Thread: Question about uploading products via excel upload

When i try to upload my product list i get an error.

ERROR: File Uploaded Error:
Exception=Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index

then i would only try 300 and it would work then i would try 300 more and i would get the same error?

any ideas?

i have a product list of 2000.

Thanks!

Any chance that one of the items in rows 301-600 is missing a required field, or has invalid data in one of the required fields? Sounds like something in the second batch of products you are trying to upload has some invalid data in it somewhere.

It seems all of the required fields are filled correctly.

is there a limit on how much you can upload at one time? would i be able to do the whole 2000 once i fix the mistake?

The only real limits are imposed on file-size and you'll be limited by the physical resources you have available to you. You won't be able to upload anything over 4 mb...and depending on the resources at your disposal 2 mb might be pushing it. Also, depending on your environment, sql may timeout depending on the number of records that have to be created, but typically you don't see that until the upper tens-of-thousands range and even then you'll see sql timeout errors instead of what you're seeing.

Which version of AspDotNetStorefront are you running?

Version (Code/DB): AspDotNetStorefront ML 8.0.1.2/8.0.1.2


i just tried to import some that worked before and it gave me the same error.

Can you attach your excel file (.zipped up), or if you'd rather not post send to support?

It's attached, its wierd, the first 600 worked fine to upload and then we worked from the bottom too and it worked until 800 so the error in-between 600 and 800 i believe, i just can't figure it out

Tracked it down There are several comments throughout the spreadsheet; 2 each in rows 788 and 872. Both rows have comments in columns R and AG. Once these are removed, the file imports successfully.

awesome thanks!