# How to edit your product data

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

A consistent step along this product discovery journey is to keep your product data fresh and up-to-date. Lead times are constantly changing, inventory of products come and go daily, and price increases happen almost quarterly. With **My Catalog**, you will be able to maintain and update your existing products in your Canoa catalog whenever you need.&#x20;

## ‍There are multiple ways to update your product data in Canoa - My Catalog & Canvas&#x20;

### **The first way is working** **in the Table view in My Catalog**.&#x20;

We recommend working in this way if you are updating **less than 20** products.

1. Make sure you are working in your own **View** - in case someone else from your team is working in My Catalog at the same time.
2. Click on the individual product image in the list of products to show the **Product Side Panel**. You then can edit any of the fields in this right side panel, which will automatically save to your Catalog.
3. If your products are published to Canoa’s Public Catalogs or exist inside Canvases, your products will automatically be updated publicly, no additional steps are needed.
4. If you want to work on a specific group of products, for example, click on the **Filter** icon and then select the sofa category, for example (if you have multiple manufacturers you may filter through those or any other filter as well). This will bring up all of the sofas instead of sifting through the entire catalog of products.

<figure><img src="https://2113117739-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FoXL90G447T7Arsje35d9%2Fuploads%2FXdbbZcTY1aIwQqKQpdBM%2FTable%20-%20choose%20product.png?alt=media&#x26;token=c762bd04-35cf-4145-80fd-f89958c4d484" alt=""><figcaption><p>Click on the Image of the Product to edit its specifications in the right-side Product Panel.</p></figcaption></figure>

### **The second way to edit product data** **is by working with a CSV** **file**.&#x20;

We recommend working in this way if you are making updates to **more than 20** products at one time. **First**, let's export your existing product data out from My Catalog and into a **CSV** file so we can utilize the **Product IDs** of your products.

1. Make sure you are working in your own **View** - in case someone else from your team is working in My Catalog at the same time.
2. **Select** all of the products you would like to bulk edit by checking the box to the right of the product name. You can use the **Filter tool** to narrow down the search.
3. Click on the **three dots** on the right and then select **Export**. You will then see a window pop up at the bottom of your screen to let you know that it's working on downloading the **CSV** file to your computer. (It may take a few seconds).
4. Open your **CSV** file in your preferred spreadsheet program, like **Excel, GoogleSheets, or Airtable**, and edit the desired fields you would like to update.

<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>Filter tool is located to the left. Export is located in the three dots on the right.</p></figcaption></figure>

### **There are a few important things to note:**

* You must always include the **Product ID** field in the **CSV** file to update existing products in My Catalog. This is how Canoa recognizes each product for bulk edits. If you do not include the Product ID for each line of data, a new product will be created and your existing product will not be updated.
* You may delete all other fields that you are ***not*** updating from your **CSV** file.
* In the spreadsheet program you are working in, export or download your new edits to a new **CSV** file.

<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><p>Sample of exported data in GoogleSheets</p></figcaption></figure>

### **Now, let's import the CSV file back into My Catalog in order to complete this bulk edit.**

* While in My Catalog, click **Import** and select your **CSV** file.
* Make sure the **Product ID field** and the fields you are updating are selected -> click **Import**.&#x20;
  * ***Tip: If the formatting of your Field names do not match the*** [*<mark style="color:purple;">**Product Data Template**</mark>*](https://docs.google.com/spreadsheets/d/1jBbhwIQ2Jj5Z14_8MdPvxC8uDidg-GK8shcYdoMLFXs/edit?usp=sharing)***, then you must manually select the Fields from the drop down menu in this view.***
  * ***Tip:** You will accidentally create new products if you do **not** include the **Product ID** field in this bulk import to edit existing products. The **Product ID** is the most important factor when making edits to live data on Canoa.*
* You will get a **notification** and an **email** once your Import is complete. &#x20;
* Your products are now updated in your private catalog and public catalog!

<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 My Catalog, 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>

If you are a Brand, you are responsible for maintaining accurate data for your products published on Canoa. We recommend that you update your Airtable or Excel Spreadsheet 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.
