Zen Cart Logo

Can I import from CSV?

Locked

Views: 13,496

Results 1 to 7 of 7
This thread is locked. New replies are disabled.
6 May 2008, 3:46 AM
#1
jberry610 avatar

jberry610

New Zenner

Join Date:
May 2008
Posts:
1
Plugin Contributions:
0

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

6 May 2008, 4:32 AM
#2
Kim avatar

Kim

Obaa-san

Join Date:
Jun 2003
Location:
West Coast, North America
Posts:
26,659
Plugin Contributions:
0

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.

6 May 2008, 4:52 AM
#3
misty avatar

misty

Inactive

Join Date:
Apr 2004
Location:
UK
Posts:
5,752
Plugin Contributions:
1

Re: Can I import from CSV?

jberry610:

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?module=documents&JAS_DocumentManager_op=viewDocument&JAS_Document_id=2&4a518f10f450e0719f940c2fab0a7c46=43df39a8dc8b460c8b11034d58f7ea8d

Dezina ZenCart Templates
Please do not PM for support queries..Post in forums..help others

4 Sep 2009, 2:09 AM
#4
xrsixturbo avatar

xrsixturbo

New Zenner

Join Date:
Sep 2009
Posts:
8
Plugin Contributions:
0

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

4 Sep 2009, 2:47 AM
#5
Kim avatar

Kim

Obaa-san

Join Date:
Jun 2003
Location:
West Coast, North America
Posts:
26,659
Plugin Contributions:
0

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.

4 Sep 2009, 3:09 AM
#6
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

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.

5 Sep 2009, 5:16 AM
#7
handkem avatar

handkem

Zen Follower

Join Date:
Oct 2006
Posts:
152
Plugin Contributions:
0

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