chrispeng [ad_1]
1. System development background
With the transformation of business operations from extensive to intensive, in terms of sales channel management, due to the limitations of technology and means, most companies still use the traditional models and management methods at the initial stage of operation. These methods are effective in terms of efficiency, cost, and availability. Disadvantages in terms of controllability have become increasingly prominent. Therefore, the changes in the market environment have put forward new requirements for the channel management methods of enterprises.
The Dorje sales channel management system can help companies to implement strict supervision and control of the orderly flow of key products in the distribution network by tracking the products from the warehouse to the distributors, improve the company’s channel management level, reduce and evade Channel risk. The system uses bar code technology to accurately and confidentially identify the products. Through the commodity inspection function of foreign branches, it can effectively prevent cross-regional sales and cross-sales of products and prevent the impact of counterfeit and shoddy products.
2. Introduction
1. System structure
The system topology is shown in the figure above. The main equipment includes data servers, warehouse management PCs, handheld data collectors and other equipment. With the help of the network, the collection and query of product barcode information is realized, and the market circulation of products is monitored. The equipment selection and performance requirements are recommended as follows:
Database server: P4/1G/40G (Linux operating system)
Client PC: P3/128M/20G
Data collector: PT-850(GRPS)/MC70(Symbol)
3. System software platform product selection:
Considering generality and practicability, the server operating system is Windows 2000 Server, and the client PC is Windows 2000/98/XP. The system adopts the B/S mode, the database uses Microsoft SQL Server 2000, and the Web Server is Microsoft IIS. The handheld terminal operating system is uBase-III, which uses C language to develop applications. The structure is shown in the figure:
Four, functional modules
System applications include Windows-based applications and uBase-III-based handheld applications, both of which can be connected in real time via the Internet. Use the function as shown in the figure:
Five, function description
(1) Web application service based on B/S mode
1. Product inquiry
Enter the date, select the market (area), and the system will query the product flow based on the current market inspection data (scanned product barcode), and display the circulation record of each product, including branch offices, warehouses, and distributors.
Such as: barcode 1234567:
2. System maintenance
(1) Code maintenance: Provide interfaces to obtain branch company, warehouse code, and dealer code from other systems.
(2) Operator maintenance: set the operator and password.
(3) Data organization: backup current data. Back up the expired data and delete it from the current system.
3. Data import: This function provides data uploading and importing to the library service for collectors without GPRS function. Import the collected data into the PC through the serial port, execute this function on the PC, and the data enters the database.
(2) Palm application
1. Inbound and outbound operations
(1). Storage
Enter the source unit code on the handheld collector, such as other warehouse codes or dealer codes, scan the barcode of each product, and save the data after completion and upload it automatically, prompting the user to operate successfully.
(2). Delivery
Enter the code of the required unit on the handheld collector, such as other warehouse codes or dealer codes, scan the barcode of each product, and save the data after completion and upload it automatically.
2. Branch inspection
The market patrol staff of the branch company use the handheld collector to scan the barcode of the product to be checked at the supermarket, distributor, and customer. After the completion, the data is saved and automatically uploaded. The system prompts whether the transmission is successful.
3. Head office inspection
Managers of the head office use handheld collectors to scan barcodes of products that need to be checked in supermarkets, distributors, and customers. The system connects to the headquarters database via GPRS to query the circulation process of the product and display it on the collector for managers to real-time Determine whether the product is sold across regions and whether it is counterfeit.
4. System Settings
(1) Operator settings
Set the work number of the current user.
(2)Using unit setting
Set the unit of use of this collector.
(3) Code table download
Connect to the headquarters via GPRS to complete the download and data synchronization of the warehouse code and dealer code in this area.
[ad_2]
