F&R
Webservice Interfaces
Date: 24.09.2024
Document Version: 1.22
1. F&R Article / Master Data
a. in format XML
b. in format CSV
2. F&R Stock Data
3. F&R Article Delivery Dates
4. F&R Prices
5. Falk&Ross Order Interface
6. F&R Order Status and Tracking
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 2 -
1. F&R Article / Master Data
Date: 24.09.2024
XML Version: R000-011
Document Version: 1.4
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 3 -
History of changes:
Date: Description
2024-02-29 If available from Version R000-012
color codes in HEX, RGB, CMYK and
Pantone are included.
2023-11-08 Added meta tag <style_nr_dot>
herein you can find the style number
in format [Link]
2023-11-01 Current version R000-011
Added packaging unit
2018-07-10 Current version R000-009
General remarks:
An import of all Falk&Ross article master data has been possible for several years. The Excel
file has been updated and expanded with new data and data fields throughout the past
years, maximum compatibility was of paramount importance. This Excel file is still available
for download.
In addition, from now on, we offer a simplified way of importing our master data by using
XML files. The file content is updated and expanded on a daily base on our servers.
How does the XML import work?
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 4 -
We have defined two separate XML file formats. With the main format, you can download
basic information across the complete range of Falk&Ross styles. This file contains the full
range of articles available at Falk&Ross. Within this file we provide links for you to fetch
detailed article data per style as needed.
The complete article list file [[Link]]:
a. In format XML
You can download the complete style list in the current XML version (historic versions of the
file are also available, explained on page 8) by using the following link:
[Link]
In this file, you will find basic information for the full range articles available at Falk&Ross. You
need to parse the XML data and download detailed style data separately. You can find The link
to download the detailed style data per article within the XML TAG <url_style_xml> .
…
<style>
<style_nr>99633</style_nr>
<style_aid>o70b459a30b316b36d86118f33161616</style_aid>
<url_style_xml>[Link]
</style>
…
[Link]
for version: R000-010 / R000-011 / R000-012
General header information:
<style_list>…</style_list> Contains all necessary information to
download all detailed style data
<export_data_date>2018-07-09 Time stamp for these files´ creation
07:38:44</export_data_date>
<file_version>R000-009</file_version> Version of this XML file
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 5 -
<style_count>2611</style_count> Number of styles contained in this file
Style data:
<style>…</style> Contains important core information
per style.
<style_nr>99633</style_nr> Five-digit Falk&Ross style number for
style 99633
<style_aid> Falk&Ross internal code
o700242da6cac9f0bbd2987f1163ad8c
</style_aid>
<url_style_xml> Link to access the detailed style data
[Link] for style 99633
[Link]/ws/xml/[Link]</url_style_xml>
Accessing detailed style data:
The URL for downloading the detailed style data is contained in the
<url_style_xml> XML tag:
<url_style_xml>[Link]
Most of the xml tags used in the detailed data are self-explanatory.
XML tags explained:
[Link]
for version: R000-010 / R000-011 / R000-012
General header data:
<style_list>…</style_list> Contains detailed data for import into your IT
systems
<export_data_date>2018-07-09 07:38:44</export_data_date> Time stamp for these files creation
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 6 -
<file_version>R000-009</file_version> Version of this XML file
Style data:
<style>…</style> Contains all important information on the type
<style_nr>99633</style_nr> Five-digit Falk&Ross style number for style
99633
<style_catalog_page>502</style_catalog_page> Catalogue page number
<style_custom_tariff_nr> Commodity code or customs tariff
62105000 numbers/intrastat numbers.
</style_custom_tariff_nr>
<supplier_code>33</supplier_code> Falk&Ross supplier code
<supplier_article_code>R156X</supplier_article_code> Supplier article code
<brand_code>33</brand_code> Falk&Ross brand code
<brand_name>Result</brand_name> Brand name
Pictures:
<style_picture_list> List of pictures for this style
<style_picture> Single picture entry
<filename>996_33_101_m-2015_01.jpg</filename> File name
<shottype>m</shottype> Picture type: m=Model; f=Flat; b=Back
<pos>1</pos> Picture position in list
<url>[Link] URL to download this picture
2015_01.jpg</url>
</style_picture>
…
</style_picture_list>
Article linking:
<style_link_list> Articles these styles are linked to
<style_link_to><style>49633</style></style_link_to> Is linked to style 49633
…
</style_link_list>
Article Name:
<style_name> List of article names including translations
<language> Language presented as ISO 2 Code
<de>…</de> At this time, the following languages are
available:
de;en;fr;es;hu;pl;nl;cz;sk;ro;pt;hr;se;dk
<en>…</en>
<fr>…</fr>
…
</language>
</style_name>
Article description:
<style_description> Descriptive texts for the style
<language> Language presented as ISO 2 Code
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 7 -
<de>…</de> At this time, the following languages are
available:
de;en;fr;es;hu;pl;nl;cz;sk;ro;pt;hr;se;dk
<en>…</en>
<fr>…</fr>
…
</language>
</style_description>
<style_searchkeys> Search terms including translations
<language> Language presented as ISO 2 Code
<de>…</de> At this time, the following languages are
available:
de;en;fr;es;hu;pl;nl;cz;sk;ro;pt;hr;se;dk
<en>…</en>
<fr>…</fr>
…
</language>
</style_searchkeys>
Categories and subcategories
<style_category_list> List of categories
<style_category_main>Products Main category, in English language only
<style_category_sub> Subcategory
<language> Language presented as ISO 2 Code
<de>Hosen</de> At this time, the following languages are
available:
de;en;fr;es;hu;pl;nl;cz;sk;ro;pt;hr;se;dk
<en>Trousers/en>
<fr>…</fr>
…
</language>
</style_category_sub>
… Multiple subcategories can be listed
<style_category_sub>…</style_category_sub>
</style_category_main>
</style_category_list>
Article filters:
<style_filter_list> List of filters
<style_color_group_list> List of colour groups
<style_color_group>Black</style_color_group> Colour group
…
<style_color_group>Dark Blue</style_color_group>
</style_color_group_list>
<style_gender_group_list> Gender
<style_gender_group>unisex</style_gender_group> Unisex
…
<style_gender_group>men</style_gender_group> Male
</style_gender_group_list>
<style_weight_group_list></style_weight_group_list> Filter weight group
<style_details_group_list> Filter details group
<style_details_group>Wind-
/Rainjackets</style_details_group>
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 8 -
…
<style_details_group_list>
<style_sleeve_group_list> Filter sleeve group
<style_sleeve_group>Short-sleeved</style_sleeve_group>
<style_sleeve_group_list>
<style_sustainable_group_list> Filter Sustainable
<style_sustainable_group>
</style_sustainable_group>
</style_sustainable_group_list>
<style_certificate_group_list> Filter certificates
<style_certificate_group>
<en>
<![CDATA[ WRAP ]]>
</en>
<de>
<![CDATA[ WRAP ]]>
</de>
…
</style_certificate_group>
…
<style_certificate_group_list>
<style_benefit_group_list> Filter article benefit
<style_benefit_group>
<en>
<![CDATA[ 20+ colours ]]>
</en>
<de>
<![CDATA[ 20+ Farben ]]>
</de>
..
</style_benefit_group>
…
</style_benefit_group_list>
<style_rebrand_group_list> Filter Rebrandable
<style_rebrand_group>
<en>
<![CDATA[ Removable ]]>
</en>
<de>
<![CDATA[ Removable ]]>
</de>
…
</style_rebrand_group>
…
</style_rebrand_group_list>
<style_fabric_group_list> Filter fabric
<style_fabric_group>
<en>
<![CDATA[ Cotton ]]>
</en>
<de>
<![CDATA[ Baumwolle ]]>
</de>
…
</style_fabric_group>
…
</style_fabric_group_list>
<style_neckline_group_list> Filter neckline
<style_neckline_group>
<en>
<![CDATA[ Crew Neck ]]>
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 9 -
</en>
<de>
<![CDATA[ Crew Neck ]]>
</de>
…
<style_neckline_group>
…
<style_neckline_group_list>
Article SKU Information:
<sku_list> List of SKU variants
<sku> Variant
<sku_artnum>996331015</sku_artnum> 9-digit Falk&Ross article number = SKU
<sku_color_code>101</sku_color_code> Falk&Ross colour code
<sku_color_name>Black</sku_color_name> Falk&Ross colour name
<sku_color_swatch>996_33_101.jpg</sku_color_swatch> Colour swatch file name
<sku_color_swatch_url>[Link] URL for color swatch download
[Link]/ws/picto/996_33_101.jpg</sku_color_swatch_url>
<sku_color_picture>996_33_101_f- File name for colorized images
2015_01.jpg</sku_color_picture>
<sku_color_picture_url>[Link] URL for picture download
[Link]/ws/picture/996_33_101_f-
2015_01.jpg</sku_color_picture_url>
<sku_size_code>5</sku_size_code> Falk&Ross size code
<sku_size_name>L/XL</sku_size_name> Falk&Ross size name
<sku_size_order>5</sku_size_order> Sequence of sizes
<sku_changed_date>2018-07-04</sku_changed_date> Time stamp for last change
<sku_closeout>0</sku_closeout> Closeout ?: 1=yes; 0=no
<sku_new>0</sku_new> New ?: 1=yes; 0=no
<sku_ean>5055192307968</sku_ean> GTIN number
<sku_weight>0.34</sku_weight> Weight in kilograms
<sku_coo>CN</sku_coo> Country of Origin
<sku_pieces_in_pack>10</sku_pieces_in_pack> Packaging units - available starting with XML
version R000-010
<sku_pieces_in_carton>150</sku_pieces_in_carton> Packaging units - available starting with XML
version R000-010
<sku_supplier_artnr>969590020</sku_supplier_artnr> Unique Supplier Code on SKU level
<sku_cc_list> Color codes list
<cc_hex> If available color codes in HEX
<hex_1/><hex_2/><hex_3/>
</cc_hex>
<cc_cmyk> If available color codes in CMYK
<cmyk_1/><cmyk_2/><cmyk_3/>
</cc_cmyk>
<cc_rgb> If available color codes in RGB
<rgb_1/><rgb_2/><rgb_3/>
</cc_rgb>
<cc_pan> If available color codes in Pantone
<pan_1/><pan_2/><pan_3/>
</cc_pan>
</sku_cc_list> Color codes list end
</sku>
…
<sku>…</sku>
…
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 10 -
</sku_list>
</style>
</style_list>
Import of all articles in formal XML only by one Server
Request
If you would like to import all style information only by one server request please use the URL
below:
[Link]
If you would like to download the same XML information only by one server request in a more
compacted format then please use the URL below:
[Link]
The structure of the exported xml data is the same as for only one style. The xml tag
for one style is embedded by the xml TAG <style_list><style>… Style details
information…</style>…</style_list>. The available data is updated on a daily base.
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 11 -
How we handle changes in the XML file´s structure in a new
version:
Changes may be made to the XML exports file´s structure with a new version, possibly
preventing your current setup from importing successfully. Because of that, when we modify
the XML file structure, we also update the XML file´s version.
To avoid compatibility issues on your side, we always provide previous versions of the XML file
for continuing use. To use this feature, you have to modify the download URL of the complete
article list file to use the version specific one as shown below. If you have implemented your
import setup with a specific version of the XML export in the past, please continue to use the
version specific link.
XML Version: Version: URL:
11 R000-011 [Link]
10 R000-010 [Link]
Always the current Current [Link] oder
version version [Link]
When using a version specific XML file, you will find the correct, version specific link to the
detailed article information within the <url_style_xml>…</url_style_xml> XML TAG, making sure
import of this information continues to function with a version specific setup. If you wish to
access new or added article details or data, you may need to upgrade to an updated XML file
version. This may make changes to your import setup necessary because of changes in XML
exports file structure.
We ask you to take this into account in your implementation.
All included article information continues to be updated for all supported version specific XML
files.
Please let us know about your wishes and suggestions concerning the XML article data
import by contacting us at:
it-business@[Link]
We look forward to your suggestions and the joint implementation of your wishes and
suggestions for improvement.
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 12 -
The complete article list file [[Link]]:
b. In format CSV
Datum: Beschreibung
29.02.2024
Starting from Version R000-012 the export of needed data for the article
names and article descriptions is possible in the different languages. You only
need to use in your URL the parameter lang:
lang=de oder lang=en ; lang = 2 digit country iso code
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 13 -
General remarks:
An Excel and XML-based master data import of all Falk&Ross article master data has already
been possible for several years. Now it is also possible to export parts of the existing data in
CSV format. This exported data is suitable for direct import into various ERP or webshop
systems. A semicolon is used as a separator for the export CSV data.
The master data can be exported in CSV format using the following URL. The specification of
style is possible as an additional parameter. If this parameter is empty, all articles are exported,
otherwise only the specified style. If further translations are required for the import, this is only
possible via the full XML export und 1.a.
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 14 -
https:// webservice_kennung:webservice_passwort@[Link]-
[Link]/ws/run/[Link]?action=get_article_csv&style=
for Version: run or R000-011 / R000-012
General Head information:
FR_Sku 9 digit Falk&Ross article number
FR_Style 5 digit Falk&Ross style number
Supplier_Style Supplier Style Number
Supplier_Sku Supplier sku number if available
Gtin Gtin code if available
Country_Origin 2 Digit Iso Code country of origin
Style_Name Style Name
Brand Brand
Colour Colour name
Size Size
Size_Order Order of size
Pu_Pack Package quantities in pieces
Pu_Carton Carton quantities in pieces
Weight_kg Weight Sku in kg
Catalogue_Page Catalogue page
Commodity_Code Commodity code
Picture_1; Picture_2; Picture_3 Link Style Product pictures directly
downloadable
Colour_swatch Link Sku Colour Swatches directly
downloadable
Price Your purchaising prices
Currency Your currency
FR_Style_dot Since Version R000-012: 5 digit F&R Style
number point included
Lang_IsoCode Since Version R000-012: 2 digit country
iso code for article name and decription
FR_Description Since Version R000-012: F&R Article
description. Special character | replaces
a normal line break.
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 15 -
For example:
FR_Sku;FR_Style;Supplier_Style;Supplier_Sku;Gtin;Country_Origin;Name;Brand;
Colour;Size;Size_Order;Pu_Pack;Pu_Carton;Weight_kg;Catalogue_Page;Commodity
_Code;Picture_1;Picture_2;Picture_3;Colour_Swatch;Price;Currency
670571010;67057;3842-1LH;;5055650853822;PK;Cotton Tote Single Handle;SG
Accessories - BAGS (Ex JASSZ Bags);Black;One
Size;0;25;250;0.06;517;42029298;[Link]
[Link]/ws/picture/670_57_008_m-2023_01.jpg;[Link]
[Link]/ws/picture/670_57_008_m-2023_02.jpg;[Link]
[Link]/ws/picture/670_57_008_d-2023_01.jpg;[Link]
[Link]/ws/picto/670_57_101.jpg;[Link];EUR
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 16 -
2. F&R Stock Data
Date: 30.04.2020
XML Version: V3
Document Version: 1.1
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 17 -
History of changes:
Datum: Beschreibung
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 18 -
General remarks:
This interface allows you to query the stock levels of our article range and process this
data for use with your own systems. It is possible, depending on URL used, to query
stock levels for all styles at once or individual styles as needed. The exported data is
created dynamically and updated at a defined interval across all systems involved in
the process.
How does the stock level import work?
By querying URL´s with a defined set of parameters you can access and export our
stock level data both in CSV and XML formats for processing in your own systems. This
process also enables automation of data exchange in between your systems and our
systems concerning stock levels.
Stock level data in XML format:
You can fetch and process our stock levels using the current XML version (historic
versions of the file are also available, explained on page XX) by using the following link:
[Link]
[Link]/webservice/R03_000/stockinfo/falkross_de.xml
The placeholders webservice_account and webservice_password need to be replaced
with your personal Falk&Ross webservices login credentials, take note that these are
different from your Falk&Ross webshop login credentials.
Data accessed by using this link is structured like this:
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 19 -
Output:
<product>
<product_variant>
<SKU>023051623</SKU>
<g><Flag>=</Flag><Quantity>144</Quantity></g>
<y><Flag>=</Flag><Quantity>0</Quantity></y>
<b><Flag>=</Flag><Quantity>1000</Quantity></b>
</product_variant>
…
</product>
XML tags explained :
<product>
<product_variant> Start tag for the product variant (=SKU).
<SKU>023051623</SKU> 9-digit Falk&Ross article number.
<Flag> It is possible to set a customer specific
threshold value for maximum stock shown
– if there are more items in stock than the
threshold value, not the actual quantity, but
the threshold value will be listed.
<Quantity>144</Quantity> Quantity in stock
<g> Start tag for stock code „green“
<y> Start tag for stock code „yellow“
<b> Start tag for stock code „blue“
Additional parameters in the URL are:
product: by adding this parameter to the URL, you can only fetch stock data for specific
items only. The truncation mark “_” may be used starting from the 6th digit of the 9-
digit article number.
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 20 -
[Link]
[Link]/webservice/R03_000/stockinfo/product/18001___5?format=
xml
Output:
<product> Stock data is listed for items
<product_variant>
<SKU>180010005</SKU> matching the 18001___5 article
<g><Flag>=</Flag><Quantity>851</Quantity></g> number, in XML format as by the
<y><Flag>=</Flag><Quantity>0</Quantity></y> parameters in the called URL.
<b><Flag>=</Flag><Quantity>1512</Quantity></b>
</product_variant>
<product_variant>
<SKU>180011015</SKU>
<g><Flag>=</Flag><Quantity>2615</Quantity></g>
<y><Flag>=</Flag><Quantity>0</Quantity></y>
<b><Flag>=</Flag><Quantity>2448</Quantity></b>
</product_variant>
…
XML tags explained :
<product>
<product_variant> Start tag for the product variant
(=SKU).
<SKU>023051623</SKU> 9-digit Falk&Ross article number
<Flag> It is possible to set a customer
specific threshold value for
maximum stock shown – if there
are more items in stock than the
threshold value, not the actual
quantity, but the threshold value
will be listed.
<Quantity>144</Quantity> Quantity in stock
<g> Start tag for stock code „green“
<y> Start tag for stock code „yellow“
<b> Start tag for stock code „blue“
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 21 -
Stock level data in CSV format:
You can fetch and process our stock levels using the current CSV version (historic
versions of the file are also available, explained on page XX) by using the following link:
[Link]
[Link]/webservice/R03_000/stockinfo/falkross_de.csv
The placeholders webservice_account and webservice_password need to be replaced
with your personal Falk&Ross Webservices credentials.
Data accessed by using this link is structured like this:
Output:
2020-04-30 08:51:11
023051623;144;0;1000
110331217;351;0;1000
687282010;58;0;0
706671014;1;0;0
548427007;151;0;450
485182023;13;0;0
The first line contains the time stamp for this export.
Column Description
1. 9-digit Falk&Ross article number
2. Corresponds to the „green“ stock level in the Falk&Ross webshop.
3. Corresponds to the „yellow“ stock level in the Falk&Ross webshop.
4. Corresponds to the „blue“ stock level in the Falk&Ross webshop.
It is possible to set a customer specific threshold value for maximum stock shown – if there are
more items in stock than the threshold value, not the actual quantity, but the threshold value
will be listed.
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 22 -
Additional parameters in the URL are:
product: As with the XML format shown above - by adding this parameter to the URL,
you can only fetch stock data for specific items only. The truncation mark “_” may be
used starting from the 6th digit of the 9-digit article number.
[Link]
[Link]/webservice/R03_000/stockinfo/product/18001___5?format=csv
Output:
2020-04-30 09:03:47
180010005;851;0;1512
180011015;2614;0;2448
180011235;903;0;1728
180012005;1167;0;5616
180013005;0;0;0
180014005;0;0;0
Stock data is listed for items matching the 18001___5 article number, in XML format as by the parameters
in the called URL.
The first line contains the time stamp for this export.
Column Description
1. 9-digit Falk&Ross article number
2. Corresponds to the „green“ stock level in the Falk&Ross webshop.
3. Corresponds to the „yellow“ stock level in the Falk&Ross webshop.
4. Corresponds to the „blue“ stock level in the Falk&Ross webshop.
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 23 -
A Code example for the PHP programming language:
<?php
// REMARK: XML needs to be encoded in UTF-8 !
// your webservice login
$user = "";
// your webservice password
$pass = "";
$auth = base64_encode($user . ':' . $pass);
$params = array(
'http' => array(
'method' => 'POST',
'user_agent' => 'PHP 5;',
'header'=> "Content-type: application/x-www-form-urlencoded\r\n" .
"Content-Length: " . 0 . "\r\n" .
"Cache-Control: no-cache\r\n" .
"Connection: close\r\n" .
"Authorization: Basic $auth \r\n",
'content' => "" )
);
$context = stream_context_create($params);
// REMARK: - to use HTTPS, extension=php_openssl.dll needs to be enabled in [Link] !!!
$xmlresponse = "";
$fp = fopen('[Link] . "$user" . ':' . "$pass" . '@[Link]-
[Link]/webservice/R03_000/stockinfo/product/10209?format=xml', 'r');
// example for getting stock of all our articles only using one request
if ($fp) {
while (!feof($fp))
{
$xmlresponse .= fgets($fp,128);
}
fclose($fp);
echo $xmlresponse;
?>
In order to use the stock data, pricing data and order status/order tracking features, you
need login credentials for the Falk&Ross webservices, take note that these are different from
your usual Falk&Ross webshop login credentials. In the code example, you would need to
replace the $user variable with your webservices account name and $pass with the
corresponding password.
The varible $xmlresponse will receive the exported data, depending on which URL has been
defined for the variable $fp – article, stock, prices or status information. The received data
can then be processed as needed.
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 24 -
How we handle changes in the XML or CSV file´s structure in
a new version for the stock data interface:
Changes may be made to the XML or CSV export format on new versions, possibly preventing
your current setup from importing successfully. Because of that, when we modify the export
format, we also update the version.
To avoid compatibility problems on your side, we always provide previous versions of both
exports for continuing use.
XML Version: Version: Url:
1 R001-000 [Link]
3 R003-000 [Link]
CSV Version: Version: Url:
1 R001-000 [Link]
3 R003-000 [Link]
Please let us know about your wishes and suggestions concerning the Stock data interface by
contacting us at:
it-business@[Link]
We look forward to your suggestions and the joint implementation of your wishes and
suggestions for improvement.
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 25 -
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 26 -
3. F&R Article Delivery Dates
Date: 23.11.2022
XML Version: since R000-010
Document version: 1.1
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 27 -
History of changes:
Date: Description:
12.08.2022 Export of delivery dates
in format csv and xml is possible
since version R000-010
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 28 -
General remarks:
By this interface it’s possible to get some more information about delivery dates of
our articles .You can get in format CSV and XML the delivery dates of any sku of your
primary assigned warehouse.
How does the pricing interface work?
By using different URL´s with a defined set of parameters you can access and export
the delivery dates in format CSV and XML format. This process also enables
automation of data exchange between your systems and our systems concerning
delivery dates.
Delivery Dates Information in XML format:
You can fetch and process your delivery dates information using since the XML version
R000-011 by using the following link:
[Link]
[Link]/ws/run/[Link]?format=xml&s&action=get_deliveries
The placeholders webservice_account and webservice_password need to be replaced
with your personal Falk&Ross Webservices credentials.
Data accessed by using this link is structured like this:
Output:
<delivery_list>
<export_data_date>2022-05-24
09:28:15</export_data_date>
<file_version>R000-010</file_version>
<deliveries>
<item>
<sku>102090000</sku>
<date>2022-07-14</date>
<qty>730</qty>
<free_to_sell_qty>730</free_to_sell_qty>
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 29 -
</item>
<item>
<sku>102090003</sku>
<date>2022-07-16</date>
<qty>735</qty>
<free_to_sell_qty>700</free_to_sell_qty>
</item>
…
<item>
<sku>102090005</sku>
<date>2022-07-13</date>
<qty>730</qty>
<free_to_sell_qty>730</free_to_sell_qty>
</item>
</deliveries>
</delivery_list>
XML tags explained :
<export_data_date> Timestamp Export Date in ISO Format
<file_version> Version of the interface possible since R000-
010
<sku> 9 digit F&R article number
<date> Delivery date
<qty> Delivery quantity
<free_to_sell_qty> Qantity free to sell on delivery date
Additional parameters in the request URL are:
style: Allows you to export delivery dates for a single style or sku only. If no value was
set for style, delivery dates for all styles or skus are exported. If a query for a style with
no associated data is performed, you will receive an error message:
Output:
<error>
<error_code>100</error_code>
<error_msg>no
data</error_msg>
</error>
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 30 -
Delivery Dates Information in CSV format:
You can fetch and process your delivery dates information using the current CSV version
by using the following link:
[Link]
[Link]/ws/run/[Link]?format=csv&&action=get_price
The placeholders webservice_account and webservice_password need to be replaced
with your personal Falk&Ross webservices credentials.
Data accessed by using this link is structured like this:
Output:
sku;delivery_date;qty
102090000;2022-07-14;730
102090003;2022-07-16;735
102090009;2022-07-14;730
102091010;2022-06-10;500
102091010;2022-06-14;630
sku 9-digit Falk&Ross article number
delivery date Delivery date
qty Delivery quantity
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 31 -
Additional parameters in the request URL are:
style: Allows you to export your delivery dates for a single style or sku only. If no value
was set for style, purchase prices for all styles are exported. If a query for a style with
no associated data is performed, you will receive an error message:
Output:
<error>
<error_code>100</error_code>
<error_msg>no
data</error_msg>
</error>
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 32 -
How we handle changes in the XML file´s structure in a new
version:
Changes may be made to the XML file´s structure with a new version, possibly preventing your
current setup from importing successfully. Because of that, when we modify the XML file
structure, we also update the xml file´s version.
To avoid compatibility problems on your side, we always provide previous versions of the XML
file for continuing use. To use this feature, you have to modify the download URL for the file to
use the version specific one as shown below. If you have implemented your import setup with
a specific version of the XML file in the past, please continue to use the version specific link.
XML Version: Version: Url:
11 R000-011 [Link]
011/[Link]?action=get_deliveries
10 R000-010 Not possible you’ll get an error message
Always the current Current [Link]
version Version
The XML tag <file_version>…</file_version> contains the version of the XML file, making sure
import continues to work when you need to use a historic version of the export. If new data
was introduced to the export, you may have to upgrade to a higher version of the export/file
if you intend to process the additional data. This may make changes to your import setup
necessary because of changes in XML file structure.
We ask you to take this into account in your implementation.
Please let us know about your wishes and suggestions concerning the price interface by
contacting us at:
it-business@[Link]
We look forward to your suggestions and the joint implementation of your wishes and
suggestions for improvement.
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 33 -
4. F&R Prices
Date: 23.01.2020
XML Version: R000-010
Document version: 1.1
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 34 -
History of changes:
Date: Description:
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 35 -
General remarks:
You can use our Customer Service Portal MyAccount (accessible from the Falk&Ross
webshop) to get your current price lists in 2 different formats by E-Mail. However, this
process is not suitable for automated data synchronization.
In addition to the MyAccount Portal, you may also ask your responsible Falk&Ross
Sales Team for our so-called SKU-File, an Excel file which also holds your pricing
information.
The best way to automate importing pricing information to your systems is using our
webservices, as described below.
How does the pricing interface work?
By querying URL´s with a defined set of parameters you can access and export your
pricing information both in CSV and XML formats for processing in your own systems.
This process also enables automation of data exchange in between your systems and
our systems concerning pricing information.
Pricing Information in XML format:
You can fetch and process your pricing information using the current XML version
(historic versions of the file are also available, explained on page XX) by using the
following link:
[Link]
[Link]/ws/run/[Link]?format=xml&style=&action=get_price
The placeholders webservice_account and webservice_password need to be replaced
with your personal Falk&Ross Webservices credentials.
Data accessed by using this link is structured like this:
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 36 -
Output:
<price_list>
<export_data_date>2020-01-22
11:34:20</export_data_date>
<file_version>R000-009</file_version>
<currency>EUR</currency>
<exchange_rate>1</exchange_rate>
<sku_list>
<sku>
<sku_nr>102090000</sku_nr>
<default_price>2.66</default_price>
<your_price>2.49</your_price>
</sku>
<sku>
<sku_nr>102090003</sku_nr>
<default_price>1.94</default_price>
<your_price>1.83</your_price>
</sku>
<sku>
<sku_nr>102090004</sku_nr>
<default_price>1.94</default_price>
<your_price>1.83</your_price>
</sku>
…
</sku_list>
</price_list>
XML tags explained :
<export_data_date> Time stamp of the export in ISO format
<file_version> Interface version used (version R000-009 in
this case)
<currency> Currency set for your account
<exchange_rate> Currency exchange rate
<sku_nr> 9-digit Falk&Ross article number
<default_price> Calculated default price
<your_price> your purchase price
Additional parameters in the request URL are:
style: Allows you to export your purchase price for a single style only. If no value was
set for style, purchase prices for all styles are exported. If a query for a style with no
associated data is performed, you will receive an error message:
Output:
<error>
<error_code>100</error_code>
<error_msg>no
data</error_msg>
</error>
nopromo: If set to 1, only price information for articles that are not flagged as
promotional in our webshop is exported.
ndp: If set to 1, exporting the default price is suppressed.
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 37 -
[Link]
[Link]/ws/run/[Link]?format=xml&style=&action=get_price&ndp=
1
Output:
<price_list>
<export_data_date>2020-01-22
11:34:20</export_data_date>
<file_version>R000-009</file_version>
<currency>EUR</currency>
<exchange_rate>1</exchange_rate>
<sku_list>
<sku>
<sku_nr>102090000</sku_nr>
<your_price>2.49</your_price>
</sku>
<sku>
<sku_nr>102090003</sku_nr>
<default_price>1.94</default_price>
<your_price>1.83</your_price>
</sku>
<sku>
<sku_nr>102090004</sku_nr>
<default_price>1.94</default_price>
<your_price>1.83</your_price>
</sku>
…
</sku_list>
</price_list>
XML tags explained :
<export_data_date> Time stamp of the export in ISO format
<file_version> Interface version used (version R000-009 in this
case)
<currency> Currency set for your account
<exchange_rate> Currency exchange rate
<sku_nr> 9-digit Falk&Ross article number
<your_price> Your purchase price
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 38 -
Pricing Information in CSV format:
You can fetch and process your pricing information using the current CSV version
(historic versions of the file are also available, explained on page XX) by using the
following link:
[Link]
[Link]/ws/run/[Link]?format=csv&style=&action=get_price
The placeholders webservice_account and webservice_password need to be replaced
with your personal Falk&Ross webservices credentials.
Data accessed by using this link is structured like this:
Output:
artnr;default_price;your_price;currency
102090000;2.66;2.49;EUR
102090003;1.94;1.83;EUR
…
art_nr 9-digit Falk&Ross article number
default_price Calculated default price
your_price Your purchasing price
Currency Currency set for your account
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 39 -
Additional parameters in the request URL are:
style: Allows you to export your purchase price for a single style only. If no value was
set for style, purchase prices for all styles are exported. If a query for a style with no
associated data is performed, you will receive an error message:
Output:
<error>
<error_code>100</error_code>
<error_msg>no
data</error_msg>
</error>
nopromo: If set to 1, only price information for articles that are not flagged as
promotional in our webshop is exported.
ndp: If set to 1, exporting the default price is suppressed.
[Link]
[Link]/ws/run/[Link]?format=csv&style=&action=get_price&ndp=
1
Output:
artnr;your_price;currency
102090000;2.49;EUR
102090003;1.83;EUR
…
art_nr 9-digit Falk&Ross article number
your_price Your purchasing price
Currency Currency set for your account
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 40 -
How we handle changes in the XML file´s structure in a new
version:
Changes may be made to the XML file´s structure with a new version, possibly preventing your
current setup from importing successfully. Because of that, when we modify the XML file
structure, we also update the xml file´s version.
To avoid compatibility problems on your side, we always provide previous versions of the XML
file for continuing use. To use this feature, you have to modify the download URL for the file to
use the version specific one as shown below. If you have implemented your import setup with
a specific version of the XML file in the past, please continue to use the version specific link.
XML Version: Version: Url:
10 R000-010 [Link]
9 R000-009 [Link]
Always the current Current [Link] …
version Version
The XML tag <file_version>…</file_version> contains the version of the XML file, making sure
import continues to work when you need to use a historic version of the export. If new data
was introduced to the export, you may have to upgrade to a higher version of the export/file
if you intend to process the additional data. This may make changes to your import setup
necessary because of changes in XML file structure.
We ask you to take this into account in your implementation.
Please let us know about your wishes and suggestions concerning the price interface by
contacting us at:
it-business@[Link]
We look forward to your suggestions and the joint implementation of your wishes and
suggestions for improvement.
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 41 -
5. Falk&Ross Order Interface
Date: 16.03.2021
XML Version: V2
Document Version: 1.2
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 42 -
History of changes :
Date: Version Description
16.3.2021 9 Ability to independently change the webservice mode
and check the status of my webservice accounts
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 43 -
General remarks:
The methods described in this chapter enable you to automate placing
orders by using the Falk&Ross webservices order interface. If all XML tags
have been filled correctly, you will in turn immediately receive your web
order number in the XML response file after your request has been
accepted.
How does the order interface work?
We have defined a XML file format with a set of data fields which need to
be completed by you with the appropriate data for your order. For
instance, these include: a different delivery address, your reference
number, comments to the order, notes to specific order items and the order
items with the corresponding quantity. The completed XML file then needs
to be transmitted to our webserver using a suitable method.
We have added a basic demonstration program at the end of this chapter
to show how an implementation could work.
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 44 -
Description of the XML file in the current version:
XML tag To be filled Remarks
in request
<?xml version="1.0" encoding="utf-8" X
standalone="yes"?>
<order> X
<orders_id /> Your webshop order
number on successful
order placement
<err />
<err_msg />
<request_date_time>2008-08-08 X Time Stamp of the
13:30:00</request_date_time> request in format YYYY-
MM-DD hh:mm:ss
<response_date_time>2008-08-08 Time Stamp of the
13:30:05</response_date_time> response in format
YYYY-MM-DD hh:mm:ss
<customers_number> X
<cn_value>132305</cn_value> X Your customer number
<cn_err />
<cn_err_msg />
</customers_number> X
<shipping_method> X
<sm_value>0</sm_value> X Shipping method. At this
time only „0“ (=as
agreed) is allowed.
<sm_err />
<sm_err_msg />
</shipping_method> X
<partial_shipment> X
<ps_value>0</ps_value> X Partial delivery ?
0=false;1=true
<ps_err />
<ps_err_msg />
</partial_shipment> X
<order_reference> X
<or_value><![CDATA[Bestellung 4711]]></or_value> X Corresponds to „Your
Reference“
when ordering using the
webshop. Limited to max.
32 characters
<or_err />
<or_err_msg />
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 45 -
</order_reference> X
<order_note> X
<on_value><![CDATA[ACHTUNG: Test Bestellung, bitte X Corresponds to
stornieren!!!]]></on_value> „Comments to your
order“
when ordering using the
webshop. Not limited in
length
<on_err />
<on_err_msg />
</order_note> X
<delivery_address> X
<da_is_different> X Differing delivery
address:
1=true; 0= false
If set to „false“, the
following address
information is discarded
and the deposited
address of the account
that placed the order is
used as delivery address
<da_value>true</da_value> X
<da_err />
<da_err_msg />
</da_is_different> X
<da_lastname> X
<da_value><![CDATA[Dodd]]></da_value> X Last name, limited to
max. 50 characters.
<da_err />
<da_err_msg />
</da_lastname> X
<da_firstname> X
<da_value> <![CDATA[]]></da_value> X First name, limited to
max. 50 characters.
<da_err />
<da_err_msg />
</da_firstname> X
<da_company> X
<da_value><![CDATA[Falk & Ross]]></da_value> X Company name, limited
to max. 50 characters.
<da_err />
<da_err_msg />
</da_company> X
<da_street_address> X
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 46 -
<da_value><![CDATA[Im Bruechel 10]]></da_value> X Street address, limited to
max. 50 characters.
<da_err />
<da_err_msg />
</da_street_address> X
<da_city> X
<da_value><![CDATA[Kaiserslautern]]></da_value> X City, limited to max. 50
characters.
<da_err />
<da_err_msg />
</da_city> X
<da_postcode> X
<da_value>67661</da_value> X Post code, limited to
max. 10 characters.
<da_err />
<da_err_msg />
</da_postcode> X
<da_country_code> X
<da_value>DE</da_value> X ISO country code, 2
characters.
<da_err />
<da_err_msg />
</da_country_code> X
</delivery_address> X
<product_list> X
<pl_err />
<pl_err_msg />
<product> X
<p_sku>180000002</p_sku> X 9-digit article number
<p_err /> If article number is
unknown, error code 30
is returned
<p_err_msg />
<p_lineref> x
<![CDATA[Ihre Bestellpositionsreferenz]]> x Your order item
reference, limited to max.
32 characters.
</p_lineref> x
<p_quantity> X
<pq_ordered>15</pq_ordered> X Quantity, integer number
<pq_err></pq_err>
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 47 -
<pq_err_msg></pq_err_msg>
</p_quantity> X
</product> X
<product> X
<p_sku>996011965</p_sku> X 9-digit article number
<p_err />
<p_err_msg />
<p_quantity> X
<pq_ordered>5</pq_ordered> X Quantity, integer number
<pq_err></pq_err>
<pq_err_msg></pq_err_msg>
</p_quantity> X
</product> X
</product_list> X
</order> X
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 48 -
URL for transmitting orders and demonstration program:
[Link]
Sending the order data works in the same way as transmitting a normal
HTML form. Please refer to the following demo program code on how
header information has to be filled and how you can authenticate yourself
accordingly. For this, you only have to set the variables $kunde, $user and
$pass to match your customer number and your webservice account
credentials.
In the demo program, the variable $xmlrequest contains an example order
for which the following has been set:
- order reference = „order reference 4711“
- comments to your order = „Attention: Test order, please cancel“
- no differing delivery address was used
- order item references „order item reference 1“ and
„order item reference 2“ were added for the articles
180000002 and 180000003, which are ordered in the quantity of 2 and
1 piece(s).
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 49 -
Demonstration program for order transmission in the PHP
programming language:
<?php TEST ORDER
// REMARK: XML needs to be encoded in UTF-8 !
// Your webservice account name
// Your webservice password
// Your customer number
$user = "";
$pass = "";
$kunde = "";
$xmlresponse="";
// Your order
$xmlrequest = '<?xml version="1.0" encoding="utf-
8"?><order><request_date_time></request_date_time><customers_n
umber><cn_value>$kunde</cn_value></customers_number><shipping_
method><sm_value>0</sm_value></shipping_method><partial_shipme
nt><ps_value>true</ps_value></partial_shipment><order_referenc
e><or_value><![CDATA[order reference
4711]]></or_value></order_reference><order_note><on_value><![C
DATA[Attention: Test order, please
cancel!!!]]></on_value></order_note><delivery_address><da_is_d
ifferent><da_value>false</da_value></da_is_different></deliver
y_address><product_list><product><p_sku>180000002</p_sku><p_li
neref><![CDATA[order item reference
1]]></p_lineref><p_quantity><pq_ordered>2</pq_ordered></p_quan
tity></product><product><p_sku>180000003</p_sku><p_lineref><![
CDATA[order item reference
2]]></p_lineref><p_quantity><pq_ordered>1</pq_ordered></p_quan
tity></product></product_list></order>';
// preparation of necessary header information
$auth = base64_encode($user . ':' . $pass);
$params = array(
'http' => array(
'method' => 'POST',
'user_agent' => 'PHP 5;',
'header'=> "Content-type: application/x-www-form-
urlencoded\r\n" .
"Content-Length: " . strlen($xmlrequest) .
"\r\n" .
"Cache-Control: no-cache\r\n" .
"Connection: close\r\n" .
"Authorization: Basic $auth \r\n",
'content' => $xmlrequest
)
);
$context = stream_context_create($params);
// REMARK: - to use HTTPS, extension=php_openssl.dll
// needs to be enabled in [Link] !!!
// - sadly readfile does not work with HTTPS,
// as a workaround we use fopen
$fp = fopen('[Link]
[Link]/webservice/R02_000/order?format=xml', 'r', false,
$context);
if ($fp) {
while (!feof($fp)) {
$xmlresponse .= fgets($fp,128);
}
fclose($fp);
}
echo $xmlresponse;
?>
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 50 -
If your webservice order cannot be processed by our system you will receive
the weborder number „0“. An error code and error description will be
placed in the corresponding XML error tag in the XML response file. In
addition, you will also find an error code and error description at the
location/XML Tag that caused the order to be rejected within the response
file.
Error codes:
Code Meaning Remarks
0 No error
10 General error
20 Generally invalid data
21 Data format invalid e.g. letter instead of integer number
e.g. max. number of characters
22 Invalid data length
exceeded
23 Mandatory data missing e.g. article number is missing
30 Object not found e.g. article number is non-existent
40 Access denied
41 Delivery block
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 51 -
Additional XML file examples:
Different delivery address and partial delivery enabled
<?xml version="1.0" encoding="utf-8"?>
<order>
<request_date_time/>
<customers_number>
<cn_value>$kunde</cn_value> Your customer number
</customers_number>
<shipping_method>
<sm_value>0</sm_value>
</shipping_method>
<partial_shipment>
<ps_value>true</ps_value>
Partial delivery = yes
</partial_shipment>
<order_reference>
<or_value>
<![CDATA[Referenzbeleg
4711]]>
</or_value>
</order_reference>
<order_note>
<on_value>
<![CDATA[ACHTUNG: Test
Bestellung, bitte stornieren!!!]]>
</on_value>
</order_note> Different delivery address = yes
<delivery_address> „1“ would also be valid
<da_is_different>
<da_value>true</da_value>
</da_is_different>
Different delivery address to:
<da_lastname>
<da_value><![CDATA[Nachname]]></da_value> Last name
<da_err />
<da_err_msg />
</da_lastname>
<da_firstname>
<da_value> <![Vorname]]></da_value> First name
<da_err />
<da_err_msg />
</da_firstname>
<da_company>
<da_value><![CDATA[Firmenname]]></da_value> Company name
<da_err />
<da_err_msg />
</da_company>
<da_street_address>
<da_value><![CDATA[Straße 1]]></da_value> Street address
<da_err />
<da_err_msg />
</da_street_address>
<da_city>
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 52 -
<da_value><![CDATA[Stadt]]></da_value> City
<da_err />
<da_err_msg />
</da_city>
<da_postcode>
<da_value>67661</da_value>
<da_err />
<da_err_msg />
</da_postcode>
<da_country_code>
<da_value>DE</da_value>
<da_err />
<da_err_msg />
</da_country_code>
</delivery_address>
<product_list>
<product>
<p_sku>180000002</p_sku>
<p_lineref>
<![CDATA[Ihre
Bestellpositionsreferenz 1]]>
</p_lineref>
<p_quantity>
<pq_ordered>2</pq_ordered>
</p_quantity>
</product>
<product>
<p_sku>180000003</p_sku>
<p_lineref>
<![CDATA[Ihre
Bestellpositionsreferenz 2]]>
</p_lineref>
<p_quantity>
<pq_ordered>1</pq_ordered>
</p_quantity>
</product>
</product_list>
</order>
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 53 -
No differing delivery address and partial delivery disabled
<?xml version="1.0" encoding="utf-8"?>
<order>
<request_date_time/>
<customers_number>
<cn_value>$kunde</cn_value> Your customer number
</customers_number>
<shipping_method>
<sm_value>0</sm_value>
</shipping_method>
<partial_shipment>
<ps_value>false</ps_value> Partial delivery = no
</partial_shipment>
<order_reference>
<or_value>
<![CDATA[Referenzbeleg 4711]]>
</or_value>
</order_reference>
<order_note>
<on_value>
<![CDATA[ACHTUNG: Test Bestellung, bitte
stornieren!!!]]>
</on_value>
</order_note>
<delivery_address>
<da_is_different> Different delivery address = no
<da_value>false</da_value> „0“ would also be valid, but no
</da_is_different> alternate delivery address is
</delivery_address>
<product_list>
<product>
<p_sku>180000002</p_sku>
<p_lineref>
<![CDATA[Ihre Bestellpositionsreferenz 1]]>
</p_lineref>
<p_quantity>
<pq_ordered>2</pq_ordered>
</p_quantity>
</product>
<product>
<p_sku>180000003</p_sku>
<p_lineref>
<![CDATA[Ihre
Bestellpositionsreferenz 2]]>
</p_lineref>
<p_quantity>
<pq_ordered>1</pq_ordered>
</p_quantity>
</product>
</product_list>
</order>
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 54 -
Example XML responses:
Your order was accepted
<?xml version="1.0" encoding="UTF-8"?> Web order number received = 8628005
<order><orders_id>8628005</orders_id> No error code present
<response_date_time>2020-06-08
11:32:14</response_date_time>
<request_date_time>2020-06-02
13:35:47</request_date_time>
<customers_number><cn_value>xxxyyy</cn_value>
</customers_number>
<shipping_method><sm_value>0</sm_value>
</shipping_method>
<partial_shipment><ps_value>0</ps_value>
</partial_shipment>
<order_reference><or_value>
Bestellung Problemtest
</or_value>
</order_reference>
<order_note><on_value>
Test Bestellung Ingo. Bitte stornieren.
</on_value>
</order_note>
<delivery_address>
<da_is_different>
<da_value>0</da_value>
</da_is_different>
</delivery_address>
<product_list><product><p_sku>
102090003
</p_sku>
<p_lineref>
Test 1
</p_lineref>
<p_quantity><pq_ordered>
1
</pq_ordered>
</p_quantity>
</product>
</product_list>
</order>
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 55 -
Your order was rejected
Cause: article number requested does not exist
<?xml version="1.0" encoding="UTF-8"?> Web order number received = 0
<order><orders_id>0</orders_id> Error code = 10
<response_date_time>2020-06-08
12:02:49</response_date_time>
General error
<err>10</err>
<request_date_time>2020-06-02
13:35:47</request_date_time>
<customers_number><cn_value>142233</cn_value
>
</customers_number>
<shipping_method><sm_value>0</sm_value>
</shipping_method>
<partial_shipment><ps_value>0</ps_value>
</partial_shipment>
<order_reference><or_value>
Bestellung Problemtest
</or_value>
</order_reference>
<order_note><on_value>
Test Bestellung Ingo. Bitte stornieren.
</on_value>
</order_note>
<delivery_address><da_is_different><da_value>0</
da_value>
</da_is_different>
</delivery_address>
<product_list><product><p_sku>999999999</p_sku
>
<p_quantity><pq_ordered>
1
</pq_ordered>
</p_quantity>
<p_err>30</p_err> Error code = 30
<msg>Artno not found</msg> Message: Art no. not found
</product> Cause of error: article number not
</product_list>
</order>
found
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 56 -
Your order was rejected
Cause: discontinued item was overordered
<?xml version="1.0" encoding="UTF-8"?> Web order number received = 0
<order><orders_id>0</orders_id> Error code = 10
<response_date_time>2020-06-08
12:13:33</response_date_time>
General error
<err>10</err>
<request_date_time>2020-06-02
13:35:47</request_date_time>
<customers_number><cn_value>142233</cn_value
>
</customers_number>
<shipping_method><sm_value>0</sm_value>
</shipping_method>
<partial_shipment><ps_value>0</ps_value>
</partial_shipment>
<order_reference><or_value>
Bestellung Problemtest
</or_value>
</order_reference>
<order_note><on_value>
Test Bestellung Ingo. Bitte stornieren.
</on_value>
</order_note>
<delivery_address><da_is_different><da_value>0</
da_value>
</da_is_different>
</delivery_address>
<product_list><product><p_sku>059470004</p_sku
>
<p_quantity><pq_ordered>
700
</pq_ordered>
</p_quantity>
<p_err>30</p_err> Error code = 30
<msg>ERROR_MESSAGE_FRSTOCK_OUTOFSTOCK</ Message:
msg> ERROR_MESSAGE_FRSTOCK_OUTOFSTOCK
</product> Cause of error: order quantity for a
</product_list>
</order></order>
discontinued article exceeds stock
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 57 -
Please take note:
After your webservice account has been set up, it will operate in test mode
(for the order interface only)
Test mode means that your orders sent to the interface will be accepted
and responded to, but they will not be transferred to our ERP system and
therefore not go into shipping.
After you have successfully implemented the order interface, please
contact your responsible Falk&Ross sales team or send an e-Mail to it-
business@[Link] with the request to enable live mode for your
webservice account. Once the account has been switched to live mode, you
will receive an confirmation e-Mail. From that moment, your transmitted
webservice orders will be passed on to our ERP system and will be shipped
to the delivery address specified in the XML file automatically.
To avoid side effects, please do not transmit several orders at the same
time. A few seconds should pass between each order transmission.
You can also switch yourself your web service account to live mode. To
do this, please use the following URL:
The placeholders webservice_account and webservice_password need to be replaced
with your personal Falk&Ross webservices credentials.
[Link]
[Link]/ws/run/[Link]?action=setlive
Output:
<ws_state>
<export_data_date>2021-03-16 10:48:47</export_data_date>
<webservice_mode_code>0</webservice_mode_code>
<webservice_mode_name>live</webservice_mode_name>
</ws_state>
<webservice_mode_code> 1 = Test Mode; 0 = Live Mode
<webservice_mode_name> Name of Webservice mode: either live or test
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 58 -
You can also switch yourself your web service account to test mode. To
do this, please use the following URL:
The placeholders webservice_account and webservice_password need to be replaced
with your personal Falk&Ross webservices credentials.
[Link]
[Link]/ws/run/[Link]?action=settest
Output:
<ws_state>
<export_data_date>2021-03-16 10:48:47</export_data_date>
<webservice_mode_code>1</webservice_mode_code>
<webservice_mode_name>test</webservice_mode_name>
</ws_state>
<webservice_mode_code> 1 = Test Mode; 0 = Live Mode
<webservice_mode_name> Name of Webservice mode: either live or test
You can also get current information about your webservice account. To
do this, please use the following URL:
The placeholders webservice_account and webservice_password need to be replaced
with your personal Falk&Ross webservices credentials.
[Link]
[Link]/ws/run/[Link]?action=getstate
Output:
<ws_state>
<export_data_date>2021-03-16 10:48:47</export_data_date>
<webservice_mode_code>1</webservice_mode_code>
<webservice_mode_name>test</webservice_mode_name>
</ws_state>
<webservice_mode_code> 1 = Test Mode; 0 = Live Mode
<webservice_mode_name> Name of Webservice mode: either live or test
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 59 -
6. F&R Order Status and Tracking
Date: 05.02.2020
XML Version: R000-011
Document Version: 1.0
History of changes:
Date: Version Description:
2.4.2020 R000-010 Added URL parameter shippingdate=shipping_date
4.2.2020 R000-011 Added <order> TAG into get_order
4.2.2020 R000-011 Added <order_state_code> Tag to get_order and
get_order_status = order status code implemented.
(0=order recieved;10=in processing;100=invoiced)
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 60 -
General remarks:
The methods detailed in this document provide you with the option to
obtain your order status for your webshop orders and tracking numbers
once the orders are shipped by using the Falk&Ross Webservices.
How does the Order Status and Tracking interface work?
By querying URL´s with a defined set of parameters you can access your order status
and tracking numbers for processing in your own systems.
Order status for webshop orders in XML format:
You can fetch and process your order status information for webshop orders by using
the following link, we only provide a XML format in this case.
[Link]
[Link]/ws/run/[Link]?format=xml&s&action=get_order&date=
The placeholders webservice_account and webservice_password need to be replaced
with your personal Falk&Ross Webservices credentials.
Data accessed by using this link is structured as follows:
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 61 -
Output:
<order_list>
<export_data_date>2020-02-04
11:14:59</export_data_date>
<file_version>R000-010</file_version>
<weborder>
<order_nr>84xxxxx1</order_nr>
<order_date>2020-02-04</order_date>
<order_state>berechnet</order_state> Shipping carton invoiced, no tracking
<order_state_code>100</order_state_code> numbers yet
<order_is_test>0</order_is_test>
<order_partial_shippment>0</order_partial_shippment>
<order_is_webservice_order>1</order_is_webservice_ord
er>
<order_ref>xxxx1</order_ref>
<shippment_list>
</shippment_list>
</weborder>
<weborder>
<order_nr>84xxxxx2</order_nr>
<order_date>2020-02-04</order_date>
<order_state>berechnet</order_state> Shipping carton invoiced, tracking
<order_state_code>100</order_state_code>
<order_is_test>0</order_is_test> numbers available.
<order_partial_shippment>0</order_partial_shippment>
<order_is_webservice_order>1</order_is_webservice_ord
er>
<order_ref>xxxxx2</order_ref>
<shippment_list>
<shippment>
<shipping_date>2020-02-04</shipping_date>
<bill_date>2020-02-04</bill_date>
<bill_number>2020xxxx1</bill_number>
<parcel_list>
<parcel>
<pid>41363422x1</pid>
<carrier>UPS</carrier>
<tracking_number>1Z76339xxx1</tracking_number>
<weight>0.98</weight>
</parcel>
…
</parcel_list>
</shippment>
…
</shippment_list>
</weborder>
…
</order_list>
XML tags explained:
<export_data_date> Time stamp of export in ISO format
<file_version> Interface version used, in this case
run=R000-010
<order_nr> Webshop order number
<order_date> Order date
<order_state> Order status
<order_state_code> 0=order recieved;10=in
processing;100=invoiced
<order_is_test> Test order if webservices are in test
mode
<order_is_webservice_order> Is order placed through webservices
<order_ref> Your reference number
<shipping_date> Shipping date
<bill_date> Billing date
<parcel> Parcel data bracket
<pid> Internal Falk&Ross carton number
<carrier> Freight carrier (UPS etc.)
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 62 -
<tracking_number> Tracking number for this shipping
carton
<weight> Shipping carton weight in kilograms
Additional parameters possible in the URL are:
date: This parameter enables you to query for the order status and tracking information
of your webshop orders for a given order date (in ISO format). If no value is specified
for date, the current date is set as default. If there is no data for the specified date, you
will receive an error message in the xml output:
Output:
<error>
<error_code>100</error_code>
<error_msg>no
data</error_msg>
</error>
shippingdate: This parameter enables you to query for the order status and tracking
information of your webshop orders for a given delivery date (in ISO format). If no value
is specified for shippingdate, the current date is set as default. If there is no data for
the specified shippingdate, you will receive an error message in the xml output:
Output:
<error>
<error_code>100</error_code>
<error_msg>no
data</error_msg>
</error>
order: This parameter enables you to query for the order status and tracking
information of your webshop orders for a specific webshop order. If there is no data for
the specified order, you will receive an error message in the xml output:
Output:
<error>
<error_code>100</error_code>
<error_msg>no
data</error_msg>
</error>
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 63 -
If you only want to query the status of your webshop orders, you may use the following
URL:
[Link]
[Link]/ws/run/[Link]?format=xml&s&action=get_order_status&d
ate=
Output:
<order_list_status>
<export_data_date>2020-02-04
11:53:03</export_data_date>
<file_version>R000-011</file_version>
<order_list>
<order>
<order_nr>849xxx1</order_nr>
<order_date>2020-02-04 11:15:26</order_date>
<order_nettosum>9.38</order_nettosum>
<order_ref>refxxx1</order_ref>
<order_state>angelegt</order_state>
<order_state_code>0</order_state_code>
</order>
<order>
<order_nr>849xxx2</order_nr>
<order_date>2020-02-04 11:15:23</order_date>
<order_nettosum>9.16</order_nettosum>
<order_ref>refxxx2</order_ref>
<order_state>inBearbeitung</order_state>
<order_state_code>10</order_state_code>
</order>
<order>
<order_nr>849xxx3</order_nr>
<order_date>2020-02-04 10:25:18</order_date>
<order_nettosum>47.58</order_nettosum>
<order_ref>refxxx3</order_ref>
<order_state>berechnet</order_state>
<order_state_code>100</order_state_code>
</order>
...
</order_list>
</order_list_status>
XML tags explained :
<export_data_date> Time stamp of export in ISO format
<file_version> Interface version used, in this case
run=R000-011
<order> Webshop order
<order_nr> Webshop order number
<order_nettosum> Base order total without taxes, freight
cost and additional markups.
<order_ref> Your reference number
<order_state> Order status (received, in processing,
invoiced)
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 64 -
<order_state_code> 0=order received; 10=in
processing; 100=invoiced
Additional parameters possible in the URL are:
date: This parameter enables you to query for the order status and tracking information
of your webshop orders for a given order date (in ISO format). If no value is specified
for date, the current date is set as default. If there is no data for the specified date, you
will receive an error message in the xml output:
Output:
<error>
<error_code>100</error_code>
<error_msg>no
data</error_msg>
</error>
order: This parameter enables you to query for the order status and tracking information of
your webshop orders for a specific webshop order. If there is no data for the specified order,
you will receive an error message in the xml output:
Output:
<error>
<error_code>100</error_code>
<error_msg>no
data</error_msg>
</error>
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 65 -
How we handle changes in the XML file´s structure in a new version:
Changes may be made to the XML file´s structure with a new version, possibly preventing your
current setup from importing successfully. Because of that, when we modify the XML file
structure, we also update the xml file´s version.
To avoid compatibility problems on your side, we always provide previous versions of the XML
file for continuing use. To use this feature, you have to modify the download URL for the file to
use the version specific one as shown below. If you have implemented your import setup with
a specific version of the XML file in the past, please continue to use the version specific link.
XML Version: Version: Url:
11 R000-011 [Link]
011/[Link]?action=get_order...
10 R000-010 [Link]
010/[Link]?action=get_order...
9 R000-009 [Link]
[Link]?action=get_order...
Always the current Current [Link] …
version version
The XML tag <file_version>…</file_version> contains the version of the XML file in use, making
sure import continues to work when you need to use a historic version of the export. If new
data was introduced to the export, you may have to upgrade a higher version of the export/file
if you intend to process the additional data. This may make changes to your import setup
necessary because of changes in XML file structure.
We ask you to take this into account in your implementation.
Please let us know about your wishes and suggestions concerning the order status a tracking
interface by contacting us at:
We look forward to your suggestions and the joint implementation of your wishes and
suggestions for improvement.
Falk&Ross Group Europe GmbH, extendend webservice interfaces
- Page 66 -