Clean up the SKU on each order row before Junipeer matches it with Qliro. Usually this means removing extra characters.
Each row connects:
a Function, and
the Characters it should use.
Functions
Allow only letters (a-zA-Z)
Allow only numbers and letters
Allow only numbers
Remove characters to the left
Remove characters to the right
Split using a delimiter and use only the characters to the left
Split using a delimiter and use only the characters to the right
Good to know
When you choose one of the split functions, enter the character to split on in Characters – usually
_or-.Leave it empty if the SKUs can be used as they are.