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.
Step 2: Upload the CSV File
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
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
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 availableWT
(Weight): Leave empty if not availableG0
(Group 0):Vendor
GC
(Group Code):Category
(if available)NT
(Count/Flag):Quantity
Step 5: Generate the SIF File
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
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!
Last updated