Advance Import and Export for WooCommerce DocumentationAdvance Import and Export for WooCommerce Documentation
Buy Now
View Demo
  • Getting Started

    • Introduction
    • Quick Start
    • Features
    • Installation
    • First-Time Setup
    • CSV Preparation
    • Sample Files
    • Use Cases
    • Common Mistakes
  • Tutorials

    • Google Sheets Live Sync
    • Shopify Migration
    • Daily Backup to S3
    • Multi-Store Sync
  • Using the Plugin

    • Dashboard
    • Quick Import Wizard
    • Quick Export
    • Settings
    • Compatibility
  • Import In Detail

    • Import Sources
    • Import Modes
    • Column Mapping
    • Transformations
    • Migration Presets
    • Delta Import
  • Export In Detail

    • Export Features
    • Export Destinations
    • Browser Download
    • Server Path (REST / CLI)
  • Data Types

    • Products
    • Variable Products
    • Orders
    • Customers
    • Categories & Tags
    • Coupons
    • Reviews
    • Posts
    • Pages
    • Users
    • Subscriptions
    • Bookings
    • Memberships
    • Menus
  • Automation

    • Scheduled Jobs
    • History & Logs
    • Rollback
    • Health Check
  • Cloud Service Setup

    • Google API Setup
    • Amazon S3 Setup
    • Dropbox Setup
    • Email / SMTP Setup
  • Server Configuration

    • PHP Configuration
    • Server Cron Setup
    • Image Handling
  • Developer

    • REST API
    • WP-CLI Commands
  • Compare

    • vs WP All Import
    • vs Product Import Export (WebToffee)
  • Help

    • Troubleshooting
    • FAQ
    • Glossary
    • Security
    • Changelog
Support
Buy Now
View Demo
  • Getting Started

    • Introduction
    • Quick Start
    • Features
    • Installation
    • First-Time Setup
    • CSV Preparation
    • Sample Files
    • Use Cases
    • Common Mistakes
  • Tutorials

    • Google Sheets Live Sync
    • Shopify Migration
    • Daily Backup to S3
    • Multi-Store Sync
  • Using the Plugin

    • Dashboard
    • Quick Import Wizard
    • Quick Export
    • Settings
    • Compatibility
  • Import In Detail

    • Import Sources
    • Import Modes
    • Column Mapping
    • Transformations
    • Migration Presets
    • Delta Import
  • Export In Detail

    • Export Features
    • Export Destinations
    • Browser Download
    • Server Path (REST / CLI)
  • Data Types

    • Products
    • Variable Products
    • Orders
    • Customers
    • Categories & Tags
    • Coupons
    • Reviews
    • Posts
    • Pages
    • Users
    • Subscriptions
    • Bookings
    • Memberships
    • Menus
  • Automation

    • Scheduled Jobs
    • History & Logs
    • Rollback
    • Health Check
  • Cloud Service Setup

    • Google API Setup
    • Amazon S3 Setup
    • Dropbox Setup
    • Email / SMTP Setup
  • Server Configuration

    • PHP Configuration
    • Server Cron Setup
    • Image Handling
  • Developer

    • REST API
    • WP-CLI Commands
  • Compare

    • vs WP All Import
    • vs Product Import Export (WebToffee)
  • Help

    • Troubleshooting
    • FAQ
    • Glossary
    • Security
    • Changelog
