Product Categories Mapping

Product Categories Mapping

Product Categories Mapping controls how the sync translates external product category IDs into ExpoPlatform's own Product Categories for exhibitors. When an exhibitor record arrives with a list of product category IDs from the source system, this mapping table is used to convert each external ID into the corresponding ExpoPlatform Product Category. The result is applied to the exhibitor's profile.

If the incoming data contains product category IDs that have no entry in the mapping, those unmapped IDs are silently ignored — the exhibitor's existing Product Categories in ExpoPlatform are preserved rather than being cleared.

Exhibitor-only setting. Product Categories Mapping applies to exhibitor entities only. Visitor syncs don't use this setting.


How to configure

The mapping is managed from the Product Categories Mapping panel inside the exhibitor settings page for the integration (for example: Admin → Integrations → MapYourShow → Exhibitor Settings). The panel shows the current number of active mappings and provides three actions:

  • Import — upload a CSV file to replace all existing mappings with the entries in the file

  • Export — download the current mappings as a CSV file

  • Delete mapping — remove all mappings for this integration and event

CSV format for import

The first row must be the header our_id,external_id. Each subsequent row maps one ExpoPlatform Product Category (by its internal numeric ID) to one external category ID from the source system.

our_id,external_id
1,599
2,600

Each row specifies:

Column

Meaning

our_id

The ExpoPlatform Product Category (internal numeric ID).

external_id

The ID as it appears in the source system's data.


Behaviour summary

Product Categories Mapping is a modifier, not a skip gate. Processing always continues regardless of how the mapping resolves. What happens to the exhibitor depends on what the incoming data contains:

Incoming data

Mapping table state

Result

Field missing from incoming data

Any

Existing ExpoPlatform Product Categories are preserved unchanged

Field present, empty list

Any

ExpoPlatform Product Categories are cleared

Field present, IDs found in mapping

Has entries

Mapped ExpoPlatform Product Categories are applied

Field present, IDs not found in mapping

Has entries

Existing ExpoPlatform Product Categories are preserved unchanged

Field present, any IDs

Empty

Existing ExpoPlatform Product Categories are preserved unchanged


When to configure this

Configure Product Categories Mapping when the source system contains product category IDs you want to reflect on the ExpoPlatform exhibitor profile. If it's left empty (no rows), Product Categories in ExpoPlatform won't be populated from the sync — they'll need to be managed manually or through another route.