Jack_mcs Posted February 19, 2018 Share Posted February 19, 2018 (edited) This addon provides a way to merge two customer accounts. It will move all orders from one account to the another and add the account details of the From account into the address book of the To account. Once the changes have been made, the From account is deleted. It is compatible with all versions of oscommerce. Edited February 19, 2018 by Jack_mcs Dan Cole 1 Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
♥Dan Cole Posted February 19, 2018 Share Posted February 19, 2018 Jack does this need to move the account details from the old account to the new or more recent account? Can that be optional? I can see this being useful to merge old accounts with newer ones but I wouldn't want to carry old address information forward. Dan Quote Need help? See this thread and provide the information requested. Is your version of osC up to date? You'll find the latest osC community version (CE Phoenix) here. Link to comment Share on other sites More sharing options...
Jack_mcs Posted February 20, 2018 Author Share Posted February 20, 2018 It isn't coded as an option but that can be added. I'll add to the next version. To remove it for now, remove this code from the admin/merge_accounts.php file array('table' => 'address_book', 'field' => 'customers_id'), Dan Cole 1 Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
♥kennyk Posted February 20, 2018 Share Posted February 20, 2018 Hi Jack, I installed the Merge Accounts add on and am getting the following error: Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 32 bytes) in /home/admin/web/mydomain.com/public_html/catalog/admin/includes/functions/database.php on line 103 Any suggestions for a fix? Thanks for any help. Ken Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted February 20, 2018 Author Share Posted February 20, 2018 That usually happens when the data being read in is too large for the server to allow. The script is trying to load in customers and then populate three lists and if the number of customers you have is huge, then this could happen. You can see how many customers you have in the Customers section of admin (down at the bottom). I have this installed in a shop that has 8,000 customers and it is working fine so yours would have to be considerably larger if this is the problem. It could also be that your host has the memory limit for your account controlled in some way that is stopping it. From the error, the script used 132 MB which is about standard in todays hosting. But there might be local settings overriding that. You could ask your host to check the memory setting and ask why you are running out of it. They will most likely say it is the script, which it may be, but since it works in other shops that seems unlikely. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
♥kennyk Posted February 20, 2018 Share Posted February 20, 2018 Thanks Jack. Yes, I have more customers than 8K. I'll check in to this further and see if there's something I can change with my server configuration. Quote Link to comment Share on other sites More sharing options...
♥kennyk Posted February 20, 2018 Share Posted February 20, 2018 I was able to increase the php memory and this fixed this error. With the number of customers I have it takes a very long time to build the lists and actually causes the browser to stop responding to build them. In fact, the browser never did compete the build of the customer selection menus. I would imagine once built it would not easy to find the accounts you want to merge. If I might venture an enhancement/change would be to provide Merge From and To fields for searching for the customer accounts to merge rather than build selection menus. You could still have the option to click for menu selection based on one of the three criteria you offer for those who want to select them using that method. For me I would know the email addresses of the accounts I want to merge so this would be quick and assured to get the correct two accounts. Thank you for your efforts with this excellent addition! Ken Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted February 20, 2018 Author Share Posted February 20, 2018 You are correct. When I first added the lists I thought there might be a problem with sites that had a large number of customers or were on servers with low memory settings. I intended to go back and change that but ran out of time. I will change it in the next version. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
♥kennyk Posted February 22, 2018 Share Posted February 22, 2018 Excellent! I look forward to being able to use this very useful mod. Thanks Jack! Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted March 18, 2018 Author Share Posted March 18, 2018 A new version has been updated with these changes: Moved database code to an ajax file for speed. Added an option to email the customer about the merge. Changed the code to remove the results when a new search is started. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Gadget Posted June 6, 2018 Share Posted June 6, 2018 Performed install. However, Merge Accounts page shows nothing, just blank. with no errors. See attached. Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted June 7, 2018 Author Share Posted June 7, 2018 Please down and install the Version Checker addon. The installation is just uploading files. I should have included it in this package. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Gadget Posted June 7, 2018 Share Posted June 7, 2018 13 hours ago, Jack_mcs said: Please down and install the Version Checker addon. The installation is just uploading files. I should have included it in this package. OK- did that. (see result attached)... Yes it is the latest version. All files uploaded and files modified. no errors that I see. What's next? Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted June 7, 2018 Author Share Posted June 7, 2018 You can see the difference between your two images is the text on the right. So in the first image, that wasn't displaying because the file wasn't present and the code was giving an error. Now that you have installed that addon, the code is getting past that and failing on the next item, which is the loading of the merge_accounts_ajax.php file. Please check that that is present in your admin directory. If it is, then also see if there is a file named error_log present. If there is, open it and look for any entries having to do with this addon and post them here if they don't provide the reason for you. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Gadget Posted June 7, 2018 Share Posted June 7, 2018 (edited) Sorry, it WAS displaying, I just didn't include it in the first snip image. Yes, both files exist in the folder. There is no error log file created. Still nothing displayng. Thanks for your help. Edited June 7, 2018 by Gadget Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted June 7, 2018 Author Share Posted June 7, 2018 Sorry, but you've lost me. You said, "it WAS displaying" and then "Still nothing displaying". Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Gadget Posted June 11, 2018 Share Posted June 11, 2018 As I posted above- below is all I see. After I installed the version checker I now get the Merge accounts V 1.1 that shows up now. But still nothing shows up on the Merge accounts page to do. Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted June 11, 2018 Author Share Posted June 11, 2018 I can tell you that this addon has been tested in RC2, 2.3.4 and 2.3.4 BS versions of oscommerce so the problem you are seeing is almost certainly an installation issue. So you need to find out what the error is. If an error_log file is in the admin directory, look at it. If not, look at the errors in your control panel, if that option exists. If not, see if your host will provide the error. If not, you will need to pay for someone to look at it. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.