Subiekt GT
The price checker reads products and prices directly from the Subiekt GT company database in SQL Server. It shows the product name and the price from the chosen price level (e.g. Detaliczna — retail), net or gross.
Before you start
- The price checker and the Subiekt 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 server name shown in the Subiekt GT login window, usually in the form
COMPUTER\INSERTGT(INSERTGTis the typical instance name of InsERT GT programs). On the price checker, replace the computer name with its IP address, e.g.192.168.1.10\INSERTGT. - Database — the name of the company (podmiot) database. The most reliable place to read it is SQL Server Management Studio, under Databases of the instance. If the server has several companies, choose the database of the company whose prices the price checker should show.
Step-by-step setup
- Open the settings and go to the Source tab.
- Choose Subiekt GT 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\INSERTGT |
| User | The read-only SQL login. | pricechecker |
| Password | The login's password. | |
| Database | The company database name. | MyCompany |
| Encrypt connection (SSL) | Leave checked. | ✓ |
| Search by product code (SKU) | Search by product symbol. | ✓ |
| Search by EAN code | Search by the primary barcode. | ✓ |
| Gross price / Net price | Which price is shown. | Gross price |
| Price level name | The price level name exactly as in Subiekt GT. | Detaliczna |
- Press Connection test — Connected should appear.
- Go back with the back button, save the settings and scan a few products.
Price level, net and gross
Subiekt GT has up to 10 price levels (e.g. Detaliczna, Hurtowa, Specjalna — retail, wholesale, special). In the Price level name field enter the level name the way it appears in Subiekt — letter case does not matter. Instead of the name you can enter the level number from 1 to 10.
If the name does not match, the connection test lists the levels in the database, e.g. There is no price level “Detal”. Available: Detaliczna, Hurtowa, Specjalna. Copy one of the listed names.
The Gross price / Net price switch decides whether the screen shows the price with or without VAT. In a retail store the customer should see the gross price.
Symbol or barcode
- Search by EAN code — the app compares the scanned code with the product's primary barcode. Additional barcodes are not searched — a product whose package carries a code other than the primary one shows “Product not found”.
- Search by product code (SKU) — comparison with the product symbol (case-insensitive). Useful when your shelf labels carry a barcode with the symbol.
Keep both switches on unless you have a reason to turn them off.
Read-only login
USE [master];
CREATE LOGIN [pricechecker] WITH PASSWORD = N'Put-a-long-password-here', CHECK_POLICY = ON, DEFAULT_DATABASE = [MyCompany];
USE [MyCompany];
CREATE USER [pricechecker] FOR LOGIN [pricechecker];
GRANT SELECT ON dbo.tw__Towar TO [pricechecker];
GRANT SELECT ON dbo.tw_Cena TO [pricechecker];
GRANT SELECT ON dbo.tw_Parametr TO [pricechecker];
tw__Towar is the product file (name, symbol, barcode), tw_Cena holds the level prices, tw_Parametr the price level names. Details and warnings: SQL Server connection.