Spreadsheet: Importing data via Orders Template
If you have sales from e-commerce platforms (or a brick and mortar store) outside of our direct integrations, you can import them using a CSV file HERE. You'll need an active TaxJar subscription to access this link.
If you have not already, we recommend reading this support article, "Importing Data with a Spreadsheet" to confirm if you should use the Line Item template, and to review for other spreadsheet-specific FAQs.
- We share more detail here about why you should send line items. By passing in line items, you can use product_tax_codes to communicate to TaxJar what type of products are included in an order.
- Please note, the headers differ slightly from the Line Items template and these two templates are not interchangeable.
If you choose to import data using the Orders template, please follow these formatting guidelines:
Please use lowercase to map to known providers (ie: “ebay” and “amazon”)
If the sale is conducted in-store or via an unsupported platform, then any unique keyword can be input: (ie: mycart, instore, popupshop, cash).
|order_id||Required. Alphanumeric.Re-using the same order_id will over-write the previous order!|
|transaction_type|| Recommended: Empty defaults to “Order”
Accepts “Order” or “Refund”.
All values for "refunds" are negative and that all values for "orders" are positive.
|transaction_reference_id|| Link refunds to the original order by filling in the order’s transaction_id here.
Requirement: Needs rows with
|completed_at|| Required. Please use the ISO-8601 format in either Date or DateTime (YYYY-MM-DD).
Cannot be in a future year. Other date formats can be used, however, ISO-8601 will always be parsed correctly.
|shiptostate||Required. Use 2-letter or 3-letter codes. (eg: NY, NC)|
|shiptozip||Required if US address|
|shiptocountrycode||Required. Use 2-letter country codes (eg: US, CA)|
|from_state||Recommended. Use 2-letter codes (eg: NY, NC)|
Use 2-letter country codes (eg: US, CA)
|total_sale|| This amount should be the subtotal (item price * quantity) + handling + shipping - discount.
For example if you sold 2 items for $5, shipped for $2 with a $0.50 discount, then the total_sale would be (2 * $5) + $2 - $0.50 = $11.50
|exemption_type|| You can denote exempt transactions via spreadsheet upload for marketplace facilitators, wholesale or resale, or government or exempt entities.