Home > Master Your Haul: Using Spreadsheet Filters to Organize with LoveGoBuy

Master Your Haul: Using Spreadsheet Filters to Organize with LoveGoBuy

2025-12-14

Managing a large LoveGoBuy

Step 1: Build Your Master Logistics Sheet

Start by creating a spreadsheet (Google Sheets or Excel) with the following core columns for every item:

  • Item #
  • Product Name / Link
  • Store / Seller
  • Price (¥)
  • LoveGoBuy Order #
  • Status
  • QC Photos Received?
  • Domestic Tracking #
  • International Tracking #
  • Notes

Step 2: Apply the Power of Filters for Key Categories

Use your spreadsheet's "Filter" or "Create a Filter" function on the header row. This allows you to view only specific subsets of your data. Create three primary views:

1. Filter for QC-Passed Items

Action:Status"QC Passed"QC Photos Received?"Yes".

Purpose:

2. Filter for Pending Refunds/Exchanges

Action:Status"Awaiting Refund", "RL (Red Light)", or "Contacted Seller".

Purpose:Notes

3. Filter for Shipped Parcels

Action:Status"Shipped Internationally"International Tracking #

Purpose:

Pro Tips for Advanced Management

  • Use Color Coding:Status
  • Create Separate Tabs (Sheets):
  • Link LoveGoBuy Order Numbers:
  • Freeze the Header Row:

Conclusion: Clarity at a Click

By leveraging the simple filter function in your spreadsheet, you turn a long list of purchases into a powerful logistics dashboard for your LoveGoBuy haul. This method minimizes errors, ensures timely actions on refunds, and provides peace of mind by clearly segmenting your items by their current stage in the journey. Happy organizing, and enjoy your haul!