Skip to main content

Import prices from Amazon with the Amazon Product Pricing data service

Enrich your product data with partner or seller pricing from Amazon with the Amazon Product Pricing data service in Productsup.

Introduction

You can use the Amazon Product Pricing data service to import all prices offered on Amazon for each SKU or ASIN in your Productsup site and accompany the imported prices with information about the corresponding sellers, currencies, and errors. In Dataflow, you can see the prices sorted from lowest to highest.

Note

The Amazon Product Pricing data service is available for the import and intermediate stages.

The Amazon Product Pricing data service scans your ASIN or SKU attribute and creates an additional data source in your Productsup site to add six (6) new attributes in your site:

  1. ___amzn_price_sku_item_type shows whether Productsup imported prices based on your products' ASIN or SKU values.

  2. ___amzn_price_sku_item_code duplicates the values of the ASIN or SKU attribute to identify products on Amazon.

  3. ___amzn_price_sku_currency contains the currency of the product price imported from Amazon.

  4. ___amzn_price_sku_price contains the lowest price of a product imported from Amazon.

  5. ___amzn_price_sku_seller_id identifies the seller that uses the imported price to sell this product on Amazon.

  6. ___amzn_price_sku_errors shows error codes in case of problems with data import.

Prerequisites

To use the Amazon Product Pricing data service, you need:

  1. A product identifier. See Set a product identifier for more information.

  2. An attribute in your site containing ASIN or SKU data to let Productsup identify your products on Amazon and fetch their prices.

    ASIN stands for Amazon Standard Identification Number, while SKU means Stock Keeping Unit.

Add the Amazon Product Pricing data service

  1. Go to Data Services from your site's main menu and select ADD SERVICE.

  2. Search for Amazon Product Pricing, select Add, and give it a desired name and column prefix.

    By default, ___amzn_price is the column prefix.

    Amazon Product Pricing data service

  3. Choose the stage where you have your ASIN or SKU values in Service Data Level and select Add.

  4. In Attribute type, choose whether you want to use ASIN or SKU values to identify products on Amazon.

  5. In ASIN or SKU attribute, choose the attribute in your feed that contains your ASIN or SKU values.

    Note

    If you chose Import in Step 3, the ASIN or SKU attribute drop-down list displays the attributes of your import stage. If you chose Intermediate in that field, the drop-down list contains your intermediate-stage attributes.

  6. Select your market of interest in Marketplace.

  7. In Product condition, choose what products you want to fetch prices for:

    • New

    • Used

    • Collectible

    • Refurbished

    • Club

  8. In Select authentication, choose the Amazon authentication you previously set up in your organization, project, or site. If you haven't set up Amazon authentication yet, perform the following steps:

    1. Select Add New Authentication.

    2. Select Amazon Authentication (BETA version by Amazon) in Type. You can optionally give your authentication a name.

    3. Select Next.

    4. If applicable, select Region and Country to choose your marketplace country and locale.

    5. Select Connect to continue.

      Important

      Before proceeding, Productsup directs you to Amazon to finalize your authentication. After completing the authentication setup, Amazon redirects you back to Productsup.

    6. Close the confirmation window to proceed.

  9. Enter the number of days the data service should wait before fetching prices again in Expires after (days). The expected input format is a digit identifying the number of days.

    • Enter -1 to let the platform import prices for all products during every site run. This option can increase your site processing times.

    • Enter 0 to let the platform import prices only for new products in your feed. This option has the least impact on your site processing times.

    • Enter any number greater than zero (0) to let the platform import prices for all products in your feed during a site run if the entered number of days has passed since the last pricing import.

  10. Select Save.

  11. For the platform to process a new data service, select Run in the top-right corner of your site's view.

    Note

    If you can't see your new pricing data in Data View, ensure the platform hasn't hidden it:

    1. Go to Data View from your site's main menu and choose the relevant stage or export in the drop-down list on your left.

    2. Select the menu icon on the right and then select the eye icon.

    3. Find the attributes in the list that use the custom prefix ___amzn_price and select the eye icon next to each attribute you want Data View to display.

    4. Close the pop-up menu.

    The naming of the attributes created by the Amazon Product Pricing data service depends on the column prefix you choose in Step 2. The attribute names the data service generates always start with three underscores (___), which means the platform doesn't send such attributes to your export channels.

Edit the Amazon Product Pricing data service

  1. Go to Data Services from your site's main menu.

  2. Search for your data service.

  3. Select the cogwheel icon (⚙) next to the desired data service to edit settings.

  4. Select Save.

Delete the Amazon Product Pricing data service

  1. Go to Data Services from your site's main menu.

  2. Select the cogwheel icon (⚙) next to the desired data service.

  3. In the Danger Area panel, select Remove this service.

  4. Select Yes.

In this section: