LoomSync Studio
Interactive Etsy API v3 Reviewer Sandbox (Synthetic Data)No credentials required. Test OAuth 2.0 PKCE consent, SKU stock deltas, and createReceiptShipment tracking submission live.

ArtisanWoodcraftStudio

Shop ID: 48291044Connected via Etsy Open API v3
AES-256-GCM Server-SideListings TTL: 42m / 6h maxTLS 1.3 · PKCE S256
30-Day Shop Revenue
$14,820.00+18.4%

Aggregated via shops_r & transactions_r

On-Time Fulfillment SLA
99.4%1 of 4 active shipped

Average workshop dispatch: 1.3 business days

Zero Oversell Incidents
0100% Protected

Real-time listings_w stock buffer active

Active Variants
24across 6 listings

2 SKUs currently at low-stock threshold (≤5)

7-Day Revenue & Sync Velocity

Daily shop sales vs SKU stock sync pushes

Mon
$1.8k
Tue
$2.2k
Wed
$1.7k
Thu
$2.5k
Fri
$2.9k
Sat
$2.0k
Sun
$1.7k
303 sync events this week0 rate-limit errors

Top-Performing SKU Breakdown (30-Day Revenue by SKU)

shops_r

Revenue attribution, fulfillment reliability, and real-time inventory readiness per SKU

SKU & ProductUnits (30d)30-Day RevenueRevenue ShareOn-Time SLAStock Health
LMS-WLN-001Walnut Desk Organizer
Walnut / Matte Oil
68$4,624.00
31%
100%Reconciling
LMS-STW-014Hand-Thrown Stoneware Mug
Speckled Cream / 12oz
112$3,808.00
26%
99.1%Healthy
LMS-LIN-022Linen Table Runner
Oatmeal Flax / 90"
54$2,808.00
19%
100%Reconciling
LMS-LTH-009Engraved Leather Journal
Chestnut Full-Grain / A5
41$2,214.00
15%
98.8%Low Stock
LMS-BRS-007Personalized Brass Keychain
Aged Brass / Stamped Tag
52$1,366.00
9%
100%Low Stock

Catalog & SKU Inventory Synchronization

listings_rlistings_w

Adjust warehouse stock with the − / + controls to simulate a real-time inventory delta, then push PUT /v3/application/listings/{listing_id}/inventory.

Zero Duplicate Listings Policy
Listing IDProduct & CategorySKUVariantWarehouse StockEtsy Live StockSync StatusLast SyncedAction
#184920112
Walnut Desk Organizer
Home & Office · $68.00
LMS-WLN-001Walnut / Matte Oil
18
14+4
Delta Pending
42m ago
#184920245
Hand-Thrown Stoneware Mug
Kitchen & Dining · $34.00
LMS-STW-014Speckled Cream / 12oz
24
24
Synced
18m ago
#184920389
Personalized Brass Keychain
Accessories · $26.00
LMS-BRS-007Aged Brass / Stamped Tag
4
4
SyncedLow Stock
31m ago
#184920510
Linen Table Runner
Home Textiles · $52.00
LMS-LIN-022Oatmeal Flax / 90"
11
15-4
Delta Pending
55m ago
#184920674
Engraved Leather Journal
Stationery & Craft · $54.00
LMS-LTH-009Chestnut Full-Grain / A5
3
3
SyncedLow Stock
27m ago
#184920798
Ceramic Pour-Over Coffee Dripper
Kitchen & Dining · $46.00
LMS-CER-019Slate Matte / Size 02
16
16
Synced
12m ago

Order Fulfillment, Personalization & Tracking Management

transactions_rtransactions_wcreateReceiptShipment

Review buyer personalization notes, manage workshop queue status, and submit carrier tracking to POST /v3/application/shops/48291044/receipts/{receipt_id}/tracking.

