Follow

How to: Export my product data from Amazon

Created:   |   Updated:

Amazon provides the option to download various Inventory Reports.  These can be readily configured to upload into your ShippingEasy Product Catalog.

The Amazon Active Listings report includes several of the data fields that can be saved to the Product Catalog:

  • SKU
  • Name (Description)
  • Price (Declared Value)

However, some data fields are missing and will need to be added to the Amazon Active Listings report before uploading it to ShippingEasy. Keep in mind that these fields are optional, but the more data you provide for each product, the more useful the Product Catalog will be:

  • Weight
  • Image URL
  • Country of Manufacture
  • Warehouse Bin/Location
  • Harmonized Code

If you're ready to download your Amazon Active Listings report and configure it to upload to your ShippingEasy Product Catalog, just follow these steps:

  1. Log into your Amazon sellers account.
  2. On the Inventory tab, select Inventory Reports.
  3. Select the Active Listings Report from the drop-down menu. 
  4. Click the Request Report button.
  5. Reports generally take 15 to 45 minutes to generate. You can return to this page later to pick up your completed report.
  6. Under Check Report Status & Download, when the Report Status is "Ready," click the Download button.
  7. Save the file to your local computer.
  8. Open the file on your computer in a spreadsheet editor.
  9. Add the following columns (they may be placed in any order). Learn more about the data fields that can be uploaded to your Product Catalog
    • weight
    • image URL
    • country of manufacture
    • warehouse bin/location
    • harmonized code
  10. Fill in any of the data that you have available for each product in each new column.
  11. Once complete, save the sheet as a CSV file. Learn more about creating CSV files.
  12. Now you're ready to upload your file to ShippingEasy. Use our upload guide to get started. At step 3, map the data fields as follows:

    Column Header Field Name in ShippingEasy
    seller-sku SKU
    item-name Description
    price Declared value
    weight Weight
    country of manufacture Country of Manufacture
    image URL Image URL
    warehouse bin/location Warehouse Bin/Location
    harmonized code Harmonized code

 

Once you complete the CSV upload to ShippingEasy, you're done! Your new Product Listings will start updating new Amazon orders as they sync.


Related articles:

FAQs: Product Catalog
How to: Add items to my Product catalog
How to: Edit items in the Product Catalog
How to: Upload product images to my Product Catalog
What is a Product Category?

Comments

Please sign in to leave a comment.

Community browse

COMMUNITY FORUMS

Questions & Answers

Issues & Bugs

Beta Feedback

FEATURE REQUESTS

Productivity: Features, Interface & Settings

Partners: Integrations, Carriers & Stores

Shipping: Orders, Labels & Shipments

Inventory: Products, Purchase Orders & Suppliers