Section 4 : Review & Product Grid
Once product has been imported, the items will display in the preview grid. Once finalised the product lines will move to the product grid for enrichment and export.
4.1 Hide Column
Users can hide a column by hovering over the column header, clicking on Actions tab and selecting Hide column option. The column will be hidden, and it can be brought back into the grid from Show/Hide panel.
4.2 Bulk Edit by Dragging
Users can edit data inside the grid by clicking on a cell and dragging the mouse up/down, right/left.
4.3 Bulk Edit by Copy/Paste
Users can use CTRL-C/CTRL-V to copy paste data from one cell to another as well as from multiple cells to others. This functionality also works with external documents; therefore, Users can copy and paste information from or to Excel documents. Please note, from a hierarchy view, copy and paste will only work over allowed hierarchy access level and expanded product
4.4 Bulk Edit/Find and Replace
Users can edit data in bulk by using the Bulk edit functionality from Actions tab. This functionality is available for each column.
Users can use this feature on all data from a specific column, by selecting Apply to all option or to a selection of products, by selecting Apply to selection option.
Match full cell content option - Users can select if the change should be applied only to the values that fully match the data written in "Find" input.
Match case option - Users can select if the system should take into consideration if the value in "Find" input is written with Uppercase or Lowercase.
The number of cells that will be changed is displayed above the Update button.
If groups have been enabled, users can select all the products from one group by simply selecting the group. They can select multiple groups and as well deselect specific product rows to perform the find and replace functionality.
4.5 Filter Data on Columns
For each column, Users can filter data, using different operators such as equals, contains, less than, greater than etc. Also, there is the possibility to filter by Format issue or Missing data, thus displaying only the cell that have errors or are empty. Filters can be removed (1) individually, by clicking the Clear button available for each column or (2) in bulk, by using the Clear all button available inside the Filters panel.
In Filters side panel, Users can see the number of errors they have on each column. The number will change based on the filters they apply.
The show errors by column button will also show number of MISSING data fields, where the data field has been marked as mandatory. Missing but non-mandatory data will not display, when selecting this option.
4.6 Add New Product Manually
Users can now add new products in the grid manually, by clicking on Add product button displayed on the right side of the Grid, below Filters section.
4.7 Add Calculations to a Column
Calculation formulas enable you to perform mathematical operations on a specified data column. For example, they can be used to compute cost margins, apply price markdowns, or convert foreign exchange rates.
Please note that the column must already exist within your dataset.
To apply a formula, right-click on the desired column and select the Add Formula option.
Search for the desired column where the pre-calculation/raw data is located in the PIM model.
When selected, PIMdrop will identify the column in [] square brackets. Enter the required mathematical equation using +, -, *, or / to perform the calculation. You can continue building your formula by searching for and selecting additional columns or by entering a fixed value, such as a currency exchange rate.
Please note that if a calculation requires its own result before being used in subsequent formulas, the mathematical expressions must be enclosed in parentheses ( ) to ensure proper execution.
Formula restrictions: Formulas can only be applied to columns configured as:
Numbers
Numbers with decimals
Currency
4.8 Text Concatenations to a Column
Building on the same concept as formula calculations, text concatenation enables you to create a text string within a designated column by combining data from another column or adding a custom string.
You can construct the text string first and then incorporate data from another column. When inserting data within the concatenated string, search for the appropriate column containing the pre-calculated or raw data within the PIM model.
Build your concatenation formula by either entering a text string or selecting other columns.
When a column is selected, PIMdrop will identify it using square brackets [ ]. Text values must be enclosed in double quotes (""), and the + operator should be used to concatenate multiple elements within the formula.
Please note: Concatenation can only be applied to columns configured as Text.
4.9 IF/THEN Statements
An if-then statement is a basic concept in programming that allows a program to make decisions. It works by checking a condition:
If the condition is true, then the program executes a specific action.
If the condition is false, the program either does nothing or follows an alternative path.
If/Then Statements can be also configured under the Add Formula Option.
Select the column where you want the program to execute the action.
To create your first IF statement, start by typing "if", then choose the pre-calculation or raw data column from the PIM model. Once selected, PIMdrop will enclose the column name in square brackets [ ].
Next, enter the value the IF statement should check for (the true condition). As this is text, the value needs be surrounded by quotes. A comma indicates the next step of the statement, being the new value you want PIMdrop to apply when the condition is met. Another comma should be entered to indicate the next step of the statement. Double quotes, indicate if the statement is found to be TRUE.
example of multiple IF statements:
if([Web: Gender] = "W","Womens",(if([Web: Gender] = "M","Mens",(if([Web: Gender] = "U","Unisex","")))))
4.10 ROUND Statements
The ROUND function rounds a number to a specified number of digits. For example, if your data is showing values to 4 decimal points , e.g. 23.7825, and you want to round that value to two decimal places, you can use the ROUND formula. Column data must be defined as numeric, numeric with decimals or currency for this function to be used.
ROUND statements can be also configured under the Add Formula Option.
Select the column where you want the program to execute the action.
To create your ROUND statement, start by typing "Round", then choose the raw data column from the PIM model. Once selected, PIMdrop will enclose the column name in square brackets [ ].
Next, enter a comma to determine a new value, and enter the value of decimal points for the rounding. Click the ‘Validate Formula’ button.
4.11 MIN/MAX Statements
The ‘Max’ function returns the larger of two specified columns of data
The ‘Min’ function returns the smaller of two specified columns of data.
MIN or MAX statements can be also configured under the Add Formula Option.
Select the column where you want the program to execute the action.
To create your Max or MIN statement, start by typing "Max" or “Min”, then choose the FIRST raw data column from the PIM model that you want to be used for comparison. Once selected, PIMdrop will enclose the column name in square brackets [ ].
Select a comma to determine the second value and select the second raw data column from the PIM model that you want for comparison. This will also be enclosed in [].
Click the ‘Validate Formula’ button.
4.12 SPLIT Statements
The SPLIT function allows you to split contents of one cell into another cell.
By defining a delimiter, it allows the information to be offset by a space, or other character such as a comma
To create your SPLIT statement, start by adding the formula on the column you want the new data to be inserted. In the formula editor text box, start by typing "split”, then select the raw data column from the PIM model that you want to be used to split the data. Once selected, PIMdrop will enclose the column name in square brackets [ ]. Then choose the delimiter, eg “ “ (space), “_” (underscore) or “,”(comma) etc. Then define the character count offset on where the split is to occur.
For example:
split([Colour Code],'_',3) will return the last 3 characters following the delimiter character being the ‘_’ on the colour code column.
Click the ‘Validate Formula’ button.
4.13 Translations
The Translate function allows you select rows of data and convert text from one column language to another, either within the same column, or on a different column.
Select the rows where the conversion needs to occur.
In the data column to be translated, from Actions, select Translate
Select the source language from the raw data column from the drop down selection screen, e.g. English
Select the destination language, e.g. Japanese
If the second language data is to display in a different column, check the option, apply on different column, and select the new column from the selection list. Eg. ACME Japanese
Select Translate
4.14 Freeze Panes
Working on a data set contaning many columns of data can be difficult as you need to scroll beyond the current screen real estate. You can freeze columns to the left of the data set, by dragging the desired columns to the left of the selection check box.
This will freeze the column in place. You can freeze as multiple column into this fixed location
4.15 Hover Hints on Column Headings
When hovering over a column name, the hint box will display. The information contained advises:
The full heading of the column
The ‘type’ configuration of the column e.g. string (text), numeric, link (with tips), number, date etc.
Tips if applicable
Formula (if assigned)
4.16 WYSIWYG HTML Editor on Large descriptions
Large Descriptions now include a built-in editor, allowing seamless formatting of HTML content. Easily apply bold, italic, underline, bullet points, and other standard styling options to enhance and emphasise your text. When exporting your data, the data is converted to HTML code ready for easy import to your web platform.
4.17 AI to help build web ready descriptions
AI calls can be costly, so to minimise the amount of data sent to AI, the system can be defined to designate which columns of data will be used by the the AI to generate comprehensive descriptions. You can also nominate which columns are AI-enabled. The columns must be defined as a type "large description".
In the PIM configuration, edit the column that is to be AI enabled. Ensure the Generate AI Description toggle is switched on.
To designate which columns of data will be used by the the AI to generate comprehensive descriptions, in the PIM configuration, edit the column that is to be used to build out the AI enabled. Ensure the Send to AI toggle button is switched on.
From the PIM preview or product grid, select the rows of data you want the description to be generated for. On the AI enabled column, select the "Generate AI Description".
The system will then generate based on the data from the AI enabled columns.
As with all AI, the data generation should be carefully checked to ensure it accurately describes your brand and message.
Last updated