With their added flexibility, automatic rules open up a world of possibilities to online retailers when it comes to optimising their product catalogue. The goal is to make them the best retailers with a complete, personalised, and optimised feed.
To perfect your product catalogue whilst still adhering to the requirements of your chosen channels, automatic rules allow you to programme and automate a number of recurring tasks, saving you precious time. At Lengow, automatic rules are one of the major features of our platform. To help you set up these rules for your products, here are some examples of how to use them.
Automatic rules allow you to modify and update your product pages. You can add a number of conditions, starting with the values entered in your catalogue (titles, descriptions, etc).
By creating a rule, you can edit the brand name of the products you sell, with a rule that changes, for example, the brand ‘HP’ to ‘Hewlett Packard’. The description column of your product catalogue can also be updated or even filled from other fields of your product catalogue, if it has not already been filled in.
Example: You’re selling a lamp. If the ‘shade’, ‘power’ and ‘bulb type’ fields are separate in your product catalogue, you could set up a rule that will group them to create a custom description.
With automatic rules, you can also change the characters in your fields to uppercase or lowercase. So you can put all the characters in the ‘Title’ field in lowercase with the LOWER syntax ($ field_textual), or in uppercase with UPPER ($ field_textual). To do this, go into the product attribute matching area and add LOWER or UPPER. Once this step is completed, make sure that your changes have gone through by previewing your catalogue.
1: The title ‘lengow t-shirt – m size’ is in lowercase:
2: by changing the field, the title is now in uppercase:
To avoid stock shortages and disappointing your customers, you can put a rule in place to make sure items that are low in stock aren’t sent. If you have low stock or you’re a “just-in-time” business, this rule is an essential!
Example: You want to remove your product when it has only 5 items left. I set a rule that says that if my stock level reaches 5, then my stock automatically becomes 0 and is removed.
If you’re selling on a marketplace, it’s important to make sure that your stock management is impeccable, otherwise you could be temporarily or permanently excluded by these platforms.
See also: Amazon: How Can I Reactivate My Seller Account After Suspension?
With mathematical functions, you can round up or perform different types of calculations (additions, multiplications, divisions or subtractions) to apply updates to your product catalogue.
Example: You want to highlight a product by offering free shipping, and to do this, you want to reduce your selling price by 15% and add a delivery fee of 5% within the price of the product. The calculation needed will be: CALC (($ PRICE * 0.85) + ($FDP*1.05)).
Note: You can also use mathematical functions to include the marketplace commission in the price of your product directly.
If you’re distributing your products internationally, you can also use this feature to adjust the exchange rate of your products and thus convert a product into another international currency. For Euros, for example, the will be: CURRENCYCONV($PRICE,EUR).
As each channel has its own specificities, the rules will be really useful for managing requests on a case-by-case basis for different channels.
Take Amazon, for example. Managing product attributes is compulsory, but it quickly becomes complex without automatic rules. These rules allow you to differentiate parent products from child products, and to add the types of attributes you want to include (size, colour, etc).
If you distribute your products on Google Shopping or Spartoo, you can match your product categories with the requested genres (Men = M for example). To do this, you will need to use conversion lists to change the values of a field in your catalogue and match it to the values required by the channel.
After setting up your automatic rules, you will be able to choose their activation date. This is especially useful during promotional periods, like during a flash sale for example, as you will have the opportunity to change your prices by products or by category. Once the period has passed, your rules will automatically turn off.
Example: If my ‘name’ is ‘sticker’, then my ‘price’ drops by 10% for a week.
You can set up automatic rules in Lengow during the matching stage for your product attributes. Here, you can control the number of products targeted by your rule in real time, thanks to a counter that automatically updates as soon as you change your conditions.
Example: You want to lower the price of certain products during a private sale. You can lower their prices by 10% first, then add a second rule that cancels the 10% if the price after promotion is less than £10.
Not a customer yet? Don’t hesitate to ask us for a free demo!
Your e-commerce library
How to Maximise Revenue on MarketplacesLearn more
Grow your Amazon sales using A+ pagesLearn more
Maisons du Monde Case StudyLearn more
By submitting this form you authorize Lengow to process your data for the purpose of sending you Lengow newsletters . You have the right to access, rectify and delete this data, to oppose its processing, to limit its use, to render it portable and to define the guidelines relating to its fate in the event of death. You can exercise these rights at any time by writing to email@example.com
If you are a brand or retailer running an e-commerce business, you probably know how important it is to make…
E-commerce in China
Over the past few weeks, a new social media app called Lemon8 has been making waves in the United States.…
Selling your products on Amazon can be a lucrative opportunity to reach a broad audience (Amazon has more than 310…
Artificial Intelligence (AI) has revolutionized the way companies operate, especially AI in e-commerce is worth it being mentioned. With the…
Knowing how your target audience shops is vital to building an effective marketing strategy. However, today shopping behaviours change as…