ShipStation ODBC Form

A 64-bit ODBC Driver is required to connect your data source. Please make sure this driver is installed prior to your appointment with our ODBC Specialist

If the driver is not installed and accessible, we will not be able to complete the marketplace configuration.

1. What is the name for the the point of contact on this form? *This question is required.

2. What email is the point of contact for this form? *This question is required. This question requires a valid email address.

3. Your Contact Information *This question is required.

Your Name
Your Company Name
Your Phone Number
Your Email Address
Best Time to Contact You

Once you complete and submit the form, our Support team will call you to discuss next steps discuss next steps and arrange completion of the configuration.

* Our business hours are 7am - 8pm CT, Monday - Friday.

ShipStation only supports downloading orders by Last Modified Date. ShipStation checks a column in your database to see when the last time an order was modified. All orders that have been modified since the last time they were imported will be imported/re-imported as appropriate.

This method requires a column in your ODBC database that specifies when an order was last modified. You can specify this in the field mapping below.

6. Do you have the existing query utilized with your existing shipping solution? *This question is required.

Please paste the query in the box below. *This question is required.

7. Does all of the data exist in 1 table? *This question is required.

Table Name *This question is required.

8. Below is a list of all possible fields for import into ShipStation. Enter the table name and field name, from your ODBC database, for each field you wish to populate in ShipStation.

