You have no items in your shopping cart.

Profile: m.cattaneo

Avatar
Statistics
    Bugs

    Support wrote:


    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.


    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.
    4 years ago
    Bugs

    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

    4 years ago
    Bugs

    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.

    4 years ago
    Bugs

    [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

    4 years ago
    Bugs

    Support wrote:

    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.


    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:

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


    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
    4 years ago
    Bugs

    Support wrote:

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


    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
    4 years ago
    Bugs

    thanks a lot!

    4 years ago
    Bugs

    Support wrote:

    I don't plan to add scheduler to Import Manager and Price Manager.

    But I'll see how to update product combination price using this plugin "Automatic Updates".
    Write me after two days.


    Hi, I write you to remember this post:
    In PLUGIN: AUTOMATIC UPDATES It is possible to add import price (OverriddenPrice) in attribute combinations?
    thanks
    4 years ago
    Bugs

    I ask you a litte feature:

    "Import Manager" imports the values ​​of the Overridden Price but have not a scheduler.
    "Price Manager" does not have a scheduler.
    "Automatic Updates" has the schedule, but does not allow updating the prices that belong to the product combinations(OverriddenPrice)

    It is possible to add a scheduler to "Price Manager" or allow updating  Overridden Price in "Automatic Updates" ?
    thanks

    4 years ago
    Bugs

    PROBLEM: not import price (OverriddenPrice) in attribute combinations

    4 years ago

    Powered by nopCommerce

    Copyright © 2023 FoxNetSoft. All rights reserved