createReceiptShipment tracking submission live.ArtisanWoodcraftStudio
Shop ID: 48291044Connected via Etsy Open API v3Aggregated via shops_r & transactions_r
Average workshop dispatch: 1.3 business days
Real-time listings_w stock buffer active
2 SKUs currently at low-stock threshold (≤5)
7-Day Revenue & Sync Velocity
Daily shop sales vs SKU stock sync pushes
Top-Performing SKU Breakdown (30-Day Revenue by SKU)
shops_rRevenue attribution, fulfillment reliability, and real-time inventory readiness per SKU
| SKU & Product | Units (30d) | 30-Day Revenue | Revenue Share | On-Time SLA | Stock Health |
|---|---|---|---|---|---|
LMS-WLN-001Walnut Desk OrganizerWalnut / Matte Oil | 68 | $4,624.00 | 31% | 100% | Reconciling |
LMS-STW-014Hand-Thrown Stoneware MugSpeckled Cream / 12oz | 112 | $3,808.00 | 26% | 99.1% | Healthy |
LMS-LIN-022Linen Table RunnerOatmeal Flax / 90" | 54 | $2,808.00 | 19% | 100% | Reconciling |
LMS-LTH-009Engraved Leather JournalChestnut Full-Grain / A5 | 41 | $2,214.00 | 15% | 98.8% | Low Stock |
LMS-BRS-007Personalized Brass KeychainAged Brass / Stamped Tag | 52 | $1,366.00 | 9% | 100% | Low Stock |
Catalog & SKU Inventory Synchronization
listings_rlistings_wAdjust warehouse stock with the − / + controls to simulate a real-time inventory delta, then push PUT /v3/application/listings/{listing_id}/inventory.
| Listing ID | Product & Category | SKU | Variant | Warehouse Stock | Etsy Live Stock | Sync Status | Last Synced | Action |
|---|---|---|---|---|---|---|---|---|
| #184920112 | Walnut Desk Organizer Home & Office · $68.00 | LMS-WLN-001 | Walnut / Matte Oil | 18 | 14+4 | Delta Pending | 42m ago | |
| #184920245 | Hand-Thrown Stoneware Mug Kitchen & Dining · $34.00 | LMS-STW-014 | Speckled Cream / 12oz | 24 | 24 | Synced | 18m ago | |
| #184920389 | Personalized Brass Keychain Accessories · $26.00 | LMS-BRS-007 | Aged Brass / Stamped Tag | 4 | 4 | SyncedLow Stock | 31m ago | |
| #184920510 | Linen Table Runner Home Textiles · $52.00 | LMS-LIN-022 | Oatmeal Flax / 90" | 11 | 15-4 | Delta Pending | 55m ago | |
| #184920674 | Engraved Leather Journal Stationery & Craft · $54.00 | LMS-LTH-009 | Chestnut Full-Grain / A5 | 3 | 3 | SyncedLow Stock | 27m ago | |
| #184920798 | Ceramic Pour-Over Coffee Dripper Kitchen & Dining · $46.00 | LMS-CER-019 | Slate Matte / Size 02 | 16 | 16 | Synced | 12m ago |
Order Fulfillment, Personalization & Tracking Management
transactions_rtransactions_wcreateReceiptShipmentReview buyer personalization notes, manage workshop queue status, and submit carrier tracking to POST /v3/application/shops/48291044/receipts/{receipt_id}/tracking.
| Receipt ID | Buyer & PII Retention | Ordered SKU & Qty | Personalization Notes | Fulfillment Status | Carrier & Tracking | Etsy API Action |
|---|---|---|---|---|---|---|
#3491820411 Today, 09:14 UTC · $54.00 | Elena Rostova PII Auto-Purge: 28d remaining | LMS-LTH-009× 1Engraved 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× 2Personalized 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× 1Walnut 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× 4Hand-Thrown Stoneware Mug | Standard glaze — double-wall protective packing | Shipped | USPS 9405511899223847102941 | Tracking Synced |
{
"tracking_code": "9405511899223847102941",
"carrier_name": "usps",
"send_bcc": false
}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.
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 / Permission | Access | Etsy Open API v3 Endpoint(s) | Operational Purpose | Freshness & Retention |
|---|---|---|---|---|
shops_rShop Profile & Performance | Read | GET /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_rCatalog & Inventory Read | Read | GET /v3/application/shops/{shop_id}/listings & /listings/{listing_id}/inventory | Import active/inactive listings, variant matrices, SKU codes, and live Etsy quantities for reconciliation. | Refreshed on demand; max cache TTL <= 6 hours. |
listings_wInventory Stock Reconciliation | Write | PUT /v3/application/listings/{listing_id}/inventory | Push 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_rOrder Receipts & Personalization | Read | GET /v3/application/shops/{shop_id}/receipts | Fetch 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_wOrder Status & Fulfillment | Write | PUT /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. |
createReceiptShipmentCarrier & Tracking Submission | Endpoint Approval | POST /v3/application/shops/{shop_id}/receipts/{receipt_id}/tracking | Submit 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
/v3/application/shops/48291044/listings?state=activelistings_r200 OKFetched 6 listings (24 variants). Cache TTL reset to 6h window.
/v3/application/shops/48291044/receipts?was_paid=truetransactions_r200 OKImported 4 paid receipts with personalization notes.
/v3/application/shops/48291044/receipts/3491820290/trackingcreateReceiptShipment200 OKSubmitted USPS tracking 9405511899223847102941 for #3491820290.