Skip to main content

How to import products and variants

Easily import new products and variants into Katana using comprehensive templates.

Dayvid Lorbiecke avatar
Written by Dayvid Lorbiecke
Updated over a week ago

Efficiently importing your products and their variants into Katana is crucial for accurate inventory management and streamlined operations. This guide provides step-by-step instructions for seamlessly adding new products and variants using Katana's import template.


Preparing your import file

Where the download template is located in katana for adding new products
  1. Download the import template:

    • Navigate to Settings > Data import > Add new products.

    • Click on Download template to obtain the Excel (.xlsx) file.

  2. Fill in the template:

    • Open the downloaded template.

    • Each row represents a product variant.

    • Use the Product name field to group variants under the same product.

    • Define variant attributes using Variant option 1, Variant value 1, etc.

    • Ensure all required fields are completed.

  3. Save the completed template:

    • After entering all necessary information, save the file in .xls or .xlsx format.


Importing the data into Katana

If you already have products and variants in Katana, the imported file will match by Variant code / SKU to avoid duplicating existing items (existing items will not be updated as matched items are skipped during import). To update existing products, use the Update existing products template.

Note: If you'd like to make changes to products in bulk, we recommend using the Update existing products template.

Upload your products to Katana
  1. Access the Data import section:

    • In Katana, go to Settings > Data import.

  2. Upload the completed template:

    • Under Add new products, click on Upload data.

    • Select your completed template file for upload.

  3. Review import results:

    • The import process may take a few minutes, depending on the number of items.

    • Upon completion, a message will indicate how many items were successfully imported.


Tips for a successful import

  • Ensure column headers match:

    • Column names in your template must exactly match those in the provided template.

    • Mismatched headers can lead to import failures or missing data.

  • Creating product variants:

    • To create variants, use the same Product name for each variant row.

    • Differentiate variants using Variant option and Variant value fields.

    • Example: For a "T-Shirt" available in "Red" and "Blue":

      • Row 1: Product name: "T-Shirt", Variant option 1: "Color", Variant value 1: "Red"

      • Row 2: Product name: "T-Shirt", Variant option 1: "Color", Variant value 1: "Blue"

  • Adding variants to existing products:

    • To add new variants to an existing product, ensure the Product name in the template matches exactly with the existing product in Katana.

  • Required fields:

    • At a minimum, the following fields must be filled:

      • Product name

      • Make? and/or Buy? (At least one must be marked as "Yes", "Y", or "yes")

  • Product tracking:

    • To enable batch or serial number tracking, enter "batch" or "serial" in the Product tracking field.

    • Leave the field empty or enter "no"/"none" to disable tracking.

Note: This feature is part of the Full Traceability add-on and is available on specific plans.


Troubleshooting common issues

  • Import Failures:

    • If a field in the imported file doesn't meet the required format (e.g., incorrect column names or invalid data types), the specific field will not be imported, and the corresponding item's field will remain blank in Katana.

  • Duplicate Entries:

    • If a variant with the same Variant code / SKU already exists in Katana, the import will skip that entry to prevent duplication.

  • Missing Required Fields:

    • Rows missing mandatory fields like Product name will not be imported.


Import fields/columns additional info

Category - All variants of the same product should be in the same category (a Maximum of 35 characters is allowed).

Unit of measure - All variants of a product should use the same unit of measure. (Max 7 characters allowed).

*Make? - adding "Yes" to the Make? column, you'll enable Product recipes and Production operations for the product.

*Buy? - Adding "Yes" to the Buy? column allows you to add products to purchase orders in Katana and defines the Default purchase price and Default supplier on the product card.

Note: You can enter "Yes" to only one or all of the Make and Buy columns.

* = Required

Registered barcode - One registered barcode can be assigned to retail products. The registered barcode number can be between 3-140 digits.
The registered barcode only imports if internal barcodes are switched on from the barcode settings.

This feature is available on a Standard or higher plan, the field only displays in the template if you're on a higher plan.

Default sales price - Value is per unit of measure and in your base currency. You can set the base currency inside Settings > General. Numbers only, up to 9 decimal places.

Default supplier - Fill in if you have chosen 'Yes' in the Buy? column. The product supplier is added to purchase orders (PO) in Katana by default, but can be edited on each PO. All of a product's variants should have the same default supplier.

Default purchase price - Fill in if you have chosen 'Yes' in the Buy? column. (Numbers only, up to 9 decimal places.)

  • Starter plan: Value is per unit of measure and in your base currency. You can set the base currency inside Settings > General.

  • Standard, Professional, and Professional Plus plans: Value is per unit of measure and in your supplier currency. By default, supplier currency is your base currency. Read about purchase prices in foreign currencies.

Purchase UoM - Fill this in if you have chosen "Yes" in the Buy? column and if you buy this product in a different unit of measure then you track your inventory.

Note: If you enter a purchase UoM, then the value in the Default purchase price is also considered in this purchase unit of measure.

Conversion rate - Only fill this in if you have filled in the "Purchase UoM" field. It's the conversion rate of the purchase UoM to the tracking UoM.

Note: If you enter purchase UoM and do not specify the conversion rate or vice versa, then both values are not imported.

Additional info - This info is stored on the product card (the same info for all variants of the product). All variants of the same product should have the same additional info.


Importing products and stock from an ecommerce platform

If you sell online and manage product stock on an ecommerce platform (e.g. Shopify), you can connect your e-store to Katana and import all your products to Katana in minutes. Imported products will maintain the same variant structure you have set up in Shopify. Connect your Shopify store.

Since materials are typically not managed on ecommerce platforms, only product stock will be imported. Import materials using our spreadsheet template.

If you need to update stock, take a look at this article for updating products.


Your feedback is invaluable. Let us know your thoughts on this article or anything in Katana you'd like to see improved: [email protected]

Did this answer your question?