Sync Products into WooCommerce from external supplier APIs

Overview

The miniOrange WooCommerce Product Sync plugin is a powerful plugin designed to streamline the process of importing products into WooCommerce stores. By leveraging JSON or XML APIs, this plugin seamlessly synchronizes product data from external sources, such as inventory management systems or supplier databases, directly into the WooCommerce platform.

This comprehensive guide will walk you through the process of seamlessly integrating external product data into your WooCommerce store using JSON or XML APIs. By following these step-by-step instructions, you'll be able to effortlessly synchronize product information, automate updates, and streamline your WooCommerce store management workflow.

Download Plugin Pricing Plans Free Trial Demo Video

WooCommerce Product Sync

Import Products from External APIs / Supplier Inventory automatically. Automate syncing products, items and listings and create/ update WooCommerce products from these items for your WooCommerce store.

Know More   

Installing and Activating the WooCommerce Product Sync plugin (For Premium Plugin)

• After Installing and Activating the plugin on WordPress admin dashboard, you will need to login into the plugin with your miniOrange account which you used to purchase the plugin (using email and password).

• Once logged in, you need to verify the license with the miniOrange License Key which you can find on the miniOrange Portal.

• Click on Activate License to start using the plugin.

Steps to configure synchronization of products from the Custom supplier

• Go to the Suppliers tab inside the plugin screen. Click Add Custom option.

• Name the connection (For example: Logoline) and select the Connection Type.

• In the Authorization tab, choose the required authorization type for the API that you want to connect to and enter the credentials for it.


Note: If the authorization token is received in another API, click here to know how to configure it.



• Now, go to the API tab and enter the Product API details, including the API endpoint and the Name for the API.

• Once you configure the API, you can test the connection to see a successful response from the API.

• Now go to Pre-Requisites tab to configure some necessary parameters:
• In the Product Data Source, map the attribute key which contains all the product data. In the below example, it is "products" (This depends on the API response and should be left blank if such key does not exist.)
• In the Product Unique Identifier, you need to mention which key in API response lets you identify each product uniquely. In the below example, it is "id".



Note: For detailed instructions on configuring time delays between two API calls in case of Rate Limiting on the API, Click Here.



• Now, go to the Attribute Mapping section and select Main Product to map the API data to WooCommerce attributes.



Note:

1. If you have only simple products you need to map only the Main Product attributes.

2. If you have variable products, you need to map the common product attributes like name, description, category in the Main Product and Variable attributes like Size, Color in Variations.

3. For attributes like price, stock etc, you need to map them Main Product and Variations both.



• In the core fields tab, map the attributes like Unique Product Identifier, SKU, Name, Description, Price, Stock Quantity, Images, etc. For detailed Attribute mapping guide, Click Here.



Note: The Unique Product Identifier is a unique code used to identify each product. You can set the 'Unique Product Identifier' field to _sku meta key from WooCommerce. This ensures each product is uniquely identified by its SKU.



• In the API section, you can see the API connections you've created with the Product API.
• To create additional connections, click on Add Connection. To create another API connection (e.g., If any attribute like stock or price is coming in a separate API)
• To edit an existing mapping, click on Edit.

• To initiate the sync, go to the Home screen and click on the Start button.

• You will see all the mapped attributes, and you can select the attributes you want to sync and click on Start Sync.

• To track the sync status and the number of products synced, go to Dashboard, and click View Details.

• You can confirm the synced products by going to the Products tab.

If you can see the products, then the connection is successful. Your WooCommerce store is ready to import products, pricing, and stock data from the supplier.

Sync Optimisation

To optimize the Sync, you can check our developer documentation for more details:

• Batch Settings: This lets you sync the products in small batches such that your server is not overwhelmed and the sync runs smoothly. Click Here to know how to configure it.
• Pagination: If your API returns data in pages (e.g., 50 products per page) and requires a page_number parameter to retrieve all the data, you can easily handle pagination by following the instructions provided. Click here for detailed guidance on implementing pagination in your requests.

For more feature details:

• Sync Scheduling
• Price Margin
• Concatenation of attributes
• Translation

Related Articles

• WooCommerce Product Sync
• Import Products from AlphaBroder Distribution
• Import products from Amrod
• Shopify Product Sync