![]() |
Import Wizard Excel row limitation |
Post Reply ![]() |
Author | |
JamesD ![]() Newbie ![]() Joined: 10-July-2008 Status: Offline Points: 0 |
![]() ![]() ![]() ![]() ![]() Posted: 30-April-2010 at 3:05pm |
I'm having a problem with the Import Wizard where it's only allowing me to import 3000 products at a time.
I'm using Excel from Office 2000. I'm not a newbie, and I've used this wizard before. I've checked and re-checked my spreadsheet to make sure it's complying with the format restrictions.
If I have more than 3000 rows (not including the header) in my Excel spreadsheet, anything past that will get an error when the wizard is finished. It will say it couldn't import those products because of missing SKU and missing Product Name.
If I split up my spreadsheet into seperate ones with 3000 rows each, it works fine.
Thanks,
Jim
|
|
![]() |
|
ProductCart ![]() Admin Group ![]() ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135 |
![]() ![]() ![]() ![]() ![]() |
This is done to avoid performance issues when importing MS Excel files. To remove the limitation, download the file step4-xls.asp from your Control Panel folder, open it in Notepad or your favorite HTML editor, and locate the line that reads
Replace 3000 with a higher number, save the file, and upload it back to the Control Panel folder. |
|
![]() |
|
JamesD ![]() Newbie ![]() Joined: 10-July-2008 Status: Offline Points: 0 |
![]() ![]() ![]() ![]() ![]() |
Wow, you really know this cart thoroughly!!
Thanks!
|
|
![]() |
|
benpate ![]() Groupie ![]() ![]() Joined: 15-February-2007 Location: United States Status: Offline Points: 0 |
![]() ![]() ![]() ![]() ![]() |
lol, they should and they do |
|
ProductCart SEO - Resellers and Affiliates welcome
|
|
![]() |
Post Reply ![]() |
|
Tweet
|
Forum Jump | Forum Permissions ![]() You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |