Import orders into ShipStation

Use this workflow to make shipping your orders easy!

 

Edit Importing Local Line orders into Shipstation

 

  1. Connect a channel.
    1. If you have just created your ShipStation account, click Connect a channel from the getting started page on the Onboard tab.
      1. Search for "ShipStation".
    2. If you already have an account, click the gear icon (top right).
      1. Click Selling Channels.
      2. Click Store Setup
      3. Click Connect a Store or Marketplace.
      4. Search for "ShipStation".
  2. Connect your ShipStation Manual Store.
    1. Enter a Store Name.
    2. Uncheck the box next to Automatically generate order numbers to new manual orders.
    3. Click Connect.
  3. Prepare the import file.
    1. In your Local Line account, go to the Orders tab.
    2. Use the filters to find the orders you want to import into ShipStation.
    3. Select the orders and click Download Order Summary.
    4. In the downloaded CSV file, remove the # symbol from the cell in A1, along with any hidden spaces. After this modification, the header should read Order, not Order #. Save the modified file. If you are using macOS with Numbers as your default program for spreadsheets, you might need to export the Numbers file back to a CSV file type.
  4. Import orders into ShipStation.
    1. Go to the Orders tab.
    2. Click the Other Actions dropdown menu.
    3. Click Import Orders.
    4. Click + Select file. Navigate to and select the file you saved in 3d.
    5. In Import to store, select the store you created in 2a.
    6. Ensure Create a new field mapping is selected and click Upload.
  5. Map column headers to ShipStation fields.
    1. In Order Information, find the ShipStation Order # field and map it to the Order field in the Your Column Header dropdown.
    2. In Buyer & Recipient Information, map the following fields:
      1. Address Line 1 to Street
      2. Buyer Email to Email
      3. Buyer First Name to First Name
      4. Buyer Last Name to Last Name
      5. Buyer Phone to Phone
      6. Buyer Username to Account Name
      7. City to City
      8. Country Code to Country
      9. Postal Code to Postal (zip/post codes)
      10. State to State/Province
    3. In the Field mapping name, type a custom name for the mapping. For example, "Local Line Orders Summary".
    4. Click Start Import.
    5. After the loading bar completes, refresh your page to display the orders on the Orders tab.

Step 5 is only applicable on your first import. On subsequent imports, go to step 4e and then select Use a saved mapping. Select the mapping you configured in step 5 and click Upload.

For more information, see the ShipStation help page.