How to Mass Export ONLY the products you choose

This article shows you a little trick on how to export ONLY the products that you wish to update.

By default in Miva Merchant you cannot export only the products of your choosing to a flat file. you have the option of exporting entire categories or the entire product database.

Detailed Miva Merchant Product Export Directions:

1. Create a category that you will assign all of these ‘like’ products to.
   1. Make sure the ‘active’ box is not checked show it does not show up on the frontend.
2. Add all of the ‘like’ products to that category.
3. Now you can export products by category and export only that category.
   1. ‘Export file format’ should be: ‘Import Files From Flatfile.
4. Make a backup of the exported file and save it in a different location just in case something goes haywire and you need to restore those products.
5. Open you’re the exported file in your favorite spreadsheet program and make edits and save it.
   1. Be careful if you use MS Excel because it likes to format some fields which causes problems on the import. Avoid Excel if you can.
   1. For a spreadsheet editor I recommend ‘calc’ that comes with ‘OpenOffice’ because it allows you to save spreadsheet in any format you wish and you can select the delimiters. OpenOffice is a free program http://www.openoffice.org and it is a very good alternative to MS Office.
      

      OpenOffice Software

   1. I usually save file with pipe delimiters (pipe is the straight up and down line when you type (shift + \ )
6. Import the file
   1. Choose ‘Import Files from Flat File’
   1. Logging is up to you but you might as well have the log file emailed to you.
   1. IMPORTANT: Choose ‘Update Existing Products’.
   1. When you map the fields my suggestion is to only map the fields that you changed plus the required fields which are ‘CODE’ and ‘Name’. If you did not change anything in a particular field do not even map it. The less you import the less mistakes can be made.
   1. Double check field mappings
   1. Click Import.
7. Check the products on the live site to make sure they imported correctly.

Congratulations Your Done!