Exports
      Back to home
      1. Help Center
      2. Sharing your data
      3. Exports

      Defining Export Settings for Attributes

      How to reformat categories, date attributes, decimal attributes, boolean attributes, and relationships when exporting from Channels and Brand Portals

      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 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.

      Categories have settings that let you change which categories are displayed and how they appear.

      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 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.

      decimal_settings

      💡 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"

      The settings of a boolean attribute can be adjusted to display different values for "true" and "false."

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

      The settings for relationships allow you to set which attribute identifies related products and include quantity if desired.

      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?

       

      Is there anything you were hoping to find in this article that is missing? Did this article answer the questions you had? Let us know in our Help Center feedback form! 🙌

       

      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 👇