Show HN: I indexed 10M Shopify products to build an API
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: Hi HN! I'm Param, founder of Agora. The Agora API enables developers to search, purchase, and track orders for 10 million products sold on 25,000 Shopify and WooCommerce stores. You can search by text, image, URL, or location to find products. Every Shopify store has several public JSON files that are available on the same URL route. The file for general store information appears at [Base URL]/meta.json. Pr
What is actually going on
Returns and refunds break accounting when the refund is recorded in one system and the inventory restock in another, with no reconciliation.
Integration failures usually trace to schema drift: a plugin update changes a field name and the sync silently writes nulls.
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.
Launch Readiness Checker
A ready-to-use package for exactly this workflow — $27.55, 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.