Samsung Cash Register Price List Generator
Developed by António Rodrigues
This program is developed in Excel macros to generate automatically the price list of the products configured in the Samsung ER5100, ER5115 and ER5140.
This program uses the standard Samsung connect program to retrieve the information from the Samsung machine (also in the package installDir/ER5100). That information is taken from the machine and manipulated with the program to generate automatically the price list of the store.
The user can see the standard price list report in the first page of this document. The user can change this report format as needed, the report giving can be used has a template to construct your own reports.
This document gives all the information the Operator needs to configure and use the program in their environment.
Before explain in detail the application functionality is presented in the chapter 2 one Use Case where the reader can understand for what this program is design and developed.
How many times the store owner change one price of one product and must change a lot of price lists to the public. Almost of the times this implies lot of work to rewrite again the list and replace it.
Now with this application, after the prices are changed in the Samsung Cash Register can have new price lists printed in two (2) minutes.
The user changes the prices in the Samsung Cash Register (ER5100), this can be done manually in the machine or with Samsung ER-51 Series PC Interface Utility department machine download. After that, use the Samsung ER-51 Series PC Interface Utility to upload the department program to the computer, click in two buttons in the excel sheet and the report is ready to print and distribute again.
The installation is very easy and fast.
Just run the “PriceList.exe” setup application and follow the screen instructions.
The package sent has two applications:
The first is the standard Samsung communication program to connect the Cash Register to the PC. Just run the “5100.exe” file to install it. If your computer do not have in the windows/system32/ directory the file expsrv.dll copy to that directory the file given in the package.
To install the Price List application copy all the files and directories installed by the “PriceList.exe” (you do not need to copy the ER5100 directory) to the same directory of the Samsung ER-51 Series PC Interface Utility installation directory (by default C:\Program Files\51XX).
This application needs also to have the Java Runtime Environment installed (JRE), if your machine does not have the Java installed go to www.java.com and download and install the most recent JRE available (very easy, just follow the screen instructions).
To start faster the application you can create one shortcut of the excel sheet in your desktop.
There is only one parameter to configure, the customer. In the Sheet “WordReplaceConfig” row “E1” the user must configure the customer created in the Samsung ER-51 Series PC Interface Utility. The Samsung ER-51 Series PC Interface Utility can have more than one customer. The customer configured here is the customer information that is retrieved from the Samsung ER-51 Series PC Interface Utility.
Figure 1 – Customer Configuration
The Samsung Cash Register have few characters to the description of the products and in the price list almost of the times we need more accurate information. To improve the quality of the description presented in the price list the application gives the opportunity to the operator to define some automatically replacements to the descriptions. The operator defines in the first column the string pattern to find and replace with the string in second column (sheet: “WordReplaceConfig” rows: “A1:A100” e “B1:B100”). For example: to replace C/H with Cheese / Ham put in first column “C/H “ and in second “Cheese / Ham “.
Figure 2 – Replacement patterns
The Samsung ER-51 Series PC Interface Utility can be used to configure prices. Do the following steps to implement that configuration:
Figure 3 – Program Department Up
Figure 4 – Department Price Configuration
Figure 5 – Department Program Download to the Machine
To generate the price list the operator need to do the following steps:
Figure 6 – GetPrice and Convert Buttons