Auto-Filters

Auto-filters are not supported, this code is in the process of being deprecated.


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

TypeGroupEntityField 1Field Typeid



productSearchmatchProductFinderoptionProductFindernameStringproductSearch.matchProductFinder.optionProductFinder.name












TypeGroupEntityField 1Field 2Field Typeid


productSearchproductB2B Brandsdescription
StringproductSearch.product.b2bBrands.description


productSearchproductB2B Brandsid
StringproductSearch.product.b2bBrands.id


productSearchproductB2B BrandsmetaDescription
StringproductSearch.product.b2bBrands.metaDescription


productSearchproductB2B BrandsmetaKeywords
StringproductSearch.product.b2bBrands.metaKeywords


productSearchproductB2B BrandsmetaTitle
StringproductSearch.product.b2bBrands.metaTitle


productSearchproductB2B Brandsname
StringproductSearch.product.b2bBrands.name


productSearchproductB2B BrandsparentsnameStringproductSearch.product.b2bBrands.parents.name


productSearchproductB2B Categoriesdescription
StringproductSearch.product.b2bCategories.description


productSearchproductB2B Categoriesid
StringproductSearch.product.b2bCategories.id


productSearchproductB2B CategoriesmetaDescription
StringproductSearch.product.b2bCategories.metaDescription


productSearchproductB2B CategoriesmetaKeywords
StringproductSearch.product.b2bCategories.metaKeywords


productSearchproductB2B CategoriesmetaTitle
StringproductSearch.product.b2bCategories.metaTitle


productSearchproductB2B Categoriesname
StringproductSearch.product.b2bCategories.name


productSearchproductB2B CategoriesparentsnameStringproductSearch.product.b2bCategories.parents.name


productSearchproductPublic  Brandsdescription
StringproductSearch.product.b2cBrands.description


productSearchproductPublic  Brandsid
StringproductSearch.product.b2cBrands.id


productSearchproductPublic  BrandsmetaDescription
StringproductSearch.product.b2cBrands.metaDescription


productSearchproductPublic  BrandsmetaKeywords
StringproductSearch.product.b2cBrands.metaKeywords


productSearchproductPublic  BrandsmetaTitle
StringproductSearch.product.b2cBrands.metaTitle


productSearchproductPublic  Brandsname
StringproductSearch.product.b2cBrands.name


productSearchproductPublic  BrandsparentsnameStringproductSearch.product.b2cBrands.parents.name


productSearchproductPublic  Categoriesdescription
StringproductSearch.product.b2cCategories.description


productSearchproductPublic  Categoriesid
StringproductSearch.product.b2cCategories.id


productSearchproductPublic  CategoriesmetaDescription
StringproductSearch.product.b2cCategories.metaDescription


productSearchproductPublic  CategoriesmetaKeywords
StringproductSearch.product.b2cCategories.metaKeywords


productSearchproductPublic  CategoriesmetaTitle
StringproductSearch.product.b2cCategories.metaTitle


productSearchproductPublic  Categoriesname
StringproductSearch.product.b2cCategories.name


productSearchproductPublic  CategoriesparentsnameStringproductSearch.product.b2cCategories.parents.name












TypeGroupEntityField 1Field 2Field 3Field 4Field 5Field Typeid
productSearchproductConfigurable ItemsconfigurationSetsgroupsgroupId

IntegerproductSearch.product.configurations.configurationSets.groups.groupId
productSearchproductConfigurable ItemsconfigurationSetsgroupsgroupName

StringproductSearch.product.configurations.configurationSets.groups.groupName
productSearchproductConfigurable ItemsconfigurationSetsgroupsid

IntegerproductSearch.product.configurations.configurationSets.groups.id
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionscanNoneBeOrdered
BooleanproductSearch.product.configurations.configurationSets.groups.options.canNoneBeOrdered
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsdescription
StringproductSearch.product.configurations.configurationSets.groups.options.description
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionshasNone
BooleanproductSearch.product.configurations.configurationSets.groups.options.hasNone
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsid
IntegerproductSearch.product.configurations.configurationSets.groups.options.id
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsisNoneDefault
BooleanproductSearch.product.configurations.configurationSets.groups.options.isNoneDefault
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsnoneText
StringproductSearch.product.configurations.configurationSets.groups.options.noneText
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsoptionId
IntegerproductSearch.product.configurations.configurationSets.groups.options.optionId
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsoptionName
StringproductSearch.product.configurations.configurationSets.groups.options.optionName
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionstype
StringproductSearch.product.configurations.configurationSets.groups.options.type
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsvaluesdescriptionStringproductSearch.product.configurations.configurationSets.groups.options.values.description
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsvaluesdiscountPercentageStringproductSearch.product.configurations.configurationSets.groups.options.values.discountPercentage
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsvaluesidIntegerproductSearch.product.configurations.configurationSets.groups.options.values.id
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsvaluesimageFullStringproductSearch.product.configurations.configurationSets.groups.options.values.imageFull
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsvaluesimageThumbStringproductSearch.product.configurations.configurationSets.groups.options.values.imageThumb
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsvaluesisSelectedDefaultBooleanproductSearch.product.configurations.configurationSets.groups.options.values.isSelectedDefault
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsvaluesisSelectedDefaultImageBooleanproductSearch.product.configurations.configurationSets.groups.options.values.isSelectedDefaultImage
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsvaluesitemCodeStringproductSearch.product.configurations.configurationSets.groups.options.values.itemCode
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsvaluesitemCodeFormattedStringproductSearch.product.configurations.configurationSets.groups.options.values.itemCodeFormatted
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsvaluesquantityMultiplierIntegerproductSearch.product.configurations.configurationSets.groups.options.values.quantityMultiplier
productSearchproductConfigurable ItemsconfigurationSetsid


