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='2931'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='2931'
Tex Jumper - French Terry
$89.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 15:45:58 0.000000000 2931 W18-TEX-32-XL 2018-02-28 0.00000000 0For the days when you need to keep it comfy but don’t want to sacrifice looking cute - the Tex Jumper has got your back. Not to mention the back power mesh detailing on this jumper that truly make it a subtle statement piece. Super soft organic French Terry gives a luxe look and feel, as well as keeping you cosy.
- CERTIFIED ORGANIC BAMBOO FRENCH TERRY
- MOISTURE WICKING
- POWER MESH PANELLING
- REFLECTIVE MULTI-COLOURED D+K LOGO
- SOFT RIBBED CUFFS
For the days when you need to keep it comfy but don’t want to sacrifice looking cute - the Tex Jumper has got your back. Not to mention the back power mesh detailing on this jumper that truly make it a subtle statement piece. Super soft organic French Terry gives a luxe look and feel, as well as keeping you cosy.
- CERTIFIED ORGANIC BAMBOO FRENCH TERRY
- MOISTURE WICKING
- POWER MESH PANELLING
- REFLECTIVE MULTI-COLOURED D+K LOGO
- SOFT RIBBED CUFFS
| SKU | W18-TEX-32-XL |
| 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.
