Product # Change Utility

Below are the instructions to update your product numbers using the product number change utility:

Single Product number

In HITS, go to Views > Administration and Utilities > Utilities > Product # Change Utility

1. Select “Type – Single.”

2. Enter the current product number in the “Product #” field and the new product number in the “New Product #” field.

3. If you wish to retain the old product number in either the MFG SKU or Alternate Product Number field for your own records, you can uncheck those fields. If you prefer to update both fields with the new product numbers, please leave them checked.

4. Click Run. After the utility is done, search for the new product number to make sure the change went through

 

Multiple Product numbers

1. Open Excel and create a blank Excel spreadsheet and Save the blank spreadsheet type as CSV (Comma delimited).

 

2. Enter the existing product numbers in Column A and the new product numbers in Column B and save it

3. In HITS, go to Views > Administration and Utilities > Utilities > Product # Change Utility

• Select the Type – Multiple. If you wish to retain the old product number in either the MFG SKU or Alternate Product Number field for your own records, you can uncheck those fields. If you prefer to update both fields with the new product numbers, please leave them checked.

 

• Click on the binocular next to the Product# File (shown above), select the file created with the updated product numbers, and double click the excel file to add it to the Product# File field.

• Click Run. After the utility is done, search for a few new product numbers to make sure the change went through.