Field Specification

In order to be able to show your product listing to best effect to our customers around the world, Fruugo requires a product data feed.  We need to retrieve this feed frequently to keep stock levels accurate and thereby improve the customer experience.

The method used to get product information into the Fruugo system is via a suitably constructed product data feed. This feed contains the information which the Fruugo system requires to be able to correctly display your products to the customer, correctly calculate the cost (including shipping and sales tax where appropriate) to shoppers in all of the Fruugo countries.

Mandatory Feed Requirements

Both of our data formats allow the Fruugo system to utilise one data feed to display your products across all our countries. The specifications are straight-forward and easy to create which allows you to quickly integrate with Fruugo.

There are only 11 mandatory fields in the Fruugo CSV and XML formats to ensure you can get up and running as soon as possible. The remaining fields, although not compulsory*, are there so that we can fine tune your experience to get you the most sales possible. Throughout this process the Fruugo Integration Team will be on hand to advise on submitting a feed that ensures your products are set-up correctly. *They may become compulsory dependent on the nature of your products.

Mandatory Fields

Field TypeCSV Field Header NameXML Tag NameStatusDescription
Product IdProductId<ProductId>Mandatory

Your own product identifier code that you recognise when it is provided on order information.

The same ProductId should be used to group together Skus where they are available with multiple options (Colours, Sizes etc.).

Sku IdSkuId<SkuId>Mandatory

If the product has multiple options, the SkuId uniquely identifies and separates each option. If a product doesn’t have multiple options the SkuId can be the same as the ProductId.

Each ProductId & SkuId combination must be unique and not repeated for any other Product(s).

GTINs (EAN / UPC)EAN<EAN>Mandatory^^

The unique GTIN for the product. GTIN stands for Global Trade Item Number - a globally unique number used to identify trade items, products, or services. GTIN is the umbrella term that refers to the entire family of data structures - UPC, EAN, UCC - 8, 12, 13 & 14 digits.

If you are the manufacturer of the product you can mark the product to be an exception to the requirement rule by using EXCEP in the EAN field.

BrandBrand<Brand>MandatoryThe brand name of the product.
CategoryCategory<Category>Mandatory

The accurate category you wish the product to be classified in on Fruugo using the Fruugo category path.

The category value must be accurate to the nature of the product for taxation and use the full Fruugo category path in the stucture shown in the category tree.

Image URL 1Imageurl1<Imageurl1>Mandatory

The link to your primary image for a product which will be displayed. A minimum size of 400px x 400px (or larger). The image should be provided on a white background.

Images will only be updated if the file name is changed, we do not check to see if your file is newer than your last scheduled import.

Placeholder or images using watermarks are not permitted.

Stock Status*StockStatus<StockStatus>Mandatory*

The stock status of a product which indicates whether it’s available for purchase. The value of the field must be either:

INSTOCK – If you have the product currently in stock.
OUTOFSTOCK – The product is currently out of stock but may return.
NOTAVAILABLE – The product is permanently out of stock and needs to be removed.

Quantity in Stock*StockQuantity<StockQuantity>Mandatory*

The quantity of an item you have available to sell. If stock levels are not held a default number is recommended, such as 100 for in stock items and 0 for out of stock items.

Negative values or decimal places are not supported.
TitleTitle<Title>Mandatory

A concise title for your product in title case (not block capitals) which identifies the nature of the product.

  • It should include any brand, model or part number which is widely used to identify the product.
  • It should not include any reference to price; shipping; stock; special offers; or promotional text.
  • It should not include any reference to size or colour when part of a grouped product.
DescriptionDescription<Description>Mandatory

A detailed explanation of the product and its features. Use sentence case.

Do not include any URLs; Email Addresses; Telephone Numbers; Prices; Shipping information, or references to activity not on our site.

Normal Price Without VAT^NormalPriceWithoutVAT<NormalPriceWithoutVAT>Mandatory^

The normal / list price of the product excluding VAT. Must be a numeric value with a decimal separator and not include any currency symbol. For example 4.12. If included, 'NormalPriceWithVAT' must not be included.

Normal Price With VAT^NormalPriceWithVAT<NormalPriceWithVAT>Mandatory^

The normal / list price of the product including VAT. Must be a numeric value with a decimal separator and not include any currency symbol. For example 4.12. If included, 'NormalPriceWithoutVAT' must not be included.

VAT RateVATRate<VATRate>Mandatory

The numeric value of the correct VAT rate of the product in your VAT registered country (EU only).

Do not include % or any other symbols. For example: 20. To be listed as 0 for non-EU based retailers where VAT is not applicable.

*Either StockStatus or StockQuantity must be provided within the feed.
^Either NormalPriceWithoutVAT or NormalPriceWithVAT must be provided within the feed.
^^ The field is not required if the product is a book. The ISBN field must be used instead for books.

Recommended Fields

Field TypeCSV Field Header NameXML Tag NameStatusDescription
Image URL 2-5Imageurl2, Imageurl3, Imageurl4 & Imageurl5<Imageurl2>, <Imageurl3>, <Imageurl4>, <Imageurl5>Recommended

Used to provide additional image URLs for the product. Each URL should be in a separate field with up to 5 images being supported. The same image policies apply to these fields as apply to 'Imageurl1'.

Language^Language<Language>Recommended^

Two digit ISO code (lower case) of the language of the text fields of the feed, such as Title, Description, AttributeColor etc. The language must be one of those supported on Fruugo (as listed in Fruugo Countries > Countries; Languages; & Currency codes).

