exportimportmagento-1.9products-management
Importing gallery images seems like such a fundamental function, but I cannot find any column in my csv exported file where I would do this.
I created a single product with gallery images through magento's backend and then exported into csv and even those gallery images are nowhere to be found in the csv file.
what am I missing?
First you have to upload alll the images you want to import in the media/import/yourimagesfolder/
The in the CSV columns for image, thumbnail and small_image your image path should look like this
/yourimagefolder/imagename.jpg
You do not need these columns, the only required columns you need are the attributes that are required in the backend.
So in a base install of Magento, you need "description", "name", "price", "sku", "status", "tax_class_id", "visibility", and "weight". Below is a picture of the required options in a clean install of Magento EE 1.14 (so there are a few additional required fields as you can see).
Many developers, will delete these columns from the CSV if we are not using them.
I would suggest using OpenOffice to create your CSV and make sure you select the option to "quote all text fields". Microsoft Excel can work, however I have noticed a lot of formatting issues that can screw up data (especially if you use Office for Mac).
Best Answer
Just to clarify, I assume you are using the Import/Export module, NOT Dataflow. If you have been using Dataflow please try the same process with Import/Export module and see if your results improve.
This is definitely standard functionality - please see my linked CSV export from a fresh install of Magento CE 1.7.0.2 with sample data installed. Do a search for small_image and you'll find the correct columns:
There are also these columns for controlling the media gallery:
The Magento import/export is tricky, there's no two ways about it. There's basically no documentation and some quirks/bugs that can cause unexpected results. Everyone who knows how to use Mage_ImportExport has most likely spent hours crying into their keyboards at some stage.
That being said, it does work and it does work well once you know the tricks. If you could post your CSV here and maybe tell us if you've made any customisations to your Magento installation then the community will be able to better assist you.
Also, make sure you are not ticking any of the attribute 'skip' checkboxes when you are performing your export.