Save time by learning how to filter by product type, QC result, or shipment status — a powerful way to track every detail in one file
Managing multiple purchases through CSSBuy can quickly become overwhelming without proper organization. The CSSBuy spreadsheet is a powerful tool that lets you track every aspect of your haul in one centralized file. Mastering filtering and sorting will transform your purchasing experience from chaotic to streamlined.
Filtering Your Data
Filter by Product Type
Quickly locate specific categories in your haul by filtering product types:
- Select the column containing product categories (usually labeled "Item Type" or "Product Category")
- Click the filter icon (funnel-shaped) in your spreadsheet application
- Deselect "Select All" and check only the categories you want to view (e.g., "Shoes," "T-shirts," "Electronics")
- Click "OK" to apply the filter
This helps when you need to quickly check all your shoe purchases or review only clothing items.
Filter by QC Results
Quality Control (QC) images are essential for verifying item quality before shipping:
- Locate the QC status column in your spreadsheet
- Apply a filter to this column
- Filter by status such as:
- Approved
- Rejected
- Pending
- Rejected
- Approved
This ensures you never miss reviewing QC photos and helps prioritize items requiring your attention.
Filter by Shipment Status
Track your items through the shipping process with status filtering:
- Find the shipment status column (may include "Warehouse," "Shipped," "Delivered")
- Apply filters to view items by their current shipping phase
- Common status categories:
- Warehouse
- Processing
- In Transit
- Delivered
- Processing
- Warehouse
This helps you determine which items are ready to ship and track ongoing shipments.
Sorting Your Data
Sort by Date
Organize your purchases chronologically:
- Click the dropdown arrow in the date column (purchase date, QC date, or shipping date)
- Select "Sort Oldest to Newest" or "Sort Newest to Oldest"
- This helps track your most recent purchases or identify older items requiring action
Sort by Price
Manage your budget by organizing items by cost:
- Click the dropdown in the price column
- Choose to sort by "Smallest to Largest" or "Largest to Smallest"
- Helps identify your most expensive purchases or calculate total costs
Multi-Level Sorting
For advanced organization, use multiple sort criteria:
- Go to Data Sort in your spreadsheet application
- Add multiple sort levels (e.g., first by shipment status, then by purchase date)
- This creates a highly organized view showing all "Warehouse" items sorted by oldest first
Pro Tips for Maximum Efficiency
Use Color Coding
Apply background colors to cells based on status (red for rejected QC, green for shipped) for quick visual scanning.
Save Filter Views
Create and save custom filter combinations for frequent use without reconfiguring each time.
Regular Updates
Set a schedule to update your spreadsheet as you receive new QC photos or status changes.
Conditional Formatting
Automatically highlight items that have been in "Warehouse" status beyond a certain timeframe.
Take Control of Your CSSBuy Experience
By mastering the filtering and sorting capabilities of the CSSBuy spreadsheet, you transform a simple list of purchases into a powerful management system. You'll save significant time previously spent searching for information across multiple screens and gain better visibility into your entire purchasing journey. Implement these techniques with your next haul and experience the difference organization makes.