Product size variation showing double on the backend

Hi @unluerweb ,

I understand you’re seeing duplicate product size variations in the backend, and I know how frustrating that can be. Just so you know, when importing products from a CSV, duplicates can sometimes happen if the variations aren’t matched correctly. To prevent this, make sure each variation has a unique SKU or ID and that the fields are mapped correctly during the import.

Here’s a guide we have for Importing/Exporting products if you need it: https://woocommerce.com/document/product-csv-importer-exporter/#import

If that doesn’t clear things up, one option is a plugin called ‘Product CSV Import Suite‘ that could help iron out those duplicate size variations. It goes the extra mile compared to the default importer especially when handling complex imports, like those with multiple variations, custom data, and special attributes. Plus, it merges products smoothly if you update existing items.

Hope this helps. Let me know how it goes or if you have any additional questions.

Thank you for your help. Each product (variable) has a unique SKU and ID. Each variation has a unique ID, but not SKU.?The SKUs of the variants are empty.

https://snipboard.io/SCRkO0.jpg

https://snipboard.io/29U6ls.jpg

https://snipboard.io/x9TUzv.jpg

I will try to use the plugin called ‘Product CSV Import Suite‘, thank you.?Currently, the variations of all products has doubled. How can I fix this issue?

Had similar issues before – seemed to have been caused by not emptying the trash after deleting products – they still exist in the database so that might be confusing things!

The trash can is empty.

Hi @unluerweb ,

Thanks for your reply! And we also appreciate your contribution by sharing your experience @seank123! Using the suggested plugin should help streamline the process.

Currently, the variations of all products has doubled. How can I fix this issue?

To fix the double variations, and since you’re considering the ‘Product CSV Import Suite‘ plugin, there is a feature to bulk delete the products. It can help you quickly remove the duplicates without deleting one by one. However, always be cautious and remember that keeping backups like you did is a lifesaver in these situations.

Once the duplicates are cleared, when you use the Product CSV Import Suite for any future imports, ensure each variation has a unique SKU to avoid this happening again. This acts as a clear identifier for your system to recognize different variations.

Let me know if you have more inquiries.

Hello, I fixed the issue. I gave up using the ‘Product CSV Import Suite’ plugin because its review score was 2.8.

For the CSV file I used Google sheets. I sorted the products by type (variable / variation), Parent (parent_id), Attribute-1 value (carpet size). Therefore the same variations were listed one after another. I put the value 1 at the end of the repeated variation line with the formula below. I put all the rows with 1’s together by sorting them by the last column. Then I deleted these lines in bulk.

=IF(AG35=AG34;IF(AO35=AO34;1;””);””)

Hi @unluerweb ,

Great to hear you resolved the double variation issue. Your method of sorting and using formulas in Google Sheets is a clever way to spot and remove those duplicates. Thank you for sharing it here.

Just a heads-up, when working on edits with Google Sheets, make sure the information matches the required format for WooCommerce import. This ensures a smoother process when uploading your CSV file back to your website.

I’ll be setting this thread to resolved now. If you have further questions, please feel free to open a new topic.