ORAA Inventory Lookup

Reads a "Product Variant (product.product)" export (columns: Internal Reference, Barcode, Free Quantity, Sales Price). Matches by SKU first, then Barcode, and sets the Denham Court quantity in Shopify from Free Quantity only — no fallback to any other column — except a Free Quantity of 5 or less, which is treated as not genuinely sellable and zeroed (Garage isn't subject to this — it's physically counted by hand and always counts in full, even at 0 or 1). Rows missing a Free Quantity value are skipped and reported. Garage is never touched by this import. Draft products in Shopify are matched but skipped entirely (no quantity or cost change) — only active/archived products are touched. Also syncs each item's cost (Sales Price × 0.8 × 1.10) to Shopify's own cost field, so the Buy Box autopilot's cost floor / margin cap / loss check always match what's shown here. A matched row with no real Sales Price (blank or $0) gets its product archived automatically — a product with no known cost shouldn't stay live — and its Amazon quantity zeroed if it's linked to a listing. An archived product with a real price in today's sheet gets reactivated automatically, unless another active product already shares its exact barcode (a genuine duplicate), in which case it's left archived. An archived product that's missing from today's sheet entirely but still has real Garage stock also gets reactivated (same duplicate-barcode check applies) — Denham Court itself stays at 0 for it (Excel says nothing), but Garage's own quantity still makes it sellable via the combined Amazon total.

Build 2026-10-14-invoice-line-discount

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.

Runs on your full catalog — any filters/search are cleared first. Each stage below runs completely (and shows its own progress/log) before the next one starts, so there's no guessing whether a step is done. This does not run Scan Buy Box — Amazon can take hours to reflect a price change in the live Buy Box, so scanning right after this would just show stale results. Run Scan Buy Box separately, later.

Pushes each product's current Shopify Selling price and Denham Court quantity only 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 never counted toward Amazon — it isn't auto-deducted by any sale, so it's only ever assigned via the per-order "Fulfilled from" picker on the Sales tab.

For the currently filtered/sorted list below: tries to sync each item to its existing Amazon listing first, exactly like Bulk Sync. Only when that fails because there's no existing listing under your account — but the ASIN/barcode does resolve to a real product already in Amazon's catalog — does it create a new offer (Condition: New) under the Shopify SKU, using Shopify's Selling price (or your Amazon price override) and Denham Court quantity only (Garage isn't counted — see the Bulk Sync note above). Items whose barcode/ASIN doesn't match anything in Amazon's catalog at all can't be auto-listed — Amazon requires a full new-product submission for those, which this doesn't do.

For the currently filtered/sorted list below: finds every item currently marked Losing Buy Box from your last scan, and prices it 1¢ below the current Buy Box holder's landed price (accounting for your own shipping cost if any), then pushes that price to Amazon as a sticky Amazon price override — Shopify's Selling price is never touched. No margin floor — this will undercut even below cost if that's what it takes to win, so review the list first. Buy Box status itself only updates on the next Scan Buy Box, not immediately after this.

For the currently filtered/sorted list below: finds every item with a barcode (or Amazon barcode override) but no ASIN yet, looks it up in Amazon's catalog by barcode, and saves the resolved ASIN straight to the product — the same lookup as the "🔍 Look up ASIN from barcode" button on a single product, just run over the whole list and auto-saved. Items whose barcode doesn't match anything in Amazon's catalog are skipped and reported.

For the currently filtered/sorted list below: finds every item currently winning Buy Box (from your last scan) where a higher-priced competitor is known, and raises your price to 5% below that competitor's landed price — capturing more margin while still comfortably winning. Only ever raises price, never lowers it; items where 5% under the competitor is still below your current price are left alone. Items with no known competitor at all (you're the only offer) can't be calculated and are skipped — there's no reference price to work from. Capped so net margin (after commission and the shipping estimate below) can never exceed the max margin set in Sales tab settings — protects against a wildly overpriced competitor pushing your price absurdly high. Pushed as a sticky Amazon price override — Shopify's Selling price is never touched. Buy Box status itself only updates on the next Scan Buy Box (or the auto-recheck).

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.

Shown in the header of every customer invoice you create.

Scans every product linked to Amazon (has an ASIN saved) for content-policy issues Amazon has flagged on the listing — e.g. a suppressed description, image, or attribute. These block a listing from being BUYABLE (so it silently drops out of the Buy Box entirely) and can't be fixed by the autopilot or this app — they need manual correction in Seller Central. This is a diagnostic scan only; nothing here is changed automatically.

Every 30 minutes this automatically: re-verifies recently-changed items against Amazon, prices losing items 1¢ under the competitor, raises uncontested winning items to 5% under the next competitor (capped at your set margin), pushes quantity updates to already-listed items whenever Denham Court or Garage has changed — Amazon quantity is always Denham Court + Garage combined, re-read fresh every run, so a manual Garage edit reaches Amazon within this same ~30-min cycle without waiting for an Excel import (Excel import no longer needs its "push to Amazon" box ticked either), checks new barcodes against Amazon's catalog to auto-create listings priced at your margin cap (also catches products that already have an ASIN saved — e.g. from a Bulk ASIN Lookup — but were confirmed never actually listed, so nothing gets stuck in permanent limbo), raises any currently-listed item selling below cost + shipping + commission up to breakeven (no markup added — Buy Box fix/maximize handle restoring a normal margin afterward), pulls down any item priced over your margin cap even with zero competitor data (e.g. sole-seller listings), raises any sole-seller item priced well under the margin cap back up toward it (competing against Prime/cross-border sellers goes down to breakeven instead — see the Buy Box fix step), raises Shopify's own direct-website price whenever it's fallen below your cost + commission % + postage + margin floor (set below — this price has no other protection at all, since Excel only ever syncs cost, never price, so nothing else ever catches it drifting thin as cost rises; only ever raises, never lowers a deliberately higher price), and works through the whole listed catalog a slice at a time on a rolling basis so Buy Box data never goes stale just because an item hasn't recently changed — all Amazon price moves capped at 15% per run to avoid tripping Amazon's Fair Pricing checks, bounded by a breakeven floor on the Buy Box fix step, and a per-item cooldown so nothing gets re-touched before Amazon's had a chance to reflect the last change. Excel import also auto-creates genuinely new Shopify products from unmatched rows (pulling title/image from Amazon when the barcode matches), priced at whichever is higher of your cost + margin cap or 20% over Amazon's current Buy Box price (when the barcode resolves to a real Amazon listing) — so a daily Excel upload is the only manual step needed.

Read-only — Omnivore's API has no way to set a marketplace's category directly (confirmed live: changing the internal category didn't change eBay's category, even though the product visibly re-synced). Per-marketplace categories are controlled by mapping rules inside Omnivore's own dashboard. This just shows where things stand, so you know what to go fix there.

Scans every marketplace-linked product for a live error flag (e.g. "No inventory"), plus recent orders sitting in a failure, hold, or quarantined state — states Shopify has no concept of, so these are otherwise only visible by logging into Omnivore directly.