Dietary Export / Import

The dietary export and import function allows a filtered selection of products to be exported to a spreadsheet, where dietary information can be added or updated. The completed file can then be imported back into the system, enabling efficient bulk updates to dietary data.

Step 1 of 4

Applying Filters

Follow these steps to set filters before exporting dietary information:

1. Select the required Item Type

2. Select the required Dietary Type

3. Select the required filters from the product structure and other filters

   

   As least one level must be selected from the product structure filters to be able to download a dietary information sheet

   Product Structure Filter Tips

   When filtering for parts of the product structure you can:

   • Use the product structure to select 1 or more parts of the hierarchy

     • Click into a drop down and either type to search or scroll through the list of available items and select

     • Select filters from multiple sections, to provide more accurate results

     • Click the X on the selected item to remove

   • Apply a filter by selecting product tags

4. Click Apply Filters

   

Step 2 of 4

Exporting Data

Once filters have been applied a spread sheet can be downloaded which will enable bulk updates for dietary data.

Follow these export and download the spread sheet:

1. Click Download Dietary Information Sheet

   

2. The exported spread sheet will be added to your downloads folder, open the sheet to begin editing

   The spread sheet will contain all of the items based on the filters applied

   The file name of the spread sheet will be the following format: Nutrition_Template_Date_Time

Editing Spread Sheet Data

1. Add or edit dietary information as required in any of the data columns

   

2. Save the spread sheet

Importing Data

Step 3 of 3

Follow these steps to import the spread sheet:

1. Select Dietary Export / Import

2. Click Import Dietary Information

   

3. Drag and Drop the file into the import area or click the link and locate the file to upload

   One file can only be uploaded at a time, the file will be validated and displayed that it uploaded correctly, if the wrong file was selected it can be deleted at this time and the process repeated to select the correct file

   

4. Click Import

   After the import has finished, complete the bulk approval of the updated dietary information