ALO Solutions -iAlo CSV specs


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