Umbraco Commerce - Stock Returning Zero for Product Variants Using IStockService

[njvicente82]

When using commerceApi.GetProductStock to retrieve stock for product variants, the stock always returns zero, even though stock levels are correctly set in the backoffice for each variant.

Variants have unique SKUs, and stock is properly entered in the Variants Editor.

Expected Behavior: The API should return the correct stock levels for each variant.

Actual Behavior: The API returns null or 0 for all product variants.

Request: Please advise on resolving this issue or confirm if additional configuration is required.

[mattbrailsford]

If you look in the umbracoCommerceStock table, do you see the correct stock values recorded for the variants? The product reference column is the node key for the parent product, and the product variant column should be the node key for the variant item

[davidsantosshareit]

Hi @mattbrailsford ,
In behalf of @njvicente82 :
We have that table like this:

The variant column is always NULL. We have a property with alias "stock" on the variant, and it has value.

[mattbrailsford]

So when you say you have variants setup, is this using the variants property editor? And have you set the property alias to variants? (it MUST be named this)

[davidsantosshareit]

Yes, it's like this:

[mattbrailsford]

Ok, maybe it's the fact the property varies by culture. All Umbraco Commerce properties shouldn't be varying.

[davidsantosshareit]

That made the trick!! Thank you so much :)

[mattbrailsford]

Excellent. Glad it's up an running