Skip to content

Product image failure when importing through CSV #20098

Closed
@flytomek

Description

@flytomek

Preconditions

  1. Magento 2.3.0
  2. PHP Version 7.2.13
  3. macOS Mojave 10.14.1
  4. release with no Sample Data
  5. Valid product image under remote URL http://www.tompetty.com/sites/g/files/g2000007521/f/styles/photo-carousel/public/sample1_1.jpg

Steps to reproduce

  1. Create CSV file
sku;store_view_code;attribute_set_code;product_type;categories;product_websites;name;description;short_description;weight;product_online;tax_class_name;visibility;price;special_price;special_price_from_date;special_price_to_date;url_key;meta_title;meta_keywords;meta_description;base_image;base_image_label;small_image;small_image_label;thumbnail_image;thumbnail_image_label;swatch_image;swatch_image_label;created_at;updated_at;new_from_date;new_to_date;display_product_options_in;map_price;msrp_price;map_enabled;gift_message_available;custom_design;custom_design_from;custom_design_to;custom_layout_update;page_layout;product_options_container;msrp_display_actual_price_type;country_of_manufacture;additional_attributes;qty;out_of_stock_qty;use_config_min_qty;is_qty_decimal;allow_backorders;use_config_backorders;min_cart_qty;use_config_min_sale_qty;max_cart_qty;use_config_max_sale_qty;is_in_stock;notify_on_stock_below;use_config_notify_stock_qty;manage_stock;use_config_manage_stock;use_config_qty_increments;qty_increments;use_config_enable_qty_inc;enable_qty_increments;is_decimal_divided;website_id;related_skus;related_position;crosssell_skus;crosssell_position;upsell_skus;upsell_position;additional_images;additional_image_labels;hide_from_product_page;custom_options;bundle_price_type;bundle_sku_type;bundle_price_view;bundle_weight_type;bundle_values;bundle_shipment_type;configurable_variations;configurable_variation_labels;associated_skus
b18-r1t01-w0-0m;;Default;virtual;;base;R1 anniversary print T-shirt M;;;;1;Taxable Goods;Not Visible Individually;25.9500;;;;r1-anniversary-print-t-shirt-m;R1 anniversary print T-shirt;;R1 anniversary print T-shirt;;;;;;;;;1/5/19, 1:55 PM;1/5/19, 2:04 PM;;;Block after Info Column;;;;No;;;;;;;;;size=M;999.0000;0.0000;1;0;0;1;1.0000;1;10000.0000;1;1;1.0000;1;1;1;1;1.0000;1;0;0;0;;;;;;;;;;;;;;;;;;;
b18-r1t01-w0-0l;;Default;virtual;;base;R1 anniversary print T-shirt L;;;;1;Taxable Goods;Not Visible Individually;26.9500;;;;r1-anniversary-print-t-shirt-l;R1 anniversary print T-shirt;;R1 anniversary print T-shirt;;;;;;;;;1/5/19, 1:55 PM;1/5/19, 2:04 PM;;;Block after Info Column;;;;No;;;;;;;;;size=L;999.0000;0.0000;1;0;0;1;1.0000;1;10000.0000;1;1;1.0000;1;1;1;1;1.0000;1;0;0;0;;;;;;;;;;;;;;;;;;;
b18-r1t01-w0-1l;;Default;virtual;;base;R1 anniversary print T-shirt XL;;;;1;Taxable Goods;Not Visible Individually;29.9500;;;;r1-anniversary-print-t-shirt-xl;R1 anniversary print T-shirt;;R1 anniversary print T-shirt;;;;;;;;;1/5/19, 1:55 PM;1/5/19, 2:03 PM;;;Block after Info Column;;;;No;;;;;;;;;size=XL;999.0000;0.0000;1;0;0;1;1.0000;1;10000.0000;1;1;1.0000;1;1;1;1;1.0000;1;0;0;0;;;;;;;;;;;;;;;;;;;
@b18-r1t01-w0-0l;;Default;configurable;;base;R1 anniversary print T-shirt;;;;1;Taxable Goods;Catalog, Search;;;;;r1-anniversary-print-t-shirt;R1 anniversary print T-shirt;;R1 anniversary print T-shirt;http://www.tompetty.com/sites/g/files/g2000007521/f/styles/photo-carousel/public/sample1_1.jpg;;http://www.tompetty.com/sites/g/files/g2000007521/f/styles/photo-carousel/public/sample1_1.jpg;;http://www.tompetty.com/sites/g/files/g2000007521/f/styles/photo-carousel/public/sample1_1.jpg;;;;1/5/19, 1:55 PM;1/5/19, 1:55 PM;;;Block after Info Column;;;;Use config;;;;;;;;;;0.0000;0.0000;1;0;0;1;1.0000;1;10000.0000;1;1;1.0000;1;1;1;1;1.0000;1;0;0;0;;;;;;;http://www.tompetty.com/sites/g/files/g2000007521/f/styles/photo-carousel/public/sample1_1.jpg;;;;;;;;;;sku=b18-r1t01-w0-0m,size=M|sku=b18-r1t01-w0-0l,size=L|sku=b18-r1t01-w0-1l,size=XL;size=Size;
  1. Go to System > Import with following settings:
Entity Type - products
Import Behavior - add/update
Stop on error
Allowed Errors Count - 10
Field separator - ;
Multiple value separator - ,
Empty attribute value constant - __EMPTY__VALUE__
Fields enclosure - unchecked
Images File Directory - blank

and select CSV file

Expected result

  1. Import 3 virtual products and one configurable product with image

Actual result

  1. When importing: Following Error(s) has been occurred during importing process: 1. Imported resource (image) could not be downloaded from external resource due to timeout or access permissions in row(s): 4
  2. Products are imported but configurable product has no image in Magento (however image has been successfully uploaded to pub/media/import)


Metadata

Metadata

Labels

Component: ImportExportFixed in 2.2.xThe issue has been fixed in 2.2 release lineFixed in 2.3.xThe issue has been fixed in 2.3 release lineIssue: Clear DescriptionGate 2 Passed. Manual verification of the issue description passedIssue: ConfirmedGate 3 Passed. Manual verification of the issue completed. Issue is confirmedIssue: Format is validGate 1 Passed. Automatic verification of issue format passedIssue: Ready for WorkGate 4. Acknowledged. Issue is added to backlog and ready for developmentReproduced on 2.3.xThe issue has been reproduced on latest 2.3 release

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions