Articles on: Matching Column

Product Identifier Field

Set up Product Identifier mapping in Stock Sync to match store products with feed file records using SKUs, Barcodes, Product Handles, Metafields, or Variant IDs, while stripping prefixes, postfixes, or special characters.

Available on: ✔️ Add | ✔️ Update | ✔️ Export | ✔️ Remove

Watch the Product Identifier Walkthrough

Learn how to configure product matching options, prefixes, postfixes, and key separators in Stock Sync.

How to Set Up Product Identifier

Clear UI navigation path: Go to App → Feed Settings → Step 2: Matching Column

Map Primary Identifier: Locate the Product Identifier field and map it to the corresponding column in your feed file (e.g., SKU, Barcode, Variant ID, or Metafield).
Select Matching Type: Choose the identifier type that matches your feed data source (e.g., SKU, Barcode, Variant Metafield, or Product Metafield).
Configure Smart Settings: Click the gear icon next to the mapped field to adjust prefix/postfix removal, case sensitivity, or product key separators.
Save Configuration: Click Save to confirm your field settings.

For Add feeds, available identifier options are restricted to SKUs, Barcode, URL/Handle, Metafield (Variant), and Metafield (Product).

Variant Metafields and Variant IDs are fully supported as unique product identifiers across update and export feeds.

Product Identifier Smart Settings & Detailed Breakdown

1. Store Prefix/Postfix

Strip or attach prefixes and postfixes from store SKUs to match raw values in your feed file.

Available on: ✔️ Update only

To append a store prefix or postfix to the SKU during the product creation process, use custom text formatting settings.

Case	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 multiple values separated by commas.

2. Feed Prefix/Postfix

Remove prefixes, handles, special characters, or URLs from incoming feed file SKUs to align them with store identifiers.

Product Handles support multiple prefix removals using comma-separated values.

Case	Store SKU / Handle	Feed SKU / Handle	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 Postfix = `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 = `[*}`

You can test and validate regular expressions online using regex101.com.

3. Product Key Separator

Combine multiple feed columns (e.g., base SKU and option attribute) using a separator character to match a concatenated store SKU.

Example: If store SKU is ABC-123 and your feed splits this into column ABC (SKU) and column 123 (Option1), set - as the Product Key Separator.

4. Match Case

Enable strict case matching when product identifiers in your store or feed contain uppercase or lowercase letter distinctions.

5. Update Duplicate Products with Same Product Identifier

Enable this option if your store catalog contains duplicate products or variants sharing the same product identifier, ensuring all matching records receive updates without overwriting each other.

Available on: ✔️ Update only

Key Rules & Technical Details

Matching Logic: Stock Sync compares mapped feed values against store product records using the selected matching type (SKU, Barcode, Handle, or Metafield).
Wildcard & Regex Syntax: Asterisks (*) serve as wildcards for prefix/postfix stripping, while backslashes (\) escape special characters like $ or /.
Add Feed Restrictions: When adding new products, identifiers are restricted to SKUs, Barcode, URL/Handle, Variant Metafield, and Product Metafield.

Troubleshooting Steps

Issue: Feed items show "No Match Found" during processing → Solution: Verify whether your feed file contains extra spaces, dashes, or URL paths, and configure the corresponding Feed Prefix/Postfix rules.
Issue: Duplicate SKUs in store are not all updating → Solution: Enable Update duplicate products with same product identifier in the field's Smart Settings.
Issue: Handle URLs fail to match store handles → Solution: Enter the full domain URL path (e.g., HTTPS:\/\/WWW.STORE.COM\/PRODUCTS\/) under Feed Prefix to isolate the handle slug.

Good Articles to Continue

Do we support variant SKU metafield as a product identifier? → How to set up metafield identifiers for variant updates.
Can we add a prefix or postfix during the add process? → How to use custom text formatting when creating new catalog items.

Updated on: 15/10/2026

Was this article helpful?

Thank you!