om-scogo WooCommerce Automation
Comprehensive skill for automating WooCommerce store operations and workflows.
Core Workflows
1. Order Processing Pipeline
ORDER FLOW:
┌─────────────────┐
│ New Order │
│ Received │
└────────┬────────┘
▼
┌─────────────────┐
│ Validate │
│ - Payment │
│ - Inventory │
│ - Fraud check │
└────────┬────────┘
▼
┌─────────────────┐
│ Process │
│ - Confirm │
│ - Reserve stock│
│ - Notify │
└────────┬────────┘
▼
┌─────────────────┐
│ Fulfill │
│ - Pick & pack │
│ - Ship │
│ - Track │
└────────┬────────┘
▼
┌─────────────────┐
│ Complete │
│ - Deliver │
│ - Follow-up │
└─────────────────┘
2. Order Status Automations
order_automations:
- trigger: order_placed
conditions:
payment_status: completed
actions:
- set_status: processing
- send_email: order_confirmation
- create_fulfillment_task
- update_inventory
- trigger: order_shipped
actions:
- set_status: shipped
- send_email: shipping_notification
- add_tracking_note
- trigger: order_delivered
actions:
- set_status: completed
- schedule_review_request:
delay: 7_days
- update_customer_stats
- trigger: payment_failed
actions:
- set_status: on-hold
- send_email: payment_failed
- create_followup_task
Product Management
Inventory Sync
inventory_sync:
sources:
- name: warehouse_a
type: api
sync_frequency: "*/15 * * * *" # Every 15 min
- name: supplier_feed
type: ftp
file_pattern: "inventory_*.csv"
sync_frequency: "0 */4 * * *" # Every 4 hours
rules:
- condition: quantity <= low_stock_threshold
actions:
- set_stock_status: "onbackorder"
- send_alert: low_stock
- create_purchase_order
- condition: quantity == 0
actions:
- set_stock_status: "outofstock"
- hide_from_catalog: false
- show_back_in_stock_form: true
Product Data Structure
product_template:
name: "{{product_name}}"
type: "simple" # simple, variable, grouped, external
general:
regular_price: "{{price}}"
sale_price: "{{sale_price}}"
sku: "{{sku}}"
inventory:
manage_stock: true
stock_quantity: "{{quantity}}"
backorders: "notify"
low_stock_threshold: 5
shipping:
weight: "{{weight}}"
dimensions:
length: "{{length}}"
width: "{{width}}"
height: "{{height}}"
shipping_class: "{{shipping_class}}"
attributes:
- name: "Color"
values: ["Red", "Blue", "Green"]
visible: true
variation: true
- name: "Size"
values: ["S", "M", "L", "XL"]
visible: true
variation: true
categories: ["{{category}}"]
tags: ["{{tags}}"]
images:
- src: "{{image_url}}"
alt: "{{image_alt}}"
Bulk Product Updates
bulk_operations:
- name: price_increase
filter:
category: "electronics"
stock_status: "instock"
action:
update_price:
type: percentage
value: 10
- name: sale_promotion
filter:
tag: "summer_sale"
action:
set_sale_price:
discount: 25
schedule:
start: "2024-06-01"
end: "2024-06-30"
- name: update_shipping
filter:
weight_greater_than: 5
action:
set_shipping_class: "heavy_items"
Customer Management
Customer Segments
customer_segments:
- name: vip_customers
criteria:
total_spent: ">= 1000"
order_count: ">= 5"
actions:
- assign_role: "vip_customer"
- apply_discount: 15
- send_vip_welcome
- name: at_risk
criteria:
last_order: "> 90 days"
total_spent: ">= 200"
actions:
- add_tag: "at_risk"
- send_win_back_campaign
- name: first_time_buyers
criteria:
order_count: 1
registered: "< 30 days"
actions:
- send_onboarding_series
- offer_second_purchase_discount
Customer Lifecycle Emails
email_automation:
welcome_series:
- delay: 0
template: welcome_email
subject: "Welcome to {{store_name}}!"
- delay: 3_days
template: product_highlights
subject: "Our Best Sellers You'll Love"
- delay: 7_days
template: first_purchase_offer
subject: "Special Offer: 10% Off Your First Order"
post_purchase:
- delay: 0
trigger: order_completed
template: order_confirmation
- delay: 3_days
template: shipping_update
condition: order_status == "shipped"
- delay: 14_days
template: review_request
condition: order_status == "completed"
win_back:
- delay: 30_days
condition: no_order_since
template: miss_you_email
subject: "We Miss You! Here's 15% Off"
- delay: 60_days
condition: no_order_since
template: last_chance
subject: "Last Chance: 20% Off Just for You"
Marketing Automation
Coupon Management
coupon_automations:
- name: birthday_coupon
trigger: customer_birthday
coupon:
type: percent
amount: 20
individual_use: true
usage_limit: 1
expiry: 30_days
notification:
email_template: birthday_coupon
- name: abandoned_cart_coupon
trigger: cart_abandoned
delay: 24_hours
coupon:
type: percent
amount: 10
minimum_amount: 50
expiry: 7_days
notification:
email_template: abandoned_cart
- name: loyalty_reward
trigger: order_count_reached
threshold: 10
coupon:
type: fixed_cart
amount: 25
individual_use: true
Cart Recovery
cart_recovery:
triggers:
- cart_abandoned_minutes: 60
- cart_value_minimum: 30
sequence:
- delay: 1_hour
template: cart_reminder_1
subject: "You left something behind..."
include_cart_items: true
- delay: 24_hours
template: cart_reminder_2
subject: "Your cart is waiting"
include_discount: false
- delay: 72_hours
template: cart_reminder_3
subject: "Last chance + 10% off"
include_discount: true
discount_code: "COMEBACK10"
Analytics & Reporting
Sales Dashboard
SALES OVERVIEW - LAST 30 DAYS
═══════════════════════════════════════
Revenue: $45,230 (+12.5%)
Orders: 892 (+8.3%)
AOV: $50.70 (+3.9%)
Conversion: 3.2% (+0.4%)
TOP PRODUCTS:
┌────────────────────────┬────────┬─────────┐
│ Product │ Sold │ Revenue │
├────────────────────────┼────────┼─────────┤
│ Premium Widget │ 245 │ $12,250 │
│ Standard Package │ 189 │ $7,560 │
│ Deluxe Bundle │ 156 │ $9,360 │
└────────────────────────┴────────┴─────────┘
SALES BY CHANNEL:
Direct ██████████████░░ 65%
Organic ████████░░░░░░░░ 22%
Paid ████░░░░░░░░░░░░ 10%
Referral █░░░░░░░░░░░░░░░ 3%
Inventory Report
inventory_report:
metrics:
- total_products: 1,234
- in_stock: 1,089
- out_of_stock: 98
- low_stock: 47
alerts:
- type: out_of_stock
products: 98
action: reorder_required
- type: low_stock
products: 47
threshold_days: 14
- type: overstock
products: 23
recommendation: run_promotion
API Integration Examples
WooCommerce REST API
// Create Order
const order = {
payment_method: "bacs",
payment_method_title: "Direct Bank Transfer",
set_paid: true,
billing: {
first_name: "John",
last_name: "Doe",
email: "john@example.com",
address_1: "123 Main St",
city: "San Francisco",
state: "CA",
postcode: "94103",
country: "US"
},
line_items: [
{
product_id: 93,
quantity: 2
}
],
shipping_lines: [
{
method_id: "flat_rate",
method_title: "Flat Rate",
total: "10.00"
}
]
};
// Update Product Stock
const updateStock = {
stock_quantity: 100,
manage_stock: true
};
// Create Coupon
const coupon = {
code: "SAVE20",
discount_type: "percent",
amount: "20",
individual_use: true,
exclude_sale_items: true,
minimum_amount: "50.00"
};
Best Practices
- Automate Status Updates: Keep customers informed
- Sync Inventory Real-time: Prevent overselling
- Segment Customers: Personalize marketing
- Recover Abandoned Carts: Capture lost revenue
- Monitor Stock Levels: Set low-stock alerts
- Optimize Email Timing: Test send times
- Track Conversions: Measure marketing ROI
- Backup Regularly: Protect order data