Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

New Extension: Product Gallery Importer - lets you import products with multiple product images from a CSV file
 
hyteckit
Sr. Member
 
Avatar
Total Posts:  166
Joined:  2008-04-01
Los Angeles, CA
 

Okay, the extension is available now.

Product Gallery Importer

Product Gallery Importer lets you import products with multiple product images from a CSV file.

The CSV file containing all the products you wish to import should have a field name “gallery”. The field “gallery” should contain all the images you want to show up in the product gallery. Each image should be delimited by a semicolon: ‘;’

Once you installed the extension, you’ll need to set up an advanced import profile in order to use the Product Gallery Importer.  Go to your admin panel and select System->Import/Export->Advanced Profiles.  Click on the “Add New Profile” to create a new profile.

In the Profile Name field, enter “Import Product Gallery” or whatever you want.

In the Actions XML field, enter the following:

<action type="dataflow/convert_adapter_io" method="load">
    <var 
name="type">file</var>
    <var 
name="path">var/import</var>
    <var 
name="filename"><![CDATA[exported_products.csv]]></var>
    <var 
name="format"><![CDATA[csv]]></var>
</
action>

<
action type="dataflow/convert_parser_csv" method="parse">
    <var 
name="delimiter"><![CDATA[,]]></var>
    <var 
name="enclose"><![CDATA["]]></var>
    <var name="
fieldnames">true</var>
    <var name="
number_of_records">1</var>
    <var name="
decimal_separator"><![CDATA[.]]></var>
    <var name="
adapter">catalog/convert_adapter_gallery</var>
    <var name="
method">parse</var>
</action>

Save the profile by clicking on “Save and Continue Editing” button.  Before you can start importing, make sure you have the CSV file in the correct location and is name correctly.

The ‘exported_products.csv’ is the name of the CSV file you want to import.  Place the CSV file ‘exported_products.csv’ with all the products you want to import into the folder ‘var/import/’.

When you CSV is ready and in place, click on the “Run Profile in Popup” button and watch your products and product gallery get imported to the database.

NOTES:

This extension lets you add an extra gallery filed in your product CSV file that you wish to import.  The gallery field would contain all your images delimited by the semicolon: ‘;’

For example:

/path/to/image1;/path/to/image2;/path/to/image3

If images are missing or cannot be found, the product would not be imported.

 
Magento Community Magento Community
Magento Community
Magento Community
 
hyteckit
Sr. Member
 
Avatar
Total Posts:  166
Joined:  2008-04-01
Los Angeles, CA
 

More notes:

Imported gallery images are not set to be “excluded” so they’ll show up in the product gallery.  Default image, small image, and thumbnail image will be set to be “excluded” by default so it doesn’t show up in the gallery.

So don’t worry about Default image, small image, and thumbnail image duplicating an images in gallery.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Ben Marks
Moderator
 
Avatar
Total Posts:  452
Joined:  2008-10-09
Charleston, SC
 

Eh… the extension installs in app/code/core/Mage ?

 
Magento Community Magento Community
Magento Community
Magento Community
 
simplydebest
Jr. Member
 
Total Posts:  3
Joined:  2009-08-15
 

I get an error;

Declared adapter catalog/convert_adapter_gallery not found

Could anyone have an idea whats wrong?

 
Magento Community Magento Community
Magento Community
Magento Community
 
rodgerlvu
Jr. Member
 
Total Posts:  2
Joined:  2009-05-14
 
simplydebest - 29 August 2009 05:03 AM

I get an error;

Declared adapter catalog/convert_adapter_gallery not found

Could anyone have an idea whats wrong?

yes. i got the same error as you..do you know how to correct it now? thanks in advance:)

Rodger

 
Magento Community Magento Community
Magento Community
Magento Community
 
Jyoti Sangolkar
Jr. Member
 
Avatar
Total Posts:  1
Joined:  2010-08-27
Nagpur
 


Hey.,I got the solution for this

1)add all the images to the folder ( /media/import/ ) which u want to upload..
2)in the csv file,in the image field,simply add \"backslash(/)(your image name)\”..
3)and now import the sheet in the normal way..i.e.system -> import/export -> profiles,
4)upload the newly made csv file...and run profile in popup..thats all..


u will find the images are getting uploaded.. smile

DONE!!!

 
Magento Community Magento Community
Magento Community
Magento Community
 
swivvle
Jr. Member
 
Total Posts:  1
Joined:  2009-09-21
 

Anyone know of a way to use an external link for a product image in Magento?

I have a supplier who gives a CSV file with all the images hosted on their servers, it would be nice to be able to upload the file using the external URLs for the images. Please let me know if someone has a solution for this, I have been searching up and down!

 
Magento Community Magento Community
Magento Community
Magento Community
 
dweeves
Enthusiast
 
Total Posts:  877
Joined:  2010-06-26
FRANCE
 

magmi can do that, and much more !!!!!
go check the huge thread

 
Magento Community Magento Community
Magento Community
Magento Community
 
blupark
Jr. Member
 
Avatar
Total Posts:  18
Joined:  2010-03-29
 
Jyoti Sangolkar - 08 November 2010 02:14 AM


Hey.,I got the solution for this

1)add all the images to the folder ( /media/import/ ) which u want to upload..
2)in the csv file,in the image field,simply add \"backslash(/)(your image name)\”..
3)and now import the sheet in the normal way..i.e.system -> import/export -> profiles,
4)upload the newly made csv file...and run profile in popup..thats all..


u will find the images are getting uploaded.. smile

DONE!!!

Can you be more clear on the comment backslash?

 
Magento Community Magento Community
Magento Community
Magento Community
 
TRMMarketing
Sr. Member
 
Avatar
Total Posts:  145
Joined:  2009-11-29
 

Is this extension working in 1.6 CE?

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top