The Magento database contains the table
cataloginventory_stock with a single entry in there called 'Default'. I know this is the place to start for handling multiple stock locations.
I'm wondering if any of you have had experience in this and what the pitfalls are.
I'm looking to:
- Be able to track product stock across various physical locations (shops/warehouses/etc)
- Be able to identify where a product's stock is to be picked from for each customer order
If anyone could provide a link to an article or tutorial on this or just share their experience going down this path that would be great. Whether you've developed it yourself or have used a third party module, I'd love to hear from you.
Edit: I ended up writing my own multi-inventory module that adds extra rows to the existing
cataloginventory_stock table. It required overriding a few observers and models that check the stock location. In many places the stock ID of 1 was hard coded into the core.
In another project I have used Demac's multi inventory location module. While it's not perfect, it worked out of the box and is written well. I was able to easily extend and customise it for my needs.