Structured information to guide you through Unbxd PIM with minimal assistance
  1. Introduction
  2. Access Unbxd PIM
  3. Explore Unbxd PIM
  4. Features of Overview page
  5. Profile
  6. Organization - Set up your PIM Team
    1. Invite a New Member
    2. Update Member Information
    3. View a Member Information
    4. Delete a Member
    5. Create a New Role
    6. Set Property Permissions for a Role
    7. Set System Permissions for a Role
    8. Change Assigned Members of a Role
    9. Change Property Permissions for a Role
    10. Change System Permissions for a Role
    11. Change the Role Name
    12. View a Role Information
    13. Delete a Role
    14. Edit your Organization Profile Information
  7. Imports - Onboard & Schedule your Product Content
    1. Import File Best Practices
    2. Tips for doing an effective import
    3. Perform First-time Product Import
    4. Import data via SFTP
    5. View an Existing Import Information
    6. Schedule an Import
    7. Edit a Scheduled Import
    8. View a Scheduled Import Information
    9. Stop a Scheduled Import
    10. Delete a Scheduled Import
    11. Import Templates
    12. Deleting Import Template
    13. Trouble Shooting Import Errors
  8. Products - Build & Enrich Product Content
    1. Advanced Search and Filtering and saving filters by creating static product group
    2. Customize your Product Listing View
    3. Add a Solo Product
    4. Add a Solo Product via AI
      1. AI Content Score
    5. Add a Variant Product
    6. Edit a Solo Product
    7. Edit a Parent Product
    8. Edit Products from Product Listing Page
    9. Edit a Variant Product from its Parent Product
    10. Product Listing Page [AG Grid Feature / Excel Mode]
    11. View Activity Log Details for a Product
    12. View Product Details
    13. Cloning a Product
    14. Assign Category to Product from Product Display Page
    15. Create and View task from PDP Page
    16. View Task Information from Product Display Page
    17. One Click Export
    18. Delete a Product from Product Listing Page
    19. Delete Product from Product Display Page
    20. Product Groups
      1. Create a Static Product Group
      2. Edit a Static Product Group
      3. View a Static Product Group Information
      4. Delete a Static Product Group
      5. Create a Dynamic Product Group
      6. Edit a Dynamic Product Group
      7. View a Dynamic Product Group Information
      8. Delete a Dynamic Product Group
    21. Bulk Actions for Products & Product Groups
      1. Add Products to a Static Product Group
      2. Bulk Edit Products
      3. Bulk Edit Category
      4. Assign Task
      5. Certify Products
      6. Delete Multiple Products
      7. Certify Product Groups
      8. Run Readiness Report
      9. Delete Product Groups
      10. Edit Multiple Products from a Static Product Group
      11. Remove Products from a Static Product Group
      12. Delete Products from a Dynamic Product Group
      13. Delete Products from a Static Product Group
      14. Edit Multiple Products from a Dynamic Product Group
      15. Enrich Products or Product group data
  9. Certified Products & Certified Product Group
    1. Customize your Products Listing View
    2. Export Certified Products
    3. Export Products with Readiness Check & Assign Task
    4. View Activity Log Details for a Product
    5. Delete Products from Certified Product Group
    6. Export Certified Product Groups
    7. Export Certified Product Groups with Readiness Check & Assign Task
    8. Add Channel Readiness for a Certified Product Group
    9. Edit a Certified Product Group
    10. View Certified Products
    11. Delete a Product Group
  10. Scripts - Transform your Product Data
    1. Using the Transformation Script Editor
    2. Post Transformation
    3. List of Transformation Scripts
  11. Properties - Manage your Product Characteristics
    1. Property Data Types
    2. Create a New Property
    3. Change the Property Name and Assigned Property Group
    4. Change Role Permissions for a Property
    5. Make a Property Searchable
    6. View a Property Information
    7. Download all Properties
    8. Delete a Property
    9. Property Groups
      1. Create a New Property Group
      2. Change Property Group Name and Associated Properties
      3. View a Property Group Information
      4. Delete a Property Group
  12. Categories - Manage your Product Classifications
    1. Create a New Category & Subcategory
    2. Change Category Name & Associated Properties
    3. View Category & Subcategory Information
    4. Delete a Category or Subcategory
    5. Bulk Remove Categories
    6. Upload Category Property Association
    7. Download Category Property Association
    8. Download Category Property Template
  13. Tasks - First Step Towards Building Processes
    1. Create a New Task
    2. Edit an Existing Task
    3. View Task Details and Task Status Details
    4. Task Templates
      1. Create a New Task Template
      2. Edit a Task Template
      3. View Task Template Details
      4. Create a Task using a Task Template
      5. Delete a Task Template
    5. Task Assignee
  14. Readiness Reports-Ensure product information completeness
    1. Creating Readiness Report
    2. Downloading Readiness Report
    3. Viewing Readiness Reports
    4. Assigning Task using Readiness Report
  15. Catalogs - Share real-time Product Content
    1. Create & Share a New Catalog
    2. Edit a Catalog
    3. Delete a Catalog
  16. Workflows - Automate PIM Processes
    1. Create a New Workflow
    2. Run a Workflow Manually
    3. Pause & Resume a Workflow
    4. Edit a Workflow
    5. View Workflow Details
    6. View Activity Log Details for a Workflow
    7. Delete a Workflow
    8. Bulk Actions
  17. Digital Asset Management - Manage your Digital Files
    1. Add a New Asset
    2. Associate Assets with Products
    3. Perform Asset Transformations
    4. Deassociate Asset from Products
    5. Download Assets
    6. Delete an Asset
  18. Exports
    1. View Exports
    2. Download an Exported File
    3. Send an Email with the Exported File
    4. Schedule an Export
    5. Edit a Scheduled Export
    6. View Scheduled Export Details
    7. Email Exports
    8. Stop a Scheduled Export
    9. Delete a Scheduled Export
    10. Export Parent Products
    11. Export Products via SFTP
    12. Standard Templates and Custom Templates
      1. Edit a Standard Template
      2. View Standard Template Details
      3. Create a Custom Template
      4. Bulk add properties while creating custom export template
      5. Edit a Custom Template
      6. View Custom Template Details
      7. Delete a Custom Details
  19. Deleting Export Template
  20. Volusion
  21. AI Enrichment Apps
    1. Mandatory Properties and Prompt Values for each AI App
    2. Creation of templates for AI enrichment apps
      1. Amazon Description Generator
      2. Amazon Title Generator
      3. Amazon Ads Headline Generator
      4. Product Name Generator
      5. Google Ads Generator
      6. Google Ad Description Generator
      7. Google Title Generator
      8. Youtube Hooks Generator
      9. Youtube Outline Generator
      10. Youtube Description Generator
      11. Youtube Intros Generator
      12. Youtube Titles Generator
      13. Trending Instagram Hashtag Generator
  22. Bulk Transform and Enrichment
  23. Custom Template Uploader
  24. Custom Template Downloader
  25. Headerless File Format
  26. Bulk Asset Upload and Download
  27. Image Keyword Extraction
  28. Dropbox
  29. Zapier(Gmail)
  30. Zapier(Google Sheet)
  31. Find Duplicates and Related Products
  32. Vend
  33. Volusion
  34. Google URL data Fetcher
  35. UPC Generator
  36. Image Convertor to Webp
  37. Translate Catalog
  38. Extract Common Variant Properties
  39. Image Keyword Extraction
  40. AI Image to Product Builder
  41. DAM Remove BG
  42. Guide for Obtaining AWS S3 Bucket Credentials & Configuring Public Access Permissions
  43. SFTP Watcher App
  44. Generate Partial Search
  45. Channel Integration
    1. Channel Integrations -
      1. Installing BigCommerce store via Unbxd PIM
      2. Importing data into Unbxd PIM from BigCommerce
      3. Mandatory Properties to export products to BigCommerce
      4. Exporting data from Unbxd PIM to BigCommerce
      5. Automating import and export using Templates and Workflows
    2. Channel Intergation-
      1. Installing Shopify via Unbxd PIM
      2. Shopify Store Fetcher
      3. Mandatory Property Mappings for Shopify
      4. Properties in Shopify and Shopify Graph QL and their importance
      5. Importing the data into Unbxd PIM from Shopify
      6. Exporting data from Unbxd PIM to Shopify
      7. Automating import and export using Scheduled Imports/Exports and Workflows
    3. Shopify Graph QL
    4. Channel Integrations -
      1. Installing Unbxd PIM via Brightpearl
      2. Importing the data into Unbxd PIM from Brightpearl
      3. Exporting data from Unbxd PIM to Brightpearl
      4. Automating import and export using Templates and Workflows
    5. Channel Integration -
      1. Installing Magento using Username and Password
      2. Magento Token Based Installtion
      3. Mandatory Properties for Magento
      4. Mageworx
    6. Channel Intergation-
      1. Installing Etsy via Unbxd PIM
      2. Importing the data into Unbxd PIM from Etsy
      3. Exporting data from Unbxd PIM to Etsy
      4. Automating import and export using Scheduled Imports/Exports and Workflows
    7. Channel Integration -
      1. Installing Walmart via Unbxd PIM
    8. Channel Integration-
      1. Installing Unbxd PIM via Amazon Seller central
      2. Installing Amazon Seller Central via Unbxd PIM
      3. Importing data into Unbxd PIM from Amazon
      4. Exporting data from Unbxd PIM to Amazon
      5. Automating import and export using Templates and Workflows
      6. Download category template from amazon seller central
    9. Ebay Installation-
    10. Steps to get template file for Ebay-
    11. Channel Integration-
      1. Google Shopping App Installation
      2. Mandatory Properties for Google Shopping
    12. Woocommerce Installation-

Performing First-time Product Import

Once you have the import file ready, all you have to do is get that product data into Unbxd PIM. The first-time product import is a two-stage process:

  1. Uploading product information
  2. Mapping and configuring product properties

Note: If you have no file to import, you can start by creating product properties. For more information, see Properties. If you are still working on your import file or waiting for one, you can start with building your PIM team. For more information, see Organization Setup.

Upload Product Information in Unbxd PIM

  1. Navigate to the Import tab
  2. Click New Import to start the product import process / Click Start Import on the Overview page.                                      
  3. Upload your import file containing the product information in one of the supported formats (CSV, XLSX, JSON, TSV, or XML).
  4. Choose either the drag-and-drop method or use the file browser to select and upload the file from your local system.
      • Optionally, you can upload a . ZIP file that contains your product information.

        Note:The . ZIP file will only import the above-supported formats (.CSV, XLSX, JSON, TSV, or . XML).

        Once you have uploaded the file, it will be processed by Unbxd PIM. The uploaded properties will be displayed, representing your import file

        • To view sample import file formats, click Download sample file formats to access the examples.

 

Upload your import file using an SFTP location in Unbxd PIM

  1. On the Overview page, navigate to the Import tab and click “New Import“.
  2. On the “Manage Import” tab, use the search box to find and select “SFTP” as the import channel.
  3. Under “Import details,” provide a name for the import to identify it.
  4. In the “SFTP details” section, click “Add new SFTP” to set up the SFTP location.
  5. In the “Select SFTP” list, click on “Add SFTP Details.”
  6. Enter a name for the SFTP connection to identify it.
  7. Enter the hostname or IP address of the SFTP server where your import file is located.
  8. Enter the port number associated with the SFTP server. The default SFTP port is 22, but it may vary based on your server configuration.
  9. Specify the path to the file you want to import on the SFTP server. Make sure to provide the correct file path and filename.
  10. Enter the username and password credentials to access the SFTP server and the import file.
  11. To test the connectivity of the SFTP location and ensure the provided details are correct, click on “Test Connection” and wait for the test to complete. If the connection is successful, a confirmation message will be displayed.
  12. After testing the connection, click “Save” to save the SFTP details.
  13. Finally, click “Save & Start Import” to initiate the import process from the specified SFTP location.
Upload your file using a public URL
    1. Click on Import
    2. New Import
    3. Search and click on Import Via URL
    4. Enter the URL of a file that is public
    5. Click on Save & Proceed

Once your file is processed, all the uploaded properties appear in a tabular format replicating your import file.

Note: You are still in the pre-import phase, and the data in the table is a snapshot of your import file.

For the first import, all the properties are tagged NEW. You can now start mapping the product properties so that Unbxd PIM interprets your product information accurately before the actual import. Here, you can also map the product properties as a new property or map to an existing property.

Perform These Mandatory steps before starting the actual import

  • Map your important PIM properties
  • Configure your properties.

Steps 1: Map the important PIM properties

  1. (mandatory) In the list, select your property that is equivalent to a product ID.
  2. (mandatory) Select your property that is equivalent to a product name.
  3. In the list, select your property that is equivalent to a product image.
  4. If you have a parent ID for your products in the list, select the property that is equivalent to a parent id.
  5. If you have categories for your products, in the list, select the property that defines your category structure. Once you map a property as “Category,” the property will automatically set its data type to “Tree/List.
  6. To configure these properties, click  Save and proceed.

For example, the Product Id might be equivalent to the SKU Id of your import file. The Product Id will be mapped to SKU Id.

Unique ID Assignment and Duplicate Avoidance