IntegerproductSearch.product.configurations.configurationSets.id
productSearchproductConfigurable ItemsconfigurationSetssetId


IntegerproductSearch.product.configurations.configurationSets.setId
productSearchproductConfigurable ItemsconfigurationSetssetName


StringproductSearch.product.configurations.configurationSets.setName
productSearchproductConfigurable ItemsunconditionalLinksdiscountPercentage


DoubleproductSearch.product.configurations.unconditionalLinks.discountPercentage
productSearchproductConfigurable ItemsunconditionalLinksid


IntegerproductSearch.product.configurations.unconditionalLinks.id
productSearchproductConfigurable ItemsunconditionalLinksitemCode


StringproductSearch.product.configurations.unconditionalLinks.itemCode
productSearchproductConfigurable ItemsunconditionalLinksquantityMultiplier


IntegerproductSearch.product.configurations.unconditionalLinks.quantityMultiplier










TypeGroupEntityField 1Field 2Field Typeid


productSearchproductStandard ItemsdefaultPriceList
StringproductSearch.product.defaultPriceList


productSearchproductStandard ItemsdefaultUnitConversion
StringproductSearch.product.defaultUnitConversion


productSearchproductStandard ItemsdefaultUnitOfMeasure
StringproductSearch.product.defaultUnitOfMeasure


productSearchproductStandard Itemsdescription
StringproductSearch.product.description


productSearchproductStandard ItemshasStock
BooleanproductSearch.product.hasStock


productSearchproductStandard Itemsid
StringproductSearch.product.id


productSearchproductStandard ItemsisKitItem
BooleanproductSearch.product.isKitItem


productSearchproductStandard ItemsisStockItem
BooleanproductSearch.product.isStockItem


productSearchproductStandard ItemsitemCode
StringproductSearch.product.itemCode


productSearchproductStandard ItemsitemCodeFormatted
StringproductSearch.product.itemCodeFormatted


productSearchproductStandard ItemsmetaDescription
StringproductSearch.product.metaDescription


productSearchproductStandard ItemsmetaKeywords
StringproductSearch.product.metaKeywords


productSearchproductStandard ItemsmetaTitle
StringproductSearch.product.metaTitle


productSearchproductStandard ItemspricecurrencyCodeStringproductSearch.product.price.currencyCode


productSearchproductStandard ItemspricecustomerCodeStringproductSearch.product.price.customerCode


productSearchproductStandard ItemspriceunitOfMeasureStringproductSearch.product.price.unitOfMeasure


productSearchproductStandard ItemspricewarehouseCodeStringproductSearch.product.price.warehouseCode


productSearchproductStandard ItemsreviewshasReviewsBooleanproductSearch.product.reviews.hasReviews


productSearchproductStandard ItemsstatisticalGroupsstatisticalGroup0StringproductSearch.product.statisticalGroups.statisticalGroup0

productSearchproductStandard ItemsstatisticalGroupsstatisticalGroup1StringproductSearch.product.statisticalGroups.statisticalGroup1

productSearchproductStandard ItemsstatisticalGroupsstatisticalGroup2StringproductSearch.product.statisticalGroups.statisticalGroup2

productSearchproductStandard ItemsstatisticalGroupsstatisticalGroup3StringproductSearch.product.statisticalGroups.statisticalGroup3

productSearchproductStandard ItemsstatisticalGroupsstatisticalGroup4StringproductSearch.product.statisticalGroups.statisticalGroup4

productSearchproductStandard ItemsstocksdescriptionStringproductSearch.product.stocks.description


productSearchproductStandard ItemsstocksitemCodeStringproductSearch.product.stocks.itemCode


productSearchproductStandard ItemsstockswarehouseCodeStringproductSearch.product.stocks.warehouseCode


productSearchproductStandard Itemstype
StringproductSearch.product.type


productSearchproductStandard ItemsupcCode
StringproductSearch.product.upcCode


productSearchproductStandard ItemsvariantPriceItemCode
StringproductSearch.product.variantPriceItemCode












TypeGroupEntityField 1Field 2Field 3Field Typeid

productSearchproductVariation ItemsnumberOfVariationProducts

IntegerproductSearch.product.variations.numberOfVariationProducts
productSearchproductVariation Itemsoptionsid
IntegerproductSearch.product.variations.options.id
productSearchproductVariation ItemsoptionsishideIfUnavailable
BooleanproductSearch.product.variations.options.ishideIfUnavailable
productSearchproductVariation ItemsoptionsisSequential
BooleanproductSearch.product.variations.options.isSequential
productSearchproductVariation Itemsoptionsname
StringproductSearch.product.variations.options.name
productSearchproductVariation Itemsoptionsorder
IntegerproductSearch.product.variations.options.order
productSearchproductVariation Itemsoptionstype
StringproductSearch.product.variations.options.type
productSearchproductVariation ItemsoptionsvaluesidIntegerproductSearch.product.variations.options.values.id
productSearchproductVariation ItemsoptionsvaluesnameStringproductSearch.product.variations.options.values.name
productSearchproductVariation ItemsoptionsvaluesorderIntegerproductSearch.product.variations.options.values.order
productSearchproductVariation ItemsoptionsvaluesproductImageStringproductSearch.product.variations.options.values.productImage
productSearchproductVariation ItemsoptionsvaluesswatchImageStringproductSearch.product.variations.options.values.swatchImage
productSearchproductVariation ItemsoptionsvaluesswatchImageUnavailableStringproductSearch.product.variations.options.values.swatchImageUnavailable
productSearchproductVariation ItemsvariationKeywordsitemCode
StringproductSearch.product.variations.variationKeywords.itemCode
productSearchproductVariation ItemsvariationscombinationnameStringproductSearch.product.variations.variations.combination.name
productSearchproductVariation ItemsvariationscombinationnameIdIntegerproductSearch.product.variations.variations.combination.nameId
productSearchproductVariation ItemsvariationscombinationorderIntegerproductSearch.product.variations.variations.combination.order
productSearchproductVariation ItemsvariationscombinationvalueStringproductSearch.product.variations.variations.combination.value
productSearchproductVariation ItemsvariationscombinationvalueIdIntegerproductSearch.product.variations.variations.combination.valueId
productSearchproductVariation ItemsvariationsproductitemCodeStringproductSearch.product.variations.variations.product.itemCode










TypeGroupEntityField 1Field Typeid



productSearchproductdetailsadditionalDetailsStringproductSearch.product.details.additionalDetails


productSearchproductdetailsadditionalTabStringproductSearch.product.details.additionalTab


productSearchproductdetailsdescriptionStringproductSearch.product.details.description


productSearchproductdetailsfeatureStringproductSearch.product.details.feature


productSearchproductdetailsformIdIntegerproductSearch.product.details.formId


productSearchproductdetailsfractionalQuantityIntegerproductSearch.product.details.fractionalQuantity


productSearchproductdetailsincludesStringproductSearch.product.details.includes


productSearchproductdetailsisPoaB2bBooleanproductSearch.product.details.isPoaB2b


productSearchproductdetailsisPoaB2cBooleanproductSearch.product.details.isPoaB2c


productSearchproductdetailsisVirtualBooleanproductSearch.product.details.isVirtual


productSearchproductdetailsitemCodeStringproductSearch.product.details.itemCode


productSearchproductdetailsmetaDescriptionStringproductSearch.product.details.metaDescription


productSearchproductdetailsmetaKeywordsStringproductSearch.product.details.metaKeywords


productSearchproductdetailsmetaTitleStringproductSearch.product.details.metaTitle


productSearchproductdetailsorderCommentIntegerproductSearch.product.details.orderComment


productSearchproductdetailsrequestListIntegerproductSearch.product.details.requestList


productSearchproductdetailssecondaryDescriptionStringproductSearch.product.details.secondaryDescription


productSearchproductdetailsspecificationStringproductSearch.product.details.specification


Product Related

TypeGroupEntityField 1Field Typeid



productSearchmatchProductFinderoptionProductFindernameStringproductSearch.matchProductFinder.optionProductFinder.name












TypeGroupEntityField 1Field 2Field Typeid


productSearchproductB2B Brandsdescription
StringproductSearch.product.b2bBrands.description


productSearchproductB2B Brandsid
StringproductSearch.product.b2bBrands.id


productSearchproductB2B BrandsmetaDescription
StringproductSearch.product.b2bBrands.metaDescription


productSearchproductB2B BrandsmetaKeywords
StringproductSearch.product.b2bBrands.metaKeywords


productSearchproductB2B BrandsmetaTitle
StringproductSearch.product.b2bBrands.metaTitle


productSearchproductB2B Brandsname
StringproductSearch.product.b2bBrands.name


productSearchproductB2B BrandsparentsnameStringproductSearch.product.b2bBrands.parents.name


productSearchproductB2B Categoriesdescription
StringproductSearch.product.b2bCategories.description


productSearchproductB2B Categoriesid
StringproductSearch.product.b2bCategories.id


productSearchproductB2B CategoriesmetaDescription
StringproductSearch.product.b2bCategories.metaDescription


productSearchproductB2B CategoriesmetaKeywords
StringproductSearch.product.b2bCategories.metaKeywords


productSearchproductB2B CategoriesmetaTitle
StringproductSearch.product.b2bCategories.metaTitle


productSearchproductB2B Categoriesname
StringproductSearch.product.b2bCategories.name


productSearchproductB2B CategoriesparentsnameStringproductSearch.product.b2bCategories.parents.name


productSearchproductPublic  Brandsdescription
StringproductSearch.product.b2cBrands.description


productSearchproductPublic  Brandsid
StringproductSearch.product.b2cBrands.id


productSearchproductPublic  BrandsmetaDescription
StringproductSearch.product.b2cBrands.metaDescription


productSearchproductPublic  BrandsmetaKeywords
StringproductSearch.product.b2cBrands.metaKeywords


productSearchproductPublic  BrandsmetaTitle
StringproductSearch.product.b2cBrands.metaTitle


productSearchproductPublic  Brandsname
StringproductSearch.product.b2cBrands.name


productSearchproductPublic  BrandsparentsnameStringproductSearch.product.b2cBrands.parents.name


productSearchproductPublic  Categoriesdescription
StringproductSearch.product.b2cCategories.description


productSearchproductPublic  Categoriesid
StringproductSearch.product.b2cCategories.id


productSearchproductPublic  CategoriesmetaDescription
StringproductSearch.product.b2cCategories.metaDescription


productSearchproductPublic  CategoriesmetaKeywords
StringproductSearch.product.b2cCategories.metaKeywords


productSearchproductPublic  CategoriesmetaTitle
StringproductSearch.product.b2cCategories.metaTitle


productSearchproductPublic  Categoriesname
StringproductSearch.product.b2cCategories.name


productSearchproductPublic  CategoriesparentsnameStringproductSearch.product.b2cCategories.parents.name












TypeGroupEntityField 1Field 2Field 3Field 4Field 5Field Typeid
productSearchproductConfigurable ItemsconfigurationSetsgroupsgroupId

IntegerproductSearch.product.configurations.configurationSets.groups.groupId
productSearchproductConfigurable ItemsconfigurationSetsgroupsgroupName

StringproductSearch.product.configurations.configurationSets.groups.groupName
productSearchproductConfigurable ItemsconfigurationSetsgroupsid

IntegerproductSearch.product.configurations.configurationSets.groups.id
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionscanNoneBeOrdered
BooleanproductSearch.product.configurations.configurationSets.groups.options.canNoneBeOrdered
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsdescription
StringproductSearch.product.configurations.configurationSets.groups.options.description
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionshasNone
BooleanproductSearch.product.configurations.configurationSets.groups.options.hasNone
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsid
IntegerproductSearch.product.configurations.configurationSets.groups.options.id
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsisNoneDefault
BooleanproductSearch.product.configurations.configurationSets.groups.options.isNoneDefault
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsnoneText
StringproductSearch.product.configurations.configurationSets.groups.options.noneText
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsoptionId
IntegerproductSearch.product.configurations.configurationSets.groups.options.optionId
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsoptionName
StringproductSearch.product.configurations.configurationSets.groups.options.optionName
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionstype
StringproductSearch.product.configurations.configurationSets.groups.options.type
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsvaluesdescriptionStringproductSearch.product.configurations.configurationSets.groups.options.values.description
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsvaluesdiscountPercentageStringproductSearch.product.configurations.configurationSets.groups.options.values.discountPercentage
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsvaluesidIntegerproductSearch.product.configurations.configurationSets.groups.options.values.id
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsvaluesimageFullStringproductSearch.product.configurations.configurationSets.groups.options.values.imageFull
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsvaluesimageThumbStringproductSearch.product.configurations.configurationSets.groups.options.values.imageThumb
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsvaluesisSelectedDefaultBooleanproductSearch.product.configurations.configurationSets.groups.options.values.isSelectedDefault
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsvaluesisSelectedDefaultImageBooleanproductSearch.product.configurations.configurationSets.groups.options.values.isSelectedDefaultImage
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsvaluesitemCodeStringproductSearch.product.configurations.configurationSets.groups.options.values.itemCode
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsvaluesitemCodeFormattedStringproductSearch.product.configurations.configurationSets.groups.options.values.itemCodeFormatted
productSearchproductConfigurable ItemsconfigurationSetsgroupsoptionsvaluesquantityMultiplierIntegerproductSearch.product.configurations.configurationSets.groups.options.values.quantityMultiplier
productSearchproductConfigurable ItemsconfigurationSetsid


IntegerproductSearch.product.configurations.configurationSets.id
productSearchproductConfigurable ItemsconfigurationSetssetId


IntegerproductSearch.product.configurations.configurationSets.setId
productSearchproductConfigurable ItemsconfigurationSetssetName


StringproductSearch.product.configurations.configurationSets.setName
productSearchproductConfigurable ItemsunconditionalLinksdiscountPercentage


DoubleproductSearch.product.configurations.unconditionalLinks.discountPercentage
productSearchproductConfigurable ItemsunconditionalLinksid


IntegerproductSearch.product.configurations.unconditionalLinks.id
productSearchproductConfigurable ItemsunconditionalLinksitemCode


StringproductSearch.product.configurations.unconditionalLinks.itemCode
productSearchproductConfigurable ItemsunconditionalLinksquantityMultiplier


IntegerproductSearch.product.configurations.unconditionalLinks.quantityMultiplier










TypeGroupEntityField 1Field 2Field Typeid


productSearchproductStandard ItemsdefaultPriceList
StringproductSearch.product.defaultPriceList


