# 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: 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/share/how-to-download-a-product-list/how-to-convert-a-product-list-from-canoa-to-sif-using-canoagpt.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.