I have just made a fresh install of Drupal commerce RC1 and all recommended dependency versions as per release notes.

I have been uploading products and their nodes via Drupal commerce feeds.

Unfortunately I have now been getting doubles of all products showing in views and now on the latest feed upload I am getting Triple duplicates : (

I have read around the forums that views with some modules can have duplicates happen and something about sort criteria, but I have even tried removing sort criteria and I am still left with triple products.

I just uploaded products again, with products overwrite on as usual, I now have quadruple duplicates showing in my product views (Or should that be quadrupal duplicates excuse the silly pun).

Yet if I go into Drupal administration and go to store and products for commerce. Their is still the same amount of products their always was. So their is repeat database entries being made which I can not delete?

Other people may think they are safe now, but I am sure will run into this nightmare problem when they least expect it.

CommentFileSizeAuthor
#2 Update existing products.png108.93 KBTheWizz

Comments

jlhs’s picture

jlhs commented

Ok,

What I did was go into the database and delete all products under the commerce_product table. Then re-uploaded the feeds 'ONCE' for the products and 'ONCE' for the nodes.

Obviously this a pretty drastic solution (Not really a solution at all) but hey it did the trick.

If I had to update the CSV file and upload again, I would again have to delete all products from the commerce_product table first and then upload the CSV file to avoid duplicates happening drastic, but hey if drastic works then drastic it is : )

TheWizz’s picture

TheWizz commented
StatusFileSize
new Update existing products.png108.93 KB

AFAIK, you should be able to "update" existing products, assuming the SKU remains the same (as this is the "unique key" used to identify the product). See enclosed screenshot from the product feeds importer. Does this setting still result in duplicate products, rather then updating the existing ones with the new data? If so, that sounds like a bug to me.

-JM

jlhs’s picture

jlhs commented

Hello JM,

I usually do this setting as per your screenshot. Overites seem to be going ok for a little while wihout making duplicates, then they started appearing and new database entries made. Unfortunately I have since deleted the whole installation where this has happened. Now on the new installation I am getting error messages in Views so can not test it again. I think my share hosting does not have enough resources to run Drupal Commerce and Drupal somehow.

Thanks from Josh

jlhs’s picture

jlhs commented

I have now done two overwrites on a new install without any problem. Perhaps I did miss to check the overwrite radio button in the lat install. But for now looking good. If I have any issue will update.

rszrama’s picture

rszrama commented
Status: Active » Closed (works as designed)

Feel free to re-open if necessary, though it might be more pertinent in the Commerce Feeds queue if there's an issue with that integration.

joro78’s picture

joro78 commented

Hi there colleagues,

we have the same issue when selecting the option for updating products.

We have set the SKU as unique, and want to retain information for the product entity, such as additional price etc, which shall not be imported, but set per product after the import. However when importing products via CSV the latter are duplicated. I assume that some information in them, such as price, has been changed. I think that we shall open the issue, because commerce-feeds does not work as expected, concerning the updating of products. We are searching for solution.

Kind regards, George