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.
Last updated
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.
Last updated
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
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 support@canoa.supply for more information and access to Canoa's new feature.
Open a SIF file in Spec
Export
as a CSV
Export with Combined Product Number if available
Open CanoaGPT
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.
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.
Add Images and 2D drawings to your products to use in future projects and to collaborate with your team.
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.
Open the CSV in Excel or GoogleSheets
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 Spec
Click File
>Import
>Microsoft Excel
Assign columns from the Excel File list (first column) from the Spec list (second column) to create the list for import shown (third column)
Example: Match SKU in the Excel List to Part Number in the Spec List
When you are done matching all of your columns, click Ok
Congrats! You imported your Canoa products into Spec.