OpenCart Categories Export
The need to perform OpenCart categories export may emerge if you need to show the exact hierarchy to your supplier, so s/he could provide you exact structure for inventory updates or you just would like to have a copy of important data on your computer. This procedure might be especially useful as a first step of bulk updates, if you further want to import file with changes.
So if you're looking for a way to export OpenCart categories, subcategories and related category data to a spreadsheet, then most likely you have already noticed that there is no export button tucked away somewhere in admin panel. This functionality is not available in OpenCart by default, however we know how to achieve the desired results.
You can export to CSV any selected category or entire category tree with associated data, such as category ID, full path, meta data, description and category image with Store Manager for OpenCart application in a breeze.
The software allows to work locally and offline, so will never ever face an issue of server timeout and will able to work with a large number of categories without any problem or delay.
Try FREE OpenCart Category Export Tool! Download Now
Step 1: Select Categories You Want to Export
In case you want to export your entire tree, you can skip this step. However, if you only want to export one or a few categories, you need to expand the hierarchy and select categories and subcategories you need to bring to CSV. Simply move through the tree and choose categories holding Ctrl button.
Step 2: Run Categories Export Wizard
In categories main menu you will see ‘Export Data’ option that allows to call export wizard for category info.
Step 3: Specify Location for Export File
By default a new file will be created for categories export, however, you can replace it with the one you wish or change current spreadsheet name and it’s location. The output file can be saved in preferable directory on your PC or uploaded via FTP to remote location.
Step 4: Indicate Delimiter Character for Your Data
The most widely-used character is comma, as the file the data are saved in is called comma-separated values. However, per your desire, you can use other symbol to separate fields in your spreadsheet.
Step 5: Decide What Fields to Export
At the next step you will see the window divided in two parts. On the left there are all fields with category details available for export. The fields you want to save to CSV, you need to move to the right pane of the window, using navigation buttons in the middle or drag&drop.
Step 6: Configure Export Options
Here you can decide if you want to export all categories or only those you have selected at the first step. If you open advanced options, you also will be able to configure date formats and configure multiple values separators.
When all the settings are set, you can hit ‘Export’ button. In a few seconds you will be navigated to results page displaying preview of exported data and allowing you to select after-export action.
Step 7: Hit ‘Finish’ and You Are Done!
So in case you would like to view file right away, you can choose to open result file when the wizard is closed. This way you can avoid the necessity to go to file location and open it manually.
That’s it! You have done the task without developer’s help or complicated scripts.