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:
Last updated
To convert a Product List exported from Canoa to a SIF file using CanoaGPT, follow these steps:
Last updated
You'll need to create a free OpenAI account to use CanoaGPT.
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.
CanoaGPT will load and display the first few rows of your CSV file.
This helps understand the structure and columns of the CSV file.
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
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.
Download the generated SIF file.
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!
