The previous blog article „Using the Amazon SellerCentral Inventory report“ has shown you how you can create and download an inventory report via SellerCentral which will give you quick access to your account’s product data along with product and price information.
With this article we will show you how to use your account’s inventory report in order to create a new product feed which can then be uploaded into your SellerCentral account. This might be helpful for those cases where you no longer have access to your original product feed. Using your SellerCentral’s Inventory Report in conjunction with the „ListingLoader
“ template will allow you to re-create a standard product feed from scratch.
Before you continue, make sure that you create an inventory report and import it into Excel. Refer to the previous blog article in case you have questions. Once you’ve imported the file into Excel, make sure that you do not close the file. In the following steps, we will need to access this data and have it transferred to the ListingLoader template.
The next step includes downloading the ListingLoader template from SellerCentral help: Go to Manage Inventory -> Reference -> Text-file Templates -> ListingLoader
, download the file and open it in Excel.
Just like all other product templates on Amazon SellerCentral, the ListingLoader template basically consists of multiple tabs in Excel, covering the template areas such as „data definitions“, „instructions“ etc. Before we continue with the next steps, we may need to activate the Excel macro settings in order to activate the ListingLoader functionality.
If Excel should show you a security warning which indicates that the template’s macros have been deactivated, you need to activate them by clicking on the Options button and selecting Enable this content. The ListingLoader template will only work when the macro settings are enabled.
Once the activation of the macros was successful, you will see an additional menu option in the template.
Now go to the „Listings-Template“tab. We will now transfer price, quantity, SKU and ASIN from our inventory report over to the ListingLoader template.
This is our inventory file that we’ve imported from SellerCentral:
We will now transfer the information over to the ListingLoader template. The final result should look like this:
Now go to the template’s Add-Ins tab. Excel will now give you access to the ListingLoader’s special functions that we will use for the next steps.
For this blog article, we will use the „Bulk Lookup“function which will run a query on the Amazon database for all items that you’ve entered. If the item exists, the ListingLoader will automatically retrieve information such as the product title from the Amazon database and have it added to your product offer data.
Click on the „Bulk Lookup“button. The Listingloader now accesses the Amazon database which is indicated by a progress window.
Once finished, our ListingLoader template looks a little bit different:
Information such as the product condition as well as the product title have been retrieved from the Amazon database and have automatically been added to the ListingLoader template. The file is now ready for being transferred into your SellerCentral account.
Uploading your ListingLoader data can either be done directly in the template by clicking on the Upload File button. Alternatively, you can save your ListingLoader file as tab-delimited text file and upload the text file via SellerCentral.
In comparison to a regular product template, you will notice that the ListingLoader does only contain very few columns. Standard columns such as “product description” or “images” are missing. The reason behind that is that the ListingLoader’s main purpose is to provide an option for easily creating offer data for existing items on the Amazon platform. The offer data will then borrow the product description, images etc. from the existing product data. In case you still want to supply your own e.g. product description, you can transfer the ListingLoader’s content over to a regular product template and amend it accordingly.