Combining two CSV

Hi Matúš,

What do you have set for the Unique indentifier in the permission step of the importer?

This error means that it cant find and existing record to update, so it needs to create the record, but you have not enabled the insert permission.

Can you confirm the structure of the first feed matches that of the combined feed?

James

Hi James,

I don't have anything selected as Unique Identifier. I don't exactly know what should I select. The settings of both feeds are identical, only differencei is in permission: first feed have option Create and the second one Update.And yes structure is the same, it's a custom feed for just a testing.

Thank you

Can you please export and attach your importer settings to this ticket by going to Tools > Import WP > Settings / Tools > Import / Export and select and export your importer as a JSON file.

Can you also attach a copy of the feed1, and feed2.

So if i understand correctly, feed one creates the products and feed 2 should update teh products?

I attached everything.

Yes feed 1 creates products and feed 2 should add more products. For exemple feed 1 create iphone 10 product and feed 2 should add iphone 10 from his feed. These are just custom test files.

Thanks for help

Thank you,

Just to confirm one thing, i can see that you have the ID field populated and since this is an id field it will be used as the main unique identifier, using this in your example then there is no way for the product to match since ID are not the same across both csv's.

However if you disable the ID field, and instead use the product sku field as the unique identifier by selecting from the unqiue identifier dropdown on the permissions page, or enter it manually as _sku will use the product sku field which 

Hello! I've created the products with ID. Because without it I had an other. Than I tried second feed - leave ID field blank and in permission page set unique identifier to "sku",i didnt have anything in dropdown menu so I entered it manually as you said. When I tried to run I got this error. 

Can you please export and attach this importer settings to this ticket by going to Tools > Import WP > Settings / Tools > Import / Export and select and export your importer as a JSON file.

sorry can you also attach the csv being used so i can replicate your setup

hi! sending it all. But I did it as you said. Uploaded first feed with ID. And then the second one without ID and in permission - unique identifier: custom: sku. So idk where is the problem :/

From your second importer i can see that you did not select the sku option from the unique identifier dropdown, instead you created a custom value called "sku" which was missing the _ prefix e.g. "_sku" (attachment 03), selecting the "_sku" option (attachment 05), saving and running the import allows the records to update (attachment 06).

James

If the permission dropdown is empty, can you make sure you are using the latest version of ImportWP - WooCommerce , should be v2.3.1 and can be downloaded from here: https://www.importwp.com/integrations/import-woocommerce-products/

The latest error means its working as expected, however you have 4 products that have the same sku, so it does not know which one to update, as there should only be one.

Enabling the delete permission could auto remove all of these the next time the importer is ran (make sure you backup your database and files before doing so just in case), or you can manually delete them and clear the trash, The 4 matching products of the first row are:

/wp-admin/post.php?post=135410&action=edit
/wp-admin/post.php?post=135357&action=edit
/wp-admin/post.php?post=135351&action=edit
/wp-admin/post.php?post=135346&action=edit

But every product have different SKU so I dont see a problem. I don't understand. I want to add products to existing one. So there would be 2 offers. Not to delete the one which have been here before.

Thank youu

The duplicate products will have been created when you previously imported products with the wrong unique identifiers, going forward after these duplicates are removed there should be no issues.

Hello!

I've tried it once again. Removed all products. Uploaded test1 with product ID. Try to upload test2 but left produck ID field empty. Than check _sku from dropdown. Ended looking like this. Am I doing it correctly? Thank you and merry christmas.

Did you remove all the products and then empty the trash/bin? as the screen still shows that the products exist by the list of product ids.

e.g. you can access the existing products via the id: /wp-admin/post.php?post=135417&action=edit

When I deleted it finally worked! Thank you! I havent though that emptying trash makes a difference.

Thank you James! All the best. Sorry it took that long for me to understand :D

Im glad the issue is resolved, if you have any other problems just let me know.

To help support the plugin i would be very grateful if you could leave a rating/review https://wordpress.org/support/plugin/jc-importer/reviews/

James