[Module] List of customer out of stock registrations

[presta-dyr 139]

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

statsoos_0.5.zip

[yaya 2]

Hi,

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

thx

[presta-dyr 139]

Under the statistics tab.

/Kjeld

[yaya 2]

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

[presta-dyr 139]

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

/Kjeld

[nuttis 3]

thanks for the module. its working perfectly!

[safa 288]

thanks for works.

[presta-dyr 139]

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

[SpyrosT 1]

nice one! I will give it a try.

[SpyrosT 1]

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

[Pippo3000 28]

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

[Ian Reynolds 0]

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

[Zenith 17]

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.

[noesac 16]

Possible to add a date column on this?

[Zenith 17]

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.

[noesac 16]

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

[Zenith 17]

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.

[maestrobo 2]

@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').'\')')) 

[Zenith 17]

Happy to help!

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

[Pippo3000 28]

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

[noesac 16]

I just noticed that when the order comes back in stock, the record is deleted from the ps_mailalert_customer_oos table. Is it possible to not delete it but to flag it as inactive instead?

[presta-dyr 139]

I have improved the module (see first message in the thread).

* It is now possible to delete entries.
* If the e-mail address is invalid it is colored red.
* If the product is not active it is colored grey.
* If the product is in stock it is colored green (save product again to send e-mails).

/Kjeld

[Zenith 17]

Thanks Kjeld for the update.

One issue I have found is that a product will be colored green when the attribute is out of stock. Seems you are only checking if the product quantity > 0 not if the attribute of the product that is being watched is in stock.

Apart from this niggle, a great update, I was able to merge it with my modified version seamlessly

[presta-dyr 139]

You're quite right. That is fixed now.

Merry Christmas,
Kjeld

[noesac 16]

I installed this a few months ago. Is the latest version a big change? Is it a risky update? I'm just on holidays right now and don't want to risk messing up my site:)

Thanks!

[Rhobur 139]

Thank you Kjeld for this extremely useful module, one problem for me after date modifications.
Though the date field is in table and the correct date added and the column date appears on the page before
the customer column as it should, still no date displayed in the results. Any idea about what might be the cause ?
Happy holidays to you and everybody !

[Zenith 17]

Missing this edit Rhobur ?

'.$oosPage['date_add'].' 

The date should show as 0000-00-00 for entries that were there before the database change was added.

[Rhobur 139]

No, didn't miss it; did all steps, no errors whatsoever. Date is like you said but only in the DB table, the html page renders the date column allright but
empty, everything seems ok, I'm puzzled and clueless.
Thanks for taking your time to help, on holidays Kjeld !

[Zenith 17]

Find line 28 in statsoos.php

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

Change to

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

[Rhobur 139]

Thanks a lot, that did it; come to think of, it was logical, i'm ashamed of not figuring it myself instead of bothering you.
Cheers and a Happy New Year to you !

[Pippo3000 28]

I have improved the module (see first message in the thread).

* It is now possible to delete entries.
* If the e-mail address is invalid it is colored red.
* If the product is not active it is colored grey.
* If the product is in stock it is colored green (save product again to send e-mails).

/Kjeld

thanks, kjeld. this fixes exactly what I was about to ask: how to delete entries from the list.

anyway, I am using v0.2 right now, how do I upgrade. Do i just install v0.4 over v0.2 and all is set? or do I have to deinstall v0.2 first and then install v0.4?

best
phil

[Zenith 17]

Just overwrite the existing files and you are good to go!

[Pippo3000 28]

Just overwrite the existing files and you are good to go!

thx, works like a charme

[CameraTek 5]

Hi presta-dyr,
Brilliant module, how would I change the link of the product the customers waiting for from going to the shop product to the product admin side?

Cheers
Andy

[Jimmy S 0]

What does the colors mean?

[Zenith 17]

Just noticed that if you have a product with multiple attributes these are not shown, it only shows one of the attributes.

[Prestafan1234 222]

I have installed this module as it sounds great, however it is not showing in my BO. I have looked under Modules and Stats. What am I doing wrong?

Version 1.3.1.1

[Dan1 5]

Hello and thank you for the module.

I installed it with PS 1.3.1. The module showed up in the modules list. I made a purchase of an out of stock product. When I click on stats tab and then Customer out of stock link from the left menu, there is no record of any sale. Any suggestions? I'm using one page checkout, I don't know if it matters.

[Zenith 17]

This is not what the module does, it shows a list of customer/guests who have signed up for an e-mail notification on an out of stock item (when items cannot be ordered when out of stock)

[VIXUS 6]

I was just looking for this... is it working on v1.105 ?

[Rhobur 139]

Can it be used with 1.4 in catalog mode ? In this mode the input box for email does not appear anymore.

[Rhobur 139]

It works OK with 1.4.0.17 except a minor problem, I can see listed only one page if I want to list the next or the last error message is "Tab cannot be found. " so the only way remaining is to look directly in the DB.

[Zenith 17]

Change line 73 to

	  <form name="submitStatsOos" method="post" action="index.php?tab=AdminStats&token='.Tools::getValue('token').'&module='.$this->name.'">';

[Rhobur 139]

Thanks very much for the fast reply, did what you said, had to add an ' after

$this->name.'">

and before ; but now I get the "Security token invalid" message. After that if I press Yes agree, it redirects me to the Stats tab. Any idea why ?

[Zenith 17]

There should not be a semi-colon after token or module (this forum is breaking code snippets)

[Rhobur 139]

Removed both semi-colons after token and module and now the difference is that after clicking on "Understand security risk" it redirects me to the
first listing page, not to the Stats tab as before; the same if I'm selecting any page number from the drop down box, no matter what I do I can see only the first records page.
Thank you having patience.

[Zenith 17]

Great news!

[Rhobur 139]

Sorry, my bad, dumb mistake forgot to clear cache.
It's working now !
Big Thanks Zenith, I'm appreciating your help very much.

[James R 4]

Love this module! Any way of displaying the dates chronologically in order rather than all over the place?

[Zenith 17]

Change line #31

       ORDER BY `id_product` DESC

to

          ORDER BY `date_add`,`id_product` DESC

[James R 4]

Thanks a million! Worked first time. Is it an easy fix to sort by latest first? If not no problem at all.

[Zenith 17]

ORDER BY `date_add` DESC,`id_product` DESC 

[James R 4]

Perfect thanks for posting that code!

[outlet.ee 9]

Sorry for the dumb question again but where exactly in stats tab is the list of customers who have subscribed? I enabled the feature and subscribed myself but can't find the list nowhere at all.

Actually I would like to change it a bit and use it for subscribing for a certain brands, like zappos does it. There is the option at every product to subscribe for a particular brand only. As I have the stock of 0 for most items, do you think it is doable this way?

[presta-dyr 139]

When you click the statistics tab you ought to be able to find the link "Customer out of stock" in the left menu.

/Kjeld

[jk.hosking 0]

Thanks for the module I have installed it and it looks great, I have one problem though, when a customer registers to receive a notification of when a product is back in stock, they do not receive it when I increase the stock back up. Instead they receive it when it goes out of stock again?

 

Any ideas would greatly be appreciated!

 

Regards

Kirsty

[ShowYou 17]

Hello,

I have some problems.

After install this module, I've wanted test it. ........ Grrrr problems've arrived.

When i click on Modules and Other modules to see my modules, a # is wrinting at the end of url on my page.

If i want to see all modules, i have a 404 error.

I've decided to use firefox instead of chrome.

I can see all my modules. I uninstall statsoos module but on the page of product i see again this module.

I search, i kill ps_mailalerts... table

I take off 4 lines on product.tpl. Now it's good on my product page but not on admin. I can see all my modules. <div>My website is online and clean because new but close</div><div>What's happen ?</div><div> (Sorry for my french ;-))

 

</div>

[nobynator 2]

Edit: Seems it doesnt work with 1.4.4.1, it doesnt send any mail to the customer.

 

And also one email before the install is stuck, cant get it deleted, where does this info get stored?

Edited September 13, 2011 by nobynator (see edit history)

[emmac64 1]

Hi,

 

I just install it and it seems great BUT I can only see the first page (on 9 features). When I clic on the little arrow or on the "go directly", I get a error "can't find the tab".

Could you help please?

Thanks.

[HolyGuyZ 1]

Another brilliant module have save the day. Thanks a lot! Works great on Prestashop 1.4.4.1. At least I can see the OOS customers.

[CPG2 6]

Great and briliant module, thanks

[Fant63 3]

Thank you for great module.

 

need help, it does not work:

 

Warning: implode() [function.implode]: Invalid arguments passed in www\modules\statsoos\statsoos.php on line 147

 

<td style="text-align: center;"><input type="checkbox" name="oosBox[]" value="'.implode('|', $oosPage).'" /></td>

 

any idea?

 

thanks

[swap 0]

Sorry, my bad, dumb mistake forgot to clear cache.

It's working now !

Big Thanks Zenith, I'm appreciating your help very much.

 

 

 

which cleared the cache?

I have the same problem: Tab can not be found.

[Zwergstern 0]

DANKE!!!

[Vinc3nzo 24]

Hello!

 

Module is no Update ??

 

Please Update this module!

very thx!!!

[presta-dyr 139]

I don't have much spare time so I can't promise you anything.

 

/Kjeld

[DenisDenis 2]

Looks very promissing, the first page is showing fine but when i want to go to the next or any other page it tells me 'tab can not be found'.

 

Any sollutions for this?

 

EDIT: I noticed the following

this is the first page

 

index.php?tab=AdminStats&token=739c38fa189696d6ea7dadff0c9f4689&module=statsoos

 

And this another page

index.php?tab=AdminStatsModules&token=739c38fa189696d6ea7dadff0c9f4689&module=statsoos

 

it seems to change the tab name to something else, dont know if this could be the problem, but simply changing the tabname back manually doesn't do anything...

[Zenith 17]

Should read the whole thread!

 

http://www.prestashop.com/forums/index.php?/topic/47173-module-list-of-customer-out-of-stock-registrations/page__view__findpost__p__546985

