VirtueMart Forum

VirtueMart 2 + 3 + 4 => Product pricing => Topic started by: Podma on April 07, 2017, 08:21:11 AM

Title: Can I disable the product price override?
Post by: Podma on April 07, 2017, 08:21:11 AM
Hello there.

So as this topic name tells you. I would like to ask there is anyway to disable all product price override? I'm asking this because recently I got a webshop what I have to manage and they told me that they disabled the prices on the webshop because there was a problem. The problem was that some of the products has price showen on the webshop with the TAX included it's the normal way, but there some products where this price was overrided and that price much cheaper than the original price. I was looking some way to solve this problem I read and searched a lot but I could not find anyone who had this similar problem. I want to disable the product price override for all products because this issue show up on random products at least I can't find any connection between the overrided products. There are atleast a thousands products and if it possible I don't want to check all produckt to see the override is disabled or not. But If there is no other way I will do in manually.

Please Help :)

Update:
Joomla: Joomla! 3.4.5 Stable
Vitruemart 3.2.1
PHP 5.6.29
Title: Re: Can I disable the product price override?
Post by: Jörgen on April 07, 2017, 09:32:14 AM
Hello

You could do this in the database. Either with CSVi or with Regular labs dB replacer, Maybe also with VM Batch edit Products.


https://www.regularlabs.com/extensions/dbreplacer (https://www.regularlabs.com/extensions/dbreplacer)
https://csvimproved.com/ (https://csvimproved.com/)
http://shop.st42.fr/en/products/vm-be-pro-batch-product-edit.htm (http://shop.st42.fr/en/products/vm-be-pro-batch-product-edit.htm)

regards

Jörgen @ Kreativ Fotografi
Title: Re: Can I disable the product price override?
Post by: jenkinhill on April 07, 2017, 12:31:14 PM
@Podma start by tellig us the versions that you are using:  https://forum.virtuemart.net/index.php?topic=79799.0

You can quickly remove all price overrides directly in the database with phpMyAdmin. Set all prices in the product_override_price column in ###_virtuemart_product_prices table to NULL.
Title: Re: Can I disable the product price override?
Post by: Podma on April 07, 2017, 13:06:53 PM
Thank you for the advice for the version numbers I forgot those things to write down. I updated my first post :) and thanks for the answers I will try these :)

Title: Re: Can I disable the product price override?
Post by: jenkinhill on April 07, 2017, 15:10:35 PM
Quote
Joomla: Joomla! 3.4.5 Stable

That version is old with known critical security issues. It should not be used on a live site.    http://forum.virtuemart.net/index.php?topic=118683.0