ShoppingAdvisor - Price Filters

With ShoppingAdvisor you can setup a filter to remove products from any shopping feed based the price of an item. This can be accomplished using Business Rules.

With any business rule in ShoppingAdvisor, you will need to perform three basic steps:

• Write the Business Rule
• Setting the Rule on a Feed Template
• Preview the data feed to see the results

Writing the Business Rule to Filter by Price

In this scenario, we will assume that the price of your items is contained within the CurrentPrice of your external data feed. The goal here will be to filter out all items below $10 for the Shopzilla data feed.

Steps for creating the Business Rule:

• In ShoppingAdvisor goto the Data Mapping Tab, click on Business Rules and then click on the New Business Rule link.
• Enter a name for the Business Rule. In this example we will call it "Filter By Price $10 - Shopzilla". For price filters, it is a good practice to include the name of the shopping site and the price point you are filtering at in the rule name so you will know which one to choose from when applying it on the feed template and know what the rule is filtering.
• In the Expression box you will write an expression that compares the current price to a numeric value. This will always return a boolean (true/false) value for all the items. In ShoppingAdvisor, any expression that returns a Boolean value will automatically be treated as a filter in the system. Here is the code to be placed in the Expression field:

  $currentprice < 10

  NOTE: whenever you want to refer to a data field you must always prepend the name of the field with a single dollar sign.

• If you are using a CA Store with ShoppingAdvisor then the syntax will be different. You will want to reference the price that you are advertising for the product in the expression. The default price field for this in the CA Store is ITEMSTOREPRICE. Here is how the code would look for a CA Store setup:

  $ITEMSTOREPRICE < 10

  This rule will return TRUE for any item under $10. These items will not be included in the feed.

• Once you have the rule setup click on the Save and Validate button to check the syntax you have entered. Then you can click on Save and Exit once the syntax has passed validation.

Setting the Rule on a Feed Template

Next you will want to set this rule on the Shopzilla template.

• Goto Data Mapping then click on Templates.
• Click on the template you are using for the Shopzilla feed.
• Scroll to the bottom of the template down to the Products To Exclude section.
• Highlight the rule "Filter By Price $10 - Shopzilla" in the Available Rules box.
• Click on the Add button. The rule will be added to the Rules Applied box.
• Click on the Save and Exit Button at the bottom of the template.

Previewing the Data Feed

Once you have applied this business rule you can preview the feed to ensure that the URL tracking codes have bee added.

• Goto the Feeds Tab.
• Select the feed that you want to preview by clicking on the checkbox next to it.
• Click the Preview Button at the top of the list.
• You will be prompted with your e-mail address where the feed link will be sent to.
• Click on the preview button.

• You will receive an e-mail with a link back to the data feed which you can download to your local system.
• The items that had a price lower that 10 will not be included in the feed.
• To view the status and see a count of the number of items that were dropped, goto the Feeds tab and then click on Feed History. You will see the latest preview in the list with a count of the items filtered in the Filtered Items column. You can click on the number to see further details about what filters were applied.

Login to give us your comments on this SSC content