Home > Item Management > Importing Data > How Do I...? > Import Sales?

How Do I Import Sales?

If you would like to import Sales information from an external system, this is possible via the Import Sales function. The information needs to be in a comma delimited file, and contain the below mentioned fields. However, not all fields are mandatory. In order to be able to process a sale, we must assign the sale an Item. To identify the item number in POS BE, the sales file must contain either the IPN, the EAN, ORDERCODE or XREFCODE. It does not need all four pieces of information. An example of a valid file would be:

EAN,VALUE,QTY,DATE

45767676764444,1.50,23,20070226

Field

Description

Mandatory

IPN

The item number. This needs to be the IPN assigned to the item in POS BE.

No

EAN

The item barcode.

No

ORDERCODE or ORDER CODE

The item order code.

No

VALUE

The value of the sale. This will be multiplied by the quantity to give the total of the sale transaction.

Yes

QTY

The amount sold. This value will be used to multiple the VALUE of the sale to give a total of the sale transaction.

Yes

DATE

The date assigned to the sale. This needs to be in the format YYYYMMDD. If you have a file with multiple dates, then a separate sale transaction will be created for each record with a different date.

Yes

G2000ORDERCODE

Only used by G2000.

No

XREFCODE

Cross reference code used to lookup the item.

No

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)