SureDone's bulk editor is a powerful tool that enables you to mass automate editing, adding, and ending listings across all the marketplaces simultaneously.
- The only accepted file format for spreadsheets is CSV (comma separated values)
- When uploading images, the folder of images must be compressed into a ZIP file
- The data in the spreadsheet is not case-sensitive.
- The system will automatically ignore bad headers
- To lock in a column to all have the same value, you can set the header equal to the value.
For example, to make sure that the action is always start, you can do action=start in the header.
Another example would be if you wanted to lock in the entire column to have a stock count of 5, you could do stock=5
- The two requirements for the spreadsheet are:
- The first header (cell A1) needs to be action
- The second header (cell B1) needs to be an identifier, such as ID, SKU, or GUID. Only one of these should be used.
- The actions available for the spreadsheet are as follows:
- Start: adds the products to your inventory as a draft. This allows for reviewing the item in the system before uploading it to the marketplaces.
- Add: adds the products to the e-commerce storefront and all the marketplaces, unless the marketplaces are skipped.
- Edit: edits the products with the data provided in the uploaded spreadsheet.
- Relist: will take a product that's disabled or a draft and attempt to relist it.
- End: ends the listing on the storefront and all the marketplaces, unless the marketplaces are skipped.
- Delete: deletes the product from the database and from any marketplaces it is on. There is no way to undo this.
When uploading images in bulk, the images must be in the same order as the spreadsheet.
The two best methods of getting your photos ready for a bulk upload are:
- Prepare your spreadsheet and then take your photos in the same order as the spreadsheet.
- Take photos of your products and then type up your spreadsheet in the same order as the photos.
The mediacount header is the number of images the item has.
If you are uploading many products with the same image, you don't need to have multipel copies of the image. All you need to do is set the first mediacount to the number of images you'll be using and then type in copy for the rest of the column. This will copy the same image for every row.
Here's an example:
The file size limit for the zipped folder of images on https://www.suredone.com/bulk is 300MB.
If you need to upload a file containing images that exceeds 300MB, you need to use https://bulk.suredone.com/bulk, which allows you to upload a zip file up to 2GB.