> For the complete documentation index, see [llms.txt](https://help.canoa.supply/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.canoa.supply/docs/share/how-to-download-a-product-list/how-to-convert-a-product-list-from-canoa-to-sif-using-canoagpt.md).

# How to convert a Product List from Canoa to SIF using CanoaGPT

### **Step 1: Open CanoaGPT**

You'll need to create a free OpenAI account to use CanoaGPT.

{% embed url="<https://chatgpt.com/g/g-dkB2IDXQ3-canoagpt>" %}

### **Step 2: Upload the CSV File**

1. **Upload your CSV export file from Canoa to CanoaGPT.**
   * Ensure the file is in the CSV format. If it's in another format, convert it to CSV first.

### **Step 3: Inspect the CSV Structure**

1. **CanoaGPT will load and display the first few rows of your CSV file.**
   * This helps understand the structure and columns of the CSV file.

### **Step 4: Define the Mapping**

1. **CanoaGPT will automatically map the CSV columns to the appropriate SIF keys.**
   * Example mapping:
     * `PN` (Part Number): `SKU`
     * `PD` (Product Description): `Product`
     * `MC` (Manufacturer Code): `Manufacturer`
     * `P1` (Price 1): `List Price`
     * `P2` (Price 2): `Sell Price` (if available)
     * `P4` (Discount): `Discount`
     * `P5` (Net Discount): `Net Discount` (if available)
     * `VO` (Volume): Leave empty if not available
     * `WT` (Weight): Leave empty if not available
     * `G0` (Group 0): `Vendor`
     * `GC` (Group Code): `Category` (if available)
     * `NT` (Count/Flag): `Quantity`

### **Step 5: Generate the SIF File**

1. **CanoaGPT will generate the SIF file for you:**
   * After mapping the columns, CanoaGPT will convert the CSV data into the SIF format.
   * CanoaGPT ensures the data is properly formatted and ready for import into CET or other systems.

### **Step 6: Download and Verify the SIF File**

1. **Download the generated SIF file.**
2. **Verify its contents to ensure it meets your requirements.**

By following these steps, you can efficiently convert your Canoa CSV export into a SIF file using CanoaGPT, ensuring seamless data integration and consistency across systems. If you have any specific questions or need further assistance, don't hesitate to ask CanoaGPT for help!


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

```
GET https://help.canoa.supply/docs/share/how-to-download-a-product-list/how-to-convert-a-product-list-from-canoa-to-sif-using-canoagpt.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.