Bulk-Product Upload #511

New Issue

2026-06-29T08:38:23Z

rob commented

2026-06-29 08:38:23 +00:00

current-bulk-data-template-WITH HEADERS.csv

Add headers to the csv (they are not there currently; see 'Revised-bulk-data-template.csv attached'
Change 'Title' field name in the db to 'Product Name' ( also mentioned in #384 )
Remove ebay title (column C). Not needed any longer.
Merge UPC and EAN (columns D and E) into one new column called GTIN (see Proposed-new-bulk-data-template.csv above)
- Any existing data in the EAN field of existing instances can be dicarded. We don't need it. I don't think there is any anyway.
Rename 'Weight' header to 'Weight (oz)'
Change Sale-Price column/field in db to List-Price ( also mentioned in #384 )
Remove HTS column from this upload file. We can add this back later, after we make a Manage HTS Codes' page.
Make 'Supplier-Code' column not case sensitive. It seems not to accept Default but will accept DEFAULT.
Make sure the image URLs upload the images to the SKU images tab. I tested and it's not working since we updated image handling.
Make only SKU, Product Name and Supplier-Code required fields for uploading products in bulk
Figure out how to keep people from overwriting swaths of stuff when they don't mean to.
- One idea is to add a required column in frontw here the user must select "Update" or "Create" products. Then we can validate that any SKU collisions are either intended or not. Interstatial review screen that shows you everything that's about to happen (before and after comparisond review page and a popup asks "Are you sure?" when they press Submit.
After uploading, forward back to Products page after successful upload, with a Success message. If an error, it stays on the same page detailing the error and an option to re-upload.
Support .xslx file download and upload, not just .csv. Let user choose which template type to download and use.

[current-bulk-data-template-WITH HEADERS.csv](/uploads/7362be076066107dc83580d27d32db05/current-bulk-data-template-WITH_HEADERS.csv) [Propsed-new-bulk-data-template.csv](/uploads/7fb3b2a4bb3e4f6d28dbcb1b385656c7/Propsed-new-bulk-data-template.csv) 1. Add headers to the csv (they are not there currently; see 'Revised-bulk-data-template.csv attached' 2. Change 'Title' field name in the db to 'Product Name' ( also mentioned in #384 ) 3. Remove ebay title (column C). Not needed any longer. 4. Merge UPC and EAN (columns D and E) into one new column called GTIN (see Proposed-new-bulk-data-template.csv above) * Any existing data in the EAN field of existing instances can be dicarded. We don't need it. I don't think there is any anyway. 5. Rename 'Weight' header to 'Weight (oz)' 6. Change Sale-Price column/field in db to List-Price ( also mentioned in #384 ) 7. Remove HTS column from this upload file. We can add this back later, after we make a Manage HTS Codes' page. 8. Make 'Supplier-Code' column not case sensitive. It seems not to accept Default but will accept DEFAULT. 9. Make sure the image URLs upload the images to the SKU images tab. I tested and it's not working since we updated image handling. 10. Make only SKU, Product Name and Supplier-Code required fields for uploading products in bulk 11. Figure out how to keep people from overwriting swaths of stuff when they don't mean to. * One idea is to add a required column in frontw here the user must select "Update" or "Create" products. Then we can validate that any SKU collisions are either intended or not. Interstatial review screen that shows you everything that's about to happen (before and after comparisond review page and a popup asks "Are you sure?" when they press Submit. 12. After uploading, forward back to Products page after successful upload, with a Success message. If an error, it stays on the same page detailing the error and an option to re-upload. 13. Support .xslx file download and upload, not just .csv. Let user choose which template type to download and use.

Sign in to join this conversation.

No Label

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: rob/pms3#511