Go Back   Volusion Review Forums - Get the Most from your Online Store > Volusion Forums > Inventory
Reload this Page

Extra Large CSV Import

User Name
Password Register
Register FAQ Calendar Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1  
Old 07-09-2008, 02:04 PM
Soho Lighting Soho Lighting is offline
Junior Member
  
Join Date: Apr 2007
Posts: 5
Default Extra Large CSV Import
Hi there,
We having trouble importing product updates because our products files have gotten really large as we are up to like 70,000 products. Does anyone have any suggestions how to do large imports? I find that the browser times out or we get error message half way through...at this level of the game CSV files are just too cumbersome.
Thanks in advance for your help.
Pete Herman
Reply With Quote
  #2  
Old 07-09-2008, 03:28 PM
bgreenway bgreenway is offline
Junior Member
  
Join Date: Apr 2008
Posts: 13
Default
Quote:
Originally Posted by Soho Lighting View Post
Hi there,
We having trouble importing product updates because our products files have gotten really large as we are up to like 70,000 products. Does anyone have any suggestions how to do large imports? I find that the browser times out or we get error message half way through...at this level of the game CSV files are just too cumbersome.
Thanks in advance for your help.
Pete Herman
Pete, how about breaking them up into 3 or 4 (or more) chunks?
Reply With Quote
  #3  
Old 07-09-2008, 05:28 PM
fmc's Avatar
fmc fmc is offline
Senior Member
  
Join Date: Aug 2007
Posts: 130
Default
I have you unchecked the show error codes or whatever it's called on the import page? I've imported up to 19,000 files... it still took like 45 minutes, though.
Reply With Quote
  #4  
Old 07-09-2008, 09:27 PM
Spesh Spesh is offline
Senior Member
  
Join Date: Nov 2007
Posts: 134
Default
Just be carefull if it times out. We've had it go for over an hour only to time out at the end and look like everything was uploaded, only to turn out we needed to waste our bandwidth and load it again and again till it was all up.
Reply With Quote
  #5  
Old 07-23-2008, 04:14 PM
Salient Salient is offline
Junior Member
  
Join Date: Jun 2008
Posts: 2
Default
Most of the stores I've set up have over 70,000 items. Even if I'm only updating one database field, I've got to split the files into a minimum of 8 chunks. If I'm updating more than one DB field, I have to split into as many as 16-32 chunks.

Time consuming, to be sure; but if you want to make absolutely certain that all your data imports properly, it's worth the time.

Lastly, as previously noted, make sure to turn off all debugging features when importing more than 500 records.
Reply With Quote
  #6  
Old 07-24-2008, 07:22 AM
Slam it's Avatar
Slam it Slam it is offline
Senior Member
  
Join Date: Jan 2007
Posts: 131
Default
Maybe volusion should begin supporting some sort of FTP uploading of the product sheets.
__________________
E-Commerce Blog
http://theguth.wordpress.com/
Reply With Quote
  #7  
Old 07-25-2008, 03:34 PM
cskarp cskarp is offline
Junior Member
  
Join Date: Jun 2008
Posts: 26
Default
Quote:
Originally Posted by Slam it View Post
Maybe volusion should begin supporting some sort of FTP uploading of the product sheets.
Yes, please! :)
Reply With Quote
Reply

« Previous Thread | Next Thread »

Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are Off
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +0. The time now is 10:20 AM.

Volusion Review Forums - Archive - Top -