...
| 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> | 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. |
| 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. |
...
| Field Type | CSV Field Header Name | XML Tag Name | Status | Description |
|---|---|---|---|---|
| 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. |
| Manufacturer | Manufacturer | <Manufacturer> | Optional | The name of the manufacturer of the product. |
| Restock Date | RestockDate | <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 Time | LeadTime | <LeadTime> | Optional | The 'LeadTime' has two separate purposes depending on the 'StockStatus' of the product.If the product is INSTOCK, 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.If the is OUTOFSTOCK, the 'LeadTime' indicates the approximiate number of days until the product is back in stock and can be dispatched from the warehouse. Note: The product will remain on the site as 'INSTOCK' with the number of days showing as to when it is available. |
| 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. |
| Country | Country | <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 Date | DiscountPriceStartDate | <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 Date | DiscountPriceEndDate | <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. |
...