Scripts

A context object is passed to the script, which contains properties with data and methods. Some properties are read-only and cannot be changed, while others are used for writing (making changes).

There are three types of scripts:

• Product – for changing product prices, availability, tags, and properties
• Status – for changing product statuses
• Analysis – for building product data views

General Data

Passed to scripts of all types.

Data

A read-only property containing general data from the system:

• MainCurrency – system currency (USD, EUR, etc.)
• Category – a dictionary with categories, the key string with the category’s ExternalId, the value is the category data {Id: Guid; ExternalId: string; Name: string; ParentExternalId: string; IsActive: boolean}
• Contractor – a dictionary with contractors, the key string with the contractor's UnifiedName, the value is the contractor data {ExternalId: string; Name: string; Tags: string[]}
• ProductPriceType – a dictionary with price types, the key string with the price type's UnifiedName, the value is the price type data {Id: Guid; Name: string; ExtensionData: string}
• ContractorPriceType – a dictionary with contractor price types, the key string with Contractor.UnifiedName-ContractorPriceType.Code, the value is the price type data {Id: Guid; Name: string;}
• PriceSet – a dictionary with price groups, the key string with the price group’s UnifiedName, the value is the price group data {Id: Guid; Name: string; UnifiedName: string}
• Global – Dictionary <string, Dictionary<string, string>>

ContractorPrices

A read-only property that contains an array with contractor prices for the current product ReevaluationContractorPrice[]

ReevaluationContractorPrice type:

• Code – contractor price code
• Name – contractor product name
• Url – contractor product link
• Price – product price
• Currency – currency for the product price
• ParsedOn – parsing date and time (DateTime)
• Contractor – contractor’s UnifiedName (unique short name which is set during the Contractor creation)
• PriceSet – price group’s UnifiedName (unique short name which is set during the PriceSet creation)

Logs

A read-only property used for writing logs. Contains the Add(string message) method.

Iteration

A technical read-only property that represents the sequential number of the product during processing (e.g., first, second, third, etc.).

Methods

double? ConvertPrice(double? price, string fromCurrency, string toCurrency)

Converts the price from one currency to another.

ReevaluationContextPricesWrapper GetPrices(Func<ReevaluationContractorPrice, bool> predicate = null)

Retrieves contractor prices in the system currency. Optionally, it can pass a predicate for filtering.

ReevaluationContextPricesWrapper GetPrices(string currency, Func<ReevaluationContractorPrice, bool> predicate = null)

Retrieves contractor prices in a specified currency. Optionally, it can pass a predicate for filtering.

Type ReevaluationContextPricesWrapper

Contains a ReevaluationContractorPrice[] Values array with prices and methods: double? Min(), double? Max(), double? Avg(), int Count().

Product script

ProductOld

A read-only property with product data:

• Price – a dictionary with product prices, the key is the UnifiedName of the price type, the value is the price (can be null)
• Currency – a dictionary with product price currencies, the key is the UnifiedName of the price type, the value is the currency (can be null)
• Property - a dictionary with product properties, the key is the UnifiedName of the property, the value is the product property value (can be null)
• Tag – a dictionary with product tags, the key is the UnifiedName of the tag, the value is true or false
• ExternalId – the product code in your system
• CategoryId – category code in your system
• Name – product name
• Vendor – vendor name
• VendorCode – article number
• CreationTime – product creation date (DateTime)
• Availability – UnifiedName of availability
• Catalog – UnifiedName of the catalog
• IsActive – product status (true/false)

Product

A property for writing:

• Availability – UnifiedName of availability type
• Price – a dictionary with product prices, the key UnifiedName of the price type, value = price (can be null).
• Currency – a dictionary with product price currencies, the key UnifiedName of the price type; value = currency (can be null)
• Tag – a dictionary with product tags, the key UnifiedName of the tag, value = true/false)
• Property – a dictionary with product properties, the key UnifiedName of the property, value = property value (string)

Status script

ProductOld

A read-only property with product data, the same as in the Product script.

Product

A property for writing:

• IsActive – true/false

Analysis

Consists of two scripts: columns and data. The script for calculating columns is executed once before the script for generating data for each product in these columns.

Columns

• Columns – property contains a method for adding a column:

Add(string dataField, string caption, int width, string alignment = null, string band = null, bool isFixed = false)

Data

• ProductOld – a read-only property with product data, the same as in the Product script
• Cell – a dictionary for filling data in cells, the key DataField column’s and the value is a CellData object

CellData type contains properties:

• Text – text in the cell
• ToolTip – tooltip on hover
• Background – background color
• Color – text color
• IconId – icon
• IconColor – icon color
• Href – link (if filled, the text will be displayed as a link)
• Bold – true/false
• Italic – true/false
• TextDecoration – underline/line-through

Updated on: 01/10/2024