New in DataFeedWatch: Regular Expressions made easy with ''is in list(regexp)''

Posted on February 7, 2018 by Monica Axinte

is-in-list-regexp.png

It is easy to get excited about big, shiny new things, but there’s also lots of value in announcing smaller updates too. These smaller improvements can add up to a significant impact for our users.

That is why today we introduce a new functionality ‘’is in list (regexp)’’. 

We took something complicated, regular expressions, and turned it into something simple and accessible to everyone. 


What are Regular Expressions?

Regular expressions are very helpful when it comes to complex feed optimizations. Their only drawback is that the learning curve is quite steep and it takes some practice to get the hang of RegExp. 

Let's say you have a list of 100 IDs and you are able to find 3 patterns, that will match all your 100 values:

  1. 25 IDs start with ‘1’ and end with ‘7’
  2. 25 IDs start with ‘Adidas’ and end with ‘_2017’
  3. 50 IDs start with ‘2017’, end with ‘shoe’ and have ‘sale’ somewhere in the middle

If you know how to use regular expressions, you can replace a list of 100 values, with a list of just 3 values:

  1. ^1.*7$
  2. ^Adidas.*_2017$
  3. ^2017.*sale.*shoe$

in-list-with-regex.png

Regular expressions are pretty cool and efficient, right?

The great news is you do not have to know regular expressions to use the new ‘in list (regexp)’ feature.

 


How to use ''is in list (regexp)'' in your feed?

You probably know that you can use our ‘Add static value’ option to provide a color in your feed even if you do not have color field in your store - colors just need to be mentioned somewhere in your description or title.

However, things can get complicated if for each main color you have different shade names. Your blue products might have color names such as Indigo, Navy, Turquoise, Aquamarine and other variations. 

blue-color-variations.png

You want to have them all renamed in your feed to the color blue. Therefore you can create a list of possible values that you can use as a blue color.

blue-color-variation-list.png

 

For all these values, you proceed with creating a simple rule that will create the attribute blue if any of the color variations is in the product title or description.

static-color-blue-regexp.png

 


What is the difference between ''is in list (regexp)'' and  ''is in list''?

You might be familiar with our ''is in list'' option which enables users to apply a rule to a list of specific products. The option is really useful and our users love it, but it can feel limiting at time. If there is only one product with a different character or whitespace in that list of values that you uploaded, that product will not be considered as part of the list. 

Let’s say you have the following list of values:

list-of-values.png

 

You can use the ''is in list'' functionality to add labels to your bestsellers. Through the list of specific values above you can only include the 3 IDs: 1, 1234 and 6789.

is-in-list.png

 

But this will not be the case anymore.

We have recently introduced a new option - ''is in list (regexp)'' . By choosing ''is in list (regexp)'' all IDs that contain 1, 1234 (they were already covered by the first line) and all IDs that contain 6789 will be considered as part of the list. 

in-list-with-regexp.png

Same list of IDs, but quite a difference in the way our system reads it, based on which option you use.

What updates would you like for us to add on our to-do list? Feel free to leave a comment or to send an email to support@datafeedwatch.com. 

Also, keep an eye on our blog, we’ve got some more goodies in the pipeline for you!

 

Download 

 

About DataFeedWatch

DataFeedWatch is data feed optimization and management software that enables merchants on Magento, Shopify, Volusion3Dcart, BigCommerce, WooCommerce, OpenCart, VersaCommerce, and numerous other shopping carts to optimize their product data feed for Google and 1000+ Shopping Channels in 50 countries. The most intuitive and easy data feed management and optimization tool on the market. Free trial and live demo available.

Posted in: Features & Functionality, DataFeedWatch News

Written by Monica Axinte

Monica Axinte is the VP of Marketing for DataFeedWatch.
Find me on:

Related posts

It is easy to get excited about big, shiny new things, but there’s also lots of value in announcing smaller updates too. These smaller improvements ...
It is easy to get excited about big, shiny new things, but there’s also lots of value in announcing smaller updates too. These smaller improvements ...
It is easy to get excited about big, shiny new things, but there’s also lots of value in announcing smaller updates too. These smaller improvements ...
It is easy to get excited about big, shiny new things, but there’s also lots of value in announcing smaller updates too. These smaller improvements ...

Share This!

Subscribe to Email Updates