Product Identifier field

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

This field is the most essential that needs to be mapped for an update or adding new products or removing products. 

There are many options you can use as identifiers. You can also set multiple column on this field. 

There are a few options for the SKU field. Do set the one which suitable for your feed file. Can refer to below:

There are a few settings for this field which are:

1. Store Prefix/Postfix

If your you products in the store contain any prefix or postfix, can specify it. It supports wildcards too. It's supported by the comma-separated value. 

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$

Prefix/Postfix supports wildcards too. 

For example:

Given prefix -  will remove the dash from XYZ-123 to match with XYZ123

2. Feed Prefix/Postfix

If your products in the feed contain any prefix or postfix, you can specify it. Handles 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 wirldcard 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 *[ ]*

3. Product Key Separator

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

4. Case Sensitive

To enable the upper or lower capital identifiers. 

5. Update duplicate products with same product identifier

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