Recover Cart Sales

[kunal247]

Hi,

I have just installed this contribution v2.11 from new.

I am getting an error when I try and run tools> Recover Cart Sales

 

1054 - Unknown column 'customers_group_id' in 'field list'

 

select customers_group_id from customers where customers_id = ''

 

 

 

What could this be?

How do i fix this?

 

Aprreciate your expert help.

Thanks in advance.

Kunal

[♥Vger]

Was there by any chance an sql file you should have installed into your database when you installed this contribution?

 

Vger

[kunal247]

Was there by any chance an sql file you should have installed into your database when you installed this contribution?

 

Vger

<{POST_SNAPBACK}>

The SQL file installed was

CREATE TABLE `scart` (
  `scartid` INT( 11 ) NOT NULL AUTO_INCREMENT UNIQUE, `customers_id` INT( 11 ) NOT NULL UNIQUE, `dateadded` VARCHAR( 8 ) NOT NULL, `datemodified` VARCHAR( 8 ) NOT NULL, PRIMARY KEY ( `scartid` ));
INSERT INTO `configuration_group` ( `configuration_group_id` , `configuration_group_title` , `configuration_group_description` , `sort_order` , `visible` )
  VALUES ('6501', 'Recover Cart Sales', 'Recover Cart Sales (RCS) Configuration Values', '15', '1');
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
  VALUES ('', 'Look back days', 'RCS_BASE_DAYS', '30', "Number of days to look back from today for abandoned cards.", 6501, 10, NULL, NOW(), '', '');
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
  VALUES ('', 'Sales Results Report days', 'RCS_REPORT_DAYS', '90', "Number of days the sales results report takes into account. The more days the longer the SQL queries!.", 6501, 15, NULL, NOW(), '', '');
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
  VALUES ('', 'E-Mail time to live', 'RCS_EMAIL_TTL', '90', "Number of days to give for emails before they no longer show as being sent", 6501, 20, NULL, NOW(), '', '');
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
  VALUES ('', 'Friendly E-Mails', 'RCS_EMAIL_FRIENDLY', 'true', "If <b>true</b> then the customer's name will be used in the greeting. If <b>false</b> then a generic greeting will be used.", 6501, 30, NULL, NOW(), '', "tep_cfg_select_option(array('true', 'false'),");
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
  VALUES ('', 'E-Mail Copies to', 'RCS_EMAIL_COPIES_TO', '', "If you want copies of emails that are sent to customers by this contribution, enter the email address here. If empty no copies are sent", 6501, 35, NULL, NOW(), '', '');
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
  VALUES ('', 'Show Attributes', 'RCS_SHOW_ATTRIBUTES', 'false', "Controls display of item attributes.<br><br>Some sites have attributes for their items.<br><br>Set this to <b>true</b> if yours does and you want to show them, otherwise set to <b>false</b>.", 6501, 40, NULL, NOW(), '', "tep_cfg_select_option(array('true', 'false'),");
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
  VALUES ('', 'Ignore Customers with Sessions', 'RCS_CHECK_SESSIONS', 'false', "If you want the tool to ignore customers with an active session (ie, probably still shopping) set this to <b>true</b>.<br><br>Setting this to <b>false</b> will operate in the default manner of ignoring session data & using less resources.", 6501, 40, NULL, NOW(), '', "tep_cfg_select_option(array('true', 'false'),");
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
  VALUES ('', 'Current Customer Color', 'RCS_CURCUST_COLOR', '0000FF', "Color for the word/phrase used to notate a current customer<br><br>A current customer is someone who has purchased items from your store in the past.", 6501, 50, NULL, NOW(), '', '');
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
  VALUES ('', 'Uncontacted hilight color', 'RCS_UNCONTACTED_COLOR', '9FFF9F', "Row highlight color for uncontacted customers.<br><br>An uncontacted customer is one that you have <i>not</i> used this tool to send an email to before.", 6501, 60, NULL, NOW(), '', '');
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
  VALUES ('', 'Contacted hilight color', 'RCS_CONTACTED_COLOR', 'FF9F9F', "Row highlight color for contacted customers.<br><br>An contacted customer is one that you <i>have</i> used this tool to send an email to before.", 6501, 70, NULL, NOW(), '', '');
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
  VALUES ('', 'Matching Order Hilight', 'RCS_MATCHED_ORDER_COLOR', '9FFFFF', "Row highlight color for entrees that may have a matching order.<br><br>An entry will be marked with this color if an order contains one or more of an item in the abandoned cart <b>and</b> matches either the cart's customer email address or database ID.", 6501, 72, NULL, NOW(), '', '');
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
  VALUES ('', 'Skip Carts w/Matched Orders', 'RCS_SKIP_MATCHED_CARTS', 'true', "To ignore carts with an a matching order set this to <b>true</b>.<br><br>Setting this to <b>false</b> will cause entries with a matching order to show, along with the matching order's status.<br><br>See documentation for details.", 6501, 80, NULL, NOW(), '', "tep_cfg_select_option(array('true', 'false'),");
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
  VALUES ('', 'Autocheck "safe" carts to email', 'RCS_AUTO_CHECK', 'true', "To check entries which are most likely safe to email (ie, not existing customers, not previously emailed, etc.) set this to <b>true</b>.<br><br>Setting this to <b>false</b> will leave all entries unchecked (must manually check entries to send an email to).", 6501, 82, NULL, NOW(), '', "tep_cfg_select_option(array('true', 'false'),");
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
  VALUES ('', "Match orders from any date", 'RCS_CARTS_MATCH_ALL_DATES', 'true', "If <b>true</b> then any order found with a matching item will be considered a matched order.<br><br>If <b>false</b> only orders placed after the abandoned cart are considered.", 6501, 84, NULL, NOW(), '', "tep_cfg_select_option(array('true', 'false'),");
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
  VALUES ('', "Lowest Pending sales status", 'RCS_PENDING_SALE_STATUS', '1', "The highest value that an order can have and still be considered pending. Any value higher than this will be considered by RCS as sale which completed.<br><br>See documentation for details.", 6501, 85, NULL, NOW(), 'tep_get_order_status_name', 'tep_cfg_pull_down_order_statuses(');
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
  VALUES ('', 'Report Even Row Style', 'RCS_REPORT_EVEN_STYLE', 'dataTableRow', "Style for even rows in results report. Typical options are <i>dataTableRow</i> and <i>attributes-even</i>.", 6501, 90, NULL, NOW(), '', '');
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
  VALUES ('', 'Report Odd Row Style', 'RCS_REPORT_ODD_STYLE', '', "Style for odd rows in results report. Typical options are NULL (ie, no entry) and <i>attributes-odd</i>.", 6501, 92, NULL, NOW(), '', '');

 

Hope this helps in finding the problem.

I notice there is a Customer_id column in the database. should this be there?

 

Kunal

[kunal247]

Image of the SQL Database:

The SQL file installed was

CREATE TABLE `scart` (
? `scartid` INT( 11 ) NOT NULL AUTO_INCREMENT UNIQUE, `customers_id` INT( 11 ) NOT NULL UNIQUE, `dateadded` VARCHAR( 8 ) NOT NULL, `datemodified` VARCHAR( 8 ) NOT NULL, PRIMARY KEY ( `scartid` ));
INSERT INTO `configuration_group` ( `configuration_group_id` , `configuration_group_title` , `configuration_group_description` , `sort_order` , `visible` )
? VALUES ('6501', 'Recover Cart Sales', 'Recover Cart Sales (RCS) Configuration Values', '15', '1');
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
? VALUES ('', 'Look back days', 'RCS_BASE_DAYS', '30', "Number of days to look back from today for abandoned cards.", 6501, 10, NULL, NOW(), '', '');
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
? VALUES ('', 'Sales Results Report days', 'RCS_REPORT_DAYS', '90', "Number of days the sales results report takes into account. The more days the longer the SQL queries!.", 6501, 15, NULL, NOW(), '', '');
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
? VALUES ('', 'E-Mail time to live', 'RCS_EMAIL_TTL', '90', "Number of days to give for emails before they no longer show as being sent", 6501, 20, NULL, NOW(), '', '');
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
? VALUES ('', 'Friendly E-Mails', 'RCS_EMAIL_FRIENDLY', 'true', "If <b>true</b> then the customer's name will be used in the greeting. If <b>false</b> then a generic greeting will be used.", 6501, 30, NULL, NOW(), '', "tep_cfg_select_option(array('true', 'false'),");
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
? VALUES ('', 'E-Mail Copies to', 'RCS_EMAIL_COPIES_TO', '', "If you want copies of emails that are sent to customers by this contribution, enter the email address here. If empty no copies are sent", 6501, 35, NULL, NOW(), '', '');
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
? VALUES ('', 'Show Attributes', 'RCS_SHOW_ATTRIBUTES', 'false', "Controls display of item attributes.<br><br>Some sites have attributes for their items.<br><br>Set this to <b>true</b> if yours does and you want to show them, otherwise set to <b>false</b>.", 6501, 40, NULL, NOW(), '', "tep_cfg_select_option(array('true', 'false'),");
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
? VALUES ('', 'Ignore Customers with Sessions', 'RCS_CHECK_SESSIONS', 'false', "If you want the tool to ignore customers with an active session (ie, probably still shopping) set this to <b>true</b>.<br><br>Setting this to <b>false</b> will operate in the default manner of ignoring session data & using less resources.", 6501, 40, NULL, NOW(), '', "tep_cfg_select_option(array('true', 'false'),");
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
? VALUES ('', 'Current Customer Color', 'RCS_CURCUST_COLOR', '0000FF', "Color for the word/phrase used to notate a current customer<br><br>A current customer is someone who has purchased items from your store in the past.", 6501, 50, NULL, NOW(), '', '');
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
? VALUES ('', 'Uncontacted hilight color', 'RCS_UNCONTACTED_COLOR', '9FFF9F', "Row highlight color for uncontacted customers.<br><br>An uncontacted customer is one that you have <i>not</i> used this tool to send an email to before.", 6501, 60, NULL, NOW(), '', '');
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
? VALUES ('', 'Contacted hilight color', 'RCS_CONTACTED_COLOR', 'FF9F9F', "Row highlight color for contacted customers.<br><br>An contacted customer is one that you <i>have</i> used this tool to send an email to before.", 6501, 70, NULL, NOW(), '', '');
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
? VALUES ('', 'Matching Order Hilight', 'RCS_MATCHED_ORDER_COLOR', '9FFFFF', "Row highlight color for entrees that may have a matching order.<br><br>An entry will be marked with this color if an order contains one or more of an item in the abandoned cart <b>and</b> matches either the cart's customer email address or database ID.", 6501, 72, NULL, NOW(), '', '');
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
? VALUES ('', 'Skip Carts w/Matched Orders', 'RCS_SKIP_MATCHED_CARTS', 'true', "To ignore carts with an a matching order set this to <b>true</b>.<br><br>Setting this to <b>false</b> will cause entries with a matching order to show, along with the matching order's status.<br><br>See documentation for details.", 6501, 80, NULL, NOW(), '', "tep_cfg_select_option(array('true', 'false'),");
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
? VALUES ('', 'Autocheck "safe" carts to email', 'RCS_AUTO_CHECK', 'true', "To check entries which are most likely safe to email (ie, not existing customers, not previously emailed, etc.) set this to <b>true</b>.<br><br>Setting this to <b>false</b> will leave all entries unchecked (must manually check entries to send an email to).", 6501, 82, NULL, NOW(), '', "tep_cfg_select_option(array('true', 'false'),");
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
? VALUES ('', "Match orders from any date", 'RCS_CARTS_MATCH_ALL_DATES', 'true', "If <b>true</b> then any order found with a matching item will be considered a matched order.<br><br>If <b>false</b> only orders placed after the abandoned cart are considered.", 6501, 84, NULL, NOW(), '', "tep_cfg_select_option(array('true', 'false'),");
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
? VALUES ('', "Lowest Pending sales status", 'RCS_PENDING_SALE_STATUS', '1', "The highest value that an order can have and still be considered pending. Any value higher than this will be considered by RCS as sale which completed.<br><br>See documentation for details.", 6501, 85, NULL, NOW(), 'tep_get_order_status_name', 'tep_cfg_pull_down_order_statuses(');
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
? VALUES ('', 'Report Even Row Style', 'RCS_REPORT_EVEN_STYLE', 'dataTableRow', "Style for even rows in results report. Typical options are <i>dataTableRow</i> and <i>attributes-even</i>.", 6501, 90, NULL, NOW(), '', '');
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
? VALUES ('', 'Report Odd Row Style', 'RCS_REPORT_ODD_STYLE', '', "Style for odd rows in results report. Typical options are NULL (ie, no entry) and <i>attributes-odd</i>.", 6501, 92, NULL, NOW(), '', '');

 

Hope this helps in finding the problem.

I notice there is a Customer_id column in the database. should this be there?

 

Kunal

<{POST_SNAPBACK}>