Articles on: Matching Column

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, 123HEREand 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.

Updated on: 19/03/2024

Was this article helpful?

Share your feedback

Cancel

Thank you!