How to retrieve current sale price and dates via MWS / Amazon Reports

Question

I've looked through all the report documentation I can find and the various MWS operations, but I cannot for the life of me find any way to retrieve the currently set sale price, sale start date and sale end date for the SKUs we are currently selling.

For clarification: I am trying to retrieve the SALE price, not the standard 'listing price'. When editing an item directly via Seller Central these fields are labelled Sale Price, Sale From Date and Sale End Date. Which are separate to the main price, which is labelled Your price.

Is my search-fu lacking or is this information not retrievable via MWS (either directly or via some report or another)?

Many thanks!

C

Answer 1

When you call GetMyPriceForSKU and supply your SKU you will get back results that will include the following:

<Offers>
  <Offer>
    <BuyingPrice>
      <LandedPrice>
        <CurrencyCode>USD</CurrencyCode>
        <Amount>217.76</Amount>
      </LandedPrice>
      <ListingPrice>
        <CurrencyCode>USD</CurrencyCode>
        <Amount>189.00</Amount>
      </ListingPrice>
      <Shipping>
        <CurrencyCode>USD</CurrencyCode>
        <Amount>28.76</Amount>
      </Shipping>
    </BuyingPrice>
    <RegularPrice>
      <CurrencyCode>USD</CurrencyCode>
      <Amount>199.00</Amount>
    </RegularPrice>
    <FulfillmentChannel>MERCHANT</FulfillmentChannel>
    <ItemCondition>New</ItemCondition>
    <ItemSubCondition>New</ItemSubCondition>
    <SellerId>YOURSELLERID</SellerId>
    <SellerSKU>YOUR_SKU</SellerSKU>
  </Offer>
</Offers>

This example is a Product that has a Sale Price set in Seller Central.

You will see that the ListingPrice is 189.00. This is the Sale Price.

      <ListingPrice>
        <CurrencyCode>USD</CurrencyCode>
        <Amount>189.00</Amount>
      </ListingPrice>

Below you will see RegularPrice is 199.00. This is the normal Price.

    <RegularPrice>
      <CurrencyCode>USD</CurrencyCode>
      <Amount>199.00</Amount>
    </RegularPrice>

The example below is from a Product that does not have a Sale Price set. Notice the ListingPrice and RegularPrice are the same.

  <Offer>
    <BuyingPrice>
      <LandedPrice>
        <CurrencyCode>USD</CurrencyCode>
        <Amount>33.60</Amount>
      </LandedPrice>
      <ListingPrice>
        <CurrencyCode>USD</CurrencyCode>
        <Amount>24.45</Amount>
      </ListingPrice>
      <Shipping>
        <CurrencyCode>USD</CurrencyCode>
        <Amount>9.15</Amount>
      </Shipping>
    </BuyingPrice>
    <RegularPrice>
      <CurrencyCode>USD</CurrencyCode>
      <Amount>24.45</Amount>
    </RegularPrice>
    <FulfillmentChannel>MERCHANT</FulfillmentChannel>
    <ItemCondition>New</ItemCondition>
    <ItemSubCondition>New</ItemSubCondition>
    <SellerId>YOUR_SELLERID</SellerId>
    <SellerSKU>YOUR_SKU</SellerSKU>
  </Offer>

Unfortunately Amazon does not provide the Sale Begin and End dates through the feed. As of right now I dont know a way to retrieve those dates. If you wanted to find out all the Products on Sale you could simply compare ListingPrice and RegularPrice of each Product. When the Sale expires the ListingPrice will revert back to RegularPrice.