Importing a CSV file to Zen Cart for just make data pass through Zen cart to ShipWork

[sirriperek]

Hi,

I am trying to create a program that gets the order information from a CSV file and pushes data to Zen Cart DB.

I dont care if Zen cart properly works or not. I just need Zen Cart keep it in DB because The Shipworks will connect to Zen Cart DB and get the information of all orders.

Can any body help me about mapping the data fields between my CSV file and Zen cart??
Thanks

This is my CSV file:

ORDER NO
PO NO
ORDER DATE
ORDER EST DATE
CANCEL DATE
ORDER SM
ORDER SM DESC
SHIPTO NAME
SHIPTO COMPANY
SHIPTO STREET
SHIPTO STREET2
SHIPTO CITY
SHIPTO STATE
SHIPTO ZIP
SHIPTO PHONE
SHIPTO COUNTRY
CUSTOMIZATION
LINE NUM
HOST SKU NO
COMPANY SKU NO (the company that generates the CSV file)
HOST DESCRIPTION
QUANTITY
UNIT PRICE
EXT PRICE
LINE EST DATE

[kobra]

That is not even close to the ZenCart DB structure and the data rsides in several tables linked/indexed to each other

The ZenCart DB is not like a flat file DB