Sello

Developers

Product feed

What is a product feed?

If you want to integrate your webshop or inventory system to Sello to reach out to the different marketplaces currently supported by Sello the easiest way is to create a product feed. Create a JSON (text format) product feed in your system. You then place this feed somewhere on your site or system where Sello can publicly reach the URL to the feed, for example: http://www.mywebshop.se/sellofeed.json

When you have created the feed you add the URL to the feed in Sello. Sello will then read your feed every hour. Sello will create the products that are new in the feed and the products that has been updated in the feed will be compared to Sello and we will automatically update and sync the product information to the marketplaces you are connected to.

We recommend that you update your feed often in accordance with changes made with your stock, this way you will have updated stock, prices and such information about your products in the product feed you create for Sello.

 

Product feed requirements

Product feed behavior

Sello recognizes your products by the SKU (Stock keeping unit), this is your internal article number for your products. SKU always needs to be a unique string or number. The first time you add your feed to Sello, Sello will create all the products and log all your products SKU’s in the feed. We will remember the data and compare the data between readings of the feed. Next reading of your feed when all the products are created Sello will update the products in Sello by comparing the products in Sello against your feed and if the products have been changed in the feed, they will be changed in Sello.
If you stop sending a SKU in the feed that you have imported once to Sello. Sello will then deactivate that product after 24 hours on all your marketplaces that you activated the product for.
Sello will read your feed every hour and update the products if the information has been changed since last time we read the feed.

There are two ways of syncronizing products to Sello, you can either create a single product or a variant product. You can also combine the both in the feed if you have both kinds of products in your system.
Tradera is the only marketplace that does not support variant products. However Sello will still be able to use your variant products for Tradera because we have a special way of creating those grouped products in Sello. However if you are going to import variant products to Sello and activate them on Tradera you will need to add a separate text for Tradera on the variant where you add your product name plus variant name. Example: “Carbon fiber Iphone 7S case – Black”

 

Product feed example

There are multiple ways to to create a product feed in Sello. For example you can add price or category in different ways on your products. We will show you two different examples, you can however combine these JSON data structures, they are  just examples. Keep in mind that some of these attributes are mandatory.

The first example is suitable for those of you who only want to integrate your products to Tradera with the Sello product feed. In this example we will only add the absolute necessary data that is needed on Tradera. We will use attributes that are  generally only used for Tradera. If you are going to integrate Sello to other marketplaces we do not recommend using this setup.

The example feed contains 2 single products. Why we add single products only in this example is because that is the only kind of product supported by Tradera. There is no support for things like product properties, product brands and so on.

All product information should be put inside of products.

In this example we will use (“integration_id”: 6789), this is our integration ID number for our example feed. This will need to be changed according to your own integration_id number you have been assigned in Sello for your integration (marketplace). Every account has unique ID numbers for their integrations. In this case ID 6789 will be our Tradera integration.

 

Feed 2 single products:

{
    "products": [
        {
            "sku": "nike35-s",
            "privateName": "Nike White T-shirt - Small",
            "tax": 25,
            "quantity": 25,
            "condition": "new",
            "forSale": true,
            "traderaPrice": {
                "store": 199,
                "auction": {
                    "start": 1,
                    "buynow": 229
                }
            },
            "traderaCategoryId": 164102,
            "images": [
                "http://sello.io/img/nike35-s/1.jpg",
                "http://sello.io/img/nike35-s/2.jpg",
                "http://sello.io/img/nike35-s/3.jpg"
            ],
            "texts": {
                "name": "Nike White T-shirt - Small",
                "description": "Very nice Nike T-shirt in white cotton. This t-shirt is of small size."
            },
            "shipping": [
                {
                    "integration_id": 6789,
                    "posten": 0
                }
            ]
        },
        {
            "sku": "nike33-m",
            "privateName": "Nike Orage T-shirt - Medium",
            "tax": 25,
            "quantity": 22,
            "condition": "new",
            "forSale": true,
            "traderaPrice": {
                "store": 199,
                "auction": {
                    "start": 1,
                    "buynow": 229
                }
            },
            "traderaCategoryId": 164103,
            "images": [
                "http://sello.io/img/nike33-m/1.jpg",
                "http://sello.io/img/nike33-m/2.jpg",
                "http://sello.io/img/nike33-m/3.jpg"
            ],
            "texts": {
                "name": "Nike Orage T-shirt",
                "description": "Very nice Nike T-shirt in orange cotton. This t-shirt has the size medium."
            },
            "shipping": [
                {
                    "integration_id": 6789,
                    "posten": 0
                }
            ]
        }
    ]
}

 

In the following product feed example we will do a little more advanced product feed data structure. This is more suited for a Sello Premium merchant that wants to sell their products on multiple marketplaces,  and not only on Tradera.

The following JSON data will include a product group with 5 different variants (5 sizes). Vi have also added examples of how you add product properties to your variants, this is however not mandatory. But if you sell on CDON, Amazon, vidaXL, Coolshop etc this is very important to add to your product properties.

All product information should be put inside of products.

In this example we will use (“integration_id”:12345), this is our integration ID number for our example feed. This will need to be changed according to your own integration_id number you have been assigned in Sello for your integration (marketplace). Every account has unique ID numbers for their integrations. In this case ID12345 will be our CDON integration.

 

 

Attributes and descriptions

 