Support
  • Getting Started

    • Introduction
    • Quick Start — Your First Import in 5 Minutes
    • Features — Full Tour
    • Installation — Full Setup Guide
    • First-Time Setup — Complete Checklist
    • CSV Preparation — How to Make a Good Import File
    • Sample Files — Download Ready-to-Use Templates
    • Use Cases — "I Want To..." Quick Reference
    • Common Mistakes — Things To Watch Out For
  • Tutorials

    • Tutorial — Google Sheets Live Sync
    • Tutorial — Migrate from Shopify to WooCommerce
    • Tutorial — Daily Backup to Amazon S3
    • Tutorial — Sync Between Two WooCommerce Stores
  • Using the Plugin

    • Dashboard — What You See First
    • Quick Import Wizard — 5 Steps to Import Any File
    • Quick Export — One-Page Export Tool
    • Settings — Every Option Explained
    • Compatibility — Third-Party Plugin Support
  • Import In Detail

    • Import Sources — 11 Ways to Pull Data In
    • Import Modes — Create, Update, Delete, Replace
    • Column Mapping — Connect Your Columns to WooCommerce
    • Transformations — Change Values During Import
    • Migration Presets — Move From Shopify, Magento, BigCommerce
    • Delta Import — Skip Unchanged Rows
  • Export In Detail

    • Export Features
    • Export Destinations — Where Your Files Go
    • Export Download — One-Click Browser Download
    • Export to Server Path — WP-CLI
  • Data Types

    • Products Import — Full Field Reference
    • Variable Products — The Complete Guide
    • Orders Import — Historical Orders and Line Items
    • Customers Import — With Addresses and Notes
    • Categories and Tags Import
    • Coupons Import — Discount Codes
    • Reviews Import — Product Reviews and Ratings
    • Posts Import — WordPress Blog Posts
    • Pages Import — WordPress Pages
    • Users Import — WordPress User Accounts
    • Subscriptions Import — WooCommerce Subscriptions
    • Bookings Import — WooCommerce Bookings
    • Memberships Import — WooCommerce Memberships
    • Menus Import — WordPress Navigation Menus
  • Automation

    • Jobs — Saved and Scheduled Imports and Exports
    • History — Every Run You Have Ever Done
    • Rollback — Undo Any Import in One Click
    • Health Check — Data Integrity Checks With Auto-Fix
  • Cloud Service Setup

    • Google API Setup — Sheets, Drive, OAuth
    • Amazon S3 Setup — IAM User and Bucket Permissions
    • Dropbox Setup — API Token for Private Files
    • Email Setup — Making Notifications Actually Work
  • Server Configuration

    • PHP Configuration — Memory, Execution Time, Upload Size
    • Server Cron Setup — Reliable Scheduled Imports
    • Image Handling — Download, Resize, Watermark
  • Developer

    • REST API — Developer Reference
    • WP-CLI Commands — Command Line Automation
  • Compare

    • Advance Import and Export vs WP All Import
    • Advance Import and Export vs Product Import Export for WooCommerce
  • Help

    • Troubleshooting — Fix Common Problems
    • FAQ — Common Questions
    • Glossary — Every Term Explained
    • Security — How Your Data Is Protected
    • Changelog — What Changed

Tutorial — Multi-Store Sync

In this tutorial, you will keep two WooCommerce stores in sync. Products added on Store A automatically appear on Store B.

Scenario

You run:

  • Store A (master) — your main store where products are created
  • Store B (secondary) — mirror store (maybe a wholesale version, a different region, a staging site)

You want:

  • New products on A → auto-appear on B
  • Price changes on A → auto-update on B
  • Stock changes on A → auto-update on B

Time Required

About 30 minutes.

Prerequisites

  • Both stores have WordPress + WooCommerce
  • Both stores have this plugin installed
  • Both stores have admin access
  • Basic REST API knowledge

Part 1 — Generate REST API Keys on Store A

Store A will be the data source. Store B will pull from it.

Step 1

On Store A: WooCommerce → Settings → Advanced → REST API → Add key.

Step 2

Fill in:

FieldValue
DescriptionStore B Sync
UserAdmin account
PermissionsRead (read-only is enough for pulling)

Click Generate API key.

Step 3

Copy both keys immediately:

  • Consumer key — like ck_abc123...
  • Consumer secret — like cs_xyz789...

Store B will use these to connect.

Part 2 — Set Up Pull Job on Store B

Store B will pull products from Store A every hour.

Step 1

On Store B: Webkul WC Addons → Jobs → Add New.

Step 2 — Tab 1: Source / Destination

Job Editor 6-tab layoutThe Job Editor's 6 tabs hold the full sync configuration — Source, Mapping, Transformations, Schedule, Notifications, Run & Results.

Fill in:

FieldValue
Job TypeImport
Job TitlePull from Store A
Entity TypeProducts
Import ModeCreate + Update
File FormatJSON
Source TypeWooCommerce REST API

In the WC REST API panel:

FieldValue
Remote Store URLhttps://store-a.com (Store A's URL)
Consumer Keypaste from Part 1
Consumer Secretpaste from Part 1

Click Test Connection to verify.

Step 3 — Tab 2: Column Mapping

Should auto-map. Verify:

Source (WC API)Target (Store B)
skuSKU
nameName
regular_priceRegular price
sale_priceSale price
stock_quantityStock
categoriesCategories
imagesImages

Step 4 — Tab 3: Transformations

Optional. Common tweaks:

  • Add 20% markup if Store B has higher prices
  • Translate values if Store B is in a different language

Step 5 — Tab 4: Schedule

FieldValue
ScheduleHourly
Delta ImportYes (only process changed items)

Step 6 — Tab 5: Notifications

  • Send on Failure: Yes
  • Recipients: [email protected]

