Import-pipeline table provider that inserts and updates product parameter options, commonly called product variants. A ProductParameter is an attribute a product can vary by, such as size or colour, and each parameter can have several options, for example the colour parameter might offer red and blue. Registered under the provider id "productOptions" and looked up by a DatabaseUpdateStep configured with that id. Rows are matched by productCode, parameterCode and name, creating the parameter and the option on insert if they do not already exist. Deleting options is not supported.

Implements: DatabaseTableProvider


Properties

PropertyReturnsDescription
providerIdStringProvider id this class is registered under. Used to select it from a DatabaseUpdateStep configuration.
queryParametersList<TableParameter>Query parameters this provider accepts when building its source criteria.
tableFieldsList<TableParameter>Describes the row columns this provider accepts for insert and update: productCode (the parent product's SKU), parameterCode and parameterTitle (identifying the parameter, eg colour), name and title (identifying and describing the option, eg black / Glossy Black), and cost (the option's incremental cost).

Methods

getProviderId()

Returns: String

Provider id this class is registered under. Used to select it from a DatabaseUpdateStep configuration.

getQueryParameters()

Returns: List<TableParameter>

Query parameters this provider accepts when building its source criteria.

getTableFields()

Returns: List<TableParameter>

Describes the row columns this provider accepts for insert and update: productCode (the parent product's SKU), parameterCode and parameterTitle (identifying the parameter, eg colour), name and title (identifying and describing the option, eg black / Glossy Black), and cost (the option's incremental cost).

To get full access to the Kademi Hub existing customers can login here, or new customers can register here.