Why you would use this feature
This feature is useful for migrating planograms to or from other systems that use different formatting. It also allows standardization of UPC codes across planograms to help make product attribute maintenance and reporting easier.Feature Options
What field do you want to update from?
Select the product-level field that contains the UPC that needs to be formatted.Which field do you want to save your updates?
Select the destination field for the reformatted UPC.Add Fix
Click the Add Fix button to add an entry to the list of UPC fixes.What type of fix do you want to apply?
Select the type of fix that you want to apply to your UPCs.Add check digit to the right
Add specific digits/characters
Adds digits and/or characters to either the front or back of the UPC if it matches the specified criteria. You can specify whether the search value should be located at the start or end of the UPC or whether the UPC contains the search value. Digits or characters to be added can be added to the start or end of the UPC.Cut to a maximum length
Removes digits and/or characters from UPCs that are longer than the specified length. Digits/characters are removed from the front of the UPC.Pad to a minimum length
Adds the digit or character specified to the front of UPCs shorter than the number chosen in the minimum length selector until they reach that length.Remove the rightmost digit
Removes the rightmost digit of the UPC.Remove specific digits/characters
Removes digits and/or characters from a UPC if it matches the specified criteria. You can specify whether the search value should be located at the start or end of the UPC or whether the UPC contains the search value. Specify the number of characters to be removed and select whether to remove characters from the start or end of the UPC.UPC-E conversions
Converts UPCs in UPC-A to UPC-E format, and vice versa. Select Convert UPC-E to UPC-A to convert UPCs from UPC-E format to UPC-A. If Input has a check digit is checked, UPCs that have 8 or fewer digits will be converted. If unchecked, UPCs that have 7 or fewer digits will be converted. Select Convert UPC-A to UPC-E to convert UPCs from UPC-A to UPC-E. If Input has a check digit is checked, UPCs that have more than 8 digits will attempt to be converted. If unchecked, UPCs that have more than 7 digits will attempt to be converted. Check Input has a check digit to tell the converter that the UPC to convert has a check digit. If unchecked, the converter will assume there is no check digit. Check Calculate check digit for output to tell the converter to calculate and add a check digit to the resulting output. If unchecked, the converter will output the converted UPC without a check digit.Not all UPCs in UPC-A format can convert to UPC-E. If a conversion isn’t possible then the UPC is left in UPC-A format.