Unbxd PIM offers an exceptional feature that addresses duplicate products and assigns a unique identifier to each product if it doesn’t already have one. This ensures data integrity and uniqueness within the system.

    • Create a new unique Id: Unbxd PIM will automatically generate a unique identifier for each product that doesn’t have a pre-existing unique ID in the import file. This ensures that every product in your catalog has a distinct identifier within the system.
    • De-Duplicate: Map the unique property from your import file with the unique property in Unbxd PIM. This allows the system to identify duplicate products based on the specified unique ID field. The de-duplication process merges duplicate products into a single record, eliminating redundancies in your product catalog.

 

Generate Unique Ids or Address Duplicate Ids

  1. Click on Auto-generate or De-duplicate based on other fields
  2. In Case you have If you have a unique property other than the actual product ID, map them below to the respective PIM property (data from past imports) to ensure easy data transfer during imports. Map unique file property with unique PIM property this will avoid duplication.                                                                                                                                                                    OR
  3. If you want to Generate unique ids for each product, then checkmark the create new unique id field
  4. Click on save

List of New Properties

New properties are automatically detected based on the different data types present in the uploaded product information. These properties represent specific attributes or characteristics of the products being imported. Configuring and managing these properties is an important step in the import process to ensure accurate and organized product data.

To view the newly created properties and their associated data types, follow these steps:

    1. After mapping essential fields, click on “Save & Proceed.” This will redirect you to the “Configure All Fields” page.
    2. On the “Configure All Fields” page, you will find a list of properties that have been detected from the uploaded data. Each property will be displayed along with its corresponding data type.
    3. Look for the properties that have been newly created during the import process. These properties will be tagged as “New.”
    4. For the newly created properties, you have the option to select the appropriate data type. Choose the data type that best suits the nature of the data contained in the respective property.
    5. Click on Save & Import

Step 2:Configuring Properties

Once you have the list of properties, you can configure them according to your requirements. 

Here are the available configurations:

  • Map to an Existing Property or Create a New Property
      • You can choose to map a new property to an existing property if there is a similar attribute already defined. This helps maintain consistency and avoids duplication.
      • If no mapping is available, Unbxd PIM will automatically create a new property with the same name.
  • Writing Scripts for Data Transformation
      • Unbxd PIM allows you to write scripts in Python to perform data transformations. These scripts enable you to manipulate and transform the imported data based on your requirements.
      • The Python scripting language is used for its readability and simplicity.
  • Selecting the Data Type
      • Each property has a specific data type assigned to it, such as Text, Number, Date, Link, Boolean, File, Image, Tree/List, or Text Area.
      • You can select the appropriate data type for each property to ensure data consistency and accurate handling.
  • Making a Property Searchable in PIM:
      • You have the option to make a property searchable within the PIM system. By enabling this, you can search for values of that property in the Products Listing page.
      • By default, properties equivalent to the product ID and product name are set as searchable.
  • Defining Multivalued Separators:
      • Suppose a property has multiple values within a specific column of the import file. In that case, you can define a separator to split and import those values as separate values instead of a single value.
      • This is useful when dealing with properties that have multiple attributes or options.

Adding a new property

Unbxd PIM provides the flexibility to add new custom property columns during the pre-import phase. These columns can be mapped to existing properties or automatically created new properties. 

Additionally, you can write scripts to populate the values of the new column based on other property columns. This enables you to tailor the product information according to your specific requirements. 

Example:

You can create a custom column called “Product Title” that combines the values of both “Brand” and “Product Name.

Add a new custom property

  1. In Configure All Field Page
  2. Click on Add a custom property 
  • Mapping Options
      • Once you select the option to add a custom property column, you will be presented with mapping options.
      • Choose whether to map the new column to an existing property or let Unbxd PIM automatically create a new property.
  • Writing Scripts (Optional)
      • If you want to populate the values of the new column using other property columns, you can write a script.
      • Using the Python scripting language, you can define the logic for fetching and combining values from different properties.
  • Configuring Properties
    • After adding the custom property, you can continue configuring other properties and their respective mappings.

