...
To get response in JSON format send request to http://otapi.net/service-json/
Examples of requests
Request | Method | Request example |
Comments | |||
Get info on enabled providers for API Key | Request example | Trade provider is a service (or marketplace) for trading. Information about goods (titles, settings, configuration, etc.) and categories is sent to OT API from trade provider and then is broadcasted to website via OT API Key. Method allows to get list of available providers for your API Key and information about them. | |
Get all categories | Request example | ℹ️ Our API does not allow to get all products in all categories at once. first we request the main (root) categories, then separately request subcategories of second, third, ... level | |
Get subcategories in category | Request example |
Get products in category (Search product by category) | 1 provider: |
<SearchItemsParameters><CategoryId>otc-1</CategoryId></SearchItemsParameters>
In frameSize specify required number of products (for example, 20). ⚠️ Maximum 200 products per 1 request
Get parent categoriesSeveral providers: |
In xmlParameters specify provider and category:
<SearchItemsParameters><Provider>Taobao</Provider><CategoryId>otc-1</CategoryId></SearchItemsParameters>
In frameSize specify required number of products (for example, 20). ⚠️ Maximum 200 products per 1 request
Get parent categories list for category (root path) |
In xmlParameters specify subcategory:
<SearchItemsParameters><CategoryId>abb-201967404</CategoryId></SearchItemsParameters>
In blockList specify: RootPath Get numberGet parent categories list for item (root path) |
In itemId specify item ID
Get number of goods in category |
1. Via API request.
In |
<SearchItemsParameters><CategoryId>...</CategoryId><OutputMode>TotalCount</OutputMode></SearchItemsParameters>
Incode find: <TotalCount>...</TotalCount> |
Via website https://open-demo.otcommerce.com |
Indicate category number in address bar and get number of products found in search results: https://clip.otcommerce.com/files/4b/7e/totalcounteng.jpg | ||
Get full product info with characteristics | Request example |
For Taobao enter itemID without prefix. |
For other providers specify Prefix |
Add Description into blockList |
if you need product photo, video and description | ||
Get short product info |
For Taobao enter itemID without prefix. |
For other providers specify Prefix |
Get product category number |
In blockList specify RootPath
You can get product category ID via website address bar (https://clip.otcommerce.com/files/40/48/category.jpg). The last digits in address bar are category ID | |||
Get up to 10 000 products in 1 request | It's possible to get up to 10 000 products by search criteria or a list of identifiers, with full information (descriptions, characteristics, configurations) in 1 request with the use of Bulk methods (GetBulkItemsResult, GetBulkSearchItemsResult, RunBulkItems, RunBulkSearchItems). Paid calls are counted only for successful receipt of goods. For example, 9 000 goods were loaded, 9 000 calls are counted. ⚠️ Methods are available only after API Key purchase. Contact manager in Telegram group to enable. | ||
Get product SKU and configurations | Request example | If product has no configurations, the response will have one section <OtapiConfiguredItem>... </OtapiConfiguredItem>. If product has configurations, then the response will have several sections <OtapiConfiguredItem>... </OtapiConfiguredItem>. <Id>...</Id> of the product is its configuration (SKU) and below it are all the product parameters (quantity in stock, price, etc.) For example, product is black and white shoes, black shoes which are available in sizes 35, 38 and 40, and white ones are available in sizes 36 and 42. Response will have 5 sections <OtapiConfiguredItem>... </OtapiConfiguredItem>, inside each - information about price and quantity in stock, as well as <Id>... </Id> Pid is product identifier property, Vid is value identifier property (for example, Pid="color" Vid="black"). In section <Attributes> you can find all product attributes (this can be product purpose, season, style and others) and also all product configurations with translation into selected language. | |
Get product collections: popular, best, last | In xmlParameters specify: <RatingListItemSearchParameters><CategoryId>0</CategoryId><ItemRatingType>Popular</ItemRatingType></RatingListItemSearchParameters> <RatingListItemSearchParameters><CategoryId>0</CategoryId><ItemRatingType>Best</ItemRatingType></RatingListItemSearchParameters> <RatingListItemSearchParameters><CategoryId>0</CategoryId><ItemRatingType>Last</ItemRatingType></RatingListItemSearchParameters> Popular - Popular goods (created and updated automatically) Best - Recomended products (required to create/update in API Key admin panel) Last - Latest opened products (created and updated automatically) | ||
Get number of sold products in the last 30 days or total | Request example | Find values: SalesInLast30Days TotalSales | |
Get product price with discount | BatchGetItemFullInfo | In |
code find: <Promotions> | ||
Get product internal reviews (from OTCommerce customers) | SearchItemReviews | Request example |
In xmlParameters specify:
<SearchParameters><ItemId>546425262438</ItemId><Source>Internal</Source></SearchParameters>
⚠️ Available with "Customers reviews" module only. | ||
Get products in category with internal reviews (from OTCommerce customers) | BatchSearchItemsFrame | Request example |
In xmlParameters specify:
<SearchItemsParameters><CategoryId>otc-824</CategoryId><SearchMethod>Reviews</SearchMethod></SearchItemsParameters>
Get⚠️ Available with "Customers reviews" module only. | |
| SearchReviewedItems | Request example |
In xmlParameters specify:
<SearchParameters><CategoryId>otc-824<string>CategoryId</string></CategoryId><ProviderType>Taobao</ProviderType></SearchParameters>
⚠️ Available with "Customers reviews" module only.
⚠️ Available with "Customers reviews" module only. |
Get |
product external reviews (from provider) | In |
<SearchParameters><ItemId>546425262438</ItemId><Source>Provider</Source></SearchParameters>
Incode find: <Text> ℹ️ "Customers reviews" module is not required | |
In code find block: <ProviderReviews><Content> ℹ️ "Customers reviews" module is not required | ||
Get vendor info (location, rating, etc.) |
VendorId can be found via https:// |
In vendorId specify vendor/seller name
Vendor’s rating in our API is Level
. Find vendor via search on the site, then scroll down to "All items of this seller": https://clip.otcommerce.com/files/ |
Copy vendor ID from browser address bar: https://clip.otcommerce.com/files/5d/cd/VendorENG.jpg Vendor’s rating in our API is Level | |||
You can find vendor/seller name here https://clip.otcommerce.com/files/21/99/seller.jpg Vendor’s rating in our API is Level | |||
Get internal (domestic, local) delivery price | Request example | In |
the code search for words InternalDelivery (without a space) ⚠️ It's impossible to get internal shipping charge of a product for a specific address via api. You should set it in admin panel of API Key | ||
Sorting provider products by price descending | Request example |
In xmlParameters specify provider, category ID and sorting order (for example, Taobao, otc-1, descending):
<SearchItemsParameters><Provider>Taobao</Provider><CategoryId>otc-1</CategoryId><OrderBy>Price:Desc</OrderBy></SearchItemsParameters>
Sorting provider products by price ascending | Request example |
In xmlParameters specify provider, category ID and sorting order (for example, Taobao, otc-1, ascending):
<SearchItemsParameters><Provider>Taobao</Provider><CategoryId>otc-1</CategoryId><OrderBy>Price:Asc</OrderBy></SearchItemsParameters>
Get enabled languages for API Key
Sorting products by the number of sales in ascending order | BatchSearchItemsFrame | Request example | In xmlParameters, you must use sorting <OrderBy>Volume:Asc</OrderBy> <Value Name="SalesInLast30Days">...</Value> parameter returns results in ascending order |
Sorting products by the number of sales in descending order | BatchSearchItemsFrame |
⚒️ Languages and Multilanguage module documentation
Search
Search product by category ID
| Request example | In xmlParameters |
<SearchItemsParameters><CategoryId>otc-1</CategoryId></SearchItemsParameters>
In frameSize specify required number of products (for example, 20).
⚠️ Maximum 200 products per 1 request
Several providers:
In xmlParameters specify provider and category (for example, Taobao and category otc-1):
<SearchItemsParameters><Provider>Taobao</Provider><CategoryId>otc-1</CategoryId></SearchItemsParameters>
In frameSize specify required number of products (for example, 20).
⚠️ Maximum 200 products per 1 request
Search product by category name
, you must use sorting <OrderBy>Volume:Desc</OrderBy> <Value Name="SalesInLast30Days">...</Value> parameter returns results in descending order | |||
Get enabled languages for API Key | Request example | ⚠️ API Keys K0 Basic, K1 Standard and K2 Advanced include only 1 language. To connect additional language, you need to connect "Multililanguage" module. Unlimited number of languages are available for K3 Enterprise Key. Price of Multilanguage module | |
Search | |||
Search product by category ID | 1 provider: | ||
Several providers: | |||
Search product by category name | There is no direct product search by category name, but if you specify category name or part of it in xmlParameters and HintCategories in blockList, search will display matching categories. | ||
<SearchItemsParameters><ItemTitle>Eletronic components</ItemTitle></SearchItemsParameters>
In blockList specify: HintCategories
Search product by ID | Request example |
For Taobao enter itemID without prefix. |
For other providers specify Prefix |
Add Description into blockList |
if you need product photo, video and description | ||
Search product by word | 1 provider: |
Specify in xmlParameters search query (for example, dress):
<SearchItemsParameters><ItemTitle>dress</ItemTitle></SearchItemsParameters>
⚠️ Maximum 200 products per 1 request
⚠️⚠️ Search query can be in any required language. API Keys K0 Basic, K1 Standard and K2 Advanced include only 1 language. To connect additional language, you need to connect paid module "Multilingualism". Price. Unlimited number of languages are available for K3 Enterprise Key. |
Several providers: |
If there are several providers, in xmlParameters specify provider and search query (for example, dress on Taobao):
<SearchItemsParameters><Provider>Taobao</Provider><ItemTitle>dress</ItemTitle></SearchItemsParameters>
⚠️ Maximum 200 products per 1 request
⚠️ Search query can be in any required language. API Keys K0 Basic, K1 Standard and K2 Advanced include only 1 language.⚠️ Search query can be in any required language. API Keys K0 Basic, K1 Standard and K2 Advanced include only 1 language. To connect additional language, you need to connect "Multililanguage" module. Unlimited number of languages are available for K3 Enterprise Key. Price of Multilanguage module | ||
Search product by phrase or key words | 1 provider: |
Specify in xmlParameters search query (for example, dress):
<SearchItemsParameters><ItemTitle>red dress</ItemTitle></SearchItemsParameters>
⚠️ Maximum 200 products per 1 request
⚠️ Search query can be in any required language.⚠️ Search query can be in any required language. API Keys K0 Basic, K1 Standard and K2 Advanced include only 1 language. To connect additional language, you need to connect "Multililanguage" module. Unlimited number of languages are available for K3 Enterprise Key. Price of Multilanguage module |
Several providers: |
If there are several providers, in xmlParameters specify provider and search query (for example, dress on Taobao):
<SearchItemsParameters><Provider>Taobao</Provider><ItemTitle>red dress</ItemTitle></SearchItemsParameters>
⚠️ Maximum 200 products per 1 request
⚠️ Search query can be in any required language. API Keys K0 Basic, K1 Standard and K2 Advanced include⚠️ Search query can be in any required language. API Keys K0 Basic, K1 Standard and K2 Advanced include only 1 language. To connect additional language, you need to connect "Multililanguage" module. Unlimited number of languages are available for K3 Enterprise Key. Price of Multilanguage module | ||
Search product by link |
In xmlParameters specify link:
<SearchItemsParameters><ItemTitle>https://detail.1688.com/offer/530220113667.html</ItemTitle></SearchItemsParameters >
You can't copy and paste a product link into a requestYou can't copy and paste a product link into a request in this form https://item.taobao.com/item.htm?spm=a21wu.241046-global.4691948847.9.41cab6cb6SlLhG&scm=1007.15423.84311.100200300000001&id=566279369923&pvid=0c5ba9c6-4ad1-4735-b0d3-b30089f3bdb3 | ||
Search product by photo | 1 provider: |
Specify in xmlParameters link to photo:
<SearchItemsParameters><ImageUrl>https://img.alicdn.com/imgextra/i1/529782397/O1CN01qnZeTY1TZs3xAcmOv_!!529782397.jpg</ImageUrl></SearchItemsParameters>
⚠️ Maximum 200 products per 1 request
ℹ️ Link to photo can be any but it must be viewable in any browser
ℹ️ Link to photo can be any but it must be viewable in any browser ⚠️ Search by photo is an |
additional module. it costs 170$ (one-time payment) for each provider |
Several |
Specify in xmlParameters required provider and link to photo (for example, https://img.alicdn.com/imgextra/i1/529782397/O1CN01qnZeTY1TZs3xAcmOv_!!529782397.jpg):
<SearchItemsParameters><Provider>Taobao</Provider><ImageUrl>https://img.alicdn.com/imgextra/i1/529782397/O1CN01qnZeTY1TZs3xAcmOv_!!529782397.jpg</ImageUrl></SearchItemsParameters>
providers: |
ℹ️ Link to photo can be any but it must be viewable in any browser ⚠️ Search by photo is an additional module. it costs 170$ (one-time payment) for each provider | |||
Search product by brand | For Taobao: | 1️⃣ Add brand into brands list in admin panel of API Key: Catalog –> Collections –> Popular brands (https://clip.otcommerce.com/files/71/3f/brandseng.jpg). You can add brand: - from list https://clip.otcommerce.com/files/54/91/brandsrus2%20%281%29.jpg - by link or ID https://clip.otcommerce.com/files/e7/68/brandseng3.jpg. You can copy link or ID from website https://open-demo.otcommerce.com/?q=brands (https://clip.otcommerce.com/files/3d/cd/brandsrus4.jpg -> https://clip.otcommerce.com/files/dc/40/brandsrus5.jpg) ⚠️ If you specify brand ID, it should be copied exactly from the link (for example, ot:34657) 2️⃣ Make request using BatchSearchItemsFrame method. |
In xmlParameters specify brand:
<SearchItemsParameters><BrandId>Adidas</BrandId></SearchItemsParameters>
For other providers: | Don’t add brand to brands list in admin panel of API Key. Make a request as when searching by word, phrase, seller and other filters, using BatchSearchItemsFrame method. |
In xmlParameters specify brand.
<SearchItemsParameters><ItemTitle>Adidas</ItemTitle></SearchItemsParameters>
Search product by brand in category | For Taobao: | 1️⃣ Add brand into brands list in admin panel of API Key: Catalog –> Collections –> Popular brands (https://clip.otcommerce.com/files/71/3f/brandseng.jpg). You can add brand: - from list https://clip.otcommerce.com/files/54/91/brandsrus2%20%281%29.jpg - by link or ID https://clip.otcommerce.com/files/e7/68/brandseng3.jpg. You can copy link or ID from website https://open-demo.otcommerce.com/?q=brands (https://clip.otcommerce.com/files/3d/cd/brandsrus4.jpg -> https://clip.otcommerce.com/files/dc/40/brandsrus5.jpg) ⚠️ If you specify brand ID, it should be copied exactly from the link (for example, ot:34657) 2️⃣ Call clarifying categories list for specific brand to narrow search for necessary products. In xmlParameters specify provider and brand: <SearchItemsParameters><Provider>Taobao</Provider><BrandId>Adidas</BrandId></SearchItemsParameters> In blockList specify: HintCategories In response we receive categories list, select category ID 3️⃣ Request products by brand and specifying category. In xmlParameters specify category ID containing products of this brand and brand: <SearchItemsParameters><Provider>Taobao</Provider><CategoryId>201566723</CategoryId><BrandId>Adidas</BrandId></SearchItemsParameters> | |
For other providers: | Don’t add brand to brands list in admin panel of API Key. 1️⃣ Call clarifying categories list for specific brand to narrow search for necessary products. In xmlParameters specify provider and brand as a keyword: <SearchItemsParameters><Provider>Alibaba1688</Provider><ItemTitle>Adidas</ItemTitle></SearchItemsParameters> In blockList specify: HintCategories In response we receive categories list, select category ID 2️⃣ Request products by brand and specifying category. In xmlParameters specify category ID containing products of this brand and brand: <SearchItemsParameters><CategoryId>abb-10282</CategoryId><ItemTitle>Adidas</ItemTitle></SearchItemsParameters> | ||
Search product/s by vendor/seller | You can find vendor/seller name here: https://clip.otcommerce.com/files |
In xmlParameters specify vendor/seller name:
<SearchItemsParameters><VendorId>myczx8</VendorId></SearchItemsParameters>Search product with internal reviews (from OTCommerce customers) | SearchItemReviews | Request example |
In xmlParameters specify:
<SearchParameters><ItemId>546425262438</ItemId><Source>Internal</Source></SearchParameters>
⚠️ Available with "Customers reviews" module only. | ||
Search product in category with internal product reviews (from OTCommerce customers) | BatchSearchItemsFrame | Request example |
<SearchItemsParameters><CategoryId>otc-824</CategoryId><SearchMethod>Reviews</SearchMethod></SearchItemsParameters>
⚠️ Available with "Customers reviews" module |
In xmlParameters specify:
<SearchParameters><CategoryId>otc-824<string>CategoryId</string></CategoryId><ProviderType>Taobao</ProviderType></SearchParameters>only. | |||
| SearchReviewedItems | Request example | ⚠️ Available with "Customers reviews" module only. | |
Search product with external reviews (from provider) | In |
<SearchParameters><ItemId>546425262438</ItemId><Source>Provider</Source></SearchParameters>
Incode find: <Text> ℹ️ "Customers reviews" module is not required | ||
In |
code find block: <ProviderReviews><Content> ℹ️ "Customers reviews" module is not required |
Search provider products in category sorted by descending internal reviews (from OTCommerce customers |
In xmlParameters specify:
<SearchItemsParameters><Provider>Taobao</Provider><CategoryId>otc-824</CategoryId><SearchMethod>Reviews</SearchMethod><OrderBy>ReviewCount:Desc</OrderBy></SearchItemsParameters>) count | BatchSearchItemsFrame | Request example | ℹ️ Available with "Customers reviews" module only. |
Search provider products in category sorted by ascending internal reviews (from OTCommerce customers) count | BatchSearchItemsFrame | Request example |
In xmlParameters specify:
<SearchItemsParameters><Provider>Taobao</Provider><CategoryId>otc-1</CategoryId><SearchMethod>Reviews</SearchMethod><OrderBy>ReviewCount:Asc</OrderBy></SearchItemsParameters>
⚠️ Available with "Customers reviews" module only. | |
Search productby descending sales count |
In xmlParameters specify:
<SearchItemsParameters><ItemTitle>T-shirt</ItemTitle><OrderBy>Volume:Desc</OrderBy></SearchItemsParameters>| Request example | ||
Search product by ascending sales count | Request example |
In xmlParameters specify:
<SearchItemsParameters><ItemTitle>T-shirt</ItemTitle><OrderBy>Volume:Asc</OrderBy></SearchItemsParameters>
Search product by minimal vendor's rating ... | BatchSearchItemsFrame | Request example |
<SearchItemsParameters><ItemTitle>T-shirt</ItemTitle><MinVendorRating>19</MinVendorRating></SearchItemsParameters>
ℹ️ Maximum seller rating value varies from provider to provider. It can be found in available search methods of provider. In this particular example, the only provider is Taobao and maximum seller rating for this provider is 20 |
Search productby price interval: from ... to |
.. |
In xmlParameters specify:
<SearchItemsParameters><ItemTitle>T-shirt</ItemTitle><CurrencyCode>CNY</CurrencyCode><MinPrice>10</MinPrice><MaxPrice>40</MaxPrice></SearchItemsParameters>. in CNY | BatchSearchItemsFrame | Request example | Selection includes products with promotion price (PromotionPrice). Currency (if not explicit) gets from administrators panel (first currency from list) and converts. |
Search productby USD equivalent price not exceed ... | BatchSearchItemsFrame | Request example |
<SearchItemsParameters><ItemTitle>T-shirt</ItemTitle><MaxPrice>3</MaxPrice><CurrencyCode>USD</CurrencyCode></SearchItemsParameters>
Get currency code (CurrencyCode) by using GetCurrencyInstanceList or GetInstanceCurrencyInfoList methods. | ||
Search product with minimal sales count of ... | BatchSearchItemsFrame | Request example |
In xmlParameters specify:
<SearchItemsParameters><ItemTitle>T-shirt</ItemTitle><MinVolume>50</MinVolume></SearchItemsParameters>Search product with minimal first lot ... | BatchSearchItemsFrame | Request example |
In xmlParameters specify:
<SearchItemsParameters><Provider>Alibaba1688</Provider><ItemTitle>T-shirt</ItemTitle><MinFirstLot>5</MinFirstLot></SearchItemsParameters>
ℹ️ Method works only for 1688 | ||
Search productwith maximal first lot ... (equals to retail order) | BatchSearchItemsFrame | Request example |
<SearchItemsParameters><Provider>Alibaba1688</Provider><ItemTitle>T-shirt</ItemTitle><MaxFirstLot>1</MaxFirstLot></SearchItemsParameters>
Search NEW products | BatchSearchItemsFrame | Request example |
In xmlParameters specify:
<SearchItemsParameters><ItemTitle>T-shirt</ItemTitle><StuffStatus>New</StuffStatus></SearchItemsParameters>We have 2 conditions: New and Second. | |
| Request example | Or you can sort by UpdatedTime |
<SearchItemsParameters><ItemTitle>t-shirt</ItemTitle><Sort><OrderBy>UpdatedTime:Desc</OrderBy></Sort></SearchItemsParameters>
Search by attribute: product, size, color | BatchSearchItemsFrame | Request example | Search attributes for selected item by using BatchGetItemFullInfo (example's item - id 646674173023) (<Attributes> ) |
In xmlParameters specify:
<SearchItemsParameters><ItemTitle>T-shirt</ItemTitle><Configurators><Configurator Pid="20509" Vid="28317" /><Configurator Pid="1627207" Vid="13535612018" /></Configurators></SearchItemsParameters>Search product with discount | BatchSearchItemsFrame | Request example |
In xmlParameters specify:
<SearchItemsParameters><ItemTitle>T-shirt</ItemTitle><Features><Feature Name="Discount">true</Feature></Features></SearchItemsParameters>
Search TMall products | BatchSearchItemsFrame | Request example |
In xmlParameters specify:
<SearchItemsParameters><ItemTitle>T-shirt</ItemTitle><Features><Feature Name="Tmall">true</Feature></Features></SearchItemsParameters>Sort goods in stock | BatchSearchItemsFrame | Request example |
It's possible to request maximum 200 products in one request
...
