Writing Ranked Keywords And Title Casing Rules Into A Stock Metadata Generator

Description and use

Scripts generate exact CSV headers, correctly title‑case filenames, rank keywords, and track uploads, eliminating platform rejections for digital assets.

Problem

Metadata CSVs for stock platforms were rejected due to incorrect headers, title casing, keyword ordering, and duplicate uploads.

Outcome

All 60 assets were successfully uploaded after correcting header counts, title casing, keyword ranking, and implementing an upload ledger.

Workflow

• Write make_metadata.py to output platform‑specific headers and format rows
• Implement title‑casing that strips extensions and capitalizes words without affecting file extensions
• Create ranked‑keyword JSON files and apply them per asset
• Use upload_tracker.py to log each file as soon as it is submitted
• Validate CSVs by opening in a text editor to catch hidden delimiters
• Upload assets to stock platforms

Evidence

Last March I lost a whole weekend to a CSV header. I had 60 assets ready for Adobe Stock, generated the metadata file with a script I'd written in an afternoon, uploaded, and every single row got rejected on ingest.

Source

The second rejection I got, on Vecteezy this time, was for a title in ALL CAPS.

Source

The third failure was mine alone: I ran my upload batch twice on the same folder because I lost track of which files I had already submitted.

Source