Mixed Up Clothing EDI Integration (Shopify / CommerceHub / Macy's)
The Problem
Our client, Mixed Up Clothing, has been drop-shipping with Macy’s through CommerceHub’s OrderStream platform. They were using OrderStream Portal to upload product inventories and manage orders. All were done manually. This manual approach was not only time-consuming for their operations team but also leading to non-efficient manual processes.
Mixed Up Clothing wanted to have an optimized drop-shipping integration whereby flows are automated, manual tasks are reduced and processes are optimized. Hence, they chose Dscopify as solution to integrate the Shopify store with OrderStream for their direct-to-consumer Macy’s orders.
Also Read: BloomsyBox Integration with Macys
The Approach
Macy’s uses EDI (X12 EDI standards, version 4010) to communicate with OrderStream. As Mixed Up Clothing account was already live, the integration followed the migration route whereby:
(1) The OrderStream account was upgraded to an “integrated” one. This upgrade allowed integration with OrderStream using EDI through SFTP.
(2) A full end-to-end test activity were completed using OrderStream Test. This was to ensure full compliance with Macy’s EDI requirements and to cover all the test scenario as per OrderStream test plan.
(3) A due diligence activity was carried out with Mixed Up Clothing team to review all catalog SKU/UPC prior to the introduction of the inventory feed. Discrepancies were identified and corrected.
(4) Integration setup & configuration were completed as per Mixed Up Clothing requirements.
(5) Once go-live readiness was achieved, the connection was switched “live”.
The Result
Mixed Up Clothing’s Shopify store is fully connected with OrderStream. As such,
The inventory feeds from Shopify to OrderStream are fully automated – both delta feeds (when inventory changes throughout the day) and full feeds (at least once per day).
New orders from Macy’s into OrderStream are transferred automatically to Shopify for fullfilment. All the transferred orders are also acknowledged automatically.
Shipped orders (or order lines) in Shopify are automatically updated on OrderStream, with the tracking details (carrier, tracking number).
Cancelled orders (or order lines) in Shopify are also automatically updated with cancellation codes.
For all completed orders, the invoices are automatically generated.
All EDI documents within the scope of the integration were covered:
EDI 846 – Inventory
EDI 850 – Purchase Orders
EDI 997 – Order Acknowledgements
EDI 856 – ASN / Shipments / Cancellations
EDI 810 – Invoices
The migration from a completely manual process to a fully automated one was achieved and the integration was concluded successfully.
