How to reformat categories, date attributes, decimal attributes, boolean attributes, and relationships when exporting from Channels, Brand Portals and Product sheets
Although you maintain information in Plytix in the way that is best for your business, you may need to change the way this information looks when you export it to share with others. Attributes that can be adjusted for sharing will display a "Settings" icon like this when you hover over them:
*Skip to any section in this article by clicking on the links above
💡 If you want to change the format of an attribute that is not mentioned in this article, you may be able to use a computed attribute to change it.
ℹ️ If you want to change the format of an asset, check our our article Defining the Export Settings for Media Attributes.
Defining the Output Format for Categories
It can be useful to change the formatting of your categories when you maintain categories in multiple languages, or you sell to different platforms, each with their own set of requirements. When exporting the "Categories" attribute, you have control over:
- the hierarchy separator - default is the greater than sign (>) but can be any character
- the category path - choose from "Full Path," "Exclude First" or "Last Child"
- the selected category tree - any category or subcategory in your account. Choosing a subcategory will create a blank output for products not in that category.
Defining the Output Format for Date
Because dates are often written differently depending on region, preference or context, there are many way you may choose to display the date when exporting a date attribute. By creating a combination of the tokens below, you can create a wide array of different time/day/month/year formats:
ℹ️ For information about how to format dates for import and export, check out our article on Configuring a Date Attribute.
Defining the Output Format for Decimals
When exporting a decimal attribute, for example the price of a product, you have options to define:
- the decimal separator - Dot (.) or Comma (,)
- the level of precision for the decimal - For example "1.5," "1.50," "1.502," etc.
💡 If you want to leave the number of decimal digits unlimited, simply leave the "Precision" value blank.
Defining the Output Format for Booleans
When exporting a boolean attribute, you have the option to change the values that appear for true and false values. Some examples of values that could be used instead of "true" and "false" include:
- "Yes" and "No"
- "Y" and "N"
- "T" and "F"
Defining the Output Format for Relationships
When exporting relationships, you may want to export only the related product(s), or you may want to include a quantity if your products are related to each other in a ratio other than 1:1. You can add, remove, and reorder the format for this export by dragging and dropping:
- Identifier - default "SKU"
- Quantity Separator - default "#"
Your product is a double bed. This product is assigned a relationship called "Suggested Products" which includes products that compliment this bed like pillows, sheets, and headboards. When exporting this relationship, the "Suggested Products" related to the bed will appear as follows:
- Learn about creating and managing product categories
- Learn how to define export settings for media attributes
- Learn how to define the format for images upon export
If you have any questions just click on the chat box in the bottom-right corner and we'll be happy to answer them...
and please let us know 👇