The Woocommerce Import Add-on has Two Issues

Hi,

Ignore my request on the other ticket to export your importer settings as this is a duplicate, as i can see you have done this here.

Based on your settings it looks like you need to set the product type from "variable product" to be populated dynamically from column {3} , as "variable product" is for the parent product, and "product variation" is the child product.

With this setting saved, if you can manually delete the previously imported products, and remove them from the trash, before running the importer.

And the uncategorised being assigned to a product when it is created is a bug that i will let you know when it is fixed.

James

I made changes as you said. But it is still not working. Please json and screen-shot in attachment.

Hi Kem,

I ran your import with the supplied csv file, and it Inserted 30 products, and had 75 errors.

Upon looking at the history tab it says, "variation cannot be imported; Missing parent ID or parent does not exist yet".

To fix this error, under the step "3. Template Fields", under the section "Advanced", enable the parent field and set parent: {4} and parent field type to sku.

And then re-run the import.

I also noticed that you have imported the images, but not set them as the featured.

Under "3. Template Fields", under the "Product gallery" section, on the field with the featured images in, click on teh "Show settings" button, and set the "Is Featured?" dropdown to yes. And re-run the import.

Hi James. All products imported without any error. However, the plugin sometimes misses to import price. Some of the products in store has 'Read More' link instead of 'Buy Now' because the absense of price whereas the csv file does have price.

Please try to import the csv file in attachment.

Hi Kem,

Can you give me a list of products that have the Read more link instead of buy now.

Can you also use one of the product with the read more links and attach a screenshot showing what the edit product screen looks like, what attributes it has and details of each variation.

Hi James. Unfortunately i deleted products with no-price. Also, new issue has cropped up. First i imported 105 products. All went well. Now i am trying to import one product with 5 variations but the plugin shows log for 93 entry.

I have tried below without success....

1) Deleted the old importer
2) renamed the csv file

Still plugin shows error for 93 entries. Check attachments.

I have opened up your csv, and can see that there are 6 rows of data, followed by 86 rows of empty data, which will be why the plugin shows all the errors for 93 records (as shown in the attached screenshot 1).

From the errors image it says "Invalid product type" for each row of your csv that has values.

On the first row the product type column is: Variable and the rest are: Variation

these do not match the values that woocommerce expect which is variable and variation.

To resolve this you can either modify the data in your product type column to be lowercase and re upload your csv, or you can map the data inside the importer on the product type field.

To map data, on the product type field, click on the grey button to the right of the select data button (as shown in the attached screenshot 2). Clicking this loads up a modal labelled "Field map", click on "add row" twice to create 2 empty rows, and set the values of (without the double quotes, as shown in the attached screenshot 3):

If Value "Equals" This "Variable" Then Return "variable"
If Value "Equals" This "Variation" Then Return "variation"

Close the modal and save the importer, and re-run the import.

Hi James. It did work but not as wanted. First import work perfectly. The second import, immidietely after first-import, stops generating thumbnails of the products but product pages shows images properly. Its just thumbnail and second-import. I am attaching file here two csv try to import. Also sharing my site's admin and password in private reply.

When a product imports an image, wordpress handles the resizing and generation of thumbnails.

Can you give me an example url and product of where i can see the issue.

2.1 Has the featured image dropdown set which is why the image is displayed, and 2.2 does not, which is why the woocommerce placeholder displays.

If you look at the edit screen /wp-admin/post.php?post=32651&action=edit you can see the "Product Image" field is empty and the "product Gallery" field has the image.

Hi James, All worked well. Also, have you updated addon? Because, now uncategorised issue too has dissappeared in latest import.

I need to import brand for each product, so i guess i will have to buy pro, right?

Thanks

Uncategorized only appeared on the first import, after that it would go away.

How is the brand setup, if this is a taxonomy you can link it via the taxonomies section.