Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

  • Puck Holshuijsen 91 posts 354 karma points
    Jun 06, 2017 @ 07:52
    Puck Holshuijsen

    Product inventory question

    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 :)


  • Puck Holshuijsen 91 posts 354 karma points
    Jun 20, 2017 @ 06:28
    Puck Holshuijsen

    Maybe somebody else has any idea on this?


  • Puck Holshuijsen 91 posts 354 karma points
    Oct 10, 2017 @ 08:05
    Puck Holshuijsen

    Decided to take different approach!

Please Sign in or register to post replies

Write your reply to: