GetMyPriceForSKU()

Returns pricing information for your own active offer listings, based on SellerSKU.

Parameters

Seller_SKU_List

SQL_VARCHAR(255)

A structured list of seller SKU values.

Marketplace_Id

SQL_VARCHAR(255)

An encrypted, Amazon-defined marketplace identifier.

Returns

If the procedure fails, it throws an exception.

Otherwise, the procedure returns a table with the following columns:

MarketplaceASIN_MarketplaceId

SQL_VARCHAR(255)

A unique Marketplace ASIN Marketplace ID.

ASIN

SQL_VARCHAR(255)

An Amazon Standard Identifier Number.

SKUIdentifier_MarketplaceId

SQL_VARCHAR(255)

A unique SKU Identifier Marketplace Id.

BuyingPrice

SQL_LONGVARCHAR(2147483647)

Contains pricing information that includes promotions and contains the shipping cost.

RegularPrice

SQL_LONGVARCHAR(2147483647)

The current price excluding any promotions that apply to the product. Excludes the shipping cost.

FulfillmentChannel

SQL_VARCHAR(255)

The fulfillment channel for the offer listing.

ItemCondition

SQL_VARCHAR(255)

The item condition for the offer listing. Valid values: New, Used, Collectible, Refurbished, or Club.

ItemSubCondition

SQL_VARCHAR(255)

The item sub-condition for the offer listing.

SKUIdentifier_SellerId

SQL_VARCHAR(255)

The SKU Identifier Seller ID.

SKUIdentifier_SellerSKU

SQL_VARCHAR(255)

The SKUIdentifier Seller SKU.

SellerId

SQL_VARCHAR(255)

The SellerId submitted with the operation.

SellerSKU

SQL_VARCHAR(255)

The Seller SKU for the offer listing.