Custom Export Profiles
You’ve just exported your Magento products to a csv file and opened it up in Open Office or Excel to find that all the commas that once separated the different categories that each product is a part of have disappeared. You’re left with one, long number that if uploaded will mess up the very existence of your shop. That’s where creating your own export profile comes in handy, because you can simply tell it not to export categories – and just focus on the attributes that matter.
In my example I’m going to create an export profile and import profile that doesn’t include categories. Let’s pretend that I need to create a quick profile that allows me to change the prices of some of my products. Instead of exporting every detail down to the meta description field, I’ll create a new profile:
1. Go to System > Import/Export > Profiles
2. Click on the button in the top right corner which says ‘Add new Profile‘
3. Now you need to configure your profile so that it exports successfully as a csv, into the correct place with the correct data. The image below shows how this should be basically configured.
The important part is the section which says ‘Field Mapping’. Simply change it to ‘Only Mapped Fields’ and begin adding field mapping. The only details I need are the product SKU and the price. This will connect all price changes to the correct product. I’m going to export the product name too so that it’s easier to read in the spreadsheet.
Once all the settings have been configured, click on ‘Save Profile‘ in the top right corner.
4. Once saved you’ll see that the profile has saved itself as profile number 7 on the Export / IMport Profile overview page. Click on this profile and click the tab which says ‘Run Profile’, then the button ‘Run Profile In Popup‘. If you have configured it the way I have, the csv file will appear in your var/export folder on your server.
5. If you open it up, it should be the cleanest-looking product spreadsheet you’ve ever seen – rather like the one below:
6. Once you’ve made your changes, simply import the products using the existing ‘Import All Products’ profile. Simple!
Thanks for reading the Magento Blog at Ecommerce Website Design. Now, if only I could export that damn fox to a different country!
It is possible to export products in PDF format. Or exist az extension for this?
I know that once it’s in excel you can export it to a PDF if you have Adobe Acrobat, which isn’t free.