How to Import WooCommerce Products from a CSV File

WooCommerce products can be straightforwardly imported from a CSV file using the WP Ultimate CSV Importer Pro plugin. To import WooCommerce Products, navigate to WP Ultimate CSV Importer Pro -> Import/Update. Upload the WooCommerce Products import file and Choose the import type and data type. Now Map the incoming data element with an advanced or drag-and-drop interface. Configure the import settings and run the import.

Step 1: Prepare Your CSV File #

Before importing, ensure your CSV file is properly formatted. Each column in the CSV file should represent a specific product field in WooCommerce. Here are some common fields to include:

• Product Name: The name of your product.
• Product SKU: A unique identifier for the product.
• Product Price: Regular and sale prices.
• Product Categories: Categories separated by a delimiter (e.g., commas).
• Product Images: URLs of the product images.
• Product Stock: Stock quantity and status.
• Product Attributes: Custom attributes like color, size, etc.

To know how to import, update and Schedule your import please refer the link. You can get your WooCommerce Products Import Sample CSV here.

Step 2: Upload Your CSV File #

1. Log in to your WordPress dashboard.
2. Navigate to Ultimate CSV Importer Pro > Import/Update.
3. Click on Browse and choose your CSV file.
4. Select the Fresh import option to import the new products. If you want to update the existing products, then select Update Content
5. Select the post type as WooCommerce Products to specify that you are importing products.

Step 3: Map Your Fields #

Once the file is uploaded, you will be prompted to map the fields in your CSV file to WooCommerce product fields.

• Left Column: Fields from your CSV file.
• Right Column: WooCommerce fields available in your store.

You can use the Advanced mode to map the CSV fields to the desired WP fields using drop-down.

In the drag-and-drop method, you can map the CSV fields from the right-hand menu and drop them onto the appropriate WP fields on the left side.

For example:

• Map Product Name to Product Title.
• Map Product SKU to SKU.
• Map Product Price to Regular Price.

If your CSV includes custom fields, you can map them to Custom Meta Fields in WooCommerce.

Once done with Mapping, Save the mapping template. You can use this import template for future imports. Now Click on Continue.

Step 4: Configure Import Settings #

Depending on your requirements, you can configure media and  import options:

• Manage the media files and configure the import settings.

• From here you can configure the settings of your product import with the Rollback option( backup before import).
• You can also switch to maintenance mode while importing.
• Efficient duplicate handling of existing records for duplicate-free product import.

Step 5: Run the Import #

After mapping and configuring settings:

1. Click the Import Now button to start the process.
2. Monitor the progress bar to track the import status.
3. Once completed, check your WooCommerce product catalog to confirm the data has been imported correctly.

Advanced Topics #

1. Importing Product Variations or Variable Products #

Easily import and manage product variations for WooCommerce. Ensure your CSV file contains the following fields:

• Parent SKU: Links variations to the parent product.
• Attribute Name/Value: Define attributes like size or color.
• Stock Status & Price: Set specific prices or stock levels for variations.

Follow these steps:

1. Prepare the CSV files for WooCommerce Variations and its Related Products
2. Select the Import type as Fresh Import
3. Choose the data type as WooCommerce Variations
4. Map the Parent SKU field to the “Parent” WooCommerce field during import.
5. Map attribute columns to corresponding WooCommerce fields like “Attributes” or “Custom Meta Fields.”
6. Run the import and verify that variations are linked correctly to the parent product.

Note: You can also import WooCommerce products and Variations with Single CSV file.

WP Ultimate CSV Importer Pro

Get Ultimate CSV/XML Importer to import data on WordPress faster, quicker and safer.

Grab it Now $199/-

2. WooCommerce Add-ons Import #

WP ultimate CSV importer supports the below WooCommerce add-ons to import the specific and advanced Woocommerce fields to your WordPress site.

WooCommmerce Orders: #

The Woocommerce orders add-ons include the order status field and the order total field. The order status field may include completed, refunded, pending, cancelled, on hold, processing, awaiting payment. The total value fields specify the order total which includes Cart & Order discount, Shipping tax To import these fields using WP ultimate CSV importer PRO, prepare a CSV file with these fields.and follow the import steps explained above in this guide.

WooCommerce Subscription Product: #

With WP ultimate CSV importer, it is easy to import various subscription details such as subscription signup fee, subscription period,  subscription price, subscription period interval, subscription trial period, subscription trial length, subscription length, subscription_payment_sync_date, subscription one time shipping.

Prepare CSV file with the desired subscription details that you need to import.  Follow the import process of WP Ultimate CSV importer explained above to import the subscription fields to your WordPress site. 

WooCommerce Coupons #

The Coupons add-ons help to import the coupon fields using WP ultimate CSV importer.  Prepare the CSV file with the desired WooCommerce Coupon field such as individual use, exclude sale item, coupon amount, and discount type. 

WooCommerce Chained Product #

Chained product add-ons help you to create combo products with the main products. You can create and upload these products as a CSV file and them using WP ultimate CSV importer. The chained product fields includes chained product detail, chained product manage stock. 

WooCommerce Product Bundle  #

WP Ultimate CSV/XML Importer supercharges your ability to import CSV/XML data to Product Bundle meta fields. Using the Product Bundles addon, you can group simple, variable, subscription products and sell them as a bundle. Ultimate CSV Importer lets you easily add bundle products in bulk to your WooCommerce store within some minutes.

WooCommerce Variation Swatches #

The WP Ultimate CSV Importer makes importing WooCommerce Variation Swatches quick and effortless, allowing you to bulk upload products with visual variation selectors like color, size, or material. To get started, prepare a CSV file with product details, attributes, variation values, and swatch type metadata (e.g., “Color Swatch” or “Image Swatch”) for each attribute. First, install the WooCommerce Variation Swatches plugin and configure it on your site. Upload your CSV file via the WP Ultimate CSV Importer, map the fields to corresponding WooCommerce product attributes and swatch-related custom fields, and initiate the import. 

The plugin will automatically assign swatches and create products with variations based on your data. After importing, verify the display of swatches on your store and troubleshoot any mapping issues or formatting errors in the CSV. This streamlined process eliminates manual entry, supports custom fields, and ensures accurate bulk imports, making it an ideal solution for managing WooCommerce variation swatches efficiently. 

For example, if you provide the variation swatches as colour for the product attribute then you need to provide the colour code along with the product  attributes. If you have multiple attributes, then it will be separated with the pipeline symbol. 

3. Handling External Image URLs #

To import products with external images:

1. Include full URLs of images in the Image URL column.
2. During field mapping, link the column to the “Product Gallery Images” or “Featured Image” field.
3. Enable background image processing for large imports.

4. Managing ACF and Custom Meta Fields #

Import data for Advanced Custom Fields (ACF) or custom WooCommerce meta fields:

1. Identify ACF field keys from your site.
2. Prepare your CSV to include field keys as column headers.
3. Map these headers to corresponding custom meta fields during import.

5. Automating Scheduled Imports #

Keep your product catalog updated with scheduled imports:

1. On the Import Configuration Settings, enable the option “ Do you want to schedule the import process”
2. Then enter the scheduled time, frequency, time zone, etc 
3. Now click on Schedule Import.

6. Bulk Updating Existing Products #

Update product details (like price or stock) by matching SKUs:

1. Enable the “Update Existing Records” option during import.
2. Map the SKU field to ensure accurate identification of products to update.
3. Follow the subsequent steps as explained above for successful data update.

7.  Importing Taxonomies in WooCommerce #

To import Taxonomies in WooCommerce,

• Prepare a CSV file with the desired WooCommerce  Product/Attributes/Orders, with its taxonomy fields and taxonomy meta fields(if needed)
• Navigate to the WP ultimate CSV importer PRO -> Import/update
• Upload the CSV file and choose the import type as Fresh Import or Existing Content
• Select the data type as WooCommerce Products/Attributes/Orders from the drop- down menu.
• Map the desired WP fields with its desired CSV fields by Advanced mode or drag and drop mode.
• Ensure to map the taxonomy fields in the mapping section and save the mapping template.

