The file should be placed at an HTTPS or FTP address from which we can retrieve it. If you have blockages at IP address level, ensure that our IPs (185.153.57.22, 13.48.206.143, 13.51.87.202 and 13.51.99.152) have access. Refrain from using timestamps or other information that will change the URL of the feed as this will cause your products to disappear.
For us to optimize update routines and display your product catalog’s recent version with prices and item availability, we highly encourage the last-modified HTTP response header to be provided and serviced. The header indicates the date and time the product feed was last changed. By servicing this regularly, we can check for updates more frequently.
Use one of the following encodings for the price file:
- UTF-8, UTF-16
- ISO-8859-1
- Windows-1252
We can handle the majority of formats. The most common are: TEXT/CSV, XML and JSON. Note that the price file can’t be in Excel or any other non-text format. To make our processing and your updates run faster, compress your feed using gzip/zip.
CSV
When it comes to a CSV feed, the data have to be structured in rows and columns. Each row must represent a single product and each column should consist of fields with product information.
- Divide each field or column by a particular separator. Recommended separators include a tab, pipe, semicolon or comma.
- Use "field qualifiers" at the start and end of each field. Note that this character might not occur within a field. Recommended “field qualifiers” single ( ‘ ‘ ) or double ( “ ” ) quotation marks.
Example feeds
Below is a list of the columns recommended for a successful listing. The order and title are not important, provided that they are comprehensible.
- By including EAN/GTIN, it will be possible to match your products automatically and upload them quicker.
- Fields should never contain code or tags such as HTML or JavaScript.
- SKU/ID
- Name
- Price
- Shipping costs
- Stock status
- Delivery time
- Manufacturer
- EAN/GTIN
- Condition
- Manufacturer SKU/MPN
- URL
- Image URL
- Category
- Description
- AdultContent
- AgeGroup
- Bundled
- Color
- EnergyEfficiencyClass
- Gender
- GroupId
- Material
- Multipack
- Pattern
- Size
- SizeSystem