How do I configure my labels in Andy using an Excel document?

At Andy, we always strive to provide the most satisfactory user experience.

In this case, to make the configuration of your labelling with Andy as simple as possible, we have created an Excel document that you can fill out with the information of the products that you intend to label. Once completed, please send it to help@andyapp.io and our team will configure it correctly for you.

Here is the downloadable Excel file Expiry List

This Excel file includes:

Product: The name of the food to be labelled.

Category: Assign categories and group products by categories.

Status: It indicates whether the product has undergone any modification or process and it requires labelling.

Thawing Time: The time it takes for a food item to thaw before it can be used. This field is optional.

Secondary Expiry Date: The date when the original packaging underwent a modification (such as opening, breaking, preservation), and a new expiry or “best before” date needs to be established.

Primary Expiry Date: It indicates the date until which the food can be safely consumed an the food stops retaining its properties. It’s the "Best before..." date followed by the day/month/year or "Best before the end of..." followed by the month/year or just the year.

Lot: This item indicates a set of products of the same type, processed by the same manufacturer, within a specified period of time under essentially identical conditions. This number ensures knowledge and identification of the procedure, history, and background of each product from its origin to its final destination.

Storage Method: Techniques and practices used to preserve the quality, freshness, and safety of food products over time. Examples include Refrigeration (0 to 4°C), Freezing (<-18°C), Dry storage/pantry.

If you need to label prepared products, please fill up the sheet Expiries + Ingredients

This second sheet contains the same information plus:

List of Ingredients: It includes the ingredients of a processed product, with the allergenic ingredient highlighted in bold.

List of Allergens: The allergens contained in the processed product, indicated in bold and underlined.

We also recommend configuring your labelling directly in Andy. This article will help you: How do I configure food labels with Andy.

Ready!

You might now be interested in finding out more about the Different label designs available for printing with Andy

Related Articles
How to configure food labels with Andy
Your first step to printing food labels with Andy is creating the product’s status. Go to Settings > Products > Status and click on Create Status. Enter a Name for the status and set the Priority (the order in which it will appear in the Andy App). ...
Printing Food Labels with Andy
1. In the Main Menu, click on the Labels item. If you see this message on your screen: "The printer is not yet configured," follow the steps in the following articles according to the type of device you are using: Setting up your printer on an ...
What can I find in Andy's Food Safety Training folder?
Andy's Library includes helpful basic Food Safety training videos that will make your team's daily tasks a lot easier. To view them, simply access Andy's Control Panel and click on Settings > Tools> and enable the Library > Show Food Safety Training ...
How does Andy calculate the times on the labels?
To unravel the mystery of how Andy calculates the times on the labels you're about to print, let's begin by differentiating the two types of "times" currently available on the app: Expiry and Thawing. Expiry time This refers to the secondary ...
How to download your expiry list from Andy
Andy allows you to get your product expiry date list with a single click! Simply go to your Control Panel > Settings > Labelling > Products: You can use the filters on the left side menu to filter the products and download only those that interest ...