• Now manage the media handling and configure the import settings.
• Once done, Run the import to import the taxonomies to the WooCommerce Product/Attributes.

8. Export WooCommerce Products #

To export WooCommerce Products,

• Navigate to WP Ultimate CSV importer -> Export
• Choose the data type as WooCommerce Products. Click on Continue

• Enter the File name and choose the desired File type.
• Use the advanced filter options to export your product field data more specifically.
• Select “Export CSV file to Google Sheets” to export your CSV file in Google sheet.

Note: To enable this option, you need to link the Google Sheets in our plugin settings. For that, navigate to WP Ultimate CSV Importer Pro -> Settings-> Google Sheets. Enter the client id, and client secret, and redirect the URL of your desired Google sheet to link it with the plugin.

On enabling the “Export data with Specific Inclusion” section you can export the specific product attributes. For example: Select product_attribute 1, product_value 1, product_visible 1.

You can also schedule the export by enabling the “Do you want to schedule this export”. Then provide the scheduled time, frequency, time zone etc. Now click on Schedule Export.

Once done click on Export.

You can download your export file or export your file on Google Spreadsheets.

Note: You can also export data more specifically with other options at advanced filters that includes:

• Export data based on specific period
• Export data with auto delimiters
• Export data with the specific status
• Export data by specific post_id

FAQs #

What file formats does WP Ultimate CSV Importer Pro support?
The plugin supports CSV and XML formats. JSON imports are not currently available, but you can export data in JSON format.

Can I import grouped products?
Yes, grouped products can be imported by linking child products via a “Group Product SKU” field in the CSV.

Does the plugin support multisite imports?
Yes, but you need to activate the plugin for each site individually. Network activation does not enable imports across subsites.

What types of WooCommerce products can I import?
You can import all WooCommerce product types, including simple, variable, grouped, and external products. Ensure that your CSV includes relevant fields like Parent SKU for variations or Linked Product SKUs for grouped products.

Does the plugin support importing from external sources like Google Sheets or Dropbox?
Yes, you can link external data sources such as Google Sheets or Dropbox by providing a public URL. The plugin fetches data directly from these sources during import.

How do I import custom fields into WooCommerce products?
Include the custom field keys as column headers in your CSV file. During mapping, expand the “Custom Fields” section and link the columns to their respective fields. For advanced custom fields, ensure they exist in a published post before importing.

Why aren’t product images uploading?
Ensure the image URLs in your CSV are publicly accessible. If they point to an external source, enable background processing for large imports. For local files, confirm the images are in the WordPress media library.

How do I prevent overwriting existing data during updates?
Use the “Update Existing Records” option and configure the import to skip empty fields in the CSV. This ensures that only populated fields are updated.

How do I import Excel files into WordPress?

• First Open the Excel file, and copy the content of the file
• Then Paste it on the new spreadsheet or Google sheet
• Save the file by navigating to File -> Download ->Comma Separated Value. Then the Excel file is now converted into a CSV file.
• Now it is easy to import your CSV Files into WordPress by following the simple steps
• Navigate to the WP CSV importer-> Import/Update
• Browse the CSV  file you want to import. 
• Select the content type such as post, pages, Woocommerce products, etc from the drop-down menu.
• Choose the new or existing to choose the import//update.
• Map the WP core fields with their appropriate CSV Header column.
• Configure the Featured media handling section and import settings.
• Once done click on Import

How to import CSV  into  WooCommerce?

As the WP CSV importer is compatible with Woocommerce, you can easily import any Woococommerce CSV files such as Woocommerce Products and Variations, Woocommerce orders, etc.,

The import process is the same as that explained above. 

How do I import categories from CSV to WordPress?

With WP CSV importer you can import categories by simply following the import steps. You need to select the content type as Categories from the drop-down to import.

WP Ultimate CSV Importer Pro

Get Ultimate CSV/XML Importer to import data on WordPress faster, quicker and safer.

Grab it Now $199/-