Quick Start Integration
Introduction
The Fyndiq Quick Start Integration is a quick and easy way to automatically upload and update products to Fyndiq.
To use this solution, all you have to do is put together a very basic CSV file with all the products you would like to sell on Fyndiq.
This file should be put on a web server and should automatically be updated to always show the latest stock numbers and prices.
Fyndiq will read the file on a regular basis to import new products, update existing products (and their stock values and prices) and delete products which are no longer included in the CSV file.
If you should later decide to build a full integration with Fyndiq (to add more information to your products and also import orders), the Fyndiq Quick Start Integration is a good basis for further development.
Sounds good? Great!
Too technical? You still have the possibility to upload your products manually through the Merchant Pages.
Below you can find some basic instructions on how the Fyndiq Quick Start Integration has to be created.
To get started even more quickly, there is also a CSV template available here.
Get started
Here are the steps required to get your Fyndiq Quick Start Integration running. Please do not hesitate to contact us along the way at seller@fyndiq.com if need be.
-
Sign up on the merchant pages.
Contact our merchant support so they can help you setting your account in test mode. -
Create your Fyndiq Quick Start Integration CSV file as described below.
-
Log in to your account and generate an API v2 token in the Settings/API section.
-
Test your CSV file with the Feed Checker located at the bottom of the Settings/API section.
If the file is not valid, the test will indicate where the error(s) are. Once the file is complete and valid, you can go on to the next step. -
Make your CSV file available on a public URL (e.g. by uploading it on a web server) and make sure that the file is updated with the latest stock values and prices regularly.
-
Save the URL of your Fyndiq Quick Start Integration CSV file in the Settings/API section.
-
Wait until the products appear in your Fyndiq Merchant Account. This might take up to 30min.
-
Check if the products look as they should. If they do, please contact Merchant Support, so that your account can be switched to live mode.
Congrats! Your products are online and for sale on Fyndiq.
Basic concepts
CSV
CSV is a widely used text format for exchanging tabular data. Our feed reader recognizes feeds following the below format rules:
- Encoding must be UTF-8
- The first row must be a header, defining the name of each column
- Rows must be separated by a newline character (\n)
- Columns must be separated by a comma (,)
- Fields with embedded commas, double-quote characters or line breaks must be quoted
- Embedded double-quote characters must be represented by a pair of double quote characters (""example"")
Data rows
Each row in your CSV file represents one article, which is a single selling unit on Fyndiq.
Several articles can be grouped into one product, all sharing the product fields or attributes.
A simple example would be a dress, which the merchant sells in different colors.
Each color in this example is an article and the dress itself is the product.
Note that all the articles for the same product must have the same price. If your articles have different prices, please do not group them into a product.
Data columns - Feed fields
In this Quick Start guide we focus on the main product attributes, so all the below fields are required for the feed to be successful.
Please note that there are more fields and product attributes available in a full version of the feed.
product-id
Unique identifier for every single product.
The main purpose of this field is to group separate articles in one product.
Articles with the same product_id will be grouped on Fyndiq and use the first article's price.
If articles are not supposed to be grouped (different prices), please use a different product_id for each article.
product-title
Name of the product.
product-description
Product description must not contain any markup (e.g. HTML).
product-market
Market where the product is sold at. Only market supported is Sweden (SE).
product-currency
Must be 'SEK' since Sweden is the only market.
product-price
Product price as it will appear on the Fyndiq website.
The price must include all taxes and must be lower or equal to product-old-price.
prodcut-oldprice
The standard product retail price as it appears on the merchant's website.
product-vat-percent
The VAT percentage for the product. Supported values are 6, 12 or 25 for Sweden.
product-image-1-url
Publicly available URL for the product image JPG or PNG, minimum size 200x200px.
product-image-1-identifier
Unique identifier for the product image. When the content of this field is changed, the image on Fyndiq will be updated.
article-sku
Unique article identifier. Please note, that the Article SKU has to be unique within your CSV file.
article-quantity
The current quantity in stock for the article. The quantities must always be kept up-to-date.
article-name
Name of the article contains the unique attribute that differentiates that article from the others in the same product.
Field types and constraints
Summary of the required fields and their constraints
Column | Description | Type | Example |
---|---|---|---|
product-id | Unique identifier for product | String (1-32 characters) | 4711 |
product-title | The product title | String (5-64 characters) | Adidas soccer ball |
product-description | Product description in plain text | String (10-4096 characters) | This is an amazing soccer ball. |
product-market | Two letters country code for the country in which the product will be sold | SE | SE |
product-currency | Three letter currency code for the product prices | SEK | SEK |
product-price | Final product price on Fyndiq, including VAT. Dot used as decimal separator | Decimal | 199.50 |
product-oldprice | Product price on merchant's website including VAT. Dot used as decimal separator | Decimal | 299.50 |
product-vat-percent | VAT percentage applied for the product price | Integer: 6, 12 or 25 for Sweden | 25 |
product-image1-url | URL to product image | String, valid URL | http://img.example.com/p8328-a.jpg |
product-image1-identifier | Unique image identifier | String (1-42) | ac33443422ee |
article-sku | Unique article SKU | String (1-64) | 2388BB-322 |
article-quantity | Stock quantity for the article | Non-negative Integer (0-100000) | 42 |
article-name | Name of the article | String (1-30) | Small |
Feed Sample
In this sample we have two products and four articles:
- Product 1 (Case for Iphone) with 1 variation
- Product 2 (High heels) with 3 variations (3 sizes)
product-id,poduct-title,product-description,product-market,product-currency,product-price,product-oldprice,product-vat-percent,product-image-1-url,product-image-1-identifier,article-sku,article-quantity,article-name
1,"Case for ""iPhone 6 Plus"" thin and transparent",Transparent and ultra-thin case for iPhone 6 Plus,SE,SEK,99.50,120,25,https://cdn.fyndiq.se/product/61/81/1a/0e3dfa796d6074368b4e342aa0f856c26a/original.png,342aa0f856,CIPHONETR,100,transparent
2,High heels blue,Brand new and trendy design,SE,SEK,180.50,200,25,https://cdn.fyndiq.se/product/60/48/64/2fa6f0e92636edd142b1477 ea7ec17df31/original.png,ea7ec17df31,SHOES39,10,Size 39
2,High heels blue,Brand new and trendy design,SE,SEK,180.50,200,25,https://cdn.fyndiq.se/product/60/48/64/2fa6f0e92636edd142b1477 ea7ec17df31/original.png,ea7ec17df31,SHOES40,12,Size 40
2,High heels blue,Brand new and trendy design,SE,SEK,180.50,200,25,https://cdn.fyndiq.se/product/60/48/64/2fa6f0e92636edd142b1477 ea7ec17df31/original.png,ea7ec17df31,SHOES41,2,Size 41
Categories
Your products must be assigned a category in order to be visible on our website. An easy way to do so is to log in to your pages and add them on the product level. There is also the possibility to update products by batches.
The categories reflects the menus on Fyndiq.se.
Should you wish to develop a more advanced integration at a later stage, please note that the categories from your web shop can be added to the product feed and mapped to Fyndiq’s categories.
FAQ
I am selling T-shirts; and each T-shirt is sold in different colors. How do I properly export my products?
Export all color variations as articles in consecutive rows, which have the same product-id
but different color names for the article-name
.
I'm selling products without variations. How should my feed look like?
Note that you still have to provide all fields. Make sure every product has a unique product-id
. You can use part of the product-title
as the article-name
(up to the 30 character). article-sku
and article-quantity
become values for the product. See an example of a feed with two products with no variation below:
product-id,poduct-title,product-description,product-market,product-currency,product-price,product-oldprice,product-vat-percent,product-image-1-url,product-image-1-identifier,article-sku,article-quantity,article-name
1,"Case for ""iPhone 6 Plus"" thin and transparent",Transparent and ultra-thin case for iPhone 6 Plus,SE,SEK,99.50,120,25,https://cdn.fyndiq.se/product/61/81/1a/0e3dfa796d6074368b4e342aa0f856c26a/samsung.png,342aa0f856,CIPHONETR,100,transparent
2,"Case for ""Samsung S6"" thin and transparent",Transparent and ultra-thin case for Samsung S6,SE,SEK,99.50,120,25,https://cdn.fyndiq.se/product/61/81/1a/0e3dfa796d6074368b4e342aa0f856c26a/iphone.png,377bb0f987,CSAMSUNGTR,100,transparent
I have more than one image for each product. Can I export all the images?
You can use up to 50 images for each product. You simply need to add ‘’’product-image’’’ fields to your feed. If you want to add three pictures the feed will look as follows:
product-id,poduct-title,product-description,product-market,product-currency,product-price,product-oldprice,product-vat-percent,**product-image-1-url,product-image-1-identifier,product-image-2-url,product-image-2-identifier,product-image-3-url,product-image-3-identifier**,article-sku,article-quantity,article-name
Glossary
CSV file
Comma-separated values is a text file format for tabular data. The format follows several simple rules and is easy to work with.
SKU
Stock keeping unit is the unique identifier for each article. All SKUs must be unique, within a merchant’s feed.
It is considered a bad practice to reuse SKUs for discontinued products.
Article
Article (sometimes called variation or combination) is the selling unit which can actually be bought by a customer.
Articles must have a unique SKU.
Product
A product is a container for one or more articles.
Articles belonging to a single product usually differ by one or more attributes e.g. different sizes for a pair of shoes or different colors for a T-shirt.
All articles contained in a product must have the same Fyndiq price.
Published: 18 October 2023