Hemi Connectors / Fuse5 Technical Scope / Fuse5 Get Price

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)

Is this article helpful?
0 0 0