SubmitPriceFeed

The Price feed allows you to set the current price and sale price (when applicable) for an item.

Execute

The stored procedure accepts two aggregated formats: #TEMP tables and XML aggregate

For #TEMP tables

You must include in your query:

INSERT INTO PriceFeedAggregate#TEMP (SKU, StandardPrice, StandardPriceCurrency, MAP, MAPCurrency, SalePrice, SalePriceCurrency, SaleStartDate, SaleEndDate) VALUES ('15700', '134', 'JPY', '100', 'JPY', '150', 'JPY', '2017-02-01T00:00:00Z', '2020-02-01T00:00:00Z')

INSERT INTO PriceFeedAggregate#TEMP (SKU, StandardPrice, StandardPriceCurrency, MAP, MAPCurrency, SalePrice, SalePriceCurrency, SaleStartDate, SaleEndDate) VALUES ('99987867', '134', 'JPY', '100', 'JPY', '150', 'JPY', '2017-02-01T00:00:00Z', '2020-02-01T00:00:00Z')

Then you execute the procedure by specifying the value of PriceFeedAggregate with the name of #TEMP table used PriceFeedAggregate#TEMP.

EXEC SubmitPriceFeed PriceFeedAggregate = 'PriceFeedAggregate#TEMP'

*The temporary table must be defined and used within the same connection. Closing the connection will clear out any temporary tables in memory.

For XML aggregate

The XML aggregate must follow the API structure (https://images-na.ssl-images-amazon.com/images/G/01/rainier/help/xsd/release_4_1/Price.xsd):

    <Message>
        <MessageID>1</MessageID>
        <Price>
          <SKU>15700</SKU>
          <StandardPrice currency="JPY">134</StandardPrice>
          <MAP currency="JPY">100</MAP>
          <Sale>
            <StartDate>2017-02-01T00:00:00Z</StartDate>
            <EndDate>2020-02-01T00:00:00Z</EndDate>
            <SalePrice currency="JPY">150</SalePrice>
          </Sale>
        </Price>
      </Message>
      <Message>
        <MessageID>2</MessageID>
        <Price>
          <SKU>99987867</SKU>
          <StandardPrice currency="JPY">134</StandardPrice>
          <MAP currency="JPY">100</MAP>
          <Sale>
            <StartDate>2017-02-01T00:00:00Z</StartDate>
            <EndDate>2020-02-01T00:00:00Z</EndDate>
            <SalePrice currency="JPY">150</SalePrice>
          </Sale>
        </Price>
      </Message>

EXEC SubmitPriceFeed PriceFeedAggregate = '...(the above XML)...'

Input


Name	Type	Required	Description
SKU	String	False	Required. Used to identify an individual product. Each product must have a SKU, and each SKU must be unique.
OperationType	String	False	Required. Used to specify the type of operation (Update or Delete) to be performed on the data.
StandardPrice	Double	False	Required. Price of the item (non-sale price).
StandardPriceCurrency	String	False	Required. The currency for the Standard Price.
MAP	String	False	Minimum Advertised Price. Use only if dictated by the manufacturer. Both the standard and sale price (if applicable) must be higher than the MAP value.
MAPCurrency	String	False	Minimum Advertised Price. Use only if dictated by the manufacturer. Both the standard and sale price (if applicable) must be higher than the MAP value.
SalePrice	Double	False	The price of the sale.
SalePriceCurrency	String	False	The currency of the sale.
SaleStartDate	Datetime	False	The starting date of the sale.
SaleEndDate	Datetime	False	The ending date of the sale.
PriceFeedAggregate	String	False	An aggregate representing the feed. Can be in the form of XML or a #TEMP table.

Result Set Columns