Working with Spec

In this article, you will learn how to export products from Canoa and import into Spec as well as getting your product data Canoa-ready in Configura’s Spec and import as products in Canoa.

Import a Canoa SIF file into Spec

You may export product data as a SIF file from both Canvas and My Catalog/Table View.

• Follow steps for Canvas export in How to export a SIF file from Canvas help doc

• Follow steps for My Catalog/Table View export in How to export a SIF file from My Catalog/Table View help doc

SIF Export in My Catalog/Table View

Import SIF file in Spec

Open or import SIF file from Canoa download. You may update product data against the Spec catalog to enable more option selection.

The Export SIF feature is only available in beta, please contact [e-mail] for more information and access to Canoa's new feature.

Exporting Product Data from Spec for import into Canoa

1. Open a SIF file in Spec

2. Export as a CSV

   • Export with Combined Product Number if available

3. Open CanoaGPT

4. Ask CanoaGPT to create a CSV from the file, with a record for every PN or Part Number with all of the associated data fields.

5. Import your CanoaGPT formatted CSV into Canvas (for less than 100 products) or Catalog Pro (for 100 products or more)

   • Match the CSV fields with the Canoa formatted fields

   • *Format your CSV before importing to save time matching fields. Refer to the article for step-by-step instructions.

6. Add Images and 2D drawings to your products to use in future projects and to collaborate with your team.

Match the Spec fields to Canoa fields

Your products are ready to add Images and 2D drawings

Import your Canoa Product List CSV into Spec

There are 2 ways to Export a Product List to a CSV from Canoa

• Canvas -Add a Product List to a Canvas, select products you wish to Export and select CSV

• My Catalog/Table View-Select the custom products you wish to Export, click the three dots and select Export.

Head to How to bring your Product List into Excel for more detail.

Export your Product List from Canvas

1. Open the CSV in Excel or GoogleSheets

2. Save As or Download a XLS extensions

   • Note: delete any lines that are above the column headers, unhide any columns, delete columns do not wish to import and delete other tabs that will not be used.

Open the CSV in Excel or GoogleSheets

1. Open Spec

2. Click File>Import>Microsoft Excel

3. Assign columns from the Excel File list (first column) from the Spec list (second column) to create the list for import shown (third column)

   1. Example: Match SKU in the Excel List to Part Number in the Spec List

1. When you are done matching all of your columns, click Ok

2. Congrats! You imported your Canoa products into Spec.