Import Wizard Excel row limitation
Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=3667
Printed Date: 02-March-2025 at 4:40pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: Import Wizard Excel row limitation
Posted By: JamesD
Subject: Import Wizard Excel row limitation
Date 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
|
Replies:
Posted By: ProductCart
Date Posted: 01-May-2010 at 1:54am
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. ------------- The ProductCart Team Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software |
Posted By: JamesD
Date Posted: 01-May-2010 at 8:19am
|
Wow, you really know this cart thoroughly!!
Thanks!
|
Posted By: benpate
Date Posted: 01-May-2010 at 11:14am
lol, they should and they do ------------- http://www.web1seo.com - ProductCart SEO - Resellers and Affiliates welcome |
JamesD wrote: