SUMMARY
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
- My fields and constants
- Conditioning (if…then…else)
- Strings operators
- Numerical operators
- 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 :
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 !
2nd step : discover the personalized field user interface
Personalized fields user interface has several features, here are all of them zone per zone :
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 :
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.
4 - Available blocks description
To answer most demands, you can create personalized field by selecting lots of different blocks :
- My fields and constants
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 |
|
| 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). | Return "En stock" for all products |
|
Numerical(0) |
|
| 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 |
|
| Return "0" if price is> 100, 10 otherwise. |
|
Text compare |
|
| Return "MySuperBrand" if the brand is empty, otherwise return "brand". |
|
Math compare |
|
|
|
|
And/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 |
|
| Return the concatenated expression of Title+"from brand"+ Brand |
|
Case |
|
| Put in lower case the field "Brand". |
|
Length Of |
|
| Return the length of field "EAN". |
|
Take First |
|
| Return the first word of field "Model". |
|
Substring |
|
| Get only the 10 first characters of "Title". |
|
Trim |
|
|
|
|
Split |
| Useful to extract a string until an umpteenth apparition of a determined separator. |
|
|
Replace in string |
|
|
|
|
Replace |
|
|
|
|
Numerical operators
These blocks allow you to any standard mathematical operations on any numerical field :
Name | Block | Description | Example | Example illustration |
Calculate |
|
| Increase price by 10% |
|
Round |
| This block allows you to round any decimal field to a specific number of decimals. |
|
|
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 :
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 :