Data Interface Depiction: Product Data Update With Excel Sheet
You can import product data into the JAMIX Kitchen Intelligence System using MS Excel documents (also in CSV format).
- Data must be in the first sheet and empty sheets are not allowed.
- Header information can be in any row and it is mandatory.
- Row data must begin from the next row after the header information. Row data must not contain headers or empty rows between the rows.
- Decimal separator for price and quantity fields is a dot.
- Cell format is numeric for price and quantity fields, and date for date field.
* =Mandatory
Header information
| Field | Column | Description | |
| Supplier | * | A | Supplier name |
| Customer number | B | Receiver's customer number | |
| Date | * | C | DD.MM.YYYY |
Row data
| Field | Column | Description | |
| Price type | * | A | 0= Current price, 1= Contract price. |
| EAN code | * | B | If there’s no EAN code, fill in 14 zeros and give a product code. |
| Product code | C | Always give the product code if there is one | |
| Name | * | D | Product name |
| Sales batch | * | E | Number of items in a sales batch |
| Pack unit of measure | * | F | UOM of pack, e.g. CTN |
| Contains | * | G | UOMs contained in a pack |
| Basic unit | * | H | Always lbs/kg in food items, other products can have any other unit. If this is the same as the pack UOM, G-column needs to be 1. |
| Net price per item | * | I | Price (for sales batch), without tax* |
| Gross price per item | * | J | Price (for sales batch), with tax* |
| Tax % | * | K | Tax % for the product, e.g. 14%, 24% |
| Producer | L | ||
| Price unit | M | Needs to be filled if the prices are not for sales batch. If filled, this needs to be either the basic unit or the sales unit. | |
| EAN code/Sales batch | N | Use, if you want to inform the EAN code for both the item and the sales batch, and they differ from each other. | |
| Not in use | O | ||
| Name specification | P | Additional information related to the product name | |
| Item quantity (gross) | Q | Item gross weight or size. If you give the gross size here, you have to give the net size in column G. Column G is used for gross and net size if this column is empty. |
If the sale unit's ratio to the basic unit is not precise (for example when using price by lbs/kg in meat
products), you can register the units as follows:
- Sales batch = 1
- Sales unit = lbs/kg
- Contains = 1
- Basic unit = lbs/kg