Access Pricing Parameter Using the Custom Function

To begin, please make sure that the pricing parameter feature is activated within your account.

Next, using the custom functions interface, you can load the parameter sheet data into a variable.

Follow these steps:

example_variable = ctx.get_pricing_parameters('parameter_sheet_name', keys_dict)

Here, 'parameter_sheet_name' should be replaced with the name of your specific parameter sheet, and 'keys_dict' should contain the necessary key-value pairs for retrieval.

key_dict = {"key column label":"Value to look for", "key column label2":"Value to look for2"}

For example, if 'brand' is the key column:

This code snippet:

ctx = get_context()
key = {"brand":"Giorgio Armani"}
pricing_parameters = ctx.get_pricing_parameters('Test_Guide',key)
ctx.log(pricing_parameters)

This code will result in a variable containing the parameter sheet data, providing insights like:

{'data': [{'name': 'brand', 'value': 'Giorgio Armani'}, {'name': 'gtin', 'value': '1234567890'}], 'error': ''}

You can also use a variable as the value to look for, offering a more generic approach. For instance:

brand_value = get_attr("brand") # a function to bring back the brand value
key = {"brand": brand_value}

With the data loaded, you can now access it as needed. To retrieve the value for 'Giorgio Armani' brand, you can use the following code snippet:

gtin_value = None # Default value if 'gtin' is not found

for item in pricing_parameters['data']: #or this
    if item['name'] == 'gtin':
       gtin_value = item['value']  
       break

Executing this code with the provided data will yield the output: 1234567890.