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(INSERTNEXOis 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
- Open the settings, Source tab.
- Choose Subiekt Nexo 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\INSERTNEXO |
| User / Password | The read-only SQL login. | pricechecker |
| Database | The company database name. | Nexo_MyCompany |
| Encrypt connection (SSL) | Leave checked. | ✓ |
| Price list name | The price list the price comes from. | name from Subiekt nexo |
| Search by product code (SKU) | Search by product symbol. | ✓ |
| Search by EAN code | Search by barcodes. | ✓ |
- 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.
- Save the settings and scan a few products.
Price and search
- 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.