# How to import your product data

{% embed url="<https://www.youtube.com/watch?ab_channel=Canoa&v=cng8vMFm0kE>" %}

**Table view in My Catalog** is the tool used to import products as new releases drop or client projects with specific furniture specs are added to your workload. Here is where you can upload custom furniture pieces and any products you design with on a daily basis that are not already in Canoa's Public Catalogs.&#x20;

With this feature, you will be able to create, import, and maintain products to your Catalog. If you are a supplier, you will also be able to publish these new products to Canoa's Public Catalogs (with the help of the Canoa team) for all designers and users to discover.

### Types of data supported by Canoa:

<table><thead><tr><th width="351">Data Type</th><th>File Type</th></tr></thead><tbody><tr><td>2D vectors</td><td>.dwg, .dxf, .3dm</td></tr><tr><td>3D surfaces</td><td>.dwg, .dxf, .3dm</td></tr><tr><td>3D solids</td><td>.dwg, .dxf, .3dm</td></tr><tr><td>3D meshes</td><td>.dwg, .dxf, .3dm</td></tr><tr><td>Images</td><td>.png, .jpg, .gif</td></tr><tr><td>Structured data</td><td>.xls, .csv</td></tr><tr><td>Attachments</td><td>.pdf</td></tr></tbody></table>

