I can't seem to sort the excel datasheet in the right way. It needs to be in a particular way so the products can be merged while uploading. In the screenshot, I show you how it is now and how it needs to be. There are around 65k rows, sorting one by one isn't an option. I also provide a sample file with few products inside. The SKU always stays above the parent_sku. It works as follow: Parent product (SKU) is being imported and the variations (parent_sku) of the parent product follow.



Cross posted:

https://www.mrexcel.com/forum/excel-...datasheet.html

https://www.excelforum.com/excel-for...datasheet.html

https://chandoo.org/forum/threads/so...tasheet.41196/

https://www.reddit.com/r/excel/comme...cel_datasheet/

https://www.msofficeforums.com/excel...datasheet.html

https://www.ozgrid.com/forum/forum/h...xcel-datasheet