Get Availability
Availability Request
Summary of Changes: (The purpose of this table is to keep traceability and Product team to highlight the things that were changed into the scope, based on comments or discussions)
| Date | Version | Name | Applied changes |
|---|---|---|---|
| 06.07.2022 | 1.0 | Bogomil Pavlov | First Publish |
| 01.09.2023 | 1.1 | Bogomil Pavlov | Misleading comment in the mapping was updated |
We will need to get stock from Decathlon once a day in order to obtain all new SKUs because they can push only delta stock updates. Thus we need to check if the SKU is existing in Location Quantity table and if not to get the stock for the SKU and add it in the table. Please have in mind we need also to get the correct location id from the Account. So we need to check the SKU then the Product Account and if the account has Decathlon Connector set and what is the location id. If we have more than one location set on the Account we use the smallest id.
API Call: POST https://api-global.preprod.decathlon.net/one_market_connect/products/availability/ API Docs: Product Availability:
- Desc: Check Product availability
- API body: Contains product data
- API Method: POST
- API Body: present in POSTMAN COLLECTION
- API header: Authorization and x-api-key
Sample Request: POST https://api-global.preprod.decathlon.net/one_market_connect/products/availability/
Sample Request:
{
"sku_ids":[
4407216,
4081662
],
"warehouse_id":"W115"
}Mapping:
| Decathlon Field | Hemi Field | Comment |
|---|---|---|
sku_ids |
Item > SKU | All SKUs which are in Products |
| but not in Location Quantity table | ||
warehouse_id |
Location Decathlon Connector > Warehouse Id | New slave table under Location with Warehouse ID field |
Sample Response:
{
"4407216": 11.0,
"4081662": 3.0
}We need to create the SKU in Item Location Quantity with the relevant quantity.
Limits: We can specify between 20-30 SKUs in the body of the request.