» 6. Admin site » b) Management of Customers
- Price Lists
Pages for inserting price information about the products from .xls file. There must be
an information about products' part or manufacturer number or both witch to be
corresponding to products in the database. If there is no information about date and
currency of prices, the data from the begining of the page will be used. Paste .xls
data in the textarea of the page [screen] and click “Analyze”.
The information will be analyzed and labels for columns will be offer [screen]. Change
labels if necessary and click “Check”.
The system will search the database for products with part and manufacturer numbers according to
the pasted data and choosen labels. If there is such product the first checkbox will be checked.
If there is an information about price, the second checkbox will be checked. In the database
will be inserted information only for products with two checked checkboxes [screen].
Click “Prepare” to prepare information for inserting: prices and currency [screen].
Click “Insert” to insert the data - list of products with inserted data will be displayed [screen].
There is а legend on the pages.