4.2 CSV FILE GUIDANCE
Csv file instruction:if the row starts with'#', it is note row, will be ignored, no need to input field.
•
product.csv–product list
1
Shop ID
2
Branch ID
3
POS No
4
Product number
5
Taste/Flavor
6
Barcode/Product Code
7
Barcode_format/Label format number
8
Product_name
9
Abbr/ Product name abb.
10
Category
11
Department
12
Pcs_flag
13
Default_pcs
14
Unit_text
15
Tare_number
16
Tare
17
P_tare_unit
18
Stock
19
Stock_low
20)
Stock_top
21
FCL_ratio
22
Score_type
23
Score_ratio
24
Exchange_score
25
Price_low
26
Price
27
Price_ vip1
28
Price_vip2
29
Price_vip3
30
Group_qty
31
Group_price
32
Price unit
33
Change prices
34
Discount
124
id of the shop the product will be applied to.
id of the branch the product will be applied to.
scale number
arrange in product number order, automatically generate
6-digit product number
reserved function
product barcode
barcode format
product name
product name in abbreviation
product category; display as serial number in chart
product department; display as serial number in chart
sell goods by quantity; (0:No, 1:Yes) input o or 1
reserved function;default: 0
reserved function
reserved function;default: 0
input pre-tare vaule
Unit for the pretared value
reserved function;default: 0
reserved function;default: 0
reserved function;default: 0
reserved function;default: 0
reserved function;default: 0
reserved function;default: 0
reserved function;default: 0
reserved function;default: 0
product unit price
reserved function;default: 0
reserved function;default: 0
reserved function;default: 0
reserved function;default: 0
reserved function;default: 0
(0:kg, 1:100g) input 0 or 1
reserved function;default: 0
reserved function;default: 0
USER'S GUIDE S75
EN
EN