Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesRetail & E-commerceE-commerce OperationsProduct Research and Supplier Sourcing

SpreadsheetE-commerce OperationsFree

Product Research and Supplier Sourcing

Compare product ideas and supplier quotes on landed cost, margin after fees, MOQ cash and demand with a weighted score.

Shown with sample data

Colour

Product Research and Supplier Sourcing

Compare product ideas and supplier quotes on landed cost, margin after fees, MOQ cash and demand with a weighted score.

Options compared
7
Shortlisted
5
Best margin after fees
68%
Cash for shortlisted first orders
$18,262
Score by option
  • Ningbo Kitchen Tools100
  • Guangzhou Homeware Co.94
  • Fujian Green Living88
  • Yongkang Steelware79
  • Local supplier: Weaver & Co.75
  • Shenzhen Plastics Ltd69
  • Chaozhou Ceramics63

How to use it

  1. 1Set marketplace or payment fees and the margin you need on the Settings sheet.
  2. 2Add a row per product and supplier with costs from the quote and freight estimate.
  3. 3Estimate monthly demand from marketplace research tools or competitor sales estimates.
  4. 4Rate each supplier from 1 to 5 on communication, samples, certifications and reviews.
  5. 5Order samples from everything marked Shortlist before committing to an MOQ.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Most bad products look good on the supplier’s price alone. For each product idea and supplier quote, enter unit cost, freight per unit, duty rate, selling price, minimum order quantity, estimated monthly demand and supplier rating; the sheet calculates landed cost, margin after marketplace fees, the cash tied up in the first order and how many months of stock it represents, then scores each option out of 100 and labels it Shortlist, Maybe or Pass.

Who it’s for

  • Choosing your first or next product to sell
  • Comparing several supplier quotes for one product
  • Checking a product still works after freight and duty
  • Presenting sourcing options to partners or investors

What’s included

  • Options sheet: Each product and supplier option, scored.
  • Settings sheet: Fees and your margin hurdle.

How to use it

  1. 1Set marketplace or payment fees and the margin you need on the Settings sheet.
  2. 2Add a row per product and supplier with costs from the quote and freight estimate.
  3. 3Estimate monthly demand from marketplace research tools or competitor sales estimates.
  4. 4Rate each supplier from 1 to 5 on communication, samples, certifications and reviews.
  5. 5Order samples from everything marked Shortlist before committing to an MOQ.

Tips

  • Include freight, duty, inspection and packaging in landed cost; they can add 20–40% to the factory price.
  • Check how many months of stock the MOQ represents: tying up 8 months of cash in one product is a big risk for a new seller.
  • Always order samples and, for larger orders, a pre-shipment inspection.
  • Duty rates depend on the product’s tariff classification and origin; confirm with a customs broker.

Questions

What is landed cost?

The total cost of getting one unit to your warehouse: product price plus freight, insurance, duty and taxes, customs fees and any inspection or prep costs.

What is a good profit margin for an e-commerce product?

Many sellers aim for at least 30% net margin after product, shipping, marketplace fees and advertising. Set your own minimum on the Settings sheet.

What does MOQ mean?

Minimum order quantity: the smallest number of units a supplier will produce or sell in one order. Many suppliers will negotiate a lower MOQ for a first order at a slightly higher unit price.

Related searchesproduct research spreadsheetsupplier sourcing templatelanded cost calculatoralibaba sourcing trackerproduct sourcing checklistmoq calculator

Details

Format
Spreadsheet
Category
E-commerce Operations
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetE-commerce OperationsFree

Product Research and Supplier Sourcing

Compare product ideas and supplier quotes on landed cost, margin after fees, MOQ cash and demand with a weighted score.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
E-commerce Operations
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More e-commerce operations templates

View all
E-commerce Profit Calculator2 sheets

Listings analysed

8

Average net margin

21%

Losing money

1

Entries by channel
3
2
2
1
Own storeAmazonEtsyeBay
SpreadsheetE-commerce Operations

E-commerce Profit Calculator

True profit per order after product cost, shipping, marketplace and payment fees, ads and returns.

10 min setupPreview

Customer Order Form

Take product orders online: customer details, items and quantities, delivery or collection, and payment choice.

Full name *

Email *

Phone *

Place order
FormE-commerce Operations

Customer Order Form

Take product orders online: customer details, items and quantities, delivery or collection, and payment choice.

10 min setupPreview
Product Catalogue with Margins2 sheets

Products

7

Average margin

64%

Low-margin products

1

ABCD
1ProductCategoryVariantSupplier
2Organic cotton teeApparelBlack / MGreenThread
3Heavyweight hoodieApparelGrey / LGreenThread
4Canvas tote bagAccessoriesNaturalBagCo
5Embroidered capAccessoriesNavyCapWorks
Products
SpreadsheetE-commerce Operations

Product Catalogue with Margins

SKUs with cost, price, margin, markup, stock and status for every product.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