Good Morning All,
I already read a few topics regarding SAGE and Magento Integrations, but in my company, we have this main requirement/idea:
We already have 2 warehouses in SAGE
1 - The main warehouse (offline) - Where our products arrive to be catalog (Ex. 5000 units SKU - ZP001). After this process, the main warehouse moves some products (ZP001) to the second warehouse (Ex. 800 units)
2 - Secondary, "in transit" warehouse (Online Shop) - Magento should pick that there are 800 (SKU - ZP001) units available (in transit) in this secondary warehouse, but in the Backoffice, optimally, we should be able to only put 200 units (ZP001) online and give those individual SKUs, based on first statistical family. (Ex. 76545|ZP001)
Sage will know that, in total, there are 800 units (ZP001- If no sales), but Magento should here have the perception, that, in total, there are 800 units (ZP001) to be sold, but only 200 units are online and that there's still remaining another 600 units on the secondary warehouse, to be placed online. SAGE should not track the individual SKU's on Magento, only that 200 individual Sku's were created from the first family SKU (ZP001), and discount the stock.
Note 1: A transfer from the transit warehouse to Magento, should be considered as an “automatic purchase from the system” and a manual correction should be considered as
“inventory adjustment” (with the corresponding user info and comments)
Note 2: Transit warehouse in Magento should not allow manual stock adjustments/corrections on SAGE, only inside Magento warehouses. Magento only needs to track the stock on individual SKUs created from SAGE primary SKU.
I hope to have been clear enough. Please, If anyone has developed something like this, or knows how this can work, please speak up. Also, If you think that is a way "out-of-the-box" solution, I'm open to hear your thoughts and find a simpler solution.
Thanks in advance!
