After the file is uploaded it will begin processing. Larger uploads can take some time. While the file is processing you will see the status as “Pending.” Once the file is done processing, the status will change to Complete and a results file will appear. This guide will tell you how to read these files & use them to assure everything processes as you'd expect.
Even for experienced users, it's important to check the results files after you do a bulk upload to make sure that everything is processed as you expected.
Results Interface:
The result interface cam be accessed Products > Bulk Results or on the sidebar under bulk > Results:
The bulk results interface includes the name of the file submitted in the bulk request and results file name allowing it to be easily identified.
It includes the number of actions in Actions column, but there is a new Status column that breaks down the progress of the upload into the following stages:
- Status (will show Pending or Complete)
- Reading
- Database
- Channels
- Finishing
When the file is finished processing, a Download link will show in the Results column. However, with Version 3, there is also the option to cancel uploads if they are still in Pending state. If an upload can be canceled, a Cancel link will show at the bottom of the stage in the Status column:
Please keep in mind, that cancelling an upload doesn't necessarily mean nothing got updated. Updates on items are continuous but once canceled, it will stop processing rows going forward. A results file will be downloadable to see which items got updated.
2. Find the upload you need.
- Request Date: The timestamp of the upload (local time)
- Actions: The number of actions (products edited/relisted etc)
- Status: Progress of the upload
- Uploaded File: Creates a downloadable link of the file that was uploaded
- Results File: Creates a downloadable link of the results file
3. Click the second blue “Download” link to get the "Results File"
- You can also download the file uploaded for reference.
- The file will download to your downloads folder - locate it and open it in a spreadsheet application such as Excel.
- How to Use The Results File -
The results file always exports the same headers, here is what they mean:
- Line - This is the line in the bulk upload file that corresponds to this result (excluding the headers)
- Action - This tells you what action was performed on the product in the bulk upload file.
- Guid - (could also be ID or SKU depending on the identifier used) This tells you which product the action was performed on.
- Result - This is the SureDone result. It tells you if the changes in your spreadsheet were saved to SureDone. It does not tell you if it listed correctly to your channels.
- Errors - This tells you whether the product listed correctly on your channels. No errors means it listed successfully. If there are any critical errors (the kind that would prevent information from being saved, or a new listing being created on any channel) they will be placed here.
- Messages - This is where an additional messages from the channels will be, such as Warnings - these should not stop your listings from going through, but are important to address.
- Notices- Notices are all other messages, usually from SureDone, are placed here.
The most important columns to check are the results and errors columns as it will tell you if your listings are going through or not. If there is an error here then you need to address it. It will usually be clear what the issue is, such as missing or invalid data. Flags Set at the bottom of Column 1 are to remind you of which selections you made before upload, such as skipping certain channels or importing media. You can look up common error codes here.
Important:
- Getting a “success” message in the results column does not guarantee your listing went through.
- Amazon always shows success due to their queuing system.
Now that you've successfully uploaded a product edit and checked the results. Go back and fix any erros in your upload before moving on. You'll want to make sure that you can edit products successfully before trying to add products from scratch.
Once you've got that down, the next guide will explain how to Upload Images to Products in Bulk.
This guide is a part of the “Introduction to Bulk” Series - for maximum learning, please read all the guides in the series! To view the whole series, go here!