Remove a new custom column

  1. If, for any reason, you need to remove the newly added custom column,
  2. Click on the “Skip Property” option.

 

Now, let us get back to configuring properties.

Mapping Properties

If you want to map the property to an existing property, in the Map to list, map the property to an existing property. If there is no mapping, it will automatically create a new property with the same name.  For example, you can map the new property “Product Name” to an existing property “Title”. The property “Title” is created via the Property section. For more information about creating a new property, see Creating a New Property.

Performing Data Transformations in Unbxd PIM

In Unbxd PIM, you have the flexibility to perform data transformations on your product information. This allows you to modify and manipulate the content before it is ingested into the PIM system. 

There are two ways to perform data transformations: 

    1. Code View
        1. On the “Configure all fields” page, locate the property for which you want to add a transformation script.
        2. Click on the “+ Add Transformation” button for that property.
        3. By default, you will be in the tool view. Switch to the code view by clicking on the code view confirmation tab.
        4. In the code view, you can write Python scripts to perform the desired data transformations.
        5. Once you have added the code, click on “Preview Output” to see the transformed data.
        6. If the preview output is as expected, the “Save Transformation” option will be enabled. Click on it to save the transformation script.
    2. Tool View
        1. On the “Configure all fields” page, click on the “+ Add Transformation” button for the property you want to modify.
        2. By default, you will be in the tool view.
        3. The tool view provides a range of operations you can select for data transformation.
        4. Select the desired operation from the “Select Operation” list based on your requirements.
        5. Depending on the selected operation, enter the necessary values in the provided fields.
        6. If you want to combine multiple operations, click on “Add another operation” and repeat the steps.
        7. To view sample values for a property, click on “Show sample values” and select the property.

Once you have configured the transformation, click on “Save” to save the changes.

Operations Sample Scenario Steps
Text Rules
Copy Populate the “Long Description” property with the content from the “Short Description” property for all products in your product catalog
  1. In the Select Operation list, select Copy.
  2. In the Properties dropdown list select the property from which you want to copy the value
Set Automate the process of setting the brand name for products in your Unbxd PIM product catalog
  1. In the Select Operation list, select Set.
  2. In the Value text boxenter the value which you want to set for the property
Replace Replace all occurrences of “Crimson” for the property “Color” with “Red”
  1. In the Select Operation list, select Replace.
  2. In the Replace Value box, type the property value you want to replace.
  3. In the Replace With box, type the new value.
Join Join two properties “ Brand” and “Product Name” using the joining value “-”
  1. In the Select Operation list, select Join.
  2. In the Join by Value box, type the character you want to use to join the the two property values.
  3. In the Property box, select the second property.
Prefix Prefix (add something at the beginning) US currency “$” for the property “Price”
  1. In the Select Operation list, select Prefix.
  2. In the Prefix With box, type the character you want to add before the property value.
Suffix Suffix (add something at the end) registered trademark to the values of the property “Product Name”
  1. In the Select Operation list, select Suffix.
  2. In the SuffixWith box, type the character you want to add after the property value.
Split & pick Split the property “Image URL” and pick the image name

Example:
https://xyz.shopc.com/LCProdThumb/17/4/174833handbag.jpg

Split the image url with “/” and pick the image name “174833handbag.jpg”

When you specify the “split by” value as “/” and the “pick position” value as “6”, and execute the script, the url first splits into the following:
– https: (Position 0)
– Empty space (Position 1)
– xyz.shopc.com (Position 2)
– LCProdThumb (Position 3)
– 17 (Position 4)
– 4 (Position 5)
– 174833handbag.jpg (Position 6)

The result will be 174833handbag.jpg

  1. In the Select Operation list, select Split and Pick.
  2. In the Split by box, enter the character using which you want to split property value.
  3. In the Pick item at position box, enter the position number using which you want to pick the specific part of the property value.
Remove HTML You have a product catalog in Unbxd PIM that includes a property called “Product Description.” However, some of the product descriptions contain HTML tags, such as

, , or . To present the product information in a more readable format and remove the HTML tags, you can use the Remove HTML Tag operation.

  1. In the Select Operation list, select Remove HTML.
Remove special character You have a product catalog in Unbxd PIM that includes a property called “Product Name.” However, some of the product names contain special characters such as symbols or punctuation marks. To ensure consistency and improve data quality, you want to remove these special characters from the product names using the Remove Special Character operation.
  1. In the Select Operation list, select Remove special character.
