Bugs

Topic for reporting any problems and bugs.

IMPORTANT NOTE: There is a known issues with installing new plugins in nopCommerce.
Please read this post for more information.

TEMPLATE: Product Attribute Combination
PROBLEM: not import OverriddenPrice record

When debugging is ebabled the following message appears in the log file

“- old value=, imported value=331, imported (updated) value=331  Error (property=OverriddenPrice)
   Exception=Invalid cast from 'System.String' to 'System.Nullable`1[[System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'.”

In addition, the schedule tab is visible in the documentation page but not appears in the installed plugin.


TEMPLATE: Product Attribute Value
PROBLEM: not import ProductAttribute if name is not present (Empty)

Download the new release.
I have solved it.
Thank you for report about this bug.

thanks a lot!

Support wrote:

thanks a lot!

I have two other problems

When I import product attributes I have to change the value of:
Is Required
Control type
Which parameter needs to be configured?


when I import 4 images it imports the first and the last.

this is the log

2020.03.04 12:25:18:9063*******
ExecuteImportBase. importTemplate.Id=10, fake=False
2020.03.04 12:25:18:9068*******
FolderHelper.GetFiles. importTemplate.Id=10, feedFolder=C:\sviluppo\factory\FilesForImport\Importazione\Collars\ASCOT\Test\ImportImmagini.xlsx, importTemplate.FeedFolder=C:\sviluppo\factory\FilesForImport\Importazione\Collars\ASCOT\Test\ImportImmagini.xlsx
2020.03.04 12:25:18:9072*******
FolderHelper.GetFiles. importTemplate.Id=10, feedFolder=C:\sviluppo\factory\FilesForImport\Importazione\Collars\ASCOT\Test\ImportImmagini.xlsx, pattern=ImportImmagini.xlsx, folder=C:\sviluppo\factory\FilesForImport\Importazione\Collars\ASCOT\Test
2020.03.04 12:25:18:9081*******
ExecuteImportBase (list of files). importTemplate.Id=10
   C:\sviluppo\factory\FilesForImport\Importazione\Collars\ASCOT\Test\ImportImmagini.xlsx

2020.03.04 12:25:18:9085*******
ImportImportTemplate. (try to read the one file) importTemplate.Id=10, file=C:\sviluppo\factory\FilesForImport\Importazione\Collars\ASCOT\Test\ImportImmagini.xlsx
2020.03.04 12:25:18:9090*******
ImportImportTemplate. (the file was read) importTemplate.Id=10, file=C:\sviluppo\factory\FilesForImport\Importazione\Collars\ASCOT\Test\ImportImmagini.xlsx
2020.03.04 12:25:18:9110*******
PrepareColumnMappings. importTemplate.Id=10
   colMap.Key=Key, ColumnSourceId=1, ColumnSourceName=1
   colMap.Key=Picture, ColumnSourceId=4, ColumnSourceName=4
   colMap.Key=DisplayOrder, ColumnSourceId=5, ColumnSourceName=5

2020.03.04 12:25:18:9151*******
ReadOneRowItemsFromList. step 4. importTemplate.Id=10, file=C:\sviluppo\factory\FilesForImport\Importazione\Collars\ASCOT\Test\ImportImmagini.xlsx, key=ASCOT-1622, rowNumber=2
New values
   'Key'-'ASCOT-1622'
   'Picture'-'c:\sviluppo\factory\ImagesForImport\Thumbs\0031438_ascot-collar-black-greased-leather-english-brass-finishing.jpeg'
   'DisplayOrder'-'1'

2020.03.04 12:25:18:9155*******
ReadOneRowItemsFromList. step 4. importTemplate.Id=10, file=C:\sviluppo\factory\FilesForImport\Importazione\Collars\ASCOT\Test\ImportImmagini.xlsx, key=ASCOT-1622, rowNumber=3
New values
   'Key'-'ASCOT-1622'
   'Picture'-'c:\sviluppo\factory\ImagesForImport\Thumbs\0031439_ascot-collar-black-greased-leather-english-brass-finishing.jpeg'
   'DisplayOrder'-'2'

2020.03.04 12:25:18:9159*******
ReadOneRowItemsFromList. step 4. importTemplate.Id=10, file=C:\sviluppo\factory\FilesForImport\Importazione\Collars\ASCOT\Test\ImportImmagini.xlsx, key=ASCOT-1622, rowNumber=4
New values
   'Key'-'ASCOT-1622'
   'Picture'-'c:\sviluppo\factory\ImagesForImport\Thumbs\0031440_ascot-collar-black-greased-leather-english-brass-finishing.jpeg'
   'DisplayOrder'-'3'

2020.03.04 12:25:18:9163*******
ReadOneRowItemsFromList. step 4. importTemplate.Id=10, file=C:\sviluppo\factory\FilesForImport\Importazione\Collars\ASCOT\Test\ImportImmagini.xlsx, key=ASCOT-1622, rowNumber=5
New values
   'Key'-'ASCOT-1622'
   'Picture'-'c:\sviluppo\factory\ImagesForImport\Thumbs\0031441_ascot-collar-black-greased-leather-english-brass-finishing.jpeg'
   'DisplayOrder'-'4'

2020.03.04 12:25:19:0347*******
ImportManagerProcessing.XML. importTemplate.Id=10, file=C:\sviluppo\factory\FilesForImport\Importazione\Collars\ASCOT\Test\ImportImmagini.xlsx, byteArray.count()=8324
  - MemoryStream was created
  - step 1
  - rowNumber=1
  - rowNumber=2
  - rowNumber=3
  - rowNumber=4
  - rowNumber=5

2020.03.04 12:25:19:0352*******
ImportImportTemplate. (the column list was read) importTemplate.Id=10, file=C:\sviluppo\factory\FilesForImport\Importazione\Collars\ASCOT\Test\ImportImmagini.xlsx, row.I

About import pictures.

Plugin checks if this picture was imported early. Plugin doesn't allow to import the same picture twice for one product. It's protection.

About import product attributes.
Is Required  - try to use IsRequired
Control type  - try to use AttributeControlTypeId

Support wrote:

As you see in the log the 4 filenames of the images are different

'Picture'-'c:\sviluppo\factory\ImagesForImport\Thumbs\0031438_ascot-collar-black-greased-leather-english-brass-finishing.jpeg'

'Picture'-'c:\sviluppo\factory\ImagesForImport\Thumbs\0031439_ascot-collar-black-greased-leather-english-brass-finishing.jpeg'

'Picture'-'c:\sviluppo\factory\ImagesForImport\Thumbs\0031440_ascot-collar-black-greased-leather-english-brass-finishing.jpeg'

'Picture'-'c:\sviluppo\factory\ImagesForImport\Thumbs\0031441_ascot-collar-black-greased-leather-english-brass-finishing.jpeg'



Support wrote:

What is the template were I can see   IsRequired abd AttributeControlTypeId
I use the template (Product Attribute Value) and I don't find it.

thanks

Product Attribute Value
doesn't have such columns.
You can check the nopcommerce class itself

nopCommerce_4.20_Source\Libraries\Nop.Core\Domain\Catalog\ProductAttributeValue.cs


Pictures.
Plugin checks the picture hash of the file.
Please check and write me if you have real different four pictures.
If you see different 4 different picture you need to write me and I'll investigate this issue.

[quote=Support]Product Attribute Value
doesn't have such columns.
You can check the nopcommerce class itself

nopCommerce_4.20_Source\Libraries\Nop.Core\Domain\Catalog\ProductAttributeValue.cs


Before updating the plugin to the latest version, the program imported all the images correctly. Even the same image with different names.
This probably happened because the "Import product images using hash" parameter under "Settings-Media Settings" was not set. Now it only imports 2 images in both cases.

Here are the hashes of the files

SHA1  445F2A97DADF60D660DBAEFA0600D46EAE65ECAF  C:\Users\linda\Desktop\ImgCollar\0031438_ascot-collar-black-greased-leather-english-brass-finishing.jpeg
SHA1  CAC4C0DEF57BECE4C7B890144D7E006553CF16B0  C:\Users\linda\Desktop\ImgCollar\0031439_ascot-collar-black-greased-leather-english-brass-finishing.jpeg
SHA1  1A69E8F867E197A6500075CACD15C6CF7CF3F66F  C:\Users\linda\Desktop\ImgCollar\0031440_ascot-collar-black-greased-leather-english-brass-finishing.jpeg
SHA1  CAB0F3C31FCC80310D1F71EBD2F9D6086F772FC5  C:\Users\linda\Desktop\ImgCollar\0031441_ascot-collar-black-greased-leather-english-brass-finishing.jpeg

SHA256  444E11B1B427893B64B0356057E3CA54AE1E4B5D2FE2D574DE7EA5FDE9A7561A  C:\Users\linda\Desktop\ImgCollar\0031438_ascot-collar-black-greased-leather-english-brass-finishing.jpeg
SHA256  A415A8C6CEF942FDA11CF73DF454E91CFFA6582ED00FF66C430D055385D061B6  C:\Users\linda\Desktop\ImgCollar\0031439_ascot-collar-black-greased-leather-english-brass-finishing.jpeg
SHA256  06687A67F6326F45770188868FB6876AE1F5B7BFECE7839D02CE3F6D99C79576  C:\Users\linda\Desktop\ImgCollar\0031440_ascot-collar-black-greased-leather-english-brass-finishing.jpeg
SHA256  C726B9651DF74C4426BFD02D9AA713CDDD41F8431729D12C738A6FF42EF6D4BD  C:\Users\linda\Desktop\ImgCollar\0031441_ascot-collar-black-greased-leather-english-brass-finishing.jpeg

SHA384  0EBBA803F5308AB75FCD5E52C627B6908B93559439AC59D850B53A98A9049E9E7F1... C:\Users\linda\Desktop\ImgCollar\0031438_ascot-collar-black-greased-leather-english-brass-finishing.jpeg
SHA384  397290614C3ABDB3787605318EAE4C5AF19C7253606E5265E2E54872E33D95404C5... C:\Users\linda\Desktop\ImgCollar\0031439_ascot-collar-black-greased-leather-english-brass-finishing.jpeg
SHA384  835E29FA3BF369BAA5CAF324B43DACFBB8DDE94CA89F74933DB106698C4B69F6584... C:\Users\linda\Desktop\ImgCollar\0031440_ascot-collar-black-greased-leather-english-brass-finishing.jpeg
SHA384  951A2A93E5F2855B53D1207DB66D78969936244515192BAA1C04D86C7B15DC24D32... C:\Users\linda\Desktop\ImgCollar\0031441_ascot-collar-black-greased-leather-english-brass-finishing.jpeg

SHA512  83C9DCD88097C3BD40B440B1DC3D14216D5FBC62ACB13BE3E20A8054989C5072AED... C:\Users\linda\Desktop\ImgCollar\0031438_ascot-collar-black-greased-leather-english-brass-finishing.jpeg
SHA512  ADDB8372F61D4EF1275B01FC9323D29A0A3E22A02C2214558868FE8635551305F8F... C:\Users\linda\Desktop\ImgCollar\0031439_ascot-collar-black-greased-leather-english-brass-finishing.jpeg
SHA512  4944E0137BAFCAB7385B6A20E450D2BF26807ECF518775E6733D13B780378F4B77D... C:\Users\linda\Desktop\ImgCollar\0031440_ascot-collar-black-greased-leather-english-brass-finishing.jpeg
SHA512  81B19A5B10905C65C96F0FF5925FBE2C9BC10A1D935BCAA3A6D1FDDAC54AE823F49... C:\Users\linda\Desktop\ImgCollar\0031441_ascot-collar-black-greased-leather-english-brass-finishing.jpeg

MD5  B39546623A75CF28E7E2B0E3A595AB02  C:\Users\linda\Desktop\ImgCollar\0031438_ascot-collar-black-greased-leather-english-brass-finishing.jpeg
MD5  39EA0DAE7EC466002DB13324B5A49FB2  C:\Users\linda\Desktop\ImgCollar\0031439_ascot-collar-black-greased-leather-english-brass-finishing.jpeg
MD5  C2E8DE1A2EE672890D1866520C95F53E  C:\Users\linda\Desktop\ImgCollar\0031440_ascot-collar-black-greased-leather-english-brass-finishing.jpeg
MD5  F60AB47A0983EC2F53785F5DED1B3ACD  C:\Users\linda\Desktop\ImgCollar\0031441_ascot-collar-black-greased-leather-english-brass-finishing.jpeg



