Upload to Update/psuedo-Bulk Edit

jesse . .

1 month ago

There are a bunch of variations of this posted, so here's mine. I find it most complete while hopefully an implementation that doesn't touch much. Notably, this does not add cards and should not affect the current Import process. So not these, but the same end result:

This would allow uploading a CSV file in the current Export file format (headers) and update existing records based on that. Updates would be done by id only; importantly, the product-name, console-name, and price-in-pennies fields (like the web app) plus anything image related can't/won't be updated/changed.

Be strict but helpful. Ideally each row in the file would be validated, valid rows updated, and invalid rows displayed/emailed. If no update is done when invalid records exist, still validate the entire file and displayed/email the errors. Y'all know your validation better, but text fields could be truncated or publish size and throw errors, numbers validates or errors thrown, date fields can be the exact format or error, and hopefully all folders can be loaded once before validation then wrong ones either ignored or considered an error. Values in the fields that can't be updated would be ignored completely. For best compatibility, it would not require "all" columns (as "all" would change if fields are added to the Export), so should use matching columns regardless of order. A preview of the first couple rows preview could be helpful, but all of this can be fixed via a corrected upload.

This is also a more complete version of:
https://sportscardpro.userecho.com/communities/1/topics/690-ability-for-bulk-cost-update

Building on that, it would also allow easily adding new cards to folders or notes after adding with a workflow similar to:
Import -> Export -> Modify CSV locally -> Upload to Update

Of course it also allows one to pull down the Export, then move a bunch of cards to correct folders, find missing images (if added), etc.