Stock management / Quantity Levels not set due to use of combinations!

[Nathan38]

Hi,

 

Our website is a kids clothing and toys shop which sells items in various sizes and colours and ages etc.. (www.aiko-alani.com)

 

We have added our products through bulk CSV upload. I gave most items a general quantity of 1000 but due to us enabling stock management recently (we now have a few items that really are limited to 5/6 in stock) it has caused a problem with the items that make use of Combinations Tab (age, size, colour!)

 

They all have a quantity level of ZERO for each combination of that particular item!!!

 

So in mysql I did:

 

 

UPDATE `ps_product`

SET `quantity`= 9999

WHERE `quantity` <> 1000

 

This has updated all the products quantities as expected apart from the items that make use of Combinations!!

 

How do I update them please?!? Are they stored in a different table or what?!

 

Please help - Prestashop has consequently DISABLED all these items due to the stock level being Zero!!

 

Thanks

Nathan

[Nathan38]

Oh well.. guess I'm on my own on this one too!!

Any reason why no one answered my last 2 posts??

[Nathan38]

Table ps_stock_mvt doesnt have any entries in the table for my products that have combinations which have ZERO stock...!

 

Is there anyway to rectify this mess?!? Please can someone offer any help?

[rseigel]

Products with attributes are stored in the product_attribute table. There is no stock level for the main product which is why you are getting that message.

 

So the SQL would be:

 

UPDATE `ps_product_attributes`
SET `quantity`= 9999
WHERE `quantity` <> 1000

[Nathan38]

Ron

 

I really cannot thank you enough... all the products which have combinations now have a quantity of 9999 for each individual combination.

 

I am extatic..! I cant believe it was that simple...!!??!

 

I was having nightmare thoughts about having to re-upload products and re-add images/descriptions etc..

 

I got on to the ps_stock_mvt table because I manually entered a '666' quantity to a product to observe where it was inserted in the DB.

I noticed entries in this table and did not pick up on the attribute table.

 

However, no entries have been made in to the ps_stock_mvt table which DOES have entries for all the products that have combinations - im a bit worriesabout this.!?

 

Do you have any thoughts on this please???

 

many many thanks

 

Nathan!

[Nathan38]

Ron, do you fancy taking a look at my previous post about Tags?? lol .. could really appreciate some help - am in a mess lol!

[rseigel]

No idea on that one bro. Sorry.