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.

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

  1. Mark says:

    When uploading inventory via FTP, do the retails have to come from the vendor? How do I change retails manually?

    • 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

  7. 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 *