Generate Partial Search You have a product catalog in Unbxd PIM with a property called “Product Name.” To improve search accuracy and provide better search results to users, you want to generate partial search terms based on the product names. This will enable users to find products even if they enter a partial or incomplete search query.
  1. In the Select Operation list, select Generate Partial Search.
Lower Case You have a product catalog in Unbxd PIM that includes a property called “Product Title.” However, the product titles are inconsistently formatted, with some in uppercase, others in title case, and some in lowercase. To ensure uniformity and improve the overall presentation, you want to convert all product titles to lowercase using the Lowercase operation.
  1. In the Select Operation list, select Lower Case.
Upper case You have a product catalog in Unbxd PIM that includes a property called “Product Name.” However, the product names are inconsistently formatted, with some in lowercase, others in title case, and some in uppercase. To ensure uniformity and improve the overall presentation, you want to convert all product names to uppercase using the Uppercase operation.
  1. In the Select Operation list, select Upper Case.
Title Case You have a product catalog in Unbxd PIM that includes a property called “Product Description.” However, the product descriptions are inconsistently formatted, with some in uppercase, others in lowercase, and some in mixed case. To ensure uniformity and improve the overall presentation, you want to convert all product descriptions to title case using the Title Case operation.
  1. In the Select Operation list, select Title Case.
Capitalize You have a product catalog in Unbxd PIM that includes a property called “Product Category.” However, the category names are inconsistently formatted, with some in lowercase, others in uppercase, and some in mixed case. To ensure uniformity and improve the overall presentation, you want to capitalize the first letter of each word in the category names using the Capitalize operation.
  1. In the Select Operation list, select Capitalize.
Zero Pad You have a product catalog in Unbxd PIM that includes a property called “Product Code.” The product codes are numeric values, but some of them have inconsistent lengths. To standardize the formatting and ensure a consistent number of digits, you want to add leading zeros to the product codes using the Zero Pad operation.
  1. In the Select Operation list, select Zero Pad.
Number Rules
Addition Add two numerical property values for properties “ Base Price” and “Delivery Charges”. That is,

Actual price = Base price + Delivery charges

  1. In the Select Operation list, select Addition.
  2. In the Property box,  select the property you want to use for addition.
  3. To include multiple properties for addition, click  .
Subtraction Subtract two numerical property values for properties “ Actual Price” and “Discounted Price”. That is, Offer Price= Actual Price- Discount Price
  1. In the Select Operation list, select Subtraction.
  2. In the Property box,  select the property you want to use for subtraction.
  3. To include multiple properties for subtraction, click  .
Multiplication Multiply two numerical property values for properties “Number of Units” and “Price per Unit”. That is, Total Price = “Number of Units” * “Price per Unit”
  1. In the Select Operation list, select Multiplication.
  2. In the Property box,  select the property you want to use for multiplication.
  3. To include multiple properties for multiplication, click  .
Division Divide two numerical property values for properties “Total Weight of the Products”  and “Total Weight of the Carton”. That is, Per Unit Weight = Total Weight of the Products / Total Weight of the Carton
  1. In the Select Operation list, select Division.
  2. In the Property box,  select the property you want to use for division.
  3. To include multiple properties for division, click  .
Add number value Product catalog in Unbxd PIM includes a property called “Price.” However,to increase all product prices by a specific value, such as a discount or tax percentage. To automate this calculation and update the prices accordingly,use the Add Number Value operation.
  1. In the Select Operation list, select Add number value.
  2. In the Text box,Enter the value by which you want to add on .
  3. To include multiple properties for Add number values, click  .
Substract number value Product catalog in Unbxd PIM includes a property called “Price.” However, to increase all product prices by a specific value, such as a discount or tax percentage. To automate this calculation and update the prices accordingly, you can use the Add Number Value operation.
  1. In the Select Operation list, select Substract number value.
  2. In the Text box,Enter the value by which you want substract .
  3. To include multiple properties for Substract number values, click  .
Multiply number value Product catalog in Unbxd PIM includes a property called “Unit Price.” However, you want to adjust the prices based on a specific factor, such as a markup or discount percentage. To automate this calculation and update the prices accordingly, you can use the Multiply Number Value operation.
  1. In the Select Operation list, select Multiply number value.
  2. In the Text box,Enter the value by which you want multiply the value.
  3. To include multiple properties for Multiply number values, click  .
