Skip to content
sandadocs
Console Start free trial

WooCommerce

Connect WooCommerce to sanda: what to prepare, the fields the connection form asks for, and how its data lands in your warehouse.

View as Markdown

Connect WooCommerce

  1. Open the catalogue. In the console, go to Data · Connections and press New connection.
  2. Choose WooCommerce. It is listed under commerce; you can also search for it by name.
  3. Fill in the form. Enter the fields below. Credentials go straight to sanda’s sync engine and are never stored in sanda’s database.
  4. Choose what to sync. Pick the streams you want, and a sync mode for each. See choose what to sync.
  5. Run the first sync. sanda tests the connection, then lands each stream as a table in your warehouse.

Configuration fields

What the connection form asks for. Required fields are marked; the rest are optional.

Field Type Required Description
Customer Key string, secret Yes Customer Key for API in WooCommerce shop.
Customer Secret string, secret Yes Customer Secret for API in WooCommerce shop.
Shop Name string Yes The name of the store. For https://EXAMPLE.com, the shop name is 'EXAMPLE.com'.
Start Date string Yes The date you would like to replicate data from. Format: YYYY-MM-DD.
Number of Concurrent Threads integer No The number of worker threads to use for the sync. Higher values can speed up syncs but may hit rate limits. WooCommerce API rate limits depend on the hosting provider. Default 5.

Something unclear or out of date? Tell us, and we will fix the page.