SELECT DISTINCT (SELECT c.id_parent FROM `prstshp_category_product` cp LEFT JOIN `prstshp_category` c ON cp.id_category=c.id_category WHERE cp.id_product=p.`id_product` AND c.id_parent IN(12,13,77) ) AS id_category_basic, (SELECT name FROM `prstshp_category_lang` WHERE id_category=id_category_basic AND id_lang=7 ) AS category_name, (SELECT DISTINCT cl.name FROM `prstshp_category_product` cp LEFT JOIN `prstshp_category` c ON cp.id_category=c.id_category LEFT JOIN `prstshp_category_lang` cl ON cp.id_category=cl.id_category WHERE cp.id_product=p.`id_product` AND c.id_parent=id_category_basic AND cl.id_lang=7 ) AS subcategory_name, (SELECT id_image FROM `prstshp_image` WHERE id_product=p.`id_product` ORDER BY position ASC LIMIT 1) AS first_image, sp.reduction AS p_reduction, sp.reduction_type AS p_reduction_type, p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2023-02-09 00:00:00", INTERVAL 999 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `prstshp_category_product` cp LEFT JOIN `prstshp_product` p ON p.`id_product` = cp.`id_product` INNER JOIN prstshp_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `prstshp_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN prstshp_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `prstshp_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 7 AND cl.id_shop = 1 ) LEFT JOIN `prstshp_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 7 AND pl.id_shop = 1 ) LEFT JOIN `prstshp_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `prstshp_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 7) LEFT JOIN `prstshp_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `prstshp_specific_price` sp ON p.`id_product` = sp.`id_product` WHERE product_shop.`id_shop` = 1 AND cp.id_category = 15 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC LIMIT 0,100黑色经典夹克 - Montagut

MONTAGUT

黑色经典夹克

¥3,190.00

+ 159 会员积分

:  
大小
数量

商品描述 发货与退货

这款经典夹克是MONTAGUT FW17系列的最新款式。 这款夹克采用高档棉质纤维制成,修身剪裁,平领设计,款式简洁。

    1. 条款以及派送情况
  • 发货的费用包括处理费,打包费用以及运输费用。处理费是固定的,而运输费就会根据货品的总重量的不同而变动。我们建议您将喜欢的货品下在一张单上,我们是不会把两张单独的订单整合到一起的,运费也是分两单收取。
  • 包裹的风险由客户承担,但我们会采取妥善的措施来保护你订购的商品。
  • 在您签收包裹前,请先撕掉外包装,确保纸盒是否是用梦特娇专用胶纸,且用梦特娇专用的黑色小贴纸封口(贴纸必须是完好无缺的)。
    2. 退货
  • 自订单确认后10天内可因质量问题退货。
  • 自订单确认后18天内可因质量问题换货。
  • 退货时,请确保所有的挂牌、产品包装都是齐备的。付费由客户承担。
  • 具体退货货政策请参阅合同条款或联系客服人员。

更多细节

你也可能喜欢