Skip to main content

Exporting product recipes / BOMs

Export product recipes / BOMs from Katana to spreadsheets for efficient data analysis and inventory management.

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

Exporting product recipes, also known as Bills of Materials (BOMs), from Katana allows you to analyze, update, and manage your manufacturing components efficiently. By exporting these recipes to a spreadsheet, you can make bulk edits and re-import them to streamline your production processes.


How to export product recipes

  1. Navigate to the Items screen

    • Go to the Items screen in Katana.

  2. Select products

    • Choose the products for which you want to export the product recipes.

  3. Click the export icon

    Export icon in the items screen

    • Click on the export icon located at the top right of the screen.

  4. Choose export format

    Export options within the item screen

    • From the dropdown menu, select either Recipes/BOMs.xlsx or Recipes/BOMs.csv depending on your preferred file format.

The exported file will contain detailed information about the selected product recipes, which you can then edit as needed.


Editing and re-importing product recipes

After exporting, you can make bulk changes to your product recipes in the spreadsheet. Once you've made the necessary edits:

  1. Save the file

    • Ensure the file is saved in .xlsx or .csv format.

  2. Import the updated recipes

    • Go to Settings > Data import in Katana.

    • Under Add new product recipes / BOMs, click Upload data.

    • Select your updated file for import.

  3. Choose import options

    • Decide whether to replace existing product recipes or add ingredients from the imported file to existing recipes.

  4. Review and confirm

    • Katana will validate the file and highlight any errors.

    • If issues are found, correct them in the template and re-upload.

For detailed guidance on importing product recipes, refer to the article:
πŸ‘‰ Importing product recipes


Additional tips when importing

  • Existing items only: Ensure all products and ingredients in your spreadsheet already exist in Katana. The import process cannot create new items.

  • Mandatory fields: Include Product variant code / SKU, Ingredient variant code / SKU, and Quantity in your spreadsheet.

  • Optional fields: Product variant name and Ingredient variant name are for reference only and are not imported into Katana.

  • Multiple ingredients: For products with multiple ingredients, create separate rows for each ingredient, repeating the Product variant code / SKU as needed.

  • Notes: Any notes added will appear in the respective field for each ingredient in the product recipe.

  • Unit of measure: This is set on the item card in Katana and cannot be defined via the import template.


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?