Sfoglia categorie
Italiano
$
USD
Connettiti alla tua IA
I will amazon shopify sku inventory recon master exceptions sheet
TradBridge Studio, seller ops studio, Hong Kong
TradBridge Studio — Hong Kong seller-ops for Amazon/Shopify spreadsheets.
File-only Excel clean-up and SKU recon. Sku Recon Extra: Make-a-copy Google Sheet, paste CSVs, Run — Master + Exceptions catc...
Informazioni su questo servizio
Still getting cancels or overselling while each export looks fine? Join them - I flag Exceptions first. Sku Recon is file-only reconciliation. I merge your CSVs into one trustworthy Master, plus an Exceptions list for anything that won't join. Stop guessing which SKU is wrong before you restock.
What you get
Clean Master ready to filter, pivot, or hand to a VA
Exceptions that fail loudly. I never invent a match
Optional Alias Map when Amazon and Shopify SKUs differ (Standard/Premium)
Summary KPIs on Standard+
Premium: guided setup so you can paste and Run next export
How it works
Upload .xlsx/.csv/Sheets export on the order.
Tell me the match key and keep/drop rules.
I normalize, match, flag Exceptions, return the workbook.
Review Exceptions before Master; fix once; re-export next cycle.
Best for
1-2 person Amazon and Shopify sellers who need inventory truth without another sync app first.
I will not
Log into Seller Central or Shopify. Promise real-time ERP. Invent SKU matches. Rebuild your full books.
Order the tier for your unique SKU count. First dirty merge: Standard or Premium. Weekly same shape: add Extra Sku Recon Template and re-run yourself.
Il mio portfolio
FAQ
What's included in Basic, Standard, and Premium?
All tiers: Master and Exceptions, file-only. Not live ERP or real-time sync. Basic $80: ~150 SKUs, 2 sources, 1 revision, 3 days. Standard $150: ~500 SKUs, 3 sources, Summary and Alias starter, 2 revisions, 4 days. Premium $300: ~1500 SKUs, fuller Alias, async setup, reuse note, 3 revisions, 5 days.
My sync is green but I still get cancels / oversell — can you help?
Yes if the pain is units: wrong join, truncated SKU, FBA≠sellable qty. I return Exceptions + Master (file-only). I don’t install sync or fix payouts/COGS.
Will you log into Amazon Seller Central or Shopify?
No. Upload exports on the order only. Safer and faster. You paste final numbers into your store. I will not log into Seller Central, Shopify, Google Drive, or an ERP.
What is the Exceptions list? Will you guess unmatched SKUs?
Exceptions need your eyes: unmapped, Amazon-only, Shopify-only, duplicates, blank or negative qty, cost conflict, cancelled or refunded (info), mapping gaps. I never invent a match. A wrong join is worse than an open miss. Review Exceptions before you trust Master.
What is Alias Map?
When codes differ by channel (Shopify SKU vs Amazon Seller SKU, FNSKU, or barcode), Alias Map points them to one Master SKU. Standard includes a starter map. Premium builds a fuller starter from your files. Basic expects keys that already match, or identity join plus open misses.
My CSV drops leading zeros on SKUs. Can you fix that?
Yes on DFY orders. I keep SKUs as text in the clean Master when possible. If you open CSVs yourself later, use Data > From Text/CSV and set SKU to Text, or prefix a single quote. Do not open the export in Excel first if zeros matter.
What is the Extra Sku Recon Template vs these packages?
Packages mean I do the messy first merge for you (DFY). Extra (~$20) is a reusable Make-a-copy Sheet so you paste Raw CSVs and Run again (soft cap about 2,000 Raw rows). First dirty files: Basic $80, Standard $150, or Premium $300. Weekly same shape: add the Extra after DFY. You can order both.
How do SKU and row caps work?
Soft caps are about 150, 500, and 1,500 unique SKUs (Basic $80, Standard $150, Premium $300). Far over the cap? Upgrade the tier, split into two orders, or ask for a Custom Offer. Do not pad the file with blank rows.
How many revisions? What if my files change?
Revisions are 1, 2, or 3 by tier, for the same files and match rules. Clarifying the match key counts as a pass. Send rules upfront. A brand-new export dump or a new sales channel after delivery is a new order, not a revision.
Do you reconcile Amazon settlements / COGS?
No — that’s bookkeeper/CPA or A2X-class tools. I only do SKU/qty Exceptions.
