My salable quantity is off.

I figured out why it's off and how salable quantity is calculated.

Example proper order:

User: New order with product sku SKU-AAA x 1

System: Create a Reservation for SKU-AAA x 1...

table inventory_reservation fields reservation_id,stock_id,sku,quantity,metadata

1 1 SKU-AAA -1.0000 {"event_type":"order_placed","object_type":"order","object_id":"12345"}

After Shipped...

System: Counter the Reservation... (and cleaned by cron later on)

2 1 SKU-AAA 1.0000 {"event_type":"order_placed","object_type":"order","object_id":"12345"}

System: Finally deduct the physical quantity of the SKU-AAA.

My problem is that I have orders that are still open, and are made before the new inventory system!

I also know that I have to somehow manually create those missing reservation entries, but I was hoping that there is a built-in way of doing that...

Thanks in advance.


Maybe you had fixed this, if not check the CLI commands to check and resolve reservation inconsistencies.



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.