We started filling the store and forgot to set "show prices with tax".
As a result, we have all prices and options more expensive by the VAT rate (21%).
That is, for example, we set the price to 100, and now the output is 121.
Is it possible to return everything back? Maybe there is a module, or is it possible through a query in the DB, etc.?
Thanks in advance.
Something like that:
where oc_ is your table prefix !
Code: Select all
UPDATE `oc_product` SET `price` = (price / 121) * 100Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.
Sorry, but who are you?
The "admin" of this site - then you should know how to work with phpMyAdmin, you have set up also the database - or not?
If not, ask the admin.
And if, learn yow to use such tools.
Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.
Clearly it's simpler to have:
Code: Select all
`price` = price / 1.21UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Legendary Member
The simpliest solution would be to store the correct price .. 
Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.
If you don't know how to run an SQL command you could export all your products, use a spreadsheet formula to change them, and then import them:
https://www.opencart.com/index.php?rout ... sion_id=17
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Legendary Member
Who is online
Users browsing this forum: lockiedownunder and 16 guests
