While we recommend using the API to submit orders, we can import and process orders using this Excel template.

RequirementsCopied!

• The Excel sheet must be .xlsx format.

• The required fields below MUST be provided.

• The column headers MUST exactly match below. There should be no extra characters or spaces.

TemplateCopied!

Download Template

FieldsCopied!

* required

** requirement varies depending on agreement with Think Patented

Order ID *
Line Item ID
Purchase Order Number
SKU *
Quantity *
Unit Price
Unit Tax
Order By First Name
Order By Last Name
Order By Email
Shipping First Name *
Shipping Last Name *
Shipping Company
Shipping Email
Shipping Phone
Shipping Address 1 *
Shipping Address 2
Shipping City *
Shipping State * - use full state name (i.e.: Ohio)
Shipping Postal Code *
Shipping Country * - use full country name (i.e.: United States)
Shipping Method **
Need By Date
Billing First Name **
Billing Last Name **
Billing Company **
Billing Email **
Billing Phone **
Billing Address 1 **
Billing Address 2 **
Billing City **
Billing State ** - use full state name (i.e.: Ohio)
Billing Postal Code **
Billing Country ** - use full country name (i.e.: United States)
CustomData.MyHeaders

Custom data can be passed using the “CustomData.MyHeader” format.