[Commerce] Add Etsy listing, inventory, and order review capability
A working diagnosis of this problem and the sequence that actually resolves it, written from the operational side rather than the marketing side.
Reported context: ## Goal Analyze the Etsy shop snapshot and surface review-needed items for daily store management. ## Scope - Flag listing issues such as inactive/expired listings, missing photos or descriptions when detectable, low inventory, stale listings, and pricing or shipping metadata gaps. - Flag inventory risks such as sold-out SKUs, low stock, variation inconsistencies, and products needing restock review. - Flag order/rec
What is actually going on
Order lifecycle bugs appear when the system of record for status is ambiguous between storefront, ERP, and fulfilment.
Returns and refunds break accounting when the refund is recorded in one system and the inventory restock in another, with no reconciliation.
The sequence that works
Pin integration versions and add a schema assertion that fails loudly when an expected field disappears.
Declare a single system of record per entity: orders in the storefront, inventory in the ERP, fulfilment status in the warehouse system.
Add reconciliation jobs that compare counts across systems daily and alert on divergence.
Log every state transition with a correlation id so a single order can be traced end to end.
Test the failure path, not only the happy path: cancelled order, partial refund, address change after dispatch.
Where people lose time
Auto-updating plugins in production without a staging pass. Schema drift is silent until data is already wrong.
Storing business logic in two systems and hoping they agree.
Verify before you trust it
Run the checks above against your own data instead of adopting them at face value. The failure modes are specific enough that a single afternoon of measurement will either confirm this diagnosis or rule it out — both outcomes are useful, and guessing is not.
Inventory Flow Oracle
A ready-to-use package for exactly this workflow — $187, delivered immediately.
Sold via Gumroad, which acts as merchant of record and handles payment and applicable taxes. All sales are final; see the return policy before purchase.