WinShop SQL Logo

WinShop SQL is a business, warehouse and cash register system for medium and large business corporations. It belongs to the WinShop software family of business systems and its typical users are retail outlets ON LINE connected to a central server, department stores or wholesale organizations with a large number of users on a local network and external sales representatives connected via the Internet. The standard POS terminal is a computerised cash register or a touchscreen POS unit with cash register peripherals. Special peripherals to be connected are checkweighers, portable data terminals and barcode scanners, camera systems, payment terminals or PDAs. To expand the company's business activities, the eWinShop online shop can be integrated into the WinShop SQL system. The WinShop SQL system is designed for business organisations operating in the Czechia and Slovak Republics.

WinShop SQL system architecture:

The client-side application works in the cutting-edge Microsoft .NET Framework. The application part is programmed in MS C#. Server processes are in native SQL server environment. The data storage is MS SQL Server 2019. The reporting tool is the modern SAP Crystal reports system.

items
1 000 000+
installations
100+
receipts per month
1 500 000+
individual functionalities

The biggest advantages of WinShop SQL:

The WinShop SQL business, warehouse and cash register system builds on the long tradition of WinShop business, warehouse and cash register systems and takes advantage of all the experience gained to make WinShop SQL a reliable and flexible business, warehouse and cash register system that delivers a wide range of benefits. The solution of the individual modules of the application part of the system together with intuitive operation contributes to the acceleration of individual business processes. By evaluating the turnover of goods, registering minimum warehouse levels and calculating optimum warehouse levels, together with an automated system of supplier orders, it ensures the necessary supply of individual sites. This contributes to the time optimization of inventory acquisition costs and, together with savings in operator time, directly contributes to a rapid return on investment.

  • ON LINE connection of all stations to the central server

  • a permanent overview of the status and movements of inventory at all locations

  • wide selection of promotional and marketing events

  • support for working with suppliers' consignment goods

  • integrated inventory optimization system

  • processing of INTRASTAT and EKOKOM records and support for EDI communication

  • automatic printing of labels and price tags, support for electronic price tags

  • integration of the SAP Crystal Reports reporting tool with the possibility to export in XLS, TXT, HTML, PDF and Chart formats

  • cash register sales with integrated WR system eliminating sales outages when the connection to the central server is lost

  • support for customer and loyalty systems

  • complete support for barcodes, QR codes and RFID identification

  • flexible inventory system

  • automated ordering systems

  • generator and printer of custom barcodes and QR codes

  • generator of press outputs and statistical reports

Are you interested in WinShop SQL?

Contact us
  • Exact specification of goods

    Using additional data such as colour, dimension, size, length, model, season - (fashion and sports) or production and serial numbers - (electronics), weight, weight and commercial barcodes - (food, drugstore) or material, dimensional standards and warehouse location - (hardware, logistics warehouses). The extended stock item specification capabilities make it easy to track the movement of individual products from order to supplier, through purchase and inter-warehouse predispositions to sale to customer, including quick availability of all information for complaint resolving purposes.

    winshop-sql.jpg

  • Immediate availability of information

    The WinShop SQL business, warehouse and cash register system provides sales organizations with instant availability of information from all locations and central warehouses thanks to the ON LINE availability of the SQL server data. The timeliness of the required data is ensured by the original SQL interpretation of data requests, which guarantees the speed of the application even with slow internet connections (256 kbs and below). For POS terminals, a unique WR (WinShop replications) system is integrated, thanks to which the risk of interrupted sales in case of connection failure with the central server is completely eliminated.

    Win_Shop_SQL_2.webp

  • Modern multifunctional POS terminal

    The WinShop SQL Retail checkout application offers a range of functionality to support retail sales. The intuitive interface of basic checkout operations is complemented by a customer card system with customer information (total sales, last purchase by item, favourite items, holidays, birthdays, etc..), product information (instructions for use, certifications and approvals or composition) to the ON LINE search function for goods at other stores. WinShop SQL Retail supports direct communication with payment terminals and MOBITO payment. Of course there is a statistical module for store managers, a shift planner for staff and an Attendance module.

    WinShop_SQL_pokladna.png

  • Clear statistical and managerial outputs

    For the creation of statistical outputs, the WinShop SQL business, warehouse and cash register system has integrated the modern reporting tool SAP Crystal reports, which enables the creation of clear reports supplemented by many types of graphs. Each report can be exported to MS Excel, MS Word, HTML, PDF, RTF and other formats. Creation of individual outputs is ensured by the report generator or the possibility of ordering individual CR reports.

    WinShop_SQL_statistika.png

  • WinShop Dashboard

    Dashboard is a management information tool that allows you to visually monitor and analyze key performance indicators of the company. It can be customized to meet the specific needs of individual departments. Real-time monitoring reduces the hours of analysis that used to be a major challenge for businesses. Changes in any aspect of the business, be it marketing, sales, customer support or finance, impact the business as a whole. Dashboards allow users to gain a more detailed insight into the workings of the business. A dashboard allows all data to be tracked in one central location. The biggest benefit of a properly designed dashboard is the efficiency and speed you can use to make business decisions. Dashboards can be set on the Winshop SQL homepage according to the client's wishes. Another option for displaying dashboards is the mobile application WS Dashboard, or individual statistics can be sent by e-mail.

    Dashboard.png

  • WinShop PDA

    The WinShop PDA application is designed to process supplier receipts, process and dispatch customer orders, predisposition of items between stores, inventory or query the location of an item and the current stock of items in the warehouse. The application makes it easy for the operator to work with bulk data collection and processing. It uses an integrated barcode scanner to identify stock items during data collection. A clear menu is available to select the type of processing of the retrieved items. The WinShop PDA application is mainly used on mobile portable terminals with Windows MOBILE or Android operating system. The terminals are designed to be drop and wear resistant and are equipped with a high-capacity battery. The device connects to WinShop databases ON LINE via WIFI network or OFF LINE via USB interface. The WinShop PDA application can be used in conjunction with a mobile barcode printer to print merchandise labels, shelf labels or price tags for promotional items.


