Getting sales reports based on orders in Ecwid

Last updated

The 'Sales' section in Ecwid control panel provides merchants with a useful interface for tracking and processing orders in their Ecwid stores. However, you may need an advanced tool for sales reporting. It can be especially important if you sell many various products, process lots of orders or need to track sales for your affiliate partners or products' vendors separately. With Ecwid, you have the following ways to create reports you want.

Use built-in sales reporting of Google Analytics (recommended way)

Being a unique solution Ecwid uses an approach completely different from "usual" shopping carts.  Instead of trying to put all sorts of site features into one product, we created a product that would be absolutely the best at just one thing: it’s the best shopping cart software available. And since Ecwid can be added to any web site you can use it with any CMS system you like, with whatever newsletter management software or service most suitable for you, and so on. Ecwid grants you the flexibility to use your online shop as one great component among many.

The same thing is with reports. Instead of implementing a reports feature in Ecwid  we have a better offer: you can use super-powerful and free e-commerce reports by Google Analytics. Not a single built-in report of any shopping cart in the world will ever have the same level of power and flexibility as Google Analytics which has been developed by Google for 7+ years.

 

How to use it: 

  1. First of all you should integrate your Ecwid store with Google Analytics. Remember to enable the "Ecommerce tracking" feature. It will allow Google Analytics to generate  profound reports about monthly sales, purchased products, referrers, etc.
  2. Your E-commerce reports are available in the Google Analytics backend on the Standard Reporting → Conversions → Ecommerce page support.google.com/analytics/bin/answer.py?hl=en&answer=1037249&topic=1037061&ctx=topic
  3. The last step is to install special powerful e-commerce report dashboards that provide easy access to all your stats. Example: 

In order to do this, please make sure you're logged in to Google Analytics and open the below links to install the dashboards. 

Other ways

Export orders data to a CSV file and compose reports in a spreadsheet editor

Using the Ecwid's built-in export tool, you can download your orders data into a CSV file and process that file using your spreadsheet editor (e.g. OpenOffice Calc or MS Excel). How to do it:

  • On the 'Sales' page in your Ecwid Control Panel, click either 'Export all' or 'Export selected' button in order to generate a CSV file containing the information of the selected orders set.
  • Open the CSV file in OpenOffice/Excel/Google Docs.
  • Arrange the data in a desired manner and make up necessary reports using tools provided by the spreadsheet editor.

Use applications from Ecwid App Market

There is a special section in our App Market with analytics and reporting apps. Check it out to find more useful apps for your business here: https://www.ecwid.com/apps/analytics

Export orders data to a 3d-party orders/inventory tracking tool and generate the sales reports there

There are many online tools and desktop applications that specialize in extended orders/inventory tracking and generating sales reports. Such tools can be configured to either be fed with CSV files containing order data or be connected with online stores via APIs. For example, you can consider using QuickBooks. 

How to manually import your orders to QuickBooks

Create custom reporting tool connected with Ecwid by means of Ecwid API

If you need a custom sales reporting tool for your Ecwid store, you may want to consider creating a script that will use Ecwid API to obtain orders data and generate sales reports automatically in any format.

If you need help with the development of such a tool, you can contact our customization team: https://ecwidcom.typeform.com/to/vIlijv

Was this article helpful?
1 out of 1 found this helpful
Questions?
Get help
  • Forums

    Join the Ecwid community. Discuss support topics and store ideas with other Ecwid users.

  • Contact us

    Still have questions about Ecwid? Let us know! We will be glad to help you with your Ecwid store.

  • Status Monitor

    Get real time status updates on Ecwid services here, 24/7