The WebToffee plugin: Product Import Export Plugin for WooCommerce, is the one stop solution for all your import export tasks related to WooCommerce products. The plugin exports and imports all store products with utmost efficiency. But, what if the import export operation is not working as expected?
The Logs section in the import export plugins by WebToffee gives you a detailed history of everything that has been happening in the heart of an import-export operation. So, if anything goes wrong, they give a useful overview of the events in order to help you, the developer, seek out the culprits. However, there may be instances where functional errors occur! Do not let those error messages dispirit you during the process. Here, we have listed some of the most common errors encountered and the solution to resolve them.
In Basic version
| Error | When do they occur | Possible solutions |
| same ID already exists | During import, when you try to add a product(by its ID), but a product with the same ID is already available in your store. | Update the existing product. Or Skip adding the product |
| same SKU already exists | During import, when you try to add a product(by its SKU), but a product with the same SKU is already available in your store. | |
| conflicts with an existing post | During import, when you try to add a product(by its ID), but the Product ID conflicts with an existing Post ID. Example: You are trying to import a product with ID:1080, but if you have an order/coupon or any other post with ID:1080; then the product will not get imported with the ID: 1080. This operation is halted by the default WordPress system. | Skip adding the product Or If possible, change the product ID in the input CSV file. Or For more details, refer: How to resolve ID conflict during import in WooCommerce. |
| Invalid input format for product type | Case1: The product type is not specified in the required format in the input file. | In the input file, specify correct values for the column, tax:product_type as: simple, external or grouped respectively(only lower case letters are allowed). |
| Case2: When you are trying to import or export a product type that is not valid in the basic version. | Basic version supports the following product types are:
Upgrade to premium. |
|
| Unsupported product type | On importing/exporting product types that are not supported by the basic version. Example: Import-export of variable products(a valid WooCommerce product type) is a premium feature. | Basic version supports the following product types are:
Upgrade to premium. |
In Premium version
| Error | When do they occur | Possible solutions |
| same ID already exists | During import, when you try to add a product(by its ID), but a product with the same ID is already available in your store. | Update the existing product. Or Skip adding the product. |
| same SKU already exists | During import, when you try to add a product(by its SKU), but a product with the same SKU is already available in your store. | |
| conflicts with an existing post | During import, when you try to add a product(by its ID), but the Product ID conflicts with an existing Post ID. Example: You are trying to import a product with ID:1080, but if you have an order/coupon or any other post with ID:1080; then the product will not get imported with the ID: 1080. This operation is halted by the default WordPress system. | Import as new item Or Skip adding the product. Or If possible, change the product ID in the input CSV file. Or For more details, refer: How to resolve ID conflict during import in WooCommerce. |
| Invalid input format for product type | The product type is not specified in the required format in the input file. | In the input file, specify the correct values for the column, tax:product_type as: simple, external or grouped respectively(only lower case letters are allowed). |
Updating the existing product
During import, in the step 4: Advanced Options/Batch Import/Scheduling > select Update for the option: If product exists in the store.
Import as new item
When you do want to import a new product from the input file and its ID conflicts with an existing Post ID, you can import the product as a new item. This will import the product with a new ID.
To do so: select Import as new item for the option: If product ID conflicts with an existing Post ID.
When to Upgrade ?
Generally, the error codes: Invalid product type and version does not support import occurs when you are using the basic plugin version for the product types that are supported only in premium. The basic version of the WooCommerce Import Export Products plugin supports only simple, external/affiliate, and grouped products. Check the premium version, to handle variable products.
For further assistance, contact the WebToffee support team.
- Was this article helpful?
- Yes, thanks!Not really
Comments (4)
Lidacha
January 7, 2022
Hello,
I imported a csv with a custom field (ACF).
The field contains a shortcode to display a PDF-icon that downloads a PDF on click.
The content is imported, so far so good…
However, the icon only displays and works if you manually open and save (without making any changes) the product afterwards.
As I have 10000 products, that is no option.
Any idea what could cause this?
Thanks.
Alan
January 20, 2022
Hi,
Can you please reach us via support?
Yee
August 14, 2021
Hi,
I am getting a parsing error, but before upgrading to the recent version, I had no problem updating the SAME products.
PHP Parse error: Invalid numeric literal in …/import.php(1187) : eval()’d code on line 1
Could you give me any pointer?
Thanks.
Mark
August 25, 2021
Hi,
Please reach us via support.