Create Your Own Wegobuy Spreadsheet from Scratch
Templates are helpful, but nothing fits your workflow better than a custom-built Wegobuy spreadsheet designed exactly for your buying habits. Creating your own tracker from scratch takes about twenty minutes, teaches you how every formula works, and gives you total control over layout, color, and automation. This guide walks you through the entire build process column by column, formula by formula, so you end up with a spreadsheet that feels like it was made just for you.
Visit Our Main WebsiteStep 1: Define Your Columns
Start with a blank Google Sheet or Excel workbook. In the first row, type your column headers. Do not over-engineer at this stage. The most successful custom spreadsheets start with eight to ten columns and expand only after a real order reveals what is missing.
- Column A: Item Name. Keep it searchable and consistent.
- Column B: Store Link. Paste the full URL for dispute evidence.
- Column C: Size. Record the exact size you ordered.
- Column D: Color. Prevents confusion when ordering multiple colorways.
- Column E: Price (CNY). The original item price from the store.
- Column F: Domestic Shipping. Cost from seller to agent warehouse.
- Column G: Status. Use data validation to create a dropdown list.
- Column H: Weight (grams). Essential for international shipping decisions.
- Column I: International Shipping. Your share of the parcel cost.
- Column J: Total Cost. A formula that adds E, F, and I.
Step 2: Write Your First Formula
Formulas are what separate a spreadsheet from a fancy list. The first and most important formula is your row total. In cell J2, type =E2+F2+I2. This adds the item price, domestic shipping, and international shipping into one number that represents your true cost for that item.
| Formula | Location | Purpose |
|---|---|---|
| =E2+F2+I2 | J2 (copy down) | Total cost per item |
| =SUM(J2:J100) | Below J column | Grand total of all items |
| =COUNTA(A2:A100) | Below A column | Total number of items ordered |
| =AVERAGE(J2:J100) | Below J column | Average cost per item |
| =COUNTIF(G2:G100,"Shipped") | Below G column | Count of shipped items |
Step 3: Add Visual Polish
A spreadsheet that looks good gets used more often. Format your header row with a bold font and a subtle background color. Freeze the header so it stays visible while scrolling. Adjust column widths so every cell is readable on a phone screen. Apply conditional formatting to turn Status cells green for Delivered, yellow for In Warehouse, and red for Refund Requested.
- Header row: bold, background color #f5f3ef, dark text.
- Freeze row 1 so headers stay visible.
- Column widths: 120px for text, 80px for numbers, 200px for links.
- Conditional formatting: green for Delivered, yellow for In Warehouse, red for Refund Requested.
- Borders: light gridlines between rows, no borders inside individual cells.
Step 4: Test with a Real Order
The final step is the most important. Before declaring your spreadsheet complete, enter a real order. Do not use fake test data. Use an actual product you just purchased or are about to purchase. You will immediately discover which columns feel redundant, which formulas need fixing, and which missing pieces would make your life easier. Adjust the layout based on this real-world test, and your custom spreadsheet will be ready for production use.
Ready to build your custom tracker? Grab a product from our main store and use it as your first test row.
Get Best Deals NowFrequently Asked Questions
Do I need to know math to write formulas?
No. Spreadsheet formulas use plain English functions like SUM, AVERAGE, and COUNTIF. If you can read a restaurant bill, you can write a spreadsheet formula.
Can I save this as a reusable template?
Yes. In Google Sheets, click File then Save as Template. In Excel, save the file as a .xlsx template. Share it with friends or the community.
What if I build something that breaks?
Start with a copy of your blank template before entering real data. If a formula breaks, you can always revert to the clean version and try again.
Should I use formulas or manual entry for totals?
Always use formulas for totals. Manual entry invites errors, and the entire point of a spreadsheet is automatic calculation.
Creating your own Wegobuy spreadsheet from scratch is a twenty-minute investment that pays dividends for years. You learn how the system works, you customize every detail to your preferences, and you gain the confidence to fix or expand the sheet as your needs evolve. Start with ten columns, add three formulas, apply basic formatting, and test with a real order. By the end of the day, you will have a tracker that feels like a personal assistant. For products that deserve a custom tracker, visit our main store and start building.