[DenisDenis 2]

I am so sorry, it works now, thank you very much!

[Shila 0]

Great job, works perfect on 1.4.4.1

[presta-dyr 139]

I have updated the module for PS 1.4.

 

/Kjeld

[Zenith 17]

The attributes didn't get fixed

 

Products with more than one attribute combination only show a random attribute instead of all.

[HyugayaX 0]

Sorry for the question, but I´m new in all this web store stuff, how do I install this module?

 

I already tried uploading to the css/module folder, but then realize the lack of .css file.

 

Thanks in advance.

 

Edit: Nevermind, just figured out... sorry for the spam.

[emmac64 1]

Hi,

 

I have PrestaShop™ 1.4.2.5, and many customers complain about receiving many messages, even after ordering or after weeks.

I have to delete it.

Is someone having the same problem?

[Daniel - PrestaBR 317]

First, thanks for the very useful module!

 

Has anyone developed an CSV Export function?

It would be good for those who have a large list of products.

 

DGV

[James R 4]

Is there any way of displaying the date in the latest 1.4 version? Statsoos.php has been coded differently so the old find and replaces aren't working.

 

Thanks!

[violet23 0]

Hi,

 

I realise for the same product, only the first guest who enter the email will be shown, subsequent guests who enter emails for the same product will not be captured.

 

Any fix for this problem?

 

Thanks!

[rozwesel 0]

Thank you a lot... It's great! (Poland:))

[tivicrdotcom 12]

Great module really because before I couldn't find where to look for the populated product/email list. Now, when I view it under stats, they are all there but when select them to delete it displays:

 

"Tab cannot be found" and obviuosly doesn't delete de entries, any clue?

 

Thanks in adavance!

 

AJ

[nemok 0]

guys,

 

is there a way to show dates ? the changes suggested don't works...

Edited June 22, 2012 by nemok (see edit history)

[MagnaUser 0]

In PS 1.3 still showing a few pages.... can´t erase, error of Token...

[Pippo3000 28]

first of all thanks for the module - again. I used it for PS1.3.2 and now v0.5 also with PS1.4.8.2. but my problem is also (?) that I cannot delete any selection. Also, I cannot access any other page than page 1, I get an 'tab not found' error. any idea how to solve this?

 

disregards. found this and will try it now

http://www.prestasho...post__p__546985

 

EDIT: still tab not found. how do I clear the cache? disabled cache and forced compile for 2 mins but that did not help?

Edited August 7, 2012 by Pippo3000 (see edit history)

[Pippo3000 28]

first of all thanks for the module - again. I used it for PS1.3.2 and now v0.5 also with PS1.4.8.2. but my problem is also (?) that I cannot delete any selection. Also, I cannot access any other page than page 1, I get an 'tab not found' error. any idea how to solve this?

 

disregards. found this and will try it now

http://www.prestasho...post__p__546985

 

EDIT: still tab not found. how do I clear the cache? disabled cache and forced compile for 2 mins but that did not help?

 

anyone? please

[Pippo3000 28]

bump

[tivicrdotcom 12]

I am using PS 1.4.6.2 and facing the same issue when clicking on page 2 or trying to delete (Tab cannot be found.Tab cannot be found.). I tried some of the solutions but none of them worked, although the module/scripts work nicely storing the emails and sending notifications when available. Anyone know a remedy? Thanks in advance!

[tivicrdotcom 12]

Anybody?

[Pippo3000 28]

unfortunately not. a real pity as this is really a functionality PS should have out of the box...

 

EDIT: reading helps and sticking to the letter. when applying the changes mentioned above I missed a ) or ; somehow, tried it again now and yes, it does work. just stick to the code by the letter

Edited October 17, 2012 by Pippo3000 (see edit history)

[johnnnyme 4]

Hello

 

Same problem here, can't delete records.

When i try to delete a record i have message "Tab cannot be found" and a white screen.

 

Any advise?

Thanks

[vigneswara 0]

Hello

 

Same problem here, can't delete records.

When i try to delete a record i have message "Tab cannot be found" and a white screen.

 

Any advise?

Thanks

1. Open up statsoos.php
   
2. at line 78 you will find something like the following:
   

• action="index.php?tab=AdminStatsModules&token=
  
• Change it to the following:
  
• action="index.php?tab=AdminStats&token=
  

Try it out

[johnnnyme 4]

It works fine

 

Thanks

[nemok 0]

If anyone need I can send the working module with date column and without bug on scrolling next pages. Marco

[tivicrdotcom 12]

1. Open up statsoos.php

2. at line 78 you will find something like the following:

 

• action="index.php?tab=AdminStatsModules&token=

• Change it to the following:

• action="index.php?tab=AdminStats&token=

 

Try it out

 

 

Dude that actually worked, thanks as I was already on my third page and this is a very helpful module,

 

If anyone need I can send the working module with date column and without bug on scrolling next pages. Marco

 

 

Dude email it to me please at aacostacr at hotmail dot com

[johnnnyme 4]

Thanks a lot nemok but, why don't you just upload it in the next post?

Its better that way, because i dont want to publish my mail.

 

Thanks again