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?file_id=02519710256564919153
Cross posted
https://www.excelforum.com/excel-formulas-and-functions/1268423-sorting-an-excel-datasheet.html
https://chandoo.org/forum/threads/sorting-an-excel-datasheet.41196/
https://www.reddit.com/r/excel/comments/b110go/sorting_an_excel_datasheet/
http://www.msofficeforums.com/excel/41931-sorting-excel-datasheet.html#post139421
https://www.ozgrid.com/forum/forum/help-forums/excel-general/1216045-sorting-an-excel-datasheet
U can download the files from the following link: http://s000.tinyupload.com/index.php?file_id=02519710256564919153
Cross posted
https://www.excelforum.com/excel-formulas-and-functions/1268423-sorting-an-excel-datasheet.html
https://chandoo.org/forum/threads/sorting-an-excel-datasheet.41196/
https://www.reddit.com/r/excel/comments/b110go/sorting_an_excel_datasheet/
http://www.msofficeforums.com/excel/41931-sorting-excel-datasheet.html#post139421
https://www.ozgrid.com/forum/forum/help-forums/excel-general/1216045-sorting-an-excel-datasheet
Last edited by a moderator:
