If you have any invalid identifiers or identifiers that were not found on Amazon, these rows get flagged as an error and move to the end of your file when you export. If you need to keep everything in the same exact order you imported it as, you can take the following steps:
โ
1. Add a custom column that you'll import with your identifiers. If you have column headers in your file, you can name this column something like "import_order". Then auto-populate this column with numbers 1 to however many rows exist in your file.
2. After you've ran the search and exported your results, you'll simply use the "sort" tool in excel to re-order your file in the same way you imported it - order smallest to largest (or asc to desc). Your "imported_order" column will automatically be exported with the rest of the data you select (you'll see this as your last column in the file).ย