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 Attribute Permissions for a Role
    7. Set System Permissions for a Role
    8. Change Assigned Members of a Role
    9. Change Attribute 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. Variant options during Import
    5. Import data via SFTP
    6. View an Existing Import Information
    7. Schedule an Import
    8. Edit a Scheduled Import
    9. View a Scheduled Import Information
    10. Stop a Scheduled Import
    11. Delete a Scheduled Import
    12. Import Templates
    13. Deleting Import Template
    14. 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 [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. Assigning Category to a Parent Product
    16. Create and View task from PDP Page
    17. View Task Information from Product Display Page
    18. One Click Export
    19. Delete a Product from Product Listing Page
    20. Delete Product from Product Display Page
    21. 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
    22. 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
      16. Searching Product Group
  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. Attributes - Manage your Product Characteristics
    1. Attribute Data Types
    2. Create a New Attribute
    3. Change the Attribute Name and Assigned Attribute Group
    4. Change Role Permissions for a Attribute
    5. Make a Attribute Searchable
    6. View a Attribute Information
    7. Bulk Upload Attributes using an sheet
    8. Download all Attributes
    9. Arranging attribute and attribute groups in your preferred order
    10. Delete a Attribute
    11. Attribute Groups
      1. Create a New Attribute Group
      2. Change Attribute Group Name and Associated Attributes
      3. View a Attribute Group Information
      4. Delete a Attribute Group
  12. Categories - Manage your Product Classifications
    1. Bulk create category & subcategory
    2. Change Category Name & Associated Attributes
    3. View Category & Subcategory Information
    4. Delete a Category or Subcategory
    5. Bulk Remove Categories
    6. Upload Category Attributes Association
    7. Download Category Attribute Association
    8. Download Category Attribute Template
    9. Download All Categories
    10. Filter out Categories
  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 attributes 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 Attributes 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 Attributes
  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. Viewing Credentials for an Installed App
    2. Channel Integrations -
      1. Installing BigCommerce store via Unbxd PIM
      2. BigCommerce Setup via BigCommerce App
      3. Importing data into Unbxd PIM from BigCommerce
      4. Mandatory Attributes to export products to BigCommerce
      5. Exporting data from Unbxd PIM to BigCommerce
      6. Automating import and export using Templates and Workflows
    3. Channel Intergation-
      1. Installing Shopify via Unbxd PIM
      2. Shopify Store Fetcher
      3. Mandatory Attribute Mappings for Shopify
      4. Attributes 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
      8. Increasing the Threshold in Shopify Exports
      9. 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 Attributes for Magento
      4. Mageworx
    6. Channel Intergation-
      1. Installing Etsy via Unbxd PIM
      2. Importing the data into Unbxd PIM from Etsy
      3. Mandatory Attributes required to list products on Etsy
      4. Exporting data from Unbxd PIM to Etsy
      5. 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-
      1. Steps to get template file for Ebay-
    10. Woocommerce Installation-
      1. Google Shopping -
        1. Google Shopping App Installation
        2. Mandatory Attributes for Google Shopping
    11. ERP - Enterprise Resource Planning
      1. How to get Netsuite Account Details
  46. Download Products directly from Product Listing Page

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 attributes.

Note: If you have no file to import, you can start by creating product attributes. For more information, see Attributes. 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 attributes 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 attributes 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 attributes are tagged NEW. You can now start mapping the product attributes so that Unbxd PIM interprets your product information accurately before the actual import. Here, you can also map the product attributes as a new attribute or map to an existing attribute.

Perform These Mandatory steps before starting the actual import

  • Map your important PIM attribute
  • Configure your attributes.

Steps 1: Map the important PIM attributes

  1. (mandatory) In the list, select your attribute that is equivalent to a product ID.
  2. (mandatory) Select your attribute that is equivalent to a product name.
  3. In the list, select your attribute that is equivalent to a product image.
  4. If you have a parent ID for your products in the list, select the attribute that is equivalent to a parent id.
  5. If parent_id is coming from file then you will get another attribute mapping option for variant options select it if you do not have the variant attribute option but you want to create click on Configure All Fields Create an attribute name it similar to variant option click on add transformation and select set and add the attributes based on which you will create variants (example: Color and Size) click on save as draft and go back to map essential page and map that attribute.
  6. If you have categories for your products, in the list, select the attribute that defines your category structure. Once you map a attribute as “Category,” the attribute will automatically set its data type to “Tree/List.
  7. To configure these attributes, 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 attribute from your import file with the unique attribute 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 attribute other than the actual product ID, map them below to the respective PIM attribute (data from past imports) to ensure easy data transfer during imports. Map unique file attributes with unique PIM attributes 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 Attributes

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

To view the newly created attributes 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 attributes that have been detected from the uploaded data. Each attribute will be displayed along with its corresponding data type.
    3. Look for the attributes that have been newly created during the import process. These attributes will be tagged as “New.”
    4. For the newly created attributes, 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 attribute.
    5. Click on Save & Import

Step 2:Configuring Attributes

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

Here are the available configurations:

  • Map to an Existing Attribute or Create a New Attribute
      • You can choose to map a new attribute to an existing attribute 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 attribute 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 attribute 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 attribute to ensure data consistency and accurate handling.
  • Making a Attribute Searchable in PIM:
      • You have the option to make a attribute searchable within the PIM system. By enabling this, you can search for values of that attribute in the Products Listing page.
      • By default, attributes equivalent to the product ID and product name are set as searchable.
  • Defining Multivalued Separators:
      • Suppose a attribute 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 attributes that have multiple attributes or options.

Adding a new attribute

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

Additionally, you can write scripts to populate the values of the new column based on other attributes 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 attribute

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

 

Now, let us get back to configuring attributes.

Mapping Attribute

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

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 attribute for which you want to add a transformation script.
        2. Click on the “+ Add Transformation” button for that attribute.
        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 attribute 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 propert, 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” attribute with the content from the “Short Description” attribute for all products in your product catalog
  1. In the Select Operation list, select Copy.
  2. In the Attributes dropdown list select the attribute 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 box enter the value which you want to set for the attribute
Replace Replace all occurrences of “Crimson” for the attribute “Color” with “Red”
  1. In the Select Operation list, select Replace.
  2. In the Replace Value box, type the attribute value you want to replace.
  3. In the Replace With box, type the new value.
Join Join two atttributes “ 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 attribute values.
  3. In the Attribute box, select the second attribute.
Prefix Prefix (add something at the beginning) US currency “$” for the attribute “Price”
  1. In the Select Operation list, select Prefix.
  2. In the Prefix With box, type the character you want to add before the attribute value.
Suffix Suffix (add something at the end) registered trademark to the values of the attribute “Product Name”
  1. In the Select Operation list, select Suffix.
  2. In the SuffixWith box, type the character you want to add after the attribute value.
Split & pick Split the attribute “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 attribute value.
  3. In the Pick item at position box, enter the position number using which you want to pick the specific part of the attribute value.
Remove HTML You have a product catalog in Unbxd PIM that includes a attribute 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 attribute 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 attribute 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 attribute 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 attribute 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 attribute 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 attribute 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 attribute 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 attribute values for attributes “ Base Price” and “Delivery Charges”. That is,

Actual price = Base price + Delivery charges

  1. In the Select Operation list, select Addition.
  2. In the Attribute box,  select the attributes you want to use for addition.
  3. To include multiple attributes for addition, click  .
Subtraction Subtract two numerical attribute values for attributes “ Actual Price” and “Discounted Price”. That is, Offer Price= Actual Price- Discount Price
  1. In the Select Operation list, select Subtraction.
  2. In the Attribute box,  select the attribute you want to use for subtraction.
  3. To include multiple attributes for subtraction, click  .
Multiplication Multiply two numerical attribute values for attributes “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 Attributes box,  select the property you want to use for multiplication.
  3. To include multiple attributes for multiplication, click  .
Division Divide two numerical attribute values for attributes “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 Attributes box,  select the property you want to use for division.
  3. To include multiple attributes for division, click  .
Add number value Product catalog in Unbxd PIM includes a attribute 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 attributes for Add number values, click  .
Substract number value Product catalog in Unbxd PIM includes a attribute 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 attribute for Substract number values, click  .
Multiply number value Product catalog in Unbxd PIM includes a attribute 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 attributes for Multiply number values, click  .
Divide number value Product catalog in Unbxd PIM includes a attribute 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 attributes for Divide number values, click  .
Percentage Get % portion of a particular attribute 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 attribute 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 attribute 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 attribute values of a attribute “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 Attributes 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 attribute from the attribute 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 attribute using the “Append” or “Overwrite” option. This allows you to customize the behavior when updating attributes in your product catalog. Here are two examples illustrating the Append and Overwrite options:

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

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

Overwrite Example: Attributes: “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” attributes 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 attributes 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 attributes that have missing values. 

This option is suitable when the attribute 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” attribute, 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 attributes are kept up-to-date. This option is typically chosen for attributes that are essential for the product and should not have any missing values.

In Unbxd PIM, the data types for product attributes are automatically detected during the import process based on the uploaded file. However, you have the flexibility to change the data type for each attribute 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” attribute, 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 attribute

  1. On the import configuration page, locate the attribute 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 attribute.                                                                                                                                                 
      3. For more information on attribute data types, see Attribute Data Types.

 

Making a Attribute Searchable

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

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

Once a attribute 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:

Attribute with Multiple Values

When dealing with a attribute 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 attributes with multiple values:

      1. During the import process, locate the column that contains the attribute 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 attribute 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 attribute.

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” attribute. This allows you to manage and search for individual tags within the PIM system.

 

Confirmation before Import

After completing the mapping and attribute 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 attributes, 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 attribute 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 attributes in the following pages:

      • Attributes Listing page
      • Products Listing page

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