×

Notice

Query: SELECT * FROM #__virtuemart_cdp WHERE ((end = "0000-00-00 00:00:00") OR (NOW() BETWEEN start AND end)) AND state = 1
Master: 162
Mastercategories:
Query getCategoriesByProductID: SELECT virtuemart_category_id FROM #__virtuemart_product_categories WHERE virtuemart_product_id = 300
Category: 11
Mastercategory:
Mastercategories: 4
Mastercategory: 4
Master: 154,155,170,204,300,1200
Mastercategories: 7
Mastercategory: 7
Query: SELECT * FROM #__virtuemart_cdp WHERE id = 3
Query: SELECT p.virtuemart_product_id FROM #__virtuemart_product_categories AS p LEFT JOIN #__virtuemart_products AS ps ON ps.`virtuemart_product_id`= p.`virtuemart_product_id` WHERE ps.published = 1 AND virtuemart_category_id = 8
Products: ["205","207","206","154","155","156","157"]
Calling reorder by SKU:
Reorder by query: SELECT virtuemart_product_id FROM #__virtuemart_products_en_gb WHERE virtuemart_product_id IN (205,207,206,154,155,156,157) ORDER BY product_name ASC
Query for discount by rule: SELECT discount FROM #__virtuemart_cdp WHERE id = 3
Query for discount type by rule: SELECT discount_type FROM #__virtuemart_cdp WHERE id = 3
Query: SELECT p.`product_name`,ps.`product_sku`,m.`virtuemart_media_id`,mu.`file_url` FROM `#__virtuemart_products_en_gb` AS p LEFT JOIN #__virtuemart_products AS ps ON ps.`virtuemart_product_id`= p.`virtuemart_product_id` LEFT JOIN #__virtuemart_product_medias AS m ON m.`virtuemart_product_id`= p.`virtuemart_product_id` LEFT JOIN #__virtuemart_medias AS mu ON mu.`virtuemart_media_id`= m.`virtuemart_media_id` WHERE p.virtuemart_product_id ='156' AND ps.published = 1 LIMIT 1

Multi Variant

Depended Multivariants
virtuemart warp5Warp5 T-Shirts
Base price for variant 8,00 €
Sales price 9,60 €
Sales price without tax 8,00 €
Discount
Tax amount 1,60 €
Price / kg:
Base price for variant 8,20 €
Sales price 9,84 €
Sales price without tax 8,20 €
Discount
Tax amount 1,64 €
Price / kg:
Base price for variant 8,50 €
Sales price 10,20 €
Sales price without tax 8,50 €
Discount
Tax amount 1,70 €
Price / kg:
Base price for variant 8,70 €
Sales price 10,44 €
Sales price without tax 8,70 €
Discount
Tax amount 1,74 €
Price / kg:
Base price for variant 9,90 €
Sales price 11,88 €
Sales price without tax 9,90 €
Discount
Tax amount 1,98 €
Price / kg:
Base price for variant 10,00 €
Sales price 12,00 €
Sales price without tax 10,00 €
Discount
Tax amount 2,00 €
Price / kg:
Base price for variant 10,30 €
Sales price 12,36 €
Sales price without tax 10,30 €
Discount
Tax amount 2,06 €
Price / kg:
Base price for variant 10,50 €
Sales price 12,60 €
Sales price without tax 10,50 €
Discount
Tax amount 2,10 €
Price / kg:
Base price for variant 10,80 €
Sales price 12,96 €
Sales price without tax 10,80 €
Discount
Tax amount 2,16 €
Price / kg:
Base price for variant 12,00 €
Sales price 14,40 €
Sales price without tax 12,00 €
Discount
Tax amount 2,40 €
Price / kg:
Base price for variant 12,40 €
Sales price 14,88 €
Sales price without tax 12,40 €
Discount
Tax amount 2,48 €
Price / kg:
Base price for variant 12,70 €
Sales price 15,24 €
Sales price without tax 12,70 €
Discount
Tax amount 2,54 €
Price / kg:
Base price for variant 12,90 €
Sales price 15,48 €
Sales price without tax 12,90 €
Discount
Tax amount 2,58 €
Price / kg:
Base price for variant 13,50 €
Sales price 16,20 €
Sales price without tax 13,50 €
Discount
Tax amount 2,70 €
Price / kg:
Base price for variant 14,50 €
Sales price 17,40 €
Sales price without tax 14,50 €
Discount
Tax amount 2,90 €
Price / kg:
Choose a variant
Description The new Multi variant feature lets manage you 100s of product variants in the parent. The product content is replaced by the selected product
Units in box: 1

Reviews

There are yet no reviews for this product.