Skip to main content

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 (INSERTGT is 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​

  1. Open the settings and go to the Source tab.
  2. Choose Subiekt GT from the list.
  3. Fill in the fields:
FieldWhat to enterExample
AddressServer IP address and the instance or port.192.168.1.10\INSERTGT
UserThe read-only SQL login.pricechecker
PasswordThe login's password.
DatabaseThe company database name.MyCompany
Encrypt connection (SSL)Leave checked.✓
Search by product code (SKU)Search by product symbol.✓
Search by EAN codeSearch by the primary barcode.✓
Gross price / Net priceWhich price is shown.Gross price
Price level nameThe price level name exactly as in Subiekt GT.Detaliczna
  1. Press Connection test — Connected should appear.
  2. 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.

Subiekt GT — FAQ

Which server address do I enter for Subiekt GT?
The IP address of the computer with SQL Server and the instance name, usually INSERTGT, e.g. 192.168.1.10 followed by a backslash and INSERTGT. If the instance has a fixed port, you can enter the port after a colon instead of the name, e.g. 192.168.1.10:1433.
How do I choose which Subiekt GT price the price checker shows?
Enter the price level name in the Price level name field, e.g. Detaliczna, and choose the gross or net price. If the name does not match, the connection test lists the levels available in the database.
Why doesn't the price checker find a product by the code on its package?
With Subiekt GT the app searches only by the primary barcode and by the symbol. If the code on the package is an additional barcode in Subiekt, make it the primary one or enter it as the product symbol.
Which permissions does the price checker login need in Subiekt GT?
Only SELECT on the tw__Towar, tw_Cena and tw_Parametr tables in the company database. Do not use the sa login or administrative roles.