How do I import my orders with a CSV?

(ShipStation recently provided the ability to map different names for the Buyer and the Recipient. If your Buyer Names are showing up blank in-app, please reimport your CSV and update your saved mapping to include Buyer Name.)

Importing orders into ShipStation is an easy process using a CSV (comma-separated values) or a tab delimited file. Most shopping carts and marketplaces will allow you to export your existing orders into one of these two types of formats for easy importing into other programs.

Once you have your file, we recommend opening it in a spreadsheet program like Microsoft Excel, Numbers, OpenOffice or LibreOffice. This way you have an idea of what information is included in the file. While you're looking through your CSV, make sure that all your Order #s are unique (to both others in the document, and those in ShipStation), otherwise ShipStation will try to update the previous matching order number. If you want your order numbers to automatically number themselves on your store, you can put "AUTO" as the value for each order in your CSV.

On most computers, you can still upload the file while it's open (the last saved copy will be the one uploaded to ShipStation), so when you're ready, go to the Orders tab in ShipStation. Then, click on the Other Actions dropdown and select "Import Orders."

If you'd like to see a full list of the fields available for you, and which ones are required, you can take a look at the PDF at the bottom of this page.

This will show the page to set up your import. Here, you need to select the file from you computer, and then choose the manual store into which you wish to import the orders. 

Then, you can choose between creating a new field mapping (connecting your CSV's headers with the ones we use) or using a saved field mapping. For this example, we'll create a new one. 
Finally, choose between the CSV file or the Tab delimited file that we talked about earlier, select whether the file has column names at the top, and then click Upload and Continue.

Now, you'll need to go through and select the appropriate column from your CSV header and match it to the ShipStation field. This is why we suggested earlier that you open up the file to take a peek at what the headers mean (they can get confusing sometimes). If you save this mapping, next time you import and select that saved mapping, all of this will be already be mapped for you.  

Once you've mapped all of the fields, you have the option to Save the settings for future imports. Even if you don't plan on importing orders again, it's worth it to save the settings (with a descriptive name) so that if it does happen, you don't have to map the fields again.

To save the settings, simply name the mapping. 

Now, click Start Import and the system will process the import. Once it's finished, your orders should be imported into the "Awaiting Shipment" section of your orders screen. 
If you need some help with formatting your CSV (especially for orders with more than one item in it), you can format your file after the one attached below.

Was this article helpful?
4 out of 7 found this helpful
Have more questions? Submit a request