Joining quantity of the same product that comes from 2 or 3 separate suppliers data feeds? Possible?
Hi, we are an online store only that doesn't have a shop front (and no stock in a warehouse), so we drop ship our products straight from the suppliers warehouse to the customer once an order comes in.
We rely on the suppliers data feeds to update the price and quantity daily.
Can someone assist with this requirement - 3 suppliers stock the exact same product, and we are looking for a way to be able to import the suppliers daily data feeds and join the quantity of that same product across the suppliers. So if the quantity is 10, 15, 8 across the 3 suppliers, then our website will know that there is 33 units in stock.
Currently it shows 8 in stock each day as the third daily data feed updates last, and if it goes from 8 to 0 stock (and there's still 25 units at the other 2 suppliers warehouses), then the website will update to "out of stock" because there's 0 stock at that last warehouse and that data feed imports last.
Has anyone solved this?
Is there an extension for this situation that can help?
We are currently on Magento 1.9 but will be updating to Magento 2 within 12 months.