Sync WooCommerce data to Sourcetable
WooCommerce
All your business data, synced in a spreadsheet.
Find out how to make the most of your WooCommerce data with Sourcetable
Sourcetable Benefits
Data & analytics
Reliable data is crucial for tracking your store’s performance over time, and modifying your approach for retaining and converting customers as required. WooCommerce’s data can be synced to Sourcetable so you can successfully keep track of your business via a complete data overview, and reports covering orders, revenue, shipping figures, taxes and much more.
Accessibility
Syncing your WooCommerce data to Sourcetable keeps it centralized and accessible. Everyone on your team will be able to track your website’s sales performance quickly and easily, without having to learn to code.
Reliability
Sourcetable brings together key data from WooCommerce and other platforms quickly and intuitively, giving our users fresh and reliable insights into their e-commerce’s performance at all times.
Visualizations
Sourcetable comes with a full suite of visualization tools for all your reporting needs - bar charts, line graphs, burn charts, mapping, scatter plots, and more. Create visually striking live dashboards to share with your team and identify the metrics that matter.
Find out how to get the most from WooCommerce with Sourcetable
Smart Templates
Use out of the box tried and tested templates in order to merge databases and improve data collaboration across your entire organisation
Quick Analysis
Analyze your WooCommerce data alongside cost data and marketing insights from other e-commerce platforms, and access cross channel reports in the blink of an eye
Ease Of use
Compile all your WooCommerce data into one spreadsheet so you can query it and find the business intelligence behind the numbers
Who uses WooCommerce data in Sourcetable
📈 Marketing and Advertising professionals
👷🏿 Sales and Sales Ops folk
🚀 Founders
🏢 Ecommerce businesses
Here's a sample of 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
Sample companies
Online businesses integrating WooCommerce with Sourcetable have access to all relevant data on orders, purchases, skus, refunds, support tickets and signups.
-
Retail online stores
(eCommerce) -
Retail offline stores
-
Small to Medium
sized businesses -
B2B Platforms
-
Software as a Service
(SaaS) companies -
B2C Marketplaces
-
Subscription services
Popular Use Reports & Use Cases
Get an active list of all WooCommerce orders
WooCommerce + Sourcetable
Automate WooCommerce reports without writing code
WooCommerce + Sourcetable
Analyze customer LTV using WooCommerce order history
WooCommerce + Segment
Calculate CAC by lead source using WooCommerce order history and Marketo marketing data
WooCommerce + Marketo
Determine the effectiveness of newsletter campaigns using Mailchimp lists and WooCommerce order history
WooCommerce + Mailchimp
What makes Sourcetable special?
Interconnectivity
Connect, sync and query your WooCommerce data with data from 30+ other sources, no knowledge of SQL required.
Collaboration
Create views and workflow templates to drive decisions and improve business performance based on your WooCommerce data
Automation
Automate your WooCommerce data so you can focus on what matters most: selling your product
Frequently Asked Questions
How do I sync my WooCommerce data to Sourcetable?
How easy is it to visualize my WooCommerce data using Sourcetable?
Which payment service integrations are available to sync with WooCommerce on Sourcetable?