What Are Auto Filters
Auto Filters allow you to choose select products you allow/disallow select customers to view. As an administrator you are able to set parameter-based conditions for specific customers which filter specific products based on data pulled into Sage Ecommerce.
How Do They Work
Auto Filters are continuously running in the background but are only triggered when certain conditions are met. Auto filters are configured in System > Modules > Listing Manager > Auto Filter. When a condition is met the filter applies (or removes) a mask over a product. As a result customers which fall under these conditions will either be subject to the filter created. Setting up an Auto Filter requires 3 basic items: Description, Condition & Filter.
In this particular example we are looking to mask product to “DR001281” to customers who do not fall under the item codes “C01157, C01043, C04107, C03030, C03133, C04954, and C01020”.
Auto filters are very powerful based on the parameters you wish to put in place. Below is a full list of compatible parameters giving you full customization to the products you wish to display based on any of the parameters below.
Applicable Conditions & Filters
Condition | Filter | ||
---|---|---|---|
AND | MUST | ||
OR | MUST_NOT | ||
= | |||
< > | |||
IN | |||
NOT IN |
Available Fields For Use In Conditions and Filters
Type | Group | Entity | Field 1 | Field Type | id | ||||
productSearch | matchProductFinder | optionProductFinder | name | String | productSearch.matchProductFinder.optionProductFinder.name | ||||
Type | Group | Entity | Field 1 | Field 2 | Field Type | id | |||
productSearch | product | B2B Brands | description | String | productSearch.product.b2bBrands.description | ||||
productSearch | product | B2B Brands | id | String | productSearch.product.b2bBrands.id | ||||
productSearch | product | B2B Brands | metaDescription | String | productSearch.product.b2bBrands.metaDescription | ||||
productSearch | product | B2B Brands | metaKeywords | String | productSearch.product.b2bBrands.metaKeywords | ||||
productSearch | product | B2B Brands | metaTitle | String | productSearch.product.b2bBrands.metaTitle | ||||
productSearch | product | B2B Brands | name | String | productSearch.product.b2bBrands.name | ||||
productSearch | product | B2B Brands | parents | name | String | productSearch.product.b2bBrands.parents.name | |||
productSearch | product | B2B Categories | description | String | productSearch.product.b2bCategories.description | ||||
productSearch | product | B2B Categories | id | String | productSearch.product.b2bCategories.id | ||||
productSearch | product | B2B Categories | metaDescription | String | productSearch.product.b2bCategories.metaDescription | ||||
productSearch | product | B2B Categories | metaKeywords | String | productSearch.product.b2bCategories.metaKeywords | ||||
productSearch | product | B2B Categories | metaTitle | String | productSearch.product.b2bCategories.metaTitle | ||||
productSearch | product | B2B Categories | name | String | productSearch.product.b2bCategories.name | ||||
productSearch | product | B2B Categories | parents | name | String | productSearch.product.b2bCategories.parents.name | |||
productSearch | product | Public Brands | description | String | productSearch.product.b2cBrands.description | ||||
productSearch | product | Public Brands | id | String | productSearch.product.b2cBrands.id | ||||
productSearch | product | Public Brands | metaDescription | String | productSearch.product.b2cBrands.metaDescription | ||||
productSearch | product | Public Brands | metaKeywords | String | productSearch.product.b2cBrands.metaKeywords | ||||
productSearch | product | Public Brands | metaTitle | String | productSearch.product.b2cBrands.metaTitle | ||||
productSearch | product | Public Brands | name | String | productSearch.product.b2cBrands.name | ||||
productSearch | product | Public Brands | parents | name | String | productSearch.product.b2cBrands.parents.name | |||
productSearch | product | Public Categories | description | String | productSearch.product.b2cCategories.description | ||||
productSearch | product | Public Categories | id | String | productSearch.product.b2cCategories.id | ||||
productSearch | product | Public Categories | metaDescription | String | productSearch.product.b2cCategories.metaDescription | ||||
productSearch | product | Public Categories | metaKeywords | String | productSearch.product.b2cCategories.metaKeywords | ||||
productSearch | product | Public Categories | metaTitle | String | productSearch.product.b2cCategories.metaTitle | ||||
productSearch | product | Public Categories | name | String | productSearch.product.b2cCategories.name | ||||
productSearch | product | Public Categories | parents | name | String | productSearch.product.b2cCategories.parents.name | |||
Type | Group | Entity | Field 1 | Field 2 | Field 3 | Field 4 | Field 5 | Field Type | id |
productSearch | product | Configurable Items | configurationSets | groups | groupId | Integer | productSearch.product.configurations.configurationSets.groups.groupId | ||
productSearch | product | Configurable Items | configurationSets | groups | groupName | String | productSearch.product.configurations.configurationSets.groups.groupName | ||
productSearch | product | Configurable Items | configurationSets | groups | id | Integer | productSearch.product.configurations.configurationSets.groups.id | ||
productSearch | product | Configurable Items | configurationSets | groups | options | canNoneBeOrdered | Boolean | productSearch.product.configurations.configurationSets.groups.options.canNoneBeOrdered | |
productSearch | product | Configurable Items | configurationSets | groups | options | description | String | productSearch.product.configurations.configurationSets.groups.options.description | |
productSearch | product | Configurable Items | configurationSets | groups | options | hasNone | Boolean | productSearch.product.configurations.configurationSets.groups.options.hasNone | |
productSearch | product | Configurable Items | configurationSets | groups | options | id | Integer | productSearch.product.configurations.configurationSets.groups.options.id | |
productSearch | product | Configurable Items | configurationSets | groups | options | isNoneDefault | Boolean | productSearch.product.configurations.configurationSets.groups.options.isNoneDefault | |
productSearch | product | Configurable Items | configurationSets | groups | options | noneText | String | productSearch.product.configurations.configurationSets.groups.options.noneText | |
productSearch | product | Configurable Items | configurationSets | groups | options | optionId | Integer | productSearch.product.configurations.configurationSets.groups.options.optionId | |
productSearch | product | Configurable Items | configurationSets | groups | options | optionName | String | productSearch.product.configurations.configurationSets.groups.options.optionName | |
productSearch | product | Configurable Items | configurationSets | groups | options | type | String | productSearch.product.configurations.configurationSets.groups.options.type | |
productSearch | product | Configurable Items | configurationSets | groups | options | values | description | String | productSearch.product.configurations.configurationSets.groups.options.values.description |
productSearch | product | Configurable Items | configurationSets | groups | options | values | discountPercentage | String | productSearch.product.configurations.configurationSets.groups.options.values.discountPercentage |
productSearch | product | Configurable Items | configurationSets | groups | options | values | id | Integer | productSearch.product.configurations.configurationSets.groups.options.values.id |
productSearch | product | Configurable Items | configurationSets | groups | options | values | imageFull | String | productSearch.product.configurations.configurationSets.groups.options.values.imageFull |
productSearch | product | Configurable Items | configurationSets | groups | options | values | imageThumb | String | productSearch.product.configurations.configurationSets.groups.options.values.imageThumb |
productSearch | product | Configurable Items | configurationSets | groups | options | values | isSelectedDefault | Boolean | productSearch.product.configurations.configurationSets.groups.options.values.isSelectedDefault |
productSearch | product | Configurable Items | configurationSets | groups | options | values | isSelectedDefaultImage | Boolean | productSearch.product.configurations.configurationSets.groups.options.values.isSelectedDefaultImage |
productSearch | product | Configurable Items | configurationSets | groups | options | values | itemCode | String | productSearch.product.configurations.configurationSets.groups.options.values.itemCode |
productSearch | product | Configurable Items | configurationSets | groups | options | values | itemCodeFormatted | String | productSearch.product.configurations.configurationSets.groups.options.values.itemCodeFormatted |
productSearch | product | Configurable Items | configurationSets | groups | options | values | quantityMultiplier | Integer | productSearch.product.configurations.configurationSets.groups.options.values.quantityMultiplier |
productSearch | product | Configurable Items | configurationSets | id | Integer | productSearch.product.configurations.configurationSets.id | |||
productSearch | product | Configurable Items | configurationSets | setId | Integer | productSearch.product.configurations.configurationSets.setId | |||
productSearch | product | Configurable Items | configurationSets | setName | String | productSearch.product.configurations.configurationSets.setName | |||
productSearch | product | Configurable Items | unconditionalLinks | discountPercentage | Double | productSearch.product.configurations.unconditionalLinks.discountPercentage | |||
productSearch | product | Configurable Items | unconditionalLinks | id | Integer | productSearch.product.configurations.unconditionalLinks.id | |||
productSearch | product | Configurable Items | unconditionalLinks | itemCode | String | productSearch.product.configurations.unconditionalLinks.itemCode | |||
productSearch | product | Configurable Items | unconditionalLinks | quantityMultiplier | Integer | productSearch.product.configurations.unconditionalLinks.quantityMultiplier | |||
Type | Group | Entity | Field 1 | Field 2 | Field Type | id | |||
productSearch | product | Standard Items | defaultPriceList | String | productSearch.product.defaultPriceList | ||||
productSearch | product | Standard Items | defaultUnitConversion | String | productSearch.product.defaultUnitConversion | ||||
productSearch | product | Standard Items | defaultUnitOfMeasure | String | productSearch.product.defaultUnitOfMeasure | ||||
productSearch | product | Standard Items | description | String | productSearch.product.description | ||||
productSearch | product | Standard Items | hasStock | Boolean | productSearch.product.hasStock | ||||
productSearch | product | Standard Items | id | String | productSearch.product.id | ||||
productSearch | product | Standard Items | isKitItem | Boolean | productSearch.product.isKitItem | ||||
productSearch | product | Standard Items | isStockItem | Boolean | productSearch.product.isStockItem | ||||
productSearch | product | Standard Items | itemCode | String | productSearch.product.itemCode | ||||
productSearch | product | Standard Items | itemCodeFormatted | String | productSearch.product.itemCodeFormatted | ||||
productSearch | product | Standard Items | metaDescription | String | productSearch.product.metaDescription | ||||
productSearch | product | Standard Items | metaKeywords | String | productSearch.product.metaKeywords | ||||
productSearch | product | Standard Items | metaTitle | String | productSearch.product.metaTitle | ||||
productSearch | product | Standard Items | price | currencyCode | String | productSearch.product.price.currencyCode | |||
productSearch | product | Standard Items | price | customerCode | String | productSearch.product.price.customerCode | |||
productSearch | product | Standard Items | price | unitOfMeasure | String | productSearch.product.price.unitOfMeasure | |||
productSearch | product | Standard Items | price | warehouseCode | String | productSearch.product.price.warehouseCode | |||
productSearch | product | Standard Items | reviews | hasReviews | Boolean | productSearch.product.reviews.hasReviews | |||
productSearch | product | Standard Items | statisticalGroups | statisticalGroup0 | String | productSearch.product.statisticalGroups.statisticalGroup0 | |||
productSearch | product | Standard Items | statisticalGroups | statisticalGroup1 | String | productSearch.product.statisticalGroups.statisticalGroup1 | |||
productSearch | product | Standard Items | statisticalGroups | statisticalGroup2 | String | productSearch.product.statisticalGroups.statisticalGroup2 | |||
productSearch | product | Standard Items | statisticalGroups | statisticalGroup3 | String | productSearch.product.statisticalGroups.statisticalGroup3 | |||
productSearch | product | Standard Items | statisticalGroups | statisticalGroup4 | String | productSearch.product.statisticalGroups.statisticalGroup4 | |||
productSearch | product | Standard Items | stocks | description | String | productSearch.product.stocks.description | |||
productSearch | product | Standard Items | stocks | itemCode | String | productSearch.product.stocks.itemCode | |||
productSearch | product | Standard Items | stocks | warehouseCode | String | productSearch.product.stocks.warehouseCode | |||
productSearch | product | Standard Items | type | String | productSearch.product.type | ||||
productSearch | product | Standard Items | upcCode | String | productSearch.product.upcCode | ||||
productSearch | product | Standard Items | variantPriceItemCode | String | productSearch.product.variantPriceItemCode | ||||
Type | Group | Entity | Field 1 | Field 2 | Field 3 | Field Type | id | ||
productSearch | product | Variation Items | numberOfVariationProducts | Integer | productSearch.product.variations.numberOfVariationProducts | ||||
productSearch | product | Variation Items | options | id | Integer | productSearch.product.variations.options.id | |||
productSearch | product | Variation Items | options | ishideIfUnavailable | Boolean | productSearch.product.variations.options.ishideIfUnavailable | |||
productSearch | product | Variation Items | options | isSequential | Boolean | productSearch.product.variations.options.isSequential | |||
productSearch | product | Variation Items | options | name | String | productSearch.product.variations.options.name | |||
productSearch | product | Variation Items | options | order | Integer | productSearch.product.variations.options.order | |||
productSearch | product | Variation Items | options | type | String | productSearch.product.variations.options.type | |||
productSearch | product | Variation Items | options | values | id | Integer | productSearch.product.variations.options.values.id | ||
productSearch | product | Variation Items | options | values | name | String | productSearch.product.variations.options.values.name | ||
productSearch | product | Variation Items | options | values | order | Integer | productSearch.product.variations.options.values.order | ||
productSearch | product | Variation Items | options | values | productImage | String | productSearch.product.variations.options.values.productImage | ||
productSearch | product | Variation Items | options | values | swatchImage | String | productSearch.product.variations.options.values.swatchImage | ||
productSearch | product | Variation Items | options | values | swatchImageUnavailable | String | productSearch.product.variations.options.values.swatchImageUnavailable | ||
productSearch | product | Variation Items | variationKeywords | itemCode | String | productSearch.product.variations.variationKeywords.itemCode | |||
productSearch | product | Variation Items | variations | combination | name | String | productSearch.product.variations.variations.combination.name | ||
productSearch | product | Variation Items | variations | combination | nameId | Integer | productSearch.product.variations.variations.combination.nameId | ||
productSearch | product | Variation Items | variations | combination | order | Integer | productSearch.product.variations.variations.combination.order | ||
productSearch | product | Variation Items | variations | combination | value | String | productSearch.product.variations.variations.combination.value | ||
productSearch | product | Variation Items | variations | combination | valueId | Integer | productSearch.product.variations.variations.combination.valueId | ||
productSearch | product | Variation Items | variations | product | itemCode | String | productSearch.product.variations.variations.product.itemCode | ||
Type | Group | Entity | Field 1 | Field Type | id | ||||
productSearch | product | details | additionalDetails | String | productSearch.product.details.additionalDetails | ||||
productSearch | product | details | additionalTab | String | productSearch.product.details.additionalTab | ||||
productSearch | product | details | description | String | productSearch.product.details.description | ||||
productSearch | product | details | feature | String | productSearch.product.details.feature | ||||
productSearch | product | details | formId | Integer | productSearch.product.details.formId | ||||
productSearch | product | details | fractionalQuantity | Integer | productSearch.product.details.fractionalQuantity | ||||
productSearch | product | details | includes | String | productSearch.product.details.includes | ||||
productSearch | product | details | isPoaB2b | Boolean | productSearch.product.details.isPoaB2b | ||||
productSearch | product | details | isPoaB2c | Boolean | productSearch.product.details.isPoaB2c | ||||
productSearch | product | details | isVirtual | Boolean | productSearch.product.details.isVirtual | ||||
productSearch | product | details | itemCode | String | productSearch.product.details.itemCode | ||||
productSearch | product | details | metaDescription | String | productSearch.product.details.metaDescription | ||||
productSearch | product | details | metaKeywords | String | productSearch.product.details.metaKeywords | ||||
productSearch | product | details | metaTitle | String | productSearch.product.details.metaTitle | ||||
productSearch | product | details | orderComment | Integer | productSearch.product.details.orderComment | ||||
productSearch | product | details | requestList | Integer | productSearch.product.details.requestList | ||||
productSearch | product | details | secondaryDescription | String | productSearch.product.details.secondaryDescription | ||||
productSearch | product | details | specification | String | productSearch.product.details.specification |
Product Related
Type | Group | Entity | Field 1 | Field Type | id | ||||
productSearch | matchProductFinder | optionProductFinder | name | String | productSearch.matchProductFinder.optionProductFinder.name | ||||
Type | Group | Entity | Field 1 | Field 2 | Field Type | id | |||
productSearch | product | B2B Brands | description | String | productSearch.product.b2bBrands.description | ||||
productSearch | product | B2B Brands | id | String | productSearch.product.b2bBrands.id | ||||
productSearch | product | B2B Brands | metaDescription | String | productSearch.product.b2bBrands.metaDescription | ||||
productSearch | product | B2B Brands | metaKeywords | String | productSearch.product.b2bBrands.metaKeywords | ||||
productSearch | product | B2B Brands | metaTitle | String | productSearch.product.b2bBrands.metaTitle | ||||
productSearch | product | B2B Brands | name | String | productSearch.product.b2bBrands.name | ||||
productSearch | product | B2B Brands | parents | name | String | productSearch.product.b2bBrands.parents.name | |||
productSearch | product | B2B Categories | description | String | productSearch.product.b2bCategories.description | ||||
productSearch | product | B2B Categories | id | String | productSearch.product.b2bCategories.id | ||||
productSearch | product | B2B Categories | metaDescription | String | productSearch.product.b2bCategories.metaDescription | ||||
productSearch | product | B2B Categories | metaKeywords | String | productSearch.product.b2bCategories.metaKeywords | ||||
productSearch | product | B2B Categories | metaTitle | String | productSearch.product.b2bCategories.metaTitle | ||||
productSearch | product | B2B Categories | name | String | productSearch.product.b2bCategories.name | ||||
productSearch | product | B2B Categories | parents | name | String | productSearch.product.b2bCategories.parents.name | |||
productSearch | product | Public Brands | description | String | productSearch.product.b2cBrands.description | ||||
productSearch | product | Public Brands | id | String | productSearch.product.b2cBrands.id | ||||
productSearch | product | Public Brands | metaDescription | String | productSearch.product.b2cBrands.metaDescription | ||||
productSearch | product | Public Brands | metaKeywords | String | productSearch.product.b2cBrands.metaKeywords | ||||
productSearch | product | Public Brands | metaTitle | String | productSearch.product.b2cBrands.metaTitle | ||||
productSearch | product | Public Brands | name | String | productSearch.product.b2cBrands.name | ||||
productSearch | product | Public Brands | parents | name | String | productSearch.product.b2cBrands.parents.name | |||
productSearch | product | Public Categories | description | String | productSearch.product.b2cCategories.description | ||||
productSearch | product | Public Categories | id | String | productSearch.product.b2cCategories.id | ||||
productSearch | product | Public Categories | metaDescription | String | productSearch.product.b2cCategories.metaDescription | ||||
productSearch | product | Public Categories | metaKeywords | String | productSearch.product.b2cCategories.metaKeywords | ||||
productSearch | product | Public Categories | metaTitle | String | productSearch.product.b2cCategories.metaTitle | ||||
productSearch | product | Public Categories | name | String | productSearch.product.b2cCategories.name | ||||
productSearch | product | Public Categories | parents | name | String | productSearch.product.b2cCategories.parents.name | |||
Type | Group | Entity | Field 1 | Field 2 | Field 3 | Field 4 | Field 5 | Field Type | id |
productSearch | product | Configurable Items | configurationSets | groups | groupId | Integer | productSearch.product.configurations.configurationSets.groups.groupId | ||
productSearch | product | Configurable Items | configurationSets | groups | groupName | String | productSearch.product.configurations.configurationSets.groups.groupName | ||
productSearch | product | Configurable Items | configurationSets | groups | id | Integer | productSearch.product.configurations.configurationSets.groups.id | ||
productSearch | product | Configurable Items | configurationSets | groups | options | canNoneBeOrdered | Boolean | productSearch.product.configurations.configurationSets.groups.options.canNoneBeOrdered | |
productSearch | product | Configurable Items | configurationSets | groups | options | description | String | productSearch.product.configurations.configurationSets.groups.options.description | |
productSearch | product | Configurable Items | configurationSets | groups | options | hasNone | Boolean | productSearch.product.configurations.configurationSets.groups.options.hasNone | |
productSearch | product | Configurable Items | configurationSets | groups | options | id | Integer | productSearch.product.configurations.configurationSets.groups.options.id | |
productSearch | product | Configurable Items | configurationSets | groups | options | isNoneDefault | Boolean | productSearch.product.configurations.configurationSets.groups.options.isNoneDefault | |
productSearch | product | Configurable Items | configurationSets | groups | options | noneText | String | productSearch.product.configurations.configurationSets.groups.options.noneText | |
productSearch | product | Configurable Items | configurationSets | groups | options | optionId | Integer | productSearch.product.configurations.configurationSets.groups.options.optionId | |
productSearch | product | Configurable Items | configurationSets | groups | options | optionName | String | productSearch.product.configurations.configurationSets.groups.options.optionName | |
productSearch | product | Configurable Items | configurationSets | groups | options | type | String | productSearch.product.configurations.configurationSets.groups.options.type | |
productSearch | product | Configurable Items | configurationSets | groups | options | values | description | String | productSearch.product.configurations.configurationSets.groups.options.values.description |
productSearch | product | Configurable Items | configurationSets | groups | options | values | discountPercentage | String | productSearch.product.configurations.configurationSets.groups.options.values.discountPercentage |
productSearch | product | Configurable Items | configurationSets | groups | options | values | id | Integer | productSearch.product.configurations.configurationSets.groups.options.values.id |
productSearch | product | Configurable Items | configurationSets | groups | options | values | imageFull | String | productSearch.product.configurations.configurationSets.groups.options.values.imageFull |
productSearch | product | Configurable Items | configurationSets | groups | options | values | imageThumb | String | productSearch.product.configurations.configurationSets.groups.options.values.imageThumb |
productSearch | product | Configurable Items | configurationSets | groups | options | values | isSelectedDefault | Boolean | productSearch.product.configurations.configurationSets.groups.options.values.isSelectedDefault |
productSearch | product | Configurable Items | configurationSets | groups | options | values | isSelectedDefaultImage | Boolean | productSearch.product.configurations.configurationSets.groups.options.values.isSelectedDefaultImage |
productSearch | product | Configurable Items | configurationSets | groups | options | values | itemCode | String | productSearch.product.configurations.configurationSets.groups.options.values.itemCode |
productSearch | product | Configurable Items | configurationSets | groups | options | values | itemCodeFormatted | String | productSearch.product.configurations.configurationSets.groups.options.values.itemCodeFormatted |
productSearch | product | Configurable Items | configurationSets | groups | options | values | quantityMultiplier | Integer | productSearch.product.configurations.configurationSets.groups.options.values.quantityMultiplier |
productSearch | product | Configurable Items | configurationSets | id | Integer | productSearch.product.configurations.configurationSets.id | |||
productSearch | product | Configurable Items | configurationSets | setId | Integer | productSearch.product.configurations.configurationSets.setId | |||
productSearch | product | Configurable Items | configurationSets | setName | String | productSearch.product.configurations.configurationSets.setName | |||
productSearch | product | Configurable Items | unconditionalLinks | discountPercentage | Double | productSearch.product.configurations.unconditionalLinks.discountPercentage | |||
productSearch | product | Configurable Items | unconditionalLinks | id | Integer | productSearch.product.configurations.unconditionalLinks.id | |||
productSearch | product | Configurable Items | unconditionalLinks | itemCode | String | productSearch.product.configurations.unconditionalLinks.itemCode | |||
productSearch | product | Configurable Items | unconditionalLinks | quantityMultiplier | Integer | productSearch.product.configurations.unconditionalLinks.quantityMultiplier | |||
Type | Group | Entity | Field 1 | Field 2 | Field Type | id | |||
productSearch | product | Standard Items | defaultPriceList | String | productSearch.product.defaultPriceList | ||||
productSearch | product | Standard Items | defaultUnitConversion | String | productSearch.product.defaultUnitConversion | ||||
productSearch | product | Standard Items | defaultUnitOfMeasure | String | productSearch.product.defaultUnitOfMeasure | ||||
productSearch | product | Standard Items | description | String | productSearch.product.description | ||||
productSearch | product | Standard Items | hasStock | Boolean | productSearch.product.hasStock | ||||
productSearch | product | Standard Items | id | String | productSearch.product.id | ||||
productSearch | product | Standard Items | isKitItem | Boolean | productSearch.product.isKitItem | ||||
productSearch | product | Standard Items | isStockItem | Boolean | productSearch.product.isStockItem | ||||
productSearch | product | Standard Items | itemCode | String | productSearch.product.itemCode | ||||
productSearch | product | Standard Items | itemCodeFormatted | String | productSearch.product.itemCodeFormatted | ||||
productSearch | product | Standard Items | metaDescription | String | productSearch.product.metaDescription | ||||
productSearch | product | Standard Items | metaKeywords | String | productSearch.product.metaKeywords | ||||
productSearch | product | Standard Items | metaTitle | String | productSearch.product.metaTitle | ||||
productSearch | product | Standard Items | price | currencyCode | String | productSearch.product.price.currencyCode | |||
productSearch | product | Standard Items | price | customerCode | String | productSearch.product.price.customerCode | |||
productSearch | product | Standard Items | price | unitOfMeasure | String | productSearch.product.price.unitOfMeasure | |||
productSearch | product | Standard Items | price | warehouseCode | String | productSearch.product.price.warehouseCode | |||
productSearch | product | Standard Items | reviews | hasReviews | Boolean | productSearch.product.reviews.hasReviews | |||
productSearch | product | Standard Items | statisticalGroups | statisticalGroup0 | String | productSearch.product.statisticalGroups.statisticalGroup0 | |||
productSearch | product | Standard Items | statisticalGroups | statisticalGroup1 | String | productSearch.product.statisticalGroups.statisticalGroup1 | |||
productSearch | product | Standard Items | statisticalGroups | statisticalGroup2 | String | productSearch.product.statisticalGroups.statisticalGroup2 | |||
productSearch | product | Standard Items | statisticalGroups | statisticalGroup3 | String | productSearch.product.statisticalGroups.statisticalGroup3 | |||
productSearch | product | Standard Items | statisticalGroups | statisticalGroup4 | String | productSearch.product.statisticalGroups.statisticalGroup4 | |||
productSearch | product | Standard Items | stocks | description | String | productSearch.product.stocks.description | |||
productSearch | product | Standard Items | stocks | itemCode | String | productSearch.product.stocks.itemCode | |||
productSearch | product | Standard Items | stocks | warehouseCode | String | productSearch.product.stocks.warehouseCode | |||
productSearch | product | Standard Items | type | String | productSearch.product.type | ||||
productSearch | product | Standard Items | upcCode | String | productSearch.product.upcCode | ||||
productSearch | product | Standard Items | variantPriceItemCode | String | productSearch.product.variantPriceItemCode | ||||
Type | Group | Entity | Field 1 | Field 2 | Field 3 | Field Type | id | ||
productSearch | product | Variation Items | numberOfVariationProducts | Integer | productSearch.product.variations.numberOfVariationProducts | ||||
productSearch | product | Variation Items | options | id | Integer | productSearch.product.variations.options.id | |||
productSearch | product | Variation Items | options | ishideIfUnavailable | Boolean | productSearch.product.variations.options.ishideIfUnavailable | |||
productSearch | product | Variation Items | options | isSequential | Boolean | productSearch.product.variations.options.isSequential | |||
productSearch | product | Variation Items | options | name | String | productSearch.product.variations.options.name | |||
productSearch | product | Variation Items | options | order | Integer | productSearch.product.variations.options.order | |||
productSearch | product | Variation Items | options | type | String | productSearch.product.variations.options.type | |||
productSearch | product | Variation Items | options | values | id | Integer | productSearch.product.variations.options.values.id | ||
productSearch | product | Variation Items | options | values | name | String | productSearch.product.variations.options.values.name | ||
productSearch | product | Variation Items | options | values | order | Integer | productSearch.product.variations.options.values.order | ||
productSearch | product | Variation Items | options | values | productImage | String | productSearch.product.variations.options.values.productImage | ||
productSearch | product | Variation Items | options | values | swatchImage | String | productSearch.product.variations.options.values.swatchImage | ||
productSearch | product | Variation Items | options | values | swatchImageUnavailable | String | productSearch.product.variations.options.values.swatchImageUnavailable | ||
productSearch | product | Variation Items | variationKeywords | itemCode | String | productSearch.product.variations.variationKeywords.itemCode | |||
productSearch | product | Variation Items | variations | combination | name | String | productSearch.product.variations.variations.combination.name | ||
productSearch | product | Variation Items | variations | combination | nameId | Integer | productSearch.product.variations.variations.combination.nameId | ||
productSearch | product | Variation Items | variations | combination | order | Integer | productSearch.product.variations.variations.combination.order | ||
productSearch | product | Variation Items | variations | combination | value | String | productSearch.product.variations.variations.combination.value | ||
productSearch | product | Variation Items | variations | combination | valueId | Integer | productSearch.product.variations.variations.combination.valueId | ||
productSearch | product | Variation Items | variations | product | itemCode | String | productSearch.product.variations.variations.product.itemCode | ||
Type | Group | Entity | Field 1 | Field Type | id | ||||
productSearch | product | details | additionalDetails | String | productSearch.product.details.additionalDetails | ||||
productSearch | product | details | additionalTab | String | productSearch.product.details.additionalTab | ||||
productSearch | product | details | description | String | productSearch.product.details.description | ||||
productSearch | product | details | feature | String | productSearch.product.details.feature | ||||
productSearch | product | details | formId | Integer | productSearch.product.details.formId | ||||
productSearch | product | details | fractionalQuantity | Integer | productSearch.product.details.fractionalQuantity | ||||
productSearch | product | details | includes | String | productSearch.product.details.includes | ||||
productSearch | product | details | isPoaB2b | Boolean | productSearch.product.details.isPoaB2b | ||||
productSearch | product | details | isPoaB2c | Boolean | productSearch.product.details.isPoaB2c | ||||
productSearch | product | details | isVirtual | Boolean | productSearch.product.details.isVirtual | ||||
productSearch | product | details | itemCode | String | productSearch.product.details.itemCode | ||||
productSearch | product | details | metaDescription | String | productSearch.product.details.metaDescription | ||||
productSearch | product | details | metaKeywords | String | productSearch.product.details.metaKeywords | ||||
productSearch | product | details | metaTitle | String | productSearch.product.details.metaTitle | ||||
productSearch | product | details | orderComment | Integer | productSearch.product.details.orderComment | ||||
productSearch | product | details | requestList | Integer | productSearch.product.details.requestList | ||||
productSearch | product | details | secondaryDescription | String | productSearch.product.details.secondaryDescription | ||||
productSearch | product | details | specification | String | productSearch.product.details.specification |
User and Customer Related
Type | Group | Entity | Field | Field Type | id |
user | customer | Customers | address1 | String | user.customer.address1 |
user | customer | Customers | address2 | String | user.customer.address2 |
user | customer | Customers | address3 | String | user.customer.address3 |
user | customer | Customers | address4 | String | user.customer.address4 |
user | customer | Customers | city | String | user.customer.city |
user | customer | Customers | contactEmail | String | user.customer.contactEmail |
user | customer | Customers | contactFax | String | user.customer.contactFax |
user | customer | Customers | contactName | String | user.customer.contactName |
user | customer | Customers | contactPhone | String | user.customer.contactPhone |
user | customer | Customers | countryCode | String | user.customer.countryCode |
user | customer | Customers | currencyCode | String | user.customer.currencyCode |
user | customer | Customers | customerCode | String | user.customer.customerCode |
user | customer | Customers | customerGroup | String | user.customer.customerGroup |
user | customer | Customers | customerType | String | user.customer.customerType |
user | customer | Customers | String | user.customer.email | |
user | customer | Customers | fax | String | user.customer.fax |
user | customer | Customers | id | Integer | user.customer.id |
user | customer | Customers | name | String | user.customer.name |
user | customer | Customers | paymentCodeTerm | String | user.customer.paymentCodeTerm |
user | customer | Customers | phone | String | user.customer.phone |
user | customer | Customers | priceCode | String | user.customer.priceCode |
user | customer | Customers | primaryShippingLocation | String | user.customer.primaryShippingLocation |
user | customer | Customers | state | String | user.customer.state |
user | customer | Customers | status | String | user.customer.status |
user | customer | Customers | suburb | String | user.customer.suburb |
user | customer | Customers | taxGroup | String | user.customer.taxGroup |
user | customer | Customers | zip | String | user.customer.zip |
Type | Group | Entity | Field | Field Type | id |
user | customer | priceList | description | String | user.customer.priceList.description |
user | customer | priceList | id | String | user.customer.priceList.id |
user | customer | priceList | isExclude | String | user.customer.priceList.isExclude |
user | customer | priceList | priceListCode | String | user.customer.priceList.priceListCode |
Type | Entity | Field | Field Type | id | |
user | user | String | user.email | ||
user | user | firstName | String | user.firstName | |
user | user | groupId | Integer | user.groupId | |
user | user | isApproved | Boolean | user.isApproved | |
user | user | isB2b | Boolean | user.isB2b | |
user | user | isDeleted | Boolean | user.isDeleted | |
user | user | lastName | String | user.lastName | |
user | user | locale | String | user.locale | |
user | user | username | String | user.username | |
Type | Group | Entity | Field | Field Type | id |
user | customer | businessPartnerCustomer | accountingCode | String | user.customer.businessPartnerCustomer.accountingCode |
user | customer | businessPartnerCustomer | analyticalDimension0 | String | user.customer.businessPartnerCustomer.analyticalDimension0 |
user | customer | businessPartnerCustomer | analyticalDimension1 | String | user.customer.businessPartnerCustomer.analyticalDimension1 |
user | customer | businessPartnerCustomer | analyticalDimension10 | String | user.customer.businessPartnerCustomer.analyticalDimension10 |
user | customer | businessPartnerCustomer | analyticalDimension11 | String | user.customer.businessPartnerCustomer.analyticalDimension11 |
user | customer | businessPartnerCustomer | analyticalDimension12 | String | user.customer.businessPartnerCustomer.analyticalDimension12 |
user | customer | businessPartnerCustomer | analyticalDimension13 | String | user.customer.businessPartnerCustomer.analyticalDimension13 |
user | customer | businessPartnerCustomer | analyticalDimension14 | String | user.customer.businessPartnerCustomer.analyticalDimension14 |
user | customer | businessPartnerCustomer | analyticalDimension15 | String | user.customer.businessPartnerCustomer.analyticalDimension15 |
user | customer | businessPartnerCustomer | analyticalDimension16 | String | user.customer.businessPartnerCustomer.analyticalDimension16 |
user | customer | businessPartnerCustomer | analyticalDimension17 | String | user.customer.businessPartnerCustomer.analyticalDimension17 |
user | customer | businessPartnerCustomer | analyticalDimension18 | String | user.customer.businessPartnerCustomer.analyticalDimension18 |
user | customer | businessPartnerCustomer | analyticalDimension19 | String | user.customer.businessPartnerCustomer.analyticalDimension19 |
user | customer | businessPartnerCustomer | analyticalDimension2 | String | user.customer.businessPartnerCustomer.analyticalDimension2 |
user | customer | businessPartnerCustomer | analyticalDimension3 | String | user.customer.businessPartnerCustomer.analyticalDimension3 |
user | customer | businessPartnerCustomer | analyticalDimension4 | String | user.customer.businessPartnerCustomer.analyticalDimension4 |
user | customer | businessPartnerCustomer | analyticalDimension5 | String | user.customer.businessPartnerCustomer.analyticalDimension5 |
user | customer | businessPartnerCustomer | analyticalDimension6 | String | user.customer.businessPartnerCustomer.analyticalDimension6 |
user | customer | businessPartnerCustomer | analyticalDimension7 | String | user.customer.businessPartnerCustomer.analyticalDimension7 |
user | customer | businessPartnerCustomer | analyticalDimension8 | String | user.customer.businessPartnerCustomer.analyticalDimension8 |
user | customer | businessPartnerCustomer | analyticalDimension9 | String | user.customer.businessPartnerCustomer.analyticalDimension9 |
user | customer | businessPartnerCustomer | bank | String | user.customer.businessPartnerCustomer.bank |
user | customer | businessPartnerCustomer | billTo | String | user.customer.businessPartnerCustomer.billTo |
user | customer | businessPartnerCustomer | billToAddress | String | user.customer.businessPartnerCustomer.billToAddress |
user | customer | businessPartnerCustomer | business | String | user.customer.businessPartnerCustomer.business |
user | customer | businessPartnerCustomer | category | String | user.customer.businessPartnerCustomer.category |
user | customer | businessPartnerCustomer | currencyCode | String | user.customer.businessPartnerCustomer.currencyCode |
user | customer | businessPartnerCustomer | customerCode | String | user.customer.businessPartnerCustomer.customerCode |
user | customer | businessPartnerCustomer | defaultAddress | String | user.customer.businessPartnerCustomer.defaultAddress |
user | customer | businessPartnerCustomer | defaultContact | String | user.customer.businessPartnerCustomer.defaultContact |
user | customer | businessPartnerCustomer | defaultDeliveryAddress | String | user.customer.businessPartnerCustomer.defaultDeliveryAddress |
user | customer | businessPartnerCustomer | dimensionTypeCode0 | String | user.customer.businessPartnerCustomer.dimensionTypeCode0 |
user | customer | businessPartnerCustomer | dimensionTypeCode1 | String | user.customer.businessPartnerCustomer.dimensionTypeCode1 |
user | customer | businessPartnerCustomer | dimensionTypeCode10 | String | user.customer.businessPartnerCustomer.dimensionTypeCode10 |
user | customer | businessPartnerCustomer | dimensionTypeCode11 | String | user.customer.businessPartnerCustomer.dimensionTypeCode11 |
user | customer | businessPartnerCustomer | dimensionTypeCode12 | String | user.customer.businessPartnerCustomer.dimensionTypeCode12 |
user | customer | businessPartnerCustomer | dimensionTypeCode13 | String | user.customer.businessPartnerCustomer.dimensionTypeCode13 |
user | customer | businessPartnerCustomer | dimensionTypeCode14 | String | user.customer.businessPartnerCustomer.dimensionTypeCode14 |
user | customer | businessPartnerCustomer | dimensionTypeCode15 | String | user.customer.businessPartnerCustomer.dimensionTypeCode15 |
user | customer | businessPartnerCustomer | dimensionTypeCode16 | String | user.customer.businessPartnerCustomer.dimensionTypeCode16 |
user | customer | businessPartnerCustomer | dimensionTypeCode17 | String | user.customer.businessPartnerCustomer.dimensionTypeCode17 |
user | customer | businessPartnerCustomer | dimensionTypeCode18 | String | user.customer.businessPartnerCustomer.dimensionTypeCode18 |
user | customer | businessPartnerCustomer | dimensionTypeCode19 | String | user.customer.businessPartnerCustomer.dimensionTypeCode19 |
user | customer | businessPartnerCustomer | dimensionTypeCode2 | String | user.customer.businessPartnerCustomer.dimensionTypeCode2 |
user | customer | businessPartnerCustomer | dimensionTypeCode3 | String | user.customer.businessPartnerCustomer.dimensionTypeCode3 |
user | customer | businessPartnerCustomer | dimensionTypeCode4 | String | user.customer.businessPartnerCustomer.dimensionTypeCode4 |
user | customer | businessPartnerCustomer | dimensionTypeCode5 | String | user.customer.businessPartnerCustomer.dimensionTypeCode5 |
user | customer | businessPartnerCustomer | dimensionTypeCode6 | String | user.customer.businessPartnerCustomer.dimensionTypeCode6 |
user | customer | businessPartnerCustomer | dimensionTypeCode7 | String | user.customer.businessPartnerCustomer.dimensionTypeCode7 |
user | customer | businessPartnerCustomer | dimensionTypeCode8 | String | user.customer.businessPartnerCustomer.dimensionTypeCode8 |
user | customer | businessPartnerCustomer | dimensionTypeCode9 | String | user.customer.businessPartnerCustomer.dimensionTypeCode9 |
user | customer | businessPartnerCustomer | exportNumber | String | user.customer.businessPartnerCustomer.exportNumber |
user | customer | businessPartnerCustomer | factor | String | user.customer.businessPartnerCustomer.factor |
user | customer | businessPartnerCustomer | group | String | user.customer.businessPartnerCustomer.group |
user | customer | businessPartnerCustomer | groupCustomer | String | user.customer.businessPartnerCustomer.groupCustomer |
user | customer | businessPartnerCustomer | id | String | user.customer.businessPartnerCustomer.id |
user | customer | businessPartnerCustomer | isActive | Boolean | user.customer.businessPartnerCustomer.isActive |
user | customer | businessPartnerCustomer | isProspect | Boolean | user.customer.businessPartnerCustomer.isProspect |
user | customer | businessPartnerCustomer | name | String | user.customer.businessPartnerCustomer.name |
user | customer | businessPartnerCustomer | notes | String | user.customer.businessPartnerCustomer.notes |
user | customer | businessPartnerCustomer | payBy | String | user.customer.businessPartnerCustomer.payBy |
user | customer | businessPartnerCustomer | payByAddress | String | user.customer.businessPartnerCustomer.payByAddress |
user | customer | businessPartnerCustomer | paymentTerms | String | user.customer.businessPartnerCustomer.paymentTerms |
user | customer | businessPartnerCustomer | provinceTaxCode | String | user.customer.businessPartnerCustomer.provinceTaxCode |
user | customer | businessPartnerCustomer | riskBy | String | user.customer.businessPartnerCustomer.riskBy |
user | customer | businessPartnerCustomer | salesRep0 | String | user.customer.businessPartnerCustomer.salesRep0 |
user | customer | businessPartnerCustomer | salesRep1 | String | user.customer.businessPartnerCustomer.salesRep1 |
user | customer | businessPartnerCustomer | shortTitle | String | user.customer.businessPartnerCustomer.shortTitle |
user | customer | businessPartnerCustomer | statisticalGroup0 | String | user.customer.businessPartnerCustomer.statisticalGroup0 |
user | customer | businessPartnerCustomer | statisticalGroup1 | String | user.customer.businessPartnerCustomer.statisticalGroup1 |
user | customer | businessPartnerCustomer | statisticalGroup2 | String | user.customer.businessPartnerCustomer.statisticalGroup2 |
user | customer | businessPartnerCustomer | statisticalGroup3 | String | user.customer.businessPartnerCustomer.statisticalGroup3 |
user | customer | businessPartnerCustomer | statisticalGroup4 | String | user.customer.businessPartnerCustomer.statisticalGroup4 |
user | customer | businessPartnerCustomer | supplierNumber | String | user.customer.businessPartnerCustomer.supplierNumber |
user | customer | businessPartnerCustomer | taxExemptionNumber | String | user.customer.businessPartnerCustomer.taxExemptionNumber |
user | customer | businessPartnerCustomer | taxRule | String | user.customer.businessPartnerCustomer.taxRule |
user | customer | businessPartnerCustomer | templateCode | String | user.customer.businessPartnerCustomer.templateCode |
Type | Entity | Field | Field Type | id | |
user | warehouse | address1 | String | user.warehouse.address1 | |
user | warehouse | address2 | String | user.warehouse.address2 | |
user | warehouse | address3 | String | user.warehouse.address3 | |
user | warehouse | address4 | String | user.warehouse.address4 | |
user | warehouse | country | String | user.warehouse.country | |
user | warehouse | description | String | user.warehouse.description | |
user | warehouse | id | Integer | user.warehouse.id | |
user | warehouse | isExclude | Boolean | user.warehouse.isExclude | |
user | warehouse | legislation | String | user.warehouse.legislation | |
user | warehouse | state | String | user.warehouse.state | |
user | warehouse | suburb | String | user.warehouse.suburb | |
user | warehouse | suffix | String | user.warehouse.suffix | |
user | warehouse | warehouseCode | String | user.warehouse.warehouseCode | |
user | warehouse | zip | String | user.warehouse.zip |