CSV importer tool -- can I create my own unique identifier?

Google Sheets
10

I can’t share the source code but I can tell you how the unique identification works… The importer stores miscellaneous order info in the Metadata column as JSON object. The importer concatenates several fields from this metadata to create a unique ID:

  • id
  • isbn
  • quantity
  • tracking

If the newly imported unique ID matches an ID already in the sheet, it is skipped.
Make sense?

3 Likes