CSV and Excel order import
Import orders from a spreadsheet into Sellercloud
Some orders never arrive as an EDI file: a wholesale order sheet, a partner's email, an export from another shop. Import them from a CSV or Excel file, check every row before anything changes, and with Create orders in Sellercloud on, each one is created in Sellercloud like any other order.
Plans from $199 a month for up to 500 orders. 14-day free trial, card required; $750 onboarding charged at the start.
On the call we create your company's account with you and get your first partner live. You then choose a plan in the app, which starts the free trial.
In short
Order import reads a CSV or Excel (.xlsx) file of orders, one row per item, and records each order on an EDI connection or a custom source in interSend. When that connection's Create orders in Sellercloud switch is on, each order is then created in Sellercloud.
How an import works
- 1
Choose the file
Pick where the orders go, an EDI connection or a custom source, then the file. Download a template if you are starting from scratch.
- 2
Match the columns
interSend guesses which column holds what. It knows headers such as "Order #" and "Qty" and the columns of Shopify's order export. Your choices are remembered for that connection, so the next file starts from them.
- 3
Check every row
You see how many orders are new, already here or have problems. Each problem names its spreadsheet row, and you can download the list. SKUs Sellercloud does not know are flagged. Nothing has changed yet.
- 4
Import
The orders are recorded at once. With Create orders in Sellercloud on, each is then created there, one after another; any not done within a minute are created by the connection's next order check. Orders → Imports keeps a record of every file.
Where the orders go
Into an EDI connection
The orders become that partner's. Once one is in Sellercloud the partner gets an 855 if its file rules send one, and once it ships, the 856 ship notice and 810 invoice, when Send to partner is on.
Into a custom source ("Orders from a file")
A source of your own with no partner, such as wholesale orders. With Create orders in Sellercloud on, orders are created there, and their tracking is recorded when they ship. Nothing is sent anywhere.
Wayfair and Secret Sales orders come from their APIs, so files are not imported into those connections. See the Rooms To Go, ShopHQ and other EDI partner pages for what each partner is sent.
What a file can hold
- CSV separated by commas, semicolons or tabs, including Excel's own CSV with accents and £, or an Excel .xlsx file.
- Up to 4 MB, 5,000 rows and 1,000 orders in one import.
- One row per item, with the order number on every row. The address may be left blank after an order's first row.
- Required columns: order number, ship-to name, address, city, state, postal code, SKU and quantity.
- Optional: country, company, address line 2, phone, email, order date, ship-by date, ship method, unit price, description, notes, gift message, shipping cost, tax and currency.
- Shipping cost becomes Sellercloud's shipping fee. Tax is written on the Sellercloud order as a note.
- State and country names become codes (Florida to FL). Dates such as 03/04/2026 are read the way the file's other dates show, and anything that could be read two ways is listed for you to check.
Checks and history
- Import the good orders and list the rest (the default), or import nothing unless every order is valid.
- Order numbers already here are skipped by default. Or replace the ones not yet in Sellercloud; an order already in Sellercloud is never changed.
- The same file uploaded twice is recognised, and imported again only if you tick Import it again.
- Anyone who can see the connection can check a file. Importing it takes an Operator or Admin.
- Every import is listed under Orders → Imports: the file, who imported it and when, how many orders were new, replaced, already here or left out, and how many are in Sellercloud now.
Questions about order import
Can I import a Shopify order export?
Yes. interSend recognises the columns of Shopify's order export, including rows that leave the address blank after an order's first item. It is a file you import, not a live link to a Shopify store.
Can I import Wayfair or Secret Sales orders from a file?
No. Their orders come straight from the marketplace's API. Files can be imported into EDI connections (Rooms To Go, ShopHQ and other EDI partners) and custom sources.
What happens to an order number that is already there?
It is skipped, unless you choose to replace orders not yet in Sellercloud. An order already in Sellercloud, or read from a partner's own file, is never changed by an import.
Do imported orders count toward my plan?
Yes. Each imported order counts when it is recorded, as every order does.
Can I import files through the API or Claude?
Not files, not yet. The REST API can create single orders on an EDI connection or custom source, with the same checks.
Bring your spreadsheet orders into Sellercloud
You see every row before you press Import, and orders reach Sellercloud only on connections with Create orders in Sellercloud on.
Book a setup call (opens in a new tab)On the call we create your company's account with you and get your first partner live. You then choose a plan in the app, which starts the free trial.
Page last updated .