The text within the feed should all be in one language. Note: The field becomes mandatory if the language used is not the native language of your registered country.

Attribute Size*AttributeSize<AttributeSize>Recommended*

The specific size option of the SKU, which where a product is available in several size choices will present the size option to the retailer. Note: The field becomes mandatory if you have products which are available in multiple sizes.

We recommend including the size for all products, however the field should not include generic terms such as one size or o/s (unless clothing & footwear).

Attribute Color*AttributeColor<AttributeColor>Recommended*

The specific colour option of the SKU, which where a product is available in several colours choices will present the colour option to the retailer. Note: The field becomes mandatory if you have products which are available in multiple colours.

We recommend including the colour for all products, however the field should not include generic terms such as multi-coloured, mixed or one colour (unless clothing & footwear).

Currency^Currency<Currency>Recommended^

Three letter ISO code (Upper Case) of the currency of the price fields of the feed, such as NormalPriceWithoutVAT. The currency must be one of those supported on Fruugo (as listed in Fruugo Countries > Countries; Languages; & Currency codes).

We strongly recommend always using the native currency of your registered country. Note: The field becomes mandatory if the language used is not the native language of your registered country.

Discount Price Without VATDiscountPriceWithoutVAT<DiscountPriceWithoutVAT>Recommended

The discount / sale price of the product excluding VAT. Must be a numeric value with a decimal separator and not include any currency symbol. For example 4.12.

Must only be used if you use 'NormalPriceWithoutVAT' for your normal list price. If included 'DiscountPriceWithVAT' must not be included.

Discount Price With VATDiscountPriceWithVAT<DiscountPriceWithVAT>Recommended

The discount / sale price of the product excluding VAT. Must be a numeric value with a decimal separator and not include any currency symbol. For example 4.12.

Must only be used if you use 'NormalPriceWithVAT' for your normal list price. If included 'DiscountPriceWithoutVAT' must not be included.

*The field becomes mandatory if you have products which are available in multiple sizes or colours.
^The field becomes mandatory if the language or currency used in the feed is not the native language & currency of your registered country.


Optional Fields

Field TypeCSV Field Header NameXML Tag NameStatusDescription
ISBN*ISBN<ISBN>Optional*The unique ISBN for the product. ISBN stands for International Standard Book Number - the globally unique number used to identify publications. The data structure should be either the 10 or 13 digit number (13 preferred). Note: The field becomes mandatory for all books.
ManufacturerManufacturer<Manufacturer>OptionalThe name of the manufacturer of the product.
Restock DateRestockDate<RestockDate>Optional

The date when a product which is currently marked as OUTOFSTOCK in 'StockStatus' will be back in stock and available for order.

The date must be provided in one of the following UNIX timestamp formats: DD:MM:YY; DD:MM:YYYY; YY:MM:DD; YYYY:MM:DD; DDMM-YY; DD-MM-YYYY; YY-MM-DD; YYYY-MM-DD.

Lead TimeLeadTime<LeadTime>Optional

The 'LeadTime' indicates the approximiate number of days delay from order to the item being dispatched from the warehouse when a product is currently marked as INSTOCK in 'StockStatus'.

Note: Only to be used if the time exceeds 24 hours as 1 day is the default product value.

Package Weight^PackageWeight<PackageWeight>Optional

The shipping weight of the product provided in grams with no decimal places or unit of measurement. For example, 190.

Note: The field becomes mandatory if your shipping rules are calculated based on the total order weight - please see Shipping > Weight Based Shipping. If you are utilising quantity based shipping all products must have a default value of 1000 - please see Shipping > Quantity Based Shipping.

Attribute 1-10

Attribute1, Attribute2 through to Attribute10<Attribute1>, <Attribute2> through to <Attribute10>Optional

These are used for any additional attributes/options that most suit your product type that are not Size (AttributeSize) or Colour (AttributeColor).

They should be used so each column only contains one attribute type/value. The semantics of used attribute field must be communicated to a member of the Integration team. Note: The attribute fields should not be used to list product features; only options to be selected by the customer.

CountryCountry<Country>Optional

Two digit ISO code (Upper Case) is used to limit a product to listed countries if they have a different restriction to your default account settings. It is an “include” list and for multiple countries should be separated by spaces. For example: IE FR DE. The country codes must be those supported on Fruugo (as listed in Fruugo Countries > Countries; Languages & Currency codes).

Note: The field should be left blank if the product does not have a country restriction that differs from your default account settings.

Discount Price Start DateDiscountPriceStartDate<DiscountPriceStartDate>Optional

The start date for your discount price to begin being displayed, if it is a timelimited promotion, and you have populated either 'DiscountPriceWithoutVAT' or 'DiscountPriceWithVAT'.

The date must be provided in one of the following UNIX timestamp formats: DD:MM:YY; DD:MM:YYYY; YY:MM:DD; YYYY:MM:DD; DDMM-YY; DD-MM-YYYY; YY-MM-DD; YYYY-MM-DD.

Discount Price End DateDiscountPriceEndDate<DiscountPriceEndDate>Optional

The end date for your discount price to stop being displayed, if it is a timelimited promotion, and you have populated either 'DiscountPriceWithoutVAT' or 'DiscountPriceWithVAT'.

The date must be provided in one of the following UNIX timestamp formats: DD:MM:YY; DD:MM:YYYY; YY:MM:DD; YYYY:MM:DD; DDMM-YY; DD-MM-YYYY; YY-MM-DD; YYYY-MM-DD.

*The field becomes mandatory if you sell books.
^The field becomes mandatory if your shipping is calculated by either order weight or quantity ordered.