The Advanced Filter feature in Product Manager PRO allows you to refine and search product data based on custom rules, providing a simplified yet powerful alternative to manual SQL querying. This tool is ideal for precise data filtering and bulk updates, even when additional columns or third-party extensions are involved.

Features of Advanced Filter

1. Simplified Querying

• No need to write SQL queries.
• Use dropdown options to define filter conditions, such as:
  • Equals to
  • Like
  • Not Like
  • In / Not In
  • Greater Than / Less Than

2. Dynamic Field Population

• All fields from the product table are available for filtering.
• Supports additional custom columns added by you or third-party extensions.

3. Table Joins

• Join related tables, such as:
  • product_special (special prices)
  • product_to_category (category assignments)
• Filter products based on dependent table values, e.g., filter by special prices or specific categories.

4. Export Filtered Data

• Export filtered product data in CSV format for external editing or backup.
• The exported CSV can be re-imported using the CSV Import feature for bulk updates.

How to Use the Advanced Filter

1. Access the Filter:
   Navigate to the Advanced Filter section in the Product Manager PRO interface.
2. Define Filter Rules:
   • Select a field from the dropdown (e.g., Product Name, Price, Quantity).
   • Choose a condition (e.g., Equals, Greater Than, Like).
   • Enter the value to filter by.
   • Add multiple rules to combine filters.
3. Apply Filter:
   • Click “Apply” to view the filtered list of products.
   • Use the refined list to perform bulk actions or edits.
4. Export Data:
   • Click “Export CSV” to save the filtered data.
   • Edit the CSV file for updates and re-import using the CSV Import feature.

Benefits of Advanced Filter

• Customizable Search: Create detailed filters tailored to your needs without technical expertise.
• Enhanced Flexibility: Work seamlessly with custom columns and third-party modules.
• Efficient Updates: Export filtered data for bulk updates and maintain consistency in product details.
• Time-Saving: Quickly locate products with specific attributes, prices, or categories.

Example 1

I want to filter all products under the Category “Desktops“

Example 2:

I want to filter products that have a quantity of less than 10

Example 3:

I want to filter products that have a quantity greater than or equal to 100, and only category belongs to desktops, and manufacturer belongs to Apple or Sony

The Advanced Filter feature empowers OpenCart store owners to manage and update product data with precision, making inventory management more efficient and organized.