This new web service lets you download your specific purchase prices and the recommended sales prices of our products.

Each customer account is linked to one specific pricelist. We use this link to provide your specific purchase prices.

The data is provided through one endpoint: get_prices

This webservice is very similar to the other web services in our API's. Therefore:

• Method to be used is POST

• Encoding is UTF-8

• 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.

Endpoint Settings

Environment	Server	Database
PROD	https://api.stanleystella.com	production_api

Get JSON

Service	URL
Get Prices	/webrequest/products/get_prices

JSON format as input  

Submit this JSON message as input. There are no filters possible on this call.

{
    "jsonrpc":"2.0",
    "method":"call",
    "params":{
        "db_name":"production_api",
        "password":"YOUR_PASSWORD",
        "user":"YOUR_LOGIN"
    },
    "id":0
}

JSON format as output

The following JSON is the output of the call.

{
    "jsonrpc": "2.0", 
    "id": 0, 
    "result": "[
        {
            \"B2BSKUREF\": \"STSW131C002XS\", 
            \"PurchasePriceList\": \"K120 (EUR)\", 
            \"PurchasePrice\": 14.5,
            \"DiscountPct\": 0.0,
            \"RecommendedSalesPriceGT10pcs\": 27.55,
            \"RecommendedSalesPriceGT100pcs\": 24.65,
            \"RecommnededSalesPriceGT500pcs\": 21.75,
            \"RecommendedSalesPriceGT1000pcs\": 20.75
            \"RecommendedSalesSmallBrand\": 6.45,
            \"RecommendedSalesMediumBrand\": 5.35
        }, 
        ...
    ]"
}

PHP code example with curl

Here is an example of PHP code used to call the Prices JSON/REST service. This code is given as illustration.

$url = "https://api.stanleystella.com/webrequest/products/get_prices";
$jsonData = array(
    'jsonrpc' => '2.0',
    'method' => 'call',
    'params' => array(
        'db_name' => "production_api",
        'password' => "YOUR_PASSWORD",
        'user' => "YOUR_LOGIN",
    ),
    'id' => 0
);
$ch = curl_init($url);
$jsonDataEncoded = json_encode($jsonData);
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, $jsonDataEncoded);
curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: application/json'));
$result = curl_exec($ch);
$jsonDataDecoded = json_decode($result)->result;
curl_close($ch);

Download prices in CSV file

If you prefer to work with a CSV file, here is a PHP code that will let you download products data and prices and combine them in a useful CSV file.

<?php
ini_set("memory_limit","256M");
ini_set("max_execution_time",9000);
ini_set('default_charset', 'utf-8');
header('Content-Type: text');

$allproducts = getAllSTSTProducts();
$allprices = getPurchasePrices();


$fp = fopen('pricelist_output.csv', 'w');
$r = array();
$r["B2BSKUREF"] = "B2BSKUREF";
$r["StyleCode"] = "Style code";
$r["StyleName"] = "Style";
$r["ColorCode"] = "Color code";
$r["ColorName"] = "Color";
$r["SizeCode"] = "Size code";
$r["SizeName"] = "Size";
$r["PurchasePrice"] = "PurchasePrice";
$r["RecommendedSalesPriceGT10pcs"] = "RecommendedSalesPriceGT10pcs";
$r["RecommendedSalesPriceGT50pcs"] = "RecommendedSalesPriceGT50pcs";
$r["RecommendedSalesPriceGT100pcs"] = "RecommendedSalesPriceGT100pcs";
$r["RecommendedSalesPriceGT250pcs"] = "RecommendedSalesPriceGT250pcs";
$r["RecommendedSalesPriceGT500pcs"] = "RecommendedSalesPriceGT500pcs";
$r["RecommendedSalesPriceGT1000pcs"] = "RecommendedSalesPriceGT1000pcs";
fputcsv($fp, $r, ";");


foreach ($allprices as $sku) {
    $r = array();
    $r["B2BSKUREF"] = $sku->B2BSKUREF;
    $key = array_search($sku->B2BSKUREF, array_column($allproducts, 'B2BSKUREF'));
    $r["StyleCode"] = $allproducts[$key]["StyleCode"];
    $r["StyleName"] = $allproducts[$key]["StyleName"];
    $r["ColorCode"] = $allproducts[$key]["ColorCode"];
    $r["ColorName"] = $allproducts[$key]["Color"];
    $r["SizeCode"] = $allproducts[$key]["SizeCodeNavision"];
    $r["SizeName"] = $allproducts[$key]["SizeCode"];
    $r["PurchasePrice"] = $sku->PurchasePrice;
    $r["RecommendedSalesPriceGT10pcs"] = $sku->RecommendedSalesPriceGT10pcs;
    $r["RecommendedSalesPriceGT50pcs"] = $sku->RecommendedSalesPriceGT50pcs;
    $r["RecommendedSalesPriceGT100pcs"] = $sku->RecommendedSalesPriceGT100pcs;
    $r["RecommendedSalesPriceGT250pcs"] = $sku->RecommendedSalesPriceGT250pcs;
    $r["RecommendedSalesPriceGT500pcs"] = $sku->RecommendedSalesPriceGT500pcs;
    $r["RecommendedSalesPriceGT1000pcs"] = $sku->RecommendedSalesPriceGT1000pcs;
    fputcsv($fp, $r, ";");
}


fclose($fp);


function getAllSTSTProducts() {
    $url = "https://api.stanleystella.com/webrequest/products/get_json";
    $jsonData = array(
        'jsonrpc' => '2.0',
        'method' => 'call',
        'params' => array(
            'db_name' => "production_api",
            'password' => YOUR_PASSWORD,
            'user' => YOUR_LOGIN,
            "LanguageCode" => "en_US"
        ),
        'id' => 0
    );

    $ch = curl_init($url);
    $jsonDataEncoded = json_encode($jsonData);

    curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
    curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
    curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
    curl_setopt($ch, CURLOPT_POST, 1);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $jsonDataEncoded);
    curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: application/json'));
    $result = curl_exec($ch);
    
    $jsonDataDecoded = json_decode(json_decode($result)->result, true);
    curl_close($ch);

    return $jsonDataDecoded;
}

function getPurchasePrices() {
    $url = "https://api.stanleystella.com/webrequest/products/get_prices";
    $jsonData = array(
        'jsonrpc' => '2.0',
        'method' => 'call',
        'params' => array(
            'db_name' => "production_api",
            'password' => YOUR_PASSWORD,
            'user' => YOUR_LOGIN
        )
    );

    $ch = curl_init($url);
    $jsonDataEncoded = json_encode($jsonData);

    curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
    curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
    curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
    curl_setopt($ch, CURLOPT_POST, 1);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $jsonDataEncoded);
    curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: application/json'));
    $result = curl_exec($ch);
    
    $r = json_decode($result);
    curl_close($ch);
    return $r->result;
}