How do I provide safety information via CSV file upload?

Quick Links

Safety information can be provided at SKU level in our Retailer Portal by uploading a comma-separated value (CSV) file. CSV is a common, simple file format that is widely supported by consumer, business, and scientific applications.

A CSV file consists of any number of records, separated by line breaks; each record consists of fields, separated by a character or string, most commonly a comma (,) but semi-colons (;) are also supported. All records have an identical sequence of fields.

From 13th December 2024, if we are not able to display your product’s safety information it may be removed from sale.

Safety Information

Product API Integrations

Via Feed

Example File

How to provide safety information via CSV file upload

Please follow the below steps to provide your product safety information:

Step	Action

Step	Action
1	Log in to Retailer Portal using your retailer credentials
2	Locate the Compliance menu item in the navigation pane
3	Click on the Safety Information page under the Compliance menu item
4	Read the instructions on how to format your CSV file
5	Create and complete your CSV file It’s important to use the correct headers and values for your file otherwise you may encounter errors with your catalogue Your CSV file must comply with the UTF-8 standard and not exceed 10 MB Both commas (,) and semi-colons (;) are supported as delimiters
6	Upload your CSV file Your upload will fail if we encounter an error with your file. Please ensure you have formatted the file correctly
-	Repeat the process if you’d like to amend your safety information, or provide safety information for additional products. You are able to upload multiple files, e.g. upload Ingredients for a batch of SKUs in one file, and Batch Number’s for the same SKUs in another If you are amending a SKU's safety information, please be aware that uploading new values will overwrite your existing values

CSV structure

Your CSV file should always include the following headers when uploading your safety information to be processed correctly:

productId,skuId,Language

The following headers are optional depending on what type of safety information you are providing:

Safety Warnings,CE Mark,Ingredients,Serial Number,Manufacturer Part Number,Model Number,Batch Number,Safety Attestation

Header and expected values

Please note that Headers must be provided as per the below format

Header	Value

Header	Value
ProductId	Your product ID
SkuId	Your SKU ID
Language	The language code for your safety information. For example: English safety information `ProductId,SkuId,Language,Safety Warnings,CE Mark abc-123,def-456-1,en,Not suitable for children under 36 months,1` German safety information `ProductId,SkuId,Language,Safety Warnings,CE Mark abc-123,def-456-1,de,Nicht für Kinder unter 36 Monaten geeignet,1` Please click here to view a list of supported languages on Fruugo
Safety Warnings	The applicable safety warnings for your SKU. For example: Single safety warning: `ProductId,SkuId,Language,Safety Warnings abc-123,def-456-1,en,Not suitable for children under 36 months` Multiple safety warnings: Please ensure that your list is readable as we display the values you upload on the product details page to the customer. We recommend using a character to separate list items, e.g. “.”, “/”, “-”, “•” `ProductId,SkuId,Language,Safety Warnings abc-123,def-456-1,en,Not suitable for children under 36 months. Choking Hazard. Adult supervision recommended` Mandatory for certain categories
CE Mark	A declaration that your SKU has a CE mark present. If applicable, please provide the value “1” as this corresponds to the following statement: This SKU has a CE mark present. `1` Any value other than “1” will be ignored. If you provide a value other than “1” and your SKU is an a mandatory category, it may be removed from sale. For example: `ProductId,SkuId,Language,Safety Warnings,CE Mark abc-123,def-456-1,en,Not suitable for children under 36 months,1` Mandatory for certain categories
Ingredients	A list of ingredients for your SKU, including quantity and unit if applicable. For example: Single ingredient: `ProductId,SkuId,Language,Ingredients abc-123,def-456-1,en,Octinoxate 6.7%` Multiple ingredients: Please ensure that your list is readable as we display the values you upload on the product details page to the customer. We recommend using a character to separate list items, e.g. “.”, “/”, “-”, “•” `ProductId,SkuId,Language,Ingredients abc-123,def-456-1,en,Octinoxate 6.7% / Titanium Dioxide 1.6% / Butylene Glycol / Polymethylsilsesquioxane` Mandatory for certain categories
Serial Number	A unique identifier for your SKU if serial number is applicable. Optional
Manufacturer Part Number	A unique identifier for your SKU if manufacturer part number is applicable. Optional
Model Number	A unique identifier for your SKU if model number is applicable. Optional
Batch Number	A unique identifier for your SKU if batch number is applicable. Optional
Safety Attestation	An attestation that must be provided when safety information is not required for a SKU in an obligatory category path. If applicable, please provide the value “1” as this corresponds to the following statement: This SKU does not require safety information. `1` Any value other than “1” will be ignored. If you provide a value other than “1” and your SKU is an a mandatory category, it may be removed from sale. For example: `ProductId,SkuId,Language,Safety Warnings,Safety Attestation abc-123,def-456-1,en,Not suitable for children under 36 months,1` Mandatory for certain categories

Example file

You can download the example file below to view a sample of SKUs with populated safety information.