Jump to content

[Module] List of customer out of stock registrations


Recommended Posts

  • 2 weeks later...

I've found a bug using with 1.5.6.

 

Then trying to delete these stats selecting one or all stat lines - shows an error: Cannot find controller

 

 

 

 

Tested, works fine with 1.5.6

Share this post


Link to post
Share on other sites

I´ve had this great module a long time, but when I upgraded to 1.5.6.1 it stopped working. It don´t send out any mails when a product is back in stock and when you try to enter your e-mail to a product that is out of stock you get a message that you are allready registered.

Help please!

Share this post


Link to post
Share on other sites
  • 1 month later...

Someone can explain how we can get it works for 1.5.6 please ?

 

Really thanks!

 

we download this module from first post, enabled it, it's all fine except one thing: when we try to open secong page of list prestashop display error about adminstatsmodules controller. help us, we really need this wonderful module

Share this post


Link to post
Share on other sites
  • 1 month later...

Gromov, I'm using PS 1.5.3.1 and I solved my problem with the pagination by copying the content of line 81 to line 78 (they are almost the same, the only thing that change is AdminStatsModules to AdminStats). 

I guess the if/else could be removed for cleaner code, but I haven't tried that.

  • Like 1

Share this post


Link to post
Share on other sites
  • 1 month later...

Gromov, I'm using PS 1.5.3.1 and I solved my problem with the pagination by copying the content of line 81 to line 78 (they are almost the same, the only thing that change is AdminStatsModules to AdminStats). 

I guess the if/else could be removed for cleaner code, but I haven't tried that.

 

Thanks!

Share this post


Link to post
Share on other sites
  • 4 months later...
  • 2 months later...
The STATS OOS show only the size of products, but the colors (as combinations of a product) not. Possible to do it show the combination of the product too? It would be important, because a t-shirt not only size (S, M, L), but also the color is (black, red, white).

Have you any suggestion?

Share this post


Link to post
Share on other sites
  • 4 weeks later...

Where is the most stable download for 1.6.0.9? This is a must for every store owner. For example, the module populated 30 emails of customers asking for an specific sold out product. Bought more, listed them, module notifies the customers, voilá, instant sales. Gotta Love it!

Share this post


Link to post
Share on other sites
  • 1 month later...

Thank you for the module!

 

I change it to show a Top List products with filter, may be someone helps!

post-413746-0-68423000-1421841959_thumb.png

 

I checked in PS 1.5.5.0

 

You can download here: statsoos.zip

 

The date_add field must be in mailalerts module:

in file /modules/mailalerts/MailAlert.php:

class MailAlert extends ObjectModel
{
	public $id_customer;

	public $customer_email;

	public $id_product;

	public $id_product_attribute;

	public $id_shop;

	public $id_lang;
	
	public $date_add;

