# Best Practices for Data Formatting

<figure><img src="/files/4diHPqxuuBB37jYTzRIH" alt="" width="241"><figcaption><p>Example of Healthy Data</p></figcaption></figure>

## Healthy Data Fields for Specification and Designing

Below are a few best practices to make sure you and your team have what they need to specify again and again on Canvas with Canoa.

### Product Name:

All names with each word capitalized.&#x20;

*Example*: Round Coffee Table

### SKU:

The SKU is an integral part of creating products and the ability to specify products again and again.  You may be putting together parts and pieces to create a conference table or a modular sofa.  As well as adding fabrics and finishes to your product.&#x20;

* Use the SKU needed to specify and quote that product.&#x20;
* This may be a combination of SKUs that can be separated by , commas, + plus signs or - dashes

*Example*: A conference table may be made of the top, base and power components.  Instead of creating products for each component, combine them for ease of specifying. *Example*: 1234-567-8910

### Color:

Add in the name of the color or series of colors that make up your product. A side chair may be Alabaster with a Chrome frame. Below are some examples:

* Alabaster, Chrome
* Shell: Alabaster, Frame: Chrome

### Material:

This is where you will be able to dive deeper into the materials of the product. It may be made of recycled poly, white oak veneer, fabric, stainless steel, etc. Listing all of the materials included in the product is helpful for you and your client making decisions.

* Recycled Poly, Powder Coated Stainless Steel

<figure><img src="/files/lrWBvZUB8Dou1ZYNeChq" alt="" width="375"><figcaption></figcaption></figure>

### Size:

We recommend industry standard formatting, which is required for published products.

* All size in inches "
* Simplified Width x Depth x Height, Seat Height = "W x "D x "H, "SH

You may use metric sizing if this works best for you and your project.

### Lead Time (Weeks):

We recommend using the interior design standard of *Weeks* for the lead time. &#x20;

* Canoa only accepts one number, i.e. 16
* If there is a range, i.e. 2-4 weeks, choose the longest lead time to plan for any contingencies.&#x20;
* You may want to consider adding additional time for freight

*Example*: 2 weeks for domestic ground freight or 8 weeks for international sea freight

### Bulk Importing:

{% content-ref url="/pages/cGi8J1vSlm7rh9TczlwA" %}
[How to import your product data](/docs/collect/my-catalog/working-in-table-view/how-to-import-your-product-data.md)
{% endcontent-ref %}

Refer to the Product Data Templates below for column formatting requirements, Subcategories, Categories, and other format details. Read the article linked above to walk through the step-by-step guide on how to import 100s of products at once into Canoa.

* [<mark style="color:purple;">**GoogleSheet\_Product Data Template**</mark>](https://docs.google.com/spreadsheets/d/1jBbhwIQ2Jj5Z14_8MdPvxC8uDidg-GK8shcYdoMLFXs/edit?gid=245220932#gid=245220932)
* [<mark style="color:purple;">**Airtable\_Product Data Template**</mark>](https://airtable.com/apprZxsHjKZnpn8aw/shrIUkS7l8W8gbFer)

{% content-ref url="/pages/Z0L553oBU32H7qgCgOMT" %}
[Understanding and using Products](/docs/collect/understanding-and-using-products.md)
{% endcontent-ref %}

### FAQs:

#### What if I don’t have all of the information and I am using products privately in my account?

Add the product information and data you have. It's okay to leave fields blank! You and other users in your account can always add more details later quickly and easily. &#x20;

#### What if I don’t have some information and I want to publish publicly on Canoa?

If you are looking to publish, all fields with an asterisk must be complete to create a publishable product. If your company doesn’t require a field or do not need it to specify, please add in N/A to that column or field. Read the article below for more information on this topic:

{% content-ref url="/pages/3nGSmTnQfydmOONrhflQ" %}
[Before you start publishing](/docs/for-brands/before-you-start-publishing.md)
{% endcontent-ref %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.canoa.supply/docs/collect/my-catalog/working-in-table-view/how-to-import-your-product-data/best-practices-for-data-formatting.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
