Fuga provides a generic supplier delivery file format that can be used to import information for delivered products in Fuga. The format is described below.
- The first row must be a header row with the column names
- The character encoding must be utf-8,
- All values must be between double quote characters (") and separated by a comma (,).
- A new line is started with the crlf
Field Name | Purpose | Mandatory | Fuga Concept | Fuga Field | Remarks | Technical |
Supplier | Who is the supplier of the goods | Y | Lot | Lot Supplier | Must be a supplier in fuga. Matches to the name of the supplier. | String (30) |
Order Date | Date on which the order was made | N | Lot | Lot Order date | Date in dd/mm/yyyy | |
Order Number | Reference of the order | N | Lot | Lot Number | String (30) | |
Product Name | Name of the product | Y | Product | Product Name | The product name is used to identify the product in Fuga if no CNK code is present. | String (30) |
Product Number | Supplier product id | N | Lot | Lot Product Number | ||
CNK Number | Identifies the product via the CNK code | N | Product | Product CNK Number | Must be a valid Belgian CNK number. Supplier specific numbers should be in product number. If present, the CNK code is used to identify the product | xxxxxxx 7 digits. |
EAN Number | Ean code of the product | N | Product | Product EAN code | Is not used to identify the product, just informational and for barcode scanning. | 13 digits |
Delivery Number | The delivery reference | N | Lot | Lot Delivery Number | This field is used to identify whether this delivery is already present in Fuga. The combination delivery number, when available, and the product needs to be unique | String (30) |
Number of Products | Amount of products in the delivery | Y | Lot | Initial Number of Products | Integer | |
Lot Number | The Lot Number | Y | Lot | Number | Identification of the lot of the product | String (30) |
Purchase Price | The purchase price, in Euro, for a single product in the lot excluding VAT. The purchase price is the actual price after discounts. | N | Lot | Purchase price | Can be used to calculate sale price and stock value | Decimal with max 2 digits precision and dot as separator. It is not mandatory to have the decimal part. |
Gross Price | The price, excl VAT, as listed in the suppliers catalogue, prior to discounts. This is higher or equal to the Purchase Price | N | Decimal with max 2 digits precision and dot as separator. It is not mandatory to have the decimal part. | |||
Public Price | The intended sales price to the public, including VAT. | N | Decimal with max 2 digits precision and dot as separator. It is not mandatory to have the decimal part. | |||
VAT Rate | The VAT rate when this product is purchased. | Y | Product | Purchase VAT tariff | Decimal with max 2 digits precision and dot as separator. It is not mandatory to have the decimal part. | |
Expiry Date | When will the product expire and should no longer be used. | N | Lot | Date Expired | Date in dd/mm/yyyy | |
Barcode | A barcode, other than the EAN code, that might have been foreseen by the supplier | N | Lot | Explicit Barcode | Can be used to identify the Lot by scanning | String (30) |