[Module] List of customer out of stock registrations

[presta-dyr]

This small module lists registrations for out of stock products done via the mailalerts module. If customers are registered their name is shown. In any case the e-mail and the product is listed.

Updated 2010-05-27: Fixed bug for multiple pages
Updated 2010-12-18: Added colors and added delete function
Updated 2010-12-18: Fixed count for attributes
Updated 2012-01-18: Fixed count for attributes

/Kjeld

Attached File(s)

•  statsoos_0.5.zip (9.25K)
  Number of downloads: 34

Hi,

where can we see customers who are waiting for out of stock products. (which page)

thx

Under the statistics tab.

/Kjeld

ok thx
But i have a problem, because i have uninstall statistics tab on my board ....

You can install it again from the tools->tabs menu.

/Kjeld

Attached File(s)

•  stats.png (7bytes)
  Number of downloads: 2675

thanks for the module. its working perfectly!

thanks for works.

There was a bug when the number of customers grew to two pages. I have updated the attachment in the first message in this thread.

/Kjeld

nice one! I will give it a try.

Is there a way to delete the fake lists?
There are a lot showing "your@email.com"

From 1268350571:

This small module lists registrations for out of stock products done via the mailalerts module. If customers are registered their name is shown. In any case the e-mail and the product is listed.

Updated 2010-05-27: Fixed bug for multiple pages

/Kjeld

Thanks, Kjeld! Great work, seems to work perfectly with PS1.3.2

Phil

I am using 1.3.2.3 and have just updated to the newest version (top of thread) still I only see one page of 20 names?

Does this work with 1.3.2.3?

Thanks

Ian

I'm using it on SVN 1.4 and have been using it since 1.2.5 - just compared my code (had to make some changes for 1.4 version) and it's still the same base code for the pagination. Should work for you, maybe you don't have more than 20 mail alerts?

Look in the database, in the "mailalert_customer_oos" table to see how many entries you have.

Possible to add a date column on this?

It is, I have added a date, but it requires modifying the database and core files, as the date is not recorded in the database by default.

If you are willing to make the changes let me know and I'll post up instructions.

That would be great thanks. Is it a risky change?

No risks, just either have to work around the changes if you update, or apply them to the new version files.

Via phpMyAdmin alter the table...

ALTER TABLE `ps_mailalert_customer_oos` ADD `date_add` DATE NOT NULL

-----[ OPEN ]-----

modules/mailalerts/mailalerts.php

-----[ FIND ]-----

    `id_product_attribute` int(10) unsigned NOT NULL,

-----[ ADD AFTER ]-----

    `date_add` date NOT NULL,

-----[ OPEN ]-----

modules/statsoos/statsoos.php

-----[ FIND ]-----

      SELECT `id_customer`, `customer_email`, `id_product`, `id_product_attribute`

-----[ REPLACE WITH ]-----

          SELECT `id_customer`, `customer_email`, `id_product`, `id_product_attribute`, `date_add`

-----[ FIND ]-----

      '.$this->l('Customer').''.$this->l('E-mail').''.$this->l('Product').''.$this->l('Attribute').'';

-----[ REPLACE WITH ]-----

      '.$this->l('Date').''.$this->l('Customer').''.$this->l('E-mail').''.$this->l('Product').''.$this->l('Attribute').'';
 

-----[ FIND ]-----

    '.$customerName.'

-----[ ADD BEFORE ]-----

                '.$oosPage['date_add'].'

-----[ OPEN ]-----

modules/mailalerts/mailalerts-ajax_add.php

-----[ FIND ]-----

    REPLACE INTO `'._DB_PREFIX_.'mailalert_customer_oos` (`id_customer`, `customer_email`, `id_product` , `id_product_attribute`)
    VALUES ('.intval($id_customer).', ''.pSQL($customer_email).'', '.intval($id_product).', '.intval($id_product_attribute).')'))

-----[ REPLACE WITH ]-----

    REPLACE INTO `'._DB_PREFIX_.'mailalert_customer_oos` (`id_customer`, `customer_email`, `id_product` , `id_product_attribute`, `date_add`)
    VALUES ('.intval($id_customer).', ''.pSQL($customer_email).'', '.intval($id_product).', '.intval($id_product_attribute).', ''.date('Y-m-d').'')'))

I think these are the only changes, let me know how it goes as I may have forgotten a change somewhere - was awhile ago I added this.

@zenith: thanks for the hack. very useful.

for the last replace, not sure your parenthesis are correct. mine are like this and that work like a charm :)

if (Db::getInstance()->Execute('
    REPLACE INTO `'._DB_PREFIX_.'mailalert_customer_oos` (`id_customer`, `customer_email`, `id_product` , `id_product_attribute`, `date_add`)
    VALUES ('.intval($id_customer).', ''.pSQL($customer_email).'', '.intval($id_product).', '.intval($id_product_attribute).', ''.date('Y-m-d').'')')) 

Happy to help!

It's this forum code that removed the last apostrophe from mine. As long as you have it working ;)

From 1281655766:

Is there a way to delete the fake lists?
There are a lot showing "your@email.com"

yes, would like to be able to delete entries, too. no fakes (yet) but some customers are waiting for products which will not be in stock again, so I would like to get rid of those in the statsoos statistic.

phil