AI Help Button

Macros Expert

 

The Macros Expert is a specialized AI assistant designed to help Sales Layer users create, validate, and optimize data transformation formulas (macros). With it, you can easily clean, format, and automate product information during imports and exports, ensuring accuracy, consistency, and efficiency.

 

How to use it:

 

You can find this feature in two different sections

  1. Formula application into the Bulk Actions section, and

  2. Formula application into the Channels section

Bulk Actions section:

  1. Go to Actions > Edit > In bulk as shown in the image below
     
Edit In Bulk button
 
  1. Click 'formula' and select a field to update. 
  2. This will enable the AI help button below.
 

Channels section: 

  1. Go to the Channels tab and select the channel you want to edit.
  2. Navigate to the Output Data tab and scroll down to the Configure Fields section.
  3. Click the + Formula button. A pop-up window will appear.
  4. Click the ‘Ask AI Expert’ button to open the ChatGPT Macros Expert tab.

     
How to acces the AI Help Button
 

You can give the AI assistant prompts that can help you build or review your formulas directly within Sales Layer.

 

Here are some examples of prompts you could use:

  • Write me a formula a formula to retrieve the last modification date of my products and the product name
  • Create a formula to show the product name followed by its reference.
  • Write a formula that only exports products with stock greater than zero.
  • I need a formula to retrive the last modification date of my products and the product name.
 

The Macros Expert will respond with the syntax using official Sales Layer formula functions as shown below. It also gives a detailed explanation on the formula parameters as well as contextual examples, helping you learn while you work.

 
Example of response

 

Data Model Expert

 

The Data Model Expert is an AI assistant that helps users analyze data, generate .xly files automatically, standardize catalog structures, and review existing forms for errors. This tool helps streamline your product form configuration process, ensuring accuracy which helps in maintaining consistent, manageable product data models.

How to access the Data Model Expert:

  1. Go to the Products tab.
  2. Under Actions, select Edit Forms.
  3. In the product forms editor, go to Actions again and click Import Configuration.
  4. In the pop-up window, click the Ask AI Expert button to open the ChatGPT Data Model Expert.
How to access the Data Model Expert

 

Example of a use case: 

 

Prompt: Prepare an .xly file to be imported as attribute sets in Sales Layer based on my product structure”. (include your product data in the prompt)

Response: It generates an xly structure based on the provided data as shown below. 

 
Example of a response

 

It is also possible to generate a downloadable .xly file which can then be imported into Sales Layer.

 
Importing a downloaded .xly