How do I set up ODBC postback field mappings?

(This article refers to a feature that is currently being previewed by certain users. If you're interested in joining this feature's preview group, please reach out to our support team. We'll follow up when the preview group is expanded!)


*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.

While many of our current integrations only post back minimal shipment information, with ShipStation ODBC, a large variety of fields are available to post back to your data source. If you wish to set up post back data, head to 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.

The only field which is required for posting back data is the Order #

And if you click on the Order # button, you will be able to trim any additional characters from the beginning or end of order numbers. Just as with the Import Field Mapping, anytime a field is a clickable button, it will allow for additional configuration. 

Once you've mapped both the Package and Recipient fields, your post back data will begin communicating with your database!

 

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