WooCommerce

WooCommerce is an open source e-commerce wordpress plugin designed to sell your products online and expand your business.

Sync WooCommerce data to Sourcetable

Build reports once. Connect to WooCommerce and start modeling from live data.

Popular Use Cases

WooCommerce connector Sourcetable connector
Get an active list of all WooCommerce orders
WooCommerce + Sourcetable
WooCommerce connector Sourcetable connector
Automate WooCommerce reports without writing code
WooCommerce + Sourcetable
WooCommerce connector Sourcetable connector
Analyze customer LTV using WooCommerce order history
WooCommerce + Sourcetable
WooCommerce connector Marketo connector
Calculate CAC by lead source using WooCommerce order history and Marketo marketing data
WooCommerce + Marketo
WooCommerce connector Mailchimp connector
Determine the effectiveness of newsletter campaigns using Mailchimp lists and WooCommerce order history
WooCommerce + Mailchimp
Here's a sample of the WooCommerce data that will be available in your Sourcetable spreadsheets:
actionscheduler_actions

Contains the information about the actions which Action Schedular will be executing

actionscheduler_claims
actionscheduler_groups
actionscheduler_logs

Contains the logging information about the action schedular

woocommerce_sessions

Contains the session data of a customer like carts

woocommerce_api_keys

Contains the API keys that can be used to call REST API

woocommerce_attribute_taxonomies

Contains the global attribute taxonomy names for products

woocommerce_downloadable_product_permissions

Contains the product access permissions that are granted after the purchase of downloadable products

woocommerce_order_items

Contains the line items that are associated with the orders

woocommerce_order_itemmeta

Contains the metadata information of order line items

woocommerce_tax_rates

Contains the information about the tax rates applicable and can be applied from the admin area

woocommerce_tax_rate_locations

Contains locations (postcodes and cities) that are associated with the tax rates

woocommerce_shipping_zones

Contains the information about the shipping zones and can set under the admin area

woocommerce_shipping_zone_locations

Contains the location information that are assocaited with the shipping zone

woocommerce_shipping_zone_methods

Contains the shipping methods that are assocaited with the shipping zone

woocommerce_payment_tokens

Contains the customer payment tokens that are used by gateways

woocommerce_payment_tokenmeta

Contains the metadata information of payment tokens

woocommerce_log

Contains the logging information of woocommerce

wc_webhooks

Contains the webhook information that have been setup on the store

wc_download_log

Contains the logging information about the user downloads of downloadable products

wc_product_meta_lookup

Contains the metadata on which indexing is done in order to speed up requests

wc_tax_rate_classes

Contains the tax classes data

wc_reserved_stock

Contains the reserved stock that can be used to prevent the race conditions that may arise during checkout