Divide number value Product catalog in Unbxd PIM includes a property called “Unit Price.” However, you want to adjust the prices based on a specific factor, such as a markup or discount percentage. To automate this calculation and update the prices accordingly, you can use the Divide Number Value operation.
  1. In the Select Operation list, select Divide number value.
  2. In the Text box,Enter the value by which you want divide the value.
  3. To include multiple properties for Divide number values, click  .
Percentage Get % portion of a particular property value. That is,

Offer Price= 80% of Actual Price

  1. In the Select Operation list, select Percentage.
  2. In the Percentage portion box, enter the percentage value.
Convert Integer to float Product catalog in Unbxd PIM includes a property called “Weight.” However, the weight values are currently stored as integers, representing whole numbers. To provide more precise weight information, convert the integer values to floating-point numbers.
  1. In the Select Operation list, select Convert Integer to float.
Ceil If a product has an average rating of 3.7, applying the Ceiling operation with zero decimal places will round it up to 4. Similarly, if another product has an average rating of 2.2, it will also be rounded up to 3
  1. In the Select Operation list, select Ceiling.
Convert float to integer You have a product catalog in Unbxd PIM that includes a property called “Quantity.” The quantity values are currently stored as floating-point numbers, but you want to represent them as whole numbers without decimal places for consistency and simplicity. To achieve this, you can use the Convert Float to Integer operation.
  1. In the Select Operation list, select Convert Integer to float.
Round off Round off the property values of a property “Weight” upto two decimal places

That is, the value 114.7261 will become 114.73

  1. In the Select Operation list, select Round off.
  2. In the Round off to box, enter the value for the decimal places.
Import Utility Rules
Merge Product data coming from multiple sources, each containing specific information about the products. To create a unified view of the products and consolidate the data,use the Merge operation within an Import Utility rule.
  1. In the Select Operation list, select Merge.
  2. In the Property box, select the property to merge.
DeDuplicate You have an import file containing product data from different sources, and there might be instances where duplicate products exist with slightly different information. To streamline your product catalog and avoid duplicates, you can use the De-duplicate operation within an Import Utility rule.
  1. In the Select Operation list, select DeDuplicate/strong>.
  2. In the UID key box, enter the value
  3. Select the property from the property list
      1. If you want to combine another operation with the previous operation, click Add another operation.
      2. If you want to copy the automatically generated code, click Copy Code.
      3. If you want to preview the output of your code, click Preview Output.
      4. Click Save.

For more information about transformation scripts, see Working with Transformation Scripts.

Append or Overwrite the New Values

In the Unbxd PIM system, you have the flexibility to choose how new data is handled for a property using the “Append” or “Overwrite” option. This allows you to customize the behavior when updating properties in your product catalog. Here are two examples illustrating the Append and Overwrite options:

Append Example: Property: “Product Features” Existing Value: “Waterproof, Lightweight” New Value: “Durable” Append Option: Selected

Result: After applying the Append function, the updated “Product Features” property will be “Waterproof, Lightweight, Durable”. The new value “Durable” is appended to the existing features, maintaining the previous values.

Overwrite Example: Property: “Product Features” Existing Value: “Wireless, Noise-cancelling” New Value: (No value provided) Append Option: Not selected (Overwrite option is chosen)

Result: The existing value “Wireless, Noise-cancelling” is completely overwritten with an empty value. The updated “Product Features” property will be an empty field, as the new value is not provided.

Ignore or Overwrite Empty Values

In the Unbxd PIM system, you have the flexibility to choose how empty or missing data is handled for a property using the “Ignore” or “Overwrite” options.

Ignore

When you select the “Ignore” option, the system will keep the field or attribute blank if no data is provided. This means that if there is missing information, the field will not be populated with any default or placeholder value. The product information will be saved as is, with the missing data, allowing you to keep track of properties that have missing values. 

This option is suitable when the property is not essential or required for the product, and you want to maintain visibility of the missing data.

Example: If you select the “Ignore” option for the “Product Weight” property, the system will keep the field blank if no weight information is provided for a product in the import file. This allows you to maintain the visibility of products with missing weight data. For example, if the file includes products A, B, and C, but only products A and B have weight values, the “Product Weight” field for product C will be empty. This option is suitable when the weight is not essential for all products and you want to track which products have missing weight information.

