In connection with the order overview, there is a customer need to be able to search for external order references (e.g., Amazon/eBay order numbers or member names).
This data is currently only stored in the "additional information" of the order during import and is therefore not found in the standard administration search function.

Requirement/Use Case:

Customers want to be able to search the order overview for these external references to more easily find orders for accounting or support.

Typically, this involves fields such as:

Amazon order number

eBay order number

eBay username

Current status:

The standard search in the order overview only accesses certain indexed fields (e.g., order number, customer, email).

Data in "additional information" or unstructured JSON fields is not searched.

Proposal for a possible technical solution:

Introduction/use of custom fields at the order level (customFields.amazonordernumber, customFields.ebayordernumber, etc.),

Indexing these fields in the DAL search or in the Elasticsearch index,

Expanding the admin order overview with filter/search fields for these custom fields.

Assessment:
This use case is often relevant for Shopware 5 migrations and multi-channel integrations (Amazon, eBay, Idealo, etc.). A generic solution for making such external references searchable would therefore be desirable or should at least be documented as an extension interface.