Modules

Back Office - analysis and statistics

  • Analysis and statistics module

  • Press kits

  • Contingency tables

  • XLS exports

  • Power BI exports

Back Office - pricing

  • Price levels

  • Subscriber price lists

  • Individual price lists

  • Price exceptions

  • Promotions itemized

  • Financial Promotions

  • Electronic price tags

Back Office - company and employee dials

  • Customer discount system

  • Records of companies

  • Employee records

  • Attendance

  • Shift planning

Back Office - additional modules

  • Intrastat

  • Ekokom

  • SSCC codes

  • EDI communication

  • GDPR

  • Connecting the camera system

  • Connecting weighing systems

  • Welmec

Back Office - finance

  • Customer and supplier Saldokonta

  • Tracking reimbursements

  • Homebanking

  • Financial cash registers

Back Office - buy/sell

  • Invoices received

  • Sale of goods and services

  • Invoices issued

Back Office - orders

  • Supplier orders

  • B2B orders

  • B2C orders

  • Orders of own establishments

Back Office - complaint

  • Supplier Claims

  • Customer complaints

Back Office - warehouse

  • Catalogue of goods and services

  • EAN and QR code generator

  • Warehouses

  • Warehouse positions

  • Inventory optimization

  • Inventory of stocks

  • Records of consignment stocks

  • Records of production numbers

  • Receipt of goods and services

  • Transfer of goods between warehouses

  • Reservation of goods

Back Office - production

  • Meat production management

  • Recipes

  • Calculation of raw materials

  • Demolition

  • Batch records

  • Production planning

WinShop PDA - possible functionalities

  • Creation of supplier orders

  • Supplier order fulfilment

  • B2B order creation

  • B2B order fulfillment

  • B2C order creation

  • B2C Order Fulfillment

  • Inventory

  • Expeditions

  • WMS position stacking function

  • WMS expiry management function

  • PDT tray

  • Price and availability check

Front Office - sale

  • Printing of price tags

  • Checkout terminal

  • Promotions itemized

  • Financial Promotions

  • Sale of goods and services

  • Sale of consignment goods

  • Sale of products according to recipes

  • Sale of vouchers

  • Search for goods by EAN

  • Search for goods by name

  • Search for goods by code

  • Search for goods by supplier

  • Search for goods by price

  • Search for goods by serial number

  • Manual discount system

  • Billing

  • Price inquiry

  • Purchase of packaging

  • Statistics and analysis

  • Customer complaints

Front Office - additional modules

  • Sale SAZKA

  • Topping up credit vouchers

  • Connection to TAXFREE systems

  • Connection to checkweighers

  • Remittance system

  • Financial Treasury

  • Attendance records

  • Shift scheduling

  • Monitoring the achievement of business objectives

  • Customer display with multimedia

Front Office - warehouse operations

  • Creation of delivery notes

  • Creating transfers between warehouses

  • Formation of depreciation

  • Creation of inventories

  • B2C order processing

  • Dispensing point for B2C orders

Front Office - payment system

  • Combined payment methods

  • Cash

  • Card

  • Voucher

  • Rechargeable vouchers

  • Foreign currencies

  • Meals

  • Connection to deposit machines

  • Connection to card terminals

  • Payment of invoices issued

Front Office - customer system

  • Customer records

  • Customer discount system