Sometimes, it becomes essential to modify or update OpenCart products from a specific category in a convenient format like .csv or xls. To accomplish that, you first need to export them
and save in the necessary format.
Currently, OpenCart backend does not provide such a possibility. Probably, you will agree that exporting all products and searching for the ones assigned to a particular category seems too time-consuming and annoying.
Store Manager functionality allows to export OpenCart products by category using a special filter.
Here how you can export the filtered items to .csv:
Go to 'Stores' tab and open 'Categories & Products' section. In the lower grid find 'Filter' drop-down and select a suitable option:
Show all products;
Filter by selected category(ies);
Filter by selected and nested category(ies);
Show products without category.
Launch the export wizard by tapping the 'Export/Import' button and select 'Export' action.
Specify the location to save the export file to. In case you want to save it to the existing file, it must be writable and it will be overwritten.
Select the delimiter to separate data fields. Check 'Quote string values' box and input the character.
Configure the date & time formats and separators. You can also leave them default.
Select the fields to be included in the export file using special buttons. It is possible to select all fields at one time by pressing the double arrow button. In order to export fields names in the first row, check the corresponding box.
At this step you have to select which products you would like to export (all or selected), choose the image export method (export only image names or image URLs) and specify the multiple values separator.
Preview the export options configured during the process. You can modify any of the settings by tapping the 'Change' button.
Press 'Export' and preview the file. Select the action to be performed with the exported file.
You can also save the configuration to file or to Store Manager archive and use it the next times.
Tap 'Finish' to export the file
Now you can open the exported file and update the products assigned to a specific category and import them back using the same wizard.
In addition, Store Manager allows to save grid with the filtered products to .html, .xml, .txt, .csv, .xls or .xlsx file format.
Try performing OpenCart export by category for 14 days free Try Now