Jump to content
Hugol

(Solucionado) Taxing All Products

Recommended Posts

good morning, I'm with a problem I would like to solve in a practical way.

I have about 2300 products already imported into my store, but the amount without taxes, so now I have to add the tax to be reviewed one by one.

One solution I did was with a SQL query ps_product changing table id_tax_rules_group field with the id of the tax rule I want.

changed query all data at the base and now I see them as if they really had the tax in the table. but when I go to the store do not apply. I see from the back office to the product and it has no taxes.

 

I do not really changing all the products one by one.

 

any advice? please?

Edited by Hugol (see edit history)

Share this post


Link to post
Share on other sites

Hello,

 

You also need to run this query:

 

 

UPDATE ps_product_shop SET id_tax_rules_group='1';

 

/!\ Do not forget to make a backup of your DB before doing the query in case anything goes wrong.

 

Have fun ;)

 

 

Hope this helps.

 

Cheers!

 

 

PS: Note that I assumed your taxe rule was ID 1, change that by your real tax rule ID ;)

Edited by Muad'Dib (see edit history)

Share this post


Link to post
Share on other sites

I did that. with the corresponding tax id I want to use.

but no changes in the store

 

also thank you very much Muad'Dib

Edited by Hugol (see edit history)

Share this post


Link to post
Share on other sites

My pleasure ;)

 

Strange. I did that on mine yesterday just after having the same issue after importing a .csv and it worked just fine... All my products were changed to the proper tax rule.

 

Is the tax rule set when you open the products for edition?

Share this post


Link to post
Share on other sites

yes, they were all off, id = 1

I edited the first to make sure the id, and work, and did well then when I made the SQL query from phpmyadmin with id = 53 group also tax rules changed in the base, but there is no change in the store, I have to do one to one ....

PD: version 1.5.2

Share this post


Link to post
Share on other sites

Only difference with me is I ran the MYSQL query directy on the DB using the mysql I do not use phpmyadmin. But it worked for me. I see no reason why it should not work for you... Strange thing.

 

I am also on ps1.5.2.

Share this post


Link to post
Share on other sites

Ready Muad'Dib!

I made ​​changes to my store all products now have taxes charged. but I also had to modify another table of: ps_product_shop

 

cosulta and stay well:

Update 'ps_product_shop' Set 'id_tax_rules_group' = x

 

I'm really happy!

Solved issue ;)

 

I appreciate your feedback

Edited by Hugol (see edit history)

Share this post


Link to post
Share on other sites

And the table ps_product ?

 

 

both tables modified to give me a result.

I hope it will be helpful as I could not find help in other post

Share this post


Link to post
Share on other sites

You happen to know what they're those two tables, they seem almost the same.

Share this post


Link to post
Share on other sites

You happen to know what they're those two tables, they seem almost the same.

 

 

These are the queries I made:

 

Set 'ps_product' Update 'id_tax_rules_group' = 32
Set 'ps_product_shop' Update 'id_tax_rules_group' = 32

 

 

But Totti read what they were doing with Muad'Dib I modified ps_product table first, and then nothing happened Muad'Dib told me to modify the other table, (ps_product_shop), and I did. and now works perfect.

Try first modify the table: ps_product_shop, to see if it actually makes it to the first

hopefully you can make your changes.

luck!

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More