Kornit X Product Manager - Excel Import and Export

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 not advised and may lead to undesirable results due to the connection they have with Blank products.
The Excel import only supports .xlsx spreadsheet files.

CRITICAL: When updating products, it is recommended that you first export the products. Manually constructing an import for products that already exist in the system is error prone and may result in products being updated incorrectly. We also recommend saving a version before updating the import to ensure you can update the products back to how they were in case of error. 
Each spreadsheet will have the following tabs:
Name
Description
products
Product information (mandatory)
attributes
Product attributes
aspect_options
Product aspects and aspect options
print_areas
Product print areas
text_areas
Product text areas
image_areas
Product image areas

The "products" Tab

Column Name
Description
product.id
The ID of the product to be updated (use unique non numeric string to create a new product)
product.name
Product name
product.space
Currently only "2D" is supported
product.productCode
Supplier SKU
product.retail_sku
Retailer SKU
product.supplier_company_ref_id
Supplier company reference ID
product.type
Product type
product.categories
ID of the category to create the product in (new products only)

The "attributes" Tab

When updating a product, any attributes for that product that aren't specified in the attributes tab will be deleted from Product Manager.

Column Name
Description
product.id
Product ID (corresponds to product.id on the products tab)
attribute.name
Name of the attribute to update (if a matching attribute doesn't exist then a new attribute will be created)
attribute.value
Attribute value

The "aspect_options" Tab

When updating a product, any aspects and aspect options for that product that aren't specified in the aspect_options tab will be deleted from Product Manager.

Column Name
Description
product.id
Product ID (corresponds to product.id on the products tab)
aspect.name
Name of the aspect to update (if a matching aspect doesn't exist then a new aspect will be created)
aspect.width
Width of all images for relevant aspect options
aspect.height
Height of all images for relevant aspect options
aspect_option.name
Name of the aspect option to update (if a matching aspect option doesn't exist then a new aspect option will be created)
aspect_option.main_url
URL of the aspect option's main image
aspect_option.mask_url
URL of the aspect option's mask image

The "print_areas" Tab

When updating a product, any print areas for that product that aren't specified in the print_areas tab will be deleted from Product Manager.
Column Name
Description
product.id
Product ID (corresponds to product.id on the products tab)
aspect.name
Name of the aspect that the print area belongs to
print_area.name
Name of the print area to update (if a matching print area doesn't exist then a new print area will be created)
print_area.x
X co-ordinate (relative to top left of aspect image)
print_area.y
Y co-ordinate (relative to top left of aspect image)
print_area.width
Width of print area (relative to aspect image)
print_area.height
Height of print area (relative to aspect image)
print_area.print_width
Print width (mm)
print_area.print_height
Print height (mm)

The "text_areas" Tab

When updating a product, any text areas for that product that aren't specified in the text_areas tab will be deleted from Product Manager.

Column Name
Description
product.id
Product ID (corresponds to product.id on the products tab)
print_area.name
Name of the print area that the text area belongs to
text_area.name
Name of the text area to update (if a matching text area doesn't exist then a new text area will be created)
text_area.x
X co-ordinate (relative to top left of aspect image)
text_area.y
Y co-ordinate (relative to top left of aspect image)
text_area.size
Default font size
text_area.fill_colour
Default fill colour
text_area.stroke_colour
Default stroke colour
text_area.stroke_width
Default stroke width
text_area.font_id
Default font
text_area.allow_rotate
Can the text be rotated?
text_area.allow_move
Can the text be moved?
text_area.allow_input
Can the text be changed by the user?

The "image_areas" Tab

When updating a product, any image areas for that product that aren't specified in the image_areas tab will be deleted from Product Manager.

Column Name
Description
product.id
Product ID (corresponds to product.id on the products tab)
print_area.name
Name of the print area that the image area belongs to
image_area.name
Name of the image area to update (if a matching image area doesn't exist then a new image area will be created)
image_area.x
X co-ordinate (relative to top left of aspect image)
image_area.y
Y co-ordinate (relative to top left of aspect image)
image_area.width
Width (relative to aspect image)
image_area.height
Height (relative to aspect image)

The "ecommerce" Fields

When updating a product, any eCommerce data for that product that isn't specified in the ecommerce tab will be deleted from Product Manager.
For eCommerce we can import product descriptions, lead time, manufacturers code, weight, tax code, tax rate, notes and shipping carrier to highlight the main options. 

Using The Import As A Product Creation Solution

The Excel import can be used as a viable solution for the creation of Simple Blank Products. Attached is an example of a simple 2D T-Shirt product which can be downloaded and imported straight into the system to create a simple product featuring different aspects, attributes, print areas, image and text areas. Users just need to add their fulfiller company ID to the "product.supplier_company_ref_id" field on the products tab.
Non-numerical IDs need to be used for the creation of products. As an example "abcdefgh" can be used for every relating tab of the sheet users must match otherwise the import will fail.

    • Related Articles

    • Blank Products | Using Fulfiller Blanks With Product Manager

      Overview The Catalog section of the Kornit X platform houses thousands of Fulfillers approved products that have been configured to meet their exact print specification. This opens doors of opportunity, as it means that these products can be added to ...
    • Product Creation Services | Blank Products - Production Spreadsheet

      What information do we request and why? Before we can begin production of your Blank products we will contact you to ask for image assets and also setup information / data. We have a predefined Production Spreadsheet that you will be asked to ...
    • Catalog | Product Manager - Product Classification

      What Is The Product Classification? Within platform you now have the ability to set a product classification against your items, this is found within the eCommerce export and can be used as a search term within "Product Manager" and "Feeds". Where ...
    • Product Manager | Updates

      Introduction As part of all products within Catalog > Product Manager there is an option to add updates to products. For example, if a blank product has had a range of new aspect option colours or print sizes added there will be a history audit trial ...
    • CSV Order Import Breakdown

      The following article has been split out from the existing Generic FIlesystem article to show users how to use a CSV format to import textual orders into Order Manager found within the Sales module of the Kornit X Platform. For information on setting ...