Chapter 57 ShipStation ODBC
To connect ShipStation to Big Business you need to set up the Shipping Connect add-on (or let us do this for you) and in the ShipStation ODBC Client configure a Store to use Custom Queries.
This Solution describes creating this setup. (7101)
Modified DateTime
Sales Orders now include a Modified DateTime field named, ModMyDtTm. Added for ShipStation ODBC Client requirements, and not needed for their Custom Queries, it provides a simple way to see the last time an Order was modified in Big Business when reading from MySQL.
This Solution describes this option. (7069)
ShipStation is an online service for shipping that offers an ODBC Client that can connect to Big Business. It requires a DateTime field in the data it is reading. Orders now include a Modified DateTime, named ModMyDtTm, for this purpose.
Modified Timestamp
Sales Orders (SO) now include a Modified Timestamp field (ModMyTimeStamp). This field was added to meet a ShipStation requirement for their ODBC Client.
This Solution describes this option. (7077)
ShipStation is an online service for shipping that offers an ODBC Client that can connect to Big Business. It requires a DateTime field in the data it is reading. Orders now include a Modified DateTime, named ModMyDtTm, for this purpose.
ShipStation CountOrders
To connect ShipStation to Big Business you need to set up the Shipping Connect add-on (or let us do this for you) and in the ShipStation ODBC Client configure a Store to use Custom Queries starting with CountOrders.sql.
This Solution describes creating this file. (7083)
In ShipStation ODBC Client create a Store using the DSN you created and set it
SELECT count(*) FROM `SO` WHERE `ModMyTimeStamp` >= '{MinDateYear}-{MinDateMonth}-{MinDateDay}'
AND `ShipCtry` = 'US';
ShipStation BatchOrder
To connect ShipStation to Big Business you need to set up the Shipping Connect add-on (or let us do this for you) and in the ShipStation ODBC Client configure a Store to use Custom Queries including BatchOrder.sql with contents below.
This Solution provides example of file contents. (7083)
SELECT
SONo as OrderId,
ModMyTimeStamp as OrderDate,
ShipName as RecipientFullName,
ShipAddr1 as RecipientAddress1,
ShipCity as RecipientCity,
ShipSt as RecipientState,
ShipZip as RecipientZip,
ShipCtry as RecipientCountry
FROM `SO` WHERE `ModMyTimeStamp` >= '{MinDateYear}-{MinDateMonth}-{MinDateDay}'
AND `ShipCtry` = 'US';
ShipStation PostBack
To connect ShipStation to Big Business you need to set up the Shipping Connect add-on (or let us do this for you) and in the ShipStation ODBC Client configure a Store to use Custom Queries including BatchOrder.sql with contents below.
This Solution provides example of file contents. (7083)
SELECT
SONo as OrderId,
ModMyTimeStamp as OrderDate,
ShipName as RecipientFullName,
ShipAddr1 as RecipientAddress1,
ShipCity as RecipientCity,
ShipSt as RecipientState,
ShipZip as RecipientZip,
ShipCtry as RecipientCountry
FROM `SO` WHERE `ModMyTimeStamp` >= '{MinDateYear}-{MinDateMonth}-{MinDateDay}'
AND `ShipCtry` = 'US';