Quantity Update

[Rainbow Trade]

Hi,

 

I was wondering if there is a way in which I can do a mass update of all of the products quantities using php my admin rather than having to manually update the quantities through prestashop backend. Which table/tables would need to be changed? I've tried setting the quantity in ps_product to 100 for all products but this is not appearing on the backend.

 

Also which table do I need to update in order for the different combination prices for a product to be updated through phpmyadmin instead of Back Office.

 

eg: 100 x 100mm - needs to be £1.50

200 x 200mm - needs to be £2.50

 

Thanks

Jon

[vekia]

what ps version you use? everything depends on it

[Rainbow Trade]

Hi Mate The Prestashop version I am using is 1.5.4.1

[vekia]

so, if you want update quantity of products, check ps_stock_quantity.

for example, sql query below will change quantity to 100 for each product:

 

UPDATE ps_stock_available set quantity = '100'

[Rainbow Trade]

Thanks mate, do you know how to do the price combinations at all? If there is an easy way of doing this it will save me hours of manually doing the product combinations individually.

[RogueWaveLimited]

If this is something that you do regularly, I have a service that can do a (daily, weekly etc) price/quantity update for you from your data or your supplier's data for a small monthly fee.

[uriii007]

so, if you want update quantity of products, check ps_stock_quantity.

for example, sql query below will change quantity to 100 for each product:

 

UPDATE ps_stock_available set quantity = '100'

salut

te rog explica-mi si mie cum fac update stoc la toate produsele

merci

[vekia]

salut

te rog explica-mi si mie cum fac update stoc la toate produsele

merci

 

?

[maio]

@vekia:

 

it would have had more sense to make a product_stock table for product-quantities...

[glozinski]

tried to update minimal product in ps_products table UPDATE UPDATE "minimal_quantity" set quantity = '1' and did not work?  thank you in advance.

[RogueWaveLimited]

You should try this:

 

UPDATE ps_products set minimal_quantity = '1'