ListingVariationImage. Invalid property_id, value_id combination.

[Gatis Pelčers]

Hello,

I'm trying to link variations and images by using updateVariationImages API endpoint but the error message I get back says:

variation with property_id 200 and value_id 10 is invalid

Here is what was returned from getInventory API endpoint for affected Listing:

"property_values": [
  {
    "property_id": 200,
    "property_name": "Primary color",
    "scale_id": null,
    "scale_name": null,
    "values": [
      "White"
    ],
    "value_ids": [
      10
    ]
  }
],

So to me it seems a perfectly valid combination: 200 Primary color, 10 White. But why do I receive this error? I'm able to updateVariationImages for same Listing for some other value_ids, but not for this one. 

Here is the full JSON request if that helps in any way. This API call is successful if I remove the first JSON object from payload.

[
  {
    "property_id": 200,
    "value_id": 10,
    "image_id": 2137907465
  },
  {
    "property_id": 200,
    "value_id": 105068403201,
    "image_id": 2090343966
  },
  {
    "property_id": 200,
    "value_id": 102989584900,
    "image_id": 2090343932
  }
]

Has anyone ever encountered this error and is there a way to fix this?

Thanks. Any input is greatly appreciated.

[Rob Thomas]

I noticed that when I use getInventory to get my available value_ids for property_id 200(primary color), I receive 1 for "Black" - Same is for getTaxonomyNodeProperties. However, when i manually link a photo to black then run getVariationImages, i get a value_id of 74111869019 for "Black"...

[Rob Thomas]

Hi, I am experiencing the same issue. Did you ever come across a solution?

On Wednesday, November 27, 2019 at 10:18:13 AM UTC-5, Gatis Pelčers wrote:

[Jeff Schnitzer]

Anyone have any insight into this? I see the same thing. I can't set 200 ("Primary color") to 1 ("Black") or 10 ("White"). I get the same 400 error:

"variation with property_id 200 and value_id 1 is invalid"

Manually setting the variation image to black in the Etsy UI and then querying the API, I get the value_id of 49928889190 / 49974750696 for black / white (could be inverted, I have no way to tell). Those numbers are a total mystery, they don't appear in the inventory for my listing when I query it.

Thanks in advance,

Jeff

[ma...@nestledpines.com]

Do you have images associated with your variations?  From the conversation above it sounds like if you link images to your variations, then a new id is assigned that would likely correspond to that image somehow.

What is the listing number if you don't mind sharing?

[Jeff Schnitzer]

Associating images with variations is exactly what I'm trying to do. The problem seems to be that I can't do it via the API - or at least, I can't use the published value ids for colors Black or White, and I can't figure out what value ids I should use.

Here's a listing that shows the issue: 829846826

POST https://openapi.etsy.com/v2/listings/829846826/variation-images

variation_images=%5B%7B%22property_id%22%3A200%2C%22value_id%22%3A1%2C%22image_id%22%3A2429351552%7D%5D

Legible: variation_images=[{"property_id":200,"value_id":1,"image_id":2429351552}]

Result is "variation with property_id 200 and value_id 1 is invalid"

I can add the variation image in the Etsy UI, just not via the API. And when I add it with the Etsy UI, fetching via the API I see a strange and mysterious color value id.

Thanks,

Jeff

[ma...@nestledpines.com]

I just spent a bunch of time playing with this and got the same error message as you.  No help from the API documentation, everything looks spot on.

A work-around, it seems, would be to use a custom variation field name instead of using the built-in Primary Color field.  When I work with items that have a custom variation field name, I seem to get a value_id similar to your other mysterious value_id that works fine.  Not sure how that aligns with what you are working on, but it would think that it could certainly be utilized as a type of work-around.  If not strangely intentional, I would assume this is indeed a bug.

[Peter Stenger]

Submitted an email, will update with response.

To: deve...@etsy.com 

Hello, I am working with the /listings/LISTING_ID/variation-images endpoint.

When I submit a valid combination of ids, for example I post

 

{property_id=200, value_id=1, image_id=MYID}. 200 is the property_id for "Primary color", 1 is the value_id for "Black", and MYID is a valid image id. This is what I get in response:

 

HTTP 400: variation with property_id 200 and value_id 1 is invalid

 

I have tried manually setting the variation-images for this listing in the Etsy UI (Color: Black to my image), then fetching the variation-images from the API. I get back this:

{property_id=200, value_id=49928889190, image_id=MYID}

 

Where does this number “49928889190” appear, and why is it different from value_id 1 found in the taxonomy properties.

When I fetch the inventory of this listing, that valueId does not show up at all. It's not in the taxonomy node properties for graphic tees (which is what this listing is set to). I can't find it anywhere in the API.

 

 

Google groups thread: https://groups.google.com/forum/#!topic/etsy-api-v2/cJg3TlOB0Y8

Stackoverflow post: https://stackoverflow.com/questions/62989345/etsy-api-listingvariationimage-endpoint-is-strange-and-mysterious

 

Thanks,

Peter

On Wednesday, November 27, 2019 at 10:18:13 AM UTC-5, Gatis Pelčers wrote:

[Peter Stenger]

I am having the same issue, it is infuriating! When I create custom properties through /listings/{listing_id}/inventory, I get a response back that indicates it has assigned  each property an ID:

    "products": [

      {

        "product_id": 4632256031,

        "sku": "",

        "property_values": [

          {

            "property_id": 514,

            "property_name": "Type",

            "scale_id": null,

            "scale_name": null,

            "values": [

              "Digital Download"

            ],

            "value_ids": [

              106592194838

            ]

          },

          {

            "property_id": 513,

            "property_name": "Color",

            "scale_id": null,

            "scale_name": null,

            "values": [

              "white"

            ],

            "value_ids": [

              53161799556

            ]

          }

        ], //...

However, when I try to pull the attributes for the listing using /listings/847150849/attributes, I get a blank response:

{

  "count": 0,

  "results": [],

  "params": {

    "listing_id": "847150849"

  },

  "type": "PropertyValue",

  "pagination": {}

}

I tried to go one step further and use /listings/847150849/attributes/514 since that is the custom property value, but it states that the attribute does not exist.

This has to be some sort of bug, because why would they want us to parse out the value_ids from the products list?

[James Hu]

Etsy Developer Support got back to me on this and they are aware of this bug. You will need to use https://openapi.etsy.com/v2/listings/XXXXX?api_key=APIKEY&includes=Variations endpoint to retrieve the proper value ids to match with in the meantime.

[assaf.l...@gmail.com]

Is it possible that updating variation images can't be applied to images based on the primary color property?

I got the invalid property and value message even when I was using the correct values received from the Variations API call