productSearchproductStandard ItemsdefaultUnitConversion
StringproductSearch.product.defaultUnitConversion


productSearchproductStandard ItemsdefaultUnitOfMeasure
StringproductSearch.product.defaultUnitOfMeasure


productSearchproductStandard Itemsdescription
StringproductSearch.product.description


productSearchproductStandard ItemshasStock
BooleanproductSearch.product.hasStock


productSearchproductStandard Itemsid
StringproductSearch.product.id


productSearchproductStandard ItemsisKitItem
BooleanproductSearch.product.isKitItem


productSearchproductStandard ItemsisStockItem
BooleanproductSearch.product.isStockItem


productSearchproductStandard ItemsitemCode
StringproductSearch.product.itemCode


productSearchproductStandard ItemsitemCodeFormatted
StringproductSearch.product.itemCodeFormatted


productSearchproductStandard ItemsmetaDescription
StringproductSearch.product.metaDescription


productSearchproductStandard ItemsmetaKeywords
StringproductSearch.product.metaKeywords


productSearchproductStandard ItemsmetaTitle
StringproductSearch.product.metaTitle


productSearchproductStandard ItemspricecurrencyCodeStringproductSearch.product.price.currencyCode


productSearchproductStandard ItemspricecustomerCodeStringproductSearch.product.price.customerCode


productSearchproductStandard ItemspriceunitOfMeasureStringproductSearch.product.price.unitOfMeasure


productSearchproductStandard ItemspricewarehouseCodeStringproductSearch.product.price.warehouseCode


productSearchproductStandard ItemsreviewshasReviewsBooleanproductSearch.product.reviews.hasReviews


productSearchproductStandard ItemsstatisticalGroupsstatisticalGroup0StringproductSearch.product.statisticalGroups.statisticalGroup0

productSearchproductStandard ItemsstatisticalGroupsstatisticalGroup1StringproductSearch.product.statisticalGroups.statisticalGroup1

productSearchproductStandard ItemsstatisticalGroupsstatisticalGroup2StringproductSearch.product.statisticalGroups.statisticalGroup2

productSearchproductStandard ItemsstatisticalGroupsstatisticalGroup3StringproductSearch.product.statisticalGroups.statisticalGroup3

productSearchproductStandard ItemsstatisticalGroupsstatisticalGroup4StringproductSearch.product.statisticalGroups.statisticalGroup4

productSearchproductStandard ItemsstocksdescriptionStringproductSearch.product.stocks.description


productSearchproductStandard ItemsstocksitemCodeStringproductSearch.product.stocks.itemCode


productSearchproductStandard ItemsstockswarehouseCodeStringproductSearch.product.stocks.warehouseCode


productSearchproductStandard Itemstype
StringproductSearch.product.type


productSearchproductStandard ItemsupcCode
StringproductSearch.product.upcCode


productSearchproductStandard ItemsvariantPriceItemCode
StringproductSearch.product.variantPriceItemCode












TypeGroupEntityField 1Field 2Field 3Field Typeid

productSearchproductVariation ItemsnumberOfVariationProducts

IntegerproductSearch.product.variations.numberOfVariationProducts
productSearchproductVariation Itemsoptionsid
IntegerproductSearch.product.variations.options.id
productSearchproductVariation ItemsoptionsishideIfUnavailable
BooleanproductSearch.product.variations.options.ishideIfUnavailable
productSearchproductVariation ItemsoptionsisSequential
BooleanproductSearch.product.variations.options.isSequential
productSearchproductVariation Itemsoptionsname
StringproductSearch.product.variations.options.name
productSearchproductVariation Itemsoptionsorder
IntegerproductSearch.product.variations.options.order
productSearchproductVariation Itemsoptionstype
StringproductSearch.product.variations.options.type
productSearchproductVariation ItemsoptionsvaluesidIntegerproductSearch.product.variations.options.values.id
productSearchproductVariation ItemsoptionsvaluesnameStringproductSearch.product.variations.options.values.name
productSearchproductVariation ItemsoptionsvaluesorderIntegerproductSearch.product.variations.options.values.order
productSearchproductVariation ItemsoptionsvaluesproductImageStringproductSearch.product.variations.options.values.productImage
productSearchproductVariation ItemsoptionsvaluesswatchImageStringproductSearch.product.variations.options.values.swatchImage
productSearchproductVariation ItemsoptionsvaluesswatchImageUnavailableStringproductSearch.product.variations.options.values.swatchImageUnavailable
productSearchproductVariation ItemsvariationKeywordsitemCode
StringproductSearch.product.variations.variationKeywords.itemCode
productSearchproductVariation ItemsvariationscombinationnameStringproductSearch.product.variations.variations.combination.name
productSearchproductVariation ItemsvariationscombinationnameIdIntegerproductSearch.product.variations.variations.combination.nameId
productSearchproductVariation ItemsvariationscombinationorderIntegerproductSearch.product.variations.variations.combination.order
productSearchproductVariation ItemsvariationscombinationvalueStringproductSearch.product.variations.variations.combination.value
productSearchproductVariation ItemsvariationscombinationvalueIdIntegerproductSearch.product.variations.variations.combination.valueId
productSearchproductVariation ItemsvariationsproductitemCodeStringproductSearch.product.variations.variations.product.itemCode










