Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview

...

MultiExcerptNameFeature Overview

...

In conjunction with Best Practice Design, you can implement an Alternate Product Substitution offer feature, whereby out of stock items in the cart can be substituted with alternates at the customer's request.

...

In the CMS, the Product Maintenance search allows you to find a product for editing. You can include a filter in the search criteria to narrow search results even further. Product Search comes with standard search filters:

Image Added


You can also add values from the Product table fields. For example, suppose we want to be able to narrow our search to products from a particular category. So we want specific category codes as filter options. 


Add a custom filter field

To add a custom filter field:

  1. In the CMS, navigate to Advanced ContentResources.
    Image Added
  2. In Search For, enter the resource name 'rcCmsProductCustomerFilter', then click Search.
    Image Added
  3. Make sure rcCmsProductCustomerFilter is selected, then click Modify.
    Image Added
  4. In Resource Value, enter one or more filter options. 
    Image Added
    Instrutions - You will need to know the field identity name from the database and add each filter option in this exact format:

    [text value]=[filter string];

    NOTE - '[ ]' are used only to separate. Do not include them when you enter a resource value.

    • [text value] is the label of the filter displayed in the dropdown list.
    • [filter string] is the information the database needs for processing the filter. 

Info
titleExamples

We want to add specific category codes as filter options.


1. Add a specific category code

Let's use the example: Category Code: SX010102.


To create a filter with this category code, we add this string in Resource Value:

Category Code (SX010102)=CategoryCode='SX010102';
Image Added
NOTE - The text string can be any text you want to add. 

Once saved, this filter option will be available in Product Search. When this filter is selected, only products under this category are included in the search.
Image Added

2. Add a specific category code with more subfilter values

For our example: Category Code: SX010102, we also want to be able to filter products in this category with a specific Unit Description (UnitDesc) 'EACH'. 

To create a filter with this category code, we add this string in Resource Value:

Category Code (SX010102)=CategoryCode='SX010102 AND UnitDesc='EACH';
Image Added

Image Added

Tip

Custom filter options display after standard filter ones in the dropdown list.

Image Added



 



Filters are in the format: {text}=[sql][;][...]


text: The text displayed in the Filter drop-down menu (on the Product Maintenance page).

sql: The SQL that will go into the WHERE clause of the query. Defaults to empty string if not present (i.e. no filter).


text and sql must be separated by a pipe (|) character and each filter must be separate by a semi-colon (;). Each resource can have any number of filters.



In the Filter dorp-down list, the 'system' ones are shown first, followed by the 'customer' ones and are shown in the order they appear in each resource.





Additional Information


Multiexcerpt
MultiExcerptNameAdditional Info


Note

Products must have Alternates configured (either in the ERP or the CMS) in order for this functionality to work. If an out of stock product has no Alternate data, the button will not display. 



...

Minimum Version Requirements


Multiexcerpt
MultiExcerptNameMinimum Version Requirements

03.79.00


Prerequisites


Multiexcerpt
MultiExcerptNamePre reqs

**


Self Configurable


Multiexcerpt
MultiExcerptNameSelf Configurable

Yes


Business Function


Multiexcerpt
MultiExcerptNameBusiness Function

Behaviour & Personalisation


BPD Only?


Multiexcerpt
MultiExcerptNameBPD Only

Yes


B2B/B2C/Both


Multiexcerpt
MultiExcerptNameB2B/B2C/Both

Both


Ballpark Hours From CV (if opting for CV to complete self config component)


Multiexcerpt
MultiExcerptNameBallpark Hours From CV (if opting for CV to complete self config component)

Contact Commerce Vision


Ballpark Hours From CV (in addition to any self config required)


Multiexcerpt
MultiExcerptNameBallpark Hours From CV (in addition to any self config required)

Contact Commerce Vision


Third Party Costs


Multiexcerpt
MultiExcerptNameThird Party Costs

n/a


CMS Category


Multiexcerpt
MultiExcerptNameCMS Category

 CMS Products



Related help

Content by Label
showLabelsfalse
max10
spacesKB
showSpacefalse
sortmodified
reversetrue
typepage
excludeCurrenttrue
cqllabel = "product-maintenance" and type = "page" and space = "KB"
labelskb-how-to-article

...