Attribute Requirements Mandatory Example Description
sku string (max 40 chars) required *  TSHIRT01923 Your own unique identifier for this product
condition new or used required *  new If the product is new or used
tax 0, 6, 12 or 25 required *  25 The VAT percentage for this product
privateName string (max 40 chars) required *  T-shirt Dog XS The internal Sello product name, used in inventory. This won’t be disclosed to your customers, it’s a strictly internal name.
quantity integer required *  20 The stock quantity for this product
location string (0-20 chars) optional  Box 83 The stock location for this product
volume float optional  0.03 Product volume in m3. Decimals should use dot and not comma.
weight integer optional  28 Weight in grams
purchasePrice float optional 2.10 Purchase price in SEK. Decimals should use dot and not comma.
brand string (0-100 chars) optional  Adidas Product brand name
pricing object with price keys (see example) required *
(or use prices below)
{
    "price": 123,
    "industry": 362,
    "currency": "SEK"
}
Used by Sello to calculate prices in different currencies. Currently on SEK is a valid value for currency. This is the easiest way to add price to your products for alla your channels (marketplaces)
prices object with integration – price keys (see example) required (or use pricing)
{
	"4": {
		"store": 10,
		"auction": {
			"start": 1,
			"buynow": 10,
			"reserve": null
		}
	},
	"25728": {
		"sv": {
			"store": 10,
			"regular": 99
		}
	},
	"25729": {
		"SE": {
			"store": 10,
			"regular": 99
		},
		"FI": { // Prices in EUR
			"store": 1,
			"regular": 9
		},
		"NO": { // Prices in NOK
			"store": 10,
			"regular": 99
		},
		"DK": { // Prices in DKK
			"store": 10,
			"regular": 99
		}
	},
	"25727": {
		"sv": {
			"store": 10
		}
	}
}
Integration id and it’s price details. With this attribute you can specify your price per integration_id (marketplace). This is good if you want different prices per marketplace. Otherwise we recommend “pricing”.

In the example the following integration_id is for the following channels:

4 = Tradera
25728 = Fyndiq
25729 = CDON
25725 = Prestashop

integration_id is always unique to your account, do not use these ID's in the example.
texts object with:
name (10-80 chars)
description (10-7000 chars)or a separate object for each integration
required
{
    "name": "A10-2 title",
    "description": "Test description lorem ipsum"
}

or (this example will cause different names on the two integrations)

{
	1020: {
	    "name": "A10-2 title integration 1",
	    "description": "Test description lorem ipsum"
	},
	3040: {
	    "name": "A10-2 title integration 2",
	    "description": "Test description lorem ipsum"
	}
}
Product name and description. You can add different product names and descriptions per integration or language.

If you do not state integration or language Sello will add it as the Swedish standard text on the product.

images array of image url’s required
[
    "http://feeds.sello.io/test/cat1.png",
    "http://feeds.sello.io/test/cat2.jpg"
]
At least one image is required. Images should be in png, jpg or gif format. The first image in the array will be your main product image. There is no limitation in how many images you may supply, image size is limited to 8 MB per image. If you supply more than 5 images, Sello will choose the first 5 to submit to Tradera. If an image is larger than 300 kB, Sello will resize and/or compress the image to be at most 300 kB.
shopCategory string (max 100 chars) required Clothes – tshirts – animals The category crumb in your shop. This will be used to map your categories against marketplace categories.
Since products are categorized by size on Tradera, we recommend you to include product size in the category crumb. For example:
Clothes – T-shirts – Ladies – SThe format of the crumb is up to you, it’s only use to map a category in your shop against marketplace category.
properties object with key-value pairs.
key: string (max 100 chars)
value: string (max 100 chars)
optional
{
    "EAN": "10203040",
    "Color": "red",
    "Size": "large"
}
Any product properties you wish to supply
shipping See example optional
(required for Tradera)
{
	// Tradera
	{
		"integration_id": 4,
		"posten": 48,
		"pickup": true	
	},
	// CDON
	{
		"integration_id": 25729,
		"SE": "A", // CDON shipping codes
		"DK": "I" 
	}
}
cost in SEK and provider (posten, dhl, schenker, bussgods or other)
forSale boolean or object required
true

or

{
    // Tradera
    "4": true,
    // Fyndiq
    "25728": false,
    // CDON
    "25729": true
}
If bool provided, should product be for sale on marketplace or not.If object provided, which marketplaces the product should be active on.

 

Validate you feed

Sello has created a simple tool to validate your product feed. This tool will detect some errors like if your feed has the wrong JSON format or such. It also will validate some of the data in your fields. It might be a good tool for you when you are developing the feed.

You will find said tool here: https://sello.io/wp-content/themes/sello/validatefeed/validatefeed.html

 

Troubleshooting

If you encounter problems with your feed a tip can be contacting Sello support and we will try to assist you by taking a look at your feed. It is very important to give us as much details about your problems as possible for us to be able to help you.

The feed logging system can aslo ge a good tool to see if you feed or products in the feed contain errors that are not complying with Sellos criteria.
You can find the feed logging system here:

 

 

Ready to go live with your feed

When you develop your feed in can be a good idea to have a pretty JSON print in the data. But if  you have many products in the feed (over 1000) it can be a good idea to compress the JSON data so it is as compact as possible.

 

How to add your product feed to Sello:

  1. Log into Sello.
  2. Go to: Settings -> Product feed -> Settings.
  3. Click: “URL to feed”.
  4. Paste you URL link to your product feed.
  5. Click: “Save”.

You feed will be imported as soon as Sellos system runs the feed reader. This might take a hour or so.