The Products and Orders Sync for WooCommerce is a powerful WooCommerce extension designed to seamlessly synchronize products and orders across multiple WordPress websites. Utilizing the robust WooCommerce REST API, this add-on enables real-time or scheduled syncing of product data, inventory levels, and customer orders between connected stores.
Whether you’re managing a multi-store network or simply need to keep product catalogs consistent across different sites, this tool streamlines cross-site communication and ensures data accuracy, eliminating the need for manual updates.
Installation
- Install and activate the WooCommerce plugin.
- Install and activate the Products and Orders Sync for WooCommerce add-on.
- Two menus will appear on the WordPress Dashboard: “Shop Sync” and “Shop Sync WooCommerce”.
License Configuration
Navigate to the Shop Sync WooCommerce menu and go to the License tab. Then, enter the License Key in the corresponding field and click on the Activate button.
How to acquire the Child Site’s Consumer Key and Consumer Secret Key
To get the consumer key and consumer secret key of the child site(s), follow the following steps:
1- Navigate to the child site’s “WooCommerce” > “Settings” > “Advanced” > “REST API” sub-tab. Click the “Add Key” button.
2- Enter text in the “Description” text field and update the permissions to “Read/Write”. Click the “Generate API key” button.
3- Finally, your child site’s Consumer key and Consumer secret will be generated.
Shop Sync
In this menu, you will be able to add and manage all your multi-store networks.
To create a new store network, you will need to provide the following information regarding the child site(s) on the parent site:
1- Child Site URL (with https:// included as well in it)
2- Consumer Key
3- Consumer Secret
Here you can perform the following actions as follows:
1- Click the “Add Shop” button to create a new record of a child site to connect it to the parent site.
Note: The first shop record (of the child site) once added cannot be deleted. It can only be updated.
2- Enable the “Sync” switch of an individual child site record if you want order/product synchronization to be performed on that specific site.
Note: If this switch is disabled, then no operation, whether “Sync By Orders” or “Sync By Products” will be performed on the respective child site.
3- Click the “Remove” button to remove the respective individual child site record from being connected to the parent site.
4- Once the child site(s) are connected, you can select which of the 2 options you would like to perform on the multi-store network.
Sync Type: (Sync By Orders)
- Enable the “Sync Orders:” switch if you want the respective order(s) to be added in the child site(s) as well.
If this option is disabled, then no orders will be synced from the parent site to any of the child sites, regardless of the respective child site’s sync option status. - In the “Select Orders:” option, you can select which parent site order(s) to sync to the child site(s).
Note: If you leave this field empty, then all the WooCommerce site orders in the parent site will be synced to all the child sites in the multi-store network.
Sync Type: (Sync By Products)
- Enable the “Create Variations:” switch if you want the newly created product variations on the parent site to be added in the child site(s) as well.
If this switch is disabled, then no new product variations will be created in all the child sites in the multi-store network. - If a status is chosen in the “Select Product Status:” option, all products synchronized to the child site(s) will have their respective status updated.
Similarly, if the “Select Product Status:” option is left unchecked, the parent site product or products will be synchronized with the same status (on the parent site) across all of the child sites. - In the “Search Products:” option, you can select which parent site product(s) to sync to the child site(s).
Note: If you leave this field empty, then all the parent site products will be synced to all the child sites in the multi-store network. - In the “Select Categories” option, you can select which parent site product(s) to sync to the child site(s) based on the product category(s).
Note: If you leave this field empty, then all the parent site products (in all the categories) will be synced to all the child sites in the multi-store network.
General
In this tab, you will be able to update the general settings of the addon based on your requirements.
Enable Auto Sync
Enable this switch if you want to run the synchronization process for all your multi-store networks (for both orders and products).
If the option is disabled, then the synchronization process will not run automatically for all your multi-store networks (for both orders and products).
Schedule Cron Time (in minutes)
Here, you can set the time interval limit for the cron job, after which the synchronization process for all your multi-store networks (for both orders and products) will run again.
Note: Make sure to set the cron time limit based on the number of products and orders to sync, your bandwidth, and other server resources being utilized.
For a simple product, it takes less than a minute, and for variable products, it depends on the number of variations. Additionally, you can add 5-10 minutes extra per 100 products for safe synchronization and the same for the order data.
Clear DB (Reset Stored Information)
Enable this switch if you want to remove all the products from destination sites (child sites) before importing the parent site products. If the option is disabled, then the products from destination sites (child sites) will not be removed before importing the parent site products.
Note: If the same product is found in the child site(s), its product data fields will be updated.
Sync All Products on All Sites
Clicking this button runs a one-time product synchronization for all your multi-store networks. It uses the “Sync Type” set to “Sync By Products” to ensure that all products are synchronized across every connected site.
Sync All Orders on All Sites
Clicking this button runs a one-time order synchronization across all your multi-store networks. With the “Sync Type” set to “Sync By Orders,” it ensures that all orders are synchronized on every connected site within each network.
Product Fields
In this tab, you can choose which product fields of any given product (simple or variable) will be updated from the parent site to the respective child sites when the “Update” button is pressed twice (in sequential order) on the parent site product edit page.
Note: To add child site(s) in the “Shop Sync Settings” metabox, navigate to the “Destination Sites” tab and enter the required individual child site(s) details in each record and click the “Save Changes” button.
Here is the list of all the product fields that you can select whether to update or not individually from the parent site (from the product edit page) to the child site(s):
- Product Info
- Description
- Short Description
- Default Attributes
- Categories
- Create Variations
- Pricing
- Price
- Regular Price
- Sale Price
- Date on Sale From
- Date on Sale To
- Inventory
- Manage Stock
- Stock Quantity
- Is In Stock
- Backorders Allowed
- Backorders
- Low Stock Amount
- Sold Individually
- Purchaseable
- Shipping
- Weight
- Length
- Height
- Marketing & Visibility
- Featured
- Featured
- Reviews
- Reviews Allowed
- Reviews Allowed
- Other
- Purchase Note
- Total Sales
- Product Status
Suppose the Regular price of a product on the parent site is updated to $100, and on one of the child sites, it is $50. If the “Regular Price” switch is enabled on the parent site’s “Product Fields” tab, then when the respective product’s “Update” button is pressed the second time in succession after the first page reload, the child site’s respective product’s regular price will be updated to $100.
Similarly, if the “Regular Price” switch is disabled on the parent site’s “Product Fields” tab, then when the respective product’s “Update” button is pressed the second time in succession after the first page reload, the child site’s respective product’s regular price will not be updated to $100. The respective product’s regular price will remain $50 on the child site.
Destination Sites
In this tab, you will be able to add, remove, and manage all your individual shop(s) (child sites) to update their specific product-related data individually without affecting other child sites.
To add a new child site record, you will need to provide the following information regarding the child site(s) on the parent site:
1- Shop Name (So you can identify this child site on the individual product edit page of the parent site in the “Shop Sync Settings” metabox.)
2- Destination Shop – Child site URL (with https:// included as well in it)
3- Consumer Key
4- Consumer Secret Key
If any of the 3 fields (Destination Shop, Consumer Key, and Consumer Secret Key) of any child site(s) record is entered incorrectly, then you will get an error like below:
FAQ’s
1- Does “Products and Orders Sync for WooCommerce” add-on have any dependent plugin(s)?
The “Products and Orders Sync for WooCommerce” add-on requires the WooCommerce plugin to be installed before activating it.
2- How much time should be allocated to the “Schedule Cron Time” option in the “General” tab?
It depends completely on the number of products, product types (simple or variable), the number of variations in each variable product is the key factor and the number of orders you want to sync between your parent site and child site(s), your bandwidth, and other server resources being utilized.
3- What does the “Sync All Products on All Sites” option do?
The “Sync All Products on All Sites” option is used to manually run the syncing functionality (one-time) for all your multi-store networks (created in the Shop Sync sub-menu) with the “Sync Type” – “Sync By Products” option selected in them.
4- Which WooCommerce product data fields are supported by the “Products and Orders Sync for WooCommerce” add-on?
Currently, the “Products and Orders Sync for WooCommerce” add-on only supports the syncing of Default WooCommerce Product Data Fields like Product Title, Long Description, Short Description, Categories, Product Image, Product Gallery, and Product Type etc.
5- Which WooCommerce product types are supported by the “Products and Orders Sync for WooCommerce” add-on?
Currently, the “Products and Orders Sync for WooCommerce” add-on only supports 2 WooCommerce product types, which are “Simple product” and “Variable product” respectively.
Changelogs
1.0.0
- Initial Release.
