> 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

To convert a Product List exported from Canoa to a SIF file using CanoaGPT, follow these steps:

### **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!
