SUMMARY

1 - What are the goals of personalized fields ?

2 - Create your 1st personalized field

1st step : Where do we create a personalized field

2nd step : discover the personalized field user interface

3rd step : blocks choice for the 1st field and save

3 - Use a personalized field

4 - Available blocks description

- My fields and constants

- Conditioning (if…then…else)

- Strings operators

- Numerical operators

5 - Tips & tricks

- Multiple conditions

- Copy/paste within one same field

- Copy/paste between 2 different fields or 2 different stores

BeezUP allows you to customize all data that you send to your channels thanks to Personalized fields.
This article describes you how !

1 - What are the goals of personalized fields ?


Personalized fields can be used in several situations, here are a few examples:

- Improve an incomplete catalogue
Ex : to indicate the shipping costs when they are not in your source feed

- Make a field matching some specific requirements
Ex : convert « 1 » into « In Stock » for a specific channel

- Combine various fields
Ex : Make your title become the combination of : « Product title » + « color » + « brand »

- Modify a value depending on several conditions
Ex : Reduce by 10% prices of a specific brand on a specific marketplace

This article will tell you how to create your first simple personalized field, but also how to go much further in customizing data sent to your ecommerce partners.


2 - Create your 1st personalized field

1st step : Where do we create a personalized field


You can create a personalized field for any field of any channel, here's how :

cp1.png
cp2.png

1. Click on « Channel »

2. Click on the « Column mapping» button of the chosen channel

3. Identify the field for which you want to create your personalized field, and click on the dropdown list in front of it.

4. Select in the bottom part of the dropdown list the option "Create a personalized field".

The personalized fields dedicated menu then pops up !

cp3.png

2nd step : discover the personalized field user interface

Personalized fields user interface has several features, here are all of them zone per zone :

cp4.png

1 : Personalized field name : this is where you can give a specific name to your personalized field so that you can, then, easily find it in your mapping pages.

2 : Available blocks : this is from this list that you can select all necessary blocks to build your custom field. See below for details on each of them.

3 : Workspace : this is your "free" zone, where you can put your blocks so that they become together the logic you want
Note : in order to be considered your blocks must be all attached to the main "Return" block

4 : Preview : this is where you can see your result, for a chosen product (zone 5), of your built expression (in zone 3)

5 : Source values : this is this zone that you can choose the product for which you want to see your built expression's result. You just need to type the desired product SKU in the dedicated field, and click on the arrow.
You can then see in zone 4 (preview), the result for the chosen product
In the bottom part of this zone, can be found all your source feed fields with their value for the chosen product, this is useful to have a look at them to check your built expression

6: Validator : this tells you if your expression is ok, or if not its errors.

7 : Zoom and center : these buttons allow you to zoom in/out as well as recenter your workspace

8 : Bin : with a drag and drop until the bin, you can delete any block from your workspace

9 : Save: mandatory button if you want to save your expression, only works if your expression is valid ("Validator" : OK)

10 : Close : button that allows you to close the window without saving modifications

3rd step : blocks choice for the 1st field and save


Now that you know the interface, in order to build personalized field, you need to select from the left list (zone 2) blocks matching your needs.
For the 1st personalized field, we'll only take one "texte" constant block, to export for all products expression "En stock".

Here are the 4 main steps to achieve it :

cp5.png

Step 1 : From the left list, click on "Constants", then select "abc" which stands for a text constant.

Step 2 : Thanks to a drag & drop, attach the block to "Return"
Note : a little sound should be heard if this is well attached

Step 3 : Click in the center of bloc, delete "abc" and then type your desired text, here "En stock"

Step 4: Your block is now done, as well as your first custom field.

You then just need to click on "Save "zone 9) after having renamed your field (zone 1)

Congratulations, your 1st personalized field is now created !

Back to the mapping page, your newly created field should appear in the list of available fields, and can hence be mapped wherever you need to.

Or if you prefer learning how to create your first personalized field through a video, there it is :

3 - Use a personalized field

Once your custom field created, you can :

1) access it from any mapping page, and map it to the field of your choice. On the below example the personalized field "NAME + BRAND" is used as "title",

2) edit it and/or see its detail, and come back to the interface described above,

3) delete it.
Note : you can only delete a field as long as it's not mapped on another channel.

cp6.png

4 - Available blocks description

To answer most demands, you can create personalized field by selecting lots of different blocks :

- My fields and constants

- Conditioning (if…then…else)

- Strings operators

- Numerical operators

My fields and constants

"My fields" regroup all the fields from your source feed, you can use them as you freely.
The constants are essential, they can be used in the other blocks described below, but they can also be used to always return the same value.

Name

Block

Description

Example

Example illustration

Your field names


These blocks represent your source feed fields. They can be used in various situations (see below), or they can be used by themselves to just export your field. It can be useful if you want to export twice your field for the same channel.

Return with no modification your "URL image" field.

Text("abc")

This block, by editing the default "abc" can return any fixed text. It can be used on its own or in some other blocks (see below).
Note : This block can contain 8192 characters maximum.

Return "En stock" for all products

Numerical(0)


