Skip to main content

Subiekt nexo

The price checker reads products and prices directly from the Subiekt nexo database in SQL Server. It shows the product name and the gross price from the chosen price list.

Before you start​

  • The price checker and the nexo 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 when logging in to Subiekt nexo, usually COMPUTER\INSERTNEXO (INSERTNEXO is the typical instance name of InsERT nexo programs). On the price checker, enter the IP address instead of the computer name, e.g. 192.168.1.10\INSERTNEXO.
  • Database — nexo company databases usually have names starting with Nexo_, e.g. Nexo_MyCompany. You can see the list of databases in SQL Server Management Studio, under Databases.
  • Price list name — the name of a price list from the price lists module in Subiekt nexo. If you are not sure what it is called, type anything and run the connection test — the message lists the price lists in the database.

Step-by-step setup​

  1. Open the settings, Source tab.
  2. Choose Subiekt Nexo from the list.
  3. Fill in the fields:
FieldWhat to enterExample
AddressServer IP address and the instance or port.192.168.1.10\INSERTNEXO
User / PasswordThe read-only SQL login.pricechecker
DatabaseThe company database name.Nexo_MyCompany
Encrypt connection (SSL)Leave checked.✓
Price list nameThe price list the price comes from.name from Subiekt nexo
Search by product code (SKU)Search by product symbol.✓
Search by EAN codeSearch by barcodes.✓
  1. Press Connection test. The app also checks that the given price list exists — on error you will see e.g. There is no price list “Detal”. Available: … with the list of valid names.
  2. Save the settings and scan a few products.
  • The screen shows the gross price from the chosen price list entry. The net price cannot be selected for Subiekt nexo.
  • A product that is not in the chosen price list gives Product not found — even if it exists in the product file. Make sure the price list covers the whole range sold in the store.
  • Search by EAN code searches all barcodes of the product, from all units of measure — including the barcode of a carton.
  • Search by product code (SKU) compares the scanned code with the product symbol.

Read-only login​

USE [master];
CREATE LOGIN [pricechecker] WITH PASSWORD = N'Put-a-long-password-here', CHECK_POLICY = ON, DEFAULT_DATABASE = [Nexo_MyCompany];

USE [Nexo_MyCompany];
CREATE USER [pricechecker] FOR LOGIN [pricechecker];
GRANT SELECT ON ModelDanychContainer.Asortymenty TO [pricechecker];
GRANT SELECT ON ModelDanychContainer.PozycjeCennika TO [pricechecker];
GRANT SELECT ON ModelDanychContainer.Cenniki TO [pricechecker];
GRANT SELECT ON ModelDanychContainer.JednostkiMiarAsortymentow TO [pricechecker];
GRANT SELECT ON ModelDanychContainer.KodyKreskowe TO [pricechecker];

Subiekt nexo — FAQ

Which database name do I enter for Subiekt nexo?
The name of the company database in SQL Server, usually starting with Nexo_, e.g. Nexo_MyCompany. You can see the list of databases in SQL Server Management Studio.
Where do I get the price list name?
It is the name of a price list in Subiekt nexo. If you enter a wrong one, the connection test lists all price lists in the database — copy one of these names.
Can the price checker show the net price from Subiekt nexo?
No. With Subiekt nexo the app shows the gross price from the chosen price list.
Why is a product in Subiekt nexo but the price checker does not find it?
Most often the product is not in the price list entered in the price checker settings. Add it to that price list or choose a price list that covers the whole range.