Products.get_competitive_pricing_for_asins Returns No Data for Some ASINs!? | Amazon Selling Partner API
I'm using the API to get competitive pricing information in the Japan marketplace (marketplace ID: A1VC38T7YXB528), but I ran into a phenomenon where information for a number of ASINs couldn't be retrieved as expected.
Execution environment: AWS Lambda
Runtime: python3.9
The code I'm running is as follows
from sp_api.api import Products
from sp_api.base.marketplaces import Marketplaces
def lambda_handler(event, context):
ASIN_LIST = ['B099RSQ9JR', 'B09SYMGWNM', 'B08ZHSWRJN', 'B0921SBWSY', 'B07QGSRCZD']
obj = Products(marketplace=Marketplaces.JP, credentials=event['credentials'])
result = obj.get_competitive_pricing_for_asins(ASIN_LIST)
return result.payload
Running it with the target ASINs ['B099RSQ9JR', 'B09SYMGWNM', 'B08ZHSWRJN', 'B0921SBWSY', 'B07QGSRCZD'] returns results for only 2 of the 5 ASINs.
Result
[
{
"ASIN": "B099RSQ9JR",
"Product": {
"CompetitivePricing": {
"CompetitivePrices": [
{
"belongsToRequester": false,
"condition": "New",
"subcondition": "New",
"Price": {
"LandedPrice": {
"CurrencyCode": "JPY",
"Amount": 12000
},
"ListingPrice": {
"CurrencyCode": "JPY",
"Amount": 12000
},
"Shipping": {
"CurrencyCode": "JPY",
"Amount": 0
}
},
"CompetitivePriceId": "1"
}
],
"NumberOfOfferListings": [
{
"condition": "New",
"Count": 4
},
{
"condition": "Any",
"Count": 4
}
]
},
"Identifiers": {
"MarketplaceASIN": {
"MarketplaceId": "A1VC38T7YXB528",
"ASIN": "B099RSQ9JR"
}
},
"SalesRankings": [
{
"ProductCategoryId": "fashion_display_on_website",
"Rank": 34189
},
{
"ProductCategoryId": "2221186051",
"Rank": 146
}
]
},
"status": "Success"
},
{
"ASIN": "B09SYMGWNM",
"Product": {
"CompetitivePricing": {
"CompetitivePrices": [],
"NumberOfOfferListings": []
},
"Identifiers": {
"MarketplaceASIN": {
"MarketplaceId": "A1VC38T7YXB528",
"ASIN": "B09SYMGWNM"
}
},
"SalesRankings": []
},
"status": "Success"
},
{
"ASIN": "B08ZHSWRJN",
"Product": {
"CompetitivePricing": {
"CompetitivePrices": [],
"NumberOfOfferListings": []
},
"Identifiers": {
"MarketplaceASIN": {
"MarketplaceId": "A1VC38T7YXB528",
"ASIN": "B08ZHSWRJN"
}
},
"SalesRankings": []
},
"status": "Success"
},
{
"ASIN": "B0921SBWSY",
"Product": {
"CompetitivePricing": {
"CompetitivePrices": [],
"NumberOfOfferListings": []
},
"Identifiers": {
"MarketplaceASIN": {
"MarketplaceId": "A1VC38T7YXB528",
"ASIN": "B0921SBWSY"
}
},
"SalesRankings": []
},
"status": "Success"
},
{
"ASIN": "B07QGSRCZD",
"Product": {
"CompetitivePricing": {
"CompetitivePrices": [
{
"belongsToRequester": false,
"condition": "New",
"subcondition": "New",
"Price": {
"LandedPrice": {
"CurrencyCode": "JPY",
"Amount": 16000
},
"ListingPrice": {
"CurrencyCode": "JPY",
"Amount": 16000
},
"Shipping": {
"CurrencyCode": "JPY",
"Amount": 0
}
},
"CompetitivePriceId": "1"
}
],
"NumberOfOfferListings": [
{
"condition": "New",
"Count": 2
},
{
"condition": "Any",
"Count": 2
}
]
},
"Identifiers": {
"MarketplaceASIN": {
"MarketplaceId": "A1VC38T7YXB528",
"ASIN": "B07QGSRCZD"
}
},
"SalesRankings": [
{
"ProductCategoryId": "fashion_display_on_website",
"Rank": 239300
},
{
"ProductCategoryId": "2221209051",
"Rank": 1920
}
]
},
"status": "Success"
}
]
Specifying the target ASIN ['B099RSQ9JR'] does return a result.
Result
[
{
"ASIN": "B099RSQ9JR",
"Product": {
"CompetitivePricing": {
"CompetitivePrices": [
{
"belongsToRequester": false,
"condition": "New",
"subcondition": "New",
"Price": {
"LandedPrice": {
"CurrencyCode": "JPY",
"Amount": 12000
},
"ListingPrice": {
"CurrencyCode": "JPY",
"Amount": 12000
},
"Shipping": {
"CurrencyCode": "JPY",
"Amount": 0
}
},
"CompetitivePriceId": "1"
}
],
"NumberOfOfferListings": [
{
"condition": "New",
"Count": 4
},
{
"condition": "Any",
"Count": 4
}
]
},
"Identifiers": {
"MarketplaceASIN": {
"MarketplaceId": "A1VC38T7YXB528",
"ASIN": "B099RSQ9JR"
}
},
"SalesRankings": [
{
"ProductCategoryId": "fashion_display_on_website",
"Rank": 34189
},
{
"ProductCategoryId": "2221186051",
"Rank": 146
}
]
},
"status": "Success"
}
]
Specifying the target ASIN ['B09SYMGWNM'] returns no result.
Result
[
{
"ASIN": "B09SYMGWNM",
"Product": {
"CompetitivePricing": {
"CompetitivePrices": [],
"NumberOfOfferListings": []
},
"Identifiers": {
"MarketplaceASIN": {
"MarketplaceId": "A1VC38T7YXB528",
"ASIN": "B09SYMGWNM"
}
},
"SalesRankings": []
},
"status": "Success"
}
]
I've confirmed that the ASINs which returned no result are valid and do exist on www.amazon.co.jp. The same phenomenon occurs with ASINs other than the samples given here.
As for the credentials used for authentication, since results are returned in some cases, I've confirmed they are correct and hold the necessary permissions.
I checked the documentation and tried the troubleshooting steps, but the problem wasn't resolved.
I raised the issue with Amazon Selling Partner developer support and on the forum at https://developer.amazon.com/.
The answer I received from support was:
For products where a color can be selected, you need to specify and call with the ASIN as it appears when the color is clicked.
So for products with variations such as color or size, you have to specify the ASIN information selected down to the variation level.
Well then — once you get the answer it's nothing much, but it had me stuck for quite a while.
![[September 2026] AI & IT News Roundup for SMBs｜6 Handpicked Stories](https://static.wixstatic.com/media/5b7c68_147333112cfc4639a957819174666aea~mv2.png/v1/fill/w_980,h_515,al_c,q_90,usm_0.66_1.00_0.01,enc_avif,quality_auto/5b7c68_147333112cfc4639a957819174666aea~mv2.png)
Comments