Once the product information becomes part of Unbxd PIM, it is ready to cater for your diverse and complex endpoint requirements. The endpoint requirements may vary from adding a simple trademark symbol to the brand name or a complicated operation of combining multiple property values into a new property column. This is where you can use transformation scripts to help you adhere to a multitude of data distribution standards. You can either write the script or automatically select operations to perform the necessary data transformations.
The transformation scripts are supported in the import stage and when the product is ready for distribution. For example, in the import stage, you can use scripts to create a property column, which would have the values of two distinct properties. That is, if the new property column is “Product Title”, the values can be a combination of the property column “Brand” and Product Name”.
For more information about using transformation scripts in the import stage, see Writing Scripts for Data Transformation section in Performing First-time Product Import.
During the export (data distribution) stage, the transformation script option is available in the Custom Adapters and System Adapters. With the certified product data available in one-central place, you can write data transformation scripts to distribute product content catering to various endpoint requirements.
For more information about using transformation scripts in the system adapter, see Editing a System Adapter.
For more information about using transformation scripts in the custom adapter, see Editing a Custom Adapter.
Here is another scenario where a retailer wants the combination of product property values of “Product Name” and “Brand” in the “Product Name” column.
Before data transformation:
|hawaiian floral sneakers||Fashioz|
After data transformation:
|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 email@example.com.