HomeHome Product Discus... Product Discus...SmithCartSmithCartImporting products. Which fields have character limits?Importing products. Which fields have character limits?
Previous
 
Next
New Post
1/2/2013 1:01 PM
 
Hello -

I was trying to import some products today when I received the following error:
Product import Error String or binary data would be truncated.The statement has been terminated.

I remembered that certain data fields in the product tables have character limits. I'm thinking that is the cause of this error?

If you don't mind - could you list any of the import fields that have a character limit, and what that limit is? (i paid for url keywords import, so that one as well)

Thanks,
Alex
 
New Post
1/2/2013 11:14 PM
 
Hi Alex,
Using SSMS you can view the data types and lengths of your Smith_Products table which will give you all the allowable field lengths for the import xls


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
1/3/2013 11:31 AM
 
Thanks Scott -

We narrowed it down to the URL Keywords field that we had custom programmed. We increased the maximum character limit to 200 on that field, and now imports are working fine.
 
New Post
1/7/2013 4:40 PM
 
Thanks for posting back with an update. Glad to hear this issue is now resolved!
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartImporting products. Which fields have character limits?Importing products. Which fields have character limits?