Understanding and utilizing Products
This article will help you organize and manage product data efficiently, ensuring consistency and completeness for working with Canoa and uploading your data onto the platform.
What is a product?
A product in Canoa represents an item that can be used in your interior design projects. This could be furniture, decor, or any other element you want to include in your designs. Each product in your Catalog contains essential details such as name, description, manufacturer, and specifications that help in identifying and utilizing it effectively.
A product in Canoa goes a bit further than a traditional PDF spec. On Canoa, products contain marketing images, CAD files, commercial data, certifications and more. A product here is logical entity that represents a particular product in the real world.
Why are products important?
Products are important because they are the building blocks for everything we do on Canoa. Any design made on Canoa is a combination of products put together with a particular objective in mind. Products drive the recommendation engine, your ability to schedule designs and your catalog.
Canoa Product Schema
The Canoa product schema, or data model, is a structured format for organizing product data to ensure consistency and completeness to be ready for uploading to Canoa. It includes various key fields listed below with descriptions and the necessary format required.
Here are the supported fields in a product on Canoa:
| Field Name | Description | Format |
|---|---|---|
Product ID | A Canoa defined unique identifier for the product | string |
Product Name | A human readable product name or description | string |
SKU | Stock keeping unit, unique identifier | alphanumeric |
Images | Stock or marketing image of the product | URL (copy image address) |
Drawing | 2D vector drawing (top-down view) | .dwg, .dxf, .3dm |
Manufacturer | Name of the manufacturer | string |
Vendor | Name of the vendor | string |
Color | Color description | string |
Material | Materials used | string |
Description | Detailed description | string |
Quantity | The number of items available or required | integer |
Size | Dimensions ("W x "D x "H) | string |
List Price | Product's list price | currency |
Discount | Discount rate | percent |
Sell Price | Price after discount | currency |
Net Price | Price after all discounts | currency |
Markup | Markup rate | percent |
Net Discount | Net discount rate | percent |
Lead Time (Weeks) | Time required to deliver, including transit in weeks, (i.e. 12 Weeks) | integer |
Finish | Product finish | string |
Fabric | Fabric details if applicable to the product | string |
Product URL | Link to the product's webpage | URL |
Category | Canoa product category | string, single select |
Subcategory | Canoa product subcategory | string, single select |
Tags | Tags for classification (search-ability) | string |
Available Stock | Stock quantity | integer |
Weight (lbs) | Weight of the assembled product | decimal |
Condition | Product condition (e.g., New, Used) | single select |
Warranty | Warranty details in years | integer |
Certifications | Associated certifications | URL |
Configuration | Configuration details | COM/COL |
Embodied Carbon | Carbon footprint of the product | Decimal |
Customized | Customization status (Yes, No) | single select |
Alternate SKU | Alternate identifier | string |
Last Update | Timestamp of last update | string (ISO 8601 format) |
Recycling Info | Recycling details | string |
Attachments | Any additional information (i.e. Assembly Instructions) | URL |
Example of the Canoa Schema in CSV Format
Here’s an example of how data might look in a CSV file following the Canoa framework outlined above:
Usage in CanoaGPT
CanoaGPT can assist with verifying data, correcting formatting issues, optimizing data for better organization, and converting files to the required formats. When using CanoaGPT, this model helps ensure that your data is correctly formatted and complete, ready for uploading to Canoa.
To learn how to use the CanoaGPT model on Open AI's ChatGPT, read onto the next article for a step-by-step guide. Have your CSV file ready to go.
Last updated