	/**
	 * @see ObjectModel::$definition
	 */
	public static $definition = array(
		'table' => 'mailalert_customer_oos',
		'primary' => 'id_customer',
		'fields' => array(
			'id_customer' => array('type' => self::TYPE_INT, 'validate' => 'isUnsignedInt', 'required' => true),
			'customer_email' => array('type' => self::TYPE_STRING, 'validate' => 'isEmail', 'required' => true),
			'id_product' => array('type' => self::TYPE_INT, 'validate' => 'isUnsignedInt', 'required' => true),
			'id_product_attribute' => array('type' => self::TYPE_INT, 'validate' => 'isUnsignedInt', 'required' => true),
			'id_shop' => array('type' => self::TYPE_INT, 'validate' => 'isUnsignedInt', 'required' => true),
			'id_lang' => array('type' => self::TYPE_INT, 'validate' => 'isUnsignedInt', 'required' => true),
			'date_add' => array('type' => self::TYPE_DATE, 'validate' => 'isDate')
		),
	);

and in /modules/mailalerts/mailalerts.php:

$sql = 'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.MailAlert::$definition['table'].'`
		(
			`id_customer` int(10) unsigned NOT NULL,
			`customer_email` varchar(128) NOT NULL,
			`id_product` int(10) unsigned NOT NULL,
			`id_product_attribute` int(10) unsigned NOT NULL,
			`id_shop` int(10) unsigned NOT NULL,
			`id_lang` int(10) unsigned NOT NULL,
			`date_add` datetime NOT NULL,
			PRIMARY KEY  (`id_customer`,`customer_email`,`id_product`,`id_product_attribute`,`id_shop`)
		) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci';
Edited by evejuan (see edit history)

Share this post


Link to post
Share on other sites
  • 1 month later...

We've migrated to 1.6.0.11 and now the "customer out of stock" tab doesn't appear in the statistics page.

 

Other users are reporting that this module works OK for 1.6, so maybe we have to configure something or update the module. Anyone knows how to make it work in 1.6? 

Share this post


Link to post
Share on other sites
Good Evening,

 

I installed statsoos_0.5.zip, the module is enabled, but the panel stastique customer out of stock it says "not found Module."

 

I may be forgetting something?

 

My setup prestashop multiboutique in version 1.609,

 

Thank you in advance

Edited by bernard77 (see edit history)

Share this post


Link to post
Share on other sites
Hello,

 

Module updated to version 1.6 with some modifications.

- Works in multi Shop

- French Translation

- Changing the display of the selected product, for better viewing.

- Integration of the text "Guide" Theme 1.6

- Direct Link products (for modification, stock ...).

 

Works with MailAlert module.

 

To have the dates, we must modify two files MailAlert module (add the date)

 

That's it

 

Bernard

 


Share this post


Link to post
Share on other sites
  • 1 month later...

Thank you bernard77 for your work and community contribution!

I have replaced the old statsoos (0.5 version) folder with the new updated one and now the backoffice shows

an empty list, nothing selected from the DB.

The mailalerts module is version 2.2 since the new one didn;t previously work with the 0.5 version statsoos.

Should I replace the statsoos 0.5 back, uninstall and install the 1.6 version?

Or keep the new statsoos folder and update mailalerts module with the current one?

Kind Regards,

Robert

 

EDIT: to resume:

          the new 1.6 statoos with the 2.2 mailalerts doesn't work, the backoffice doesn't display any record from the mailalert_oos table;

          the new 1.6 statoos with the new mailaerts doesn't work either plus by upgrading to the latest mailalert the email textbox from the product pages (where the customer should input his address) disappears;

Edited by Rho_bur (see edit history)

Share this post


Link to post
Share on other sites
  • 4 weeks later...
 the new 1.6 statoos with the new mailaerts doesn't work either plus by upgrading to the latest mailalert the email textbox from the product pages (where the customer should input his address) disappears;

 

Same problem here, Prestashop versie 1.6.0.14

Share this post


Link to post
Share on other sites
Hello everyone

In my shop module works, I think it is necessary to install a new module and activate it.

The module is in the statistics, by the time cons is not good,

This must be updated since the Alert module.

I would look at the problem quietly, I do not have too much time now.

See you soon.

Share this post


Link to post
Share on other sites
Hello everyone,
 
This module work with : PS Version  1.6.0.14 
 
Well, I took the module, no problem, except for the date that was displayed most, following the update of Mail alert module.
 
We must change the email alert module file
 
in MailAlert.php
Line 41 add: public $ date_add;
line 55 add:,
line 56 add: 'date_add' => array ('type' => self :: TYPE_DATE, 'validate' => 'isDate')
 
class MailAlert extends ObjectModel
{
	public $id_customer;

	public $customer_email;

	public $id_product;

	public $id_product_attribute;

	public $id_shop;

	public $id_lang;
	
	public $date_add;

	/**
	 * @see ObjectModel::$definition
	 */
	public static $definition = array(
		'table' => 'mailalert_customer_oos',
		'primary' => 'id_customer',
		'fields' => array(
			'id_customer' => array('type' => self::TYPE_INT, 'validate' => 'isUnsignedInt', 'required' => true),
			'customer_email' => array('type' => self::TYPE_STRING, 'validate' => 'isEmail', 'required' => true),
			'id_product' => array('type' => self::TYPE_INT, 'validate' => 'isUnsignedInt', 'required' => true),
			'id_product_attribute' => array('type' => self::TYPE_INT, 'validate' => 'isUnsignedInt', 'required' => true),
			'id_shop' => array('type' => self::TYPE_INT, 'validate' => 'isUnsignedInt', 'required' => true),
			'id_lang' => array('type' => self::TYPE_INT, 'validate' => 'isUnsignedInt', 'required' => true),
			'date_add' => array('type' => self::TYPE_DATE, 'validate' => 'isDate')
		),
	);
in mailalert.php
line 109: `date_add` datetime NOT NULL,
 
$sql = 'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.MailAlert::$definition['table'].'`
				(
					`id_customer` int(10) unsigned NOT NULL,
					`customer_email` varchar(128) NOT NULL,
					`id_product` int(10) unsigned NOT NULL,
					`id_product_attribute` int(10) unsigned NOT NULL,
					`id_shop` int(10) unsigned NOT NULL,
					`id_lang` int(10) unsigned NOT NULL,
					`date_add` datetime NOT NULL,
					PRIMARY KEY  (`id_customer`,`customer_email`,`id_product`,`id_product_attribute`,`id_shop`)
				) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci';

The statoos module has been modified for dates FR format with the ability to switch to US comment the lines in the file statoos.php

 

The module statoos is visble in stat in "Customer out of stock" and in French : "Client en attente de stock"

 

ci joint nouvelle version

statsoos.zip

 

A bientôt

Bernard

Edited by bernard77 (see edit history)
  • Like 2

Share this post


Link to post
Share on other sites
  • 1 month later...

Good Evening  Bernard,

