Adding or Removing Merchandise Item Database Fields on the Transaction Screen

How to Add or Remove Merchandise Item Database Fields on the Transaction Screen

 

Step 1: Open the "simply-layouts-template.htm" file using a text editor, such as Notepad ++ or Notepad. The file is located here: \ProgramData\RetailPro\Server\WebClient\template\document-item

Step 2: Change the DATA TRANSLATION NUMBER and the DATABASE FIELD NAME for whichever fields you wish to change. The steps to do this are detailed below.

 

Step 2 - Part 1 : Determine the DATA TRANSLATION NUMBER for the field you wish to add:

• Open the "en-us.json" translation file using a text editor, such as Notepad ++ or Notepad. The file is located here: \ProgramData\RetailPro\Server\WebClient\locale
• Conduct a page search (CTRL+F) for the field you wish to add (e.g. "Size"). Note the data translation number for this field.
• 
• In the "simple-layouts-template.htm" file, find the database field that you wish to remove from the transaction screen, and replace the data translation number with the one you have just located.

Step 2 - Part 2: Determine the DATABASE FIELD NAME for the field you wish to add:

• Launch another browser tab and enter the FQDN or static IP address for the Prism Server into the address bar. At the end of the address, add "/api-explorer" (ex: https://server_name/api-explorer)
• Click on the RPSRESTServiceModule > REST Resources > Document > Item
• Click on the "attributename" column header to re-sort the list by attribute name.
• Scroll down to locate the database field name (e.g. "Item_Size").
• In the "simple-layouts-template.htm" file, find the database field that you wish to remove from the transaction screen, and replace the Database Field Name with the one you have just found (only use lower case letters).
• 
• Click SAVE

Step 3: Logout of Prism, Clear the browser cache, Logon to Prism.

Step 4 : Create a sales transaction and list an item to confirm if you changes have taken effect. Your fields should now be showing in the item details grid.