How to Use Lovegobuy Spreadsheet Step-by-Step

If you are new to agent-based shopping, the lovegobuy spreadsheet is the single most important tool you can adopt. It transforms a chaotic workflow of scattered links, half-remembered sizes, and forgotten shipping deadlines into a clean, organized dashboard that you control completely. This step-by-step tutorial will walk you through every phase of building and using your first spreadsheet.

Step 1: Choose Your Platform

Start by deciding whether you want Google Sheets, Microsoft Excel, or Apple Numbers. Google Sheets is our top recommendation because it is free, cloud-synced, and works on every device. It also allows real-time collaboration if you ever want to share your sheet with an agent or a business partner. Excel is ideal if you need advanced formulas or offline access. Apple Numbers works well for Mac users but lacks some advanced automation features.

Step 2: Define Your Column Structure

A good lovegobuy spreadsheet always starts with clear column headers. Do not overcomplicate it. These ten columns cover 90% of shopping workflows:

• Item Name — A clear description like 'Nike Dunk Low Panda' instead of just 'sneakers'.
• Product Link — The original marketplace URL so you can verify details later.
• Size — The exact size you selected, including any conversion notes (e.g., EU 42 / US 9).
• Color — The specific colorway to avoid confusion.
• Price (CNY) — The product price in Chinese Yuan as listed.
• Agent Fee — The percentage or flat fee your agent charges.
• Shipping Estimate — Your best guess at per-item or consolidated shipping cost.
• Total Cost — A formula column that adds up all costs automatically.
• Status — Where the item sits in your pipeline: Wishlist, Ordered, QC, Shipped, etc.
• Notes — Any extra reminders like 'Ask for extra QC photos of stitching'.

Step 3: Add Conversion Formulas

One of the biggest advantages of a lovegobuy spreadsheet is automatic currency conversion. In your local currency column, enter a formula that multiplies the CNY price by the current exchange rate. For example, if converting to USD and the rate is 0.14, your formula would be =B2*0.14 where B2 contains the CNY price. You can also add a single cell at the top of your sheet labeled 'Exchange Rate' and reference it in all formulas, making updates instant when the rate changes.

Step 4: Color-Code with Conditional Formatting

Visual processing is faster than reading text. Apply conditional formatting rules so your Status column changes color automatically. In Google Sheets, select the Status column, go to Format → Conditional Formatting, and create rules: 'Delivered' becomes light green, 'Shipped' becomes blue, 'QC Pending' becomes yellow, and 'Wishlist' becomes gray. At a glance, you will know exactly where every item stands.

Step 5: Track Shipping and Deadlines

Add two extra columns: 'Warehouse Arrival Date' and 'Storage Deadline'. Most agents offer 30 to 60 days of free warehouse storage. After that, daily fees apply. By tracking these dates in your lovegobuy spreadsheet, you avoid surprise storage charges and can plan consolidation hauls strategically.

Step 6: Review Weekly

A spreadsheet only works if you keep it updated. Set a 10-minute reminder every Sunday evening to review your sheet. Update statuses, check for approaching deadlines, and move completed orders to a separate 'Archive' tab so your active view stays clean. This habit alone will eliminate 80% of shopping mistakes.