Import Products to WooCommerce via FTP

Overview

In this guide, we will walk you through the process of importing products into your WooCommerce store via FTP using the miniOrange WooCommerce Product Sync plugin. By following these steps, you’ll be able to seamlessly connect to your FTP server, configure product settings, and map essential data fields, such as SKU, Name, Description, and Variations, directly to WooCommerce.
Whether you're importing simple or variable products, this process ensures that your product catalog is efficiently synced with accurate pricing, stock levels, and product details.

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.

Let's setup the FTP connection to import products to WooCommerce!

After installing and activating the miniOrange WooCommerce Product Sync plugin, follow the below steps to connect FTP and map product attributes:

Go to the Suppliers tab in the plugin. Click on the Add Custom button.

WooCommerce Product Import via FTP - go to suppliers

Name the Supplier (For example: Sanmar FTP) and select the Connection Type as FTP.

WooCommerce Product Import via FTP - name the supplier

In the FTP tab, under File Details, enter the connection name and complete the fields like Host, Username, Password, Port Number, and File Path.

WooCommerce Product Import via FTP - enter FTP details

In the Prerequisites tab, select which product configuration you want and the identifying columns for Main and Variations.

WooCommerce FTP product import - prerequisites

Note:
-No Variation: If your file has only simple products with no variations.
-Variable Response Attribute: Use when there is a grouping column available to identify all the variations.
-Parent Product Identifier: Use when there is no grouping column available, and you need to make a separate API call to get the variations.

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

WooCommerce FTP product import - attribute mapping

In the core fields, map the attributes like SKU, Name, Description, etc.

WooCommerce FTP product import - core fields

Note: Mapping is done on the basis of column indexes starting form 0.

Example: Our file contains SKU in the 4th column so we have mapped index 3 (as indexing starts from 0) to SKU.

WooCommerce FTP product import - example

Note: Similarly, you can map the name, description, and price from their corresponding FTP columns that contain the respective values.

In Variations Mapping, assign the variable attributes like Color and Size for variable products.

Import products to WooCommerce - variations mapping

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

Import products to WooCommerce - start sync

Select the attributes you want to sync and click on Start Sync.

Import products to WooCommerce - select attributes

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

Import products to WooCommerce - view details

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

WooCommerce FTP product import - 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 via FTP.

Sync Optimization

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:

Need Help?

Mail us on apisupport@xecurify.com for quick guidance(via email/meeting) on your requirement and our team will help you to select the best suitable solution/plan as per your requirement.

Contents