{% content-ref url="../../understanding-and-using-products" %}
[understanding-and-using-products](https://help.canoa.supply/docs/collect/understanding-and-using-products)
{% endcontent-ref %}

Now, **choose one of two ways** to create and import your new product data:

## **Option 1: Create a new product directly on My Catalog**

This option is helpful if you are creating a few new products and have all the product data readily available. This is a manual process to bring in your own product data.

* Head to **My Catalog** in the navigation menu.
* Click on the **Create Product** button on the upper right.

<figure><img src="https://2113117739-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FoXL90G447T7Arsje35d9%2Fuploads%2Fj9Kt5vgkNa0WeGpCK5sP%2FScreenshot%202024-09-19%20at%204.12.54%E2%80%AFPM.png?alt=media&#x26;token=c82d3125-8959-4658-9517-f59a385e8b78" alt=""><figcaption><p>Create Product icon</p></figcaption></figure>

* You will be prompted to fill out the several fields of product information, add an image, and add a 2D drawing in order to create a new Product (as seen below).
  * For **Drawings**, either import existing 2D drawing DWG or DXF files with the **Import Drawing** button, or use Canoa's drawing tools at the bottom of the Canvas to easily draw your own.
  * If you are a supplier, fill out the required fields marked with a <mark style="color:red;">red</mark> <mark style="color:red;">asterisk</mark> to create a '**Complete**' product and be ready to '**Publish**' to all Canoa users on the Public Catalog. Ping the Canoa team when you're ready to publish.

<figure><img src="https://2113117739-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FoXL90G447T7Arsje35d9%2Fuploads%2FzaD7xXTnkZR46BUTptJm%2FDrawing%20Editor%20-%20new%20ui.png?alt=media&#x26;token=1be87d9b-e4a2-4e7a-a422-77e313631a87" alt=""><figcaption><p>After clicking 'Create Product,' this window allows you to add in the data, images, and drawing.</p></figcaption></figure>

## **Option 2: Uploading a CSV file in Table view**

This is the best way to bring in your product data quickly, in bulk, with one swift import. Prepare your list of product data in your favorite spreadsheet program and then export it to a CSV file in order to bring it back into Canoa. Here's a step-by-step how:

1. Click on the **My Catalog** icon in the navigation menu. Toggle to the **Table** tab.
2. In a separate window, choose to use **Excel**, **GoogleSheet**, **Airtable**, or any other spreadsheet program you prefer to add your new product data.
3. Refer to this Canoa provided GoogleShee&#x74;**:** [<mark style="color:purple;">**Product Data Template**</mark> ](https://docs.google.com/spreadsheets/d/1jBbhwIQ2Jj5Z14_8MdPvxC8uDidg-GK8shcYdoMLFXs/edit#gid=245220932)(seen below) for the correct formatting of your data with the required fields.
   * If you are a supplier wanting to **Publish** to Canoa’s public Product Catalog, you will need to provide the data that is noted in <mark style="color:red;">**red**</mark> to create a **Complete** product, and then ping the Canoa team when you're ready to publish.

<figure><img src="https://assets-global.website-files.com/6399c9f45da398ac3776f03e/65aed70e060ebcc06c04b4c4_Screenshot%202024-01-22%20at%2012.57.37%E2%80%AFPM.png" alt=""><figcaption></figcaption></figure>

4. Add in your data for all the products you want to import. ***Tip: Each variation or SKU will need their own line.***
5. Ideally, the format will be consistent to what is in the <mark style="color:purple;">**Product Data Template**</mark> seen above ... capitalization, imperial sizing, punctuation, required fields, etc.&#x20;

### **Here are tips for adding in images within a CSV file:**

* If you are using a program such as **GoogleSheet** or **Excel**, you will need to copy and paste the **image URL address** into the **Images field** before downloading to a **CSV**.
* If you want to bulk import **multiple images** for each product, simply copy and paste the image URL addresses into the Images field and separate them with a **comma** in the cell. No additional spaces are needed here.&#x20;
* If you are using **Airtable**, you may attach **jpegs or pngs** in the **Image field** before downloading to a CSV.

{% hint style="info" %}
We recommend using image files under **10mb** each for peak performance.
{% endhint %}

## **Once your spreadsheet is complete, download it to a CSV file.**

1. Log back into **My Catalog - Table view**.
2. Click **Import** via the **three dots** in the upper right hand corner. And select your new/updated **CSV** file.
3. The **Import Products** window will pop up. Canoa will automatically match your data fields.
   * If the fields you are importing are not automatically selected and seen, you can manually match the fields by using the **dropdown arrows** within each field.
   * If you do not want to import a detected field, simply click the **X** to remove it from the import.
4. Click **Next**. This will launch a **preview** of how your data will look for each product you import into Canoa.
   * Use the **arrows** in the top right corner of this preview to toggle through your list of products from the CSV file.
5. Click **Import** and then click **Proceed** when you and your data are ready.
   * A processing notification will appear in the bottom right corner of your screen, letting you know the import is working. You will also receive a confirmation **email** once your import is complete. &#x20;
6. Your products are now imported to My Catalog and have been assigned a unique Product ID for easy bulk editing at a late time. **Congrats!**&#x200D;

<figure><img src="https://2113117739-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FoXL90G447T7Arsje35d9%2Fuploads%2FXMfZ1MCoT1oOSnKtmVUv%2FTable%20-%20three%20dots.png?alt=media&#x26;token=6bae4dbc-69a3-42a8-9cd1-a1a023cb04ee" alt=""><figcaption><p>In Table view, the Import button lives within the three dots.</p></figcaption></figure>

<figure><img src="https://2113117739-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FoXL90G447T7Arsje35d9%2Fuploads%2FCnrBRVTKaJGXUh4WMctm%2FScreenshot%202024-09-19%20at%204.15.39%E2%80%AFPM.png?alt=media&#x26;token=3c728841-8d16-424e-b305-9242af8a29ee" alt=""><figcaption><p>All the fields you want to include in your import must be selected and seen here. For example, here the Product Name will be created and the Description will not be created with these new product lines.</p></figcaption></figure>

<figure><img src="https://2113117739-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FoXL90G447T7Arsje35d9%2Fuploads%2FvcP3fnJGypM9qfibKxlz%2FCSV%20preview%20window%20.png?alt=media&#x26;token=4a7bdb18-b3ce-4ff7-af4e-81e79efee06b" alt="" width="375"><figcaption><p>Import Preview</p></figcaption></figure>

### **Some helpful tips to keep in mind:**&#x20;

* If you are not able to bulk import .dwg/.dxf drawing files, you should click into each product to add the drawing in at a later time. (*So designers have the most accurate 2D drawing to design to scale with*).
* If you are a supplier, you may ping the Canoa team to **Publish** your ‘**Complete**’ products, which will now be searchable on Canoa’s public [<mark style="color:purple;">**Product Catalog**</mark>](https://www.canoa.supply/products)<mark style="color:purple;">**.**</mark>
* As a supplier, you are responsible for maintaining accurate data you share with Canoa. We recommend that you update your Excel Spreadsheet or Airtable weekly or monthly - pinging the Canoa team when an update to your data has been made - email us @ <support@canoa.supply>.

Please watch the video above for a complete, in depth explanation of navigating these steps.