Back In Stock Notifications

[Ashely]

Hello Conor,

I really want the product model (or even with manufacturer) to be also included (just shown behind the $product_name) in the back-in-stock-notification subscription email. Because I hope to get a better idea of what is exactly wanted by the customer just from reading the notification email.

Is there a way to achieve that? Could you please show me which file(s) should I edit and what kind of codes should I add?

Thank you very much in advance.

Best Regards,
Ashely

[conor]

Hi Ashley,

Is there a way to achieve that? Could you please show me which file(s) should I edit and what kind of codes should I add?

You can easily add that functionality by modifying the file includes/modules/pages/back_in_stock_notification_subscribe/header_php.php

You can add a SQL lookup to populate a variable with the model and then add it to the e-mail as part of the product name, or edit the e-mail templates to add a "placement variable" to have it as a separate part of the e-mails.

Hope that helps!

All the best..

Conor
ceon

[Ashely]

Hello Conor,

Thank you very much for the quick reply.

I tried to edit the header_php.php file. But the product model was still not properly shown. The code I added to that file is as follows:

$product_model_query = "
    SELECT
        products_model
    FROM
        ". TABLE_PRODUCTS . "
    WHERE
        products_id = '" . (int) $_GET['products_id'] . "';";
$product_model_result = $db->Execute($product_model_query);
$product_model = $product_model_result->fields['products_model']; 

There must be some mistakes there. Could you please help me with that? Sorry, I know little about programming.

Thank you very much.

Best Regards,
Ashely

[conor]

Hi Ashely,

Thank you very much for the quick reply.

No problem. Glad you find the software useful!

I tried to edit the header_php.php file. There must be some mistakes there. Could you please help me with that? Sorry, I know little about programming.

You're most of the way there. Now you just need to use the $products_model variable.

Right after $form_errors = array(); put in the line:

$products_name .= ' ' . $products_model; 

This will add a space then the model to the name. (Which is the most basic way to get this information included in the e-mail.. personally I'd myself prefer to have it listed in the e-mail separately, but that's just the way I do things and this "quick fix" is what you were looking for I think!).

Hope that helps!

All the best...

Conor
ceon

[Ashely]

Thank you for the answer, Conor. Much appreciated!

Great! Now it works perfect! Product model clearly shows up. I just love this module even more. :-D

Thanks again,
Ashely

[jojo_cool]

Hi,

I uploaded all the files and the sql to the server. When I select "Back In Stock Notification" in the admin, it show "Not Found". I double checked the file location. It's correct.

Any idea why?