<< Click to Display Table of Contents >> Navigation:  Regla Getting started > Administration > File administration > Import files > File appearance and type > File appearance > Products

The product list needs to have the following field in this order:

1.Product no.

2.Product name

3.Product group

4.Supplier,

5.Price without vat (zero if not applicable)

6.Wholesale price without vat (zero if not applicable)

7.Cost price (zero if not applicable)

8.VAT

9.Allow discount (0=no/1=yes)

10.Max discount

11.Short description

12.Long description

13.Allow price overwrite (0=no/1=yes)

14.Product is in stock control (0=no/1=yes)

 

The system allows the first line of the file to contain column titles if the corresponding checkbox is checked.

 

All data that is imported to the system will go through the same error checking process as when data is entered manually into the system. Thus the same rules mentioned will be applied for all the fields.

 

Product number has to be unique and can include both digits and letters.

 

Product is the name of the product.

 

Product group is the name of the product group. If it doesn’t exist in the system, then it is created.

 

Supplier refers to a customer ID. It can be empty.

 

Companies in Regla can be defined as retail, wholesale or both and therefore a product can have both retail and wholesale price. If a product does not have either price, the field should be a zero.

 

Cost price, if used the system shows total cost price for sold products in all queries in the Sale system. If not used the field should be zero.

 

The Vat needs to be a valid number according to the system.  A list of valid vat values is given here.

 

Examples of product lines:

 

4500;Paper A4;100;1601542179;500;300;100;24,0;1;10;1;1

 4501;Paper A3;200;1601542179;600;400;200;24,0;1;15;0;0