0

With Magento's new multi-source inventory system, various new tables have been introduced into the database.

inventory_source_item contains the machine name of the source, SKU, quantity, and the status.

inventory_stock_x is a table that exists for each source, containing the SKU, quantity, and if it's salable.

Why does the second table exist, when the first could store all of that information?

3

inventory_source_item

Contains inventory levels for each source. A source is a physical location (like a warehouse).

inventory_stock_x

Contains aggregated levels for each stock. A stock can consists of one or many sources.

For example, you can have 3 warehouses (sources) in GB and one stock called "Great Britain" which would sum up all your warehouses in the inventory_stock_x table.

4
  • Thanks, Olivier. I think I knew that in the back of my mind, but after trying to understand the abstracted DB tables I lost sight of the big picture.
    – Geat
    Dec 16 '19 at 19:27
  • from where I can disable inventory_source_item zero entry. Jul 28 '20 at 11:52
  • @YoYoRoshan what do you mean by "disable"? If you mean to delete, well this can be done by a simple SQL. If you mean to disable its usage by Magento, you will need to disable the "Inventory" module or write a plugin to disable its usage and overwrite it with what you want.
    – Olivier
    Jul 28 '20 at 13:30
  • @Olivier Thanks for the quick reply, I mean to remove all zero entries from inventory_source_item without SQL. Jul 28 '20 at 15:41

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.