Search or scan a product · view Denham Court + Garage stock · update Garage count
Build 2026-08-18-buybox-sync-reliability-1
Inventory
Amazon
Catalog maintenance
Import Denham Court stock
Reads a "Product Variant (product.product)" export (columns: Internal Reference, Barcode, Free Quantity). Matches by SKU first, then Barcode, and sets the Denham Court quantity in Shopify from Free Quantity only — no fallback to any other column. Rows missing a Free Quantity value are skipped and reported. Garage is never touched.
Build 2026-08-18-buybox-sync-reliability-1
Scan Buy Box status
Checks Amazon Buy Box status for the currently filtered/sorted list below (use the filters above to narrow scope first). Amazon rate-limits this to about one product every 2.2 seconds, so large scans take a while — feel free to close this panel and keep browsing; it keeps running and caches results as it goes.
Buy Box results are shared to every device via Shopify — but a write can occasionally fail (rate limits) and get stuck only on this device. Use this to push any such results through.
Bulk sync price & quantity to Amazon
Pushes each product's current Shopify Selling price and Denham Court + Garage total to its existing Amazon listing, for the currently filtered/sorted list below. Resolves the Amazon SKU via override → barcode match → Shopify SKU. Amazon allows about 4-5 requests/second, so this is much faster than the Buy Box scan. Denham Court quantities under 2 are treated as 0 for marketplace purposes (usually damaged stock or a miscount) — Garage stock is unaffected.
Bulk sync log
Create missing products
Excel rows from your last import that had no matching Shopify product. Pick one to look up on Amazon and create a draft — nothing is created until you confirm.
New product draft
Manage Denham Court sync
Products are synced by default. Uncheck any you don't want the Excel import to touch — saved permanently per product.
from last Buy Box scan — edit to sync a specific qty
Total available
–
Saving updates only the Garage location in Shopify. Denham Court is overwritten by the next daily sync, so don't edit it here.
Review extracted invoice
Payment confirmation email
Review before sending — nothing goes out until you tap Send.
Orders by channel & status
Pending = not yet fulfilled · Shipped = fulfilled, order still open · Completed = order closed.
Net profit by sale
eBay, Kogan & Bunnings orders (synced into Shopify via Omnivore) plus Amazon orders (fetched directly from Amazon, with real settled commission & shipping cost) — all matched to Excel cost price. The Amazon % below is only used as a fallback estimate for orders Amazon hasn't settled yet. Shipping cost for eBay/Kogan/Bunnings is manual — enter it per order once you know it.