TypeGroupEntityField 1Field Typeid



productSearchproductdetailsadditionalDetailsStringproductSearch.product.details.additionalDetails


productSearchproductdetailsadditionalTabStringproductSearch.product.details.additionalTab


productSearchproductdetailsdescriptionStringproductSearch.product.details.description


productSearchproductdetailsfeatureStringproductSearch.product.details.feature


productSearchproductdetailsformIdIntegerproductSearch.product.details.formId


productSearchproductdetailsfractionalQuantityIntegerproductSearch.product.details.fractionalQuantity


productSearchproductdetailsincludesStringproductSearch.product.details.includes


productSearchproductdetailsisPoaB2bBooleanproductSearch.product.details.isPoaB2b


productSearchproductdetailsisPoaB2cBooleanproductSearch.product.details.isPoaB2c


productSearchproductdetailsisVirtualBooleanproductSearch.product.details.isVirtual


productSearchproductdetailsitemCodeStringproductSearch.product.details.itemCode


productSearchproductdetailsmetaDescriptionStringproductSearch.product.details.metaDescription


productSearchproductdetailsmetaKeywordsStringproductSearch.product.details.metaKeywords


productSearchproductdetailsmetaTitleStringproductSearch.product.details.metaTitle


productSearchproductdetailsorderCommentIntegerproductSearch.product.details.orderComment


productSearchproductdetailsrequestListIntegerproductSearch.product.details.requestList


productSearchproductdetailssecondaryDescriptionStringproductSearch.product.details.secondaryDescription


productSearchproductdetailsspecificationStringproductSearch.product.details.specification


User and Customer Related

TypeGroupEntityFieldField Typeid
usercustomerCustomersaddress1Stringuser.customer.address1
usercustomerCustomersaddress2Stringuser.customer.address2
usercustomerCustomersaddress3Stringuser.customer.address3
usercustomerCustomersaddress4Stringuser.customer.address4
usercustomerCustomerscityStringuser.customer.city
usercustomerCustomerscontactEmailStringuser.customer.contactEmail
usercustomerCustomerscontactFaxStringuser.customer.contactFax
usercustomerCustomerscontactNameStringuser.customer.contactName
usercustomerCustomerscontactPhoneStringuser.customer.contactPhone
usercustomerCustomerscountryCodeStringuser.customer.countryCode
usercustomerCustomerscurrencyCodeStringuser.customer.currencyCode
usercustomerCustomerscustomerCodeStringuser.customer.customerCode
usercustomerCustomerscustomerGroupStringuser.customer.customerGroup
usercustomerCustomerscustomerTypeStringuser.customer.customerType
usercustomerCustomersemailStringuser.customer.email
usercustomerCustomersfaxStringuser.customer.fax
usercustomerCustomersidIntegeruser.customer.id
usercustomerCustomersnameStringuser.customer.name
usercustomerCustomerspaymentCodeTermStringuser.customer.paymentCodeTerm
usercustomerCustomersphoneStringuser.customer.phone
usercustomerCustomerspriceCodeStringuser.customer.priceCode
usercustomerCustomersprimaryShippingLocationStringuser.customer.primaryShippingLocation
usercustomerCustomersstateStringuser.customer.state
usercustomerCustomersstatusStringuser.customer.status
usercustomerCustomerssuburbStringuser.customer.suburb
usercustomerCustomerstaxGroupStringuser.customer.taxGroup
usercustomerCustomerszipStringuser.customer.zip












TypeGroupEntityFieldField Typeid
usercustomerpriceListdescriptionStringuser.customer.priceList.description
usercustomerpriceListidStringuser.customer.priceList.id
usercustomerpriceListisExcludeStringuser.customer.priceList.isExclude
usercustomerpriceListpriceListCodeStringuser.customer.priceList.priceListCode












TypeEntityFieldField Typeid
useruseremailStringuser.email
useruserfirstNameStringuser.firstName
userusergroupIdIntegeruser.groupId
useruserisApprovedBooleanuser.isApproved
useruserisB2bBooleanuser.isB2b
useruserisDeletedBooleanuser.isDeleted
useruserlastNameStringuser.lastName
useruserlocaleStringuser.locale
useruserusernameStringuser.username












