I attempt to upload an excel file containing products.
When I view the import log I see that I have an error.
Adding Product(Acuvue)
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'90F604F9-F80C-4BE0-ACAA-B401921D228D',1,0,0,0,N'Acuvue',N'acuvue',NULL,8,' ',N'<UL>
<LI><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Trebuchet MS">Box of six Acuvue brand contact lenses. </SPAN></LI>
<LI><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Trebuchet MS">Light blue visibility tint. </SPAN></LI>
<LI><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Trebuchet MS">Contains inside out "AV" marker so you know your lenses are inserted correctly. </SPAN></LI>
<LI><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Trebuchet MS">Approved for 1 week continuous wear or 2 week daily wear.</SPAN></LI></UL>',N'<UL>
<LI><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Trebuchet MS">Box of six Acuvue brand contact lenses. </SPAN></LI>
<LI><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Trebuchet MS">Light blue visibility tint. </SPAN></LI>
<LI><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Trebuchet MS">Contains inside out "AV" marker so you know your lenses are inserted correctly. </SPAN></LI>
<LI><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Trebuchet MS">Approved for 1 week continuous wear or 2 week daily wear.</SPAN></LI></UL>',N'Acuvue Contact Lenses',N'ACUVUE at SunGlassPRO.com - Huge Savings, FREE shipping, rebates available, same lenses as your Dr''s office.',N'Acuvue Contact Lenses at SunGlassPRO.com',N'CL0001AV',NULL,1,N'product.vibe .aps.custom.xml.config',3,1,0,0,0,0,NULL,NULL,N'Ac uvue')
>> Added OK
Executing SQL: insert productCategory(productid,Categoryid) values(44,2)
Executing SQL: insert productManufacturer(productid,Manufacturerid) values(44,6)
Executing SQL: insert productDistributor(productid,Distributorid) values(44,1)
Error on Node: Product:Acuvue: Node: ProductVariant, Required Field (Price) Is Missing!
Why does it say that my price is missing? I have it in the spreadsheet. I have tried having the price formatted as 'general' and as 'number', there is no change in result.
How does the upload process work? I seem to get the same log even after I change what is in the excel file.