Managing a large LoveGoBuyspreadsheet filters. This guide will show you how to transform your order list into a clear management dashboard.
Step 1: Build Your Master Spreadsheet
Start by creating a detailed spreadsheet, either in Google Sheets, Microsoft Excel, or a similar program. Your columns should include:
- Item Name/Link:
- Order # / LoveGoBuy Parcel ID:
- Price (¥):
- Warehouse Status:
- QC Status:QC PASSED, REFUND PENDING, AWAITING QC.
- Shipping Status:SHIPPED.
- Notes:
- Order # / LoveGoBuy Parcel ID:
Step 2: Apply Filters and Organize Your View
Highlight your header row and click the "Filter" button (usually a funnel icon). This adds dropdown arrows to each column header, enabling you to view specific data sets.
Use Case 1: Isolating QC-Passed Items
Click the dropdown in the "QC Status""QC PASSED"prepare a domestic shipment
Use Case 2: Tracking Pending Refunds
In the same "QC Status" filter, select only "REFUND PENDING". This creates a focused action list. You can reference the Notes column for reason codes and systematically contact LoveGoBuy support
Use Case 3: Monitoring Shipped Parcels
Use the filter in the "Shipping Status""SHIPPED". This view lets you track parcels that are already on their way to you. You can copy the tracking numbers from your notes or a separate tracking ID column for external monitoring.
Step 3: Advanced Sorting for Pro Management
Combine filters with sorting for ultimate control:
- Sort by Price (Descending):
- Sort by Warehouse Arrival Date:
- Use Multiple Column Filters:and
- Sort by Warehouse Arrival Date:
Conclusion: Order from Chaos
By leveraging simple spreadsheet filters to categorize your LoveGoBuy haul into QC-passed, refund-pending, and shipped items, you transform a chaotic list into a visual logistics command center. This method saves time, reduces errors, and ensures you never lose track of an item or a necessary action, making the entire shipping process transparent and manageable.