When I import the attributes for exampl

When I import the attributes for example "Size" I must be able to set "IsRequired" and the type es "Drop-down list".
By manually entering an attribute there are these two options in the "Info" tab. I looked at the source code of nopcommerce and they are located in Nop.Core / Domain / Catalog / ProductAttributeMapping.cs.

1. Pictures.
I did the new release, download it and try it.I added the new notification in the plugin log file.
You will see the hash of the new picture, nopcommerce kernel prepares picture (validate it and change the size) and you will see the hash of new validated picture too.
If plugin found such picture in the database than plugin will write you about and and point you about the same hash.
Please try the new release and write me about result.
I checked and I upload four pictures.

ImportPicture. picture=d:\qqqq\4.jpg, seoname=$25 Virtual Gift Card New updated, productId=43, pictureId=0
  pictures store in DB
  newImageHash=DC67A4BC4DDD6046E887638A8D7A1410101124D5
  newValidatedImageHash=B9EA9E82B18FD90341BE715953852C77470F169A
  This is a new picture.
picture.Id=134


2. Product Attribute Values
You write me about Product Attribute Mapping.
Nopcommerce has three tables:
Product Attribute
Product Attribute Mapping
Product Attribute Values

I added the template for importing Product Attribute Values.
If you need I can add template for Product Attribute Mapping.
Write me next week.

We tried to import the 4 images with the latest release but it still doesn't work. It appears that the plugin is unable to correctly calculate the hashes of some images. We tried to open and save the images with Potoshop without any modification and now the plugin correctly imports the images. Unfortunately we cannot proceed to edit all the images. We can provide you with a zip file with 2 types of the same image. The plugin only works by importing the images into the "P" folder.

The Log:

2020.03.06 17:10:51:2667*******
ImportManagerProcessing.XML. importTemplate.Id=10, file=C:\sviluppo\factory\FilesForImport\Importazione\Collars\ASCOT\Test\ImportImmagini.xlsx, byteArray.count()=8324
  - MemoryStream was created
  - step 1
  - rowNumber=1
  - rowNumber=2
  - rowNumber=3
  - rowNumber=4
  - rowNumber=5

2020.03.06 17:10:51:2672*******
ImportImportTemplate. (the column list was read) importTemplate.Id=10, file=C:\sviluppo\factory\FilesForImport\Importazione\Collars\ASCOT\Test\ImportImmagini.xlsx, row.Items.Count=4
2020.03.06 17:10:51:2692*******
ImportImportTemplate. Start update product using data from the file 'C:\sviluppo\factory\FilesForImport\Importazione\Collars\ASCOT\Test\ImportImmagini.xlsx'
2020.03.06 17:10:51:2695*******
ImportProductService. ImportEntity. row.Key=ASCOT-1622
2020.03.06 17:10:51:2700*******
ImportProductService. GetEntity. productKey=ASCOT-1622
2020.03.06 17:10:51:2725*******
ImportProductService. GetEntity. (Check conditions) productKey=ASCOT-1622, products.Count()=1
2020.03.06 17:10:51:2728*******
ImportProductService. GetEntity. (After Check conditions) productKey=ASCOT-1622, products.Count()=1
2020.03.06 17:10:51:5011*******
ImportPicture. picture=c:\sviluppo\factory\ImagesForImport\Thumbs\0031438_ascot-collar-black-greased-leather-english-brass-finishing.jpeg, seoname=ASCOT COLLAR BLACK GREASED LEATHER ENGLISH BRASS FINISHING, productId=22, pictureId=0
picture.Id=111

2020.03.06 17:10:51:5109*******
ImportProductService. ImportEntity. row.Key=ASCOT-1622
    picture was added Id=111
    Finish

