Updating weights on products in prestashop on mass
There are occasions where you might need to update a group of products weight. Recently I had a whole bunch of products that were in correctly set as 2KG when they should have been set to 0.2KG (200 grams). I started off manually changing them and then thought..no thanks this will take all day.
Luckily mySQL is your friend!
Using this query I was able to update all products weight within a certain category from 2KG to 0.2KG.
I knew the category I wanted to update was category 3 so I ran the following query:
This query updates the weight value to 0.2 on all products which belong to category 3 that has a existing weight of 2.
UPDATE ps_product SET weight = 0.2 WHERE weight = 2 and ps_product.id_product in (SELECT ps_category_product.id_product FROM ps_category_product WHERE id_category = 3 )
Tags in Tags
Recent comments
-
Great module, needs...
-
Tx!!
-
nice
-
vimax brasil
-
Version
more
These are some of the articles that are written on hosting
Hosting is an important subject for many businesses - and choosing a good host is a mine field. Webhost, datacentre and ISP websites often look professional but behind the scenes are they geared up to deliver a quality service that todays businesses need. It seems like any one can set up a host but are they really able to deliver.
Check out our articles to help you make an informed choice when choosing your webhost.
