Trendyol Authorisation, Database Structure & Limits
| Version | Date | Created / Updated | Notes |
|---|---|---|---|
| v1.0 | Hristiyan Georgiev | Initial version |
Authorization
Trendyol has two types of environments: stage and production.
- The stage environment allows sellers to perform all the tests they need to integrate their integration services into their systems. Trendyol stage environment needs an IP authorization for access.
- In prod environment there is no need any IP authorization, however our IP could be added to blacklist for some reason. If any access issue has been faced with both stage and prod environment we can contact Trendyol.
We want to cover both environments and have the option to switch between production and sandbox.
The authorization itself is a simple basic auth for which Trendyol will provide us with a username and password.
Sandbox endpoint : https://stageapigw.trendyol.com/integration
Sandbox username : RvyJpQgaDsfOusTHhuLZ
Sandbox password : hhRNTUWLYuTlmy8Jl6q9
We also have access to a sandbox seller central :
Stage Seller Center: https://stagepartner.trendyol.com/
SellerID: 875827
Email: sb-intmp-test.1545@testmail.com
Password: Trendyol123!
❗Please note that the both the sandbox API and seller central are only accessible through a whitelisted IP address, at the moment the only whitelisted IP address is 87.120.199.15 which is our VPN IP address. For production we don’t need IP address whitelist.
Prod endpoint : https://apigw.trendyol.com/integration/
Prod username : d0mWi4Idlm31T7HLHOIz
Prod password : T8uxa3bEXiYi5aUw8PcP
Database Structure
We will need the standard tables such as Channel Trendyol , Orders Trendyol , Orders Trendyoland Listings Trendyol will not be added here, instead in other parts of the scope wherever needed, the tables and new fields will be specified.
Channel Trendyol : This is our starting point where we keep marketplace specific settings.
| Field Name | type | Required | Comment | Default Value |
|---|---|---|---|---|
Username |
varchar | Yes | This is the basic auth username | N/A |
Password |
varchar | Yes | This is the basic auth password | N/A |
Supplier ID |
varchar | Yes | This is the supplier ID provided by Trendyol. We need this for most of our calls. | N/A |
Country |
enum table | Yes | This should be an enumeration table where we display the country name, but we need to send the storeFrontCode as a Header in every call we make. See table below for available countries. | N/A |
Environment |
radio button | Yes | This should be a radio button with two options : Stage and Production . If "Stage" is chosen, the stage endpoint is used; if "Production" is chosen, the production endpoint is used.. | N/A |
| Country | storeFrontCode |
|---|---|
| Germany | DE |
| Saudi Arabia | SA |
| United Arab Emirates | AE |
| Greece | GR |
| Slovakia | SK |
| Romania | RO |
| Czechia | CZ |
Limits
Trendyol have different limits for Product and Order services. We want to obey to those limits and create our flows in a way that we don’t exceed the limits.
| Product services | Integration Service | Limitation |
|---|---|---|
| Product Create | 1000 req/min | |
| Product Update | 1000 req/min | |
| Stock and Price Update | NO LIMIT | |
| Check Batchrequest Result | 1000 req/min | |
| Product Filter | 2000 req/min | |
| Trendyol Brand List | 50 req/min | |
| Trendyol Brand List by name | 50 req/min | |
| Trendyol Category List | 50 req/min | |
| Trendyol Category-Attribute List | 50 req/min |
| Order Services | Integration Service | Limitation |
|---|---|---|
| Get Shipment Packages | 3000 req/min | |
| Update Tracking Number | 500 req/min | |
| Update Package Status | 500 req/min | |
| Cancel Package | 200 req/min | |
| Split Shipment Packages e /split | 200 req/min | |
| Split Shipment Packages /multi-split | 200 req/min | |
| Split Shipment Packages /quantity-split | 200 req/min | |
| Split Shipment Packages /split-packages | 200 req/min | |
| Shipping Alternative Delivery | 500 req/min | |
| Shipping Alternative Delivery - delivered | 1500 req/min | |
| Shipping Alternative Delivery - returned | 1500 req/min |