2020.03.06 17:10:51:5113*******
ImportProductService. ImportEntity. row.Key=ASCOT-1622
2020.03.06 17:10:51:5117*******
ImportProductService. GetEntity. productKey=ASCOT-1622
2020.03.06 17:10:51:5131*******
ImportProductService. GetEntity. (Check conditions) productKey=ASCOT-1622, products.Count()=1
2020.03.06 17:10:51:5134*******
ImportProductService. GetEntity. (After Check conditions) productKey=ASCOT-1622, products.Count()=1
2020.03.06 17:10:51:6127*******
ImportPicture. picture=c:\sviluppo\factory\ImagesForImport\Thumbs\0031439_ascot-collar-black-greased-leather-english-brass-finishing.jpeg, seoname=ASCOT COLLAR BLACK GREASED LEATHER ENGLISH BRASS FINISHING, productId=22, pictureId=0
  pictures store in DB
  newImageHash=38552187063728DCE0D3FD93D9CD3D25E2F73A3E
  newValidatedImageHash=D339DBDDAFEBCDFF130D88ABD1E5E04F0286E0F6
  The picture was loaded before
  The list of old pictures
  D339DBDDAFEBCDFF130D88ABD1E5E04F0286E0F6 = (newValidatedImageHash)

2020.03.06 17:10:51:6132*******
ImportProductService. ImportEntity. row.Key=ASCOT-1622
    Finish

2020.03.06 17:10:51:6136*******
ImportProductService. ImportEntity. row.Key=ASCOT-1622
2020.03.06 17:10:51:6139*******
ImportProductService. GetEntity. productKey=ASCOT-1622
2020.03.06 17:10:51:6154*******
ImportProductService. GetEntity. (Check conditions) productKey=ASCOT-1622, products.Count()=1
2020.03.06 17:10:51:6158*******
ImportProductService. GetEntity. (After Check conditions) productKey=ASCOT-1622, products.Count()=1
2020.03.06 17:10:51:7137*******
ImportPicture. picture=c:\sviluppo\factory\ImagesForImport\Thumbs\0031440_ascot-collar-black-greased-leather-english-brass-finishing.jpeg, seoname=ASCOT COLLAR BLACK GREASED LEATHER ENGLISH BRASS FINISHING, productId=22, pictureId=0
  pictures store in DB
  newImageHash=818CF6C82A3F0329D7B91B94BFB211253C82E6AD
  newValidatedImageH

I want to explain the login of this lines

ImportPicture. picture=c:\sviluppo\factory\ImagesForImport\Thumbs\0031439_ascot-collar-black-greased-leather-english-brass-finishing.jpeg, seoname=ASCOT COLLAR BLACK GREASED LEATHER ENGLISH BRASS FINISHING, productId=22, pictureId=0
  pictures store in DB
  newImageHash=38552187063728DCE0D3FD93D9CD3D25E2F73A3E
  newValidatedImageHash=D339DBDDAFEBCDFF130D88ABD1E5E04F0286E0F6
  The picture was loaded before
  The list of old pictures
  D339DBDDAFEBCDFF130D88ABD1E5E04F0286E0F6 = (newValidatedImageHash)

This picture file
c:\sviluppo\factory\ImagesForImport\Thumbs\0031439_ascot-collar-black-greased-leather-english-brass-finishing.jpeg

has this hashcode
38552187063728DCE0D3FD93D9CD3D25E2F73A3E

After it plugin calls nopcommerce internal method for resize picture (nopcommerce has limitations for picture width) and this new changed picture has this hashcode
D339DBDDAFEBCDFF130D88ABD1E5E04F0286E0F6

Next step. Plugin  reads existing pictures for this product from  SQL database and calculates hashcode code them.
One of picture has the same hashcode (new changed picture).

  The list of old pictures
  D339DBDDAFEBCDFF130D88ABD1E5E04F0286E0F6 = (newValidatedImageHash)

It's very strange that this product has other picture with the same hascode.
Can you check existing pictures again?

Support wrote:

The “Product Attribute Mapping” template does not work during the update.
It only works in the insert phase, that is when you import the values of a new product.

Yes, it was a bug.
Plugin doesn't update existing Product Attribute Mapping table.
I have solved this issue.
Download and try the new release.

I didn't solve the issues with pictures.
Thank you for these four pictures.