In order to be able to use Woocommerce integrations, an existing Woocommerce account's connection data and credentials must be provided (suspended or expired trial account will not be able to connect). The required fields are:
The only stream available syncs the orders table from the woocommerce site, as is, mapping every db type accordingly. The list of supported data types is:
Note: Columns of other types, more complex ones, are not supported and will silently be ignored on data synchronization.
One supported: "Key Based" / "Incremental"
"Key Based" (also called "Incremental") requires a particular field to be selected as "key". This is automatically selected from the orders table. That field is meant to be treated as a sequential or "sortable" field which increases by time (i.e. records added in the future will have never descending values in this field), and will be tracked across several extraction executions from the (same) integration's stream.
The first run, the whole table data will be downloaded into our platform, and the maximum value for that tracked key (i.e. the one from the last record retrieved) is kept for future runs. This will be time-consuming (as time-consuming as Full Table replication, but done only once) and the source servers may undergo a lot of resources consumption, so these runs should be scheduled on what the customer deems as low-activity hourly ranges (e.g. nightly).
When another extraction is run later for this incremental stream, only a subset of the data will be retrieved: Those having values, in the chosen key-field, greater than or equal to the last stored value.
As an example: Let's say the source table contains "sold product units", containing these fields: