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.
Download our catalog as a CSV file.
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.
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 |
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 |
Example : php with cURL call - see it running here
The following php script is hosted on our server and can be tested using the following URL https://api.stanleystella.com/sample/test.php
Parameters can be passed as follows
-
user (mandatory) : your user name
-
password (mandatory) : your password
-
dataset (optional) : can be "products" or "product_images". If none specified, product_images is called.
-
stylecode (optional) : the style you wish to filter the list on (ex : STTM522)
-
colorcode (optional) : the color you wish to filter the call on (ex : C001)
-
languagecode (optional) : the language you wish to extract (ex: en_EN, fr_FR, nl_BE, it_IT, de_DE, es_ES). only works for the product call
URL Syntax will thus be
https://api.stanleystella.com/sample/test.php?user=user@domain.com&password=pwwd&dataset=products&stylecode=STTM522&colorcode=C001&languagecode=fr_FR
<?php
// Set API Url
// Set different URL according to dataset requested
if ($_GET["dataset"]==="products")
{
$url = 'https://api.stanleystella.com/webrequest/products/get_json';
$csvFileName = 'products.csv';
$jsonData = array(
'jsonrpc' => '2.0',
'method' => 'call',
'params' => array(
'db_name' => 'production_api',
'password' => $_GET["password"],
'user' => $_GET["user"],
'StyleCode' => $_GET["stylecode"],
'ColorCode' => $_GET["colorcode"],
'LanguageCode' => $_GET["languagecode"],
),
'id' => 0
);
}
else
{
$url = 'https://api.stanleystella.com/webrequest/products_images/get_json';
$csvFileName = 'products_images.csv';
$jsonData = array(
'jsonrpc' => '2.0',
'method' => 'call',
'params' => array(
'db_name' => 'production_api',
'password' => $_GET["password"],
'user' => $_GET["user"],
'StyleCode' => $_GET["stylecode"],
'ColorCode' => $_GET["colorcode"],
),
'id' => 0
);
}
//Initiate cURL
$ch = curl_init($url);
//Encode the array into JSON.
$jsonDataEncoded = json_encode($jsonData);
// Setup cURL
// Do not return the result in the browser
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
// Set https
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
//Tell cURL that we want to send a POST request.
curl_setopt($ch, CURLOPT_POST, 1);
//Attach our encoded JSON string to the POST fields.
curl_setopt($ch, CURLOPT_POSTFIELDS, $jsonDataEncoded);
//Set the content type to application/json
curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: application/json'));
//Execute the request
$result = curl_exec($ch);
//Decode output and isolate the content of the "result" key
$jsonDataDecoded = json_decode(json_decode($result)->result, true);
//Close CURL
curl_close($ch);
// Generate csv
$fp = fopen($csvFileName,'w+');
fprintf($fp, chr(0xEF).chr(0xBB).chr(0xBF));
foreach($jsonDataDecoded as $row){
fputcsv($fp,$row);
}
fclose($fp);
echo('File generated with following parameters<br>');
echo('Style: '. $_GET["stylecode"].'<br>');
echo('Color : '. $_GET["colorcode"].'<br>');
echo('Language : '. $_GET["languagecode"].'<br>');
echo('<a href="https://api.stanleystella.com/sample/'.$csvFileName.'">Click here to download the '.$csvFileName.' file</a><br>');
?>
Example : jQuery call - see it running here
$.ajax({
url: 'https://api.stanleystella.com/webrequest/products/get_json',
type: 'post',
dataType: 'json',
data: JSON.stringify({
"jsonrpc":"2.0",
"method":"call",
"params":{
"db_name": "production_api",
"user": "someuser@somedomain.tld",
"password": "somepassword"
},
"id": 0
}),
headers: {'Content-type': 'application/json'}
});
Example : jQuery call with parameters - see it running here
$.ajax({
url: 'https://api.stanleystella.com/webrequest/products/get_json',
type: 'post',
dataType: 'json',
data: JSON.stringify({
"jsonrpc":"2.0",
"method":"call",
"params":{
"db_name": "production_api",
"user": "someuser@somedomain.tld",
"password": "somepassword",
"LanguageCode": "fr_FR",
"StyleCode": "STTM528",
"ColorCode": "C001",
"SizeCode": "XXL"
},
"id": 0
}),
headers: {'Content-type': 'application/json'}
});
Example : VBA implementation in Excel - download sample excel file (please enable macros)
' Sample VBA Implementation for the calling the API from excel
' Code can be fine-tuned to adapt your needs
Option Explicit
Public Function CallAPI()
' Variables declaration
' Basics
Dim EndpointURL As String
Dim RequestURL As String
Dim CallName As String
Dim Body As String
' Filters and parameters
Dim DBName As String
Dim Login As String
Dim Password As String
Dim StyleCode As String
Dim ColorCode As String
Dim SizeCode As String
Dim LanguageCode As String
Dim FilterList As String
' Reponses
' Response to the Call
Dim CallResponse As String
Dim CallResponseArray() As String
' Result
Dim ResponseResult As String
Dim ResponseResultArray() As String
' Result Line
Dim ResponseResultLine As Variant
Dim ResponseUpdateArray() As String
Dim ResponseUpdateItem As Variant
Dim UpdateItem() As String
' SQL String
Dim SQL As String
Dim SQLFields As String
Dim SQLValues As String
' Output to Excel Sheet
Dim Column As Integer Column = 1
Dim Line As Integer Line = 2
Dim CheckWorksheet As Worksheet
Dim oHttp As Object
' Variables initialization
' Initialize Call Parameters
EndpointURL = "https://api.stanleystella.com/webrequest/"
DBName = "production_api"
' Uncomment the appropriate line for the call you want to perform
CallName ="products"
' CallName = "products_images"
' Initialize Filters with Filters Tab values
Login = "Insert.your@login.here"
Password = "password"
StyleCode = "STSU807"
ColorCode = "C582"
SizeCode = "S"
LanguageCode = "en_US"
' Uncomment to check in the Immediate Window
' Debug.Print "+++ Style Code : " & StyleCode
' Debug.Print "+++ Color Code : " & ColorCode
' Debug.Print "+++ Size Code : " & SizeCode
' Debug.Print "+++ Language Code : " & LanguageCode
' Select Filters depending on the call to perform
If CallName = "products" Then
FilterList = StyleCode & "," & ColorCode & "," & SizeCode & "," & LanguageCode
Else
FilterList = StyleCode & "," & ColorCode
End If
' Uncomment to check in the immediate window
' Debug.Print = "+++ FILTER LIST : " & FilterList
Body = "{""jsonrpc"": ""2.0"", ""method"": ""call"", ""params"": { ""db_name"" :""" & DBName & """, ""user"" : """ & Login & """, ""password"": """ & Password & """, " & FilterList & " } }"
RequestURL = EndpointURL & CallName & "/get_json"
' Uncomment to check in the Immediate Window
' Debug.Print "+++ POST Endpoint : " & RequestURL
' Debug.Print "+++ POST Message : " & Body
' Create the WorkSheet to receive data
Set CheckWorksheet = Nothing
On Error Resume Next
Set CheckWorksheet = Worksheets(CallName)
On Error GoTo 0
' Check If the Worksheet Exists
If CheckWorksheet Is Nothing Then
' If not, create it
Worksheets.Add.Name = CallName
Else
' If Yes, flush it to avoid duplicates
Worksheets(CallName).Cells.Clear
End If
' Post the call
Set oHttp = CreateObject("MSXML2.XMLHTTP")
oHttp.Open "POST", RequestURL, False oHttp.SetRequestHeader "Content-type", "application/json"
oHttp.SetRequestHeader "Accept", "application/json"
oHttp.Send Body
' Get the call reponse and perform some cleaning
CallResponse = Replace(oHttp.ResponseText, "\""", """")
' Split Reponse and get Result array
CallResponseArray() = Split(CallResponse, "[{")
' Set the ResponseResult String
ResponseResult = CallResponseArray(1)
' Remove trailing Characters and perform additionnal cleaning
ResponseResult = Replace(ResponseResult, "}]", "")
ResponseResult = Replace(ResponseResult, """: ", "|")
ResponseResult = Replace(ResponseResult, """", "")
ResponseResult = Replace(ResponseResult, "}", "")
' This is not really nice and is needed because excel sadly interpretates
' UTF-8 encoding.
' This should be replaced by a proper conversion table in PROD environments
ResponseResult = Replace(ResponseResult, "\\u00b0", "°")
ResponseResult = Replace(ResponseResult, "\\u00e0", "à")
ResponseResult = Replace(ResponseResult, "\\u00e4", "ä")
ResponseResult = Replace(ResponseResult, "\\u00c4", "Ä")
ResponseResult = Replace(ResponseResult, "\\u00e9", "é")
ResponseResult = Replace(ResponseResult, "\\u00e8", "è")
ResponseResult = Replace(ResponseResult, "\\u00ea", "ê")
ResponseResult = Replace(ResponseResult, "\\u00f4", "ô")
ResponseResult = Replace(ResponseResult, "\\u00fb", "û")
ResponseResult = Replace(ResponseResult, "\\n", " ") ' This one should be <br>
' Define Response lines
ResponseResultArray() = Split(ResponseResult, "{")
For Each ResponseResultLine In ResponseResultArray()
' Debug.Print "*** Writing line #" & Line & " ***"
' Reset Fields and Values
SQLFields = """"
SQLValues = """"
' Start writing the line at column 1
Column = 1
' Get the binomial array Field|FieldValue
ResponseUpdateArray() = Split(ResponseResultLine, ",")
' And for each pairing found, extract Field and Value
For Each ResponseUpdateItem In ResponseUpdateArray()
' Split the pair between field name and field value
' Field has id (0)
' Value has id (1)
UpdateItem() = Split(ResponseUpdateItem, "|")
' Set the SQL Field
SQLFields = Trim(UpdateItem(0))
' Add the field on line one, in the appropriate column
Sheets(CallName).Cells(1, Column).Value = SQLFields
' Debug.Print " -> SQLFields : " & SQLFields
' Build SQL Value Chain
' Check if list contains more than one item
If (UBound(UpdateItem) - LBound(UpdateItem) + 1) > 1 Then
' If Yes, add value to the chain
SQLValues = Trim(UpdateItem(1))
Else
' If Not just add empty value
SQLValues = ""
End If
' Enable this line to check the log of data added in the Immediate Window
' Debug.Print " -> SQLFields : " & SQLFields & " -> " & SQLValues
' Write the value somewhere, for instance in an excel sheet
Sheets(CallName).Cells(Line, Column).Value = SQLValues
Column = Column + 1
Next ResponseUpdateItem
' DEBUG : Let's check the values in the Immediate Window
' Debug.Print "**************************"
' Debug.Print "Resulting SQL Field list :" & SQLFields
' Debug.Print "Resulting SQL Value list :" & SQLValues
Line = Line + 1
Next ResponseResultLine
End Function
Testing with Postman
You can test your connection with a tool like Postman.
In the address bar, select the POST method and type the URL you want to access.
In the Body, type the call as shown below (make sure to correctly set db_name, user and password parameters)
At the right part click on the drop-down arrow and change Text to JSON (application/json)
The above call will result in the following response
Retrieving the data
A sample response from "products"
{
"jsonrpc": "2.0",
"id": null,
"result":
"[
{
\"LanguageCode\": \"fr_FR\", \"B2BSKUREF\": \"STTU755C5042S\", \"StyleCode\": \"STTU755\", \"ColorCode\": \"C504\", \"SizeCodeNavision\": \"2S\", \"SizeCode\": \"XXS\", \"StyleName\": \"Creator\", \"Color\": \"Vintage White\", \"ColorGroup\": \"Whites\", \"Type\": \"T-shirt\", \"Category\": \"Tees\", \"Gender\": \"Unisexe\", \"Stock\": 719, \"Fit\": \"Coupe normale\", \"Neckline\": \"Col rond\", \"Sleeve\": \"Manches courtes\", \"ShortDescription\": \"Le T-shirt iconique unisexe\", \"LongDescription\": \"Manches mont\ées\\nCol en c\ôte 1x1 \\nBande de propret\é int\érieur col dans la mati\ère principale\\nSurpiq\ûre double large en bas de manches et bas de corps\", \"ShortNote\": \"0\", \"LongNote\": \"0\", \"Bleaching\": \"Non\", \"Washing\": \"30\°\", \"Cleaning\": \"Non\", \"Drying\": \"Pas de s\échoir\", \"Ironing\": \"110\°\", \"CompositionList\": \"100% coton biologique fil\é et peign\é\", \"ConstructionList\": \"Jersey simple\", \"FinishList\": \"Tissu lav\é\", \"SundryList\": \"\", \"Gauge\": 0.0, \"Weight\": 180.0, \"GOTS\": 1, \"OCS100\": 0, \"OCSBlended\": 0, \"Ecotex\": 1, \"Fairwear\": 1, \"CarbonNeutral\": 0, \"FSC\": 0, \"REACH\": 0, \"WeigthPerUnit\": 0.12, \"PiecesPerBox\": 100, \"HalfChest\": 43.5, \"BodyLength\": 64.0, \"SleeveLength\": 19.0, \"Width\": 0.0, \"Length\": 0.0, \"StrapLength\": 0.0, \"Waist\": 0.0, \"Tight\": 0.0, \"TotalLegLength\": 0.0, \"HSCode\": \"61091000\", \"K3EUR\": \"\", \"K15EUR\": \"\", \"K30EUR\": \"\", \"K50EUR\": \"\", \"K100EUR\": \"\", \"Price<10 EUR\": 5.25, \"Price>10 EUR\": 5.25, \"Price>50 EUR\": 4.95, \"Price>100 EUR\": 4.7, \"Price>250 EUR\": 4.4, \"Price>500 EUR\": 4.15, \"Price>1000 EUR\": 3.95, \"K3GBP\": \"\", \"K15GBP\": \"\", \"K30GBP\": \"\", \"K50GBP\": \"\", \"K100GBP\": \"\", \"Price<10 GBP\": 4.45, \"Price>10 GBP\": 4.45, \"Price>50 GBP\": 4.25, \"Price>100 GBP\": 4.0, \"Price>250 GBP\": 3.75, \"Price>500 GBP\": 3.55, \"Price>1000 GBP\": 3.35, \"SKU_Start_Date\": \"2019-01-01\", \"Published\": 1, \"PiecesPerPolybag\": 5, \"FitID\": \"9\", \"GenderID\": \"13\", \"CategoryID\": \"18\", \"TypeID\": \"30\", \"NecklineID\": \"11\", \"SleeveID\": \"10\", \"SequenceStyle\": 6300, \"NewStyle\": 0, \"NewProduct\": 0, \"NewItem\": 0, \"NewColor\": 0, \"NewSize\": 0, \"ColorSequence\": 2, \"ColorGroupSequence\": 0, \"SizeSequence\": 10, \"StylePublished\": true, \"MainPicture\": \"https://res.cloudinary.com/www-stanleystella-com/t_pim/TechnicalNames/SFM0_STTU755_C037.jpg\", \"StyleSegment\": \"ICONIC\", \"ProductLifecycle\": \"Permanent\", \"CountryOfOrigin\": \"BD\", \"CategoryCode\": \"TEES\", \"TypeCode\": \"T-SHIRT\", \"GRS\": 0, \"VEGAN\": 1, \"GOTS85\": 0, \"Thickness\": false, \"ShellWeight\": 0.0, \"PaddingComposition\": \"\", \"PaddingConstruction\": \"\", \"PaddingFinishing\": \"\", \"PaddingWeight\": 0.0, \"LiningComposition\": \"\", \"LiningConstruction\": \"\", \"LiningFinishing\": \"\", \"LiningWeight\": 0.0, \"Layer4Name\": \"\", \"Layer4Composition\": \"\", \"Layer4Construction\": \"\", \"Layer4Finishing\": \"\", \"Layer4Weight\": 0.0, \"Layer5Name\": \"\", \"Layer5Composition\": \"\", \"Layer5Construction\": \"\", \"Layer5Finishing\": \"\", \"Layer5Weight\": 0.0, \"StyleNotice\": \"Convient \à toute technique d'impression. Visitez notre site web pour plus d'informations.\", \"WashInstructions\": \"Laver avec des couleurs similaires, ne pas repasser sur l'imprim\é, laver et repasser sur l'envers.\", \"WashInstructionsAdditions\": \"0\", \"Specifications\": \"\" }
]"
}
Fields from "products" explained
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
}, ...
]
}
]"
}