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.

[doverradio]

@sweetdream34310

Unfortunately, I am not currently listing to those marketplaces in EU and if there are discrepancies from the USA version, I would not be giving the proper advice. However, tomorrow I will try and see if I can find a solution for you.

[Twoandfrommike]

ok you can use the class from https://github.com/jlevers/selling-partner-api
but you 'll need to create php array and objects that follow the structure of @tbrains sugestions.

BUT... where do you get all the paths from ? ex: /attributes/item_name ???

ex: code:

$patches = array(new stdClass());
$patches[0]->op = "replace";
$patches[0]->path = "/attributes/item_name";
$patches[0]->value = array(new stdClass());
$patches[0]->value[0]->value = "Your product new name";
$patches[0]->value[0]->language_tag = "en_US";
$patches[0]->value[0]->marketplace_id = "marketplace_id ";


$body = new \SellingPartnerApi\Model\ListingsV20210801\ListingsItemPatchRequest(['product_type'=>"Product", 'patches'=>$patches]);

[cuizheng0520]

list_price

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
        }]
    }]
}

help!!
no matter how I debug, it still doesn't work, I can't find the error, please help

request:
{"productType":"PRODUCT","patches":[{"op":"REPLACE","path":"/attributes/fulfillment_availability","value":[{"quantity":123,"fulfillment_channel_code":"DEFAULT"}]}]}

response:
class ListingsItemSubmissionResponse {
sku: XBV001234
status: INVALID
submissionId: 88f30c7a6619435b8892ceb03b2659e3
issues: [class Issue {
code: 99022
message: The field 'fulfillment_channel_code' for the attribute 'fulfillment_availability' does not have enough values. The required minimum is '1' value(s).
severity: ERROR
attributeName: fulfillment_availability
}]
}

[sgeorgiev1995]

{"productType":"PRODUCT","patches":[{"op":"REPLACE","path":"/attributes/fulfillment_availability","value":[{"quantity":123,"fulfillment_channel_code":"DEFAULT"}]}]}

try using "replace" instead of "REPLACE"

[kstar0102]

Sorry to bother you.

I have tested my following code without sellingPartner package.

----------
def patch_listings_item(api_url, seller_id, sku, access_token):
    url = f"{api_url}/listings/2021-08-01/items/{seller_id}/{sku}"
    headers = {
        "Accept": "application/json",
        "x-amz-access-token": f"{access_token}",
        "Content-Type": "application/json; charset=utf-8",
    }
    payload = {
        "productType": "PRODUCT",
        "patches": [
            {
                "op": "replace",
                "path": "/attributes/fulfillment_availability",
                "value": [
                    {
                        "fulfillment_channel_code": "DEFAULT",
                        "quantity": 1,
                        "lead_time_to_ship_max_days": 5,
                        "marketplace_id": "A1VC38T7YXB528",
                    }
                ],
            }
        ],
    }
    params = {"marketplaceIds": ["A1VC38T7YXB528"], "issueLocale": "ja_JP"}
    response = requests.patch(url, headers=headers, data=payload, params=params)
----------

but result is ;
Failed to patch the listing item. Error: {'errors': [{'code': 'InvalidInput', 'message': 'Could not process payload', 'details': ''}]}
-----

Could you help me with your high amz sp api skill ?

Thank you

[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.