Product Identifier field

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

The number of matches depends on this field.

These are the options you can use as identifiers:

• Variant SKU
• Barcode
• Variant's Title
• Product's Title
• Handle
• SKU + Option 1 
• SKU + Option 2
• SKU + Option 1 + Option 2
• SKU + Barcode
• SKU + Barcode + Option 1
• SKU + Option 3
• SKU + Option 1 + Option 3
• SKU + Option 2 + Option 3
• SKU + Option 1 + Option 2 + Option 3

You can use the column name from the feed file as the identifier:

eg: "SKU", "SKU++Colour", "SKU++Colour++Size"

or use column index such as eg: "1++2++3", "1", "1++2"

Store Prefix/PostFix

If products in the store contain any prefix or postfix, you can specify it.

For example, the SKU in the store is GONG12345 and in the feed file 12345.

Then include GONG in the field.

To include postfix, you need to add $ after the value.

For example, the SKU in the store is 12345LESS and in the feed file is 12345

Then you need to include LESS$.

Note: This field does not support comma-separated value.

Prefix on Feed

This will ignore all the prefix available in your feed file.

For example, ONE123, TWO,234 and so on

Just type in ONE, TWO

Postfix

This will ignore all the postfix available in your feed file.

For example, 123GONE, 123HERE

Just type in GONE, HERE

Both these fields support comma-separated value.