Quick Start: What Is OSSBuy Spreadsheet
OSSBuy Spreadsheet is a structured cost-tracking and supplier management system built for anyone who buys in bulk from overseas suppliers. It is not a marketplace. It is a command center for your purchasing decisions.
Think of it as your personal finance manager for sourcing: every SKU gets tracked, every supplier gets scored, and every dollar gets accounted for. If you have ever lost money because you forgot which seller had the better price, this tool fixes that.
Step 1: Get Your Template
Your first move is grabbing the right template. OSSBuy Spreadsheet ships with a pre-built starter sheet that includes all essential columns: item name, supplier URL, unit price, domestic shipping, international shipping, agent fee, and total landed cost.
- 1Download the starter template from the OSSBuy main site. It is free and ready to use.
- 2Make a copy in Google Sheets or Excel so you own your data.
- 3Rename the sheet with your project name (e.g., "Summer 2026 Restock").
Pro tip: Keep one master template untouched. Duplicate it for each new buying cycle. That way you always have a clean starting point.
Step 2: Build Your First Supplier List
Before you buy anything, you need to know who you are buying from. Your supplier list is the backbone of OSSBuy Spreadsheet. The better your list, the smarter your decisions.
Track Supplier URLs
Paste every supplier link directly into the sheet. No more digging through browser bookmarks when you need to reorder.
Rate Your Suppliers
Use a simple 1-5 score for quality, speed, and communication. Over time, patterns emerge and weak suppliers get filtered out.
Log Base Prices
Record the base item price from each supplier at the moment you find it. Prices change daily. Your log does not lie.
Note Lead Times
How long does each supplier take to ship? Log it. Slow suppliers cost you sales even if their unit price is lower.
Step 3: Track Costs Like a Pro
Most buyers only look at the sticker price. That is why they overpay. OSSBuy Spreadsheet forces you to see the full picture: item cost + domestic shipping + agent fee + international shipping = your true landed cost.
| Cost Layer | What It Is | Typical Range |
|---|---|---|
| Item Price | Base unit cost from supplier | $8 - $45 |
| Domestic Shipping | Shipping within China to agent | $0 - $3 |
| Agent Fee | Service charge by buying agent | 3% - 10% |
| International Shipping | Shipping from agent to you | $5 - $25 |
| Total Landed | Your real cost per unit | $15 - $80 |
Key insight: A $5 cheaper item with $15 higher shipping is NOT a better deal. OSSBuy Spreadsheet makes this obvious before you commit.
Step 4: Build Your Bulk Order Workflow
Once your data is clean, bulk ordering becomes a checklist instead of a guessing game. Here is the workflow that experienced OSSBuy Spreadsheet users follow every time.
Filter by priority
Sort your sheet by need level (must-have vs. nice-to-have) and total landed cost.
Group by supplier
Combine items from the same supplier into one order. You save on domestic shipping and agent processing.
Check stock availability
Visit each supplier link to confirm stock before you commit. Update your sheet with a stock status column.
Calculate order totals
Use spreadsheet formulas to auto-sum your entire order. No calculator needed.
Submit and log order IDs
After placing orders, paste order numbers back into the sheet for tracking.
Common Beginner Mistakes to Avoid
Ignoring domestic shipping
A cheap item with expensive domestic shipping can cost more than a pricier item with free domestic shipping.
Not updating prices
Supplier prices change weekly. A two-month-old sheet is not reliable. Refresh your data before every order.
Skipping quality scores
Price is not everything. A slightly more expensive supplier with 5-star quality saves you refunds and bad reviews.
One supplier for everything
Diversify. If one supplier goes out of stock or raises prices, your whole order should not collapse.
30-Day Progress Checklist
Week 1
- Download template
- Set up 5+ suppliers
- Log item prices
- Add cost columns
Week 2
- Add supplier ratings
- Calculate first landed costs
- Compare 3 suppliers for same item
- Set up filters
Week 3
- Build first bulk order list
- Group items by supplier
- Confirm stock availability
- Submit practice order
Week 4
- Log order tracking numbers
- Update supplier ratings post-delivery
- Analyze total spend vs. budget
- Plan next order cycle
Continue Learning
Ready to Start Your First OSSBuy Spreadsheet?
Grab the free starter template and begin tracking your suppliers today.