Author Topic: Can I disable the product price override?  (Read 488 times)

Podma

  • Beginner
  • *
  • Posts: 2
  • VirtueMart Version: Vitruemart 3.2.1
Can I disable the product price override?
« 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
Joomla! 3.4.5 Stable
Vitruemart 3.2.1
PHP 5.6.29

Jörgen

  • Global Moderator
  • Full Member
  • *
  • Posts: 1022
    • Kreativ Fotografi
  • VirtueMart Version: 3.0.19.9
Re: Can I disable the product price override?
« Reply #1 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://csvimproved.com/
http://shop.st42.fr/en/products/vm-be-pro-batch-product-edit.htm

regards

Jörgen @ Kreativ Fotografi
Joomla 3.6.5
Virtuemart 3.0.19.9
Olympiantheme Hera (customized)

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 26209
  • Always on vacation
    • Jenkin Hill Internet
Re: Can I disable the product price override?
« Reply #2 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.
Kelvyn

Jenkin Hill Internet,
Keswick, Lake District

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VM3.2.4 on Joomla 3.8 PHP 7.0.23

Testing VM3.2.5 on J!3.8

Podma

  • Beginner
  • *
  • Posts: 2
  • VirtueMart Version: Vitruemart 3.2.1
Re: Can I disable the product price override?
« Reply #3 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 :)

Joomla! 3.4.5 Stable
Vitruemart 3.2.1
PHP 5.6.29

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 26209
  • Always on vacation
    • Jenkin Hill Internet
Re: Can I disable the product price override?
« Reply #4 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
Kelvyn

Jenkin Hill Internet,
Keswick, Lake District

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VM3.2.4 on Joomla 3.8 PHP 7.0.23

Testing VM3.2.5 on J!3.8