×

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 = 1200
Category: 3
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

FAC #0 20

Root
virtuemart cart logoThe Famous VirtueMart Cart Logo
Base price for variant 80,00 €
Sales price 96,00 €
Sales price without tax 80,00 €
Discount
Tax amount 16,00 €
Price / kg:
Base price for variant 80,00 €
Sales price 96,00 €
Sales price without tax 80,00 €
Discount
Tax amount 16,00 €
Price / kg:
Base price for variant 80,00 €
Sales price 96,00 €
Sales price without tax 80,00 €
Discount
Tax amount 16,00 €
Price / kg:
Base price for variant 80,00 €
Sales price 96,00 €
Sales price without tax 80,00 €
Discount
Tax amount 16,00 €
Price / kg:
Base price for variant 80,00 €
Sales price 96,00 €
Sales price without tax 80,00 €
Discount
Tax amount 16,00 €
Price / kg:
Base price for variant 80,00 €
Sales price 96,00 €
Sales price without tax 80,00 €
Discount
Tax amount 16,00 €
Price / kg:
Base price for variant 80,00 €
Sales price 96,00 €
Sales price without tax 80,00 €
Discount
Tax amount 16,00 €
Price / kg:
Base price for variant 80,00 €
Sales price 96,00 €
Sales price without tax 80,00 €
Discount
Tax amount 16,00 €
Price / kg:
Base price for variant 80,00 €
Sales price 96,00 €
Sales price without tax 80,00 €
Discount
Tax amount 16,00 €
Price / kg:
Base price for variant 80,00 €
Sales price 96,00 €
Sales price without tax 80,00 €
Discount
Tax amount 16,00 €
Price / kg:
Description

This product is used as a pattern for other products. It is a parent product and has multiple child products.
You can set several settings (content, customfields) for parent product. Childs of this parent will basically have the same settings as the parent automatically inherit except you overwrite the settings.

In this case product price is set in pattern.

Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua.

At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.

Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.  

thedopedispensary.com
Units in box: 1

Reviews

There are yet no reviews for this product.