How to Use Lovegobuy Spreadsheet: Step-by-Step Tutorial

Introduction

Learning how to use a lovegobuy spreadsheet is the fastest way to transform chaotic bulk orders into organized, profitable purchases. Whether you are buying five items or five hundred, a well-structured spreadsheet keeps every detail in one place.

This tutorial covers everything from opening your first sheet to advanced tricks that professional resellers use every day. By the end, you will have a fully functional lovegobuy spreadsheet that calculates costs, tracks status, and even predicts your shipping weight.

Before You Begin: What You Need

You do not need expensive software or advanced technical skills. Here is the complete tool list:

• A free Google account (for Google Sheets)
• Our free lovegobuy spreadsheet template
• The current USD-to-CNY exchange rate
• Your agent's fee percentage and shipping rate

That is it. No coding, no plugins, no subscriptions. Everything runs inside your browser.

Step-by-Step Tutorial

Step 1: Download the Template

Start by making a copy of our free template. In Google Sheets, click File > Make a Copy. This gives you your own editable version. Rename it to something memorable like My OOCBuy Orders — June 2026.

Step 2: Customize Your Settings

At the top of the sheet, you will see a settings area with three key inputs:

• Exchange Rate: Enter the current USD to CNY rate. Update this weekly.
• Agent Fee %: Enter your agent's percentage, usually 5-10%.
• Shipping Rate per kg: Enter the cost your agent charges per kilogram for international shipping.

These three numbers power every calculation in your sheet. Get them right, and your totals will be accurate within pennies.

Step 3: Add Your First Item

Find the first empty row in the main table. Here is what to enter in each column:

• Item Name: Copy the product title from oocbuy.com
• URL: Paste the product link for reference
• Size/Variant: Enter the exact size or variant you want
• Color: Note the color to avoid mix-ups
• Qty: How many of this item you are buying
• Unit Price (CNY): The item price in Chinese yuan
• Est. Weight (kg): Estimated weight per unit (check product page)

As soon as you enter the price and weight, the sheet automatically calculates the total cost in both CNY and USD. The formula accounts for agent fees, domestic shipping, and international shipping based on your settings.

Step 4: Use the Dashboard Tab

Click the Dashboard tab at the bottom. This summary view shows:

• Total number of items
• Total estimated cost in USD
• Total estimated weight in kilograms
• Average cost per item
• Cost breakdown by category

Use this dashboard before submitting your order to confirm your budget. If the total is too high, return to the main sheet and remove or replace items.

Step 5: Track Status with Color Codes

In the Status column, use these labels and let conditional formatting handle the colors:

• Ordered — Green background
• Paid — Light green
• In Warehouse — Yellow
• Shipped — Orange
• Received — Blue
• Issue — Red (wrong item, damage, delay)

One glance at your sheet tells you exactly where every item stands.

Advanced Techniques

Once you are comfortable with the basics, try these advanced moves:

Auto-Import with IMPORTXML: Use Google Sheets' IMPORTXML function to pull product prices directly from oocbuy.com. This saves manual copying but requires some URL knowledge.

Profit Margin Column: Add a Resale Price column and a formula that calculates profit margin as a percentage. This helps resellers identify their most profitable items instantly.

Pivot Tables: Build pivot tables in the Dashboard tab to analyze spending by category, agent, or month. Data-driven buyers make better decisions.

Conclusion

Learning how to use a lovegobuy spreadsheet takes about thirty minutes and pays dividends on every single order. The small upfront investment of organizing your data prevents the much larger cost of mistakes, forgotten fees, and poor resale planning. Download our template today and make your next order your smartest one yet.