Building Adobe, Vecteezy and Dreamstime CSVs From One Folder of Assets
I still have the rejection email open in a tab from last March. I had generated a batch of 120 sticker assets, spent an evening building what I thought was a clean upload spreadsheet, pasted 120 rows into Adobe Stock, and got back a parse error before a single row was reviewed. The header was wrong. Not the content, not the keywords, the header. Five columns, and I had six. That one night is the…
Generating CSVs for Adobe Stock, Vecteezy, and Dreamstime from a single folder of assets can be a tedious task. The author shares their experience of learning the hard way, as they faced rejection emails and parse errors due to incorrect headers. After realizing the mistake, they built a script called make_metadata.py that generates the exact headers required by each platform.
This script takes one folder of assets and outputs the necessary CSVs, ensuring that the header can never drift because it is hardcoded in the code. The author emphasizes the importance of treating metadata as output from a script rather than a document, to prevent silent mistakes from accumulating in spreadsheets. They also discuss the importance of keeping track of uploaded files using an upload_tracker.py script, which prevents duplicate submissions and maintains trust with reviewers.
The author recommends a specific folder layout for organizing assets, research, and scripts, which helps in keeping track of everything as the number of products grows. They stress the importance of minimizing memory usage and running the pipeline on a single core with limited resources. Finally, the author highlights the significance of packaging assets with a real cover and thumbnail, as it greatly impacts sales.
The complete solution is detailed in the "ai sticker factory playbook" which includes all the scripts and the process behind them.
Written by urgent.news from Dev.to's reporting — not their text. Machine-written — may contain errors; check the original before relying on it.
