Thread: Help With Import

I'm getting an error when trying to do an excel import.

Adding Product(Wax Crayons, 8 Colors/Box)
Executing SQL: insert product(ProductGUID,IsImport,IsAKit,IsAPack,PackSi ze,Name,SEName,ImageFilenameOverride,ProductTypeID ,RelatedProducts,Summary,Description,SEKeywords,SE Description,SETitle,SKU,ManufacturerPartNumber,Col Width,XmlPackage,SalesPromptID,Published,TrackInve ntoryBySizeAndColor,TrackInventoryBySize,TrackInve ntoryByColor,RequiresRegistration,MiscText,Extensi onData,SEAltText) values(N'72A8C721-8A95-4A8C-9D48-2CE25F3859A3',1,0,0,0,N'Wax Crayons, 8 Colors/Box',N'wax-crayons-8-colorsbox',N'DIX00000_1_1.JPG',8,'',N'Wax Crayons, 8 Colors/Box',N'Wax crayons have been family favorites for generations. In an easy-open tuck box that keeps crayons accessible and safely stored. Color(s): 8 Assorted; Assortment: Black; Blue; Brown; Green; Orange; Red; Violet; Yellow; Crayon Size: N/A; Size Group: Standard.',NULL,NULL,NULL,N'DIX00000',NULL,4,N'pro duct.variantsinrightbar.xml.config',1,1,0,0,0,0,NU LL,NULL,N'Wax Crayons, 8 Colors/Box')
>> Added OK
Executing SQL: insert productCategory(productid,Categoryid) values(639,247)
Executing SQL: insert productCategory(productid,Categoryid) values(639,248)
Executing SQL: insert productCategory(productid,Categoryid) values(639,249)
Executing SQL: insert productManufacturer(productid,Manufacturerid) values(639,57)
Executing SQL: insert productDistributor(productid,Distributorid) values(639,5)
Adding ProductVariant(, Product=Wax Crayons, 8 Colors/Box)
Executing SQL: insert productvariant(VariantGUID,IsImport,ProductID,Name ,ImageFilenameOverride,IsDefault,DisplayOrder,Desc ription,Price,SalePrice,MSRP,Cost,SKUSuffix,Manufa cturerPartNumber,Weight,Dimensions,Inventory,Publi shed,Colors,ColorSKUModifiers,Sizes,SizeSKUModifie rs,IsTaxable,IsShipSeparately,IsDownload,DownloadL ocation,ExtensionData,SEAltText,Condition) values(N'A172A829-4684-4026-BEEC-EC68807CD77C',1,639,N'',N'UNV31301_1_1.JPG',0,1,NU LL,4.39,NULL,NULL,NULL,N'',N'Strong steel 3/8" pin for inserting into even the toughest surfaces. Head Material: Plastic; Head Diameter: 1/4 in; Pin Material: Steel; Color(s): Red.',0.174999997019768,N'3.79999995231628, 2.90000009536743, 1.10000002384186',1000000,1,N'',N'',N'',N'',1,0,0, NULL,NULL,N'',0)
Error on Node: ProductVariant:: String or binary data would be truncated.
The statement has been terminated.

It looks like one of the fields is too long and so the database is rejecting it. I was wondering if there was a way to tell which field it is? And is there a way to make the fields longer?

Thanks!

Looking at it from a v8 point of view. it looks like you're trying to stuff

Code:

Strong steel 3/8" pin for inserting into even the toughest surfaces. Head Material: Plastic; Head Diameter: 1/4 in; Pin Material: Steel; Color(s): Red.

into ManufacturerPartNumber which only takes 50 chars.