Hello GabbyTwin,
Quote Originally Posted by gabbytwin View Post
Hi,
hope someone can help me with an easy way of listing the product at their NETT price with any taxes included.
I have a lot of products to go and edit prices with if I need to work out each one minus the taxes.
Any idea will be great , did a search and couldnt find anything
I am not sure I know what you are asking. In Zen Cart you can turn on the displaying of the price with tax for the customer, administer, one or the other, both or neither.

Most people suggest opening the download from EP in a spreadsheet as it may be quicker than even a flat database (i.e., SQLite). This would make it easy to add your own column, for your own use, such as price_with_tax, and just have it calculated for you (price*tax rate).

If you think everything is being downloaded with the tax already added, and you want to remove it, then the new column would be something like price_without_tax, and you have to figure out how much to discount something to get the price before tax. The price before tax is a little more tricky as you can't just use the tax rate. An example is if I sell something for 100 units (dollars, lair, euros, yens, etc), and tax is 10%, the total is 110 units. If I just subtracted 10% from the final sale price I would be subtracting 11 units (10% of 110), leaving 99 units, a difference of 1%, or 1 unit, from the actual price before tax.

You could also alter EP's files to add a new field (column), and make sure you include the proper code in both the up-load and down-load sections. You would need to make sure you use the correct table and field in EP's database to do so, yet it most likely could be done.