3.5 Export Products
Export OpenCart Products wizard will help you to export your products from OpenCart to .csv files.
To start Export procedure you need to click on OpenCart “Import/Export Product”. Import/Export Wizard dialog window will appear:
In order to be able to start exporting operation, perform a few steps:
1) Select "Export" - save OpenCart products to comma-separated values file format (.csv);
2) Store Manager can export products from OpenCart to CSV file. You should enter the filename or select one to be replaced:
3) “Select Fields Delimiter and Quote Character” page has some important settings.
The first option is delimiter character. You can choose the separator fields data from the drop-down. It can be a comma, semicolon or tab character.
You must choose the right delimiter, because of the incorrect choice of delimiter can cause, that the file will not be parsed properly and products will not be exported.
The second option "Quote string values with" is used to separate strings in CSV file. Specify two first settings as shown below and click 'Next' button to proceed.
4) The next Import Wizard page includes 'Base Formats' and separators. They can be set by default.
5) Select fields you want to be exported:
All available fields, that can be exported, are listed in the left pane of the window .
Select those fields you want to be exported and click button to move them to the right.
If you wish to set some other caption than the default, you can specify target column name ("Target Column Name" field).
Starting from Store Manager ver. 1.15.0.502 you can select and add the Options and Attributes field values to export as well, see an illustration below:
Take a note, starting from the released version of Store Manager for OpenCart (i.e. v.2.0.0.794) the fields related to the special price values can be exported as well and you can find necessary data among the other fields to export:
The fields which are transferred to the right will be exported. Make sure you have selected all necessary data for exporting before following to the next step.
6) In order to export all products of your store you should check “All products”. If you wish to export only selected ones - choose "Selected Products” option.
“Export Image Method” section allows you to import images for the product. You can choose, where you would like to upload pictures from - your local computer (in this case you need to have only image names in your CSV file like product_image_1.jpg) or external web URLs (in case you have image URLs from your supplier like http://supplierstore.com/bulkimages/image.jpg). Please note, that in order to import images, you have to set-up a proper FTP connection.
Multiple string values are used to separate strings in CSV file.
7) ‘Export Options Preview’ - there you can see basic information about your export settings. This window consists of several sections.
You can change your data, clicking on “Change” button.
If you press “Export” button, the export procedure will be run.
8) Preview OpenCart Export is the last page of OpenCart Import/Export Wizard where you can preview the export results.
If you don't want to perform any action after saving OpenCart export data, use "Nothing" option and Wizard will be automatically closed when you press Finish button.
If you choose to open a directory, containing result file, check corresponding option. “Open result file” option allows you to see export file opened in Excel.
All columns, delimiters, and other information can be saved directly in import/export wizard or into the configuration file and then restored.
Now OpenCart products export is completed. You can press “Finish”.