Hi.

Maybe this can help others, so documenting it here (no other place found, sorry).

It may happen that this module is installed AFTER you already have many product items in the system. Of course, each item should be edited in order to set the stock as shown in the video.

However, sometimes, as in a case I am just having now, each product item is unique, so stock should be defines to the value 1 for each item. Here are 2 SQL queries to run in order to make it:

UPDATE `field_data_commerce_stock` SET `commerce_stock_value`= 1
UPDATE `field_revision_commerce_stock` SET `commerce_stock_value`= 1

Clearing the cache was needed, as well.

Amir

Comments

Abilnet’s picture

Abilnet commented

This was useful, thank you!

amir simantov’s picture

amir simantov commented

Glad to hear!

ioanmar’s picture

ioanmar commented

I'm currently using version 2 of the module but the same problem happes with version 1.:

I ran these 2 queries but I had only part of products affected. The reason is that field_data_commerce_stock & field_revision_commerce_stock tables hold only part of my products: The highest entity ID in each table is 1201 whereas the highest entity (product) ID on my website is 4488. Any guesses why these 3287 are not present in my field_data_commerce_stock & field_revision_commerce_stock tables??

guy_schneerson’s picture

guy_schneerson commented

Hi @weborion
Make sure that stock is enabled for all your product types.
If you are using version 2 and you should use the latest dev version as it has got batch processing an can handle large number of products much better.

guy_schneerson’s picture

guy_schneerson commented
Status: Active » Closed (works as designed)

closing as no real action and no more new features are added to version 1. If anyone thinks this is relevant please assign to V2 and explain what you think the solution should be.