Overview #

In addition to fixed price and percentage markups/markdowns on options and option groups, eCat provides a way for users to configure products with options like graded fabrics, customizable finishes, and other attributes that affect pricing differently depending on the product to which they are applied. Prices are automatically shown based on which product is being viewed and which options are selected by the user. This eliminates the need for complex price lists and time consuming calculations by automatically displaying prices based on which options are selected.

How it works #

• A special price file, 'matrix_options.csv', specifies prices of items configured with various combinations of priced option groups
• A boolean field on the product file named ‘OptionSet#Matrixed’ controls whether or not eCat looks up the item price in the matrix file based on the option groups associated with the user’s option selections in eCat.

Implementation
#

• Create groups of options of the same type and price which require matrix file price lookup.
• Create a matrix price file ‘matrix_options.csv’ with a record for each possible set of matrix priced option group choices.
• Populate the product file 'OptionSet#Matrixed' field with 'Y' for each option type that should be priced using the matrix file.
• Import the matrix file then check the file import log for an error report. Fix any reported errors in the file and re-import the file until no errors are reported.

Matrix price illustration #

Considerations #

• An ‘OptionGroup#’ field must be included in the matrix file for each ‘OptionSet#’ field in the product file.
• There must be a matching price record in the matrix price file for each price record in products.csv, including NetPrice.
• Multiple matrix priced option types can be applied to a single item in combination with other options where the price factor is defined on the option or option group.
• Non-matrix-priced option groups should not be referenced in the matrix price file.

Please contact SuperCat Solutions' help desk if you need more information about option matrix pricing.