Results 1 to 7 of 7
  1. #1
    Join Date
    May 2008
    Posts
    1
    Plugin Contributions
    0

    Default Can I import from CSV?

    I have like 34000 products can I upload them somehow. I can not find anywhere a place to upload a csv file or excel file. Please Help

  2. #2
    Join Date
    Jun 2003
    Posts
    33,715
    Plugin Contributions
    0

    Default Re: Can I import from CSV?

    If you have them in the correct order in your CSV you could import them directly into the MYSQL database.
    Please do not PM for support issues: a private solution doesn't benefit the community.

    Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.

  3. #3
    Join Date
    Apr 2004
    Location
    UK
    Posts
    5,821
    Plugin Contributions
    2

    Default Re: Can I import from CSV?

    Quote Originally Posted by jberry610 View Post
    I have like 34000 products can I upload them somehow. I can not find anywhere a place to upload a csv file or excel file. Please Help
    Try Easy Populate 1.2.5.4... free version from
    http://modhole.com/modhole/index.php...11034d58f7ea8d

  4. #4
    Join Date
    Sep 2009
    Posts
    8
    Plugin Contributions
    0

    Default Re: Can I import from CSV?

    I am after something like this aswell

    I have about 2,000 products coming out of filemaker - is there a way to set this up so I don't have to add tittles above the fields and set the CSV so that A will always be price, B always description C will always be SKU etc - this would be much easeir for me - cheers

  5. #5
    Join Date
    Jun 2003
    Posts
    33,715
    Plugin Contributions
    0

    Default Re: Can I import from CSV?

    is there a way to set this up so I don't have to add tittles above the fields and set the CSV so that A will always be price, B always description C will always be SKU etc
    Short answer? No.
    Please do not PM for support issues: a private solution doesn't benefit the community.

    Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.

  6. #6
    Join Date
    Jan 2004
    Posts
    66,380
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Can I import from CSV?

    As far as getting rid of the need to have titles added to the columns in your file, Kim is right: you must have those. It can get rather complicated and dangerous to alter the mod's code to make assumptions about the data it's receiving.

    You *might* find some relief from some of the work involved, however, if you are able to configure your FileMaker export to include its column names as a header row when it builds its export. (Most database systems have "include header row?" as part of their export options.) That depends on how much you know about filemaker, how much control you have over the export process, and what the column names are in it. I suspect by the nature of your question that the answers to those dependencies are probably not on the positive side. I'm guessing you might find some FileMaker tips by using your favorite search engine.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  7. #7
    Join Date
    Oct 2006
    Posts
    151
    Plugin Contributions
    0

    Default Re: Can I import from CSV?

    I had to reload my Zen Cart and Easy Populate 1.2.5.4. It used to work great before the reload and showed the rows/colums, etc. after I uploaded to the database. Now, it just says something like below. The file gets uploaded to the temp directory (permissions set to 777) but appears not to the database. I know that I have this installed correctly as I have used it before. Also, I am using Excel and saving as a tab delimited CSV file. Version 1.2.5.5. does not work at all. Any ideas would be greatly appreciated.

    Upload Results:

    Filename: 1.csv

    Upload Complete

 

 

Similar Threads

  1. Import Customers From CSV Via MySql?
    By suntower in forum Managing Customers and Orders
    Replies: 6
    Last Post: 15 Jun 2011, 06:54 AM
  2. Import Users from CSV file
    By jupitergardens in forum Managing Customers and Orders
    Replies: 0
    Last Post: 10 Jul 2010, 08:10 AM
  3. How to import catergories from a csv ???
    By ---kate--- in forum Setting Up Categories, Products, Attributes
    Replies: 2
    Last Post: 15 Apr 2010, 09:53 PM
  4. Trying to import UPCs from MS Access .csv file...
    By litepockets in forum General Questions
    Replies: 1
    Last Post: 18 Jul 2008, 08:37 AM

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