Help Documentation

Structured information to guide you through Unbxd PIM with minimal assistance
  1. Introduction
  2. Access Unbxd PIM
  3. Unbxd PIM Nomenclature
  4. Explore Unbxd PIM
  5. Your Profile
  6. Unbxd PIM Info Mode
  7. Organization - Set up your PIM Team
    1. Invite a New Member
    2. Change Member Name and Assigned Roles
    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
  8. 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. View an Existing Import Information
    5. Schedule an Import
    6. Edit a Scheduled Import
    7. View a Scheduled Import Information
    8. Stop a Scheduled Import
    9. Delete a Scheduled Import
    10. Import Adapters
  9. Products - Build & Enrich Product Content
    1. Advanced Search and Filtering
    2. Customize your Product Listing View
    3. Add a Solo Product
    4. Add a Variant Product
    5. Edit a Solo Product
    6. Edit a Parent Product
    7. Edit a Variant Product from Product Listing
    8. Edit a Variant Product from its Parent Product
    9. Edit Mode
    10. View Activity Log Details for a Product
    11. View Product Details
    12. View Task Information for a Product
    13. Delete a Product
    14. 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
    15. Bulk Actions for Products & Product Groups
      1. Add Products to a Static Product Group
      2. Edit Multiple Products
      3. Assign Categories for Multiple Products
      4. Create Task for Multiple Products
      5. Certify Products for Network
      6. Delete Multiple Products
      7. Certify Product Groups to Network
      8. Delete Product Groups
      9. Edit Multiple Products from a Static Product Group
      10. Remove Products from a Static Product Group
      11. Delete Products from a Static Product Group
      12. Edit Multiple Products from a Dynamic Product Group
      13. Delete Products from a Dynamic Product Group
  10. 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
  11. 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
  12. Assets - Manage your Digital Files
    1. Add a New Asset
    2. Associate Assets with Products
    3. Perform Asset Transformations
    4. Disassociate Asset from Products
    5. Download Assets
    6. Delete an Asset
  13. Tasks - First Step Towards Building Processes
    1. Create a New Task
    2. Edit an Existing Task
    3. Stop a Task
    4. View Task Details and Task Status Details
    5. 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
    6. Task Assignee
  14. Catalogs - Share real-time Product Content
    1. Create & Share a New Catalog
    2. Edit a Catalog
    3. View a Catalog Information
    4. Delete a Catalog
  15. Network - Partner Readiness & Content Distribution
    1. Certified Products & Product Labels
      1. Customize your Network Products Listing View
      2. Export Certified Products
      3. Export Products with Readiness Check & Assign Task
      4. View Activity Log Details for a Network Product
      5. Delete Products from Network
      6. Export Certified Product Labels
      7. Export Product Labels with Readiness Check & Assign Task
      8. Add Partner Readiness for a Product Label
      9. Edit a Product Label
      10. View Certified Products
      11. Delete a Product Label
    2. Partners
      1. Create a Partner
      2. Edit a Partner
      3. View Partner Details
      4. Delete a Partner
    3. System Adapters & Custom Adapters
      1. Edit a System Adapter
      2. View System Adapter Details
      3. Create a Custom Adapter
      4. Edit a Custom Adapter
      5. View Custom Adapter Details
      6. Delete a Custom Adapter
    4. 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. Stop a Scheduled Export
      8. Delete a Scheduled Export
  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. Scripts - Transform your Product Data
    1. Using the Transformation Script Editor
    2. List of Transformation Scripts
  18. Channel Integration
    1. Channel Integrations -
      1. Installing Unbxd PIM via BigCommerce
      2. Installing BigCommerce store via Unbxd PIM
      3. Importing Data from BigCommerce to Unbxd PIM (via BigCommerce)
      4. Sending Data from BigCommerce to Unbxd PIM (Subsequent Transfer)
      5. Getting Data from BigCommerce via Unbxd PIM
      6. Getting Data into BigCommerce from Unbxd PIM
      7. Sending Data to BigCommerce via Unbxd PIM
      8. Importing data into Unbxd PIM from BigCommerce
      9. Exporting data from Unbxd PIM to BigCommerce
      10. Automating import and export using Adapters and Workflows
    2. 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 Adapters and Workflows

Using the Transformation Script Editor

Transformation script editor supports the following views:

  • Code View – This is where you write the script for data transformations
  • Tool View – This is where you can select a wide range of operations and automatically perform data transformations without writing any scripts. In this case, the python scripts are automatically generated.

To write scripts to perform data transformations (via Code view):

  1. Click Script.
  2. Click Edit Script.
  3. Click Code View.
  4. Enter the code.
  5. If you want to preview the output of your code, click Preview Output.
  6. Click Save.

To automatically perform data transformations (via Tool view):

  1. Click Script.
  2. Click Edit Script.
  3. Click Tool View.
    The Property list displays all the available product properties.
  4. If you want to view the sample values of a property, click Show sample values.
    The sample values appears on the right side of the window. If you want to view sample values for other properties from here, select another property, and then click .
  5. In the Select Operation list, select an operation for the data transformation. The operations are:
    Operations Sample Scenario Steps
    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.
    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  .
    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.
    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.
  6. If you want to combine another operation with the previous operation, click Add another operation.
  7. If you want to copy the automatically generated code, click Copy Code.
  8. If you want to preview the output of your code, click Preview Output.
  9. Click Save.
Yes No
0 of 0 users found this section helpful
« Scripts - Transform your Product DataList of Transformation Scripts »
Suggest Edit