Back

Compare supplier prices and margins in Google Sheets

A sheet comparing supplier costs, specs, and marketplace prices with margin per product

OpsFounders
Prompt

Open my product list in [Google Sheet and tab, e.g. Sourcing sheet, Products tab]. For each product, find supplier offers on [supplier sources, e.g. 1688 or my supplier price sheets] from [supplier regions, e.g. China and Vietnam], then selling prices on [marketplaces, e.g. Amazon and Shopee]. For each supplier, capture unit price, currency, MOQ, shipping if shown, [specs to extract, e.g. material, size, weight], and source link. Take prices as displayed; if tiered or quote-only, note that instead of guessing. Work out landed cost and margin using [pricing rules, e.g. 15% marketplace fee, fixed shipping per unit, convert to USD]. Add a new tab with columns: Product, Supplier, Unit price, MOQ, Landed cost, Marketplace price, Margin %, Specs, Link. Don't edit existing tabs, contact suppliers, or place orders. Flag uncertain product matches instead of picking one. Give me a short summary: best supplier per product, products below [target margin, e.g. 30%], and anything to check.

Works withdocs.google.com