TAXES IN ALL PRODUTCS

[Prinfor]

I there, i have prestashop, and i have exported all my produtcs from one store i have in oscommerce to prestashop, everything went very well but in the transicion all my products have beeing exported and now in the new one (in prestashop) all are without taxes, editing one by one will be pratical impossible because is more than 7000 products, so is there any way to edit a file or something and put all produtcs with taxes? In the BO i can put one by one only but if editing something will i be able to put TAX in all to same time? Sorry my English, and thanks very much for all help since now, regards

[Xavier de La Garanderie]

If you are familiar with phpmyadmin, you can follow theses steps after a backup of your database

1. Browse the table ps_tax. Note the id of your tax rate.
2. Browse the table ps_product. Update the column Id_tax with the id of your tax rate. You may use an SQL UPDATE request to update all the rows in the table.

Is this help?

Xavier

[Prinfor]

Ok i have enter in phpmyadmin and thas sure we can manage all files id_tax for ID4, but what do you mean with " You may use an SQL UPDATE request to update all the rows in the table" i dont see that option, thanks for your time and help very much, regards

[Xavier de La Garanderie]

First backup your ps_product table.
Click ps_product on the left panel, then on the operation tab.
On the block Copy table to (database.table): , enter ps_product_backup, check that Structure and data is selected. Then click Go.

Second update the orignial ps_product table.
To update the tax_id column with the Id 4 for every row, click on the sql tab.
Then enter in the Run SQL query/queries on database field:

update `ps_product` set `id_tax` = 4

Click Go.

Check everything works as you expect in your back office.

Xavier

[Prinfor]

Sorry really but i have check and try to find how to do your orders but i´m getting dificult to see where can i do the "backup ps_product table" then where i see this? "On the block Copy table to (database.table): , enter ps_product_backup, check that Structure and data is selected. Then click Go" the rest i have understand and see in my phpadmin, please help for the last one... i feel i´m neary to do it, thanks a lot mister, Paulo

[Xavier de La Garanderie]

On the top of phpmyadmin, on the ps_product table management menu you have a tab called Operation

Fill the form as the picture bellow


Xavier

[freeme]

First backup your ps_product table.
Click ps_product on the left panel, then on the operation tab.Xavier

Thanks for your great mini tutorials. It helped me solve the problem I was having where no tax at all was being calculated, even though I had taxes enabled, and had show with and without tax set.

For my problem was caused when I edited the UK VAT (installed with prestashop) and changed VAT to HST 13% rather than creating a new tax id and deleting the VAT, oh lazy me. After that no taxes were being calculated.

After playing with your mini tutorial I figured out I would first have to create a NEW tax in prestashop backoffice, then follow your tutorial. I changed 1 tax id first for one product, and then tried it out by adding that product to the cart. Sure enough the tax was now being calculated, and shown in the prices. The only problem now is that in Home products the price shows with taxes included first and below that is with taxes excluded. I'd prefer that the first price be the retail price (no tax added) and the second price be with taxes added. Oh well, after 3 days of trying to find what caused the problem and how to fix it I can live with reversed prices showing.

Anyway just wanted to thank you for taking the time to help the other poster so well. It sure helped me in the process.

Frieda

[Xavier de La Garanderie]

Hi Frieda

It was a pleasure to help you.

If I well understand your problem, you have set your shop to display prices, both excluded and included tax.

If you want to change the way you shop display prices, eg show first retail price and second tax added, I think you should update your theme. However you have to make it made by a specialist.

Xavier

[freeme]

I think it wouldn't be hard to make the changes myself, Xavier. I know version .23 had retail first, taxes included second, so I have an example of how it works. If I ever get around to trying I'll post here if I have success.

Thanks again,
Frieda

[Prinfor]

Thanks you very very much, i dont know the words to say to you thanks a lot, is done, thanks

Hi Frieda

It was a pleasure to help you.

If I well understand your problem, you have set your shop to display prices, both excluded and included tax.

If you want to change the way you shop display prices, eg show first retail price and second tax added, I think you should update your theme. However you have to make it made by a specialist.

Xavier