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: woocommerce automation
Availability: InStock

- 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

安装

Every 15 min

Every 4 hours

simple, variable, grouped, external