×

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 = 154
Category: 7
Mastercategory:
Category: 8
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

Dress Shirt with tie

Fine feathers make fine birds - time to get serious.
Generic Child Variant Tooltip
Property
virtuemart sampleVirtueMart Sample
Base price for variant 40,83 €
Sales price 49,00 €
Sales price without tax 40,83 €
Discount
Tax amount 8,17 €
Price / kg:
Base price for variant 40,83 €
Sales price 49,00 €
Sales price without tax 40,83 €
Discount
Tax amount 8,17 €
Price / kg:
Choose a variant
Description

Refresh yourself with genuine VM dress.

String, attribute Tooltip
Stiched genuine VM logo, color: black
Property
String Tooltip
Machine-washable
Property
Units in box: 1

Reviews

There are yet no reviews for this product.