Need Help with Database Table ps_stock_available

[Whispar1]

This is a snippet from my ps_stock_available table

This is (1) Product that has four color combinations (attributes)

Since the base product (#N/A) can not be purchased, why is the inventory count at 12?

I also notice that when one of the combinations is out of stock, I get two emails (one for the actual combination and one for the default reference which can not be purchased anyway?

 

Also, can someone demystify me at to what id_stock_available is?

 

reference id_stock_available id_product id_product_attribute id_shop id_shop_group quantity #N/A 3385 709 0 1 0 12 46105/3 3387 709 2679 1 0 3 46115/3 3388 709 2680 1 0 3 46125/3 3389 709 2681 1 0 3 46135/3 3390 709 2682 1 0 3

 

Thanks all

[NemoPS]

that id is not in use I believe.

In any case, a product counts as in stock as long as any of its combinations is

[Whispar1]

Thanks for this. One less thing to concern myself with

I am trying to create a spreadsheet using this table and ps_stock_available to update my inventory. My unique identifier for all the products is the reference number (which does not exist in ps_stock_available) By linking these two tables in a spreadsheet, I can at least convert it to a csv to update inventory quantity but where I am stuck is how to update that in the database. I don't know sql very well but I assume there should be some sore of JOIN statement or do you have a suggestion how to achieve this.

[NemoPS]

"to achieve this": exporting joining the ref or updating later?

[Whispar1]

That is a good question Nemo and I am not sure the best way to accomplish this. The reference is the common field to all my products both with and without combinations. Ideally I need to be able to update inventory daily using the inventory spreadsheet from my suppliers.