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.

  • Was this article helpful ?
  • YesNo

36 thoughts on “Frequently Asked Questions: WooCommerce Product Import Export

  1. Pavel says:

    I’m testing the plugin (v1.7.5 basic version). I have a starnge issue with image import via csv.
    Import status shows that all is fine. images are loaded. But, for some reason, all images have a same picture (csv have diferent picture url for each product)

    Is there any logs execpt import status? How can I debug that?

    • Alan
      Alan says:

      Hi,

      You can find the import log from Woocommerce>Status>Logs>csv-import.

      The issue you are facing with the image import seems to be strange. Please share with us the CSV file you are importing and the import log via support.

  2. Trey says:

    I am having issues with the CSV File importing. I proceed to upload and it shows it being successful, then I go to view the product and it is not there.

  3. McCoy says:

    Hello, I’ve tried uploading multiple products using a CSV file. The product information uploaded but not the images. I’m using the free version. Do I need to purchase the the premium version to upload product images using the URL?

    Thanks

    • Alan
      Alan says:

      Hi,

      You can import product images from URL using both the basic and premium version of the plugin. Please make sure that the image URL present in the CSV file is publically accessible and points directly to the images.

      You can also go through the documentation on how to import product images.

    • Alan
      Alan says:

      Hi,

      In order to create the users using the Order import-export plugin, the user email address has to be present in the cutomer_email column. Please make sure that you have provided the user’s email address in the customer_email column.

  4. Thomas Löwe
    Thomas Löwe says:

    Hallo, gibt es eigentlich ein Limit an Kundendaten, die ich exportieren kann? Bei ist bei 29.000 Datensätzen Schluss.

    • Alan
      Alan says:

      Hi,

      If you are having a very large number of users to be exported then we will suggest you export them in batches by setting offset and limit as there are chances of server timeout when exporting large data. You can go through the documentation to know more about setting offset and limit while exporting.

    • Alan
      Alan says:

      Hi,

      Please make sure that you have provided the correct FTP details and CSV file path including the file name in the FTP import settings. If the issue still persists please reach us via support.

      • Sergio Leone
        Sergio Leone says:

        does not even export and no email arrives. I’m sure it’s a setup problem, I’d like to figure out where the error is because there’s no signal.

  5. Kishore says:

    Hi,
    I am trying to upload csv file from your Product Import Export for WooCommerce plugin but i am getting an error message has ” Failed to import Product”. I tried using several methods and several times but i am unable to upload the file. Please Help!

    • Alan
      Alan says:

      Hi,

      When importing inventory details from FTP server the data is fetched from the CSV file. You may please provide the updated data in the CSV file.

    • Alan
      Alan says:

      Hi,

      The issue you are facing might be because the CSV file with which you are importing variable products is not having the necessary data in it. In order to import variable products please make sure that the CSV contains either Parent SKU-Child SKU or Parent ID-Child ID combination. You may please go through the documentation on how to import variable products.

      If you still find any issues with importing products please reach us via support.

  6. ubaid
    ubaid says:

    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 ?

    • Alan
      Alan says:

      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.

  7. Morozlion says:

    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.

    • Alan
      Alan says:

      Hi,

      Currently, there is no option to import categories and subcategories alone. Importing of the category is supported only along with the product data.

  8. Anup says:

    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

    • Alan
      Alan says:

      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.

  9. Jason
    Jason Robie says:

    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.

    • Alan
      Alan says:

      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.

  10. Jacqui says:

    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?

    • Alan
      Alan says:

      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.

  11. Bob Woolnough says:

    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?

    • Mark
      Mark says:

      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.

Leave a Reply

Your email address will not be published. Required fields are marked *