Update Based Upon Item ID (Do it Best)

Update Based Upon Item ID (Do it Best)
 

This utility requires the Vendor List report the store

 
  • First, the store's IC > Reports > Vendor List Report in CSV format is emailed to Do it Best.  The correct report settings are reviewed within Do it Best Data Extraction Requests. Email the resulting file to Do it Best to jimmy.sturm@doitbest.com
 
2. Once Do it Best has processed the file containing the cross referencing information, Do it Best will send the store's "cross match" files to the support staff at TransActPOS.  The file(s) should be downloaded to the store and placed in a folder accessible from the Data01 folder.  Opening the text file with a simple text editor like Notepad ++, the matching information is presented. Refer to the Do it Best - Cross Reference Ranking topic for further clarification.
 
Suggestion: create a folder within the Data01 folder (Data01\_DoitBestMatches)
 
With the "Matches.txt" file in place, the TransActPOS Support Team Member may proceed with the utility below.
 
 

The Process

Part Numbers - the Parts Numbers utility adds new part numbers to ICPART which will appear within the Lookup By screen of the item.  This file includes the item Ranking information that is referenced in Do it Best - Cross Reference Ranking which indicates the method of how Do it Best matches the items to the "Old Vendor".