...
| Field Type | CSV Field Header Name | XML Tag Name | Status | Description |
|---|---|---|---|---|
| Product Id | ProductId | <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 Id | SkuId | <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> | MandatoryMandatory^^ | 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. |
| Brand | Brand | <Brand> | Mandatory | The brand name of the product. |
| Category | Category | <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 1 | Imageurl1 | <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. |
| 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. |
| Title | Title | <Title> | Mandatory | A concise title for your product in title case (not block capitals) which identifies the nature of the product.
|
| Description | Description | <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 Rate | VATRate | <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 Type | CSV Field Header Name | XML Tag Name | Status | Description |
|---|---|---|---|---|
| Image URL 2-5 | Imageurl2, 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 VAT | DiscountPriceWithoutVAT | <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 VAT | DiscountPriceWithVAT | <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. |
...