This block, by editing the default "0" can return any numerical value of your choice. It can be used on its own or in some other blocks (see below).

Return "5" for all products

Conditioning (if…then…else)


These blocks allow you to define in which condition returning which value, and in which other condition returning another value, with no limits.

Name

Block

Description

Example

Example illustration

If...else


Is useful in order to perfom one operation only one specific condition is true or another one if false.

Note : it's possible by clicking on the "gear" to add several conditions.

Return "0" if price is> 100, 10 otherwise.

Text compare


Allows to test any field on several possibilities :
- if it equals (or not) to a specific value
- if it contains (or not) a specific value
- if it starts (or ends) by a specific value
- if it's included in a list of specific "A|B|C, etc" elements (or not)
- if its text contains one of "A|B|C, etc" elements (or not)
- if it's empty (or not)
- if it has more than x characters (or not)
- if it has x characters (or not).

Return "MySuperBrand" if the brand is empty, otherwise return "brand".

Math compare


Allows to test any numerical value on :

- if it equals (or differs) a specific value
- if it's smaller (or equals) to a specific value
- if it's bigger (or equals) to a specific value
- if it's between a value and another one.



If the price is bigger than 50, then return "Promo-10%".
If not, if the price is bigger than 100 then return "Promo-20%".
In all other cases, return nothing (empty value).

And/Or


Allows to group conditions together in order to return one value only if one of the condition is true ("or"), or all of them ("and")

Note : it's possible by clicking on the gear to add several elements to the "and" or "or".

If "Couleur" and "ColorId" field are empty then return "White", otherwise return "Couleur" field.

Strings operators


These blocks allow you to make various operations on any "text" field :

Name

Block

Description

Example

Example illustration

Concatenate


Useful to concatenate at least 2 expressions together.

Note : it's possible by clicking on the gear to concatenate several elements together.

Return the concatenated expression of Title+"from brand"+ Brand

Case


Useful to set all letters of a field in lower case, or upper case, or capitalize (but only each 1st letter of a sentence in capital letter).

Note : in order to choose between lower/upper/capitalize, just click on the small arrow.

Put in lower case the field "Brand".

Length Of


Allows to return the length (in number of characters) of a field.

Return the length of field "EAN".

Take First


Allows to return the first word or sentence of a field.

Return the first word of field "Model".

Substring


Allows to extract one subpart of a field, by defining the 1st character to take into account as well as the last one.

Get only the 10 first characters of "Title".

Trim


Allows to delete all extra (and useless) blanks at the beginning and the end of a field.


Delete all useless blank characters in field "Description"

Split

Useful to extract a string until an umpteenth apparition of a determined separator.


Get the value located between the 1st ">" and the 2nd ">" from field Category.

Hence for instance, if in source feed value is "High-tech>TV>LCD", it will return "TV"

Replace in string


Allows, within one field, to replace one string by another one.


Within "Title" field replace "not expensive" by "cheap".

Replace


Useful to return one specific value if one field contains (or equals) one given value.

Note : it's possible by clicking on the gear, to add several elements to be searched/replaced.


If field "description" contains the following values :cyan, magenta, yellow then return respectively : blue, red, yellow.
Otherwise, return "color" field

Numerical operators

These blocks allow you to any standard mathematical operations on any numerical field :

Name

Block

Description

Example

Example illustration

Calculate


These blocks allow to perform any standard mathematical operation. (+,-,*,/)

Increase price by 10%

Round

This block allows you to round any decimal field to a specific number of decimals.


Round to 2 decimals the result of Price/3

5 - Tips & tricks


The personalized fields user interface has been designed to provide efficiency while realizing any type of data modification, but still remaining easy to use.
This section will show you some tips & tricks to enhance your efficiency !

Multiple conditions

All blocks with a "gear" can accept unlimited number of items.
You just need to click on the gear, then drag & drop as many new blocks as you may need.

Once all additional required blocks are added, please click again on the gear to close the menu and carry on your field design.

Copy/paste within one same field

You can, just like any other app, do a blocks copy/paste or even groups of blocks copy/paste.
To do so, just left click on the block to duplicate (note that all under blocks will also be copied), and then :
> either right click and click on "duplicate"
> or do a "ctrl+C / Ctrl+V"

Selected group of blocks, will then be duplicated :

Note that you can also do several "paste" in a row, you just need to do multiple "cltr + V"

Copy/paste between 2 different fields or 2 different stores

It's also possible, to avoid having to rebuild a field from scratch to copy/paste a group of blocks from a field to a new one or even to another store :
> within a given field, press "F8" on your keyboard => your personalized field will be pasted to your "clipboard". A "Successful" popup should hence confirm it.
> on the same store, or another one, create a new personalised field, and press "F9" on your keyboad, a popup will then appear :

cp7.png

Then, just do "cltr +V" (or right click : "paste")
=> your copied field is then displayed, do not forget to reattach it to "Return".

Warning :
If you save clip-board content on a separated external file, it can only be used within the same day.
In some cases, on Google Chrome, access to clipboard can be forbidden, you'll then have a popup telling you to copy manually your field from the preview zone :

Did this answer your question?