Space Cell	ODBC Table Name	ODBC Field Name
Last Modified Date and Time	Last Modified Date and Time: ODBC Table Name	Last Modified Date and Time: ODBC Field Name
Order Date and Time *This question is required	Order Date and Time: ODBC Table Name	Order Date and Time: ODBC Field Name
Order Number *This question is required	Order Number: ODBC Table Name	Order Number: ODBC Field Name
Order Status *This question is required	Order Status: ODBC Table Name	Order Status: ODBC Field Name
Custom Field 1	Custom Field 1: ODBC Table Name	Custom Field 1: ODBC Field Name
Custom Field 2	Custom Field 2: ODBC Table Name	Custom Field 2: ODBC Field Name
Custom Field 3	Custom Field 3: ODBC Table Name	Custom Field 3: ODBC Field Name
Customer Notes	Customer Notes: ODBC Table Name	Customer Notes: ODBC Field Name
Internal Notes	Internal Notes: ODBC Table Name	Internal Notes: ODBC Field Name
Gift Indicator	Gift Indicator: ODBC Table Name	Gift Indicator: ODBC Field Name
Gift Message	Gift Message: ODBC Table Name	Gift Message: ODBC Field Name
Hold Until Date	Hold Until Date: ODBC Table Name	Hold Until Date: ODBC Field Name
Order Source	Order Source: ODBC Table Name	Order Source: ODBC Field Name
Ship By Date	Ship By Date: ODBC Table Name	Ship By Date: ODBC Field Name
Item Name *This question is required	Item Name: ODBC Table Name	Item Name: ODBC Field Name
Item Quantity *This question is required	Item Quantity: ODBC Table Name	Item Quantity: ODBC Field Name
Item SKU *This question is required	Item SKU: ODBC Table Name	Item SKU: ODBC Field Name
Country of Origin	Country of Origin: ODBC Table Name	Country of Origin: ODBC Field Name
Fulfillment SKU	Fulfillment SKU: ODBC Table Name	Fulfillment SKU: ODBC Field Name
HS Tariff	HS Tariff: ODBC Table Name	HS Tariff: ODBC Field Name
Image URL	Image URL: ODBC Table Name	Image URL: ODBC Field Name
Unit Price	Unit Price: ODBC Table Name	Unit Price: ODBC Field Name
Unit Shipping	Unit Shipping: ODBC Table Name	Unit Shipping: ODBC Field Name
Unit Tax	Unit Tax: ODBC Table Name	Unit Tax: ODBC Field Name
Unit Weight	Unit Weight: ODBC Table Name	Unit Weight: ODBC Field Name
UPC	UPC: ODBC Table Name	UPC: ODBC Field Name
Warehouse Location	Warehouse Location: ODBC Table Name	Warehouse Location: ODBC Field Name
Content Type	Content Type: ODBC Table Name	Content Type: ODBC Field Name
Insurance Provider	Insurance Provider: ODBC Table Name	Insurance Provider: ODBC Field Name
Insurance Value	Insurance Value: ODBC Table Name	Insurance Value: ODBC Field Name
Non-Delivery Option	Non-Delivery Option: ODBC Table Name	Non-Delivery Option: ODBC Field Name
Package Height	Package Height: ODBC Table Name	Package Height: ODBC Field Name
Package Length	Package Length: ODBC Table Name	Package Length: ODBC Field Name
Package Width	Package Width: ODBC Table Name	Package Width: ODBC Field Name
Total Weight	Total Weight: ODBC Table Name	Total Weight: ODBC Field Name
Ship Method	Ship Method: ODBC Table Name	Ship Method: ODBC Field Name
Ship to Full Name *This question is required	Ship to Full Name: ODBC Table Name	Ship to Full Name: ODBC Field Name
Ship to First Name *This question is required	Ship to First Name: ODBC Table Name	Ship to First Name: ODBC Field Name
Ship to Middle Name	Ship to Middle Name: ODBC Table Name	Ship to Middle Name: ODBC Field Name
Ship to Last Name *This question is required	Ship to Last Name: ODBC Table Name	Ship to Last Name: ODBC Field Name
Ship to Address 1 *This question is required	Ship to Address 1: ODBC Table Name	Ship to Address 1: ODBC Field Name
Ship to Address 2	Ship to Address 2: ODBC Table Name	Ship to Address 2: ODBC Field Name
Ship to Address 3	Ship to Address 3: ODBC Table Name	Ship to Address 3: ODBC Field Name
Ship to City *This question is required	Ship to City: ODBC Table Name	Ship to City: ODBC Field Name
Ship to State/Province	Ship to State/Province: ODBC Table Name	Ship to State/Province: ODBC Field Name
Ship to Zip Code *This question is required	Ship to Zip Code: ODBC Table Name	Ship to Zip Code: ODBC Field Name
Ship to Country *This question is required	Ship to Country: ODBC Table Name	Ship to Country: ODBC Field Name
Ship to Company	Ship to Company: ODBC Table Name	Ship to Company: ODBC Field Name
Ship to Customer Username	Ship to Customer Username: ODBC Table Name	Ship to Customer Username: ODBC Field Name
Ship to Email	Ship to Email: ODBC Table Name	Ship to Email: ODBC Field Name
Ship to Phone	Ship to Phone: ODBC Table Name	Ship to Phone: ODBC Field Name
Ship to Residential Status	Ship to Residential Status: ODBC Table Name	Ship to Residential Status: ODBC Field Name
Bill to Full Name	Bill to Full Name: ODBC Table Name	Bill to Full Name: ODBC Field Name
Bill to First Name	Bill to First Name: ODBC Table Name	Bill to First Name: ODBC Field Name
Bill to Middle Name	Bill to Middle Name: ODBC Table Name	Bill to Middle Name: ODBC Field Name
Bill to Last Name	Bill to Last Name: ODBC Table Name	Bill to Last Name: ODBC Field Name
Bill to Company	Bill to Company: ODBC Table Name	Bill to Company: ODBC Field Name
Bill to Address 1	Bill to Address 1: ODBC Table Name	Bill to Address 1: ODBC Field Name
Bill to Address 2	Bill to Address 2: ODBC Table Name	Bill to Address 2: ODBC Field Name
Bill to Address 3	Bill to Address 3: ODBC Table Name	Bill to Address 3: ODBC Field Name
Bill to City	Bill to City: ODBC Table Name	Bill to City: ODBC Field Name
Bill to State/Province	Bill to State/Province: ODBC Table Name	Bill to State/Province: ODBC Field Name
Bill to Zip Code	Bill to Zip Code: ODBC Table Name	Bill to Zip Code: ODBC Field Name
Bill to Country	Bill to Country: ODBC Table Name	Bill to Country: ODBC Field Name
Bill to Company	Bill to Company: ODBC Table Name	Bill to Company: ODBC Field Name
Billing Account # (Recipient or Third-Party)	Billing Account # (Recipient or Third-Party): ODBC Table Name	Billing Account # (Recipient or Third-Party): ODBC Field Name
Billing Country (Recipient or Third-Party)	Billing Country (Recipient or Third-Party): ODBC Table Name	Billing Country (Recipient or Third-Party): ODBC Field Name
Billing Party (Recipient or Third-Party)	Billing Party (Recipient or Third-Party): ODBC Table Name	Billing Party (Recipient or Third-Party): ODBC Field Name
Billing Zip (Recipient or Third-Party)	Billing Zip (Recipient or Third-Party): ODBC Table Name	Billing Zip (Recipient or Third-Party): ODBC Field Name
Payment Date	Payment Date: ODBC Table Name	Payment Date: ODBC Field Name
Payment Method	Payment Method: ODBC Table Name	Payment Method: ODBC Field Name
Shipping Amount Paid	Shipping Amount Paid: ODBC Table Name	Shipping Amount Paid: ODBC Field Name
Tax Amount	Tax Amount: ODBC Table Name	Tax Amount: ODBC Field Name
Total Amount Paid	Total Amount Paid: ODBC Table Name	Total Amount Paid: ODBC Field Name

