Home / News / 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! Ready to find your next haul? Open the Spreadsheet
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: