Articles on: Matching Column

Product Identifier Field

Available on: ✔️ Add ✔️ Update ✔️ Export ✔️ RemoveThis field is essential for updates, adding, or removing products. You can use various identifiers and map multiple columns as needed.

The Product Identifier field offers several options to help you match the store product with the feed file. We also support using variant metafields and variant ID as identifiers. Please choose the option that is suitable for your feed file. You can refer to the information below for more details:

✅ Supported variant metafield as a product identifier.

Please note that for the add feed only got few options available which are SKUs, Barcode, URL/Handle, Metafield(variant) and Metafield(product).

There are a few settings for this field which are:

1. Store Prefix/Postfix (✔️ Update)

If your product's SKU in the store contain any of the value infront or at the back. We can set the prefix or postfix, so it will easily match within the feed file.

To append a store prefix or postfix to the SKU during the adding process, you can use custom formatting.

Example of cases using store prefix/postfix:

Cases	Store SKU	Feed SKU	Setting Applied
Store Prefix	`ABC1234`	`1234`	Store Prefix = `ABC`
Store Postfix	`12345LESS`	`12345`	Store Postfix = `LESS$`
Remove Dash (Store)	`XYZ-123`	`XYZ123`	Store Prefix/Postfix = `-`

✅ Supports wildcards and separated by comma.

2. Feed Prefix/Postfix

If your product's SKU in the feed contain any value infront or at the back. We can set the prefix or postfix, so it will easily match within the store.

Handles also support the prefixes. It's supported by the comma separated value.

Example of cases using store and feed prefix/postfix:

Case	Store	Feed	Setting Applied
Feed Prefix	`123`	`ONE123`	Feed Prefix = `ONE`
Feed Multiple Prefixes	`123`	`ONE123,TWO123`	Feed Prefix = `ONE,TWO`
Feed Multiple Prefixes with REGEX	`5535,671013`	`4007841005535,4007841671013`	Feed Prefix = `40078410*`
Remove Dash (Store)	`ABC-123`	`ABC123`	Store Prefix/Postfix = `-`
Remove URL Prefix	`meuble-tele...2502081`	`https://www.helloshop26.fr/products/meuble-tele...2502081`	Feed Prefix = `HTTPS:\/\/WWW.HELLOSHOP26.FR\/PRODUCTS\/`
Feed Postfix	`123`	`123GONE`	Feed Postfix = `GONE`
Feed Multiple Postfixes	`123`	`123GONE, 123HERE`	Feed Prefix = `GONE,HERE`
Remove Special Character	`ABC123`	`ABC$123`	Feed Postfix = `\$123`
Replace Space with Dash	`AB310-4/4M`	`AB310 4/4M`	Store Prefix = `[-]`, Feed Prefix = `[ ]`
Remove Asterisk	`D-AU-45`	`D-AU-45*`	Feed Postfix = `[*}`

✅ Test your regular expressions here: https://regex101.com/

3. Product Key Separator

If your products in the feed contain any product key separator, can specify it.

For example: Store SKU as ABC-123 and feed have ABC as sku column and 123 as option1 column, then use - as product key separator.

4. Match Case

To enable the upper or lower capital identifiers.

5. Update duplicate products with same product identifier (✔️ Update)

If have multiple products with the same product identifier, enable it this option so that the update won't overwrite each other.

Updated on: 27/08/2025

Was this article helpful?

Thank you!