Export OpenCart Products By Category
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.
You can also save the configuration to file or to Store Manager archive and use it the next times.
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.