Hi Rusty (or anybody else that has an idea about this),

I have a question about inventory and maybe you can help, or have any ideas about this.

This is the case: Our client has it's own bookkeeping programme, where the products and stock is being handled. I am going to get that information and insert it inside Merchello (so far no problems).

I know Merchello has it's own inventory logic, which works great, but here lies the issue for us. We need some kind of real-time inventory management, because our client can also sell over the phone for example.

so what is happening

• product in merchello with 1200 in stock
• they sell 1000 over the phone, and enter that in the bookkeeping programme
• now they can only sell 200 on the webshop side

What we thought about doing was, create a new table which holds the productid, variantid and stock, which will be updated every 15 minutes or so. When a customer goes to a single product on the detail page, we check the current merchello stock with the stock set in that table for the product. If it is different, we take the stock from that table and show it to the customer. We are not sure how to do this, or if this is the best idea. Maybe you have another idea / sample code on how to do this.

I hope i am being clear about this :)

Thanks!