How to convert a schedule from Canoa to SIF using CanoaGPT

To convert a schedule 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.

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!

Last updated