Import Orders via CSV

Last Updated: Nov 21, 2018 08:06AM PST
With the Order Import CSV, you can upload sales orders in bulk for further processing (fulfillment, accounting, etc.) and reporting.

Export CSV

To export the template, go to the Orders page and click Actions > Import via CSV:

Add Orders to CSV

Open the CSV in Excel, Numbers, Google Sheets, or spreadsheet software of choice. You may leave optional fields blank, but keep all columns intact. Do not include any currency symbols, such as $.
.CSV Column Notes
Reference Number (Required) Assign a unique number for each order; for orders with multiple line items, give each line item its own row, give each line item row the same reference number
Order Date Format in MM/DD/YYYY
Email (Required) This field is required.
First/Last Name (Required) Both fields are required, even if your customer is a business. If this first and last name together match the name of a contact created in Stitch AND that contact has contact type Customer, Stitch will assign the order to that contact. Otherwise, Stitch will create a new contact.
Phone Number Format as XXX-XXX-XXXX
Shipping Address (Multiple Columns) If you leave these columns blank, the order will import without a shipping address
Billing Address (Multiple Columns) If you leave these columns blank but enter a shipping address, Stitch will auto-populate this field with the shipping address
S&H This order-level field is what you charge your customer; for orders with multiple line items, enter this in the first row of the order. Omit currency symbols.
Shipping Cost This order-level field is what you pay for shipping; for orders with multiple line items, enter this in the first row of the order. Omit currency symbols.
Ship Date This field is commonly used as the "start ship" date for wholesale orders; Stitch won't apply this date to the shipment itself
Cancel Date This field is commonly used to mark the end of the wholesale shipping window.
Currency ISO Three-letter ISO currency code. When left blank, Stitch will assign your default account currency to the order
Tags Add order-level tags (separated by a comma)
Notes Add order-level notes for internal or customer-facing communication
Item SKU (Required) You must reference a unique SKU value in Stitch.
Item Qty/Price/Taxable/Rate These four columns are specific to each line item; Omit currency symbols.

Tip: For orders with multiple line items, ensure that each line item (row) shares a common reference number. Other order-level details only need to be on the first row. See this sample template for an illustration.

Import CSV

Follow the instructions on the Import Orders via CSV modal: Select your CSV, and click Continue.

In the subsequent Confirm Order Details modal, choose the fulfillment warehouse and billing options for the imported orders: confirm-order-details Finally, confirm your import in the third and final modal. Order processing takes place in the background, and you'll receive an in-app notification when processing is complete.

Note: If your import contains an error, we'll flag this on the import screen as well as the notification center. Return to the import screen to download a CSV highlighting the error.

Review Imported Orders

When the import completes, click View Imported Orders from the Import Orders modal to view your import.

Stitch will auto-assign a tag to these orders, formatted as follows: Imported Month DD, YYYY. Use this to locate orders by import batch. To remove this tag, search the Orders page for that tag, select all tagged orders, click Bulk Actions > Tag Orders, and remove the import tag.