Skip to main content

Navireo

Navireo uses the same database structure as the InsERT GT programs, so the setup is almost the same as for Subiekt GT. The differences: the price checker also searches additional barcodes and skips products marked as deleted.

Before you start​

  • The price checker and the Navireo 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 and instance name shown when logging in to Navireo, e.g. COMPUTER\INSERTGT. On the price checker, enter the IP address instead of the computer name.
  • Database — the company database name; the most reliable place to read it is SQL Server Management Studio, under Databases.

Step-by-step setup​

  1. Open the settings, Source tab.
  2. Choose Navireo from the list.
  3. Fill in the fields:
FieldWhat to enterExample
AddressServer IP address and the instance or port.192.168.1.10\INSERTGT
User / PasswordThe read-only SQL login.pricechecker
DatabaseThe company database name.MyCompany
Encrypt connection (SSL)Leave checked.✓
Search by product code (SKU)Search by symbol.✓
Search by EAN codeSearch by the primary and additional barcodes.✓
Gross price / Net priceWhich price is shown.Gross price
Price level nameThe price level name as in Navireo, or its number 1–10.Detaliczna
  1. Press Connection test, then save the settings and scan a few products.
  • The price level works as in Subiekt GT: enter the level name (letter case does not matter) or a number 1–10. With a wrong name, the connection test lists the levels available in the database. Level 0 is the stock-card (purchase) price — usually zero, do not use it to show prices to customers.
  • Search by EAN code checks the product's primary barcode and all of its additional codes.
  • Search by product code (SKU) compares the scanned code with the product symbol.
  • Products deleted in Navireo are not shown.

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];
GRANT SELECT ON dbo.tw_KodKreskowy TO [pricechecker];

Navireo — FAQ

Does the price checker find a product by an additional barcode in Navireo?
Yes. With the Navireo source the app searches the product's primary barcode and all additional codes, as long as Search by EAN code is on.
Which price level do I enter for Navireo?
The name of the price level the customer should see, e.g. Detaliczna, or its number from 1 to 10. Level 0 is the stock-card price and is usually zero.
Which permissions does the price checker login need in Navireo?
Only SELECT on the tw__Towar, tw_Cena, tw_Parametr and tw_KodKreskowy tables in the company database.