Community Add-Ons

Without below fix. This package only sends an e-mail to customers after first purchase and only after the first purchase. Credits go to original author, just changed a few sql statements.

FULL PACKAGE

For some reason last_modified value for the purchased items didnt worked for me so i changed a little code to look not in last modified date but in the date item was purchased, everything else works :



i installed this contribution and it didnt worked for me so i modified it a bit:

==========================
in reviews_mail.php FIND:
===========================

$orders_query = tep_db_query ("select o.customers_name,
o.customers_email_address,
o.orders_id,
o.last_modified
from " . TABLE_ORDERS . " o,
" . TABLE_CUSTOMERS . " c
where o.orders_status = '3'
and o.reminder_sent = '0'
and c.customers_id = o.customers_id
" . $newsletter_only . "
");


==================
AND REPLACE WITH:
==================

$orders_query = tep_db_query ("select o.customers_name,
o.customers_email_address,
o.orders_id,
o.date_purchased
from " . TABLE_ORDERS . " o,
" . TABLE_CUSTOMERS . " c
where o.orders_status = '3'
and o.reminder_sent = '0'
and c.customers_id = o.customers_id
" . $newsletter_only . "
");



==================================
As you can notice diference is in last_modified ( this value never modifies on purchase so i changed it to date_purchased
==================================





=====
FIND:
=====

if (strtotime ($orders_array['last_modified']) < $timestamp) { // Delay time has expired


=========
REPLACE:
=========


if (strtotime ($orders_array['date_purchased']) < $timestamp) { // Delay time has expired

Thanks to kymation who help me to set this contrib when you use downloads controller in your shop.

The Downloads Controller is causing problems with this contribution. I'm not familiar with the Downloads Controller, but the code posted here doesn't appear to be anything that would cause a problem. I can think of two possible solutions, and I would like for those of you seeing this problem to try them out.

1. Cut the following code from catalog/includes/functions/general.php
CODE
// BOF: WebMakers.com Added: Downloads Controller
require(DIR_WS_FUNCTIONS . 'downloads_controller.php');
// EOF: WebMakers.com Added: Downloads Controller

Then find the following code in catalog/includes/application_top.php
CODE
// define general functions used application-wide
require(DIR_WS_FUNCTIONS . 'general.php');

and paste the code you removed from general.php just below that code. Run review_mail.php manually and see if it now works.

Minor bug fixes, mostly found by the forum community:
Fixed minor errors in the instructions
Added a note about changing orders_status for modified stores
Fixed error in the emailed URL to the reviews page for stores not installed in the site root
Added the SQL bug fix by olsonsp4c

Thanks to everyone who helped with this.

If you use mySQL 4, this is the proper syntax for the SQL alter command (1 of 3 in commands in the sql file):

ALTER TABLE `orders` ADD `reminder_sent` TINYINT(1) NOT NULL default '0' AFTER `orders_status` ;

file is the revised sql.

Reviews are good for your business; they help customers make buying decisions, and they help search engines find your site.
The trick is getting your customers to review the products that they purchased.

This contribution sends an email to every customer asking them to review the product(s) they bought.
It can be scheduled to run a fixed number of days after the order has been marked completed. The
email that is sent is based on a template, so it is easy to modify to suit your business.

Support in the contribution forum thread here: http://forums.oscommerce.com/index.php?showtopic=280181