How to use AI to manage data in MERGADO

Keeping up with AI pays off in e‑commerce. In many cases, it can simplify your work and save you time, but it can also make your advertising more precise and bring you more profits. See how you can use AI to work with MERGADO right now.

Artificial Intelligence (AI) is currently one of the most important and debated topics in technology, but also in e‑commerce. With the help of AI-enabled product data management tools, e‑commerce businesses can automate tasks such as data entry, product categorization and attribute mapping, saving them significant time. AI can also help businesses identify and resolve product data issues, such as missing or incorrect data, and optimize product descriptions and names for better visibility in search engines.

AI and MERGADO System

Whether you’re removing watermarks and backgrounds from product images in Feed Image Editor, pulling information from the web with Scraping Camel, or merging categories in MERGADO Editor, you’re using AI without probably realizing it. In fact, we’ve been working with AI at MERGADO since 2017. Let’s show you where AI is already helping you and where it’s just waiting to be discovered.

Create rules with ChatGPT 

One example of where we work with AI is the Clicking Goat app. It allows you to write data from an external data source to an export in the MERGADO Store. Until now, you could only use one data source, which was the PPC system Sklik. This was connected to Clicking Goat via API and then allowed the user to enter the average click price or average keyword search rate into the export. Now you can choose ChatGPT as another data source, which opens up a lot of interesting possibilities to delegate your work to AI.

What will you use OpenAI for in Clicking Goat?

You have several options for delegating work to a chatbot. You can use OpenAI to generate the text of product descriptions, to sort products (or keywords) into categories, to translate text into a foreign language (it can also process text in different languages) or to extract parameters from text.

The OpenAI setup is similar to Sklik. You put your API key into the data source settings and then create rules. As with Sklik, the connection works by having Clicking Goat load the input data after the first export is processed in the MERGADO Editor. The OpenAI API then queries the results. On each subsequent re-generation, it writes the obtained results. It keeps these in memory and does not ask for the same input repeatedly.

How do I start using ChatGPT in Clicking Goat?

1. If you don’t have the app yet, activate it in the MERGADO Store. 
2. Then create an account in the OpenAI administration.
3. Create an API key in the OpenAI administration. 
4. Don’t forget to set your $ spending limits in OpenAI.
5. Insert the OpenAI API key into the Clicking Goat app. 
6. In Clicking Goat, create the element(s), test the prompts directly in the Clicking Goat interface or in the sandbox. 
7. Check the results. 
8. Use them in the MERGADO Editor.

Have ChatGPT generate regular expressions 

Regular expressions are a handy tool that helps you search or replace text and filter data in text or code. They’re basically useful shortcuts for a lot of different commands, requirements, and rules that you would otherwise have to deal with in many steps.

But the truth is that it can also be a long slog to find the correct form of a regular expression. Or at least it had been like that until we discovered a clever helper. ChatGPT.

Our support specialist Ludek has been chatting with ChatGPT about regular expressions for a while now. He has tested what ChatGPT can help you with, and what it is still short on. What is Ludek’s verdict?

The good news is that ChatGPT can really help you with regular expressions. For one thing, it explains nicely what each tag means, and if you give it a clear enough input, it will generate the regular expression itself without any problem.

We started the conversation gently and asked the chatbot to explain the meaning of the basic regular expressions in general. You can take a look at the picture to see how he did it.

After ChatGPT generated a list of basic regular expressions, we asked it to generate an expression that finds the number at the end of the string. It made it without any problems.

We decided to test its capabilities on more challenging examples. We asked it for a regular expression that would remove all the colors in our sample data. ChatGPT also handled this task nicely and actually provided us with a regular expression with which to remove the colors.

Trust but clarify the chatbot

ChatGPT has proven to be a good helper in creating regexes. ChatGPT has proven to be a good assistant in creating regexes. However, it is not flawless, so don’t rely on it 100%. What’s worked for us is to be as specific as possible. You can’t go wrong by giving the chatbot an example of what you want it to do either. Don’t be afraid to have a dialogue with it and to specify your request. And finally, don’t forget to check the correctness of the regex, whether created by you or the chatbot, on e.g. the aforementioned Regex101.

Download entire website into one CSV 

Another smart app we recommend you start using is Scraping Camel. This app crawls the pages of your website, saves the necessary information, and then creates a CSV file from it. You’ll use this for both automating ad creation and analyzing the site itself. Thanks to AI, Scraping Camel can count words on sites or generate keywords.

How to enable Scraping Camel AI? 

1. Activate the application in the MERGADO Store.
2. Create a web page and enable AI elements (e.g. SC_WORDS_AGG_MIN_FREQ_3 or SC_NUMBER_OF_WORDS).
3. Create your first keyword analysis.

Whether you’re actively using AI tools or are just getting started, in this article we’ve shown you how to use AI in the MERGADO System today. AI opens the door to faster bulk data editing, which is why its benefits are worth leveraging for your business. What are other ways to use AI to manage your data? We’ll explore that in future articles!