Defining Export Settings for Attributes

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:

Settings icon for attributes that can be reformatted upon export

Defining the Output Format for Categories

Defining the Output Format for Date

Defining the Output Format for Decimals

Defining the Output Format for Booleans

Defining the Output Format for Relationships

 

*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 CategoriesCategories have settings that let you change which categories are displayed and how they appear.

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 DateDate attributes can be reformatted for export in a variety of ways.

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:

Using different tokens to change the date format lets you customize it however you need to.

ℹī¸ 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 DecimalsUse the settings on a decimal attribute to change the way the decimal portion of the number appears.

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 BooleansThe settings of a boolean attribute can be adjusted to display different values for "true" and "false."

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 RelationshipsThe settings for relationships allow you to set which attribute identifies related products and include quantity if desired.

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 "#"
  • Quantity

For example:

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:

    • PillowSKU#2
    • SheetSetSKU#1
    • HeadboardSKU#1


What's next?

 

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 👇