I'd like to be able to change the prices of all our products in one go via the Host>SQL control panel.
I understand it is possible but I'm not familiar with the code. We would like to swap our Catalook Store settings from incl tax to excl tax but will then need the correct function to input into the SQL form. Currently we have UK VAT added which is 20% and we need to remove it.
The equation as I would do it on a calculator is:
new unit price = old unit price / 1.2
I found the following text on the Catalook release notes which seems to answer my question, but can anybody explain how it works or help me please? What do I need to enter in replacement of "databaseOwner" ? and what needs to replace "XX" ? 20 or 0.2.
Either way the maths doesn't make sense to me.
5.9.6: CATALooK.netStore -> Store Settings -> Price Type. If ‘tax incl.’ display is selected, prices of the products and fixed prices in product price rules must be entered now without tax!
5.9.8: CATALooK.netStore -> Store Settings -> Price Type. If ‘tax incl.’ display is selected, fixed surcharges from option selections and combinations of options and selections, fixed prices in cart price rule formulas and shipping charges from custom shipping rates must be entered now without tax!
To bulk update previously entered prices with tax included, you could execute the following script via Host -> SQL (‘Run As Script’ must be turned off)
Set unitcost = unitcost / (1+XX/100)
(Replace XX by the tax percentage amount)
After that: CATALooK.netStore -> Store Settings -> click on the ‚Clear Cache’ link
I don't won't to make a mistake and backtrack is possible. Has anybody here had any experience of using the Host>SQL function?
Many thanks for your help.