CSV Importing of Orders

Importing orders via CSV

June 1, 2012


Entering manual orders can be very time consuming and tedious. ShipStation now has a solution that will allow sellers to quickly import existing orders into our application. By using our new CSV Import feature, sellers can upload orders for marketplaces not currently supported by ShipStation. This feature is currently in Beta testing and is available to ShipStation users on the Silver or higher plans.

To begin importing your orders with our CSV Import feature in ShipStation, follow these simple instructions:

Go to the Orders screen in ShipStation, and click on the Import button.

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 bring up a window like the one below. Here, you need to select the file from you computer, and then choose the manual store into which you wish to import the orders. For the majority of users, you will only have one manual store.

Then, you can choose between creating a new field mapping (assimilating 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 Next. You’ll be greeted with a screen like the one below:

Now, you’ll need to go through and select the appropriate column (CSV Field) 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 meant (they can get confusing sometimes).

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 check the box, and name the mappings:

Now, click Next 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.

That’s it! Now you’ve imported your orders via a CSV file.