Settings > Uploads
Upload any .csv, .txt, or .xlsx file to adjust information about your stock (quantity, cost, warehouse, condition, and item description), add new Merchant Fulfilled items, and create new product pages on Amazon via proxy upload.
To change information about your current stock or add new items that already exist on the Amazon catalog, follow these steps:
Choose your file from your computer and click Open.
Wait while your upload processes.
When your file is finished processing, information about your file will display. First, you’ll see the name of the file you are currently previewing and an option to upload a different file. You can select your delimiter and map your columns to the appropriate labels within Sellery.
Once your delimiter has been selected and your columns have been mapped, you can see a preview of the file you are uploading, as well as a key of which columns will be processed and which, if any, won’t be.
You can also select your preferred currency. When you are happy with the preview, you’ll select Process Data.
Your file will process.
And lastly, you will see a report of your upload.
If the system finds errors in the data you are processing in your upload, it will alert you that a number of rows have failed, show why they failed and provide a link to a quick fix file that you can edit and then re upload. Please note, these are errors found by our system, not Amazon. It is possible that Amazon would generate additional errors when they process your upload. Those errors can be seen from your Seller Central account.
Example quick fix file:
Simply download the quick fix file, make the necessary changes as indicated by the error message, save the file, and then upload (just the quick fix changes) again.
#ProTip: When uploading a cost file (sku, cost), even if a sku contained in your cost file isn’t currently in your inventory, the system will remember the cost pairing and assign that cost to that sku once it’s imported into your inventory. The same is true for supplier and lead-time-to-ship values (lead-time-to-ship uploads currently only available for Amazon.com).
You can also use the upload function to send your file to Amazon in order to create new catalog items. To add new catalog items, you MUST download the appropriate template from Amazon, fill out the required information and then upload. The proxy upload looks a little different:
The system will look through your file and determine which columns should be forwarded to Amazon and which columns should stay in house. The ending results are color coded for your quick and easy reference. Next, you’ll tell the system which of your Amazon accounts to send the items to.
Finally, you will choose how the system will process certain columns, in this example, the quantity column. You can tell the system to set your inventory quantity to the value in the file, to add the quantity in the file to the quantity that already exists, or replace your entire inventory with what’s in the file.
After sending the information to Amazon we will update your Sellery account with the data. You will need to verify the success of the upload directly on your Seller Central account.