KornitX Platform Imports & Exports - Attributes

KornitX Platform Imports & Exports - Attributes

What Is An Attribute?

An attribute acts as an option that can be added to a product set up, such as setting up sizes for garment products. CPP also offers to set these options internally, as separate order lines and group default. For example, if we had a T-Shirt with 5 sizes set, the product would need to have 5 attributes, set with the same group name (Size) and include the 5 size names (Extra Small, Small, Medium, Large, Extra Large) and associated SKUs (XS, S, M, L, XL). Attributes can be used to link to product variants, so to use this feature you will need to have encountered attributes.
Please refer to the attributes sets article if you need attributes to be applied to multiple products for production purposes - this is more for products one by one which details do not need to be copied. 
The attributes import must be imported as a CSV document. 
The below screenshot shows you how a product appears in the iFrame with attributes set up, the customer can select the size and add the product to their cart. 

Can I Set This Manually?

Yes, attributes can be set up manually on a product by editing the product and heading to the "Functionality" Section. Within this you can access the "Attributes" header which upon clicking will display any existing attributes which can be amended, as well as the ability to add an attribute with the red "Add Attribute" button on the left.

This is a perfectly viable option if you need to create attributes for a few products but we recommend that you use the export/import as this is a quicker process and allows for multiple attributes to be added to multiple products to be updated at once. 

Please note a virtual product will carry over and attributes set on a blank, meaning only the blank can be updated to change existing products. 

How Do I Set Up Attributes With The Import? 

The attributes import can be used to set the following options - Attribute Name, Attribute Value, Attribute SKU and Attribute Description.
You can also control whether the attributes are internal, enabled, set on a separate order line and the u display order.

To create new Attributes, the relevant Products should first be 'selected' or filtered in Product Manager prior to generating an Attribute Export.

The generated CSV file serves as a template, allowing the Product data to be added in a format that is then suitable for use with the Attribute Import to update the Products. 
It is recommended that Imports are tested on a sample range prior to rollout across a high volume of Products.

The CSV file contains all Attribute data for the selected Products under the following column headers;
  1. Attribute ID - Unique Attribute number (if existing)
  2. Attribute Name - The defined Group Name, eg 'Size'
  3. Attribute Value - The defined option, eg 'Medium'
  4. attribute.is_internal - Determines if the Attribute is selectable, or not
    1. A value of 1 indicates this is enabled, 0 means this is disabled
  5. attribute.is_enabled - Determines if the Attribute is functional, or not
    1. A value of 1 indicates this is enabled, 0 means this is disabled
  6. attribute.is_seperate_order_line
    1. A value of 1 indicates this is enabled, 0 means this is disabled
  7. attribute.ui_display_order - Changes the Attribute list order in the Smartlink
  8. Attribute SKU - The associated option SKU
  9. Attribute Description - Any added option details
  10. Attribute Spec - Any added specification details
  11. Product ID - Unique Product Number

The fields can then be populated based on the required options / settings.

Prior to import, the CSV must be formatted. If using OpenOffice or equivalent, save as .CSV and be sure to:
  1. Enable 'Edit the Filter Settings'
  2. Keep Current Format
  3. Change the character set to UNICODE (UTF-8)
  4. The saving delimeter needs to be ","
  5. Enable 'Quote all text cells'
The file can then be imported.

Can You Show Me This Import?

The following video runs through the process: from setting up our import, to importing and to finally seeing the generated attributes from manually checking a product to running the export

    • Related Articles

    • KornitX Platform Imports & Exports - ECommerce Data

      What Is eCommerce Data? Within CPP, your products can be set up with eCommerce data which can be downloaded within an export, updated with our import and generated in a feed to get products added to retailer sites and for many of our other ...
    • KornitX Platform Imports & Exports - Legacy Tier Prices

      What Is Legacy Tier Pricing Data? Legacy tier pricing data is the legacy import to use for adding pricing to products that exist in Platfornm. It is incredibly important for yourself and retailers that every product that you set up in CPP contains at ...
    • CPP | Getting Started Guide | Section 7: Exports & Feeds

      7.1 Accessing Exports, Imports, and Feeds You can access these by going into product manager and looking towards the bottom left of the screen.    7.2 Exports The Exports function allows you to export your product data to a csv to review and/or amend ...
    • Kornit X Product Manager - Excel Import and Export

      Introduction The Excel import and export to and from Product Manager is a powerful tool which allows for bulk Blank product updates, and also serves a potential option for creating simple Blank products. Note: Attempting to amend Virtual Products is ...
    • KornitX Platform Imports & Exports - Pricing Tier Groups

      What Is The Pricing Tier Groups Data? The pricing tier groups import is the more advanced pricing import accessible within the platform - it can be set Cost (Ex Tax), Trade (Ex Tax), Carriage Cost (Ex Tax), RRP (Inc Tax) and Retail (Inc Tax). Below ...