Dan Cole Posted March 17, 2019 Share Posted March 17, 2019 Received the review request. Awesome. The data is correct too...name, date purchased, and item purchased....all good. Dan 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...
♥Moxamint Posted March 17, 2019 Share Posted March 17, 2019 Mine is all good as well. Cheers, Eddy Link to comment Share on other sites More sharing options...
burt Posted March 17, 2019 Share Posted March 17, 2019 Excellent thank you Guys - *much* appreciated. I'll clean up one piece of code and write a readme, and then get it out for you guys to have a play with...by end of tomorrow you'll have it. Link to comment Share on other sites More sharing options...
♥altoid Posted March 18, 2019 Share Posted March 18, 2019 23 hours ago, burt said: I believe this is now ready to test, if you are able to spend 5 minutes to create an account and perform a checkout I would greatly appreciate it: Just ran a test order I am not a professional webmaster or PHP coder by background or training but I will try to help as best I can. I remember what it was like when I first started with osC. It can be overwhelming. However, I strongly recommend considering hiring a professional for extensive site modifications, site cleaning, etc. There are several good pros here on osCommerce. Look around, you'll figure out who they are. Link to comment Share on other sites More sharing options...
Omar_one Posted March 18, 2019 Share Posted March 18, 2019 @burt will this send the emails to who's accept to get newsletters ? If yes then I think there is no problem with guest account (PWA) add-on because when you create account as guest there is no click box to accept the newsletters.. Get the latest Responsive osCommerce CE (community edition) here . Link to comment Share on other sites More sharing options...
burt Posted March 18, 2019 Share Posted March 18, 2019 23 minutes ago, Omar_one said: @burt will this send the emails to who's accept to get newsletters ? If yes then I think there is no problem with guest account (PWA) add-on because when you create account as guest there is no click box to accept the newsletters.. It sends to whoever the shopowner is targeting with the individual modules. In the example modules I've come up with, that's all customers... I am certain this system is the acorn that will grow into what CE will use for emails in the future. Link to comment Share on other sites More sharing options...
burt Posted March 18, 2019 Share Posted March 18, 2019 2 hours ago, altoid said: Just ran a test order The next activation (or perhaps the one after), you'll get; testing123 (inserted via admin) review_request (date changed from 60 days to 1 day) Report back how they look? Link to comment Share on other sites More sharing options...
♥raiwa Posted March 18, 2019 Share Posted March 18, 2019 1 hour ago, Omar_one said: @burt will this send the emails to who's accept to get newsletters ? If yes then I think there is no problem with guest account (PWA) add-on because when you create account as guest there is no click box to accept the newsletters.. 58 minutes ago, burt said: It sends to whoever the shopowner is targeting with the individual modules. In the example modules I've come up with, that's all customers... PWA uses an additional column in the customers table to flagg guest accounts (the ones which didn't have been auto deleted because the customer didn't finish correct on checkout_success.php). So to avoid sending e-mails to guest customers, shopowners can just add to the queries the condition: AND c.customers_guest != '1' or this could be used generic for all shops: AND (EXISTS (SELECT c.customers_guest FROM customers c) AND c.customers_guest != '1') I didn't check the code, but it should do it. About Me: http://www.oscommerce.com/forums/user/249059-raiwa/ Need help? How To Get The Help You Need Is your version of osC up to date? You'll find the latest osC community version CE Phoenix here. Public Phoenix Change Log Cheat Set on Google Sheets Link to comment Share on other sites More sharing options...
♥altoid Posted March 18, 2019 Share Posted March 18, 2019 2 hours ago, burt said: The next activation (or perhaps the one after), you'll get; testing123 (inserted via admin) review_request (date changed from 60 days to 1 day) Report back how they look? Received 4 and all's looking very nice. I am not a professional webmaster or PHP coder by background or training but I will try to help as best I can. I remember what it was like when I first started with osC. It can be overwhelming. However, I strongly recommend considering hiring a professional for extensive site modifications, site cleaning, etc. There are several good pros here on osCommerce. Look around, you'll figure out who they are. Link to comment Share on other sites More sharing options...
Dan Cole Posted March 18, 2019 Share Posted March 18, 2019 1 hour ago, altoid said: Received 4 and all's looking very nice. Why 4? Dan 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...
burt Posted March 18, 2019 Share Posted March 18, 2019 Code has gone out to two testers. Depending on feedback given over the next week or two, should see this system into the wild. It's close... Link to comment Share on other sites More sharing options...
René H4 Posted March 18, 2019 Share Posted March 18, 2019 Well done Gary! Link to comment Share on other sites More sharing options...
Dan Cole Posted March 18, 2019 Share Posted March 18, 2019 Gary I ran into an issue with the sql lines.... date_added datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, that ran okay on one of my databases but not on another. The error given was... #1067 - Invalid default value for 'date_added' I googled that and it suggested that I needed to change the datetime to TIMESTAMP. I tried that and it created the tables but I haven't gone any further yet. I'll do that but in the meantime I thought I'd post my experience with the sql query while I remembered what happened and what I did. Okay I'm off to check out the admin area. Dan 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...
burt Posted March 18, 2019 Share Posted March 18, 2019 41 minutes ago, Dan Cole said: Okay I'm off to check out the admin area. Great, thanks - please email me any feedback ... Link to comment Share on other sites More sharing options...
♥altoid Posted March 19, 2019 Share Posted March 19, 2019 5 hours ago, Dan Cole said: Why 4? Dan Looks like a welcome, order process, review request and a "test email" I am not a professional webmaster or PHP coder by background or training but I will try to help as best I can. I remember what it was like when I first started with osC. It can be overwhelming. However, I strongly recommend considering hiring a professional for extensive site modifications, site cleaning, etc. There are several good pros here on osCommerce. Look around, you'll figure out who they are. Link to comment Share on other sites More sharing options...
Dan Cole Posted March 19, 2019 Share Posted March 19, 2019 Ahhh....the 2 usual emails and 2 from the new queuing system. I get it. Dan 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...
burt Posted March 19, 2019 Share Posted March 19, 2019 Yes - the system does not yet replace the usual outgoing emails - but I am certain, in the near future, something like this system has to be put in place for all emails. Template-able Emails - it has to be the future! Link to comment Share on other sites More sharing options...
♥14steve14 Posted March 19, 2019 Share Posted March 19, 2019 Whilst I have not seen what you are doing I have been following this thread with anticipation for anything better than is originally available. It sound like you are getting somewhere Gary. Well done. I would love to see a system where order status update emails could be written specifically for the update status replacing the standard 'your order has been upgraded to' emails. And the same with the 'new customer' or other emails. They are all a bit plain and do nothing for future sales. Like I say, cant wait to see where this leads as it sounds good. REMEMBER BACKUP, BACKUP AND BACKUP Link to comment Share on other sites More sharing options...
MrPhil Posted March 19, 2019 Share Posted March 19, 2019 17 hours ago, Dan Cole said: Gary I ran into an issue with the sql lines.... date_added datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, that ran okay on one of my databases but not on another. The error given was... #1067 - Invalid default value for 'date_added' I googled that and it suggested that I needed to change the datetime to TIMESTAMP. I tried that and it created the tables but I haven't gone any further yet. Do you mean "the DEFAULT change to TIMESTAMP"? datetime should still be a valid field type, shouldn't it? CURRENT_TIMESTAMP appears to be a more recent addition to MySQL -- is the failing database a much older version? I think the intent is that it acts like INSERT INTO with a now() value, but it can now be defaulted to do that. For older MySQL versions, it won't work, and you may have to explicitly give a now() in the VALUES list. That, or declare a minimum MySQL version number. Link to comment Share on other sites More sharing options...
Dan Cole Posted March 19, 2019 Share Posted March 19, 2019 1 hour ago, MrPhil said: Do you mean "the DEFAULT change to TIMESTAMP"? datetime should still be a valid field type, shouldn't it? CURRENT_TIMESTAMP appears to be a more recent addition to MySQL -- is the failing database a much older version? I think the intent is that it acts like INSERT INTO with a now() value, but it can now be defaulted to do that. For older MySQL versions, it won't work, and you may have to explicitly give a now() in the VALUES list. That, or declare a minimum MySQL version number. It failed on the older database. Versions as follows: Database it failed on: MySQL 5.5.52-MariaDB Database where it work. MySQL 10.2.22-MariaDB Changing... date_added datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, to date_added TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, seems to have sorted it and the subsequent data seems identical. Dan 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...
burt Posted March 29, 2019 Share Posted March 29, 2019 Real life feedback/ideas from shopowners lead me to this change; ...it would be nice to be able to use the merge tags in the subject of the email message as well as the body. ie to be able to reference customers names or order #s etc.. With one extra line of code in the main module I made this a reality, so now it's possible to use the {{TAG}} system in the Title as so: and when received looks like (eg) this: Pretty damned cool! Link to comment Share on other sites More sharing options...
burt Posted March 29, 2019 Share Posted March 29, 2019 We also now have Filtering (for the outgoing Queue). Now easily see individual customers or slugs. As an example, let's say that the Queue has 200 emails in it waiting to go out over the next 3 months. Examples of use; You want to see all "birthday_greetings", select that slug from the dropdown and press go. You want to see all emails that are going out to a particular customer. Select that customer and press go. You want to see all "review_requests" going to a particular customers. Select slug and customer, and press go. This thing is getting better and better... Link to comment Share on other sites More sharing options...
burt Posted March 29, 2019 Share Posted March 29, 2019 I've now created a module for order_success to replace the standard order success email that osC sends. If anyone wants to test it: https://template.me.uk/outgoing/ and progress all the way through the checkout. You'll get an email sent by this new system - so PLEASE use a real email address... This system is looking like another game-changer. Link to comment Share on other sites More sharing options...
Omar_one Posted March 29, 2019 Share Posted March 29, 2019 order created and got the email .. well done Get the latest Responsive osCommerce CE (community edition) here . Link to comment Share on other sites More sharing options...
Dan Cole Posted March 29, 2019 Share Posted March 29, 2019 30 minutes ago, burt said: If anyone wants to test it: Tested and works well Gary....I think I'll dress this email up and go live with the system sometime over the weekend. 👍 Dan 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...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.