Page Comparison

The template is There are 2 templates attached at the bottom of the page:

1- Nutrition File with Examples this is to guide you on how to complete the template and should not be used for uploading your data, it contains a few examples. These examples need to be deleted before the file is submitted to IndiCater to be loaded into the database.When suppliers fill this in, the following guidelines must be followedas it is an xlsx file format.

2- Nutrition Upload Template this is for you to complete with your data and send to IndiCater to upload in csv format, by raising a support ticket.

 These guidelines must be followed when completing the template:

• Only submit a product once please (all clients access the same nutrition values, these are not loaded for each client separately)
• The first 4 columns and 2 columns towards the end are highlighted in grey and should be ignored, they are for IndiCater to fill in: NutritionID, NutritionSupplierID, ClientID (can be 0), GroupSupplierID (can be 0), GroupStockItemID (blank), Archived (blank):

Image Removed

Image Removed

• figures should be entered as grams per 100g of the product.

• The compulsory/mandatory columns are: ProductCode, Description, Salt (the Salt value can be 0.00 but it can't be blank).The following columns only accept 4 decimals: Alcohol, Carbohydrates, EnergykCal, EnergykJ, Fat, Fibre, Protein, SaturatedFat, Sodium, Sugar, Salt
• The other columns with numeric values accept 8 decimalsThe rest of the columns are optional, fields can be left blank. The most frequently used columns have a value in all 10 example lines.
• The example file is saved as an excel spreadsheet so that the column colours are preserved (as a help) but IndiCater can only upload files in a CSV format. If the supplier is unable to save the file as CSV, IndiCater can do it as long as there is only one sheet in the file.
• The following columns can contain both letters and numbers: ProductCode, Description, DepartmentName, SubDepartmentName
• All the other columns can only contain numbers (no letters, not even approx, N/A, Trace, no < or > signs) etc.
• Please be mindful not to insert extra spaces in any of the fields as this will corrupt the upload.
• Please don't use commas (= thousand separators) in values higher than 1000 or as a decimal separator (so 12.5 is correct, 12,5 is incorrect). Only use decimal points (if you need to):

Image Modified

The Template can be downloaded by right clicking Click on the link below and selecting Save link as / Open link in new tab:Nutrition Template with examples.xlsxthen click the down arrow as shown in screenshot, to download the example file or template.

1.Nutrition File with Examples.xlsx

2.Nutrition Upload Template .csv

Image Added

NOTE: If auto mapping of a product to FSA data has been completed any nutrition uploaded will update the products data.