Etsy Open API v3 · variation inventory

56 variations, one correctly-built listing.

You have 56 Design × Size combinations in a Google Sheet – each with its own SKU and price. Etsy has no single module that builds that inventory. This shows the finished result and the exact request body behind it, ready to run in your shop.

8 designs × 7 sizes = 56 per-SKU price Design → custom property 513 importable Make blueprint

◑

This is a listing preview built from sample data – a representative 8-design × 7-size catalogue, not a real shop. It runs the full engine offline (no Etsy account touched). The one step that needs your shop is the final push, where the seller authorises it once.

–

variation products in the inventory body

–

designs (custom property 513)

–

sizes (variation property 514)

✓

every SKU its own price + qty

Listing preview – buyer's view

…

· one listing, 56 variations

–

Design

Size

SKU

–

Price · Qty

–

The full variation matrix

– every cell has its own SKU, price and quantity, pulled straight from the sheet

#	Design	Size	SKU	Price	Qty	Property map

How the blueprint builds it

Read the sheet

Google Sheets → Search Rows pulls all 56 rows (design, size, sku, price, qty) plus the shared title, description and tags.

Assemble products[]

An Iterator + Array Aggregator build the products array – each item maps Design → property 513, Size → 514, with an offering carrying that row's price, quantity and SKU.

iii

Create + fill inventory

Etsy Create a Draft Listing makes the base, then a Make an API Call PUTs updateListingInventory with all 56 products and the price_on_property flags.