TypeGroupEntityFieldField Typeid
usercustomerbusinessPartnerCustomeraccountingCodeStringuser.customer.businessPartnerCustomer.accountingCode
usercustomerbusinessPartnerCustomeranalyticalDimension0Stringuser.customer.businessPartnerCustomer.analyticalDimension0
usercustomerbusinessPartnerCustomeranalyticalDimension1Stringuser.customer.businessPartnerCustomer.analyticalDimension1
usercustomerbusinessPartnerCustomeranalyticalDimension10Stringuser.customer.businessPartnerCustomer.analyticalDimension10
usercustomerbusinessPartnerCustomeranalyticalDimension11Stringuser.customer.businessPartnerCustomer.analyticalDimension11
usercustomerbusinessPartnerCustomeranalyticalDimension12Stringuser.customer.businessPartnerCustomer.analyticalDimension12
usercustomerbusinessPartnerCustomeranalyticalDimension13Stringuser.customer.businessPartnerCustomer.analyticalDimension13
usercustomerbusinessPartnerCustomeranalyticalDimension14Stringuser.customer.businessPartnerCustomer.analyticalDimension14
usercustomerbusinessPartnerCustomeranalyticalDimension15Stringuser.customer.businessPartnerCustomer.analyticalDimension15
usercustomerbusinessPartnerCustomeranalyticalDimension16Stringuser.customer.businessPartnerCustomer.analyticalDimension16
usercustomerbusinessPartnerCustomeranalyticalDimension17Stringuser.customer.businessPartnerCustomer.analyticalDimension17
usercustomerbusinessPartnerCustomeranalyticalDimension18Stringuser.customer.businessPartnerCustomer.analyticalDimension18
usercustomerbusinessPartnerCustomeranalyticalDimension19Stringuser.customer.businessPartnerCustomer.analyticalDimension19
usercustomerbusinessPartnerCustomeranalyticalDimension2Stringuser.customer.businessPartnerCustomer.analyticalDimension2
usercustomerbusinessPartnerCustomeranalyticalDimension3Stringuser.customer.businessPartnerCustomer.analyticalDimension3
usercustomerbusinessPartnerCustomeranalyticalDimension4Stringuser.customer.businessPartnerCustomer.analyticalDimension4
usercustomerbusinessPartnerCustomeranalyticalDimension5Stringuser.customer.businessPartnerCustomer.analyticalDimension5
usercustomerbusinessPartnerCustomeranalyticalDimension6Stringuser.customer.businessPartnerCustomer.analyticalDimension6
usercustomerbusinessPartnerCustomeranalyticalDimension7Stringuser.customer.businessPartnerCustomer.analyticalDimension7
usercustomerbusinessPartnerCustomeranalyticalDimension8Stringuser.customer.businessPartnerCustomer.analyticalDimension8
usercustomerbusinessPartnerCustomeranalyticalDimension9Stringuser.customer.businessPartnerCustomer.analyticalDimension9
usercustomerbusinessPartnerCustomerbankStringuser.customer.businessPartnerCustomer.bank
usercustomerbusinessPartnerCustomerbillToStringuser.customer.businessPartnerCustomer.billTo
usercustomerbusinessPartnerCustomerbillToAddressStringuser.customer.businessPartnerCustomer.billToAddress
usercustomerbusinessPartnerCustomerbusinessStringuser.customer.businessPartnerCustomer.business
usercustomerbusinessPartnerCustomercategoryStringuser.customer.businessPartnerCustomer.category
usercustomerbusinessPartnerCustomercurrencyCodeStringuser.customer.businessPartnerCustomer.currencyCode
usercustomerbusinessPartnerCustomercustomerCodeStringuser.customer.businessPartnerCustomer.customerCode
usercustomerbusinessPartnerCustomerdefaultAddressStringuser.customer.businessPartnerCustomer.defaultAddress
usercustomerbusinessPartnerCustomerdefaultContactStringuser.customer.businessPartnerCustomer.defaultContact
usercustomerbusinessPartnerCustomerdefaultDeliveryAddressStringuser.customer.businessPartnerCustomer.defaultDeliveryAddress
usercustomerbusinessPartnerCustomerdimensionTypeCode0Stringuser.customer.businessPartnerCustomer.dimensionTypeCode0
usercustomerbusinessPartnerCustomerdimensionTypeCode1Stringuser.customer.businessPartnerCustomer.dimensionTypeCode1
usercustomerbusinessPartnerCustomerdimensionTypeCode10Stringuser.customer.businessPartnerCustomer.dimensionTypeCode10
usercustomerbusinessPartnerCustomerdimensionTypeCode11Stringuser.customer.businessPartnerCustomer.dimensionTypeCode11
usercustomerbusinessPartnerCustomerdimensionTypeCode12Stringuser.customer.businessPartnerCustomer.dimensionTypeCode12
usercustomerbusinessPartnerCustomerdimensionTypeCode13Stringuser.customer.businessPartnerCustomer.dimensionTypeCode13
usercustomerbusinessPartnerCustomerdimensionTypeCode14Stringuser.customer.businessPartnerCustomer.dimensionTypeCode14
usercustomerbusinessPartnerCustomerdimensionTypeCode15Stringuser.customer.businessPartnerCustomer.dimensionTypeCode15
usercustomerbusinessPartnerCustomerdimensionTypeCode16Stringuser.customer.businessPartnerCustomer.dimensionTypeCode16
usercustomerbusinessPartnerCustomerdimensionTypeCode17Stringuser.customer.businessPartnerCustomer.dimensionTypeCode17
usercustomerbusinessPartnerCustomerdimensionTypeCode18Stringuser.customer.businessPartnerCustomer.dimensionTypeCode18
usercustomerbusinessPartnerCustomerdimensionTypeCode19Stringuser.customer.businessPartnerCustomer.dimensionTypeCode19
usercustomerbusinessPartnerCustomerdimensionTypeCode2Stringuser.customer.businessPartnerCustomer.dimensionTypeCode2
usercustomerbusinessPartnerCustomerdimensionTypeCode3Stringuser.customer.businessPartnerCustomer.dimensionTypeCode3
usercustomerbusinessPartnerCustomerdimensionTypeCode4Stringuser.customer.businessPartnerCustomer.dimensionTypeCode4
usercustomerbusinessPartnerCustomerdimensionTypeCode5Stringuser.customer.businessPartnerCustomer.dimensionTypeCode5
usercustomerbusinessPartnerCustomerdimensionTypeCode6Stringuser.customer.businessPartnerCustomer.dimensionTypeCode6
usercustomerbusinessPartnerCustomerdimensionTypeCode7Stringuser.customer.businessPartnerCustomer.dimensionTypeCode7
usercustomerbusinessPartnerCustomerdimensionTypeCode8Stringuser.customer.businessPartnerCustomer.dimensionTypeCode8
usercustomerbusinessPartnerCustomerdimensionTypeCode9Stringuser.customer.businessPartnerCustomer.dimensionTypeCode9
usercustomerbusinessPartnerCustomerexportNumberStringuser.customer.businessPartnerCustomer.exportNumber
usercustomerbusinessPartnerCustomerfactorStringuser.customer.businessPartnerCustomer.factor
usercustomerbusinessPartnerCustomergroupStringuser.customer.businessPartnerCustomer.group
usercustomerbusinessPartnerCustomergroupCustomerStringuser.customer.businessPartnerCustomer.groupCustomer
usercustomerbusinessPartnerCustomeridStringuser.customer.businessPartnerCustomer.id
usercustomerbusinessPartnerCustomerisActiveBooleanuser.customer.businessPartnerCustomer.isActive
usercustomerbusinessPartnerCustomerisProspectBooleanuser.customer.businessPartnerCustomer.isProspect
usercustomerbusinessPartnerCustomernameStringuser.customer.businessPartnerCustomer.name
usercustomerbusinessPartnerCustomernotesStringuser.customer.businessPartnerCustomer.notes
usercustomerbusinessPartnerCustomerpayByStringuser.customer.businessPartnerCustomer.payBy
usercustomerbusinessPartnerCustomerpayByAddressStringuser.customer.businessPartnerCustomer.payByAddress
usercustomerbusinessPartnerCustomerpaymentTermsStringuser.customer.businessPartnerCustomer.paymentTerms
usercustomerbusinessPartnerCustomerprovinceTaxCodeStringuser.customer.businessPartnerCustomer.provinceTaxCode
usercustomerbusinessPartnerCustomerriskByStringuser.customer.businessPartnerCustomer.riskBy
usercustomerbusinessPartnerCustomersalesRep0Stringuser.customer.businessPartnerCustomer.salesRep0
usercustomerbusinessPartnerCustomersalesRep1Stringuser.customer.businessPartnerCustomer.salesRep1
usercustomerbusinessPartnerCustomershortTitleStringuser.customer.businessPartnerCustomer.shortTitle
usercustomerbusinessPartnerCustomerstatisticalGroup0Stringuser.customer.businessPartnerCustomer.statisticalGroup0
usercustomerbusinessPartnerCustomerstatisticalGroup1Stringuser.customer.businessPartnerCustomer.statisticalGroup1
usercustomerbusinessPartnerCustomerstatisticalGroup2Stringuser.customer.businessPartnerCustomer.statisticalGroup2
usercustomerbusinessPartnerCustomerstatisticalGroup3Stringuser.customer.businessPartnerCustomer.statisticalGroup3
usercustomerbusinessPartnerCustomerstatisticalGroup4Stringuser.customer.businessPartnerCustomer.statisticalGroup4
usercustomerbusinessPartnerCustomersupplierNumberStringuser.customer.businessPartnerCustomer.supplierNumber
usercustomerbusinessPartnerCustomertaxExemptionNumberStringuser.customer.businessPartnerCustomer.taxExemptionNumber
usercustomerbusinessPartnerCustomertaxRuleStringuser.customer.businessPartnerCustomer.taxRule
usercustomerbusinessPartnerCustomertemplateCodeStringuser.customer.businessPartnerCustomer.templateCode












TypeEntityFieldField Typeid
userwarehouseaddress1Stringuser.warehouse.address1
userwarehouseaddress2Stringuser.warehouse.address2
userwarehouseaddress3Stringuser.warehouse.address3
userwarehouseaddress4Stringuser.warehouse.address4
userwarehousecountryStringuser.warehouse.country
userwarehousedescriptionStringuser.warehouse.description
userwarehouseidIntegeruser.warehouse.id
userwarehouseisExcludeBooleanuser.warehouse.isExclude
userwarehouselegislationStringuser.warehouse.legislation
userwarehousestateStringuser.warehouse.state
userwarehousesuburbStringuser.warehouse.suburb
userwarehousesuffixStringuser.warehouse.suffix
userwarehousewarehouseCodeStringuser.warehouse.warehouseCode
userwarehousezipStringuser.warehouse.zip


*commerce*build