JSON_LISTINGS_FEED Amazon SP-API - Error 'Invalid parameters provided' when migrating Flat File Feeds Workflows

[wineloy]

Hi everyone,

I'm trying to update the price and inventory using the JSON_LISTINGS_FEED, following the example from the official documentation:
🔗 Listing Workflow Migration Tutorial

{
    "header": {
        "sellerId": "AXXXXXXXXXX8",
        "version": "2.0",
        "issueLocale": "en_US"
    },
    "messages": [
        {
            "messageId": 1,
            "sku": "my-sku-example",
            "operationType": "PATCH",
            "productType": "LUGGAGE",
            "patches": [
                {
                    "op": "replace",
                    "path": "/attributes/purchasable_offer",
                    "value": [
                        {
                            "currency": "MXN",
                            "our_price": [
                                {
                                    "schedule": [
                                        {
                                            "value_with_tax": 6680.57
                                        }
                                    ]
                                }
                            ],
                            "minimum_seller_allowed_price": [
                                {
                                    "schedule": [
                                        {
                                            "value_with_tax": 5850.78
                                        }
                                    ]
                                }
                            ],
                            "maximum_seller_allowed_price": [
                                {
                                    "schedule": [
                                        {
                                            "value_with_tax": 7322.96
                                        }
                                    ]
                                }
                            ]
                        }
                    ]
                },
                {
                    "op": "replace",
                    "path": "/attributes/fulfillment_availability",
                    "value": [
                        {
                            "fulfillment_channel_code": "DEFAULT",
                            "quantity": 1,
                            "lead_time_to_ship_max_days": 1
                        }
                    ]
                }
            ]
        }
    ]
}

Issue encountered:
When submitting the feed, Amazon returns the following error:

{
    "header": {
        "feedId": "105802020157",
        "sellerId": "AXXXXXXXXXX8",
        "version": "2.0"
    },
    "issues": [
        {
            "code": "BAD_REQUEST",
            "message": "Invalid parameters provided.",
            "messageId": 1,
            "severity": "ERROR"
        }
    ],
    "summary": {
        "errors": 1,
        "messagesAccepted": 0,
        "messagesInvalid": 1,
        "messagesProcessed": 1,
        "warnings": 0
    }
}

It's important to mention that the seller is from Mexico, which is why the currency is set to MXN.

Has anyone successfully updated price and inventory using this feed format? Any insights would be greatly appreciated!

[nightcoding2021]

I would suggest passing it as a Listings API call and receiving the synchronous processing response. JSON_LISTINGS_FEED uploads only parses the JSON on upload - the subsequent processing response is not provided, although I believe the documentation shows how it can be obtained via a convoluted process, which means adding more processes/tasks or in other words surface area that didn't exist before. In my view, Amazon need to have that subsequent processing response showing on the seller central "upload results" page, linked to the correlated upload. Or, have it accessible using the original file upload references/correlations.

[weilinggu]

Hi @wineloy,

When you use JSON_LISTINGS_FEED, the available value for op can be found here , example payload can be found here. replace is not a valid op for JSON_LISTINGS_FEED.

The documentation link you shared shows the example of a payload for patchListingsItem operation, where replace can be used for op.

For difference between JSON_LISTINGS_FEED and patchListingsItem, you can check here in the documentation.

Thanks
Weiling
Amazon Selling Partner Services