Transformation Scripts
Transformation scripts in Unbxd PIM allow you to customize and manipulate product information to meet diverse endpoint requirements. These scripts are used during the import and export stages to perform data transformations and adhere to various data distribution standards.
Import Stage: In the import stage, transformation scripts can be applied to modify product data before it is imported into Unbxd PIM. For example, you can create a new property column by combining values from multiple existing properties. This can be done using a script that concatenates the “Brand” and “Product Name” properties into a new “Product Title” column.
To learn more about using transformation scripts in the import stage, refer to the “Writing Scripts for Data Transformation” section in the “Performing First-time Product Import.”
Export Stage: During the export or data distribution stage, transformation scripts can be utilized in both Custom Templates and Standard Templates. These scripts enable you to transform product content to meet the requirements of different endpoints.
By leveraging transformation scripts, you can distribute product data tailored to various endpoint specifications while having access to certified product information centralized in Unbxd PIM.
For detailed information on using transformation scripts in Standard Templates, refer to the Editing a Standard template To understand their usage in Custom Templates, refer to the Editing a Custom Template
Example Scenario: Consider a scenario where a retailer wants to combine the “Product Name” and “Brand” property values into the “Product Name” column.
Before data transformation:
Product Name | Brand |
hawaiian floral sneakers | Fashioz |
After data transformation:
Product Name | Brand |
Fashioz hawaiian floral sneakers | Fashioz |
For the scenario above, the data transformation script looks like:
resultant="".join(product["Brand"])+" " product["Product Name"]
Note: The transformation script uses the Python language because of its excellent readability and uncluttered simple-to-learn syntax.
If you have any trouble writing these scripts or understanding what would work best for your unique business use cases, please write to pim-support@unbxd.com.