SELECT bundle_SKU AS bundle_sku, assemble AS assemble_qty, max_assemble AS max_assemble_qty, min_assemble AS min_assemble_qty, itm_price AS breakdown_price FROM INVENTORY_BUNDLES WHERE bundle_SKU=? ORDER BY sequence,bundle_sku
thumb_list sql (item)
thumb_list total_sql
thumb_list sql (item)
SELECT DISTINCT I.*,
I.SKU, I.inventory_id, (I.store_quantity+I.build_quantity) AS store_quantity,I.preorder_quantity, I.allow_oversell, I.acc_code,
I.model, I.brand, I.retail, G.promo_price,I.start_date, I.tax_inc,
I.notax, I.unit, I.base_unit, I.base_unit_qty, I.promo_start, I.promo_end,
(I.promo_start <= NOW() AND I.promo_end >= NOW() AND G.promo_price < COALESCE(G.store_price, I.store_price) AND G.promo_price > 0) AS inpromo,
COALESCE(G.store_price, I.store_price) AS store_price,
(I.start_date > CURRENT_DATE) AS preorder,
I.start_date AS arrival_date,
I.misc1 AS features,
I.misc2 AS specifications,
I.misc3 AS warranty,
I.misc4 AS artist_author,
I.misc5 AS format,
I.misc7 AS manufacturer_model,
I.misc9 AS subtitle,
I.misc10 AS availability_description,
I.misc11 AS length,
I.misc12 AS width,
I.misc13 AS height,
I.actual_length,
I.actual_width,
I.actual_height,
I.misc14 AS barcode,
I.misc15 AS product_type,
I.itm_subtype AS product_subtype,
I.misc17 AS print_label,
I.misc18 AS `ref`,
I.misc21 AS internal_note,
I.misc22 AS barcode_height,
I.misc23 AS barcode1,
I.misc24 AS barcode2,
I.misc25 AS barcode3,
I.misc26 AS cogs_account,
I.misc27 AS income_account,
I.misc28 AS asset_account,
I.misc29 AS supplier_code,
I.misc30 AS split_for_picking,
I.misc31 AS ebay_description,
I.misc34 AS primary_suppliers_id,
I.misc38 AS cubic,
I.shipping AS weight,
I.`misc6` AS misc1,I.`misc16` AS misc2,I.`misc19` AS misc3,IF(I.`misc20`='y','y','n') AS misc4,IF(I.`misc32`='y','y','n') AS misc5,I.`misc33` AS misc6,IF(I.`misc35`='y','y','n') AS misc7,IF(I.`misc36`='y','y','n') AS misc8,I.`misc37` AS misc9,I.`misc39` AS misc10,I.`misc40` AS misc11,I.`misc41` AS misc12,I.`misc42` AS misc13,IF(I.`filter1`='y','y','n') AS misc14,I.`filter1`,I.`filter2` AS misc15,I.`filter2`,I.`misc44` AS misc16,I.`filter3` AS misc17,I.`filter3`,I.`filter4` AS misc18,I.`filter4`,'' AS misc19,IF(I.`misc47`='y','y','n') AS misc20,'' AS misc21,'' AS misc22,'' AS misc23,'' AS misc24,'' AS misc25,'' AS misc26,'' AS misc27,'' AS misc28,'' AS misc29,'' AS misc30,'' AS misc31,'' AS misc32,'' AS misc33,'' AS misc34,'' AS misc35,'' AS misc36,'' AS misc37,'' AS misc38,'' AS misc39,'' AS misc40,'' AS misc41,'' AS misc42,'' AS misc43,'' AS misc44,'' AS misc45,'' AS misc46,'' AS misc47,'' AS misc48,I.`filter5`,'' AS misc49,I.`filter6`,'' AS misc50,I.`filter7`,'' AS misc51,I.`filter8`,'' AS misc52,I.`filter9`,
I.swatch, I.extra, I.service_only,
I.coupons, I.free_gifts,
I.short_description,
I.rental_only,
I.sh_type_id,
I.itm_gp_id,
I.display_template,
I.editable_bundle, I.has_components AS is_kit, (I.has_components AND I.editable_bundle='y') AS has_components,
I.date_created AS created_at,
DATE(I.date_created) AS date_created,
I.itm_sortorder,
I.itm_sortorder2
FROM
INVENTORY I
LEFT JOIN INVENTORY_PRICES G ON (I.inventory_id=G.inventory_id AND G.group_id='1')
WHERE 1
AND I.visible = 'Y'
AND I.approval = 'y'
AND (I.gp_restriction=0 OR I.gp_restriction & '1')
AND I.inventory_id='2691'thumb_list total_sql
SELECT DISTINCT I.*,
I.SKU, I.inventory_id, (I.store_quantity+I.build_quantity) AS store_quantity,I.preorder_quantity, I.allow_oversell, I.acc_code,
I.model, I.brand, I.retail, G.promo_price,I.start_date, I.tax_inc,
I.notax, I.unit, I.base_unit, I.base_unit_qty, I.promo_start, I.promo_end,
(I.promo_start <= NOW() AND I.promo_end >= NOW() AND G.promo_price < COALESCE(G.store_price, I.store_price) AND G.promo_price > 0) AS inpromo,
COALESCE(G.store_price, I.store_price) AS store_price,
(I.start_date > CURRENT_DATE) AS preorder,
I.start_date AS arrival_date,
I.misc1 AS features,
I.misc2 AS specifications,
I.misc3 AS warranty,
I.misc4 AS artist_author,
I.misc5 AS format,
I.misc7 AS manufacturer_model,
I.misc9 AS subtitle,
I.misc10 AS availability_description,
I.misc11 AS length,
I.misc12 AS width,
I.misc13 AS height,
I.actual_length,
I.actual_width,
I.actual_height,
I.misc14 AS barcode,
I.misc15 AS product_type,
I.itm_subtype AS product_subtype,
I.misc17 AS print_label,
I.misc18 AS `ref`,
I.misc21 AS internal_note,
I.misc22 AS barcode_height,
I.misc23 AS barcode1,
I.misc24 AS barcode2,
I.misc25 AS barcode3,
I.misc26 AS cogs_account,
I.misc27 AS income_account,
I.misc28 AS asset_account,
I.misc29 AS supplier_code,
I.misc30 AS split_for_picking,
I.misc31 AS ebay_description,
I.misc34 AS primary_suppliers_id,
I.misc38 AS cubic,
I.shipping AS weight,
I.`misc6` AS misc1,I.`misc16` AS misc2,I.`misc19` AS misc3,IF(I.`misc20`='y','y','n') AS misc4,IF(I.`misc32`='y','y','n') AS misc5,I.`misc33` AS misc6,IF(I.`misc35`='y','y','n') AS misc7,IF(I.`misc36`='y','y','n') AS misc8,I.`misc37` AS misc9,I.`misc39` AS misc10,I.`misc40` AS misc11,I.`misc41` AS misc12,I.`misc42` AS misc13,IF(I.`filter1`='y','y','n') AS misc14,I.`filter1`,I.`filter2` AS misc15,I.`filter2`,I.`misc44` AS misc16,I.`filter3` AS misc17,I.`filter3`,I.`filter4` AS misc18,I.`filter4`,'' AS misc19,IF(I.`misc47`='y','y','n') AS misc20,'' AS misc21,'' AS misc22,'' AS misc23,'' AS misc24,'' AS misc25,'' AS misc26,'' AS misc27,'' AS misc28,'' AS misc29,'' AS misc30,'' AS misc31,'' AS misc32,'' AS misc33,'' AS misc34,'' AS misc35,'' AS misc36,'' AS misc37,'' AS misc38,'' AS misc39,'' AS misc40,'' AS misc41,'' AS misc42,'' AS misc43,'' AS misc44,'' AS misc45,'' AS misc46,'' AS misc47,'' AS misc48,I.`filter5`,'' AS misc49,I.`filter6`,'' AS misc50,I.`filter7`,'' AS misc51,I.`filter8`,'' AS misc52,I.`filter9`,
I.swatch, I.extra, I.service_only,
I.coupons, I.free_gifts,
I.short_description,
I.rental_only,
I.sh_type_id,
I.itm_gp_id,
I.display_template,
I.editable_bundle, I.has_components AS is_kit, (I.has_components AND I.editable_bundle='y') AS has_components,
I.date_created AS created_at,
DATE(I.date_created) AS date_created,
I.itm_sortorder,
I.itm_sortorder2
FROM
INVENTORY I
LEFT JOIN INVENTORY_PRICES G ON (I.inventory_id=G.inventory_id AND G.group_id='1')
WHERE 1
AND I.visible = 'Y'
AND I.approval = 'y'
AND (I.gp_restriction=0 OR I.gp_restriction & '1')
AND I.inventory_id='2691'
Jetset Windbreaker - Black
$99.95
Sold Out
[@acc_code@] [@acc_qty_multiplier@] [@active@] [@actual_height@] [@actual_length@] [@actual_width@] [@allow_oversell@] [@approval@] [@approval_mobile@] [@approval_pos@] [@arrival_date@] [@artist_author@] [@asset_account@] [@auto_url_update@] [@availability_description@] [@available_preorder_quantity@] [@avg_cost_price@] [@barcode@] [@barcode1@] [@barcode2@] [@barcode3@] [@barcode_height@] [@base_unit@] [@base_unit_qty@] [@brand@] [@brochure_url@] [@build_quantity@] [@buy_qty@] [@cogs_account@] [@committed_quantity@] [@cost@] [@count@] [@coupons@] [@created_at@] [@cubic@] [@current_id@] [@current_sku@] [@custom_label@] [@date_created@] [@default_purchase_price@] [@default_restock_quantity@] [@description@] [@display_template@] [@dropshipper@] [@ebay_description@] [@ebay_product_detail@] [@ebay_quantity@] [@editable_bundle@] [@expense_acc@] [@extra@] [@featured@] [@features@] [@filter1@] [@filter1_name@] [@filter2@] [@filter3@] [@filter4@] [@filter5@] [@filter6@] [@filter7@] [@filter8@] [@filter9@] [@format@] [@free_gifts@] [@gp_restriction@] [@group_name@] [@handling_time@] [@has_child@] [@has_components@] [@has_from_price@] [@has_mlp@] [@has_variants@] [@height@] [@hs_tariff_number@] [@image_url@] [@image_url_check_days@] [@imgupd_date@] [@in_display_page@] [@in_transit_quantity@] [@income_account@] [@incoming_quantity@] [@inpromo@] [@instock@] [@internal_note@] [@inventory_id@] [@is_au_gst_exempted@] [@is_bought@] [@is_inventoried@] [@is_kit@] [@is_neto_utility@] [@is_nz_gst_exempted@] [@is_sold@] [@itm_gp_id@] [@itm_sortorder@] [@itm_sortorder2@] [@itm_subtype@] [@job_id@] [@keywords@] [@length@] [@limited_stock@] [@manufacturer_model@] [@max_qty@] [@min_qty@] [@misc1@] [@misc10@] [@misc11@] [@misc12@] [@misc13@] [@misc13_name@] [@misc14@] [@misc14_name@] [@misc15@] [@misc16@] [@misc17@] [@misc18@] [@misc19@] [@misc1_name@] [@misc2@] [@misc20@] [@misc20_name@] [@misc21@] [@misc22@] [@misc23@] [@misc24@] [@misc25@] [@misc26@] [@misc27@] [@misc28@] [@misc29@] [@misc2_name@] [@misc3@] [@misc30@] [@misc31@] [@misc32@] [@misc33@] [@misc34@] [@misc35@] [@misc36@] [@misc37@] [@misc38@] [@misc39@] [@misc3_name@] [@misc4@] [@misc40@] [@misc41@] [@misc42@] [@misc43@] [@misc44@] [@misc45@] [@misc46@] [@misc47@] [@misc48@] [@misc49@] [@misc4_name@] [@misc5@] [@misc50@] [@misc51@] [@misc52@] [@misc53@] [@misc54@] [@misc55@] [@misc56@] [@misc57@] [@misc58@] [@misc59@] [@misc5_name@] [@misc6@] [@misc60@] [@misc61@] [@misc62@] [@misc63@] [@misc64@] [@misc65@] [@misc66@] [@misc67@] [@misc68@] [@misc69@] [@misc6_name@] [@misc7@] [@misc70@] [@misc71@] [@misc72@] [@misc73@] [@misc74@] [@misc7_name@] [@misc8@] [@misc8_name@] [@misc9@] [@mlp_price@] [@model@] [@monthly_spent@] [@multiplier_qty@] [@multiplier_qty_start@] [@name@] [@no_shipping@] [@notax@] [@origin_country@] [@parent_inventory_id@] [@parent_sku@] [@pick_priority@] [@pick_scan_qty@] [@pick_zone@] [@preorder@] [@preorder_date@] [@preorder_quantity@] [@price@] [@primary_suppliers_id@] [@primary_warehouse_id@] [@print_label@] [@product_id@] [@product_subtype@] [@product_type@] [@product_url@] [@promo_end@] [@promo_id@] [@promo_price@] [@promo_save@] [@promo_start@] [@purchase_taxcode@] [@quantity_sold@] [@rating@] [@rating_decimal@] [@rating_round_half@] [@ref@] [@regen_url@] [@rental_only@] [@reorder_quantity@] [@repeat_type@] [@req_pack@] [@restock_quantity@] [@restock_warning_level@] [@retail@] [@reviews@] [@rndm@] [@sales_commission_percent@] [@save@] [@save_price@] [@sell_qty@] [@serial_tracking@] [@service_level@] [@service_only@] [@sh_type_id@] [@shipping@] [@short_description@] [@single_price@] [@sku@] [@specifications@] [@split_for_picking@] [@start_date@] [@status@] [@stock_managed@] [@stockpriceupd_date@] [@store_price@] [@store_quantity@] [@subtitle@] [@supplier@] [@supplier_code@] [@supplier_product_name@] [@swatch@] [@tax_category@] [@tax_inc@] [@thumb@](CODE) [@thumb_1@](CODE) [@thumb_10@](CODE) [@thumb_2@](CODE) [@thumb_3@](CODE) [@thumb_4@](CODE) [@thumb_5@](CODE) [@thumb_6@](CODE) [@thumb_7@](CODE) [@thumb_8@](CODE) [@thumb_9@](CODE) [@timestamp@] [@tnc@] [@type@] [@unit@] [@update_bundle_price@] [@url@](CODE) [@variants_updated_at@] [@visible@] [@warranty@] [@weight@] [@width@] [@^acc_code@] [@^acc_qty_multiplier@] [@^active@] [@^actual_height@] [@^actual_length@] [@^actual_width@] [@^alias_description@] [@^alias_sku@] [@^allow_oversell@] [@^approval@] [@^approval_mobile@] [@^approval_pos@] [@^arrival_date@] [@^artist_author@] [@^asset_account@] [@^auto_url_update@] [@^availability_description@] [@^available_preorder_quantity@] [@^avg_cost_price@] [@^barcode@] [@^barcode1@] [@^barcode2@] [@^barcode3@] [@^barcode_height@] [@^base_unit@] [@^base_unit_qty@] [@^brand@] [@^brochure_url@] [@^build_quantity@] [@^buy_qty@] [@^cogs_account@] [@^committed_quantity@] [@^compatibility_code@] [@^compatibility_notes@] [@^content_id@] [@^cost@] [@^coupons@] [@^created_at@] [@^cubic@] [@^current_id@] [@^current_sku@] [@^custom_label@] [@^date_created@] [@^default_purchase_price@] [@^default_restock_quantity@] [@^description@] [@^display_template@] [@^dropshipper@] [@^ebay_description@] [@^ebay_product_detail@] [@^ebay_quantity@] [@^editable_bundle@] [@^expense_acc@] [@^extra@] [@^featured@] [@^features@] [@^filter1@] [@^filter1_name@] [@^filter2@] [@^filter3@] [@^filter4@] [@^filter5@] [@^filter6@] [@^filter7@] [@^filter8@] [@^filter9@] [@^format@] [@^free_gifts@] [@^gp_restriction@] [@^group_name@] [@^handling_time@] [@^has_child@] [@^has_components@] [@^has_from_price@] [@^has_mlp@] [@^has_variants@] [@^height@] [@^hs_tariff_number@] [@^id@] [@^image_url@] [@^image_url_check_days@] [@^imgupd_date@] [@^in_display_page@] [@^in_transit_quantity@] [@^income_account@] [@^incoming_quantity@] [@^inpromo@] [@^instock@] [@^internal_note@] [@^inventory_id@] [@^is_au_gst_exempted@] [@^is_bought@] [@^is_inventoried@] [@^is_kit@] [@^is_neto_utility@] [@^is_nz_gst_exempted@] [@^is_sold@] [@^itm_gp_id@] [@^itm_sortorder@] [@^itm_sortorder2@] [@^itm_subtype@] [@^job_id@] [@^keywords@] [@^length@] [@^limited_stock@] [@^manufacturer_model@] [@^max_qty@] [@^min_qty@] [@^misc1@] [@^misc10@] [@^misc11@] [@^misc12@] [@^misc13@] [@^misc13_name@] [@^misc14@] [@^misc14_name@] [@^misc15@] [@^misc16@] [@^misc17@] [@^misc18@] [@^misc19@] [@^misc1_name@] [@^misc2@] [@^misc20@] [@^misc20_name@] [@^misc21@] [@^misc22@] [@^misc23@] [@^misc24@] [@^misc25@] [@^misc26@] [@^misc27@] [@^misc28@] [@^misc29@] [@^misc2_name@] [@^misc3@] [@^misc30@] [@^misc31@] [@^misc32@] [@^misc33@] [@^misc34@] [@^misc35@] [@^misc36@] [@^misc37@] [@^misc38@] [@^misc39@] [@^misc3_name@] [@^misc4@] [@^misc40@] [@^misc41@] [@^misc42@] [@^misc43@] [@^misc44@] [@^misc45@] [@^misc46@] [@^misc47@] [@^misc48@] [@^misc49@] [@^misc4_name@] [@^misc5@] [@^misc50@] [@^misc51@] [@^misc52@] [@^misc53@] [@^misc54@] [@^misc55@] [@^misc56@] [@^misc57@] [@^misc58@] [@^misc59@] [@^misc5_name@] [@^misc6@] [@^misc60@] [@^misc61@] [@^misc62@] [@^misc63@] [@^misc64@] [@^misc65@] [@^misc66@] [@^misc67@] [@^misc68@] [@^misc69@] [@^misc6_name@] [@^misc7@] [@^misc70@] [@^misc71@] [@^misc72@] [@^misc73@] [@^misc74@] [@^misc7_name@] [@^misc8@] [@^misc8_name@] [@^misc9@] [@^mlp_price@] [@^model@] [@^monthly_spent@] [@^multiplier_qty@] [@^multiplier_qty_start@] [@^name@] [@^notax@] [@^onreload@] [@^origin_country@] [@^parent_inventory_id@] [@^parent_sku@] [@^pick_priority@] [@^pick_scan_qty@] [@^pick_zone@] [@^preorder@] [@^preorder_date@] [@^preorder_quantity@] [@^preview@] [@^price@] [@^primary_suppliers_id@] [@^primary_warehouse_id@] [@^print_label@] [@^product_id@] [@^product_subtype@] [@^product_type@] [@^product_url@] [@^promo_end@] [@^promo_id@] [@^promo_price@] [@^promo_save@] [@^promo_start@] [@^purchase_taxcode@] [@^quantity_sold@] [@^rating@] [@^rating_decimal@] [@^rating_round_half@] [@^ref@] [@^regen_url@] [@^rental_only@] [@^reorder_quantity@] [@^repeat_type@] [@^req_pack@] [@^restock_quantity@] [@^restock_warning_level@] [@^retail@] [@^review_sku@] [@^reviews@] [@^rndm@] [@^sales_commission_percent@] [@^save@] [@^save_price@] [@^sell_qty@] [@^serial_tracking@] [@^service_level@] [@^service_only@] [@^sh_type_id@] [@^ship_city@] [@^ship_country@] [@^ship_pobox@] [@^ship_state@] [@^ship_zip@] [@^shipping@] [@^short_description@] [@^single_price@] [@^sku@] [@^specifications@] [@^split_for_picking@] [@^start_date@] [@^status@] [@^stock_managed@] [@^stockpriceupd_date@] [@^store_price@] [@^store_quantity@] [@^subtitle@] [@^supplier@] [@^supplier_code@] [@^supplier_product_name@] [@^swatch@] [@^tax_category@] [@^tax_inc@] [@^thumb@](CODE) [@^thumb_1@](CODE) [@^thumb_10@](CODE) [@^thumb_2@](CODE) [@^thumb_3@](CODE) [@^thumb_4@](CODE) [@^thumb_5@](CODE) [@^thumb_6@](CODE) [@^thumb_7@](CODE) [@^thumb_8@](CODE) [@^thumb_9@](CODE) [@^timestamp@] [@^tnc@] [@^type@] [@^unit@] [@^update_bundle_price@] [@^url@] [@^variants_updated_at@] [@^visible@] [@^warranty@] [@^weight@] [@^width@] [@^^acc_code@] [@^^acc_qty_multiplier@] [@^^access_control@] [@^^active@] [@^^actual_height@] [@^^actual_length@] [@^^actual_width@] [@^^allow_oversell@] [@^^approval@] [@^^approval_mobile@] [@^^approval_pos@] [@^^arrival_date@] [@^^article_id@](REF) [@^^artist_author@] [@^^asset_account@] [@^^auto_url_update@] [@^^availability_description@] [@^^available_preorder_quantity@] [@^^avg_cost_price@] [@^^barcode@] [@^^barcode1@] [@^^barcode2@] [@^^barcode3@] [@^^barcode_height@] [@^^base_unit@] [@^^base_unit_qty@] [@^^blog_author@](REF) [@^^blog_content@](REF) [@^^blog_id@](REF) [@^^blog_subheader@](REF) [@^^blog_subject@](REF) [@^^brand@] [@^^brochure_url@] [@^^build_quantity@] [@^^buy_qty@] [@^^category_id@](REF) [@^^category_name@](REF) [@^^category_ref@](REF) [@^^category_subheader@](REF) [@^^ccat_id@](REF) [@^^cogs_account@] [@^^committed_quantity@] [@^^compat_id@](REF) [@^^compat_list_id@](REF) [@^^compatcat_description@](REF) [@^^compatcat_description2@](REF) [@^^compatcat_fullname@](REF) [@^^compatcat_name@](REF) [@^^compatcat_ref@](REF) [@^^content@](REF) [@^^content_allow_reviews@] [@^^content_author@] [@^^content_compatibility_code@] [@^^content_description1@] [@^^content_description2@] [@^^content_description3@] [@^^content_external_ref1@] [@^^content_external_ref2@] [@^^content_external_ref3@] [@^^content_external_src@] [@^^content_fullpath@] [@^^content_id@] [@^^content_label1@] [@^^content_label2@] [@^^content_label3@] [@^^content_level@] [@^^content_module@] [@^^content_name@] [@^^content_ref@] [@^^content_short_description1@] [@^^content_short_description2@] [@^^content_short_description3@] [@^^content_type_code@] [@^^content_type_id@] [@^^content_type_name@] [@^^content_wufoo_form@] [@^^cost@] [@^^coupons@] [@^^created_at@] [@^^cubic@] [@^^current_id@] [@^^current_sku@] [@^^custom_label@] [@^^date_created@] [@^^date_posted@] [@^^date_updated@](REF) [@^^default_purchase_price@] [@^^default_restock_quantity@] [@^^description@] [@^^description2@](REF) [@^^display_template@] [@^^dropshipper@] [@^^ebay_description@] [@^^ebay_product_detail@] [@^^ebay_quantity@] [@^^editable_bundle@] [@^^expense_acc@] [@^^external_ref@](REF) [@^^extra@] [@^^featured@] [@^^features@] [@^^filter1@] [@^^filter1_name@] [@^^filter2@] [@^^filter3@] [@^^filter4@] [@^^filter5@] [@^^filter6@] [@^^filter7@] [@^^filter8@] [@^^filter9@] [@^^format@] [@^^free_gifts@] [@^^gp_restriction@] [@^^group_name@] [@^^handling_time@] [@^^has_child@] [@^^has_components@] [@^^has_from_price@] [@^^has_mlp@] [@^^has_variants@] [@^^height@] [@^^hs_tariff_number@] [@^^id@](REF) [@^^image_url@] [@^^image_url_check_days@] [@^^imgupd_date@] [@^^in_display_page@] [@^^in_transit_quantity@] [@^^income_account@] [@^^incoming_quantity@] [@^^inpromo@] [@^^instock@] [@^^internal_note@] [@^^inventory_id@] [@^^is_au_gst_exempted@] [@^^is_bought@] [@^^is_inventoried@] [@^^is_kit@] [@^^is_neto_utility@] [@^^is_nz_gst_exempted@] [@^^is_sold@] [@^^itm_gp_id@] [@^^itm_sortorder@] [@^^itm_sortorder2@] [@^^itm_subtype@] [@^^job_id@] [@^^keywords@] [@^^length@] [@^^limited_stock@] [@^^manufacturer_model@] [@^^max_qty@] [@^^min_qty@] [@^^misc1@] [@^^misc10@] [@^^misc11@] [@^^misc12@] [@^^misc13@] [@^^misc13_name@] [@^^misc14@] [@^^misc14_name@] [@^^misc15@] [@^^misc16@] [@^^misc17@] [@^^misc18@] [@^^misc19@] [@^^misc1_name@] [@^^misc2@] [@^^misc20@] [@^^misc20_name@] [@^^misc21@] [@^^misc22@] [@^^misc23@] [@^^misc24@] [@^^misc25@] [@^^misc26@] [@^^misc27@] [@^^misc28@] [@^^misc29@] [@^^misc2_name@] [@^^misc3@] [@^^misc30@] [@^^misc31@] [@^^misc32@] [@^^misc33@] [@^^misc34@] [@^^misc35@] [@^^misc36@] [@^^misc37@] [@^^misc38@] [@^^misc39@] [@^^misc3_name@] [@^^misc4@] [@^^misc40@] [@^^misc41@] [@^^misc42@] [@^^misc43@] [@^^misc44@] [@^^misc45@] [@^^misc46@] [@^^misc47@] [@^^misc48@] [@^^misc49@] [@^^misc4_name@] [@^^misc5@] [@^^misc50@] [@^^misc51@] [@^^misc52@] [@^^misc53@] [@^^misc54@] [@^^misc55@] [@^^misc56@] [@^^misc57@] [@^^misc58@] [@^^misc59@] [@^^misc5_name@] [@^^misc6@] [@^^misc60@] [@^^misc61@] [@^^misc62@] [@^^misc63@] [@^^misc64@] [@^^misc65@] [@^^misc66@] [@^^misc67@] [@^^misc68@] [@^^misc69@] [@^^misc6_name@] [@^^misc7@] [@^^misc70@] [@^^misc71@] [@^^misc72@] [@^^misc73@] [@^^misc74@] [@^^misc7_name@] [@^^misc8@] [@^^misc8_name@] [@^^misc9@] [@^^mlp_price@] [@^^model@] [@^^monthly_spent@] [@^^multiplier_qty@] [@^^multiplier_qty_start@] [@^^name@] [@^^notax@] [@^^origin_country@] [@^^page_content@](REF) [@^^page_editor@](REF) [@^^page_header@](REF) [@^^page_id@](REF) [@^^page_index@](REF) [@^^page_subheader@](REF) [@^^parent_ccat_id@](REF) [@^^parent_content_id@] [@^^parent_id@](REF) [@^^parent_inventory_id@] [@^^parent_sku@] [@^^pick_priority@] [@^^pick_scan_qty@] [@^^pick_zone@] [@^^preorder@] [@^^preorder_date@] [@^^preorder_quantity@] [@^^price@] [@^^primary_suppliers_id@] [@^^primary_warehouse_id@] [@^^print_label@] [@^^product_id@] [@^^product_subtype@] [@^^product_type@] [@^^product_url@] [@^^promo_end@] [@^^promo_id@] [@^^promo_price@] [@^^promo_save@] [@^^promo_start@] [@^^purchase_taxcode@] [@^^quantity_sold@] [@^^rating@] [@^^rating_decimal@] [@^^rating_round_half@] [@^^ref@] [@^^regen_url@] [@^^rental_only@] [@^^reorder_quantity@] [@^^repeat_type@] [@^^req_pack@] [@^^restock_quantity@] [@^^restock_warning_level@] [@^^retail@] [@^^reviews@] [@^^sales_commission_percent@] [@^^save@] [@^^save_price@] [@^^sell_qty@] [@^^serial_tracking@] [@^^service_level@] [@^^service_only@] [@^^sh_type_id@] [@^^shipping@] [@^^short_description@] [@^^single_price@] [@^^sku@] [@^^sortorder@] [@^^specifications@] [@^^split_for_picking@] [@^^start_date@] [@^^status@] [@^^stock_managed@] [@^^stockpriceupd_date@] [@^^store_price@] [@^^store_quantity@] [@^^subtitle@] [@^^supplier@] [@^^supplier_code@] [@^^supplier_product_name@] [@^^swatch@] [@^^tax_category@] [@^^tax_inc@] [@^^templatebody@] [@^^templatefoot@] [@^^templatehead@] [@^^templatesearch@] [@^^thumb@](CODE) [@^^thumb_1@](CODE) [@^^thumb_10@](CODE) [@^^thumb_2@](CODE) [@^^thumb_3@](CODE) [@^^thumb_4@](CODE) [@^^thumb_5@](CODE) [@^^thumb_6@](CODE) [@^^thumb_7@](CODE) [@^^thumb_8@](CODE) [@^^thumb_9@](CODE) [@^^thumb_content_type_id@] [@^^timestamp@] [@^^title@](REF) [@^^tnc@] [@^^type@] [@^^unit@] [@^^update_bundle_price@] [@^^url@](CODE) [@^^variants_updated_at@] [@^^visible@] [@^^warranty@] [@^^weight@] [@^^width@]
0.000 0 0.000 0.000 0.000 n y n y n 0 0 0 1.0000 C 0 1 0 206 0 0 2018-02-28 00:00:00 0.000000000 2691 W18-JET-02-L 2018-02-28 0.00000000 0Effortlessly add statement style to your outfit of the day without compromising on functionality! Our Jetset Windbreaker comes in three colourways so you can mix and match your active and off-duty looks with ease. This super lightweight style is perfect for layering as a lifestyle piece, or take it out on your morning run until you’ve warmed up!
- ADVANCE FABRIC
- FRONT ZIP
- FOUR WAY STRETCH
- D+K CUFF AND WAISTBAND (BLACK ONLY)
- CONTRAST SOFT RIBBED CUFF ON NECKLINE, WRIST & WAIST (D+K BLACK, BLUE OCEAN)
- RELAXED FIT
- FRONT EXTERNAL POCKETS
Effortlessly add statement style to your outfit of the day without compromising on functionality! Our Jetset Windbreaker comes in three colourways so you can mix and match your active and off-duty looks with ease. This super lightweight style is perfect for layering as a lifestyle piece, or take it out on your morning run until you’ve warmed up!
- ADVANCE FABRIC
- FRONT ZIP
- FOUR WAY STRETCH
- D+K CUFF AND WAISTBAND (BLACK ONLY)
- CONTRAST SOFT RIBBED CUFF ON NECKLINE, WRIST & WAIST (D+K BLACK, BLUE OCEAN)
- RELAXED FIT
- FRONT EXTERNAL POCKETS
| SKU | W18-JET-02-L |
| Brand | C |
| Shipping Weight | 0.1000kg |
| Shipping Width | 0.250m |
| Shipping Height | 0.020m |
| Shipping Length | 0.250m |
Be The First To Review This Product!
Help other Matte users shop smarter by writing reviews for products you have purchased.
