Import Orders via CSV

Last Updated: May 18, 2017 11:08PM PDT
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 Orders CSV:

Add Orders to CSV

Open the CSV in Excel, Numbers, Google Sheets, or your spreadsheet software of choice. You may leave optional fields blank, but keep all columns intact.
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
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 
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 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

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 CSV window to upload your CSV.

If you choose to add invoices, payments, packing slips, or shipments to the imported orders, Stitch will assign the import date to the date of the record and add Created by bulk import to the record notes.

Confirm import. The import takes place in the background and will take a few minutes.

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.