How do I connect an ODBC database to ShipStation?

*ShipStation ODBC is an advanced tool that connects ShipStation to an existing ODBC database. If you are not the developer that set up your database, it is advised that you not attempt to make this connection. Please confer with your IT adviser to see if this would be the best fit for your business's needs. 

If you are the developer/system admin in charge of setting up this ODBC database: As with any other major configuration, we highly advise backing up all necessary data before proceeding with connecting your ODBC database to ShipStation.

To get this feature enabled, you will need to reach out to ShipStation Enterprise Support. 

Downloading ShipStation ODBC

Connecting to Data Source

Import Field Mapping

Postback Data Mapping

Downloading ShipStation ODBC

To connect ShipStation to an ODBC database, you'll need to first go to your ShipStation account's store settings to download the ShipStation ODBC program. This will need to be done on a Windows computer. 

Head to your Account Settings (the gear icon in the upper right).

Next, select Selling Channels and then Store Setup from the sidebar on the left.

Now, click ODBC in the Connect a Store or Marketplace popup.

On the page that appears, click Download ShipStation ODBC

 

Connecting to Data Source

Once the program is installed and running, log in to the ShipStation ODBC popup using your ShipStation user credentials.

After you log in, you will be able to add a new store by clicking New

From here, you'll be prompted to give this new store a name. 

After you click Next >, you'll select the select the Data Source that will be connected. This is also where you will enter the database's username and password.

To connect to a new database, locate the Data Source Name from the User DSN tab. If any configurations need to be made, click Configure... to adjust accordingly. Once ready, click OK.  

Once successfully connected, click Ok. From here, you'll be mapping the ODBC fields to their corresponding fields in ShipStation.

 

Import Field Mappings

First, you'll need to select the data source at the top of the Import Field Mapping modal. 

While there are many available fields to import, only a few are actually required. These fields are: Order #, Order Date, Full Name, or First Name & Last Name, Address 1, City, and Zip/Postal Code.

*Keep in mind that you must pass the Order Date value to be in the same timezone that is shown on the machine your database is on. 

*Also, be sure to have the time displayed in date-time format with the values for year, month, date, hour, minute, and second importing (though they don't have to be in that specific order).  

Example: YYYY/MM/DD HH:MM:SS, MM/DD/YYYY HH:MM:SS, etc. 

*If either of these criterion are not properly met, orders will not import.

The Auto Match feature can be used to map each Data Source to their corresponding ShipStation field. The matching is based off of the Field Name. If the Auto Match doesn't sync properly, or if you'd prefer, you can manually map these fields.

First, set up the order-level fields.

The Order Status field is not required, but highly recommended. (If not mapped, all ODBC orders will import into Awaiting Shipment.) 

Once you've entered the Order information, move through and assign the fields for the Items, Shipping Options, Recipient and Billing tabs, then click Next

 
Postback Data Mapping

Next, you will map the fields in the Post Back Data Source modal. Choose whether the data source that will be updated is the same as the Import Field Data Source, if you will be posting back to another data source, or if you will not be posting back shipment data. 

Just as with the Order Import Source modal, select the data source.

There are less fields available when posting back shipment information, and the only required field is the Order # field. And if you click on the Order # button, you will be able to trim any additional zeroes from the beginning or end of an order number. 

Once you map the desired post back fields, click Save and your ODBC database will be connected. 

You should get two notifications on your computer verifying that the store is connected and another once orders begin importing. 

 Now, you should start receiving orders as you would from any other store!

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