    I made that changes and checked I dont see any mail id in the stats section.  I installed the module on to the hosting server and checked the possiblities of mail not working in local. But I dont see any data in the customer out of stock section. 

Edited by sophia@wolabi (see edit history)

Share this post


Link to post
Share on other sites
Hello,

replaces the attached file by that.

After it is not normal that the table is full.

By dint I reversed the files ciprend full account id-shop

 

Have you done editing the file mailalert.php?

 

good luck

 

 


Share this post


Link to post
Share on other sites
  • 1 month later...
  • 2 weeks later...
  • 2 months later...

Hi,

 

Is it possible to add Reference# to result and sort data by Reference#? Product ID isn't very usable when I look for product to restock. Sorting by Reference# is (I believe not only in my case) helpful.

 

Thanks in advance

 

Lubos Vinar

Share this post


Link to post
Share on other sites
  • 2 weeks later...
  • 2 months later...

Hello,

 

thank you for great module!

It is working on my 1.6.1.2.

 

But I have few issues:

1. After click to product link from this module like http://bezpopelniku.cz/product.php?id_product=1 I can see only 404 page. Could you please let me know how can I change code to working? For product with ID 1 the real address is: http://bezpopelniku.cz/innokin/1-test.html

 

2. In attributes I can see only 1 attribute, but product has 2 attributes. One is resistance (which I can see) but the other one (which is out of stock) is color, and I cannot see it.

 

THANKS!

Share this post


Link to post
Share on other sites
  • 3 weeks later...
  • 1 month later...

it works in 1.6.1.4 but..... , iy you want delete any selection not works (says... Controller not found), and not delete the registration :/.

 

I think the module needs some update !!!!

Share this post


Link to post
Share on other sites
  • 1 month later...
  • 7 months later...
  • 2 months later...
  • 6 months later...
  • 4 months later...
  • 1 year later...
  • 1 month later...

Thanks you all for module OOS,

Not i have a tricky one, at least for me:

Can anybody tell me how we can do something about letting customer choose how many unavailable products they want.

Such as: "Notify me when "5" available"

If is another topic with this, please reply me with it, i can not find it.

Best Regards,

Marius

 

Share this post


Link to post
Share on other sites
  • 7 months later...

I have got it working in 1.6.1.22 with the attached files (make a backup before you use the files)

Upload the statsoos-module

mailalerts-files: unzip and upload to /modules/mailalerts

Note: dates only works for new registrations. If you have a list of customers waiting on products, the dates on those are not fixed.

statsoos.zip mailalerts-files.zip

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More