30–90d Buyer PII Auto-Purge · Zero Off-Platform Marketing
Receipt IDBuyer & PII RetentionOrdered SKU & QtyPersonalization NotesFulfillment StatusCarrier & TrackingEtsy API Action
#3491820411
Today, 09:14 UTC · $54.00
Elena Rostova
PII Auto-Purge: 28d remaining
LMS-LTH-009× 1
Engraved Leather Journal
Engrave initials: M.K.R. in serif font
Awaiting Production
#3491820388
Today, 07:40 UTC · $52.00
Marcus Vance
PII Auto-Purge: 27d remaining
LMS-BRS-007× 2
Personalized Brass Keychain
Tag 1: 'NORTH STAR' | Tag 2: 'EST. 2024'
In Workshop
#3491820342
Yesterday, 19:22 UTC · $68.00
Claire Beaumont
PII Auto-Purge: 25d remaining
LMS-WLN-001× 1
Walnut Desk Organizer
Beeswax finish card; gift note: 'Congratulations on the studio!'
In Workshop
#3491820290
2 days ago · $136.00
Daniel Okafor
PII Auto-Purge: 19d remaining
LMS-STW-014× 4
Hand-Thrown Stoneware Mug
Standard glaze — double-wall protective packing
Shipped
USPS
9405511899223847102941
Tracking Synced
createReceiptShipment API Payload Inspector
Submit any order tracking code above to inspect live Etsy Open API v3 payload
POST/v3/application/shops/48291044/receipts/3491820290/trackingSeeded Example
{
  "tracking_code": "9405511899223847102941",
  "carrier_name": "usps",
  "send_bcc": false
}
OAuth 2.0 + PKCE (S256)Connected via Etsy Open API v3

Etsy Open API v3 Connection & Scope Authorization

LoomSync Studio connects strictly through Etsy's official OAuth 2.0 authorization server using PKCE code_challenge_method=S256 and CSRF state verification. We never collect or store Etsy account passwords, and tokens are encrypted server-side in PostgreSQL using AES-256-GCM.

Connected Shop
ArtisanWoodcraftStudio
Shop ID: 48291044
Token Vault Encryption
AES-256-GCM Server-Side
Zero browser/localStorage exposure
API Cache Freshness
Listings ≤ 6h · Other ≤ 24h
Compliant with Etsy API Terms
Buyer Email Scope
Not Requested
Zero off-platform marketing policy

Scope-to-Endpoint Permission Matrix (5 OAuth Scopes + createReceiptShipment)

Every requested scope maps directly to a seller-initiated B2B inventory or order fulfillment workflow.

Scope / PermissionAccessEtsy Open API v3 Endpoint(s)Operational PurposeFreshness & Retention
shops_r
Shop Profile & Performance
ReadGET /v3/application/shops/{shop_id}Retrieve verified Etsy shop identity, storefront currency, active listing count, and fulfillment SLA metrics.Refreshed every 60m; max cache TTL <= 24 hours.
listings_r
Catalog & Inventory Read
ReadGET /v3/application/shops/{shop_id}/listings & /listings/{listing_id}/inventoryImport active/inactive listings, variant matrices, SKU codes, and live Etsy quantities for reconciliation.Refreshed on demand; max cache TTL <= 6 hours.
listings_w
Inventory Stock Reconciliation
WritePUT /v3/application/listings/{listing_id}/inventoryPush seller-confirmed warehouse stock quantities back to existing Etsy SKUs to prevent overselling. Never creates duplicate listings.Triggered exclusively by explicit inventory sync rules.
transactions_r
Order Receipts & Personalization
ReadGET /v3/application/shops/{shop_id}/receiptsFetch paid shop receipts, line-item SKUs, shipping destination, and buyer personalization notes for workshop production.Buyer PII auto-purged 30–90 days post-completion (24h on disconnect).
transactions_w
Order Status & Fulfillment
WritePUT /v3/application/shops/{shop_id}/receipts/{receipt_id}Confirm shipped status and synchronize verified workshop dispatch updates back to the Etsy seller order.Write-through only upon explicit seller confirmation.
createReceiptShipment
Carrier & Tracking Submission
Endpoint ApprovalPOST /v3/application/shops/{shop_id}/receipts/{receipt_id}/trackingSubmit carrier code and validated tracking number so Etsy triggers the official buyer shipping notification.Audit payload retained without unmasked buyer PII.

Live Etsy Open API v3 Sandbox Event Log

3 recorded operations
09:41:12 UTCGET/v3/application/shops/48291044/listings?state=activelistings_r200 OK

Fetched 6 listings (24 variants). Cache TTL reset to 6h window.

09:38:04 UTCGET/v3/application/shops/48291044/receipts?was_paid=truetransactions_r200 OK

Imported 4 paid receipts with personalization notes.

08:15:47 UTCPOST/v3/application/shops/48291044/receipts/3491820290/trackingcreateReceiptShipment200 OK

Submitted USPS tracking 9405511899223847102941 for #3491820290.