Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2010
    Posts
    1
    Plugin Contributions
    0

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

    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

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: Importing a CSV file to Zen Cart for just make data pass through Zen cart to Ship

    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
    Zen-Venom Get Bitten

 

 

Similar Threads

  1. Importing coupon data from csv file
    By cravin2 in forum Installing on a Linux/Unix Server
    Replies: 0
    Last Post: 23 Mar 2011, 07:37 AM
  2. CSV File Upload Zen Cart newbie!!!!
    By tonybrown in forum Setting Up Categories, Products, Attributes
    Replies: 3
    Last Post: 19 Sep 2010, 11:54 AM
  3. How do I make Zen Cart include www instead of just http?
    By princess_care in forum Templates, Stylesheets, Page Layout
    Replies: 3
    Last Post: 12 Feb 2009, 04:40 AM
  4. just installed zen cart -- error in language file
    By arciereshop in forum Installing on a Windows Server
    Replies: 0
    Last Post: 19 Jun 2007, 04:28 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR