How to add existing Amazon ASINs via File Template to your Catalog

And on the next page, select the download and inventory file link, or you can select add products via upload from the inventory dropdown menu. Both options will take you to the same page, on this page scroll down to the inventory files header. And click on the inventory loader file name alongside the product matching only file type. On the new page that opens click on the inventory loader template in order to download it.

Once you open the template. It is imperative to take note of the first worksheet called data definitions. As this contains the meanings of the various numerical options available to you when creating your products, definitions, and use for each field and which values are accepted for each sell, it also highlights which information is required and which optional or desired.

We would like to encourage you to fill in as much information as you possibly can here to make your listings as complete as possible, thereby assisting consumers and finding and purchasing the right product. On the inventory loader template. Remember that all columns highlighted in yellow are required, so you will need to complete all information here.

All columns, highlighted peach or orange are desired. So please do your best to complete all information here too. The white fields are not required and are optional. If you have the information as you fill in information, some previously non highlighted columns may become highlighted in red due to further relevant information required.

These you would then need to also complete. Your fields and the template are as follows, SKU required. Product ID desired. This is the product’s current UPC, EAN, ISBN or ASIN, whichever you choose to use. Product ID type desired. You would need to accept the relevant number based on which product ID used in the previous sell.

For example, if you used the ASIN BO7PH37CQL, then you would need to select the number one from the dropdown menu. As one is for ASIN.

Price desired minimum seller allowed price desired, maximum seller allowed price desired, item condition desired. Again, you would need to enter the relevant number as explained and defined in the definitions, in the data definitions worksheets, quantity desired. This is not required of the items are being listed as FBA.

Add delete desired. You would need to select the relevant letter based on the definitions of each as shown on the data definitions worksheets. For the purpose of this video, you would select a for update or add will ship internationally desired. You would need to select the relevant number or letter from the dropdown menu as provided in the data definitions worksheets.

Expedited shipping desired, standard plus desired. You would need to select the relevant letter based on the definitions of each as shown in the data definitions worksheets, item, note desired, fulfillment center ID, select default for FBM and Amazon NA for FBA. Product tax code, handling time, merchant shipping group name batteries required only in the case of FBA are batteries included only in the case of FBA, battery sell composition, only in the case of FBA, battery time owning the case of FBA, number of batteries only in case of FBA.

Battery weight only in the case of FBA, the number of lithium ion sells only in the case of FBA, the number of lithium metal sells only in the case of FBA, the lithium battery packaging only in the case of FBA, lithium battery energy content also only in the case with FBA, lithium battery energy content unit of measure lithium battery weights.

Also both only in the case of FBA lithium battery weight units of measure only in the case of FBA, supplier declared DGH said regulation one, and two all the way through to five hazmat United nations regulatory ID, safety data sheet URL, the item weight, the item weight, unit of measure item volume, item volume units of measure, flash points, GS classification, class one through to class three, the California proposition 65 compliance type California proposition 65 chemical names, one through to five.

Once you have completed all the relevant fields that you can save your file in TXT format, as it cannot be uploaded in CSV or Excel, formats, and returned to the page from where you downloaded it originally, that is the ad products via upload page located in the dropdown menu of the inventory tab on seller central, select the check and upload your inventory file tab.

Along the top of the page to check your file first, select your file type from the dropdown menu provided.

Choose your file by clicking on the gray choose file button and you can enter your email address. Should you wish to be notified once your file is being uploaded? Click the yellow check file button there after.

Then click on the monitor upload status tab at the top of the page. Once you have uploaded your template for checking, if your upload status says records that require further action from you are saved as drafts, then you need to fix certain fields in your template. Under the actions column, click on the complete drafts.

The next page will show a table of items that you need to fix, which you can then choose to do manually line by line per product. By clicking on the relevant links in the action column, you can also choose to bulk select if your fixes are the same for multiple SKUs. Once you have made all the necessary amendments.

Click the yellow save all button at the top right of the table. Once you have fixed the relevant errors, you can download the processing report by clicking the download your processing report link on the monitor upload status tab on the ad products via upload page.

Open this template, and then use the fixed errors from this file. To insert into your inventory. Loader template,

save this template again and return to the ad products via upload page, select the check and upload your inventory file tab along the top of the page. Under the step two upload file hitter. Select your file type from the dropdown menu provided. Choose your file by clicking on the gray choose file button, and you can end an email address.

Should you wish to be notified once your file has been uploaded, select the processing report and note that Excel is preferred. Click the yellow upload button and your products will be uploaded to your catalog. You can choose to skip the check file in step one and go straight to uploading your inventory load of flat file.

As this step will still show you on the monitor upload status tab, whether there are any errors in your file upload or not.