e-label - Bulk Upload - Product Information - Data Bulk Upload - Enterprise

The Bulk Upload Feature is only available for Enterprise Users. 

• Getting started and getting the Upload Template
• Adding the Product Information to the Template
• Adding the Ingredients to the Template
• Adding the Nutrition Information to the Template
• Adding Pictorgrams to the Template
• Adding Italian Recycling Information to the Template
• Adding Free Text Fields to the Template
• Adding country specific Text Fields to the Template
• Uploading the Completed Template

Getting started and getting the Upload Template

1. Go to QR Manager and click on UPLOAD E-LABEL DATA:

2. You will be taken to the BULK UPLOAD home screen:

• Select the category
• Select the language you will use in the form
• Select the languages for which you require translations for your e-label
• Click on: DOWNLOAD THE EXCEL TEMPLATE:

3. The Excel file has 9 tabs, but only the first 6 are important for you: 

• "TutorialHelp" tab - provides additional information on how to complete the required information
• "Product Information" tab - here you enter the product information
• "Ingredients" tab - here you enter the ingredient information
• "Nutrition" tab - here you enter the nutrition information
• "Pictorgams" tab - to select the pictograms that should be added per SKU 
• "Images" tab - provides the reference table of what each pictogram ID stands for 
• Italian Recycling - Here you can enter the recycling Italian packages and icons.
• Spanish Recycling - Here you can enter the recycling Spanish packages and icons.
• Free Text Fields - Here you can add free texts.
• Country-specific Fields -  Here you can add country-specific information.  

Adding the Product Information to the Template

1. The first column with the header SKU must contain the correct reference to the product - in the portal, it is referenced as SKU:

2. Go to the product information tab. Then, in column name type the display name (if different from the product is named and/or if it needs to be translated): 

3. Under product_type column, you can choose from the drop-down list. Should your type not be available, please type the name and then press ENTER on your keyboard:

4. The net_quantity_ml column is where you add the size of your container (or containers)

• Sizes are entered in ml (milliliters)
• Excel will send you an alert that there is a number that is stored as text, please ignore this:
  

5. Alcohol_volume is entered as a percentage:

6. Serving_size_ml is entered in ml (milliliters):

7. For sugar_content (sugar content), please choose from the drop-down list:

8. For origin, please choose from the drop-down list: 

9. For producing_year, please type the year (YYYY): 

 

10. For vinatage_year, please type the year (YYYY)

11. Grape_variety is a free form, please type the name of your wine:

12. Wine_colour, please choose from the drop-down:

13. Production method, please choose from the drop-down:

Adding the Ingredients to the Template

1. In the Ingredients tab, the first column with the header SKU must contain the correct reference to the product - in the Scantrust portal it is referenced as SKU:

2. There are 3 additional columns

• Aromatised_base_wine_name, pick from the drop-down list:
  
• Ingredient (here you pick an ingredient from the drop-down list --> note that they are already grouped into Categories like "Main Ingredient", "Preservative and antioxidants", "Acidity regulators", etc.):
  
  
• Is_allergen; here you can specify if a product is an Allergen or not. If the answer is YES, it will be clearly marked as such to the consumer. In the INGREDIENTS section, the marked item will be bolded:
  
• Is_organic; here you can specify if a product is an Allergen or not. If the answer is YES, it will be clearly marked as such to the consumer. In the INGREDIENTS section, the marked item will be denoted with an asterisk:
  
• •  

Adding the Nutrition Information to the Template

1. In the Nutrition tab, The first column with the header SKU must contain the correct reference to the product - in the Scantrust portal, it is referenced as SKU: 

The remaining fields are straightforward, the name already implicates the unit of measurement:  

• energy_kj
• energy_kcal
• fat_g
• saturates_g
• carbohydrate_g
• sugar_g
• protein_g
• salt_g
• show_zero_values_as_negligible, is the field where you specify how to display a nutrition field that has 0 (zero) grams:
  
•  

Adding Pictograms to the Template

1. In the Pictogram tab, the first column with the header SKU must contain the correct reference to the product - in the portal, it is referenced as SKU

2. For icon_id, pick the reference corresponding with the pictogram you would like to use:  

Adding Italian Recycling Information to the Template

1. In the Italian Recycling tab the first column with the header SKU must contain the correct reference to the product - in the Scantrust portal it is referenced as SKU:

2. For the packaging column. pick from the drop-down list: 

3. There are 3 additional columns

• Material, pick from the drop-down list: 

• For collection guidance, pick from the drop-down list:

• The numbering is determined by the selection you made for the material. You can make changes if required:

 

4. You can then enter a custom name for your packaging if required:

Adding Spanish Recycling Information to the Template

1. In the Spanish Recycling tab, the first column with the header SKU must contain the correct reference to the product - in the Scantrust portal it is referenced as SKU:

2. For the packaging column. pick from the drop-down list: 

3. In the Icon column, please select the want you are requiring: 

Adding Free Text Fields to the Template

1. In the free text tab, the first column with the header SKU must contain the correct reference to the product - in the portal, it is referenced as SKU:

2. You can add custom ingredients for your products as follows, you can also add the translations for these products:

Adding Country-specific Text Fields to the Template

1. In the Country-specific field tab, the first column with the header SKU must contain the correct reference to the product - in the Scantrust portal it is referenced as SKU:

2. You can add country-specific fields for your products as follows, you can also add the translations for these fields where applicable:

Uploading the Completed Template

Once the template is completed, return to the BULK UPLOAD home screen and: 
1 - Click on CHOOSE FILE and select the updated template
2 - Select the language you will use in the form
3 - Select the languages for which you require translations for your e-label
4 - Click on NEXT: 

5. In the next screen, you may: 

• Review the template's
  • e-label category
  • selected default input language
  • translation languages
• Review the template's
  • File summary
    • Recaptures how many e-labels will be updated
• Assign codes
  NOTE: only generate codes if you don't have any yet. Otherwise, you will end up with multiple codes per product:
  
  • For each of the products that are updated with this template, you can choose to assign a code by turning the toggle to ON.
  • Define an upload batch name (if you are assigning codes).
• Click NEXT to proceed to upload the information:

IMPORTANT:

• This template may be used for the initial creation of e-labels as well as for updates
• Not every field is mandatory
• THERE ARE NO CHECKS IN PLACE that will remind you if something was not updated. 

Please review each e-label individually to ensure all the information is displayed in a satisfactory manner! 

6. If you choose to assign codes, you may download those codes as soon as the e-label data is updated successfully by clicking on DOWNLOAD THIS BATCH: 

7. make sure you select the codes before you click on DOWNLOAD: