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