# 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

1. Create a new dataset in Scoop
2. Select **WooCommerce** from the application list
3. Enter your WordPress store URL (e.g., `mystore.com`)
4. Enter your Consumer Key and Consumer Secret
5. Choose your analysis template or customize
6. Save and extract data

## Getting API Credentials

1. Log in to your WordPress admin panel
2. Go to **WooCommerce** > **Settings** > **Advanced** > **REST API**
3. Click **Add Key**
4. Enter a description (e.g., "Scoop Analytics")
5. Select **Read** permissions
6. Click **Generate API Key**
7. 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) |
| Email | 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