English

中文

English

中文

Appearance

Sluggish Products Query ​

How to Access ​

Products → Sluggish Products

Table of Contents ​

1. Use Cases ​

Quick Links: Find Sluggish Products | Adjust Query Parameters | Analyze Brand Sluggishness

Scenario 1: Find Sluggish Products in the Past 3 Months ​

Situation: Want to identify products that have barely sold in the past 3 months but have high inventory.

How to do it:

  1. Go to "Products" → "Sluggish Products"
  2. Select the target merchant at the top
  3. Set query parameters:
    • Query Period (Months): 3
    • Maximum Sales: 10 (10 units sold or fewer)
    • Minimum Stock: 100 (100 units or more in stock)
  4. Click the "Search" button

Result: The system lists all products that meet the criteria, including sales quantity and stock quantity.

Scenario 2: Adjust Parameters to Find More Severely Sluggish Products ​

Situation: Default parameters return too many products; want to find more severely sluggish products.

How to do it:

  1. Go to Sluggish Products Query page
  2. Select the merchant
  3. Adjust query parameters:
    • Query Period (Months): 6 (extend to 6 months)
    • Maximum Sales: 0 (no sales at all)
    • Minimum Stock: 500 (500 units or more in stock)
  4. Click the "Search" button

Result: Find products that have had zero sales in 6 months with inventory over 500 units—these are the most critical sluggish products to address.

Scenario 3: Analyze Sluggishness by Brand ​

Situation: After getting query results, want to analyze a specific brand.

How to do it:

  1. Complete the sluggish products query
  2. In the results table, click the filter icon on the "Brand" column
  3. Search and select the target brand
  4. Apply the filter

Result: The list shows only sluggish products for that brand, making it easy to perform brand-level inventory analysis.

2. Feature Guide ​

When warehouse space is taken up by products that haven't moved in a long time, use this page to find them. Set the query criteria (Query Period (Months), Maximum Sales, Minimum Stock) and the system analyzes sales data and lists products meeting the sluggish criteria — useful for reporting to merchants to arrange clearance promotions or returns and free up shelf space.

Quick Links: Main Features | Step-by-Step

2.1 Main Features ​

Merchant Selector ​

  • Location: Top of the page
  • Function: Select the merchant to query
  • Description: You must select a merchant before running a query

Query Parameters ​

FieldDescriptionDefault Value
Query Period (Months)Number of months to analyze backward3
Maximum SalesProducts with sales at or below this number are considered sluggish10
Minimum StockOnly products with stock at or above this number are included100

Result Columns ​

ColumnDescription
Product NameClick to view product details
SKUThe product's unique identifier
BarcodeProduct barcode
BrandProduct brand; filterable
Sales QuantitySales quantity during the query period
Total StockCurrent total stock quantity
Available StockTotal stock minus quantities allocated to orders
Created AtWhen the product was created

Summary Statistics ​

After the query completes, the criteria used (query period, maximum sales, minimum stock) and the total number of sluggish products found are displayed.

2.2 Step-by-Step ​

▸ Run Sluggish Products Query ​

  1. Go to Sluggish Products Query page
  2. Select the target merchant at the top
  3. Set query parameters:
    • Query Period (Months)
    • Maximum Sales
    • Minimum Stock
  4. Click the "Search" button
  5. The screen shows "Processing..."; results appear automatically when done
  6. View the results list

▸ Filter Query Results ​

  1. After the query completes, in the results table
  2. Click the filter icon on the "Brand" column
  3. Search and check the brands to filter
  4. Click to confirm and apply the filter

▸ Sort Query Results ​

  1. Click table column headers to sort
  2. Sortable columns include:
    • Sales Quantity
    • Total Stock (sorted largest first by default)
    • Available Stock
    • Created At

▸ Run a New Query ​

  1. Click the "Clear" button
  2. Reset query parameters
  3. Click "Search" to start a new query

3. FAQ ​

Quick Links: FAQ | Important Notes

3.1 FAQ ​

▪ How long does the query take? ​

Query time depends on the merchant's product count; the screen shows "Processing..." while it runs. Typically, a query of several thousand products takes from tens of seconds to a few minutes, and the results appear directly on the page when done.

▪ What defines a product as "sluggish"? ​

The definition of sluggish is determined by your query parameters:

  • Within the "Query Period (Months)"
  • Sales quantity at or below "Maximum Sales"
  • And total stock at or above "Minimum Stock" Products meeting all three criteria are listed as sluggish.

▪ Can I export the query results? ​

Currently, this feature does not support export. If you need to export data, please contact the system administrator.

▪ Why do I need to select a merchant? ​

Sluggish products query analyzes products for a specific merchant because each merchant's product inventory and sales data are calculated independently.

▪ What inventory types are included in the query results? ​

"Total Stock" is the sum of the product's quantity across all shelves; "Available Stock" is total stock minus quantities allocated to orders.

3.2 Important Notes ​

⚠️ Important Reminders ​

  • You must select a merchant before running a query
  • Do not close the page during the query, or you will need to run it again
  • The longer the analysis months and the looser the criteria, the longer the query takes
  • Query results reflect the data at the time of the query; later inventory changes are not updated into the results automatically
FeatureDescriptionLink
Product ListView and manage all productsGo
Inventory QueryView real-time inventory statusGo
Stock AdjustmentsAdjust inventory quantity or typeGo