Possibly a bug in nop2.2 when importing the products from xls

I imported around 800 products , all the fields were correctly imported apart from sku , as sku is nvchar , so it should accept numbers or string or combination of both , but only the sku starting as a number is imported for instance 199 is added while C199 is not added similarly 201C is added but BP104 is not added, any ideas

Doesn't sound right.  Step through the ImportProductsFromXls code found in the ImportManager.cs found in Libraries/nop.Services/ExportImport folder.

Make sure there is an apostrophe before the SKU otherwis it won't import the SKU

With apostrophe it imports fine

I have a macro I use for the apostrophe if you want it.

thrifty34 wrote:

Yeh that will be great :)

Macro 1 for SKU


Sub Add_Apostrophe()
Dim rng As Range
Set rng = Range("K2:K" & Range("K65536").End(xlUp).Row)
For Each cell In rng
cell.Select
If cell.Value <> "" Then
cell.Value = "'" & cell.Value
End If
Next
End Sub

Macro 2 for MPN



Sub Add_Apostrophe()
Dim rng As Range
Set rng = Range("L2:L" & Range("L65536").End(xlUp).Row)
For Each cell In rng
cell.Select
If cell.Value <> "" Then
cell.Value = "'" & cell.Value
End If
Next
End Sub