WooCommerce Orders to Inventory Updates

# WooCommerce Orders to Inventory Updates

## Purpose
Deploy to maintain accurate stock levels across your online store and warehouse, preventing overselling and stockouts.

## When to Use
Automatically adjust inventory levels in your stock management system when WooCommerce orders are placed, cancelled, or refunded.

## Instructions
1. Review the template below and familiarise yourself with the structure
2. Replace all [bracketed placeholders] with your business details
3. Customise the tone and formatting to match your brand
4. Save in your preferred tool (WooCommerce or Xero)

---

## WooCommerce Orders to Inventory Updates

### Overview
Automatically adjust inventory quantities in your stock management system (Xero, Airtable, or Google Sheets) when WooCommerce orders are placed, cancelled, or refunded, ensuring accurate stock levels across all channels.

### Prerequisites
- WooCommerce store with inventory management enabled (any hosting)
- Xero account with inventory tracking enabled, OR Google Sheets for simpler setups
- Zapier account (Professional plan for multi-step Zaps)
- WooCommerce REST API credentials (Consumer Key and Consumer Secret)
- Product SKUs consistent between WooCommerce and your inventory system

### Setup Steps

**Step 1: Enable inventory management in WooCommerce**
- Go to WooCommerce > Settings > Products > Inventory
- Check "Enable stock management"
- Set "Low stock threshold" to your preferred reorder point (e.g., 10 units)
- Ensure each product has a SKU assigned

**Step 2: Prepare your inventory tracking system**
**If using Xero:**
- Enable inventory tracking in Xero (Settings > General Settings > Inventory)
- Create tracked inventory items with matching SKUs
- Set up a "Stock on Hand" account in your chart of accounts

**If using Google Sheets:**
- Create a spreadsheet with columns: SKU, Product Name, Current Stock, Last Updated
- Pre-populate with your current inventory levels

**Step 3: Create the Order Placed Zap**
Log in to Zapier and click "Create Zap". Name it "WooCommerce Order - Reduce Inventory".

**Step 4: Configure the WooCommerce trigger**
- App: WooCommerce
- Trigger event: "New Order" (status: Processing or Completed)
- Account: Connect using your WooCommerce REST API credentials
- Test: Place a test order on your store

**Step 5: Handle line items**
WooCommerce orders can contain multiple products. Use a Zapier "Looping by Zapier" step:
- Loop through each line item in the order
- For each item, extract: SKU, Quantity, Product Name

**Step 6: Configure the inventory update action**

**For Xero:**
- App: Xero
- Action: "Update Inventory Item"
- Match on: SKU
- Quantity change: Reduce by order quantity

**For Google Sheets:**
- App: Google Sheets
- Action: "Update Spreadsheet Row" (Lookup by SKU)
- Quantity: =Current Stock - Order Quantity

**Step 7: Map fields**

| WooCommerce Field | Inventory Field | Notes |
|------------------|-----------------|-------|
| Line Item SKU | Product SKU | Must match exactly |
| Line Item Quantity | Quantity to Deduct | Negative adjustment |
| Order Number | Reference | Track which order caused the adjustment |
| Order Date | Last Updated | Timestamp of the change |
| Product Name | Product Name | For verification |

**Step 8: Create a Cancellation/Refund Zap**
Create a second Zap named "WooCommerce Refund - Restore Inventory":
- Trigger: WooCommerce "Order Refunded" or "Order Cancelled"
- Action: Add the quantity back to inventory (positive adjustment)
- Use the same SKU matching logic as the order Zap

**Step 9: Add low stock alerts**
Create a third Zap:
- Trigger: Scheduled check (daily at 8:00 AM AEST)
- Action: Check inventory levels against threshold
- If below threshold: Send Slack notification or email to your purchasing team

**Step 10: Test the integration**
1. Place a test order with 2 different products
2. Verify stock levels decrease by the correct quantities
3. Cancel the test order
4. Verify stock levels are restored
5. Manually set a product below the low stock threshold and verify the alert fires

### Error Handling
- **SKU not found:** If a WooCommerce SKU does not match your inventory system, log the error and send a notification. Do not skip silently.
- **Negative stock:** Configure your inventory system to allow negative values temporarily but alert immediately.
- **Overselling:** WooCommerce's built-in stock management prevents overselling on the website, but this Zap ensures your external systems stay current.
- **Variable products:** Ensure each variation in WooCommerce has a unique SKU that maps to your inventory system.

### Maintenance
- Conduct a full physical stocktake quarterly and reconcile against system quantities
- Review and resolve any SKU mismatches monthly
- Adjust low stock thresholds seasonally based on sales velocity
- Add new product SKUs to your inventory system before listing them in WooCommerce

---

**Complexity:** intermediate | **Setup time:** 20 minutes | **Tools:** WooCommerce, Xero, Zapier