Working with Spec

In this article you will learn how to get your product data Canoa-ready in Configura’s Spec and import as products in Canoa.

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 into Spec

1. There are 2 ways to Export a Product List from Canoa

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

   2. Catalog Pro-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.