Products API

General Information

You can access our product data by several means:

CSV file

  • Download a CSV file containing all attributes of our products. You can either download all our products or filter which products to download using several criteria's (like language, style code, etc).

JSON/REST V1 web service

  • This web service lets you download all attributes of our products. Each record is a variant (style+color+size). You can also filter which products to download using several criteria's (like language, style code, etc).

JSON/REST V2 web service

  • This web service is similar to JSON/REST V1 but groups the variants by styles. Attributes that are common for all variants of a style are represented only once.


CSV File

Download a CSV file containing all attributes of our products. You can either download all our products or filter which products to download using several criteria's (like language, style code, etc).

In order to use this system, valid credentials are required. If you do not have one yet, please request an account.

Request an account


 Download our catalog as a CSV file.

Quick Access (logged users)

Once you logged in, you will find the following screen.


Just click "Download products CSV" to download the complete collection.

Alternatively, you can fill in some filters before clicking on "Download products CSV". You will then receive a CSV file containing only the result of your request.


JSON/REST V1

Stanley/Stella Products API is a JSON/RPC webservice that lets you call our product database, and import this data in your own system. The information is provided real time and contains all details about all products.

Note: If you want to get quick information regarding stock positions, you should better use our Stock API.


The data is provided through two endpoints:

  • products : an exhaustive list of all products we propose, with all related information (gender, size, descriptions, stock,...) in 6 languages. This list contains one record per variant (Style + Color + Size)

  • productsV2 : the same data as products but with variants grouped by style. This way, the data that is common to all variants of a style is outputted only once and not duplicated on every variants. See section JSON/REST V2 here under for additional details.


Please also note

  • Method to be used is POST

  • Encoding is UTF-8

  • Text delimiter is the double quote (")

  • Field delimiter is the semicolon (;)

  • The API must be called with the https prefix

In order to use this system, valid credentials are required. If you do not have one yet, please request an account.

Request an account

If you wish to test your code, you can do so with a tool like Postman.

Integration

Endpoint Settings

Environment
Server
Database


PROD
https://api.stanleystella.com
production_api

Note : the test endpoint is deemed to be used with eligible partners when we develop new features with our API. You should connect to our prod environment.

Get JSON

Service
URL
Catalog
/webrequest/products/get_json

Parameters in "Products"

You can use the following parameters to filter dataset.

Note : we are working on enabling filtering on any field.

Parameter
Type
Sample value
Comment
db_name
mandatory
production_api

user mandatory
your login

password
mandatory
your password

LanguageCode
optional, filter en_US
SKU_Start_Date
optional, filter
2016-12-31
Date format is in YYYY-MM-DD
StyleCode
optional, filter
STTM528

ColorCode
optional, filter
C001

SizeCode
optional, filter
XXL
Human readable Size Code
StyleName
optional, filter
Stanley Leads

Color
optional, filter
White
Language Sensitive
ColorGroup
optional, filter
Whites
Language Sensitive
Type
optional, filter
Tee-shirt
Language Sensitive
Category
optional, filter
Top
Language Sensitive
Gender
optional, filter
Men
Language Sensitive
Fit
optional, filter
Fitted
Language Sensitive
Neckline
optional, filter
Round Neck
Language Sensitive
Sleeve
optional, filter
Sleeveless
Language Sensitive


Retrieving the data

 

Field
Explanation
Sample Data
LanguageCode
The language of the line fr_FR, en_US, de_DE, es_ES, nl_BE, it_IT
B2BSKUREF
The SKU Reference
STTW001C673XS
StyleCode
The Style Code
STTW001
ColorCode
The Color Code
C673
SizeCode
The Size Code (2 characters)
XS
StyleName
The name of the product
Stella Dreams
Color
The name of the colour
Slub Heather Steel Grey
ColorGroup
The colour group the colour belongs to
Special Heathers
Type
The type of the product (language sensitive)
Débardeur, Tank Top
Category
The category of the product (language sensitive)
Haut, Top
Neckline
The type of neckline (language sensitive)
Col rond profond, Deep round neck
Sleeve
The type of sleeve (language sensitive)
Sans manches, Sleeveless
ShortDescription
A short abstract of the product (language sensitive)
Débardeur dos nageur, Racerback tank top
LongDescription
A complete description of the product designed for web. May contain <BR> characters (language sensitive)
sans manches biais en côte 1 x 1 sur le col et emmanchure avec surpiqûre simple
ourlet inférieur légèrement incurvé avec double surpiqûre
coutures latérales vers l'arrière
ShortNote
A short abstract of the product (language sensitive)
Débardeur dos nageur, Racerback tank top
LongNote
A complete description of the product designed for paper communication. May contain <BR> characters (language sensitive)
sans manches biais en côte 1 x 1 sur le col et emmanchure avec surpiqûre simple
ourlet inférieur légèrement incurvé avec double surpiqûre
coutures latérales vers l'arrière
Bleaching
Bleaching instructions (language sensitive)
Oui, Non, Yes, No,..
Washing
Washing instructions (language sensitive)
Oui, 30°C, 50°C,...
Cleaning
Cleaning instructions (language sensitive)
Oui, Non, Yes, No,...
Drying
Drying instructions (language sensitive)
Pas d'essorage, Tumble dry Low,...
Ironing
Ironing instructions (language sensitive)
110°C, Do not Iron,...
CompositionList
The composition of the product (language sensitive)
100% Coton bio, 100% Organic Cotton,...
ConstructionList
The construction of the product (language sensitive)
Jersey simple, Single jersey
FinishList
The finishing of the product (language sensitive)
Fabric Washe
SundryList
All additionnal features (language sensitive)
Button on shoulder
Gauge
The gauge of the product (number)
80.0
Weight
The weight of the product (numer)
120.0
GOTS
TRUE if product is certified
1,0
OCS100
TRUE if product is certified
1,0
OCSBlended
TRUE if product is certified
1,0
Ecoted
TRUE if product is certified
1,0
Fairwear
TRUE if product is certified
1,0
CarbonNeutral
TRUE if product is certified
1,0
FSC
TRUE if product is certified
1,0
Reach
TRUE if product is certified
1,0
Weight per unit
The weight of one product (in Kgs)
0.058
Pieces per box
The number of pieces in one full box
110
HalfChest
The half chest dimension (in cm)
110
BodyLength
The body length (in cm)
36.5
SleeveLength
The sleeve length (in cm)
0.0
Width
The width of the product, for bags (in cm)
0.0
Length
The length of the product, for bags (in cm)
0.0
StrapLength
The strap length of the product, for bags (in cm)
0.0
Waist
The waist of the product, for pants (in cm)
0.0
Tight
The tight of the product, for pants (in cm)
0.0
TotalLegLength
The total length of the leg, for pants (in cm)
0.0
HSCode
Custom Code
611091000
K3EUR
not used yet

K15EUR
not used yet

K30EUR
not used yet

K50EUR
not used yet

K100EUR
not used yet

Price<10EUR
Recommended sales prices for less than 10 pieces in EUR
10.35
Price>10EUR
Recommended sales prices for more than 10 pieces in EUR
6.55
Price>50EUR
Recommended sales prices for more than 10 pieces in EUR
6.2
Price>100EUR
Recommended sales prices for more than 100 pieces in EUR
5.85
Price>250EUR
Recommended sales prices for more than 250 pieces in EUR
5.5
Price>500EUR
Recommended sales prices for more than 500 pieces in EUR
5.2
Price>1000EUR
Recommended sales prices for more than 1000 pieces in EUR
4.85
K3GBP
not used yet

K15GBP
not used yet

K30GBP
not used yet

K50GBP
not used yet

K100GBP
not used yet

Price<10GBP
Recommended sales prices for less than 10 pieces in GBP
8.1
Price>10GBP
Recommended sales prices for more than 10 pieces in GBP
5.15
Price>50GBP
Recommended sales prices for more than 50 pieces in GBP
4.85
Price>100GBP
Recommended sales prices for more than 100 pieces in GBP
4.6
Price>250GBP
Recommended sales prices for more than 250 pieces in GBP
4.3
Price>500GBP
Recommended sales prices for more than 500 pieces in GBP
4.05
Price>1000GBP
Recommended sales prices for more than 1000 pieces in GBP
3.8
SKU_Start_Date
The starting date of the product in format YYYY-MM-DD. Please note that
SS17 collection : 2017-01-01
AW17 collection : 2017-09-01
Products are available in the file one month before we start selling
2015-01-01
Published
True if product is available for sale on our webshop, False if not.
Products are available in the call before their actual release on our webshop to let you organize, and remains available in the db for one year after we stop selling same
Boolean
true = 1, false = 0
PiecesPerPolybag
The number of pieces contained in one polybag
5
FitID
The technical ID for the fit
10
GenderID
The technical ID for the gender 13
CategoryID The technical ID for the category 11
TypeID The technical ID for the type 31
NecklineID The technical ID for the neckline 11
SleeveID The technical ID for the sleeve 11
SequenceStyle The sort order number of this style. The styles are ordered by this sequence number in the response of the call. This lets you import and display the styles in the same order as the Stanley/Stella webshop. 600
NewStyle Indicates if the style is new in the current collection Boolean, true = 1 or false = 0

NewProduct

Indicates if this style + color combination is new in the current collection

Boolean, true = 1 or false = 0  

NewItem Indicates if the style + color + size combination is new in the current collection

Boolean, true = 1 or false = 0  

NewColor Indicates if the color is new in the current collection, across all styles

Boolean, true = 1 or false = 0  

NewSize Indicates if the size is new in the current collection, across all styles + colors

Boolean, true = 1 or false = 0 

ColorSequence The sort order number of this color. The variants are ordered by this sequence number in the response of the call. This lets you import and display the colors in the same order as the Stanley/Stella webshop. 1
ColorGroupSequence

The sort order number of this color group.  This lets you import and display the color groups in the same order as the Stanley/Stella webshop.  

999
SizeSequence

The sort order number of this size. The variants are ordered by this sequence number in the response of the call. This lets you import and display the sizes in the same order as the Stanley/Stella webshop.  

20
StylePublished Indicates if the style is currently published on the Stanley/Stella webshop. The rule is that a style is published if at least one of its variants is published.

Boolean, true = 1 or false = 0  

MainPicture Indicates the URL of the main picture to display on the product selection page of your website. This lets you present the Stanley/Stella collection with the same images as the Stanley/Stella webshop.

https://api.stanleystella.com/Pictures/SFM0_STSU816_C016.jpg

The webservice response is a JSON/RPC response with a result key containing all requested objects - provide the error key does not exist.

If you wish to reuse the data, you must use the JSON.parse(response.result) method. This will return a table containing all objects.

JSON/REST V2

The JSON/REST V2 Product API is functioning in a very similar way as the JSON/REST V1.

The only difference is that the variants are grouped by style. This way, the data that is common to all variants of a style is outputted only once and not duplicated on every variants.

Integration

Endpoint Settings

Same as JSON/REST V1


Get JSON

Service
URL
Catalog
/webrequest/productsV2/get_json

Parameters in "Products"

Same as JSON/REST V1


Retrieving the data

Example of response of the JSON/REST V2 web service.

{
"jsonrpc": "2.0",
"id": 0,
"result": "[
    {
    \"LanguageCode\": \"en_US\",
    \"StyleCode\": \"STSU816\",
    \"StyleName\": \"Join\",
    \"Type\": \"Sweatshirts\",
    \"Category\": \"Top\",
    \"Gender\": \"Unisex\",
    \"Fit\": \"Relaxed Fit\",
    \"Neckline\": \"Round Neck\",
    \"Sleeve\": \"Long Sleeve\",
    \"ShortDescription\": \"Drop shoulder crewneck sweatshirt\",
    \"LongDescription\": \"Set-in sleeve\\n1x1 rib binding at collar with narrow double topstitch\\n1x1 rib at sleeve hem and bottom hem\\nSelf fabric half moon at back neck \",
    \"SequenceStyle\": 600,
    \"StylePublished\": 1,
    \"MainPicture\": [
        {
        \"ColorCode\": \"C016\",
        \"PhotoTypeCode\": \"Studio\",
        \"PhotoStyle\": \"Main\",
        \"PhotoShootCode\": \"Front\",
        \"PhotoSequenceCode\": 0,
        \"FName\": \"SFM0_STSU816_C016.jpg\",
        \"Color\": \"Candy Pink\",
        \"HTMLPath\": \"https://api.stanleystella.com/Pictures/SFM0_STSU816_C016.jpg\"
        }
    ],
    \"Variants\": [
        {
        \"B2BSKUREF\": \"STSU816C001XS\",
        \"ColorCode\": \"C001\",
        \"SizeCodeNavision\": \"XS\",
        \"SizeCode\": \"XS\",
        \"Color\": \"White\",
        \"ColorGroup\": \"Whites\",
        \"Stock\": 317,
        \"ShortNote\": false,
        \"LongNote\": false,
        \"Bleaching\": \"No\",
        \"Washing\": \"30\u00b0\",
        \"Cleaning\": \"No\",
        \"Drying\": \"Tumble Dry Low\",
        \"Ironing\": \"110\u00b0\",
        \"CompositionList\": \"85% Organic ring-spun Combed Cotton, 15% Polyester\",
        \"ConstructionList\": \"Brushed sweatshirt\",
        \"FinishList\": \"Fabric washed, Light sueded\",
        \"SundryList\": \"\",
        \"Gauge\": 0.0,
        \"Weight\": 300.0,
        \"GOTS\": 0,
        \"OCS100\": 0,
        \"OCSBlended\": 1,
        \"Ecotex\": 1,
        \"Fairwear\": 1,
        \"CarbonNeutral\": 0,
        \"FSC\": 0,
        \"REACH\": 0,
        \"WeigthPerUnit\": 0.35,
        \"PiecesPerBox\": 20,
        \"HalfChest\": 53.0,
        \"BodyLength\": 66.0,
        \"SleeveLength\": 59.0,
        \"Width\": 0.0,
        \"Length\": 0.0,
        \"StrapLength\": 0.0,
        \"Waist\": 0.0,
        \"Tight\": 0.0,
        \"TotalLegLength\": 0.0,
        \"HSCode\": false,
        \"Price<10 EUR\": 20.9,
        \"Price>10 EUR\": 20.9,
        \"Price>50 EUR\": 19.8,
        \"Price>100 EUR\": 18.7,
        \"Price>250 EUR\": 17.6,
        \"Price>500 EUR\": 16.5,
        \"Price>1000 EUR\": 15.4,
        \"Price<10 GBP\": 18.8,
        \"Price>10 GBP\": 18.8,
        \"Price>50 GBP\": 17.8,
        \"Price>100 GBP\": 16.85,
        \"Price>250 GBP\": 15.85,
        \"Price>500 GBP\": 14.85,
        \"Price>1000 GBP\": 13.85,
        \"SKU_Start_Date\": \"2018-01-01\",
        \"Published\": 1,
        \"PiecesPerPolybag\": 5,
        \"FitID\": \"10\",
        \"GenderID\": \"13\",
        \"CategoryID\": \"11\",
        \"TypeID\": \"31\",
        \"NecklineID\": \"11\",
        \"SleeveID\": \"11\",
        \"NewStyle\": 1,
        \"NewProduct\": 0,
        \"NewItem\": 0,
        \"NewColor\": 0,
        \"NewSize\": 0,
        \"ColorSequence\": 1,
        \"ColorGroupSequence\": 999,
        \"SizeSequence\": 20
        }, ...
    ]
    }
]"
}