Skip to main content
All CollectionsFAQ
How do I keep my export in the same order I imported it as?
How do I keep my export in the same order I imported it as?

How to keep your csv file in the same order you imported it.

Keith Allen avatar
Written by Keith Allen
Updated over a week ago

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). 

Did this answer your question?