Create Your Own LoveGoBuy Spreadsheet Easily

Introduction: Why Build Your Own?

Free templates are great, but every reseller has a unique workflow. Maybe you dropship instead of holding inventory. Maybe you buy in groups of ten instead of one. Maybe you sell on Grailed instead of StockX. Building your own lovegobuy spreadsheet lets you design every column, formula, and color code around your exact needs.

This guide assumes zero spreadsheet experience. If you can use Google Docs, you can follow these steps.

Step 1: Create a New Google Sheet

Open Google Drive, click New → Google Sheets. Name it My LoveGoBuy Tracker. This is your blank canvas.

Step 2: Build the Master List Tab

In Sheet1, rename it to Master List. Add these column headers: A = Product Link, B = Item Name, C = Size, D = Color, E = Vendor, F = Buy Price, G = Shipping, H = Status. Format row 1 as bold with a light gray background so it stands out.

Step 3: Add a Status Dropdown

Select column H, then click Data → Data Validation. Choose List of Items and enter: Researching, Paid, QC Requested, QC Approved, Shipped, Delivered, Sold. Now every cell in column H has a dropdown menu. No more typos.

Step 4: Add Conditional Formatting

Select column H again, click Format → Conditional Formatting. Add rules: text contains Delivered → green background, text contains Paid → yellow background, text contains QC Requested → orange background. Your lovegobuy spreadsheet now color-codes itself.

Step 5: Create a Profit Formula

In column I, add the header Net Profit. In I2, enter: =J2-(F2+G2)-J2*0.12-J2*0.035 where J2 is your Sell Price, F2 is Buy Price, G2 is Shipping, 0.12 is platform fee, and 0.035 is payment processing. Drag the formula down to all rows.

Step 6: Build a Vendor Quotes Tab

Right-click the sheet tab, choose Duplicate. Rename it Vendor Quotes. Keep the same product names but add columns for Vendor A Price, Vendor B Price, Vendor C Price. Use =MIN(D2:F2) in column G to auto-highlight the cheapest quote.

Step 7: Add a Monthly Summary

Create a new tab called Summary. Use =SUM(MasterList!F2:F100) to total all buy prices. Use =COUNTIF(MasterList!H2:H100,"Delivered") to count completed orders. Use =AVERAGE(MasterList!I2:I100) to calculate average profit margin.

Essential Formulas for Your LoveGoBuy Spreadsheet

Design Tips for a Clean Dashboard

• Freeze the first row so headers stay visible when scrolling down.
• Use alternating row colors (white / light gray) for easier reading.
• Bold all number columns and left-align text columns for visual hierarchy.
• Hide unused tabs if they clutter your workspace. Right-click → Hide.
• Add a Notes column for free-text reminders about each product.

Frequently Asked Questions