Ecwid Connect

Ecwid Connect automatically connects Big Business to your Ecwid store. Fully automatic and fully customizable, Ecwid Connect lets you get new customers and orders as they come in, or in batches when you are ready to process.

This Solution provides a quick overview. (7047)

Ecwid Connect is simple. It works like an Import to automatically create new customers and orders. It is fast, connecting to your store to retrieve new orders in an instant. And it is flexible, running by itself, or only when needed with a few clicks.


  Battery Settings

macOS Big Sur adds Battery to System Preferences for laptops. Settings previously found in Energy Saver are now found here. Turn OFF the setting for Prevent Computer from Sleeping for reliable Instant-On.

(7055)

Prevent Computer from Sleeping must be unchecked for Instant-On to work reliably. However the checkbox does not work reliably. If it sticks (still checked when you re-open System Prefs) try clicking Restore Defaults.


  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.


  Instant On

Instant On is a new feature in Big Business. New Networking allows Big Business Client to Sleep. Shut your laptop or allow your computer to sleep and when it wakes on the same network, Big Business Client will resume working right where you left off.

This Solution will provide details. (7076)




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