Introduction
This guide will explain how you can complete and upload your Product List.
This template contains the product information, allergens, nutrition and product ingredients all in one file.
The price and active information will be loaded via the catalogue.
Assumptions
You have access to the Supplier Portal
Please note, you will need to register to use our new Portal platform. See the Access to the Portal guide for this.
Where to find this
URL: supplierportal.indicater.com
Step by Step Guide
Log into the portal
From the menu bar on the left click on Product List
Click on the download button (highlighted in yellow)
The template will be downloaded to your computer.
Complete the template, then click on Upload Product List, now click on Select Product List File and attach the file, the items will be displayed, click on Confirm.
Below is a guide on how to complete each column:
Column A - Product Description - This is the name of the product. It's helpful to include as much info in the description as this enables the customer to see the detail when using e-Procurement or Recipe Manager. For example, Assorted Cheese Portions (20g) or Uncooked Gammon Steak (220g).
Column B - Item Code - This is your product code for the product. This is used as a unique identifier in the system so should not change or be duplicated. Any changes to item codes should be raised with the customer so that they can communicate this to their users.
Example - If Asparagus Spears, with product code 12345 changes price or pack size, these will automatically update throughout the system. However, if the item code changes from 12345 to X12345 then the new item will appear and the old item will no longer be available to the customer.
Column C - UoM - This is the Unit of Measure. This column is specifically linked to the Recipe Manager module and is how users determine the unit of measure for adding items to their recipes.
Examples:
If a product come in a 200g jar or a pack of 3x200g jars, the unit of measure will be 'g'.
A 1.65kg tub of cream cheese will have a unit of measure of 'KG'
If you are using individual products with no weighted/liquid unit of measure then you can use 'each'.
See a full list of acceptable Units of Measure at the end of this guide.
Column D - Pack Size - This shows how many packs there are in the case and the size of the packs. This is visible to customer when they are placing orders online and stock taking, it is a crucial component when creating recipes.
Examples:
A case of unsalted butter that comes as 40 individual 250g packs would show as 40x250g in this column.
If the case came a 4 boxes, each containing 10 packs of butter (250g) this would show as 4x10x250g.
If you are supplying meat or fish by the KG, you can just enter 1xKG and the users will order as many KG's as they require.
A box of 6 bottlw of olive oil (250ml) would read 6x250ml or 6xeach.
1 individual item would be 1xEach (2xEach if it is 2 items etc.)
Column E & F - Packs per Case and Items per Pack - These columns are crucial for customers to enter accurate stock take figures.
Column E – Packs per case shows the number of packs contained within a ‘case’
Column F - Items per pack is the total number of items in one pack/case ordered.
Examples:
So using the example above of unsalted butter, if the pack size is 40x250g:
Packs per case will show 1
Items per case will show 40
If the pack size was 10x4x250g:
Packs per case will show 4 (as there are 4 packs in the case ordered)
Items per case will show 40 (as there are 40 items in the case in total)
If you are ordering 1 individual item then it will be shown as 1 pack per case and 1
item per case.
Column G & H – Category and Sub Category
These are text fields and allow the user to locate products in categorised folders.
If you have a small number of products and are unable to create a category and a sub category then you can use the supplier name in the category field and then create a sub category in that column.
Some IndiCater clients specify the categories they wish to use. If this is the case then they will provide you with that information before you create your catalogue.
Examples:
Chicken Breast Filllets might be categorised as Meat in the category column and Poultry or Chicken in the sub category column.
Coca Cola Post Mix might be categorised as Soft Drinks in the category column and Post Mix in the sub category column.
Column I - Split Casing - This column provides the option to show if an item is available to order either by case or individually. If the customer is able to order a box of 6 bottles of wine but can also order the bottles individually the enter 1. If they can only order by the case enter 0. Note, the split option only applies if the unit price value is calculated exactly by dividing by the case value by the number of items in that case.
Column J to AL - Allergen Information - Each cell must be populated with either Y, N, M or N/A depending on the criteria of the product.
Key:
Y = Yes, this allergen is present in this product
N = No, this allergen is not present in this product
M = Maybe, this allergen may be present in this product
N/A = There is no allergen information for this product
Only use the letters, not the words.
Column AM to AT - Nutritional Information The figures should be entered as grams per 100g of the product. These cells should only contain numbers, no letters or special characters. You do not have to submit data for all the items you supply but if a customer has requested the nutritional data for the products they purchase these cells must be populated.
Column AU - Ingredients - Add all the ingredients contained in the item. You do not have to submit data for all the items you supply and you can leave fields blank, but if a customer has requested ingredients for the products they purchase these cells must be populated.
Column AV - Graphic String - This is optional and allows the customer to see a picture of a product when they are placing orders. You will need to add the image as a url into the column.
Column AW - Barcode - This is optional and allows the customer to see the barcode of a product. Enter the number of the barcode into the column.
Recognised UoM's: