Items
Field |
Description |
Kind and length |
MODEL |
Item name |
String 25 |
BARCODE |
Barcode |
String 25 |
LCID |
Language ID (default 1040) |
Integer |
DESCRIPTION |
Item description |
String 50 |
DESCRIPTION_SPEC |
Metal and fineness (i.e. AU 750) |
String 50 |
SPEC_01 |
Weight (i.e. “g. 10,78”) |
String 50 |
SPEC_02 |
Size Unit (i.e.. “Cm 8”) |
String 50 |
SPEC_03 |
Price 1 (i.e. “€ 10,45”) |
String 50 |
SPEC_04 |
Price 2 (i.e. “€ 10,45”) |
String 50 |
SPEC_05 |
Price 3 (i.e. “€ 10,45”) |
String 50 |
DESCRIPTION_MASK |
Empty |
String 50 |
MM_WIDTH |
0 |
Integer |
MM_HEIGHT |
0 |
Integer |
FILE_PATH_IMAGE |
Relative image path |
String 255 |
DESCRIPTION_FAMILY |
Family Desc |
String 50 |
DESCRIPTION_GROUP |
Group Desc |
String 50 |
DESCRIPTION_SUBGROUP |
Subgroup Desc |
String 50 |
SPEC_06 |
Color |
String 2 |
SPEC_07 |
Empty |
String 50 |
NOTE |
Note |
String 2048 |
TAG |
Tags |
String 255 |
CALO_1 |
Loss 1 |
String 50 |
CALO_2 |
Loss 2 |
String 50 |
CALO_3 |
Loss 3 |
String 50 |
UCM_1 |
Sale unit 1 “P” or “g” |
String 50 |
UCM_2 |
Sale unit 2 “P” or “g” |
String 50 |
UCM_3 |
Sale unit 3 “P” or “g” |
String 50 |
COSTO |
Cost (i.e. “€ 10,45”) |
String 50 |
UCM_C |
Cost unit “P” or “g” |
String 50 |
ITEMSORT |
Sort criteria |
String 16 |
Example:
"MODEL","BARCODE","LCID","DESCRIPTION","DESCRIPTION_SPEC","SPEC_01","SPEC_02","SPEC_03","SPEC_04","SPEC_05","DESCRIPTION_MASK","MM_WIDTH","MM_HEIGHT","FILE_PATH_IMAGE","DESCRIPTION_FAMILY","DESCRIPTION_GROUP","DESCRIPTION_SUBGROUP","SPEC_06","SPEC_07","NOTE","TAG","CALO_1","CALO_2","CALO_3","UCM_1","UCM_2","UCM_3","COSTO","UCM_C","ITEMSORT"
"030AC 2870000","306225","1040","306225 col. 04","AU 0750","g. 2","cm 7","€ 3,3","€ 5,5","€ 157","","0","0","AC 28700000300107500407.jpg","CLASSIC JEWELLERY","Fedine Brillanti Promesse","Gelsomino","","","","","5","6,25","0","GM","GM","UC","0","","AC 2870000030"
"030AC 2870000","306198","1040","306198 col. 03","AU 0750","g. 2","cm 7","€ 3","€ 5","€ 157","","0","0","AC 28700000300107500307.jpg","CLASSIC JEWELLERY","Fedine Brillanti Promesse","Gelsomino","","","","","5","6,25","0","GM","GM","UC","0","","AC 2870000030"
"030AC 2870010","306277","1040","306277 col. 04","AU 0750","g. 2","cm 7","€ 5,3","€ 9,5","€ 173","","0","0","AC 28700100300107500407.jpg","CLASSIC JEWELLERY","Fedine Brillanti Promesse","Gelsomino","","","","","5","6,25","0","GM","GM","UC","0","","AC 2870010030"
"030AC 2870010","306250","1040","306250 col. 03","AU 0750","g. 2","cm 7","€ 5","€ 9","€ 173","","0","0","AC 28700100300107500307.jpg","CLASSIC JEWELLERY","Fedine Brillanti Promesse","Gelsomino","","","","","5","6,25","0","GM","GM","UC","0","","AC 2870010030"
Variants
Field |
Descriotion |
Tipo e lunghezza |
ID_PROGRESSIVO |
Progressive |
Integer |
ANT_ART_VARIANTI |
Variant ID |
String 50 |
VALORE |
Size |
String 50 |
DESCRIZIONE |
Description |
String 50 |
PESO |
Weight (i.e. “g. 2,34”) |
String 50 |
RIF_CODICE_BARRE |
Barcode Reference |
Integer |
CODICE_BARRE |
Barcode 2 |
Integer |