Stats - BO : Customer Accounts

[seekapet_com_au]

Hi All,

 

I have a general question so that I can seek a better understanding.

 

In the Stats Tab --> Navigation --> Customer Accounts

 

The following appears:

 

Visitors who have been blocked at the registration phase:

Visitors who have placed an order directly after registration:

 

 

 

What exactly does Prestashop mean that a visitor has been blocked at the registration process? What can be the causes of this?

 

I am asking as I have seen a slight increase since upgrading to 1.4.9

 

Any suggestions would be great.

 

Thanks

[bellini13]

this is the query the stats module is using to determine if they have been blocked. it appears to find any visitors that have not registered, and have simply visited the authentication.php page.

 

basically if any visitor to your website clicks on the login or checkout button, but never actually login or create an order, they will be considered "blocked"

 

   	 $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->getRow('
       SELECT COUNT(DISTINCT c.`id_guest`) as blocked
       FROM `'._DB_PREFIX_.'page_type` pt
       LEFT JOIN `'._DB_PREFIX_.'page` p ON p.id_page_type = pt.id_page_type
       LEFT JOIN `'._DB_PREFIX_.'connections_page` cp ON p.id_page = cp.id_page
       LEFT JOIN `'._DB_PREFIX_.'connections` c ON c.id_connections = cp.id_connections
       LEFT JOIN `'._DB_PREFIX_.'guest` g ON c.id_guest = g.id_guest
       WHERE  pt.name = "authentication.php"
       AND (g.id_customer IS NULL OR g.id_customer = 0)
       AND c.`date_add` BETWEEN '.ModuleGraph::getDateBetween());

[Gomlers]

So this is not a way of telling the storeowner that a customer actually got blocked - The way I understand you, is that the customer left because he or she wanted to? Am I correct?

 

But if this blocked-number is high - it would be good to examine if something should be done on the authentication.php page? Like changing the layout, make the customer more confident and so on?

[seekapet_com_au]

Gomlers - If a customer enters a wrong password this also has triggered as a "block" or tries to register again with the same email address.

 

The issue also is if you have instant checkout, a customer who previously used this feature can't register an account with the same email address so it will "block" them.

[Gomlers]

Ok, thank you for your further information regarding this.

 

I believe that abandoned purchases is a HUGE problem in all e-stores.

 

The BEST way to increase sales, is to decrease the number of abandoned carts / or registrations.

 

If 1 out of 100 makes a purchase, you have a convertion rate of 1 %.

To double this, you can either pay lots of money for marketing - hence double the number of visits - OR you can make a sale to 2 out of 100 people. (And THEN buy some advertising)

 

This is why I think it's so important to take the "blocked" purchases very seriosly, and try and measure things - and then do something abouti it!

 

So all information regarding this subject is very welcome from where I stand