Importing and Exporting WooCommerce Product Bundles – WooCommerce Product Import Export

Product bundles are used to sell two or more products in a store together at a discounted rate.

WooCommerce Product Import Export plugin allows you to import/export bundled products easily. It imports/exports all the details of a bundle product perfectly into your Woocommerce store.

You can use WC Product Bundles – an open source plugin for providing the combo of the product for sale.

To import Product Bundles to your online store, you must enter details in the CSV/XML file which is to be uploaded.  For more information about CSV format, see Setting Up Product Import Export Plugin For WooCommerce.

Now, let’s understand the importing and exporting of a Product Bundle through an example.

Importing Product Bundle

Suppose, your CSV file is as shown below:

Note: Click Sample CSV of Bundle Product to download.

1. Navigate to WooCommerce > Product Im-Ex section of the plugin. Under Product > Import, move to Import Product in CSV Format section, as shown below:
2. Click Choose File to browse a required CSV/XML file from your computer.
3. Click Upload file and Import.
4. Map the fields(Woocommerce fields) with column headings( CSV file header/XML tag header) or use the mapping file to map the field.
5. Use Evaluation field to fix/update the required value for the particular field.
6. Click Submit to import the products into your online store.  According to the CSV/XML file, the product gets added to your online store. The import window appears as shown below: This plugin imports bundle product which is specified in the CSV/XML file.
7. The products get imported as shown below:
8. Here is the page of the individual bundle productThe Bundle Product which is visible to the customer is as shown below:

Exporting Bundle Product

If you are selling products as a bundle product, then you can export the products in CSV very easily. The steps to export bundle products are as given below:

1. Navigate to Admin settings (WooCommerce > Product Im-Ex) of the plugin. Under the Product Import/Export tab, the Export window is displayed as shown below:

Offset: Enter the product row number at which you wish to start the export.

Limit: Enter the number of products that you wish to export from Offset number.

Product Categories: Enter the product category that needs to be exported. Products under only these categories will be exported.

Product Type: In this field, you can enter the product type in order to export it alone.

Sort Columns: Enter the column name(s) by which you want to sort the products in CSV file. If you want to sort the products by more than one column name, enter Comma(‘,’) in between the column names.

Delimiter: With this field, you can change the comma separated file to ‘|’ or ‘.” separated file according to your requirement.

Select a mapping file for export: From this field, you can select the mapping file for export.

Columns: Select the checkbox for required columns if you want to export specific columns. With the Column Name field, you can modify the column header in the CSV file. To do that, simply enter the required column name for the specific column.

Save the export mapping: Here you can specify the columns that alone will be exported and save the mapping for later exports.

Include hidden metadata: Select the checkbox if you want to show hidden metadata of your products in the CSV file.  To get thumbnail IDs of the product images, select this checkbox.

Export Children SKU of Grouped products: By selecting this checkbox you can connect parent and child products with SKU.

Convert shortcodes to HTML: By selecting this checkbox you will be able to convert the shortcode to HTML in the exported CSV file.

Export images as Zip file: Here you can either allow or deny exporting of images as Zip file. The exported CSV will contain the URL path of the images.

Click Export Products, the CSV file gets auto-downloaded to your computer. The sample products CSV file is as shown below:

Note: You can download the Sample Exported CSV here.

To know more about other features of the plugin, read the documentation.