I’d like to be able to import csvs via this tool but want to add my own unique identifier so I don’t have to be worried about duplicate line items from overlapping imports Docs: Import CSV Line Items Can I inject my own data into the metadata column? And what format?

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 impor…

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

Google Sheets

jack.bates October 4, 2024, 11:33pm 5

I have the same (similar) question: I added a Transaction ID column to my Basic Bank Import Template. Can I use Import CSV Line Items to import those values to the Transaction ID column of my Transactions sheet?

Topic		Replies	Views
Import CSV Line Items - Can Metadata Column be deleted after? Google Sheets tcs-csv	3	26	October 2, 2024
Import CSV Line Items workflow question - Blank Transaction IDs Google Sheets tcs-csv	3	56	January 24, 2025
CSV importer tool issue - Account name doesn't import Google Sheets tcs-csv	8	902	September 11, 2021
Docs: Import CSV Line Items Show & Tell amazon , spreadsheet-utility , mint , tcs-addon , tcs-csv	19	25064	April 14, 2022
CSV Spreadsheet Importer Multitool for Google Show & Tell amazon , mint , ynab , paypal , venmo	30	4271	July 10, 2024

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

Related topics