Documentation, FAQ, Product Import Export Plugin for WooCommerce
Frequently Asked Questions: WooCommerce Product Import Export
Q1.Why are some of the products getting “Failed to import products” error?
Ans: The error occurs when you have the unidentified character “�” in the CSV. Ensure that the CSV is UTF-8 encoded to avoid this issue.
Q2.Why are some products getting “post is not a product” error?
Ans: WordPress considers everything as posts. For example, a product is a post, an image is another post etc.
Thus if the importing product IDs already exist in your site, the new products cannot be inserted to the same ID, thus the error.
Q3.How to import multiple images?
Ans: Product Import Export plugin lets you import product information and images to your WooCommerce store effortlessly. You can import multiple images using this plugin without any hassles. You must ensure that all the image URLs are in the same column separated by ” | “.
For Example: URL/image1.jpg|URL/image2.jpg|URL/image3.jpg
Q4.How to set a featured image?
Ans: The first image URL in the images column is set as the featured image.
Q5.How to import a custom field or metadata from another plugin?
Ans: Perform an Export from your site with “Include hidden metadata” checkbox ticked, and you will be able to find the corresponding column header with the metadata from the external plugins. You can use the same column header and follow same data format to import the metadata back.
Q6.I have installed the plugin in a multisite. I am getting an error “You are not allowed to view this page” when trying to import. Please help?
Ans: Please ensure that the plugin and WooCommerce are not network activated. Activate both on the site level only.
I have two question can you guide me on it.
1. how can I update the production variation description via csv ?
2. Can I upload custom fields in variation through CSV ?
Hi,
1. Yes, you can update the description of product variations by providing the description data in the meta:_variation_description
column.
2. By default, Woocommerce does not support adding custom data fields to the products. If you have created them using any third party plugins then it
will be stored as metadata. You may please export the product with the option include hidden metadata checked and the custom
metadata fields will be included in the exported CSV. Later on, you can use the same exported CSV to import data back.
Hi, I’m testing your plugin and it’s better defined than WP All Import. But one problem arises. After importing products, WP does not see the fields written by this plugin, for example, AJAX search does not see the product name, the filter does not see the price by price, etc. But if in the admin panel to open and re-save the product without changing anything, everything becomes available.
Hi,
It seems like the issue you are facing might be because the transients is not getting updated. Please reach us via support.
Can I just import a spreadsheet with Categories and Subcategories, just to set up my 500 categories first? No products, yet.
Hi,
Currently, there is no option to import categories and subcategories alone. Importing of the category is supported only along with the product data.
hi I am trying upload a fe product but it says the product is already there.
and when we check its uploaded just then.
just to retry we also deleted the product and tried to reupload the same issue repeats.
“Failed to import product”
this is the error message we get
Hi,
The “Failed to import product” error occurs when either the post_title column is not present in the CSV file or the CSV is not UTF-8 encoded. Kindly make sure that the CSV contains post_title column in it and is mapped against the Product Title field while importing. Also, make sure that the CSV is UTF-8 encoded. You can go through the documentation on How to save CSV / Excel File as UTF-8 Encoded.
If the issue still persists please share us the CSV file via support.
i’ve tried the encoding, tried the import 5 times now. 1st issue is that the date is wrong for the last 3 orders. 2nd issue is I can’t click on any of the orders. so infuriating to use a plugin that straight-up breaks my site.
Hi,
Could you please mention whether you are having an issue with the Product import export plugin or the Order import export plugin. By default, the Order import export plugin accepts a date with format YYYY-MM-DD. If you are still facing any issues with the plugin please reach us via premium support.
Our support team will follow you up from there.
Great plugin! Thank you!
Just one problem. I can’t seem to import sub categories. I’ve got the following categories listed as this: Furnishing Your Dollhouse > 1:6 Scale > Bedrooms and it’s only importing Bedrooms. Followed all instructions and made sure the excel spreadsheet was saved in right format. Any suggestions?
Hi,
Following the format Dollhouse > 1:6 Scale > Bedrooms will import the product under the Bedrooms category only. If you are required to import the product under all the three categories then you may please specify the category as Dollhouse| Dollhouse > 1:6 Scale| Dollhouse > 1:6 Scale > Bedrooms. You may please use the pipe symbol( | ) to import a product under multiple categories.
Hello ,
I’m currently testing the plugin , upload was successfully : https://imgur.com/a/M38bb21
I mapped : sku , regular_price , product title , product description .
after upload , this error is showing : https://imgur.com/a/Am2tQgg
Kindly advice
Hi Jacob,
It seems like the issue you are facing might be because the CSV file is not saved as UTF-8 encoded. Kindly make sure that CSV file is UTF-8 encoded. You can go through the documentation on How to save CSV / Excel File as UTF-8 Encoded. If the issue still persists you may please share us the CSV via support.
Hi, I have installed an extension to allow me to insert the product EAN but, this field does not appear in ‘WooCommerce product field name’. Could you please advise as to why this is?
Hi,
If you are using any third party plugin to set up EAN code to products then it will be stored as metadata. Using the premium version of the plugin you can export the EAN code stored with the products by enabling the option Include Hidden Metadata during export. Later on, you can use the same CSV to import the data back.