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.

U can download the files from the following link: http://s000.tinyupload.com/index.php...10256564919153

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/

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

https://www.ozgrid.com/forum/forum/help-forums/excel-general/1216045-sorting-an-excel-datasheet