Printable View
Hi Woody,
Screenshot pleaseQuote:
Originally Posted by Woodymon
This is an very-very-very old "initial" bug.Quote:
Originally Posted by Woodymon
Before these records were also, but they showed no script. There are two options:
1. to hide these records
2. remove these records
I would like to suggest some features for this great mod.
- Sort carts by customers/not customers
- Select all carts
- Select all non-customer carts
- differentiate between customer who has abandonded cart with product A and who purchased product B
I really want this functionality and may even pay someone to do it but thought that I would put the ideas out here first.
Otherwise excellent mod.
I can not understand anything. About what "non-customer carts" you talk? Non-customer cart long live session alive. It is not relevant to the module "Recover Cart", which work only with CUSTOMERS.Quote:
Originally Posted by redmonds
You can e-mail me.
I am getting this error at admin->Reports->Recovered Cart Sales..
Warning: Invalid argument supplied for foreach() in /var/www/vhosts/domain.com/httpdocs/cart/admin/stats_recover_cart_sales.php on line 153
Any help would be awesome!
thanks,
buck
Buck,
Check post #199 from Andrew. I had the same error and his suggestion fixed it for me.
Thanks Andrew!
Fixed - Did it for Me, Yeehaw!
JOhn ><>
Jim & Andrew
Thanks a lot! Worked perfectly
buck
I have installed the sql patch. Had to adjust some of the table names as my store was installed with prefix "store" so for instance, "configuration_group" is "storeconfiguration_group" in my database. Created all sorts of fun in the sql statement, but it completed successfully, so hopefully it's all right.
I've uploaded the files without error. I see a CONFIGURATION > RECOVER CART SALES area and can set options.
Here's the rub. Under TOOLS I have nothing related to recover cart.
Suggestions? Did I miss some adjustment in the sql statement?
It sounds like an installation problem. I'd first check to be sure all the files got uploaded correctly.
Quote:
Originally Posted by jeking
Okay, looks like some of those files did not upload. Weird. Oh well, got the menu items now.
However, when I try to load the TOOLS or REPORTS pages I get a message like:
I don't have a storescart table, but the install did create a scart. Is that the problem?Quote:
1146 Table 'dmhostore.storescart' doesn't exist
Okay. I figured it out. For some reason I had to change the name of the table in the database to "storescart" and it works great.
However, it does not solve the problem for which I was hunting a solution.
It appears we have individuals going through the cart process, into PayPal but although their payment goes through PayPal there is no record of their order in Zen Cart admin. I only know they placed an order when one of them contacts me.
Anyone know where to find an answer to solve this? Is it possible to solve it? I searched and this was my closest hope.
Hi,
I installed Recover Cart Sales (RCS) for Zen Cart.
When I went to Reports> Recover Cart Sales Report, I got this error:
Warning: Invalid argument supplied for foreach() in /home/content/v/i/c/vickilapp/html/catalog/admin/stats_recover_cart_sales.php on line 153
On line 153 it says:
foreach($cust_array as $cust) {
Can someone tell me how to correct this? Thanks!
I get that same error as well does anyone have a fix or can explain what it means
Quote:
Originally Posted by vickilapp
Just wanted to add a quick note here about this mod:
I installed it about 1 month ago, and it is working fairly well. The interface page is slightly buggy (the display is sometimes out of whack or out of order), but we have figured out how to use it and understand what it means.
The good news is that this mod is by far the most "profitable" mod I have added to my website. I never realized before how many people leave stuff in their cart because they run into some small problem or get distracted by something else during the checkout process.
I also never realized how many of these people would respond favorably when we call them on the phone the next day to ask them if they had any trouble during checkout. My rough estimate is that 80% allow us to complete the order for them, i.e. we truly recover what would have been lost sales. I would guess we recover about one order on average per day. At around US$50 per order, that is good additional business!
:clap::clap::clap: for the creator of this mod!
Anyone found a fix for the below issues as of yet?
Quote:
Originally Posted by vickilapp
Can not be so lazy! http://www.zen-cart.com/forum/showpo...&postcount=199
Maybe you will be interested in my small contribution to "Recover Cart" module.
List of changes:
- added translation to polish (not strict, but formal, correct and tested)
- fixed "Invalid argument supplied for foreach()" error in one place (added "is_array" call)
- " " corrected in one place
- icon names changed to constants (works well in zencart_pl.1.3.7), I don't know how it works in other versions
By the way, this module is a nice piece of software, many thanks for it!
Address: http://republika.pl/piotrek_home/fil..._cart_0712.zip
The archive contains all PHP files including not changed files.
wasn't being lazy i searched for a few days using the error keywords but nothing came up thanks for you help
Quote:
Originally Posted by a_berezin
this is a great mod - so thanks...
One question though - where do you modify the outgoing email that is sent to a customer - is this inline code or is there a template html that it is picking up somewhere?
thanks
john
Have you tried using some of the text from the email and searching using the Developers Tool Kit? If I recall, the text is in a file somewhere.Quote:
Originally Posted by jarcher
I have the attributes selected as true, however when I run the recover cart sales reports the attributes do not show up. I've search for answer but haven't come up with anything, any help would be appreciated.
TanyasBathandBody.com
This is a GREAT mod! :clap:
I installed in 1.3.8a and added the fixes in http://www.zen-cart.com/forum/showpo...&postcount=199
And it works. This is an invaluable tool.
Thanks
I have looked for an answer to this but cannot find it. The link in the email goes to an error page and not to the product it's supposed to. The code to generate this link is:
I would also like my link to just be to mysite.com and not mysite.com/catalog/index.php?main_page=index The code for that line is:Quote:
<a href="' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. $basket->fields['products_id']) . '">' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. $basket->fields['products_id']) . "</a>
I know this is probably an easy fix, but I am not a coder so please help! Thanks :)Quote:
zen_catalog_href_link(FILENAME_DEFAULT);
Well, I fixed the closing of the email to have what I want. But the link to the product that the customer had in their cart is something I don't think I will ever get because it's a database query. The code is:Quote:
Originally Posted by Doodlebuckets
For the product in question, the link that is generated in the email is:Quote:
$cquery = $db->Execute("SELECT * FROM " . TABLE_ORDERS . " WHERE customers_id = '" . $cid . "'" );
if ($cquery->RecordCount() < 1) {
$email .= sprintf(EMAIL_TEXT_NEWCUST_INTRO, $mline);
} else {
$email .= sprintf(EMAIL_TEXT_CURCUST_INTRO, $mline);
}
1 x Valentine Teddy Bear
giftsofcharacter.com/catalog/index.php?main_page=product_info&products_id=395:c092a7870d3e389151055a5cba2da44 f
If you take off the ":c092a7870d3e389151055a5cba2da44f" part of the URL, it goes to the right place. How do I get rid of the extra stuff on the URL? I think it is probable that if a customer were to click that link to go back and purchase and it goes to an error page, they are much less likely to buy.
hi guys, have just updated the RCS and all went well except in "stats_recover_cart_sales" get
Warning: Invalid argument supplied for foreach() in /home/<domainname>/admin/stats_recover_cart_sales.php on line 153
foreach($cust_array as $cust) {
?>
must have somthing to do with this.
tips welcome
Craig
NZ
Quote:
Originally Posted by craiglove
I have the same issue...did you ever get this fixed?
Thanks,
Denise
I have the same problem. Does anyone know of a fix? I am using 1.3.8aQuote:
Originally Posted by craiglove
On your file admin/stats_recover_cart_sales.php replace the following code on line 96:
$custlist = '';
Replace with:
$cust_array = array();
It was posted here.
Thank you so much for the help. I totally appreciate it!
Denise
Hi, I have downloaded this mod, and I have to say its such an excellent idea!
I am wanting to change the email, so its slightly more relevant for our shop and more personal.
I have found where the email is created (shop/admin/includes/languages/english/recover_cart_sales.php) so no problem editing the actual text there.
The one thing I want to remove is the shopping cart contents that appears in the email between 'EMAIL_TEXT_BODY_HEADER' and 'EMAIL_TEXT_BODY_FOOTER'. I was wondering someone could tell me which bit of code (and where) I need to delete to remove the contents of the shopping cart from the email.
I think you may find that the fix suggests you add $cust_array = array(); below the $custlist = ''; and not replace that line.........
Quote:
Originally Posted by bigjoed
For ZenCart Version 1.3.8a the following install worked for me:
From the ZenCart Downloads section:
Download and install "Recover Cart Sales" V3.0 August 12 2007.
Modify admin/stats_recover_cart_sales.php as follows:
find around line 96:
change to:Code:$custlist = '';
Code:$custlist= '';
$cust_array = array();
Modify admin/recover_cart_sales.php as follows:
Find around line 381:
change to:Code:if ((time()-(RCS_EMAIL_TTL*24*60*60)) <= strtotime($basket->fields['datemodified'])) {
These modifications are the same as posted by Andrew Berezin in post #199. I can confirm that this modification works with ZenCart version 1.3.8a with the listed modifications installed.Code:if ($basket->fields['datemodified'] != '' && (time()-(RCS_EMAIL_TTL*24*60*60)) <= strtotime($basket->fields['datemodified'])) {
I have this installed with 1.38 and have applied the patches. When testing, existing customers receive the EMAIL_TEXT_NEWCUST_INTRO rather than the EMAIL_TEXT_CURCUST_INTRO.
Can someone confirm that EMAIL_TEXT_CURCUST_INTRO is being sent on their install?
If you receive an error message on line 153 of stats_recover_cart_sales.php regarding an invalid argument supplied for the foreach() function, then before line 119:
add:PHP Code:if (!$orders->EOF) {
$custknt++;
$total_recovered += $orders->fields['value'];
$cust_array[$custknt] = array_merge($scart->fields, $orders->fields);
}
PHP Code:$cust_array = array();
Hi,
I have been editing the recover_cart_sales.php to customize the email sent out. I do want to make it more personal by having the customers first name only. Can anyone help with how I can achieve this. TIA
i have the fllowing error on the reports tool of this mod. getting this error,
Warning: Invalid argument supplied for foreach() in /public_html/store/admin/stats_recover_cart_sales.php on line 153
this is in the Amount section of the table. This is a fress install on 1.3.7. is this error because the mod has no detils to work with yet or is it a problem??
Perhaps scrolling up 2 posts might give you the answer you're seeking?
fixed thanks, i did see the post but thought i would post the whole error code as this help people searching for the error code etc :D
I would really like to know the answer to this, too. Using the last name in emails is just WAY too impersonal for my customers, too.Quote:
Originally Posted by naturalolive
Any help is welcomed and appreciated.
Zencart ROCKS!
So as to not confuse anyone, my post had a mistake. The change should be added before the loop at around line 97 as someone else had mentioned.
which fix are you refering to??Quote:
Originally Posted by numinix
Hi PPL
Thanks for this great contribution... simple question does this work on Zen Cart Version 1.3.8 and if not are there any plans or release date for recover cart sales for this version
Thanks
I've the same issue: where's the solution?Quote:
Originally Posted by Doodlebuckets
I'll grant that it's not a pretty looking url but it works just fine. It won't give an error unless something else is wrong with your site.Quote:
Originally Posted by 100asa
With all do respect, if this is the top of your to-do list, I envy you.
Unfortunately, as Doodlebuckets said, if customer click the complete urlQuote:
Originally Posted by jeking
giftsofcharacter.com/catalog/index.php?main_page=product_info&products_id=395:c092a7870d3e389151055a5cba2da44 f
it goes on error page
That's not how I read her post. She wrote 'I think it is probable that if a customer were to click that link to go back and purchase and it goes to an error page, they are much less likely to buy.'Quote:
Originally Posted by 100asa
'if' it was an error page. Try the link, it goes to the product page not an error.
sometimes, as this email, I've this link:
http://www.100asa.it/index.php?main_...ae4108dfcd5a2b
as you see, it goes on page not found.
If I cut the :8dba468e673d03b12eae4108dfcd5a2b, it goes well.
It looks like you've got an url rewrite mod installed. Oops, so does doodlebuckets. Maybe her version does not affect the links while yours does.Quote:
Originally Posted by 100asa
Does this happen with the links in all your emails or only some?
It's right! I've this mod http://www.zen-cart.com/index.php?ma...roducts_id=231
installed. This happen sometimes.
Hi,
Today I've discovered a problem with the Recover Cart Sales module (which is still great - been using it for a few months now without a hitch).
There is one abandoned cart which is displayed with no title row above it (that is, no customer details), and no "Cart Total" / "Set Contacted" / "Delete" section below it (see screenshot below).
So we cannot figure out who created this cart, and cannot do much about it....
Any ideas?
This is what it looks like, alongside other abandoned carts (I've removed customer details to protect their privacy):
http://img149.imageshack.us/img149/7...problemdv6.jpg
Thanks in advance.
I just installed and all I see is a configuration menu item "recover cart" and not the other two menu items. Any ideas?
Try uploading the files again and make sure they go into the correct folders.Quote:
Originally Posted by tbaquatics
JOhn ><>
I just installed the mod and have the same issue. It did not show until I deleted a few pass carts......Quote:
Originally Posted by bodyjewelrystores
Quote:
Originally Posted by Doodlebuckets
Hey Doodlebuckets. I ran into the same issue. I'm sure there is a better way of fixing this issue, but this is what I did.
Just replace the line above with this:
Code:$mline .= ' <blockquote><a href="' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. str_replace(strrchr($basket->fields['products_id'], ":"), "", $basket->fields['products_id'])) . '">' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. str_replace(strrchr($basket->fields['products_id'], ":"), "", $basket->fields['products_id'])) . "</a></blockquote>\n\n";
Is there a way to keep user carts even if they remove items from their own cart, i'd like to know not just when a cart is abandoned but when items are removed so i can try to close a sale, i'm sure there are customers removing items for any number of reasons but if we could see that information as well it would help our conversion rates. Has anyone done a mod like this or have suggestions on how to do it?
Thanks
This looks like a great mod.
I hope there are not too many issues vs 1.3.8 since the official download is 1.3.7.
Is there a way to set this up as a cronjob? What file would you execute?
Thanks!
You can not use this module to run as a cronjob. To do this you need an additional file.Quote:
Originally Posted by Doodlebuckets
I installed this mod but into only works hit or miss. When I go to the recover cart sales report it doesn't show any abandoned carts. If i refresh the page a couple times or go back to start and then click the recover cart report again I can get abandoned carts to show up. Now it's been a couple days and Analytics is showing abandoned check out funnels but im not seeing any change to my recover cart report.
Also, it was stated in the readme that when i ran the sql install file it would delete all of the old carts? well that didn't happen when i ran the file. I can call up all of the old carts in the recover cart report. I don't think the script gave me any errors.
Confused!
looks like he has changed his sig. Emails are enabled for HTML in admin. How do I get it to send emails in HTML?Quote:
Originally Posted by heavenlynights
Thanks in advance!
No one can tell me what I can do to send emails in HTML format? No one? :cry:Quote:
Originally Posted by Fireflyz
Emails should be sent in both HTML and plain text. It depends on the recipients email preference set in "MY ACCOUNT."Quote:
Originally Posted by Fireflyz
Yes, that was it! I feel like such a retard, now. Thank you! :smile:Quote:
Originally Posted by numinix
Somethings I would like to change if I can is:
1) get ride of the stores link under Sincerely, Owner Name Then Store link, I would like the store owner's to still be a hyperlink, but I dont want the address listed
2) Login to your account here: address ............ I would like it to say "Login" or Click here instread of listing the link.
Thank you!
1) edit the email template directly in either /email/ or /emails/ (sorry I'm not looking at the ZC directory structure right now).Quote:
Originally Posted by ryanb4614
2) Search for the defined text using the Developer's Toolkit and then modify the file that contains the definition.
I'm using ZC 1.38a. Has anyone used the RC mod with the Multi-sites mod? It'd be great if the links in the email message directed the customer to the specific site (theme) they shopped on and not to the main site. Thanks in advance for any responses.
I have this problem as well. Everything else with the recover cart sales mod works fine. I am running 1.37 and the last recover cart sales script. Has anyone else ever seen this?Quote:
Originally Posted by tanyar2515
hello, I've installed this mod before on zen cart 1.3.7 then I did the upgrade and now I have 1.3.8a.
But I have a problem that I think it is caused from this mod .
I have an italian mod, iwsmile payiment with credit card, so in some cases it is that the client buy but I don't see order in zen cart, but I see the payiment.
So this is after the installation of this mod.
I would to know to verify if it this mod how can I uninstall?
I have installed with upload of file sql and upload of all files, now how can I uninstall the record in database created by sql?
Please
Thank you
:smile:
Does anyone know if there's a particular lag between a cart being abandoned and the customer showing up in the report? I see several abandoned carts, but I logged in to do a test and the cart I abandoned isn't showing up. It's been about 30 mins.
There shouldn't be a delay. You do need to log out for it to show up.
Any suggestions or thoughts on this problem?Quote:
Originally Posted by bestore
I'm having problems loading the sql file.
Here's what I'm getting:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE scart ( scartid int(11) NOT NULL auto_increment, customers_id int(1' at line 1
and then it goes on and on...
I use ZC 1.3.8a
Any ideas?
Hi all,
I just installed the file onto a linux server (godaddy) and when I went to install the sql patch via admin panel I got the folling message:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE scart ( scartid int(11) NOT NULL auto_increment, customers_id i' at line 1
in:
[DROP TABLE IF EXISTS scart; CREATE TABLE scart ( scartid int(11) NOT NULL auto_increment, customers_id int(11) NOT NULL default '0', dateadded varchar(8) NOT NULL default '', datemodified varchar(8) NOT NULL default '', PRIMARY KEY (scartid), UNIQUE KEY customers_id (customers_id), UNIQUE KEY scartid (scartid) ) TYPE=MyISAM; SET @configuration_group_id=0; SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Recover Cart Sales' LIMIT 1; DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id; DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id; INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'Recover Cart Sales', 'Recover Cart Sales (RCS) Configuration Values', '1', '1'); SET @configuration_group_id=last_insert_id(); UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id; SET @configuration_group_id=0; SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Recover Cart Sales' LIMIT 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 (NULL, 'Look back days', 'RCS_BASE_DAYS', '30', 'Number of days to look back from today for abandoned cards.', @configuration_group_id, 10, NULL, NOW(), NULL, NULL), (NULL, '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!.', @configuration_group_id, 15, NULL, NOW(), NULL, NULL), (NULL, 'E-Mail time to live', 'RCS_EMAIL_TTL', '90', 'Number of days to give for emails before they no longer show as being sent', @configuration_group_id, 20, NULL, NOW(), NULL, NULL), (NULL, 'Friendly E-Mails', 'RCS_EMAIL_FRIENDLY', 'true', 'If true then the customer\'s name will be used in the greeting. If false then a generic greeting will be used.', @configuration_group_id, 30, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Show Attributes', 'RCS_SHOW_ATTRIBUTES', 'false', 'Controls display of item attributes.
Some sites have attributes for their items.
Set this to true if yours does and you want to show them, otherwise set to false.', @configuration_group_id, 40, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, '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 true.
Setting this to false will operate in the default manner of ignoring session data & using less resources', @configuration_group_id, 40, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Current Customer Color', 'RCS_CURCUST_COLOR', '0000FF', 'Color for the word/phrase used to notate a current customer
A current customer is someone who has purchased items from your store in the past.', @configuration_group_id, 50, NULL, NOW(), NULL, NULL), (NULL, 'Uncontacted hilight color', 'RCS_UNCONTACTED_COLOR', '80FFFF', 'Row highlight color for uncontacted customers.
An uncontacted customer is one that you have not used this tool to send an email to before.', @configuration_group_id, 60, NULL, NOW(), NULL, NULL), (NULL, 'Contacted hilight color', 'RCS_CONTACTED_COLOR', 'FF9FA2', 'Row highlight color for contacted customers.
An contacted customer is one that you have used this tool to send an email to before.', @configuration_group_id, 70, NULL, NOW(), NULL, NULL), (NULL, 'Matching Order Hilight', 'RCS_MATCHED_ORDER_COLOR', '9FFF22', 'Row highlight color for entrees that may have a matching order.
An entry will be marked with this color if an order contains one or more of an item in the abandoned cart and matches either the cart\'s customer email address or database ID.', @configuration_group_id, 72, NULL, NOW(), NULL, NULL), (NULL, 'Skip Carts w/Matched Orders', 'RCS_SKIP_MATCHED_CARTS', 'true', 'To ignore carts with an a matching order set this to true.
Setting this to false will cause entries with a matching order to show, along with the matching order\'s status.
See documentation for details.', @configuration_group_id, 80, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, '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.
See documentation for details.', @configuration_group_id, 85, NULL, NOW(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses('), (NULL, 'Report Even Row Style', 'RCS_REPORT_EVEN_STYLE', 'dataTableRow', 'Style for even rows in results report. Typical options are dataTableRow and attributes-even.', @configuration_group_id, 90, NULL, NOW(), NULL, NULL), (NULL, 'Report Odd Row Style', 'RCS_REPORT_ODD_STYLE', '', 'Style for odd rows in results report. Typical options are NULL (ie, no entry) and attributes-odd.', @configuration_group_id, 92, NULL, NOW(), NULL, NULL), (NULL, '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', @configuration_group_id, 35, NULL, NOW(), NULL, NULL), (NULL, '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 true.
Setting this to false will leave all entries unchecked (you will have to check each entry you want to send an email for).', @configuration_group_id, 82, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Match orders from any date', 'RCS_CARTS_MATCH_ALL_DATES', 'true', 'If true then any order found with a matching item will be considered a matched order.
If false only orders placed after the abandoned cart are considered.', @configuration_group_id, 84, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Can anyone help with what I need to do in order to fix this problem.
Hi, is possible close abandoned cart from admin????
Thanks.
Let look at the Creat Table part where you got error at line 1. Since you already had scartid int(11) NOT NULL auto_increment, & set scartid as unique key. Then you also set scartid as Primary key. Both do the same job.
So you have:
CREATE TABLE
scart ( scartid int(11) NOT NULL auto_increment,
customers_id int(11) NOT NULL default '0',
dateadded varchar(8) NOT NULL default '',
datemodified varchar(8) NOT NULL default '',
PRIMARY KEY (scartid), < = REMOVE THIS
UNIQUE KEY customers_id (customers_id),
UNIQUE KEY scartid (scartid) )
TYPE=MyISAM;
Then you will have:
this this. just replace this part in your sql file. Hope it works.
CREATE TABLE
scart ( scartid int(11) NOT NULL auto_increment,
customers_id int(11) NOT NULL default '0',
dateadded varchar(8) NOT NULL default '',
datemodified varchar(8) NOT NULL default '',
UNIQUE KEY customers_id (customers_id),
UNIQUE KEY scartid (scartid) )
TYPE=MyISAM;
Quote:
Originally Posted by Bruce1952
L88K thanks for your advise on the problem that I had but I ended up working it out and all is working ok now and it is a great little add on.
Hello,
I'm using ZenCart version v.1.3.7.1
I have had RCS version v.3.00 installed and working perfectly for quite some time.
I recently have this error when I navigate to the "Tools/Recover Cart Sales" page:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Studio Joel Dumont") AND date_purchased >= "20090420"' at line 5
in:
[SELECT orders_id, orders_status FROM joker_orders WHERE (customers_id = 3866 OR customers_email_address like "removed##########################" OR customers_name like "Removed"s Studio Joel Removed") AND date_purchased >= "20090420"]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
I now cannot use the RCS module as the "send" button is not available on the page? Any idea on how to get this corrected? Thank You.
Very weird...
I deleted the customer from my ZenCart, and now the RCS module is working again. I'm not sure what caused the error in RCS regarding the customer, but it is working now.
Hi, please hint me with this:
how i include actual price in line with product name?
i not mean products_price, i mean price showed in cart...
here is constructor:
$mline .= $basket->fields['customers_basket_quantity'] . ' x ' . $products->fields['name'] . "\n";
$mline .= ' <blockquote><a href="' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. $basket->fields['products_id']) . '">' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. $basket->fields['products_id']) . "</a></blockquote>\n\n";
$basket->MoveNext();
but i not know, how add (where from get)
1) price (actual, not street price products_price) per line
2) date of cart
thanx for link to any docs
ReplaceQuote:
Originally Posted by Holz
byCode:cb.customers_basket_quantity,
Code:cb.customers_basket_quantity, cb.final_price,
$basket->fields['final_price']Quote:
Originally Posted by Holz
$basket->fields['customers_basket_date_added']Quote:
Originally Posted by Holz
DB table customers_basketQuote:
Originally Posted by Holz
I just downloaded the new v.3.00b of this mod.
I have v3.0 installed now.
I noticed that i have a fix in my v.3.0 version on line 382. this fixed was implemented from instructions from http://www.zen-cart.com/forum/showth...329#post443329.
I don't see this similar fix in the new version. I'm just curious if this fix is implemented.
Thanks
Hello,Quote:
Originally Posted by a_berezin
thanx, but i have all rows final_price filled with 0.0000, you not?
And if you not, i ask for actual price today (when generate mails), not for price actal in long time before... :(
You got what you asked:Quote:
Originally Posted by Holz
If you need the final price - take it from the tables of goods. If you need an actual price with all discounts and actions - use function zen_get_products_actual_price.Quote:
Originally Posted by Holz
Hi,
Thanks for the nice add-on but I have a problem on "Reports > Recovered Sales Results". I used a test account to resubmit the abandoned carts and I noticed that it disappeared from "Tools > Recover Cart Sales" but it did not display as a 'recovered' cart within "Reports > Recovered Sales Results"!:(
Why and how to deal with?
Thanks in advanced,
Hi! Please:
1054 Unknown column 's.datemodified' in 'field list'
in:
[SELECT s.scartid, s.customers_id, s.dateadded, s.datemodified, c.customers_firstname, c.customers_lastname, c.customers_email_address FROM scart s LEFT JOIN customers c ON (s.customers_id = c.customers_id) WHERE dateadded >= '19700101' ORDER BY dateadded DESC]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
What's it?:(
Version 1.3.8
How can I tell what products my customers have in their cart. The program is working fine but I cant see any attributes for each product.
Hi,
I'm considering installing this mod but was wondering - are emails only sent manually through the admin or can emails be scheduled to go out for all abandoned carts from the previous day (or some other time interval)?
thanks
Don
It's a manual process. When you click the button, the emails go out. I do it every morning for any carts from the previous day.
Gotcha...thanks for the quick response.Quote:
Originally Posted by jeking
I'd like to modify the email sent from recover cart. Where can I find the file?
Thanks :)
This is my issue:
1146 Table 'lorig0_zc1.zen_scart' doesn't exist
in:
[SELECT s.scartid, s.customers_id, s.dateadded, s.datemodified, c.customers_firstname, c.customers_lastname, c.customers_email_address FROM zen_scart s LEFT JOIN zen_customers c ON (s.customers_id = c.customers_id) WHERE dateadded >= '19691231' ORDER BY dateadded DESC]
Thanks for any help!
I am using Zen 1.38
Quote:
Originally Posted by travel124
I am still looking for help with this one..
Any answers?
Thanks!
This specifically means that a table is missing (or named differently from what the SQL query is looking for.)Quote:
Originally Posted by travel124
Here are some things to look at for correcting it.
1) Make sure you ran the SQL Install that came with the contribution. If you did not, run that. If you did, re-run it from within the admin (Tools > SQL Patches) to make sure nothing was missed. This will install the correct tables needed to allow the contribution to run.
Report back here with results so I can help you through it.
2) If you ran the SQL install but did so through a tool like PHPMyAdmin, then re-run it as indicated above (from within the admin of the cart). This will automatically add the proper prefix (if needed) to the SQL query.
Currently it is a manual process, but I am working on completing an automated process for it that will be able to be customized by time of day and number of times per day (like every hour, etc...) which gives you more flexibility at recovering more sales. (ideally you would track the recovers with your analytics and then determine how often is best for highest recovery.Quote:
Originally Posted by jeking
For exampel, I found that with some clients sending the email 2 hours after the cart was abandoned gets the best results (highest conversion) yet with others that may be once per day etc...)
Once I have the automated version ready and tested, it will be available to members of my online coaching program for free. (I have a number of mods I develop for others that I include here which I have not released.) For info on that program you can goto:
Ecommerce Amplifier
To alter the cart message you'll need to edit the following file:Quote:
Originally Posted by deb
/admin/includes/languages/english/recover_cart_sales.php
I am getting this error...........................Quote:
Originally Posted by econcepts
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE scart ( scartid int(11) NOT NULL auto_increment, customers_id int' at line 1
in:
[DROP TABLE IF EXISTS zen_scart; CREATE TABLE scart ( scartid int(11) NOT NULL auto_increment, customers_id int(11) NOT NULL default '0', dateadded varchar(8) NOT NULL default '', datemodified varchar(8) NOT NULL default '', PRIMARY KEY (scartid), UNIQUE KEY customers_id (customers_id), UNIQUE KEY scartid (scartid)) TYPE=MyISAM;SET @configuration_group_id=0;SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Recover Cart Sales' LIMIT 1;DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'Recover Cart Sales', 'Recover Cart Sales (RCS) Configuration Values', '1', '1');SET @configuration_group_id=last_insert_id();UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;SET @configuration_group_id=0;SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Recover Cart Sales' LIMIT 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 (NULL, 'Look back days', 'RCS_BASE_DAYS', '30', 'Number of days to look back from today for abandoned cards.', @configuration_group_id, 10, NULL, NOW(), NULL, NULL),(NULL, '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!.', @configuration_group_id, 15, NULL, NOW(), NULL, NULL),(NULL, 'E-Mail time to live', 'RCS_EMAIL_TTL', '90', 'Number of days to give for emails before they no longer show as being sent', @configuration_group_id, 20, NULL, NOW(), NULL, NULL),(NULL, 'Friendly E-Mails', 'RCS_EMAIL_FRIENDLY', 'true', 'If true then the customer\'s name will be used in the greeting. If false then a generic greeting will be used.', @configuration_group_id, 30, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),(NULL, 'Show Attributes', 'RCS_SHOW_ATTRIBUTES', 'false', 'Controls display of item attributes.
Some sites have attributes for their items.
Set this to true if yours does and you want to show them, otherwise set to false.', @configuration_group_id, 40, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),(NULL, '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 true.
Setting this to false will operate in the default manner of ignoring session data & using less resources', @configuration_group_id, 40, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),(NULL, 'Ignore Repeat Customers', 'RCS_CHECK_REPEAT', 'false', 'Setting this to true will cause recover cart sales to ignore abandoned carts by repeat customers', @configuration_group_id, 45, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),(NULL, 'Current Customer Color', 'RCS_CURCUST_COLOR', '0000FF', 'Color for the word/phrase used to notate a current customer
A current customer is someone who has purchased items from your store in the past.', @configuration_group_id, 50, NULL, NOW(), NULL, NULL),(NULL, 'Uncontacted hilight color', 'RCS_UNCONTACTED_COLOR', '80FFFF', 'Row highlight color for uncontacted customers.
An uncontacted customer is one that you have not used this tool to send an email to before.', @configuration_group_id, 60, NULL, NOW(), NULL, NULL),(NULL, 'Contacted hilight color', 'RCS_CONTACTED_COLOR', 'FF9FA2', 'Row highlight color for contacted customers.
An contacted customer is one that you have used this tool to send an email to before.', @configuration_group_id, 70, NULL, NOW(), NULL, NULL),(NULL, 'Matching Order Hilight', 'RCS_MATCHED_ORDER_COLOR', '9FFF22', 'Row highlight color for entrees that may have a matching order.
An entry will be marked with this color if an order contains one or more of an item in the abandoned cart and matches either the cart\'s customer email address or database ID.', @configuration_group_id, 72, NULL, NOW(), NULL, NULL),(NULL, 'Skip Carts w/Matched Orders', 'RCS_SKIP_MATCHED_CARTS', 'true', 'To ignore carts with an a matching order set this to true.
Setting this to false will cause entries with a matching order to show, along with the matching order\'s status.
See documentation for details.', @configuration_group_id, 80, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),(NULL, '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.
See documentation for details.', @configuration_group_id, 85, NULL, NOW(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses('),(NULL, 'Report Even Row Style', 'RCS_REPORT_EVEN_STYLE', 'dataTableRow', 'Style for even rows in results report. Typical options are dataTableRow and attributes-even.', @configuration_group_id, 90, NULL, NOW(), NULL, NULL),(NULL, 'Report Odd Row Style', 'RCS_REPORT_ODD_STYLE', '', 'Style for odd rows in results report. Typical options are NULL (ie, no entry) and attributes-odd.', @configuration_group_id, 92, NULL, NOW(), NULL, NULL),(NULL, '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', @configuration_group_id, 35, NULL, NOW(), NULL, NULL),(NULL, '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 true.
Setting this to false will leave all entries unchecked (you will have to check each entry you want to send an email for).', @configuration_group_id, 82, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),(NULL, 'Match orders from any date', 'RCS_CARTS_MATCH_ALL_DATES', 'true', 'If true then any order found with a matching item will be considered a matched order.
If false only orders placed after the abandoned cart are considered.', @configuration_group_id, 84, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
With regard to your latest error: How are you trying to run the query? Are you running it from within the Zen Cart admn (via the patch tool) or are you running it through a PHPMyAdmin interface?
Also do NOT try to use the "upload" function to run the query (if running from the Zen Cart admin) but rather copy and paste the query into the space provided within the Admin. The upload is not as reliable.
The error (that you report now) specifically means that the query (likely the first one as that is where the processing stops) you are attempting to run has some type of error in it (like a missing quote or something.)
See if you can answer those questions for me and let me know if it gets you any further.
Hi econcepts,
I'd like to say a big thank you for an invaluable mod. This has helped me identify a 50%(!) bail out rate on one of my clients sites.
I do have a question though: Do you have any idea of the legality of contacting customers who have bailed on a transaction? Could it be construed as an unsolicited marketing email / phone call? I have one client in particular who is conerned about directly making contact.
I also have a feature request: It would be really handy to have an "Export to CSV" button on the results view. For one thing, we could then check names, numbers and email addresses against a CRM system to see if the people who bailed then made a purchase over the phone.
Thanks again!
Al
Al,Quote:
Originally Posted by Ked
Glad you like it. I originally did not create the mod but seeing that it has gone dormant for some time I am adding to it as I see fit. I'll certainly look at the ability to work your suggestion in.
I've got an "Export Order to CSV" mod already that is popular so I may be able to merge to two to some degree.
Got a few other items I am testing with it on my end as well.
As far as contacting customers etc... and it being seen as unsolicited email, I am not an attorney so can't give exact advice on that. I can speak from experience and say that from my use of the tool I find it mixed. Few people ask to "remove me from the list" (which they are never on one anyhow as this is a one time thing I do with the cart.)
In those cases however, I make sure they never get anything again. Typically I run one follow-up based on the "best tested time to contact" and leave it at that. I've been able to generate 30-40% or more recovery on previously lost sales with the right items in place.
I would say let your client be the judge of what they want and what they don't feel comfortable with. If nothing else, they could test it (I'm a big fan of testing everything) to see if it fits their business model.
No problems installing it, could you or anyone tell me how to get rid of "Zen-Cart art of e-commerce" image from the e-mail ?
Tried searching the forum, but perhaps not searching properly.
Much appreciated.
Zee