Enable macros in Excel

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.

Enable Macros in Microsoft Excel 2007

If macros are not enabled, you will see a notification in the message bar.

1. Click Options on the Message Bar.

   A security dialog box opens giving you the option to enable the macro.

2. Select Trust all documents from this publisher.

   This will enable you to use the template in the future without having to repeat this step every time you open it.

3. Click OK.

   The menu will become available as a ribbon under Add-Ins as shown below.

Enable Macros in Microsoft Excel 2002 and Excel 2003

If macros are not enabled, you will see the following screen when you open the template.

To enable macros follow these steps:

1. Check the Always trust macros from this publisher checkbox.

   The Enable Macros button will then be enabled.

2. Click Enable Macros button.

   The menu will become available as a toolbar within Excel.

Set Amazon MWS Credentials for Product Lookup and Upload Macros

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

1. On the first page, select I want to access my own Amazon seller account with MWS and then click Next.
2. On the next page, read the Amazon MWS License Agreement, check the box to confirm that you have read it and agree to the terms.
3. Click Next and copy your credentials from the page that appears, and save them for later use.