Comarch ERP Optima
The price checker reads items and prices directly from the Comarch ERP Optima company database in SQL Server. It shows the item name and its default sales price.
Before you start
- The price checker and the Optima server are on the same network, and SQL Server accepts TCP connections — SQL Server connection.
- You have a read-only SQL login — script below.
Where to find the server and the database
- Server — the SQL server name shown when logging in to Optima, usually in the form
COMPUTER\OPTIMA. On the price checker, enter the IP address instead of the computer name, e.g.192.168.1.10\OPTIMA. - Database — the company database, usually with a name starting with
CDN_, e.g.CDN_MyCompany. You can see the list of databases in SQL Server Management Studio.
Optima also has a configuration database (usually CDN_KNF_Konfiguracja). Connecting to it works, but it contains no items — the connection test shows Connected to the server, but CDN_KNF_Konfiguracja is not a ERP Optima database. Choose the company database.
Step-by-step setup
- Open the settings, Source tab.
- Choose ERP Optima from the list.
- Fill in the fields:
| Field | What to enter | Example |
|---|---|---|
| Address | Server IP address and the instance or port. | 192.168.1.10\OPTIMA |
| User / Password | The read-only SQL login. | pricechecker |
| Database | The company database name. | CDN_MyCompany |
| Encrypt connection (SSL) | Leave checked. | ✓ |
| Search by product code (SKU) | Search by item code. | ✓ |
| Search by EAN code | Search by the EAN code from the item card. | ✓ |
- Press Connection test, save the settings and scan a few products.
Which price is shown
The app shows the price that is set as the default sales price on the item card in Optima, the way it is stored — net or gross, depending on how that price is defined in Optima. For Optima, the price checker settings have no price list choice and no net/gross switch. If customers should see the gross price, set a gross price (e.g. the retail price) as the default sales price in Optima.
Symbol or barcode
- Search by EAN code — comparison with the EAN field on the item card.
- Search by product code (SKU) — comparison with the item code (case-insensitive).
Read-only login
USE [master];
CREATE LOGIN [pricechecker] WITH PASSWORD = N'Put-a-long-password-here', CHECK_POLICY = ON, DEFAULT_DATABASE = [CDN_MyCompany];
USE [CDN_MyCompany];
CREATE USER [pricechecker] FOR LOGIN [pricechecker];
GRANT SELECT ON CDN.Towary TO [pricechecker];
GRANT SELECT ON CDN.TwrCeny TO [pricechecker];