Home > CNFANS: How to Use the Spreadsheet’s Smart Filters to Manage QC and Refund Tasks

CNFANS: How to Use the Spreadsheet’s Smart Filters to Manage QC and Refund Tasks

2025-11-26

Efficient task management is crucial for e-commerce operations, especially when handling Quality Control (QC) checks and refund processing. With CNFANS' spreadsheet Smart Filters, you can automate sorting to prioritize pending refunds or unverified QC batches, saving time and reducing errors.

Step 1: Access Your Spreadsheet

Open your CNFANS spreadsheet containing QC and refund data. Ensure your columns are properly labeled (e.g., Status, QC Verified, Refund Pending).

Step 2: Activate Smart Filters

Click the Filter

Step 3: Prioritize Pending Refunds

To focus on退款任务:

  1. Click the dropdown in the Refund Status
  2. Select Filter by ConditionText Contains.
  3. Enter "Pending" to display only unresolved refunds.
  4. Sort by Date

Step 4: Manage Unverified QC Batches

For QC tasks:

  1. Use the QC Status
  2. Choose Filter by Value
  3. Combine with Priority

Step 5: Save Filter Views

Save your frequently used filters as named views (DataFilter ViewsSave) for one-click access to你的优先任务列表.

Benefits of Smart Filters

  • Automated Prioritization:
  • Reduced Manual Sorting:
  • Custom Workflows:

By leveraging CNFANS' spreadsheet Smart Filters, you can transform chaotic task lists into organized workflows, ensuring退款请求和QC批次are handled efficiently and promptly.

```