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)
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 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)
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)
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)
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';