Advanced Configuration Options (Price Grid)

allowAutoDeletionOfSubmittedPGI

Allows you to have PGIs in Submitted status auto deleted when the corresponding product is no longer eligible for the LPG (as per the dynamic item filter criteria).

Type – boolean

Sample valuetrue

allowPGIFieldTypeChange

If set to true, type of columns in LPG can be changed. This is a global setting, but then it can be also set individually on each LPG.

See alsoCreate and Configure New LPG

Type – boolean

autoGroupCalculationResultsInDetailsView

Groups results by the Result Group in Calculation Details.

See alsoHow to Group Calculation Results

Type – boolean

commentHistory

If set to true, history of comments in Price Lists, Manual Price Lists and Live Price Grids is captured and displayed in the product details screen Comment History.

Configured on page – Administration > Configuration > System Configuration > General Settings

See alsoGeneral Settings

Type – boolean

Sample valuefalse

defaultGroups

Sets which objects will be assigned the same default user groups as the creator has.

Configured on page – Administration > Configuration > System Configuration > Entitlements

See alsoEntitlements

Type – json object

Sample value{
    "quote" : true, 
    "contract" : true, 
    "rebateAgreement" : true, 
    "compensation" : false,
    "pricelist" : true, 
    "manualPricelist" : true, 
    "priceGrid" : false, 
    "simulation" : false, 
    "lookupTable" : false, 
    "dataChangeRequest" : false
}

defaultPGFormula

Name of a Logic. Defines a default calculation logic used for LPGs.

Configured on page – Administration > Configuration > Price Setting > Defaults for Price Lists and LPGs

See alsoDefaults for Price Lists and LPGs

Type – text

Sample valueCountryPLLogic

doNotStoreGlobalsForDirtyPass

Disables storing the content of api.global in the transition between passes. Note: This is only applies for cases where the first pass is non-distributed.

Type – boolean

doNotUsePerProductFormulasInLists

When set to true, price list calculations and price grid calculations will use the calculation logic specified in the list configuration only and not the logic that might be defined in the product master (which usually overrides the list-defined logic).

Type – boolean

extraExportColumnsConfig

When downloading a price list to Excel, this option expands one row matrices into individual columns. Example: {"PLI": {"<PLI_COLUMN_NAME1>": ["<MATRIX_FIELD_LABEL1>","<MATRIX_FIELD_LABEL2>"],"<PLI_COLUMN_NAME2>": […​]}}

Type – json object

Sample value{
    "XPLI" : {
        "LastTransaction" : [
            "Last Price Paid",
            "Last Price Paid Date",
            "Last Price Paid Order",
            "Last Price OV Flag"
        ]
    }
}

pgiDenialReasons

Allows you to predefine reasons for denial which are then shown to users who deny items in Live Price Grids.

Configured on page – Administration > Configuration > Price Setting > Denial Reasons (LPG)

See alsoDenial Reasons (LPG)

Type – json object

Sample value{
    "denialReasonsOptional" : false,
    "displayOther" : true,
    "reasons" : [ "R1", "R2", "R3" ]
}

priceGrid.eventBeforeRecalc

Determines if the recalculation event for a price grid item contains the payload showing the item before or after the recalc. Detailed explanation: When a PG item is recalculated an event is emitted. The event itself contains the item’s details as payload. There are cases, where it is desirable that the event has the old details in its payload (as the new ones can be easily retrieved by the event consumer and by that there can be sophisticated "delta" handling on the integration side for example. Other cases benefit from having the new item details (i.e. after new calculation) as payload as it saves the event consumer from querying the details separately. This flag toggles between these two modes.

Type – boolean

priceGridCancelPartialCalcsOnFullCalc

If set to true, a full LPG calculation cancels previously queued partial calculations. This behavior is applied to trackers in the "Waiting for dispatch" status.

Type – boolean

priceGridItemOfNonexistentSkuAction

  • "process" (DEFAULT) - will process it and show an error in the line.

  • "skip" - will skip it (and keep old values).

  • "invalidate" - Will invalidate it.

  • "hard-delete" - Will remove the item from the grid/list.

Option "process" causes the values to be recalculated according to the grid logic. This may mean that if the product had its own calculation logic, a different logic would be used, which may be unintentional. This is due to the fact that deleting the product also deletes the link between product and its product logic.

Type – text

Sample valueskip

priceGridItemPrefix

Sets the Price Grid Items prefix in their name. The default is PGI.

Type – text

Sample valuePGI-

publishingTemplates_<typeCode>

Specifies Excel or Word templates used for publishing documents to XLSX, PDF or DOC formats. You need to specify the type by adding a suffix: "publishingTemplates_Q" (Q for quotes; others respectively).

Configured on page – Administration > Configuration > Templates > Publishing Templates

See alsoPublishing Templates

Type – json object

Sample value{ "templates" : [ ] }

refreshPDEListOnUpdate

If set to true, the LPG detail view refreshes on update.

Type – boolean

shotgunThreshold

Sets a number describing how many items will be calculated in the distributed mode.

Type – number

Sample value5000

skipAutoApproveOnDirtyPGI

If set to true, it suppresses autoApprove when an item is dirty.

See alsoMulti-pass Calculation of a Pricelist or LPG

Type – boolean

startPagePanels

Allows you to define at the partition level the list of portlets that will be displayed on the Home page.

Configured on page – Administration > Configuration > System Configuration > Home Page

See alsoHome Page

Type – json array

Sample value[
    "pricelist", 
    "rebateManager", 
    "promotionManager", 
    "priceShop"
]

Found an issue in documentation? Write to us.