×

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 = 204
Category: 2
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

Advanced PATTERN

Showcase advanced pattern usage.
virtuemart cart logoThe Famous VirtueMart Cart Logo
Base price for variant 25,00 €
Sales price 30,00 €
Sales price without tax 25,00 €
Discount
Tax amount 5,00 €
Price / kg:
Base price for variant 25,00 €
Sales price 30,00 €
Sales price without tax 25,00 €
Discount
Tax amount 5,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 inherited until you overwrite.

One of the hugest advantages is stock control ability.

String Tooltip
Customfield string 1: Child content
Property
Customfield string 2: Child content
Property
Editor Tooltip

Advanced PATTERN content
>> This customfields are assigned in parent product.

Testimonial
Units in box: 1

Reviews

There are yet no reviews for this product.