Listings API putListingsItem How To Update price and quantity?

[doverradio]

All I want to do is use the Amazon SP-API Listings API's putListingsItem call to update the price and quantity of an item I have listed.

productType

According to the ListingsItemPutRequest docs, productType and attributes are required for this call.

Firstly, to obtain the correct productType value, you are supposed to search for a product definitions type using the Product Type Definitions API. So, I do that, and call searchDefinitionsProductTypes, just to discover my product has no matching product type.

Ultimately, I gave the value PRODUCT for productType field. As a result, the getDefinitionsProductType call returned an object containing an array of propertyNames, shown below:

        "propertyNames": [
            "skip_offer",
            "fulfillment_availability",
            "map_policy",
            "purchasable_offer",
            "condition_type",
            "condition_note",
            "list_price",
            "product_tax_code",
            "merchant_release_date",
            "merchant_shipping_group",
            "max_order_quantity",
            "gift_options",
            "main_offer_image_locator",
            "other_offer_image_locator_1",
            "other_offer_image_locator_2",
            "other_offer_image_locator_3",
            "other_offer_image_locator_4",
            "other_offer_image_locator_5"
        ]
    },

On seeing this, I decide list_price and fulfillment_availability must be the price and quantity and then try using these in my code below.

attributes

The attributes value is also required. However, their current docs show no clear example of what to put for these values, which are where I must put price and quantity somewhere.

I found this link about patchListingsItem and tried to implement that below but got an error.

code:

