Hi everyone, I’d like to seek advice on handling a Shopify setup with multiple warehouses and separate ERP systems. Would really appreciate insights from anyone who has dealt with a similar setup.
My setup:
Shopify store
warehouses (each using an individual ERP system)
Warehouse A → ERP A (Qianyi ERP)
Warehouse B → ERP B (Qianyi ERP)
SKUs between both warehouses are completely non-overlapping
Issue I’m facing:
When a customer places an order that includes:
SKU A (from Warehouse A)
SKU B (from Warehouse B)
Shopify correctly splits fulfillment by location, but orders are still synced as a whole, without SKU/location-level separation to both ERP systems
This results in:
ERP A receiving A + B
ERP B also receiving A + B
Both warehouses getting orders containing SKUs they don’t carry
My question:
Is there an effective method to achieve the following:
A single order containing SKUs from multiple warehouses Automatically route/split the relevant SKUs to the correct ERP Ensure each warehouse only processes and fulfills its own items
PS: Switching ERP systems is not a feasible option for me at the moment,
so I’m trying to find a workable solution within the current setup (Shopify + two ERPs).
If your ERP systems support FTP or SFTP, our EZ Exporter app can automatically split up the line items in the order based on the assigned fulfillment location and send separate CSV files containing the order-level data (such as the order number and shipping info) and only the line items associated with each location (more info here).
In the app, you would basically set up 2 separate “export profiles”, one for each ERP/Warehouse with the corresponding filters for the fulfillment location at the line item level. You can then schedule it to run as frequently as every 15 minutes and only include new orders created since the last export.
If your ERP systems don’t support FTP/SFTP, you can send the CSV files via email and we also have integrations with Amazon S3, Dropbox, Google Drive, Google Sheets, and Airtable.
Feel free to contact us in case you have any questions about this.
Have one ERP instance, that’s the entire point of having an ERP to consolidate resources to a single place for planning.
And each warehouse should just be able to ignore invalid SKU’s without ignoring the entire order.
That’s super iffy and specific to each ERP if they just automatically consume all orders or fulfillment orders with no granularity and they have no good apis that’s a problem deeper than forums posts can handle and can move into custom app dev fast.
Middle grounds are typically CSV by FTP like @Jonathan-HA already covered, setting up a custom-fulfillment-servce in the shopify admin(it’s a glorified mail notificaiton template), or automation tools like mechanic[1] to either edit orders or fire off events to custom EPR api endpoints, etc etc etc.
You can reach out for services if you need this dug into or a given solve setup.
Shopify correctly splits fulfillment by location, but orders are still synced as a whole, without SKU/location-level separation to both ERP systems