WooCommerce + Orcabase
Your WooCommerce store, in plain answers.
Sync your WooCommerce orders, products and customers through Fivetran and ask about sales, repeat buyers and coupons in plain words, without another report plugin.
- Synced by Fivetran
- Syncs every 6 hours
- No Fivetran account needed
What’s our repeat purchase rate, month by month?
34% of customers ordered again in August, up from 29% in March.
- Customers who started with the sampler repeat most.
- Most second orders come three to five weeks after the first.
- Customers who used the welcome coupon repeat least.
Repeat purchase rate by month, %
How I got this· 4 steps
- Looked at your WooCommerce orders and customers
- Found each customer’s first order
- Checked for a second order within 90 days
- Split repeat buyers by first product and coupon
Example answer. Numbers are illustrative.
In plain words
How do I get better WooCommerce reports?
WooCommerce’s reports cover the basics, and plugins add more. Orcabase takes a different route: Fivetran copies your orders, products and customers into a database Orcabase hosts for you, and you ask about them in plain words.
Your store keeps running as usual, and its data sits next to your ads, emails and payments.
Ask in plain words
What you can ask about your WooCommerce data
The agent answers with the number, a chart and the steps it took. Keep the good answers on a dashboard.
What sold best this month?
Which coupons bring customers who come back?
How many orders did we get each day last week?
What’s our average order value, month by month?
Which customers spend the most?
What share of orders are refunded?
Which products are often bought together?
Show me orders by country.
What comes in
Your WooCommerce data, ready to ask about.
A copy in a database Orcabase hosts for you, with its own folder for each app.
Orders
Products
Customers
Coupons and refunds
Numbers worth defining
Define them once. Every answer agrees.
Tell Orcabase what each number means, certify it, and your dashboards, the agent and your whole team use the same one. The agent can draft these from your WooCommerce data.
Revenue
Orders minus refunds, without tax and shipping.
Repeat purchase rate
Share of customers who order again within 90 days.
Average order value
Revenue divided by the number of orders.
Coupon rate
Share of orders that used a coupon.
Dashboards to start with
Your WooCommerce numbers at a glance.
Ask the agent to build one of these, or pin charts yourself. Share any dashboard with a link.
Store
4 charts- Revenue by day
- Best sellers
- Average order value
- Coupon rate
Customers
3 charts- New vs returning
- Repeat purchase rate
- Top customers
Better together
Ask across WooCommerce and the rest of your business.
The best questions need more than one app. The agent can pull from several sources for one answer.
How to connect
Connect WooCommerce, step by step.
- 1
Find it in Sync data
In Orcabase, go to Sync data → Add source and search for WooCommerce. Pick the database to sync into.
- 2
Connect WooCommerce on Fivetran’s page
Fivetran’s page asks for your store’s address and a WooCommerce API key and secret, which you create under WooCommerce → Settings → Advanced → REST API.
- 3
Choose what to sync
Back in Orcabase, tick the data you want. Only what you pick is synced, and only it counts toward your allowance.
- 4
Ask away
The first sync starts straight away. When it’s done, ask the agent about your WooCommerce data.
What you’ll need
- Access to your WordPress admin, to create a WooCommerce API key.
- The Admin role in Orcabase, and data hosting: Fivetran writes into a database Orcabase hosts for you.
- How it connects
- Synced by Fivetran
- How fresh
- Every 6 hours, as standard.
- Where your data lives
- A copy in a database Orcabase hosts for you, with its own folder for each app.
- Who can set it up
- An admin in your organization.
- Your login
- You sign in on Fivetran’s own page. Orcabase never sees your password or keys.
- Cost
- Counts toward your monthly sync allowance: 500,000 changed rows a month, as standard.
Does it work wherever my store is hosted?
Can Orcabase change orders or products?
Do I need a Fivetran account?
How fresh is my WooCommerce data in Orcabase?
What does syncing cost?
Your WooCommerce data already has the answers.
Connect it, ask your first question, and pin the answers you want to see every week.