Sales

Sales Statistics

 NOTE

Sales statistics is supported by the Sana web store integrated with SAP Business One for SAP HANA starting from Sana 9.3.4.

The ERP systems gather the detailed sales statistics for each customer. Now this sales statistics from ERP can be seen directly in Sana Admin. These reports include information about total orders, total quotes, total outstanding order amount, total outstanding invoice amount as well as profits, order returns, discounted amounts, etc. per customer within a specific time period.

To open sales statistics in Sana Admin click: Sales > Sales Statistics.

Sales statistics is available only for customers which have shop accounts in Sana Admin. If you have contacts or sales agents accounts sales statistics will not be shown for them.

Sales statistics provides two types of information: general and sales. When you open the details of the customer's sales statistics for the first time, both, general and sales information is retrieved from the ERP system and placed into the SQL database. Next time when you open the details of the customer's sales statistics, all data will be retrieved not from the ERP system, but from the SQL database. This is done for performance reasons, not to request a big amount of data each time from the ERP system.

Most probably, you will not need to check sales statistics frequently. When sales statistics is recorded into the SQL database and shown from there you will not see the latest customer's sales statistics from ERP in Sana Admin. If you want to check the latest sales data for the customer you can easily update sales statistics for all your customers. To update sales statistics for the customers run the Sales statistics import task in Sana Admin: Tools > Scheduled tasks.

This task retrieves the latest sales statistics for all your customers from the ERP system and saves it to the SQL database.

Using sales statistics you can identify your most profitable customers. Once you know who these customers are, you just have to find ways to keep them happy and bring in more people like them. In combination with pricing and discounts functionality available in your ERP system, customer segments and MailChimp integration you can show your best customers how deeply you appreciate their business and confidence. To build and deepen relationships with each individual customer or your most profitable customer segment you can, for example, give them a discount, or some kind of a multi-buy, or mix & match, or threshold offer for the next purchases. Send them a personalized e-mail via MailChimp or create a customer-specific content on your web store using customer segments to promote loyalty and keep your customers delighted.