Fuse5 Get Price
Version | Date | Created / Updated | Notes |
---|---|---|---|
v1.0 | 03.04.2025 | Bogomil | First publish |
The get price simply is a request which generate a url to a csv file which we need to import in MCP. File should be processed automatically by this functionality following standard Price concepts in MCP
Get Price
The first run of the cron should get all price levels and we do not want to specify changedsince
identifier.
If we have a record in last_date_run for the cron we want to overlap with 30mins.
API Docs : https://greenteam.fuse5live.com/f5apidoc/standalone/#api-Product-Export_All_Products
API Call : product/export
Sample Request:
{
"authenticate":{
"apikey":"API KEY"
},
"services":[
{
"call":"product/export",
"params": ["line_code","product_number","unit_barcode","location_name","list_price","core_cost","core_sell_price","alternate_core_sell_price","unit_price"],
"identifier":{"location_name":"Fiji","changedsince":"09-30-2015"}
}
]
}
Request Mapping:
identifier > changedsince
- This will be picked from last_date_run
params
- we want to always use the parameters from the sample request
Sample Response:
{
authenticate: {
"apikey":"API KEY",
status: "success"
},
services: [
{
request: {
call: "product/export",
params: null,
identifier: null
},
response: {
status: true,
msg: {
code: "M003",
msg: "Data retrieved successfully"
},
data: "https://test.test.com/properties/dev/exports/files/products_20150225_104658am.csv"
}
}
]
}
From the response we want to use the generated .csv file from the data
and import it in MCP.
Sample File:
products_20250427_021108pm.csv
Sample File Mapping:
File Header | Hemi Field | Comment |
---|---|---|
line_code | Product > SKU | Based on the Fuse5 Connector > SKU Delimiter we will generate the SKU like line_code[delimeter]product_number |
product_number | Product > SKU | Based on the Fuse5 Connector > SKU Delimiter we will generate the SKU like line_code[delimeter]product_number |
unit_barcode | N/A | |
location_name | N/A | |
list_price | Listing > RRP |
OR Listing > Original RRP | Based on Channel Fuse5 Connector > Get Prices as Original Price we will decide if we want to store the list_price as RRP or Original RRP | | core_cost | N/A | | | core_sell_price | N/A | | | alternate_core_sell_price | N/A | | | unit_price | Listing > Price OR Listing > Original Price | Based on Channel Fuse5 Connector > Get Prices as Original Price we will decide if we want to store the list_price as Price or Original Price |
We want to update the price only if there is a difference and if we are populating the Price and RRP (Channel Fuse5 Connector > Get Prices as Original is inactive) we want to set Listing > Update Price = Pending. If we are updating the Original Price and Original RPP (Channel Fuse5 Connector > Get Prices as Original is active) we do NOT want to set Listing > Update Price = Pending
We need to track to which channels is the connector assigned and based on this update said prices as per the description above (meaning we can receive 1 SKU in the file with a price but have the same connector assigned to 3 accounts - we should try to update the price on all 3 listings)