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.
Supported variant metafield as a product identifier.
The Product Identifier field offers several options to help you match the store product with the feed file. We also support using variant metafields as identifiers. Please choose the option that is suitable for your feed file. You can refer to the information below for more details:
Please note that for the add feed only got three options available which are SKUs, Barcode and URL/Handle.
There are a few settings for this field which are:
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.
It supports wildcards and separated by comma.
To append a store prefix or postfix to the SKU during the adding process, you can use custom formatting.
Store Prefix
For example: SKU in the store is ABC1234, and in the feed file 12345. Then, include ABC to match with the feed file.
Store Postfix
To include postfix, need to add $ after the value.
For example: SKU in the store is 12345LESS, and in the feed file is 12345. Then, the prefix is LESS$
Store Prefix/Postfix supports wildcards too.
For example: If you want remove the dash from store to match the feed SKUs from XYZ123 (feed) to XYZ-123(store), can use *-* as in Store Prefix/Postfix field.
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.
Feed Prefix
To ignore all the prefixes from your feed file to match the store SKU.
For example:
ONE123, TWO123, THREE123 and just put in the field as ONE, TWO, THREE
Way to remove the link from the feed as a store
For example:
From the feed: https://www.helloshop26.fr/products/meuble-tele-buffet-tv-television-design-pratique-2-pcs-agglomere- 120-cm-chene-et-blanc-brillant-2502081
Store: meuble tele buffet tv television design pratique 2 pcs agglomere 120 cm chene et blanc brilliant 2502081/2
Prefix that can be used to ignore the link: HTTPS:\/\/WWW.HELLOSHOP26.FR\/PRODUCTS\/
Feed Postfix
To ignore all the postfixes from your feed file to match the store SKU.
For example:
123GONE, 123HERE and just put in the field as GONE, HERE to remove it.
Feed Prefix and Postfix supports wildcard and special character too.
For examples:
1. Given prefix - will remove the dash from XYZ-123 to match with XYZ123
2. If feed file has D-AU-45* and you want to remove the asterisk * at the end.
D-AU-45* Just use this [*] as a postfix
3. If has special character and want remove it.
ABC$123 and the postfix are $123, To remove the postfix, you need to include \$123
4. If your feed file has this SKU: AB310 4/4M and your store SKU: AB310-4/4M
To remove the space and add the dash to match the SKU, you can add a store prefix as *[-]* and a Feed prefix as *[ ]*
Test your regular expressions here: https://regex101.com/
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.
To enable the upper or lower capital identifiers.
If have multiple products with the same product identifier, enable it this option so that the update won't overwrite each other.
This field is essential for updates, adding, or removing products. You can use various identifiers and map multiple columns as needed.
Supported variant metafield as a product identifier.
The Product Identifier field offers several options to help you match the store product with the feed file. We also support using variant metafields as identifiers. Please choose the option that is suitable for your feed file. You can refer to the information below for more details:
Please note that for the add feed only got three options available which are SKUs, Barcode and URL/Handle.
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.
It supports wildcards and separated by comma.
To append a store prefix or postfix to the SKU during the adding process, you can use custom formatting.
Store Prefix
For example: SKU in the store is ABC1234, and in the feed file 12345. Then, include ABC to match with the feed file.
Store Postfix
To include postfix, need to add $ after the value.
For example: SKU in the store is 12345LESS, and in the feed file is 12345. Then, the prefix is LESS$
Store Prefix/Postfix supports wildcards too.
For example: If you want remove the dash from store to match the feed SKUs from XYZ123 (feed) to XYZ-123(store), can use *-* as in Store Prefix/Postfix field.
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.
Feed Prefix
To ignore all the prefixes from your feed file to match the store SKU.
For example:
ONE123, TWO123, THREE123 and just put in the field as ONE, TWO, THREE
Way to remove the link from the feed as a store
For example:
From the feed: https://www.helloshop26.fr/products/meuble-tele-buffet-tv-television-design-pratique-2-pcs-agglomere- 120-cm-chene-et-blanc-brillant-2502081
Store: meuble tele buffet tv television design pratique 2 pcs agglomere 120 cm chene et blanc brilliant 2502081/2
Prefix that can be used to ignore the link: HTTPS:\/\/WWW.HELLOSHOP26.FR\/PRODUCTS\/
Feed Postfix
To ignore all the postfixes from your feed file to match the store SKU.
For example:
123GONE, 123HERE and just put in the field as GONE, HERE to remove it.
Feed Prefix and Postfix supports wildcard and special character too.
For examples:
1. Given prefix - will remove the dash from XYZ-123 to match with XYZ123
2. If feed file has D-AU-45* and you want to remove the asterisk * at the end.
D-AU-45* Just use this [*] as a postfix
3. If has special character and want remove it.
ABC$123 and the postfix are $123, To remove the postfix, you need to include \$123
4. If your feed file has this SKU: AB310 4/4M and your store SKU: AB310-4/4M
To remove the space and add the dash to match the SKU, you can add a store prefix as *[-]* and a Feed prefix as *[ ]*
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: 07/03/2025
Thank you!