How can we help?
Import Orders via CSV
|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.
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.
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.