Geek Answers Handbook

Magento imports image products

I tried all day importing some products into Magento, but all without success. After trial and error, everything ended with the error "Image does not exist." I read a few posts about this, most of them are outdated, but then a recent one talks about putting everything in /media/import and having all the files named /image.png in the CSV file.

This does not work, and I still get the same error.

I am using Magento 1.6.2 and I tried to put files in

 /var/import/image.png /var/import/i/m/image.png /media/import/image.png /media/import/i/m/image.png /media/catalog/product/i/m/image.png

I tried to name the file in CSV as

 /image.png /1/m/image.png /media/import/image.png /media/import/i/m/image.png

... and the totality of them all (it’s not entirely accurate which of them I used at the beginning with a random approach, trying to offer forums, but without any luck). I tried to find the PHP code snippet where the image file was installed, but failed ... again.

So, what folder is the importer looking for the file anyway? What is the way to do this? There are many people with the same problem, and this does not seem to be an official solution to this. Any help was appreciated.

+8
import csv magento
source share
3 answers

I ftp'd the image in media / import, and then in the actual CSV file, the image was /image.jpg.

Here is an example of my working CSV import file. I wrote a php script to hash a database that fed our directory then and collected the result below. For his work it took a lot of trial and error. Make mysqldump before trying to import so that you can fix errors with recovery.

 "sku"|"price"|"special_price"|"brand"|"weight"|"cost"|"name"|"section"|"description"|"short_description"|"make"|"fitment"|"product_name"|"store"|"websites"|"attribute_set"|"type"|"has_options"|"gift_message_available"|"custom_design"|"options_container"|"image_label"|"small_image_label"|"thumbnail_label"|"page_layout"|"meta_keyword"|"custom_layout_update"|"manufacturer"|"color"|"status"|"tax_class_id"|"visibility"|"enable_googlecheckout"|"is_recurring"|"is_imported"|"special_to_date"|"custom_design_from"|"custom_design_to"|"news_from_date"|"news_to_date"|"qty"|"min_qty"|"use_config_min_qty"|"is_qty_decimal"|"backorders"|"use_config_backorders"|"min_sale_qty"|"use_config_min_sale_qty"|"max_sale_qty"|"use_config_max_sale_qty"|"is_in_stock"|"low_stock_date"|"notify_stock_qty"|"use_config_notify_stock_qty"|"manage_stock"|"use_config_manage_stock"|"stock_status_changed_automatically"|"use_config_qty_increments"|"qty_increments"|"use_config_enable_qty_increments"|"enable_qty_increments"|"store_id"|"product_type_id"|"product_status_changed"|"product_changed_websites"|"material"|"category_ids"|"image"|"small_image"|"thumbnail" "TEE BLACK LONG LG"|"28.41"|"25.00"|""|"0.60"|"12.15"|"Ca Cycleworks Lg black cotton longsleeve logo t-shirt Cycleworks Brand Gear!!"|""|"Ca Cycleworks Lg black cotton longsleeve logo t-shirt Cycleworks Brand Gear!! for Ducati Everyone"|" Ducati Everyone"|""|""|"Ca Cycleworks Lg black cotton longsleeve logo t-shirt Cycleworks Brand Gear!!"|"admin"|"base"|"Other Accessories"|"simple"|"0"|"Use config"|""|"Block after Info Column"|""|""|""|"No layout updates"|""|""|""|""|"Enabled"|"None"|"Catalog, Search"|"Yes"|"No"|"Yes"|""|""|""|""|""|"1.0000"|"0.0000"|"1"|"0"|"0"|"1"|"1.0000"|"1"|"0.0000"|"1"|"1"|""|""|"1"|"0"|"1"|"0"|"1"|"0.0000"|"1"|"0"|"0"|"simple"|""|""|""|"36"|"/tee.jpg"|"/tee_sm.jpg"|"/tee_th.jpg" "LANYARD"|"2.27"|"2.00"|""|"0.05"|"1.05"|"Ca Cycleworks Cycleworks lanyard Cycleworks Brand Gear!!"|""|"Ca Cycleworks Cycleworks lanyard Cycleworks Brand Gear!! for Ducati Everyone"|" Ducati Everyone"|""|""|"Ca Cycleworks Cycleworks lanyard Cycleworks Brand Gear!!"|"admin"|"base"|"Other Accessories"|"simple"|"0"|"Use config"|""|"Block after Info Column"|""|""|""|"No layout updates"|""|""|""|""|"Enabled"|"None"|"Catalog, Search"|"Yes"|"No"|"Yes"|""|""|""|""|""|"1.0000"|"0.0000"|"1"|"0"|"0"|"1"|"1.0000"|"1"|"0.0000"|"1"|"1"|""|""|"1"|"0"|"1"|"0"|"1"|"0.0000"|"1"|"0"|"0"|"simple"|""|""|""|"36"|"/"|"/_sm"|"/_th" "PVC TAPE"|"13.64"|"12.00"|""|"0.50"|"1.05"|"Ca Cycleworks White pvc duck tape - all 4 panes - 2in x 110yds Cycleworks Brand Gear!!"|""|"Ca Cycleworks White pvc duck tape - all 4 panes - 2in x 110yds Cycleworks Brand Gear!! for Ducati Everyone"|" Ducati Everyone"|""|""|"Ca Cycleworks White pvc duck tape - all 4 panes - 2in x 110yds Cycleworks Brand Gear!!"|"admin"|"base"|"Other Accessories"|"simple"|"0"|"Use config"|""|"Block after Info Column"|""|""|""|"No layout updates"|""|""|""|""|"Enabled"|"None"|"Catalog, Search"|"Yes"|"No"|"Yes"|""|""|""|""|""|"1.0000"|"0.0000"|"1"|"0"|"0"|"1"|"1.0000"|"1"|"0.0000"|"1"|"1"|""|""|"1"|"0"|"1"|"0"|"1"|"0.0000"|"1"|"0"|"0"|"simple"|""|""|""|"36"|"/ductape.jpg"|"/ductape_sm.jpg"|"/ductape_th.jpg"
+9
source share

For those who have missed Magento's endless errors from the Dataflow profile boxes and are considering paid solutions: check this one out . With it, you simply avoid attracting 99% of popular errors when importing products with images:

- not a problem of the specification symbol (as it will happen through the online CSV editor)

- there are no problems with the wrong paths (you can set the path by which you want to receive images in the settings, if there is no image - the log will immediately inform you about this)

- there is no problem with multiple images: you can import the small_image, thumbnail, image fields along with the "media_gallery" field containing several paths separated by a semicolon.

In addition, it can EXPORT, so if something goes wrong and you cannot understand what happened - just create your product manually, upload the image manually using magento admin, and then just EXPORT this product. It will fill in the CSV with the correct image paths, it will also copy all the necessary images to the folder that you set in the settings, like the "media folder". That way, you can import them back without worrying about whether the images are in the correct folders.

I know that most people are looking for free materials, but if you have already spent a dozen hours fighting Dataflow in order to achieve the simple task of mass assigning images to products - I'm sure you understand what I'm talking about :)

+1
source share

In my case, I need to import 10,000 records with the same image.

After a google search, but that didn't work. I have to collect all the resolvers and it will work. My resolver:

  • minimal attributes:

    store, sku , qty, is_in_stock, attribute_set, description, model, price, tax_class_id, visibility, websites, weight, status, type, short_description, name, category_ids, image, small_image, s

You can see two "sku". one is a symbol and the other is a number. I do not know why. But when I delete the last. he shows that "the image does not exist." Maybe this is sku for the image if the name of the images is the same.

  • Create import folder in $ MAGENTO_HOME / media / var
  • Upload your images to this warehouse using ftp / scp.
  • in the csv file: add / name_image.jpg (PNG or any format images that you upload)

It will match uploaded images.

therefore upon import. error "image does not exist.

0
source share

More articles:


All Articles