You can use macros to import your listing information from other files, perform data validation, and submit your listings to Amazon within Excel using one click. You must enable macros in Excel to use these advanced functions.
Follow the instructions below to enable macros based on the version of Microsoft Excel you are using.
If macros are not enabled, you will see a notification in the message bar.
A security dialog box opens giving you the option to enable the macro.
This will enable you to use the template in the future without having to repeat this step every time you open it.
The menu will become available as a ribbon under Add-Ins as shown below.
If macros are not enabled, you will see the following screen when you open the template.
To enable macros follow these steps:
The Enable Macros button will then be enabled.
The menu will become available as a toolbar within Excel.
The Product Lookup, and Upload macros in the Listing Loader template require authorization through Amazon Marketplace Web Service (Amazon MWS).You can retrieve and import your authorization credentials from within the template itself. Click one of the macros that requires authorization, and you will be prompted through the process. You will also be prompted to create a security password for using the template macros.
If you previously retrieved your credentials but want to import them again, click the Credentials macro at the top of the template, and then click I have forgotten or would like to obtain my MWS credentials.
You can also get your credentials when the template is not open by going to Amazon Marketplace Web Service Registration