// trying to update quantity... failed.

    a.response =  await a.sellingPartner.callAPI({
        operation:'putListingsItem',
        path:{
          sellerId: process.env.SELLER_ID,
          sku: `XXXXXXXXXXXX`
        },
        query: {
          marketplaceIds: [ `ATVPDKIKX0DER` ]
        },
        body: {
          "productType": `PRODUCT`
          "requirements": "LISTING_OFFER_ONLY",
          "attributes": {
                "fulfillment_availability": {
                    "fulfillment_channel_code": "AMAZON_NA",
                            "quantity": 4,
                            "marketplace_id": "ATVPDKIKX0DER"
                        }
                    }
      });

    console.log( `a.response: `, a.response )

error:

{
	"sku": "XXXXXXXXXXXX",
	"status": "INVALID",
	"submissionId": "34e1XXXXXXXXXXXXXXXXXXXX",
	"issues": [{
		"code": "4000001",
		"message": "The provided value for 'fulfillment_availability' is invalid.",
		"severity": "ERROR",
		"attributeName": "fulfillment_availability"
	}]
}

I also tried using list_price :

// list_price attempt... failed.

    a.response =  await a.sellingPartner.callAPI({
        operation:'putListingsItem',
        path:{
          sellerId: process.env.SELLER_ID,
          sku: `XXXXXXXXXXXX`
        },
        query: {
          marketplaceIds: [ `ATVPDKIKX0DER` ]
        },
        body: {
          "productType": `PRODUCT`
          "requirements": "LISTING_OFFER_ONLY",
          "attributes": {
                "list_price": {
                    "Amount": 90,
                    "CurrencyCode": "USD"
                }
      });

    console.log( `a.response: `, a.response )

Error (this time seems I got warmer... maybe?):

{
	"sku": "XXXXXXXXXXXX",
	"status": "INVALID",
	"submissionId": "34e1XXXXXXXXXXXXXXXXXXXX",
	"issues": [{
		"code": "4000001",
		"message": "The provided value for 'list_price' is invalid.",
		"severity": "ERROR",
		"attributeName": "list_price"
	}]
}

How do you correctly specify the list_price or the quantity so this call will be successful?

Just tryin to update a single item's price and quantity.

[AshleyBurr]

I am keen to know the answer to this one too.

[shirushi-dev]

me toooo

[tbrains]

@doverradio

Update the purchasable_offer attribute to update the price with patchListingItems, Ex:

        patch_data = {
            "productType":
            "PRODUCT",
            "patches": [{
                "op":
                "replace",
                "path":
                "/attributes/purchasable_offer",
                "value": [{
                    "marketplace_id": marketplace_data.marketplace_id,
                    "currency": currency,
                    "our_price": [{
                        "schedule": [{
                            "value_with_tax": f"{price:.2f}"
                        }]
                    }]
                }]
            }]
        }

[doverradio]

@tbrains

I rewrote my patchListingsItem call in the following way, based upon your suggestion:

let price = 50
let sku = `XXXXXXXXXX`
let response =  await sellingPartner.callAPI({
            operation:'patchListingsItem',
            path:{
              sellerId: `XXXXXXXXXX`,
              sku: sku
            },
            query: {
              marketplaceIds: [ `XXXXXXXXXX` ]
            },
            body: {
              "productType": "PRODUCT",
              "patches": [{
                "op":
                "replace",
                "path": "/attributes/purchasable_offer",
                "value": [{
                    "marketplace_id": 'XXXXXXXXXX',
                    "currency": 'USD',
                    "our_price": [{
                        "schedule": [{
                            "value_with_tax": price
                        }]
                    }]
                }]
            }]
          } } );

The result looked very promising...

{
    "sku": "XXXXXXXXXX",
    "status": "ACCEPTED",
    "submissionId": "xxxxxxxxxxxxxxxxxxxxxx",
    "issues": []
}

Unfortunately, after waiting, the price remained same.

[tbrains]

It takes few minutes to reflect in the dashboard.

[doverradio]

@tbrains YOU GENIUS!!!!

Ok, it completely worked guys, he knows the way.

Please, can you show how to do quantity next?

[tbrains]

Quantity is similar, you have to patch the attribute fulfillment_availability,

fulfillment_channel_code = "DEFAULT"  # MFN

patch_data = {
    "productType":
    "PRODUCT",
    "patches": [{
        "op": "replace",
        "path": "/attributes/fulfillment_availability",
        "value": [{
            "fulfillment_channel_code": fulfillment_channel_code,
            "quantity": quantity
        }]
    }]
}

[shirushi-dev]

@tbrains

Is it possible to update "fulfillment_availability" only for "patchListingsItem"?
I'm confused because I'm not sure how to use "patchListingsItem" and "putListingsItem".

(From Google Translate)

[tbrains]

@shirushi-dev

putListingsItem: This is used to Create or Fully Update Listings.
patchListingItem: This is used to partially update a listing.

If you are just updating price and quantity of an existing listing, then putListingItem is perfect, read more.

If you are using python, then you can check this library.

[shirushi-dev]

@tbrains
Is it possible to update "fulfillment_availability" using "patchListingsItem"?

I couldn't do that.

[tbrains]

@shirushi-dev, its possible for MFN listings.

[shirushi-dev]

@tbrains
It's done! Thank you very much.

[michael-land]

is it possible to update business price via Listing API?

[tbrains]

@xiaoyu-tamu, right now its not possible to update the business price via Listing API.

[stefnats]

Just to be clear, the feeds Api is able to do that.

[Javadebi]

I know it's not relevant to this question, but may I ask how you guys extract these object structures from the schema? I mean programmatically?

[dev-pecaagora]

I receive an accept but nothing changes on Amazon, it's been more than 2 hours
help me

[Robinhood2009]

@tbrains
@BashaBill

Hello!
I am trying to use putListingsItem but I can't figure out what the body should look like. The example given in the documentation does not work. If anyone could help that would be amazing this is what I have currently:

[steven-so]

@tbrains thank you list_price update success Must have the following format, which is different from purchasable_offer. {"productType":"PRODUCT","patches":[{"op":"replace","path":"/attributes/list_price","value":[{"currency":"USD","marketplace_id":"ATVPDKIKX0DER","value":14.98}]}]}

Thanks for sharing this find.

Does anyone know if changing "List Price" through xml also works? I've tried changing MaximumRetailPrice through the feed but that didn't seem to work.

[dialdhruv]

How to update maximum retail price (MRP) ?

[chapmanjw]

How to update maximum retail price (MRP) ?

@dialdhruv See this answer: #1289

[qdev89]

hi guys,
I'm really stuck on fileld merchant_suggested_asin, it's a required filed for a product type definitions (TEMPORARY_TATTOO) but I don't know how to fill it to complete my API call.

1. If I put
   "merchant_suggested_asin": [ { "value": "WPID||ASIN" } ],
   It will return as issue on
   "issues": [ { "code": "8105", "message": "The data you provided for an attribute is invalid. Please refer the data definitions and resubmit with a valid value.", "severity": "ERROR", "attributeNames": [ "merchant_suggested_asin" ], "categories": [ "INVALID_ATTRIBUTE" ] } ],

   2. If I put a random number on this, it will return issue as :
      "code": "8541", "message": "The Listing data provided is different from what's already in the Amazon catalog. The item_id provided matches ASIN 0000000000, but some of the listing data contradicts what is already in the Amazon catalog. The following listing attribute value(s) conflict with Amazon catalog value(s): 'item_name' (Merchant [\"100 PCS Two Fast Race Car Temporary Tattoos Stickers Theme 2nd Birthday Party Decorations Favors Supplies Decor 2 Fast Racing Checkered Tattoo Sticker Gifts For Boys Girls School Prizes Carnival\"] / Amazon [en_US: \"Finding Peaches in the Desert\", en_IN: \"Special Education Teachers Kit: The Cartography of Syntactic Structures, Volume 6\", en_GB: \"Ksiega Diny: The Cartography of Syntactic Structures, Volume 6 (Äldre Svenska Frälsesläkter)\" and 19 other variant(s) en_SG, en_CA, en_AE, en_AU, nl_NL, de_DE, fr_FR, pl_PL, es_ES, hi_IN, zh_CN, ja_JP, es_MX, fr_BE, pt_BR, sv_SE, it_IT, ar_AE, tr_TR]), 'customer_id' (Merchant [\"692323389502\"] / Amazon []). To fix the issue, please follow these steps 1) If the product you are listing is the same as 0000000000, then update your listing's 'item_name, customer_id' attribute(s) to match Amazon's catalog value, 2) If it's not the right ASIN, make sure the item_id provided is correct, or 3) If you disagree with the data in Amazon catalog contact Selling Partner Support to start the appeal process.", "severity": "ERROR",

       3.  MY question is : how do I put it's as null because I want to listing a new listing that doesn't have exist item on it. 
       as scheme show as 
       
       ` "merchant_suggested_asin": {
       "title": "Merchant Suggested ASIN",
       "description": "Provide an ASIN for your product if one exists. If a value is not provided, the system will attempt a match based on the External Product ID.",
       "examples": [
           "B007KQBXN0"
       ],
       "type": "array",
       "minItems": 1,
       "minUniqueItems": 1,
       "maxUniqueItems": 1,
       "selectors": [
           "marketplace_id",
           "value"
       ],
       "items": {
           "type": "object",
           "required": [
               "marketplace_id",
               "value"
           ],
           "properties": {
               "value": {
                   "title": "Merchant Suggested ASIN",
                   "description": "Provide an ASIN for your product if one exists. If a value is not provided, the system will attempt a match based on the External Product ID.",
                   "editable": false,
                   "hidden": false,
                   "examples": [
                       "B007KQBXN0"
                   ],
                   "type": "string",
                   "minLength": 10,
                   "maxLength": 10,
                   "maxUtf8ByteLength": 40
               },
               "marketplace_id": {
                   "$ref": "#/$defs/marketplace_id"
               }
           },
           "additionalProperties": false
       }
      

      },`

      So it supposes can be empty but looks like it's abut from SP API Listing.

      Please help me on this.
      Thank you

[gabiRojas1978]

Hello. How I can update the Recommended Retail Price (RRP) or a Manufacturer’s Suggested Retail Price (MSRP)?

[steven-so]

@xiaoyu-tamu, right now its not possible to update the business price via Listing API.

Is this still the case?

I've looked at the json schema trying to find anything that could be the business price (B2B), but I have been unsuccessful.

It would be super useful if I could update the business price through patchListingsItem instead of the xml feed.

[chapmanjw]

@yourguide The B2B pricing attributes (including quantity discounts) will be available soon. We are in the process of testing those and getting them ready for release. We'll have an announcement with more details once they're ready.

[yourguide]

Awesome... thanks!

[rajlaskar]

any update available regarding the B2B price update through JSON_LISTINGS_FEED ?

[weilinggu]

Hi @rajlaskar B2B is supported via JSON_LISTINGS_FEED. See the announcement

[rajlaskar]

Hi @weilinggu
Thank you for the reply, I will follow the documentation & implement B2B pricing.

[dunghoangtekos]

@ThanhLuan0932 hi Luan! I am PHP Developer and developing to putListingsItem from my website to Amazon store also. Can we discuss more further about this through email? Please pm me at [email protected].
Much appreciate if receiving your reply.

[mtkumar82]

Hi,
I am using amazon Listing item API to update the offer price and set Min and Max price by API. Listing API setting price for offer correctly if there are no Min max price, But when sending min max price along with offer price inside the purchasable_offer, by

Like

$DescriptionData['minimum_seller_allowed_price'] = ["schedule" => ["value_with_tax" => 10.00]];

$DescriptionData['maximum_seller_allowed_price'] = ["schedule" => ["value_with_tax" => 100]] ; and submitting the offer , its giving InvaliD response Die Attribute sind ungültig like below. I am not understanding how to pass Min and max price with offer price

[status] => INVALID
[submission_id] => 52e5e0cdc698429da0614f0212cd6351
[issues] => Array
(
[0] => AmazonPHP\SellingPartner\Model\ListingsItems\Issue Object
(
[container:protected] => Array
(
[code] => 90000900
[message] => Die Attribute sind ungültig.
[severity] => ERROR
[attribute_names] => Array
(
[0] => purchasable_offer
)

                                [categories] => Array
                                    (
                                    )

                                [enforcements] =>
                            )

                    )

            )

        [identifiers] =>
    )

[mtkumar82]

I tried to send array like below in respect to above query.

Array
(
[condition_type] => Array
(
[0] => Array
(
[value] => new_new
[marketplace_id] => A1PA6795UKMFR9
)

    )

[merchant_suggested_asin] => Array
    (
        [0] => Array
            (
                [value] => B07W3C5WGY
                [marketplace_id] => A1PA6795UKMFR9
            )

    )

[purchasable_offer] => Array
    (
        [0] => Array
            (
                [currency] => EUR
                [audience] => ALL
                [our_price] => Array
                    (
                        [0] => Array
                            (
                                [schedule] => Array
                                    (
                                        [0] => Array
                                            (
                                                [value_with_tax] => 40
                                            )

                                    )

                            )

                    )

                [marketplace_id] => A1PA6795UKMFR9
                [minimum_seller_allowed_price] => Array
                    (
                        [schedule] => Array
                            (
                                [value_with_tax] => 35,00
                            )

                    )

                [maximum_seller_allowed_price] => Array
                    (
                        [schedule] => Array
                            (
                                [value_with_tax] => 69,00
                            )

                    )

            )

        [1] => Array
            (
                [currency] => EUR
                [audience] => B2B
                [our_price] => Array
                    (
                        [0] => Array
                            (
                                [schedule] => Array
                                    (
                                        [0] => Array
                                            (
                                                [value_with_tax] => 40
                                            )

                                    )

                            )

                    )

                [marketplace_id] => A1PA6795UKMFR9
            )

    )

)

[mtkumar82]

I am not understanding how to pass Min max price there, I also tried with Offer attribute

(
[condition_type] => Array
(
[0] => Array
(
[value] => new_new
[marketplace_id] => A1PA6795UKMFR9
)

    )

[merchant_suggested_asin] => Array
    (
        [0] => Array
            (
                [value] => B07W3C5WGY
                [marketplace_id] => A1PA6795UKMFR9
            )

    )

[purchasable_offer] => Array
    (
        [0] => Array
            (
                [currency] => EUR
                [audience] => ALL
                [our_price] => Array
                    (
                        [0] => Array
                            (
                                [schedule] => Array
                                    (
                                        [0] => Array
                                            (
                                                [value_with_tax] => 40
                                            )

                                    )

                            )

                    )

                [marketplace_id] => A1PA6795UKMFR9
            )

        [1] => Array
            (
                [currency] => EUR
                [audience] => B2B
                [our_price] => Array
                    (
                        [0] => Array
                            (
                                [schedule] => Array
                                    (
                                        [0] => Array
                                            (
                                                [value_with_tax] => 40
                                            )

                                    )

                            )

                    )

                [marketplace_id] => A1PA6795UKMFR9
            )

    )

[offers] => Array
    (
        [0] => Array
            (
                [marketplace_id] => A1PA6795UKMFR9
                [asin] => B07W3C5WGY
                [item_condition] => New
                [price] => Array
                    (
                        [amount] => 40
                        [currency] => EUR
                    )

                [minimum_seller_allowed_price] => Array
                    (
                        [amount] => 35,00
                        [currency] => EUR
                    )

                [maximum_seller_allowed_price] => Array
                    (
                        [amount] => 69,00
                        [currency] => EUR
                    )

            )

    )

)
but no luck, Its also not working for me, Someone please suggest how to update Min max price for an offer.

[thesarwars]

you are passing asin,
pass 'sku' and 'product_type'.

and what are you getting in response, error or success?

[mtkumar82]

Hello @thesarwars , I found the solution of this issue, Actually issue there with multiple array define for Min max price. Its working now. Thanks alot for your quick response.

[mtkumar82]

And tried below as per the documentations https://developer-docs.amazon.com/sp-api/docs/listing-workflow-migration-tutorial#submitting-data But not working.

{
"condition_type": [
{
"value": "new_new",
"marketplace_id": "A1PA6795UKMFR9"
}
],
"merchant_suggested_asin": [
{
"value": "B07W3C5WGY",
"marketplace_id": "A1PA6795UKMFR9"
}
],
"purchasable_offer": [
{
"currency": "EUR",
"audience": "ALL",
"our_price": [
{
"schedule": [
{
"value_with_tax": "40"
}
]
}
],
"marketplace_id": "A1PA6795UKMFR9",
"minimum_seller_allowed_price": [
{
"schedule": {
"value_with_tax": "35,00"
}
}
],
"maximum_seller_allowed_price": [
{
"schedule": {
"value_with_tax": "69,00"
}
}
]
},
{
"currency": "EUR",
"audience": "B2B",
"our_price": [
{
"schedule": [
{
"value_with_tax": "40"
}
]
}
],
"marketplace_id": "A1PA6795UKMFR9"
}
]
}

No luck

[ymplepay]

trying the update the qty with ( anyone can help ) :

INPUT:
{'header': ({'sellerId': 'Axx', 'version': '2.0', 'issueLocale': 'en_US', 'Merchant': 'Axx', 'marketplaceIds': 'Axx', 'merchant': 'Axx'},), 'Merchant': ({'merchantId': 'Axx'},), 'messages': [{'messageId': 1, 'sku': 'BBA-107-FBA', 'operationType': 'PARTIAL_UPDATE', 'productType': 'PRODUCT', 'attributes': {'merchant': 'Axx', 'Merchant': 'Axx', 'merchant_suggested_asin': [{'value': 'Axx', 'marketplace_id': 'A1F83G8C2ARO7P'}], 'fulfillment_availability': [{'fulfillment_channel_code': 'DEFAULT', 'quantity': 20}]}}]}

OUTPUT
{"header":{"sellerId":"
","version":"2.0","feedId":"2387205020142"}
,"issues":[{"code":"4002005","severity":"ERROR"
,"message":"Attribute ‘Merchant’ is required, but not
present."}],"summary":{"errors":1,"warnings":0,"messagesProcessed":0,"messagesAccepted":0,"messagesInvalid":0}}

[thesarwars]

I don't know which language are you using right now, but I'm sharing my python code structure. Let me know, for which country are you using this? Mine is USA.
If you have still facing the issue, let me know.

[ymplepay]

@thesarwars Yes I am also using Python and added the sellerId to do a new test. I got the same error.
Here is my code for the INPUT, any other idea?:

message_header = {
"sellerId": merchant_id,
"version": "2.0",
"issueLocale": "en_US",
"Merchant": merchant_id,
"marketplaceIds":marketplaceId,
"merchant": merchant_id,
"MerchantIdentifier":merchant_id

},

{
"messageId": message_index,
"sellerId": merchant_id,
"sku": sku,
"operationType": "PARTIAL_UPDATE",
"productType": "PRODUCT",
"attributes": {
"merchant":merchant_id,
"Merchant": merchant_id,

            "merchant_suggested_asin": [ { "value": merchant_id, "marketplace_id": marketplaceId } ],
            "fulfillment_availability": [
            {
                "fulfillment_channel_code": "DEFAULT",
                "quantity": qty,
                'marketplace_id': marketplaceId
            }
            ]
            }
        }

[thesarwars]

Then use this package. Your life would be easier..

[thesarwars]

This is the format of update 'quantity'.

[ymplepay]

@thesarwars ok, in your example which url do you use for patches? ( maybe I have one issue on the url )

[ymplepay]

@thesarwars thank you now it is working and find out the issue related to the header:
KO: {'header': ({'sellerId': 'ACBQK5XDKKW9V', 'version': '2.0', 'issueLocale': 'en_US'},)
FIXED {'header': {'sellerId': 'ACBQK5XDKKW9V', 'version': '2.0', 'issueLocale': 'en_US'}
Now the feed works properly