Connecting to Data · Legacy self-service product
WooCommerce
Analyze orders, products, and e-commerce performance
Connect WooCommerce to Scoop to analyze your WordPress e-commerce data, track order trends, understand product performance, and measure customer lifetime value.
AI-Assisted Setup
When connecting WooCommerce to Scoop, choose "Guide me with AI" for an intelligent, guided setup experience.
Available Analysis Templates
| Template | Object | Data Mode | Best For | What You'll Analyze |
|---|---|---|---|---|
| Order Analytics (Default) | orders | Snapshot | Revenue & fulfillment | Order totals, discounts, status |
| Product Catalog | products | Sync | Inventory | Pricing, stock, categories |
| Customer Analysis | customers | Sync | Customer LTV | Orders count, total spent |
| Discount Performance | coupons | Sync | Promotions | Coupon usage, effectiveness |
Example Questions You Can Answer
Sales & Revenue:
- "What's our daily/weekly/monthly revenue trend?"
- "How much are we collecting in tax and shipping?"
- "What's our average order value over time?"
- "How are discounts impacting our revenue?"
- "Which payment methods are most popular?"
Order Fulfillment:
- "How many orders are pending vs completed?"
- "What's our order completion rate?"
- "How long do orders take to complete?"
- "What's our refund rate?"
Customer Analysis:
- "Who are our highest-value customers?"
- "What's the distribution of customer lifetime value?"
- "How many repeat customers do we have?"
- "What's our customer acquisition trend?"
Product Performance:
- "Which products are low on stock?"
- "What's our price distribution across categories?"
- "How many products are on sale?"
- "Which categories have the most products?"
Coupon Effectiveness:
- "Which coupons are used most?"
- "What's the average discount amount?"
- "How many coupons have expired unused?"
- "Which coupons drive the most revenue?"
Need Something Different?
If the templates above don't match your needs, select "Something else" and describe what you want to analyze. For example:
- "I want to track revenue by product category"
- "I need to see refund trends"
- "I want to analyze which coupons drive the most sales"
Scoop's AI will recommend the right configuration for your specific use case.
Snapshotting for Order Analysis
Orders change over time - status updates, refunds are issued. Configure your Orders extract as a Snapshot dataset to:
- Track order status progression
- Monitor refund rates over time
- Analyze fulfillment velocity
- Compare performance week-over-week
Pro Tip: Enable snapshotting on day one for orders to track how orders move through statuses and identify fulfillment bottlenecks.
Connecting WooCommerce to Scoop
- Create a new dataset in Scoop
- Select WooCommerce from the application list
- Enter your WordPress store URL (e.g.,
mystore.com) - Enter your Consumer Key and Consumer Secret
- Choose your analysis template or customize
- Save and extract data
Getting API Credentials
- Log in to your WordPress admin panel
- Go to WooCommerce > Settings > Advanced > REST API
- Click Add Key
- Enter a description (e.g., "Scoop Analytics")
- Select Read permissions
- Click Generate API Key
- Copy both the Consumer Key and Consumer Secret
Important: Store these credentials securely - the Consumer Secret is only shown once. If lost, you'll need to generate a new key.
What Data You Get
Orders
Complete order data including totals, status, and customer info.
| Field | Description |
|---|---|
| Order ID | Unique identifier (prefixed with WC) |
| Order Number | Customer-facing number |
| Status | pending, processing, on-hold, completed, cancelled, refunded, failed |
| Total | Order total |
| Tax | Tax amount |
| Discount | Discount total |
| Shipping | Shipping cost |
| Created Date | When placed |
| Completed Date | When fulfilled |
| Customer ID | Associated customer (0 = guest) |
| Billing Email | Customer email |
| Payment Method | How customer paid |
| Line Items Count | Number of products |
Products
Your full product catalog.
| Field | Description |
|---|---|
| Product ID | Unique identifier (prefixed with WC) |
| Name | Product name |
| Type | simple, variable, grouped, external |
| Status | publish, draft, pending, private |
| SKU | Stock keeping unit |
| Price | Current price |
| Regular Price | Non-sale price |
| Sale Price | Discounted price |
| Stock Quantity | Inventory level |
| Stock Status | instock, outofstock, onbackorder |
| Categories | Product categories |
Customers
Registered customer database.
| Field | Description |
|---|---|
| Customer ID | Unique identifier (prefixed with WC) |
| Customer email | |
| First Name | Given name |
| Last Name | Family name |
| Username | WordPress username |
| Created Date | Registration date |
| Orders Count | Total orders placed |
| Total Spent | Customer lifetime value |
| City/State/Country | Location info |
Coupons
Discount code configuration and usage.
| Field | Description |
|---|---|
| Coupon ID | Unique identifier (prefixed with WC) |
| Code | The coupon code |
| Discount Type | percent, fixed_cart, fixed_product |
| Amount | Discount value |
| Expiration Date | When coupon expires |
| Usage Count | Times redeemed |
| Usage Limit | Maximum redemptions |
| Free Shipping | Grants free shipping? |
| Minimum Amount | Minimum order required |
Analysis Examples
Revenue Trends
Track daily, weekly, or monthly revenue with breakdowns by:
- Payment method
- Order status
- Discount impact
- Shipping costs
Customer Lifetime Value
Segment customers by:
- Total spent tiers
- Order frequency
- Geographic region
- Registration cohort
Inventory Health
Monitor your catalog:
- Stock levels by category
- Products approaching out-of-stock
- Price distribution
- Sale product performance
Promotion Effectiveness
Analyze your coupons:
- Usage rates by coupon type
- Revenue driven by discounts
- Free shipping impact
- Expiration effectiveness
Best Practices
- Start with Orders: The orders object contains the richest transactional data
- Enable Snapshotting: Track how orders progress through fulfillment
- Combine with Customers: Link orders to customers for LTV analysis
- Monitor Inventory: Track stock levels alongside sales
Troubleshooting
Connection Issues
- Verify your store URL is correct (include https:// if needed)
- Ensure your Consumer Key has Read permissions
- Check that the REST API is enabled in WooCommerce settings
- Verify your site has SSL if using HTTPS
Missing Data
- Guest orders show customer_id = 0
- Some features require specific WooCommerce extensions
- Order history may be limited by hosting/database size
API Keys
- Consumer Secret is only shown once when created
- If you lose it, create a new key
- Use Read-only permissions for security