Skip to main content

Small Business

With Small Business the price checker does not connect to a database. It reads an EDI file with the product list that the program saves in a shared Windows folder (SMB). The app loads the whole file into memory when it starts and reloads it every set number of minutes.

Before you start​

  1. Set Small Business to save the product list as an EDI file in a folder on a computer in the store network.
  2. Share this folder on the Windows network (folder properties → sharing).
  3. Prepare a Windows account that has read-only access to this folder. Do not enter an administrator account on the price checker.
  4. Note the IP address of the computer with the folder — an IP is more reliable than the computer name.

Step-by-step setup​

  1. Open the settings, Source tab.
  2. Choose Small Business from the list.
  3. Fill in the fields:
FieldWhat to enterDefault / example
Address to file EDIThe full path to the file starting with smb://: computer, share, path and file name.smb://192.168.1.10/share/products.txt
UserA Windows account with read access to the share.pricechecker
PasswordThe account's password.
DomainThe account's domain or workgroup. For a computer outside a domain, keep the default.WORKGROUP
Price typeWhich price from the file is shown.CenaSprzedazyBrutto
Update frequency (min)How often, in minutes, the file is reloaded. 0 = only when the app starts.30
  1. Press Check file — the app reads the file and shows how many products it found (messages below).
  2. Save the settings and scan a few products.

Four price types are available: CenaSprzedazyNetto, CenaSprzedazyNetto2, CenaSprzedazyBrutto, CenaSprzedazyBrutto2 (net and gross sales prices). In a store, customers are usually shown a gross price.

How the app reads the file​

  • The file is plain text in Windows-1250 encoding (Polish characters).
  • Every product starts with a header [Poz1], [Poz2] and so on. The app takes the Symbol=, Nazwa= (name) lines and the line of the selected price type, e.g. CenaSprzedazyBrutto=12,99.
  • Products are looked up only by the Symbol field, case-sensitively. For the customer to scan the barcode on the package, the product symbol in Small Business must be equal to that code (e.g. the EAN).
  • A product without the selected price type in the file shows a price of 0.00 — choose a price type that all products have.
  • Below the price the app shows the scanned code (Code …), because the file has no separate EAN field.

File excerpt:

[Poz1]
Symbol=5901234567890
Nazwa=Kawa ziarnista 1 kg
CenaSprzedazyNetto=48,77
CenaSprzedazyBrutto=59,99

Price changes in Small Business appear on the price checker only after the file is reloaded — at most after the set number of minutes. If the file is temporarily unavailable during a reload, the price checker keeps showing the prices from the last loaded file. If the file cannot be read when the app starts, No connection to the data source appears.

Check file button messages​

MessageWhat to do
The address must start with smb://, e.g. smb://192.168.1.10/share/products.txtFix the address — start with smb:// and use forward slashes /, not \.
File … not found.Check the share name, the path and the file name.
The address points to a folder, not a file. Files in the folder:Add the file name from the displayed list at the end of the address.
File found: …, Read N products.Everything works.
The file was read, but it contains no products.The file has a different structure than expected or is empty — check the export in Small Business.
The file was read, but no product has the price …Choose another price type.
Wrong user name, password or share domain.Fix the login details; for a local account check the Domain field.
The user has no access to this file or share.Give the account read access to the share and the folder.
Cannot connect to computer …The computer is off, has a different address, or a firewall blocks file sharing.
Could not read the file.Another error — the details are below the message; pass them on to the service team.

Small Business — FAQ

How does the price checker get prices from Small Business?
It reads the EDI file with the product list that Small Business saves in a shared Windows folder. The file is loaded when the app starts and reloaded every set number of minutes, every 30 by default.
How do I enter the EDI file address?
As an smb address with forward slashes, e.g. smb://192.168.1.10/share/products.txt — the computer's IP address, the shared folder name, the path and the file name.
Why doesn't the price checker find a product by its EAN code from Small Business?
With Small Business the app searches only by the Symbol field in the file, case-sensitively. The product symbol must be equal to the barcode the customer scans.
How soon does a price change in Small Business appear on the price checker?
After the next file reload, i.e. at most after the number of minutes set in the Update frequency field. Restarting the app loads the file immediately.