Importing Variant codes (SKU) to materials in Katana. If you have a long list of materials without Variant codes in Katana, it may be more efficient to generate the codes in a spreadsheet rather than upload them manually into Katana.

Updating Material names, Categories, Default Suppliers, Purchase prices, Barcodes, or Additional info for materials in bulk.

Updating safety stock levels for materials in bulk.

Updating Default storage bins for products in bulk (this is only available for those on a Standard or higher plan).

Enabling batch tracking for materials in bulk. This feature is part of the Full Traceability add-on (automatically available for Professional plans).

Imported materials are matched to products in Katana though the Katana ID in the spreadsheet. This ID isn't visible in Katana and is only used to match products.

Imported materials will be skipped if they're missing a Katana ID match in Katana.

Any changes in the spreadsheet will update products in Katana, except for changes to the Material variant column. This column is only included in the spreadsheet for better identification purposes.

If the material has multiple variants, changing the Material name in the spreadsheet for only one variant will not split the material variants into multiple material cards in Katana, but it will overwrite the material name for the original material.

The Batch trackable? columns accept values "Yes", "yes", "Y", and "y". If the field is empty, the current setting for the item will not change. You cannot disable batch tracking for items in bulk if batch tracking is already enabled in Katana. Navigate to the product card in Katana to disable batch tracking for each item.

The Sell? column accepts the following values: "Yes", "yes", "Y", "y", "No", "no", "N" and "n".

If you have multiple Locations in Katana, the file will include multiple rows for each item variant in the file (one row for each Location). This is so you can update safety stock levels for items using this file (as it's a Location-specific value in Katana).

Updating material barcodes.
This feature is available on a Standard or higher plan, and this field is only displayed in the template if you're using a higher plan.

Supplier item code - Add or change supplier item barcodes to identify raw materials and purchasable products. Multiple barcode numbers are separated by a comma "," to your item variant as a supplier item code. Supplier item codes are imported if the supplier item code is switched on in the barcode settings.

Internal barcode - Assign or change internal barcodes to track inventory movements. Barcode numbers can be between 3-40 digits. Internal barcodes are only imported if the internal barcode is switched on in the barcode settings.
If internal barcodes are already generated automatically, then they won't be imported.

If you change Default supplier to a supplier that has a different supplier currency, the default purchase prices of this item will be converted to the selected supplier's currency.

Updating Default purchase prices for materials in bulk.

If you use multiple locations in Katana, the file will include multiple rows for each item variant in the file (one row for each Location). This is so you can update safety stock levels and default storage bins for items with the file (as they are Location-specific values in Katana).
​

If you have multiple locations in Katana and there are multiple rows for each item variant in the file, and you change product data (e.g. material name, category, default purchase price, batch tracking settings) on one row but not on the other, the values for the bottom row for this item variant in the file will be imported to Katana.

Empty cells are ignored during import so they won't overwrite any existing Katana data, except for barcodes, where the empty cells overwrite the existing values. This enables deleting barcodes in bulk.