Overwrite

Selecting the “Overwrite” option instructs the system to replace any existing data in the field or attribute with an empty value if no data is provided during import or update. This ensures the field is cleared of any previous data and saved as an empty value.

It is useful when you want to enforce completeness and ensure that all properties are kept up-to-date. This option is typically chosen for properties that are essential for the product and should not have any missing values.

In Unbxd PIM, the data types for product properties are automatically detected during the import process based on the uploaded file. However, you have the flexibility to change the data type for each property when importing the file for the first time.

Example: Overwrite Option: On the other hand, if you select the “Overwrite” option for the “Product Color” property, the system will replace any existing color data with an empty value if no color information is provided during import. This ensures that the “Product Color” field is cleared of any previous data. For example, if the file includes products X, Y, and Z, and only product Y has a color value, the “Product Color” field for products X and Z will be overwritten and saved as an empty value. This option is useful when you want to enforce completeness and ensure that all products have up-to-date color information.

Set the data type for a specific property

  1. On the import configuration page, locate the property for which you want to set the data type.
  2. In the “Data Type” column, you will find a dropdown list. Click on the dropdown to view the available data types.
  3. Select the appropriate data type from the list.
    • Text: Used for alphanumeric text values, such as product names or descriptions.   
    • Number: Used for numerical values, such as prices or quantities.
    • Date: Used for date values, such as release dates or expiration dates.
    • Link: Used for hyperlink values, such as URLs or product links.
    • Boolean: Used for boolean values, representing true or false.
    • File: Used for file attachments, such as product manuals or specifications.
    • Image: Specifically for image files, allowing you to associate product images.
    • Tree/List: Used for hierarchical or list-based structures, enabling you to define categories or variations.
    • Text Area: Used for larger text content, such as detailed descriptions or notes.
      1. If you prefer, you can also filter for a specific data type using the Data Type filter.
      2. Once you have selected the desired data type, it will be assigned to the property.                                                                                                                                                 
      3. For more information on property data types, see Property Data Types.

 

Making a Property Searchable

If you want to make a property searchable, select Searchable in PIM check box.

Note: By default, properties equivalent to product id and product name are set as searchable.

Once a property is made searchable, you can search for its values in the Products Listing page. For example, post the import, there are products with the  “3900” in the Price. Searching for the same in the Products Listing page gave the following results:

Property with Multiple Values

When dealing with a property with multiple values in a specific column of your import file, Unbxd PIM provides a feature to handle this scenario effectively. Here’s how you can handle properties with multiple values:

      1. During the import process, locate the column that contains the property with multiple values.
      2. Select the “Is multivalued” checkbox for that column.
      3. Enter the separator that separates the multiple values within the column. This separator can be any character or string that you specify.
      4. Proceed with the import process.

By enabling the “Is multivalued” option and specifying the separator, Unbxd PIM recognizes that the property in that column can have multiple values. The values will be split based on the specified separator, and each value will be treated as a separate value for that property.

Example:

 Let’s say you have a column named “Tags” that contains multiple tags separated by commas. If you enable the “Have multivalued separator” option and specify the comma (“,”) as the separator, Unbxd PIM will import each tag as a separate value for the “Tags” property. This allows you to manage and search for individual tags within the PIM system.

 

Confirmation before Import

After completing the mapping and property configurations in Unbxd PIM, you can proceed to import your data by clicking the “Save & Import” button. Upon clicking, a confirmation window will appear, summarizing the changes you have made.

In the confirmation window, you can review the changes you have made to ensure they are accurate and as intended. This allows you to verify the mapping of properties, the configured transformations, and any other modifications made before proceeding with the import.


Identify errors in mapping and configurations

If there are any issues or errors with the mapping or configurations, you can easily identify them by clicking on the magnifying glass icon. It will take you directly to the specific property or field that requires attention. 

This helps in quickly identifying and resolving any mapping or configuration errors before proceeding with the import.

Step 3: Creation of Import Template

To save the mapping and configurations as an import template, you can select the checkbox provided on the confirmation window. By doing so, the system will save the current mapping and configurations as a template that can be accessed and used later.

After a successful import, you can view the import status.

Once you are done with the product import, you can find the updated products and properties in the following pages:

      • Properties Listing page
      • Products Listing page

Yes No
0 of 0 users found this section helpful
Suggest Edit