Database Table Name for Recover Cart Sales v2.22

[losse2011]

Hi there

i'm trying to locate all my entries in my recover cart sales report. I've located the entries in my cart's admin site (Reports >> Recover Cart Sales) but would like to know what datatabase table these get stored in.

 

Thank you

[Guest]

Carlos,

 

Here is the SQL statement:

 

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` VALUES ('', 'Look back days', 'RCS_BASE_DAYS', '30', 'Number of days to look back from today for abandoned carts.', 6501, 10, NULL, '2010-11-12 06:00:58', '', '');

INSERT INTO `configuration` VALUES ('', 'Skip days', 'RCS_SKIP_DAYS', '5', 'Number of days to skip when looking for abandoned carts.', 6501, 11, NULL, now(),'', '');

INSERT INTO `configuration` 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` VALUES ('', 'Use Calculated taxes', 'RCS_INCLUDE_TAX_IN_PRICES', 'false', 'Try to calculate the tax when determining prices. This may not be 100% correct as determing location being shopped from, etc. may be incorrect.', 6501, 16, NULL, now(), '', 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES ('', 'Use Fixed tax rate', 'RCS_USE_FIXED_TAX_IN_PRICES', 'false', 'Use a fixed tax rate when determining prices (rate set below). Overridden if ''Use Calculated taxes'' is true.', 6501, 17, NULL, now(), '', 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES ('', 'Fixed Tax Rate', 'RCS_FIXED_TAX_RATE', '10.00', 'The fixed tax rate for use when ''Use Fixed tax rate'' is true and ''Use Calculated taxes'' is false.<br><br>Use decimal values, ie: 8.50 for 8 1/2%', 6501, 18, NULL, '2010-11-12 06:00:58', '', '');

INSERT INTO `configuration` 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` 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, '2010-11-12 06:00:58', '', 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` 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` 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` 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` 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` 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` 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` 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` 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` 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` 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` VALUES ('', 'Pending sales statuses', 'RCS_PENDING_SALE_STATUS', '3', 'Select the order statuses that can be considered as pending. This information is used to find a succesfull order from the same customer with the same products', 6501, 85, now(), '2010-11-12 06:00:58', 'tep_get_order_status_name', 'tep_cfg_pull_down_order_statuses(');

INSERT INTO `configuration` 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` VALUES (217, '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(), '', '');

 

As you can see, there is a new table named 'scart' created and then some new configuration values are created for the settings.

 

 

 

Chris

[losse2011]

thanks... so this creates the table then inserts the contacts into that table?

[Guest]

Carlos,

 

Actually, it just creates the table necessary that will hold the data. Your current data would have to be imported into the table (if you have any)

 

 

 

Chris

[losse2011]

Thanks Chris... I do have the data already... I just know where in the database it's located... for example, if I go in the OSCommerce admin site, I can click on "recover cart sales" and see the data all the way back to 2008. I want to grab those contacts but don't know where to grab it from in the database... I'm guessing it's stored in my site's database right?

[Guest]

Carlos,

 

yes, it is. You can log into your hosting account and use phpmyadmin to export the 'scart' table in CSV format, then you will be able to open it with MS Excel or any other spreadsheet program to extract the data you want.

 

 

 

Chris

[losse2011]

Thanks... scart doesn't have email addresses though... I noticed it's got customer_id... so I take it the contacts I'm looking for are in the customer table?