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='2571'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='2571'
Air Hoodie - Grey
$79.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 2571 W18-AIR-48-M 2018-02-28 0.00000000 0Add a breath of fresh air to your active wardrobe with this lightweight and ultra comfortable hoodie! Take it out on your morning runs or pull over your activewear pre and post workout for a stylish cover up. We’ve also included thumbholes and drawcords for the hood and waist so you can find the ultimate comfortable fit - how nice are we?!
- ACTIVE FABRIC
- MOISTURE WICKING
- ULTRA LIGHTWEIGHT
- LARGE D+K LOGO DETAIL
- THUMBHOLES
- CONTRAST STITCH DETAILING
- DRAWCORD AT NECK AND WAIST
Add a breath of fresh air to your active wardrobe with this lightweight and ultra comfortable hoodie! Take it out on your morning runs or pull over your activewear pre and post workout for a stylish cover up. We’ve also included thumbholes and drawcords for the hood and waist so you can find the ultimate comfortable fit - how nice are we?!
- ACTIVE FABRIC
- MOISTURE WICKING
- ULTRA LIGHTWEIGHT
- LARGE D+K LOGO DETAIL
- THUMBHOLES
- CONTRAST STITCH DETAILING
- DRAWCORD AT NECK AND WAIST
| SKU | W18-AIR-48-M |
| 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.