In addition to importing orders from your database, ShipStation can also upload tracking and shipment information once an order is processed.

9. Is the upload source different than the previously specified datasource? *This question is required.

10. Do orders already exist in the table the tracking numbers will be uploaded to, or will they need to be inserted? *This question is required. NOTE: If order records need to be inserted, you must use a custom query. If order records already exist and need to be updated, you may use the mapping tool in the ODBC client or a custom query.

11. Will the data be uploaded to a single table? *This question is required.

Table Name *This question is required.

12. The following fields can be uploaded to your database once a shipment is processed. Enter the table name and field name mapping for each corresponding ShipStation field. (Additional fields are available via custom query)

Space Cell	ODBC Table Name	ODBC Field Name
Order Number *This question is required	Order Number: ODBC Table Name	Order Number: ODBC Field Name
Carrier	Carrier: ODBC Table Name	Carrier: ODBC Field Name
Confirmation Service	Confirmation Service: ODBC Table Name	Confirmation Service: ODBC Field Name
Insurance Fee	Insurance Fee: ODBC Table Name	Insurance Fee: ODBC Field Name
Insurance Provider	Insurance Provider: ODBC Table Name	Insurance Provider: ODBC Field Name
Insured Value	Insured Value: ODBC Table Name	Insured Value: ODBC Field Name
Online Order ID	Online Order ID: ODBC Table Name	Online Order ID: ODBC Field Name
Order Status	Order Status: ODBC Table Name	Order Status: ODBC Field Name
Package Type	Package Type: ODBC Table Name	Package Type: ODBC Field Name
Print Date	Print Date: ODBC Table Name	Print Date: ODBC Field Name
Service	Service: ODBC Table Name	Service: ODBC Field Name
Ship Date	Ship Date: ODBC Table Name	Ship Date: ODBC Field Name
Shipping Amount	Shipping Amount: ODBC Table Name	Shipping Amount: ODBC Field Name
Tracking Number	Tracking Number: ODBC Table Name	Tracking Number: ODBC Field Name
Recipient Full Name	Recipient Full Name: ODBC Table Name	Recipient Full Name: ODBC Field Name
Recipient First Name	Recipient First Name: ODBC Table Name	Recipient First Name: ODBC Field Name
Recipient Last Name	Recipient Last Name: ODBC Table Name	Recipient Last Name: ODBC Field Name
Recipient Company	Recipient Company: ODBC Table Name	Recipient Company: ODBC Field Name
Recipient Address 1	Recipient Address 1: ODBC Table Name	Recipient Address 1: ODBC Field Name
Recipient Address 2	Recipient Address 2: ODBC Table Name	Recipient Address 2: ODBC Field Name
Recipient Address 3	Recipient Address 3: ODBC Table Name	Recipient Address 3: ODBC Field Name
Recipient City	Recipient City: ODBC Table Name	Recipient City: ODBC Field Name
Recipient State/Province	Recipient State/Province: ODBC Table Name	Recipient State/Province: ODBC Field Name
Recipient Zip Code	Recipient Zip Code: ODBC Table Name	Recipient Zip Code: ODBC Field Name
Recipient Country	Recipient Country: ODBC Table Name	Recipient Country: ODBC Field Name
Recipient Phone	Recipient Phone: ODBC Table Name	Recipient Phone: ODBC Field Name

Please be sure to have the username and password for a read/write user for this database. We will collect these via phone at the time of our scheduled configuration appointment.

ShipStation ODBC Form

ODBC Setup