Step 7 — Save

Click Save.

Jobs page with sync jobYour saved sync job appears in the Jobs grid — enable the schedule, or hit Run Now to test immediately.

Part 3 — Test the Sync

Step 1 — Run Manually

Jobs page → Pull from Store A → Run Now.

Watch the progress. Takes a while on the first run (no delta yet).

Step 2 — Verify on Store B

WooCommerce → Products on Store B. You should see all products from Store A.

Step 3 — Test a Change

  1. On Store A: edit a product, change the price
  2. Wait up to 1 hour for cron, or click Run Now on Store B
  3. On Store B: verify the price updated

Part 4 — Set Up Server Cron on Store B

WordPress cron is unreliable. See Server Cron Setup.

Quick version:

*/5 * * * * curl -s https://store-b.com/wp-cron.php > /dev/null 2>&1

Part 5 — One-Way vs Two-Way Sync

One-Way (What We Built)

Store A → Store B. Changes on B are overwritten by A.

  • Simpler
  • A is the source of truth
  • Best for 99% of use cases

Two-Way Sync

Both stores sync to each other. Changes on B also go back to A.

  • Complex (easy to create loops or conflicts)
  • Useful for: multi-region stores where inventory updates can happen anywhere
  • Requires careful setup

To build two-way:

  1. On Store A: set up "Pull from Store B" job with Store B's REST API credentials
  2. On Store B: set up "Pull from Store A" (already done)
  3. Both jobs run hourly on different schedules (avoid running at the same time)
  4. Use Delta Import on both to avoid looping

Two-way sync risks

If Store A and Store B disagree on a product, which wins? "Last update wins" can cause data loss. Consider designating one store as "pricing master" and the other as "inventory master" so they never overwrite each other.

Part 6 — Syncing Orders

To sync orders from Store A to Store B:

  1. On Store A: WooCommerce → Settings → REST API → create a second key with Read/Write
  2. On Store B: create a new Job
  3. Same as Part 2 but pick Entity: Orders
  4. Run hourly

Why Read/Write for Orders?

When B pulls an order from A, then B might update a status (shipped, refunded). If Two-way sync is set up, the status change syncs back to A.

Part 7 — Partial Sync

Not everything needs to sync. Filter to only what matters.

Example — Only Sync Published Products

In Job Editor → Tab 3 (Transformations):

Add a filter condition:

Status equals "publish"

Store B only gets published products. Drafts stay on A.

Example — Only Sync Certain Categories

Categories contains "Wholesale"

Only products in the "Wholesale" category go to Store B (useful for a wholesale-only store).

Part 8 — Monitoring

Dashboard

Check both stores' dashboards daily.

  • "Failed (Last 24h)" should be 0
  • "Total Records Imported" grows over time

Email Alerts

You set these up in Part 2 Step 6. You'll hear about failures.

Spot Checks

Weekly, verify:

  • Random product on A matches B
  • Stock counts make sense
  • Prices match (or have the expected markup)

Advanced — Multi-Region Setup

Scenario

  • Store A: US customers (USD pricing)
  • Store B: UK customers (GBP pricing)
  • Store C: EU customers (EUR pricing)

Setup

Each secondary store (B, C) has its own sync job pulling from A with a currency transformation:

  • Store B: multiply price by 0.80 (USD to GBP)
  • Store C: multiply price by 0.92 (USD to EUR)

Prices auto-convert during sync.

Update exchange rates periodically in the transformation settings.

Advanced — Sync With External Systems

You can also sync with non-WooCommerce systems:

  • Stripe dashboard — pull product/customer data from Stripe
  • Shopify — keep WC and Shopify in sync
  • ERP — SAP, NetSuite, etc. via their REST APIs

Use Source Type: REST API (generic) instead of WC REST API.

Troubleshooting

ProblemFix
"Unauthorized" 401Check Consumer Key and Secret. Regenerate if needed
Products duplicate on Store BSet match key to sku. Use Create + Update mode
Images not downloadingCheck Settings → Image & Media → Download Images
Prices off on Store BCheck currency transformation or decimal separator
Stock keeps flippingTwo-way sync loop. Use one-way only
Sync very slowUse Delta Import. Schedule less frequent (every 2 hours instead of hourly)
Different product countsSome products may be filtered out. Check filter config

Related Pages

  • Import Sources → WooCommerce REST API
  • Export Destinations
  • Jobs — Scheduled jobs
  • Delta Import — Only sync changes
  • Server Cron Setup — Reliable scheduling
Prev
Tutorial — Daily Backup to Amazon S3