Filter Payloads, Product-Tags in Order overview

About the Extension

Filter Payloads and Product Tags in the Order Overview

With this plugin, you can filter the order overview in Shopware specifically by the payload data of order items and product tags. This allows you to find relevant orders faster and more efficiently by defining specific criteria. The filters can be easily configured in the plugin settings.

Plugin Features

1. Filter by Payload Data of Order Items
   Use the payload data stored in the order items to search specifically for certain properties, such as product numbers or custom fields assigned to the order items.    
2. Filter by Product Tags
   You can also filter orders by specific product tags. If this function is not required, it can be disabled in the configuration.    

1. Filter by Payload Data of Order Items:

The payload data of an order item can be found in the database under the column "order_line_item.payload". This data is stored in JSON format and can be fully utilized for filtering.

Example of Payload Data from the Database:

{
  "productNumber": "SW10018",
  "customFields":     {
    "migration_sw5current_product_attr1": "nemo",
        "migration_sw5current_product_attr2": "0"
  },
  ...
}

Example of a Valid Entry for the Plugin Configuration (Payloads of Order Items):

productNumber
customFields.migration_sw5current_product_attr1

Enter the keys to be filtered line by line in the plugin configuration. Each entry automatically creates a corresponding filter displayed in the filter overview. The filter name is based on the specified payload key (e.g., "Payload: productNumber"). For the custom fields, enter the key “customFields” followed by the technical name of the custom field (e.g. customFields.migration_sw5current_product_attr1). You can find out more about custom fields here: Shopware 6 - Settings - Custom fields

2. Filter by Product Tags:

Additionally, you can filter orders by specific product tags. This function can be activated or deactivated in the plugin configuration as needed. When the product tags filtering is enabled, a "Product Tags" filter will appear in the filter overview. You can then select one or more tags assigned to the products in the order items to filter orders specifically (e.g., "hazardous materials"). More information about configuring tags can be found here: Shopware 6 - Settings - Tags

Benefits of the Plugin

• Increased Efficiency: Quickly find orders with specific properties.
• Flexibility: Combine different filtering methods to achieve precisely the desired results.
• Easy Configuration: Set up filters intuitively in the plugin configuration.

With this plugin, you maintain control over your order overview and sustainably optimize your workflows.

Dokumentation

Documentation in German can be found here: Shopware 6 - Filter order items by payloads and product tags in the order overview