> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.stock-sync.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Product Identifier Field

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

${youtube}[Product Identifier Field](sej2azl0HTA?si=ye33NyO5wnKC6-dg)

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](https://help.stock-sync.com/en/article/do-we-support-variant-sku-metafield-as-a-product-identifier-zlwwkf/?bust=1732526188694) as a product identifier.

![](https://storage.crisp.chat/users/helpdesk/website/b219050a5836c000/frxudpblsivapo73moe7wyt-8wtvwv_1p0ety1.gif)

||| 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](https://help.stock-sync.com/en/article/can-we-add-a-prefix-or-postfix-during-the-add-process-1ch9guq/?bust=1732777872266).

![](https://storage.crisp.chat/users/helpdesk/website/b219050a5836c000/download-10_15g9qqi.jpg =438xauto)

###### Example of cases using store prefix/postfix:

| **Case**s | **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.

![](https://storage.crisp.chat/users/helpdesk/website/b219050a5836c000/download-7_i0qm0v.jpg =454xauto)

###### 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.

![](https://storage.crisp.chat/users/helpdesk/website/b219050a5836c000/download-3_rm5ez8.jpg =471xauto)

# 4. Match Case

To enable the upper or lower capital identifiers. 

![](https://storage.crisp.chat/users/helpdesk/website/b219050a5836c000/screenshot-2024-11-06-at-12301_1oa7qnf.jpg =461xauto)

# 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. 

![](https://storage.crisp.chat/users/helpdesk/website/b219050a5836c000/imagegbbedi_lbkjt.jpg =483xauto)