The Validation Errors Tables contain a comprehensive list of the issues that may be flagged for correction in your catalogue. These errors will be flagged during the integration process and in certain circumstances once your account is live on the platform.
| Info |
|---|
Most of the Automated errors listed in the Validation Errors Tables can be found flagged in the Catalogue Manager or in your Product Issue Report once your account is live. |
What can I do?
The Validation Errors Tables will help you understand and recognise flagged issues with your products. You can use the table below to understand why a particular issue has been raised and what changes you can make to ensure that your product can be published. Any product data amendments must be made via your integration.
| Info |
|---|
Please note that in some cases, Fruugo is required to restrict certain products for compliance reasons. Affected products will remain blocked from sale regardless of any product data changes you make. |
Automated Validation Errors Table
Errors flagged automatically during the product data review process are categorised and defined as follows:
Error Type | Field/s Affected | Error Title | Summary | Resolution | |
|---|---|---|---|---|---|
| 1 | Automated | All Fields | Field character limit exceeded | The value you have provided exceeds the maximum permitted characters allowed within the particular field. | In order for the product to be processed please amend the value provided to be below the maximum permitted characters for the field. You can find a full field character limit here: https://fruugo.atlassian.net/wiki/spaces/RR/pages/67882986/Field+Specification+-+Limits |
| 2 | Automated | All Pricing Fields | Invalid price format | All prices provided in the normal & discount price fields using a decimal point to separate the denominations. | Please updating all prices in both the normal & discount price fields to use a decimal separator for the denominations only. |
| 3 | Automated | Brand | Brand is required | The Brand field is a mandatory field in Fruugo's product specification and must be provided. | As this is a mandatory field in Fruugo's product specification, please can you ensure all products are updated and have the Brand field populated with the accurate brand for this product to reflect the product & packaging. |
| 4 | Automated | Category | Category does not exist or is not an exact match | The category does not match an exixting Fruugo category which can be used to list the product and therefore it can not be assigned to a suitable category. | Update the category being provided for this product to the relevant category within Fruugo's category tree category (https://fruugo.atlassian.net/wiki/spaces/RR/pages/67792527/Mapping+Category+Tree). Please ensure the category used is relevant to the product and exactly matches one of Fruugo’s category paths. |
| 5 | Automated | Category | Category is required | The Category field is a mandatory field in Fruugo's product specification and must be provided. | As this is a mandatory field in Fruugo's product specification, please can you ensure all products are updated and have the Category field populated with the accurate category path for that product. |
| 6 | Automated | Currency | Incorrect currency provided | The currency you provide within your data must be consistent across your account to match the currency set-up on your account for the bank details, and should also be used for your shipping prices. | Please update the currency being used in your product pricing to match the currency set-up on your account for your bank details. The currency of the bank details cannot be changed. |
| 7 | Automated | Description | Description is required | The Description field is a mandatory field in Fruugo's product specification and must be provided. | As this is a mandatory field in Fruugo's product specification, please can you ensure all products are updated and have the Description field populated with a description that describes the product and features in detail. |
| 8 | Automated | Description | Description contains non-permitted values | The description contains values which are prohibited for Fruugo as these can conflict the information presented on the product (price, shipping etc) and also contract the terms of operation on Fruugo. | Please amend the description to only provide details, features and key information on the product. You should remove any symbols and emojis, as well as any reference to price, shipping, product condition, promotional text, customer information, warranties and contact information (including URLs or emails). |
| 9 | Automated | Discount Date Fields | Invalid date format | The date format used for the start & end of the discount price period is not one of our supported data formats. | Please ensure that any dates provided are in one of the following accepted formats: DD:MM:YY; DD:MM:YYYY; YY:MM:DD; YYYY:MM:DD; DDMM-YY; DD-MM-YYYY; YY-MM-DD; YYYY-MM-DD. |
| 10 | Automated | Discount Date Fields | DiscountPriceStartDate & DiscountPriceEndDate relationship incorrect | The date you provided as the end date for your discount price being valid is before the start date of the offer. | To correct the issues please update your discount price start & end dates to be the accurate starts you require the discount price to be valid and ensure the start date is before the end date. |
| 11 | Automated | Discount Date Fields | Discount price end date cannot be set in the past | The date you provided as the end date for your discount price being valid is a date which has already passed. | To correct the issues please update your discount price end date to be a valid date in the future. |
| 12 | Automated | EAN | GTINs (EAN / UPC) is required | The EAN field is a mandatory field in Fruugo's product specification and must be provided. | As this is a mandatory field in Fruugo's product specification, please can you ensure all products are updated and have the EAN field populated unless they are books in which case you should populate the ISBN field. The GTIN you provide in the EAN field should be in the expected format (8, 12, 13 & 14 digits). |
| 13 | Automated | EAN | Duplicate EAN/GTINs | EAN/GTINs serves as a unique identifier for a SKU. These should not be duplicated and should be unique to the each SKU. | To correct the issue please ensure the correct EAN/GTINs value is provided. These should be unique and registered for that SKU with the relevant authority, such as GS1. If you are the manufacturer of the product and it is not distributed to or sold by others you can mark the product to be an exception to the requirement rule by using EXCEP in the EAN field. |
| 14 | Automated | EAN | EAN/GTINs not in the correct format | EAN/GTINs serves as a unique identifier for a SKU and is provided to an expected format. The GTIN you provide in the EAN field should be in the expected format (8, 12, 13 & 14 digits). | GTIN is the umbrella term that refers to the entire family of product identifiers for which your SKU should be registered. These are UPC, EAN, JAN and have an expected length of 8, 12, 13 & 14 digits depending on the registration. To correct the issue please ensure the EAN/GTIN provided is correct and registered to that SKU with correct amount of digits depending on its type. |
| 15 | Automated | EAN or ISBN | Product contains wrong identifier for this product type | The SKU is incorrectly flagged with the wrong identify EAN / ISBN which is not relevant for that product type. | If the product is a book, please ensure the ISBN field is used to provide the 10 or 13 digit ISBN for this SKU. If the product is not a book, please use the EAN field to provide the correct GTIN for this SKU in the expected format (8, 12, 13 & 14 digits). |
| 16 | Automated | ImageURL Fields | Image not found | The URL you have provided for the image is not available at the location provided. | You must ensure that the image URLs provided for your SKUs are correct and point to the accurate location of the image, including the file name and extension. The hosting of the image should be unrestricted and readily accessible for use. |
| 17 | Automated | ImageURL Fields | Image format not supported | The image format which has been provided is not one of our supported formats. | Please update your provided image URLs to ensure they are provided in one of the accepted file formats (.jpg, .png or .gif) and are to a minimum resolution of 400x400 pixels. |
| 18 | Automated | ImageURL Fields | Image download failed | An error occurred when our image system attempted to download the image from the URL you have provided. | To correct the error the image URLs you have provided must be correct for the location of the product image, including filename & extension, and that the images are hosted on a location which does not have any restriction of access such as IP whitelisting, DDoS protection or other service throttling. |
| 19 | Automated | ISBN | ISBN invalid | The ISBN provided is not in the expected format. | ISBN are unique registered identifiers specially for books with an expected length of 10 or 13 digits. To correct the issue please ensure the IBSN provided is correct and registered to that book with correct amount of digits. |
| 20 | Automated | ISBN | ISBN required | The ISBN field is a mandatory field in Fruugo's product specification for any book and must be provided. | As this is a mandatory field in Fruugo's product specification for books please can you ensure any books are updated and have the ISBN field populated. ISBN are unique registered identifiers specially for books with an expected length of 10 or 13 digits. |
| 21 | Automated | LeadTime | Invalid use of leadtime: Out of Stock | The lead time field indicates the time from order to dispatch of the order and as a result it cannot be used for products which are out of stock and not available for order. | To correct this please remove the lead time value from any SKU with a stock status of out of stock or a stock quantity of 0. |
| 22 | Automated | LeadTime | Invalid use of leadtime: Not Available | The lead time field indicates the time from order to dispatch of the order and as a result it cannot be used for products which are not available for order. | To correct this please remove the lead time value from any SKU with a stock status of not available or a stock quantity of 0. |
| 23 | Automated | LeadTime | Invalid use of lead time: Invalid Value | As Fruugo as a 24 hour dispatch policy on orders, the lead time has a minimum value of 2 as is used to indicate to the customer where dispatch will be longer than 24 hrs. The value should be numeric only (e.g. 2). | Please ensure that either the lead time is left blank if the order is dispatched within 1 day of receipt, or if you dispatch later than one day, please populate the lead time with a value of 2 (or more) to indicate your time from order to dispatch. Please provide a numeric value only. No alpha characters. |
| 24 | Automated | ProductId | Product ID is required | The ProductId field is a mandatory field in Fruugo's product specification and must be provided. | As this is a mandatory field in Fruugo's product specification, please can you ensure all products are updated and have the ProductId field populated. |
| 25 | Automated | ProductId, AttributeSize, AttributeColor | No distinguishing attribute for this child SKU | Occurs when multiple SKUs are grouped under the same ProductID but have matching attribute information which means there is insufficient data for systems to identify them as unique SKUs. | Add additional attribute information to differentiate between each of the individual SKUs which are grouped under the shared ProductID provided with the error. Without this information the customer can not select their required option. |
| 26 | Automated | SkuId | SKU ID is required | The SkuId field is a mandatory field in Fruugo's product specification and must be provided. | As this is a mandatory field in Fruugo's product specification, please can you ensure all products are updated and have the SkuId field populated with a unique ID. |
| 27 | Automated | SkuId | Duplicate SKU IDs | Two or more SKUs share the same SkuID within the data provided. | To correct the issue please ensure that each SKU within your product catalogue is updated to have a unique SkuId value and these are not duplicated across 2 or two more SKUs. |
| 28 | Automated | Stock Fields | StockStatus or StockQuantity is required | It is mandatory that all SKUs must have either the StockStatus or StockQuantity field provided in Fruugo's product specification to indicate the stock of that SKU. | Please ensure you update your SKUs to provide either or both of StockStatus or StockQuantity for each SKU in order to provide the current stock availability of that SKU. |
| 29 | Automated | Stock Fields | StockStatus & StockQuantity relationship incorrect | The StockStatus and StockQuantity relationship must be to correct to indicate the correct status and quantity of stock of a SKU. | You will need to update your SKUs to correctly indicate when the StockQuantity value is 0 available that the SKU has the Status of OUTOFSTOCK or NOTAVAILABLE. Likewise, when the StockQuantity is 1 or more that the status is set to INSTOCK. |
| 30 | Automated | Stock Fields | Invalid StockQuantity value | The StockQuantity value you have provided is not valid. The StockQuantity field is a numeric field only and can not be a negative value. | StockQuantity values should be whole numbers and cannot go below 0. |
| 31 | Automated | Stock Fields | Invalid StockStatus value | The stock status value is not valid. | Please ensure the value you provide in the StockQuantity field is a numeric value and is not negative. The value should not be below 0 or contain any alpha characters. |
| 32 | Automated | Title | Title is required | The Title field is a mandatory field in Fruugo's product specification and must be provided. | As this is a mandatory field in Fruugo's product specification, please can you ensure all products are updated and have the Title field populated with a concise title/introduction for the product. |
| 33 | Automated | Title | Title not provided in title case | The title provided has not been provided in title case as required and instead uses block upper case. | Please update your product title so that it is provided in title case rather than block upper case. |
| 34 | Automated | Title | Title contains non-permitted values | The title contains values which are prohibited for Fruugo as these can conflict the information presented on the product (price, shipping etc) and also contract the terms of operation on Fruugo. | Please amend the title to only provide a concise introduction to the product. You should remove any symbols and emojis, as well as any reference to price, shipping, product condition, promotional text, and contact information. |
| 35 | Automated | VAT Rate | VAT Rate is required | The VATRate field is a mandatory field in Fruugo's product specification and must be provided. | As this is a mandatory field in Fruugo's product specification, please can you ensure all SKUs are updated and have the VATRate field populated with the accurate VATRate for the SKU in your domestic country if you are based within the EU or UK. If you are outside of the EU or UK, please list the VATRate as 0. |
| 36 | Automated | VAT Rate | Invalid VAT rate format | The VATRate field is a numeric only field and should not contain other characters, such as %. | To correct the value please ensure you provide the numeric value only of the accurate VAT rate for the product in your domestic country if within the EU or UK. If you are outside of the EU or UK, please list the VATRate as 0. |
Manual Validation Errors Table
Errors flagged automatically during the product data review process are categorised and defined as follows:
Error Type | Field/s Affected | Error Title | Summary | Resolution | |
|---|---|---|---|---|---|
| 1 | Manual | All Fields | Multiple languages being used | The product data you have provided contains multiple different languages for the content. All product data content should be in a single language. | Please review the product data you are providing and ensure that a single language is used for all product content and that it matches the language specified in the language code. |
| 2 | Manual | Attribute Fields | Additional attributes contain size/colour attributes | Additional attributes should be used for provide variation attribute options to the customer where the variant is not a size or a colour. If the attribute type is a size or colour the dedicated attribute fields/type should be used. | Please ensure that all colour attribute information is placed in the colour attribute field/type, and size information is placed in the size attribute field/type, as these are dedicated fields for this information. Only other attribute types should be populated in the additional attribute fields. |
| 3 | Manual | Attribute Fields | Additional attributes contain multiple attribute types | Additional attributes should be used for provide variation attribute options to the customer where the variant is not a size or a colour. Each additional attribute field / type should only be used for one attribute type. Different attribute types should not be listed in the same field/tag on different products. | Please use a different attribute field/type for each different attribute type you have for your products. For example: Shape, Scent, Quantity and so forth require their own attribute field/type. If the attribute is a size or colour please use the dedicated fields/type. |
| 4 | Manual | AttributeColor | Color attribute missing/not specified | The product indicates it should have a color variation to distinguish the options but it has not been provided. | Please review the product and ensure any missing color variation values are added the color attribute field / type for each grouped SKU. |
| 5 | Manual | AttributeColor | Non-colour value specified as a color attribute | There are values listed in the color attribute field/type which are not a color value. The color attribute field/type should only be used for color values which are relevant to each particular SKU. | Any values that are not a color should be corrected so that they are an accurate color or moved from the color attribute field/type to the appropriate attribute field. For example: any size moved to size attribute field/type, and any attributes other than of size or colour should be mapped to an additional attribute field where appropriate. |
| 6 | Manual | AttributeSize | Size attribute missing/not specified | The product indicates it should have a size variation to distinguish the options but it has not been provided. | Please review the product and ensure any missing size variation values are added the size attribute field / type for each grouped SKU. |
| 7 | Manual | AttributeSize | Non-size value specified as a size attribute | There are values listed in the size attribute field/type which are not a size value. The size attribute field/type should only be used for size values which are relevant to each particular SKU. | Any values that are not a size should be corrected so that they are an accurate size or moved from the size attribute field/type to the appropriate attribute field. For example: any colours moved to color attribute field/type, and any attributes other than of size or colour should be mapped to an additional attribute field where appropriate. |
| 8 | Manual | Brand | Brand not accurate to product | The brand value provided is not accurate to the product based upon the supporting content (images, title, description etc). | To correct please ensure you represent the correct brand value on the product to match the product image, packaging, licensing and literature. The product should not be listed with your company as the brand unless you hold the licensing on the product and it reflect the product, packaging, licensing and literature. The product should not be listed as unbranded unless it is a generic, mass produced item with no branding reflected on the item or packaging. |
| 9 | Manual | Category | Category not accurate to product | The category value provided for the product does not match the type of product. The category value that is provided must the accurate category location for the product to be listed. | To correct the issue please review the Fruugo category tree and update the category value assigned to the product to the most relevant and accurate for the product type. |
| 10 | Manual | Country | Country field contains all shipping to countries | The country field should only be used where a certain product has restrictions on the countries it can be sold which differ from your other products and account set-up. It should not be listed where all products can be shipped to the same locations. | To correct this, please only populate the country field for products that have a unique shipping restriction compared to your other products and list two-digit ISO country code of the countries you intend the product to be listed in. |
| 11 | Manual | Country | Country field contains origin or location of the product | The country field should only be used where a certain product has restrictions on the countries it can be sold which differ from your other products and account set-up. It should not state the origin of the product or manufacture. | To correct the issue please remove the values from the country field for the product location. The country field should only be populated for products that are to have a unique shipping restriction compared to your other products and list two-digit ISO country code of the countries you intend the product to be listed in. |
| 12 | Manual | Description | Description does not contain sufficient information. | The description should be a clear summary of the product and it's features which are essential for the customer to obtain the details they require. | Please update your description to ensure it contains the key information about the product which the customer requires. The description should not be a duplication of the title. |
| 13 | Manual | Description | Description contains non-permitted Terms | The description should be a clear summary of the product and it's features. The description cannot include weblinks, contact information or contact requests, shipping or pricing information, discount offers, references to other websites, warranty information, downloadable content, references to the product condition, or company details. | Please update your descriptions to remove reference to any of the following terms from the descriptions: weblinks, contact information or contact requests, shipping or pricing information, discount offers, references to other websites, warranty information, downloadable content, references to the product condition, or company details. |
| 14 | Manual | ImageURL1 | Primary image contains text, icons or other overlays | The primary image of your product must be provided on a white background, or an appropriate lifestyle image where appropriate, such as clothing or furniture. It must not contain any form of overlays, logos, icons, text or other tags. | Please review the primary images you are providing in your product data and update them or provide a new image URL to compliant image. You must ensure the image provided meet the necessary requirements of being a minimum 400x400 pixels, on a white background (or appropriate lifestyle image), does not contain any overlays (logos, text, icons etc.), is not watermarked, and is not a placeholder image. |
| 15 | Manual | Language | Language code is incorrect | The product data you have provided does not match the language code you have specified for the content. All product data content should be in a single language and match the language code specified. | Please review the product data you are providing and ensure that the language used for the product data matches the language code you are providing. A single language must be used throughout for all products. |
| 16 | Manual | N/A | SKUs have been removed | Your SKUs have been removed during the integration validation process and as a result can be reviewed. | Please ensure SKUs are not being removed during the integration and any necessary corrections are made to these SKUs. The SKUs you intend on listing must be present during the integration. |
| 17 | Manual | N/A | Dangerous products listed | Fruugo takes a zero tolerance approach to the sale or advertisement of dangerous products. You must ensure that all products which are listed are not in Fruugo's prohibited product sectors and meet the necessary safety standards. | You must ensure any product which is prohibited from sale or does not meet the necessary safety standards are removed from sale in your Fruugo account. |
| 18 | Manual | N/A | IP infringement/counterfeit products listed | Fruugo takes a zero tolerance approach to the sale or advertisement of counterfeit products or products which are not officially licensed. You must ensure that all products are genuine and produced by the brand or licensed manufacturers and you are officially licensed to distribute the product. | You must ensure any product which is not supplied by official manufacturers, is not officially licensed or you do not have distribute rights for the product are removed from sale in your Fruugo account. |
| 19 | Manual | N/A | Prohibited products listed | Fruugo takes a zero tolerance approach to the sale or advertisement of prohibited products. You must ensure that all products which are listed are not in Fruugo's prohibited product categories. | You must ensure any product type which is prohibited from sale are removed from sale in your Fruugo account. You can view the prohibited product types in the retailer support documentation. |
| 20 | Manual | PackageWeight | PackageWeight value inaccurate | The package weight value is used to calculate the shipping. The value provided is not accurate for the type of product. | Please review and update the package weight value provided to ensure it is correct for the product. The value should be a whole number and provided in grams with no unit of measurement. |
| 21 | Manual | PackageWeight | PackageWeight value required | The PackageWeight field is a mandatory field in Fruugo's product specification if your shipping costs are calculated by weight, and must be provided for each SKU. | As you are using a weight-based calculation for your shipping costs you must ensure you provide the weight of each SKU in grams (no decimals) in the PackageWeight field otherwise the SKU can not be purchased. |
| 22 | Manual | ProductID, Attributes | Variation product not grouped | A product which has attribute variation options for the customer, i.e. the same product in different sizes or colors, should be grouped by sharing the same ProductId for each SKU variation. | To correct the issue please update the ProductId value for each SKU that is a variation of the same product to ensure they share the the same value which will group the items together to allow the customer to select the appropriate variation on the product. |
| 23 | Manual | Stock Fields | Generic stock values provided | The stock quantity value provided is generic and is not a true representation of the current stock quantity held. I.e. a lot of the values are the same/static across the product data, such as 100 or 999. | Please review your stock quantity values to ensure they accurate / up to date and are a true reflection of the number of units of stock you hold for each particular SKU. These values should be accurate and maintained as items are sold and items are restocked. Generic stock values should not be provided. |
| 24 | Manual | Title | Title does not describe the product | The title should be a short and concise explanation of the product to introduce it to the customer. It should include/describe the nature of the product. | Please update your title to ensure it provides a short and concise explanation of the product, and includes/describes the nature of the product to the customer. |
| 25 | Manual | Title | Title does not match the product | The title provided is not accurate and conflicts with the other content provided for the product (image, brand, description etc). | To correct please ensure you review the title and other product content to ensure they are aligned as the same product, and update the title accordingly to reflect this information. |
| 26 | Manual | Title | Title includes attribute information | The title for any grouped item which has attribute variations for the customer to select, such as size or color, should be identical for each of those SKUs and should not the attribute information. | To correct the issue please amend the title of each SKU within the grouped product to be identical and ensure any attribute information included is removed and only listed in the appropriate attribute field. For non-grouped SKUs, we also recommend mapping this attribute information to the relevant fields for improved data quality. |
| 27 | Manual | Title | Titles loaded with keywords and phrases | The title should be a short and concise explanation of the product. The title should not contain keyword loading, duplication of terms, or any information which misleads on the core use of the product. | To correct this issue please ensure that the title of each product is short and concise, clearly describe the product, and does not include the use of keyword loading, duplication of terms, or any information which misleads on the core use of the product. |
| 28 | Manual | Title | Title includes non-permitted terms | The title should be a short and concise explanation of the product. The title should not include references to price, shipping, contact information, discount/special offers, references to the product condition, or company details. | Please update your title to provide a concise introduction to the product, and remove reference to any of the following terms: references to price, shipping, contact information, discount/special offers, references to the product condition, or company details. |
| 29 | Manual | VAT Rate | Incorrect VAT rate provided | The VAT rate provided is not accurate to the product type or is not applicable for the registered country of your account. | If based within the EU or UK, please ensure that the VAT rate your provide for each product is the correct rate of VAT for the product in your domestic country. If you are outside of the EU or UK, please ensure that the VAT rate field is listed as 0 as it is not applicable to your account. |
What do the columns mean?
Header | Definition | ||
|---|---|---|---|
Error Type | Errors are either assigned automatically by validation systems or manually by members of Fruugo. | ||
Field/s Affected | Which data fields are relevant to this flagged error.
| ||
Error Title | The name flagged errors which can be used to identify and define them. | ||
Summary | A brief description of the flagged error and what the problem is. | ||
Resolution | The action that is required in order to fix the error and get the flagged SKU/s live. Countries & Country Codes |