Changing Multiple Products

[Stuellis]

Hi All

 

I'm looking for some help, is it possible to change the 'Tax' element of all products at once, or do you have to change all separately?

 

Thanks

[vekia]

hello

 

what you exactly want to change? if tax group you can do it with one simple query

 

for all products

update ps_product set id_tax_rules_group=2

 

where 2 is and ID of tax group

[Stuellis]

hello

 

what you exactly want to change? if tax group you can do it with one simple query

 

for all products

update ps_product set id_tax_rules_group=2

 

where 2 is and ID of tax group

 

I'm very very new to this, and have no idea what the above means???

[Atout]

Hi Stuellis,

What Vekia suggested is you use SQL to change directly in your DB.

Else, learn about products CSV import if don't master it.

(http://doc.prestashop.com/display/PS15/Understanding+The+Advanced+Parameters#UnderstandingTheAdvancedParameters-CSVImport)

 

Then, export your products, keep 3 columns (ID, Name and Tax), change Tax and import back specifying "Force all ID's ..."

Cheers

[vekia]

I'm very very new to this, and have no idea what the above means???

 

code that i pasted is an sql query. sql queries is a part of the mysql databases systems.

you can run this query in the database manager software. By default, many hosters allow to use database manager, usually it is PHPmyadmin, so my questions is: have you got an access to it?

[willygsd]

I used phpmysqladmin to update the product file, like this....

 

update disstore_product set id_tax_rules_group=54

where 54 is the ID of tax group 

 

I had changed some of the products manually. When I go back into these products they show my rule for tax. When I go into products that I hadn't manually updated, they still say 'No Tax' for the tax rule in the pricing tab. Looking at the product file in phpadmin, I can see they've been changed to my rule number.

 

Is there another flag that needs to be flipped for these records, to get the catalog to be able to see my tax rule is in effect?

 

update -- It looks like items with prices in them have the tax rule updated on the screen, items with no price don't. We have a lot of items in our catalog (800+), and we need to price or re-price most of them. It would be handy if the tax rule was selected correctly for these - to eliminate possible entry errors.

 

If you click save after selecting the tax rule on the screen, it displays properly - even if no price is entered. I wonder if this is a bug - though one that doesn't bother many people.

Edited October 30, 2013 by willygsd (see edit history)

[sigmaconcept]

I made the change in the sql, the update work great but it dont show in prestashop.

I dont know if it work on the new prestashop 1.6 

 

When client made a purchase, it dosent calculate any taxes, event if in the sql have being set to the right tax rule.

 

http://grab.by/yRdw

 

Thank's

[Constantino]

In case you need in bulk to change price, tax group, quantity, status, assign products to categories, it is possible in bulk with Store Manager for Prestashop. It has built-in tool for making mass changes for big amount of products. Here is the article that explains how it works - http://www.prestashopmanager.com/useful-articles/how-to/how-to-make-mass-product-changes/ Using this tool there is no need to export/import the data or use sql query.
There is 4-week free version of Store Manager for Prestashop. You can download it here - http://addons.prestashop.com/en/administration-tools-prestashop-modules/2937-store-manager-for-prestashop.html

[sigmaconcept]

I find the solution:

 

Run this script in SQL (change your tax_rules_group for your tax group)

 

UPDATE ps_product_shop SET id_tax_rules_group = 1 WHERE id_tax_rules_group = 0

 

On both table:

ps_product

ps_product_shop

 

That it...

[Inter Svetainė]

For those who are absolutely new in programing.
HOW TO UPDATE TAX RULE FOR ALL PRODUCTS

1. In prestashop admin panel go to Localisation > Tax Rules Group (module AdminTaxRulesGroup)
Look what is Tax group id that You want to use for Your eshop items.

2. Log in to PhpMyAdmin
Select database of Your prestashop.
Press EXPORT button and press OK - do the backup just in case something will go wrong...
Press on top button SQL
In SQL query paste this "UPDATE ps_product SET id_tax_rules_group = 1 WHERE id_tax_rules_group = 0" where number 1 is Your Tax Rules Group that You looke before, 0 is Your old tac rule group (by the default is 0).
After this query please press again SQL and proceed another line "UPDATE ps_product_shop SET id_tax_rules_group = 1 WHERE id_tax_rules_group = 0" which the same numbers of IDs.

That's it.

Edited January 22, 2018 by Inter Svetainė (see edit history)

[adrian.sbalsa]

On 8/17/2013 at 11:21 PM, vekia said:

hello

 

what you exactly want to change? if tax group you can do it with one simple query

 

for all products

update ps_product set id_tax_rules_group=2

 

where 2 is and ID of tax group

Where do we modify this?

Using fileziilla is ok? pretty newb am i.