WAPRO Mag
The price checker reads items and prices directly from the WAPRO Mag database in SQL Server. It shows the item name and the gross price of the chosen price (e.g. retail).
Before you start
- The price checker and the WAPRO 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 SQL server and instance name shown when logging in to WAPRO Mag, in the form
COMPUTER\INSTANCE. On the price checker, enter the IP address instead of the computer name, e.g.192.168.1.10\WAPRO. - Database — the name of the company database you choose when logging in to the program. You can also see the list of databases in SQL Server Management Studio.
- Price list name — the name of an item price in WAPRO Mag (e.g. retail). If you are not sure of the exact name, type anything and run the connection test — the message lists the price names in the database.
Step-by-step setup
- Open the settings, Source tab.
- Choose Wapro Mag 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\WAPRO |
| User / Password | The read-only SQL login. | pricechecker |
| Database | The company database name. | MyCompany |
| Encrypt connection (SSL) | Leave checked. | ✓ |
| Price list name | The price name from WAPRO Mag. | name from WAPRO Mag |
| Search by product code (SKU) | Search by trade index. | ✓ |
| Search by EAN code | Search by the item barcode. | ✓ |
- Press Connection test. The app checks that the given price exists — on error you will see There is no price list “…”. Available: … with the list of names.
- Save the settings and scan a few items.
Price and search
- The screen shows the gross price of the chosen price. The net price cannot be selected for WAPRO Mag.
- An item without the chosen price gives Product not found.
- Search by EAN code compares the scanned code with the barcode stored on the item.
- Search by product code (SKU) compares the scanned code with the item's trade index (indeks handlowy).
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.ARTYKUL TO [pricechecker];
GRANT SELECT ON dbo.CENA_ARTYKULU TO [pricechecker];
GRANT SELECT ON dbo.CENA TO [pricechecker];
WAPRO Mag — FAQ
What do I enter in the Price list name field for WAPRO Mag?
The name of the WAPRO Mag item price the price checker should use, e.g. the retail price. If the name does not match, the connection test lists all price names in the database.
What does the price checker search by in WAPRO Mag?
By the item barcode and by the trade index — depending on which of the Search by EAN code and Search by product code (SKU) switches are on.
Which permissions does the price checker login need in WAPRO Mag?
Only SELECT on the ARTYKUL, CENA_ARTYKULU and CENA tables in the company database.