Knowledgebase: Orders
How do I Export/Import My Store's Order Information?

By going to your Orders =>Manage Orders section and clicking on the "Export/Import" button at the top right, you will see your store's Order Export options.

Exporting Orders

You can export all your store's with several provided filters for your needs. Your order export filtering options include:

  • Distributor
    Create an Export of orders based on items from specific distributors
  • Date Range
    Create an Export of orders based on a specific timeframe/date range for the order.
  • Order Status
    Create an Export of orders based on the status queue the order resides in.
  • Include Order Items
    This checkbox is marked by default and will include order items in the export file.

Additional Information
When including items, please be aware that the you will have a row in the CSV file for each individual item ordered. In other words, if order AB-1002 on your store was for 5 items, the CSV file will display the order in 5 rows, one for each item. The columns used for the item listings will be itemid and itemname.

Then, within each row you will see how many units of the items were in the orders. Again, using our 5 item example, if one of the ordered items had 3 units purchased, this will be represented in the numitems column.

You can also create your own custom set of order exports which only include the columns you wish to have in the CSV file. This process is identical to creating a custom export of your products which is described in the article located here.

Exporting Checkout Questions

If you are using your store's Checkout Questions functionality, you can use the Orders Export/Import section to export the submitted answers to those questions. This export can be filtered by Date Range as well.

Additional Information
You can also perform a scheduled export of these two options as needed.

Importing Tracking Numbers

In the Import section of this page, you will have the ability to import tracking numbers for the orders after you've generated their shipping labels.

Tip
The action of importing tracking numbers to the orders in this page will automatically set the order's status to Shipped.


Help Desk Software by Kayako fusion