• OpenCart Manager RSS
  • OpenCart Manager YouTube
  • Follow OpenCart Manager on Twitter
  • Google+
  • OpenCart Manager on Blogger
  • OpenCart Manager on FaceBook
8 AM - 7 PM (GMT) / 3 AM - 2 PM (EST)
1-855-814-4511
1-855-810-5797
33-805-084-243

12 usages left

How to Export OpenCart Orders

Sometimes, you may need to export OpenCart orders data to spreadsheets to analyze it or make some statistics etc. Currently, OpenCart admin does not provide such function.

In such case you can resort to Store Manager for OpenCart. The application allows to filter the orders by date and status and then export them to a range of formats including .csv, .xls, .xlsx, .xml, .txt or .html. The whole procedure can be accomplished in a few clicks.

How to Export OpenCart Orders?

  1. Open 'Store' tab and move to 'Orders' section.


  2. Use the filters on the right and filter out the orders by selecting the necessary date range and order status (to ignore the status, check the box). You can also filter orders by specific periods (today, yesterday, this week, last 3 months etc.). Set the filters and press 'Apply'.


  3. Tap 'Export Grid' button and select the OpenCart export orders file format.


  4. Specify the place to save the file to and press OK.

Group Orders Based On Data Columns by Drag'n'Drop


The flexibility of exporting orders via Store Manager allows to previously organize the export file layout in a custom way. For example, you can group the orders based on any of the available data columns or on a couple of them.



To do that, use the 'Group Box' option and drag the column you want the orders to be filtered by. If you drag a few columns, they will be linked to each other in a descending manner, that is every column will be subject to the previous one.



In addition, before starting the export you can easily and quickly make changes to the order details including customer data, payment/shipping details and view the order history. You can do this in the left lower grid. On the right, you can find the order total including taxes and subtotal.



It is a good idea to make such exports on regular basis and compare them in order to define your best sales periods or the most loyal customers, or best sellers. Having such data at your disposal can help you at personalization of your sales techniques.


Filter and export OpenCart orders for 14 days free - Try Now



Privacy Preference Center

Strictly Necessary

These cookies are necessary fro the site ot function.

woocommerce_cart_hash, woocommerce_items_in_card, wp_woocommerce_session_{hash}

Performance

These are used to track user interaction and detect potential problems. These help us improve our services by providing analytical data on how users use this site.

_ga, _gid, _gat-_UA-326982215-25, LaSID, LaVisitorId, __utma, __utmc, __utmv, __utmz

Close your account?

Your account will be closed and all data will be permanently deleted and cannot be recovered. Are you sure?