3.6. Export Products
If you use the Standard Edition of Store Manager for Magento, the number of products available for export is limited to 3000. If you need to export more products, you will need to upgrade to the PRO Edition. Please click here for more details: Store Manager for Magento Plans & Pricing
The Export Products wizard will assist you in exporting your Magento products to a comma-separated values file (.csv), which can be opened in MS Excel or other applicationі. To begin export, click the button which starts the Import/Export Wizard.
In the starting window of the wizard select [Export] and press [Next].
The wizard will guide you through the following steps.
1. Select export target:
local file (products will be exported to a local disk on your PC in .csv format)
Google spreadsheets (products will be exported to your Google Drive)
To export products to a .csv file, press the open folder button. You can select an existing file (data will be replaced) or create a new document.
To export products to Google spreadsheets, you first need to connect to your Google drive.
Press [Add Account], enter a display name for your cloud storage, and press [Authenticate] :
You will be prompted to open browser window with the Google sign-in form:
Enter your credentials and press [Allow] to grant the eMagicOne Store Manager for Magento application access to your account.
At the last step, confirm your choices and close the window. You will see a message that authentication is successful. Close the browser tab and return to Store Manager.
To select a cloud file, click the open folder icon.
In the Drive Explorer, pick an existing spreadsheet or create new by pressing the grin plus button.
If you select an existing spreadsheet, there will be the following options available:
Replace sheet values with the selected sheet (there will open a drop-down to select a sheet).
Append sheet values to the selected sheet (there will be a drop-down to select a sheet).
Insert new sheet - enter a name for a new sheet or use macro to insert current [DATE].
2. On the next page, choose the Store view(s) for which the changes will apply.
Select the products you want to export:
All products - all products from your store will be exported.
Products from selected categories - checking this option opens a category tree. Check categories to import products from.
Export selected products - the products that you selected in the grid (if you did) before launching the wizard will be imported.
Press [Next >] to proceed.
3. Set delimiters for .csv file
This step has a number of important settings. Be sure to verify them to ensure successful export.
The first option is the delimiter character. The most popular delimiters are the comma (,), semicolon (;) and the tab character ( ), however, other symbols can be used as well.
The Export file is usually generated in order to perform subsequent Products import operations. If an incorrect delimiter is specified during import, the file will not be parsed properly, and the products will not be imported. The second option, quote string values, is used to separate strings in the .csv file.
The Category delimiter is not a native .csv setting and is used only in, and by, Store Manager. Categories are organized in the form of a "Tree", where one category may contain one, or more subcategories, and each subcategory may contain one, or more, other categories. The category delimiter character is used to separate category names, and to specify the full category tree path, for a given product. The category path is very similar to the directory path and is used to specify a fully qualified file name, in Windows. Each directory is separated by a backslash (\) character. An typical example would be:
A further example of a category path for 'Camping Tents' subcategory is illustrated in the image below, for the 'Default Category|Best Sellers|Camping, Tourism & Outdoor|Camping Tents'. The Pipe (|) character is used as a separator.
If products, that you are exporting, are of the downloadable type, you should, in the relevant section, check field "Export Files", and specify the directory on your local disk where the files for download are located.
Images - The Default Images Path, is where your image files should be stored.
5. Select the fields that you want to be exported:
All available fields that can be exported are listed in the left pane. Select the fields that you want to export, and click the [>] button, to move them into the right pane. If you'd like to export all fields press [>>]
The order in which columns will be saved in the .csv file may be changed. Do this by moving the export columns up and down, using the corresponding directional button(s).
You can check relations between products that you are exporting, by putting a check mark in front of the relevant fields, and indicate the parameter(s) (ID number or SKU), by which the products are related.
When you press the [Export] Button, the products export process will begin!
Multi-product types and their additional components
If you need to export products from your store with additional components like bundle, configurable, grouped products with cross/up-sells items:
do not forget to choose the required checkboxes on the appropriate step of Export Wizard:
It helps to save existing relations between exporting data and get the correct file.
So, you can see the products and their components (which were checked earlier) are displayed in the separate columns after export.
Such structure of the file is perfect for reverse process - import - if you need, for example, to transfer these data to another store or when updating the details after changes in a source file as well.
6. Before proceeding, Preview and verify the export file results.
Choose what action(s) to perform, after saving the export data, or, if "None" is selected, the Wizard will be closed automatically upon completion of the process. If you wish to open a directory containing the results file, check the relevant option, "Open result file", which will allow you to see the export file, using Microsoft Excel, or other comparable product.
You may save all your Export Settings for future reuse.
When finished, close the Import/Export Products wizard, by pressing the [Finish] button.
Check the following video tutorial to see how to perform export products in Store Manager in practice: