Jump to content

[PS 1.5.x] Quantity management in MYSQL DB


Recommended Posts

Hello everyone!
I'm building a script to update product quantities, both in single products and in combinations.

 

I've searched a lot and found a lot of posts asking this, but never found an official answer (sometimes it was about PS 1.4.x that is different, sometimes no answers at all).

 

The problem is, what "quantity" fields do I need to update in the database to update this parameter correctly? The fields are three: there is one in "ps_product" and "ps_product_attributes", while on the other side there is "ps_stock_available".

 

I noticed that in "ps_product" (product without attributes) the quantity of new product is always set to 0, while in "ps_product_attributes" the quantities are set different from zero, but they have different values than the real. For both cases, my experiments led to think that the only important field is "ps_stock_available", and the other two are just left for legacy, but I need to be sure before using it on a real shop. Thank you very much.

Link to comment
Share on other sites

×
×
  • Create New...