Skip to content

Attribute image exceeded max length in row(s) when importing images from Amazon.com with CSV file #15679

Open
@GoogleYY

Description

@GoogleYY

Preconditions

  1. Win 7 / CentOS Linux release 7.4.1708
  2. PHP Version 7.0.28
    3.Magento ver. 2.2.4
    4.Luma blank theme without sample data

Steps to reproduce

  1. Log into backend panel
  2. Go to System->Import
  3. Select products as Entity Type option, select Add/Update as Import Behavior, Select Stop on Error, Allowed Errors Count is 10,Field separator is Comma(,) ,Multiple value separator is Comma(,) , Fields enclosure filed is empty.
    4.Select File to Import
    5.Images File Directory left blank (As the images were going to fetch from Amazon.com)
    6.Click Check Data

Expected result

  1. It should be 0 errors.

Actual result

error

  1. Attribute image exceeded max length in row(s): 1, 3, 4, 6

Further steps to reproduce
I tried changing the data const DB_MAX_VARCHAR_LENGTH from 256 to 512 in MagentoRootFile\vendor\magento\module-import-export\Model\Import\AbstractEntity.php and then run the commands php bin/magento setup:upgrade and php bin/magento cache:flush respectively. The errors still exists

The text content of base_image column is:
https://images-na.ssl-images-amazon.com/images/I/61btlFPdvBL._SL1000_.jpg,https://images-na.ssl-images-amazon.com/images/I/51I%2Bhf88F7L._SL1000_.jpg,https://images-na.ssl-images-amazon.com/images/I/51y0P8C5-2L._SL1000_.jpg,https://images-na.ssl-images-amazon.com/images/I/51uwDQfaHrL._SL1000_.jpg,https://images-na.ssl-images-amazon.com/images/I/61Wh7FkyNYL._SL1000_.jpg

Metadata

Metadata

Assignees

No one assigned

    Labels

    Area: Import / exportComponent: CatalogImportExportIssue: ConfirmedGate 3 Passed. Manual verification of the issue completed. Issue is confirmedPriority: P2A defect with this priority could have functionality issues which are not to expectations.Progress: PR in progressReproduced on 2.2.xThe issue has been reproduced on latest 2.2 releaseReproduced on 2.3.xThe issue has been reproduced on latest 2.3 releaseReproduced on 2.4.xThe issue has been reproduced on latest 2.4-develop branchSeverity: S2Major restrictions or short-term circumventions are required until a fix is available.up for grabs

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions