Create a Lovegobuy Spreadsheet Easily in Under 15 Minutes

Introduction

If the idea of building a spreadsheet from scratch sounds intimidating, this guide is for you. You can create a fully functional lovegobuy spreadsheet in under fifteen minutes — even if you have never used Google Sheets before.

We are skipping the complex formulas and advanced tricks. This is a bare-bones, step-by-step walkthrough that gets you from blank page to organized order tracker before your coffee gets cold.

Step 1: Open Google Sheets

Go to sheets.google.com and create a new blank spreadsheet. You can also use Excel or any spreadsheet app, but Google Sheets is free and works on every device.

Step 2: Create Your Headers

In row one, type these headers across the columns:

Item Name | URL | Size | Color | Qty | Price (CNY) | Fee | Shipping | Total (USD) | Status

Do not worry about formulas yet. We will add those in step four.

Step 3: Add Your First Item

Fill in the first row with a real or sample item. For example:

• Item Name: Vintage Hoodie
• URL: [paste oocbuy.com link]
• Size: Large
• Color: Black
• Qty: 2
• Price: 85

Leave Fee, Shipping, Total, and Status blank for now.

Step 4: Add the Magic Formula

Click the Total (USD) cell for your first item row. Type this exact formula:

=F2*(1+0.08)+10

This assumes an 8% agent fee and a flat $10 shipping estimate. Adjust the numbers based on your agent's actual rates. When you press Enter, the cell shows your estimated total in USD.

Step 5: Copy the Formula Down

Grab the small square at the bottom-right corner of your Total cell and drag it down to fill twenty rows. Every new item you add will automatically calculate its own total.

Step 6: Color-Code Status

In the Status column, type words like Ordered, Shipped, or Received. Then select the Status column, go to Format > Conditional Formatting, and set color rules:

• Text contains Ordered = Green
• Text contains Shipped = Yellow
• Text contains Received = Blue

Now your sheet has a visual pulse that shows progress at a glance.

Conclusion

You now have a working lovegobuy spreadsheet. It is not fancy, but it works. As you get more comfortable, you can add columns, formulas, and dashboard tabs. The important thing is that you started. Your future self will thank you when that first organized package arrives.