etsy
[BUG] Auto-Translation of Property Values by "updateListingInventory"
I'm developing a product sync with our local database and ran into a problem with automatically translating inventory propertiy values by the Etsy V3 API.
At first I download the current inventory json-object to adjust the quantity or price, for instance. To do this the whole object must be uploaded again via updateListingInventory including the property_values object. So far so good.
In our database the property value for the primary color is set to "Schwarz" (in english: Black). This exact value can be set in the etsy shop manager as well. See the following screenshot for a better understanding.
After submitting the new json-object to etsy by the function "updateListingInventory", the property value "Schwarz" is automatically translated into "Black". As you see in the next screenshot:
When I receive the new inventory json-object (request language set to "de") the value has changed permanently to "Black". The value has now changed in the etsy shop manager to "Back" as well, and not "Schwarz" as expected.
I expected the value to be "Schwarz" and displaying the excact value in the etsy shop manager as well and not being overwritten to "Black". I understand the etsy translation by referencing the correct wording in your backend-system, but it should not change the wording permanently to "Black" in my opinion.
You might ask where the problem is. In that case we have to change every variant to the english wording, even if the user has changed the display language to german. We would highly appreciate if etsy can fix this in early 2022.
@CARAXSoftware Sorry I couldn't get to this sooner. I'm going to try to duplicate your experience. Would you be able to send the full inventory update data (including listing id and shop id) so I can try to reproduce it? If you'd prefer, you can email that information to [email protected] and just reference this ticket and my name (Andrew).
@etsyachristensen Sure.
Basic Information Shop ID: 31846020 Listing ID: 1081727947 Listing Title: Testartikel 1337!
[PUT] /listings/1081727947/inventory I'm sending the following object to the etsy api. You'll see the property value is in german "Schwarz".
{ "products": [ { "sku": "T1-A-G", "offerings": [ { "price": 2, "quantity": 28, "is_enabled": true } ], "property_values": [ { "property_id": 200, "property_name": "Hauptfarbe", "scale_id": null, "values": [ "Gold" ], "value_ids": [ 1214 ] } ] }, { "sku": "T1-B-S", "offerings": [ { "price": 2, "quantity": 28, "is_enabled": true } ], "property_values": [ { "property_id": 200, "property_name": "Hauptfarbe", "scale_id": null, "values": [ "Schwarz" ], "value_ids": [ 1 ] } ] } ], "sku_on_property": [ 200 ] }
Then I receive the following response object:
[ { "product_id": 7974192001, "sku": "T1-A-G", "is_deleted": false, "offerings": [ { "offering_id": 8054946125, "quantity": 28, "is_enabled": true, "is_deleted": false, "price": { "amount": 200, "divisor": 100, "currency_code": "EUR" } } ], "property_values": [ { "property_id": 200, "property_name": "Primary color", "scale_id": null, "scale_name": null, "value_ids": [ 52041479589 ], "values": [ "Gold" ] } ] }, { "product_id": 8208481322, "sku": "T1-B-S", "is_deleted": false, "offerings": [ { "offering_id": 8206896718, "quantity": 28, "is_enabled": true, "is_deleted": false, "price": { "amount": 200, "divisor": 100, "currency_code": "EUR" } } ], "property_values": [ { "property_id": 200, "property_name": "Primary color", "scale_id": null, "scale_name": null, "value_ids": [ 49928889190 ], "values": [ "Black" ] } ] } ]
As u see the property values has changed to "Black".
[GET] /listings/1081727947/inventory Then I tried to receive the object directly via the etsy api. I set "language" to "de" in the request for getting the german text.
{ "products": [ { "product_id": 7974192001, "sku": "T1-A-G", "is_deleted": false, "offerings": [ { "offering_id": 8054946125, "quantity": 28, "is_enabled": true, "is_deleted": false, "price": { "amount": 200, "divisor": 100, "currency_code": "EUR" } } ], "property_values": [ { "property_id": 200, "property_name": "Hauptfarbe", "scale_id": null, "scale_name": null, "value_ids": [ 52041479589 ], "values": [ "Gold" ] } ] }, { "product_id": 8208481322, "sku": "T1-B-S", "is_deleted": false, "offerings": [ { "offering_id": 8206896718, "quantity": 28, "is_enabled": true, "is_deleted": false, "price": { "amount": 200, "divisor": 100, "currency_code": "EUR" } } ], "property_values": [ { "property_id": 200, "property_name": "Hauptfarbe", "scale_id": null, "scale_name": null, "value_ids": [ 49928889190 ], "values": [ "Black" ] } ] } ], "price_on_property": [], "quantity_on_property": [], "sku_on_property": [ 200 ], "listing": null }
As you see it is still the english version "Black". :/ If I change the object via the etsy website frontend, the object contains the german version "Schwarz" as needed.