Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Mail Manager


npn2531

Recommended Posts

Try manually replacing every ' in the statement. Sometimes when you copy and paste sql statements across word processing platforms these marks are mis-read.

Oscommerce site:

 

 

OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120

Link to comment
Share on other sites

I will try it this evening. I do hope it works because Ive been looking for a program like this. Used UHTML for some time but there where some bugs.

 

(After the installation of mailmanager my complete site went blank. Could this be because of the SQL problems)

Link to comment
Share on other sites

If you can see the page you are on in the address bar when looking at the blank screen you can use echo statements to find the error. Just open up the page that is blank and then starting from just below the opening <?php mark, type in several places down the page something like:

 

echo 'line 2'; or echo 'line 50';

 

As long as you haven't placed them within a 'if then' statement, then the echo statements you add above the error will print on the screen and the echo statements below the error will not print, and you can narrow down exactly where the error is.

Oscommerce site:

 

 

OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120

Link to comment
Share on other sites

Well, the import of the .sql file did not work for the file included with the addon february 6th. But after clicking on your signatures link I've imported that file and...mwuahahaha...succes.

 

I can't see any difference at that level but I guess it will work....well..I hope ;)

Link to comment
Share on other sites

Well, the import of the .sql file did not work for the file included with the addon february 6th. But after clicking on your signatures link I've imported that file and...mwuahahaha...succes.

 

I can't see any difference at that level but I guess it will work....well..I hope ;)

 

Well, I used diffuse merge tool to compare both the .sql files and found 2 little diferences. For one instance the line:

ALTER TABLE `customers` ADD `mmstatus` CHAR( 2 ) NOT NULL AFTER `customers_newsletter`

 

-could not be found with mergetool so I imported it by hand. That gave me a .sql error. I replaced every `for ' and it worked. The database was made and gave no errors while using phpMyadmin. Then I used the .sql file without the above named code and...it imported without any errors. I thought this would be succes!

 

Nevertheless it didn't bring me any luck. Again I had a blank screen at admin and public part of the website.

 

I'm done with it. It doesn't work for me although it is still the addon I was looking for.

Link to comment
Share on other sites

  • 2 weeks later...

Hi!

 

I'm having the same problem.....

 

Using osC 2.3.3.4 and installed (en tripple checked) al modifications in the php-files.

While importing your file "HTML_mailmanager_DB__.sql" in phpMyAdmin it generates an error. (see picture in attachment)

I am not a SQL programmer, so I hope you can tell me in plain English what to do ;-)

This is really the tool I would like to use. Tried some others but they were never as good as you say this one is :-)

 

Thanks in advance!

Kees

 

post-326731-0-25861200-1392813754_thumb.png

Link to comment
Share on other sites

Again it's me.... :-)

 

In the past two hours I checked al the changes in the php-files CHARACTER BY CHARACTER. Nothing wrong.

Still blanc screens in frontend and backend.

Restoring my backup now (thank god I have it) and still hope there is a solution for both problems.

Edited by KeesB
Link to comment
Share on other sites

HTML-mailmanager-osc_2.3.3.4, http://addons.oscommerce.com/info/9004 is a different contribution than Mail Manager, http://addons.oscommerce.com/info/8120 .

 

I have not looked at HTML-mailmanager-osc_2.3.3.4, it doesn't appear to have it's own support thread, perhaps the author, Flaggi can assist.

Edited by npn2531

Oscommerce site:

 

 

OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120

Link to comment
Share on other sites

HTML-mailmanager-osc_2.3.3.4, http://addons.oscommerce.com/info/9004 is a different contribution than Mail Manager, http://addons.oscommerce.com/info/8120 .

 

I have not looked at HTML-mailmanager-osc_2.3.3.4, it doesn't appear to have it's own support thread, perhaps the author, Flaggi can assist.

 

Thank you, @@npn2531

Link to comment
Share on other sites

  • 2 months later...

Hi,

 

works perfect on 2.3.1 with very small modifications!

 

It seems that the placeholder for customers name doesn't work in sale_followup module.

 

Anyone know how to fix this?

 

Thanks.

Link to comment
Share on other sites

  • 3 weeks later...
  • 1 month later...

Hello, I tried to install various contrubutions to get my shop (2.2ms2) sending (good looking) html mails. Most of them do not work for newsletters, status updates and product notifications. As my store is heavy modded, and I'm about to starting in a productive environment, I just want to ask if there is a chance to get this contribution running in ms2 or am I wasting my time? When the shop is running, I think I will start over again with a new version, get all the features and the design of my store working on it and then migrate the data of the original store (as upgrading is - well - not really possible)... So - should I give it a try?

Link to comment
Share on other sites

It should work fine on 2.2ms2. 

 

You find it easier to upgrade a 2.2ms2 than to start anew and reinstall your contributions, esp if you have the design you like. The important security functions can certainly be upgrade. The detailed instructions to do this are on this site. Perhaps someone else, who knows where it is can post the link. 

Oscommerce site:

 

 

OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120

Link to comment
Share on other sites

  • 2 weeks later...

It should work fine on 2.2ms2. 

 

You find it easier to upgrade a 2.2ms2 than to start anew and reinstall your contributions, esp if you have the design you like. The important security functions can certainly be upgrade. The detailed instructions to do this are on this site. Perhaps someone else, who knows where it is can post the link. 

Okay, so I tried to install your contribution today, there is still some work left (templates). One problem with the 2.2.ms2 seems to be, that the order status update mails come from a different file than in newer versions of the shop.

The order status updates are still the same old text mails as without any addon. I am very shure, that I have changed all files correctly, the orders.php included. Still the same old ugly, charset-buggy textmail for order status updates.

Perhaps someone can help me... would be nice to be able to change this, as this is a very important mail.

Link to comment
Share on other sites

Okay, so I tried to install your contribution today, there is still some work left (templates). One problem with the 2.2.ms2 seems to be, that the order status update mails come from a different file than in newer versions of the shop.

The order status updates are still the same old text mails as without any addon. I am very shure, that I have changed all files correctly, the orders.php included. Still the same old ugly, charset-buggy textmail for order status updates.

Perhaps someone can help me... would be nice to be able to change this, as this is a very important mail.

I have found the problem myself. Works fine now. Still some small issues with the placeholders in the mails: in the order status update mail the $statusnewhtml does not work (puts out nothing) while $statusnewtxt works fine. Any clue for this? (There are some other placeholders wich do not work as they should, i.e. store_owner.

Link to comment
Share on other sites

  • 3 weeks later...

Hi

I'm getting a bit stuck with this....

 

My email templates preview just fine within admin, but are all over the place once they hit someone's inbox.

 

Basically the HTML isn't rendering, with the footer in particular just showing the HTML as text. I've attached some screenshots.

 

Any thoughts please.......

post-97216-0-65073000-1407858473_thumb.jpg

post-97216-0-84118400-1407858480_thumb.jpg

Link to comment
Share on other sites

I am willing to bet you have a couple of typos somewhere in the html. The html in the text is kinda of the typical thing you see when a < or > has been left out. The errors are being rendered, or read just a bit differently in the different programs that ar reading your preview and the mail. In other words, the preview screen is less sensitive to the typos than your mail program.

Oscommerce site:

 

 

OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120

Link to comment
Share on other sites

  • 1 month later...

Hi All,

 

I have probably missed this somewhere in the documentation, but I was wondering what triggers the sales_followup function once it has been enabled.  Is it just someone going to the site and accessing a page, or does there need to be a cron job created to run this feature?

Link to comment
Share on other sites

You manually send it. Go to mail manager>bulk mail> and then select the installed thank you letter. It is one of the bulk mail letters. It is  written to send to any customer whose order has been changed to a status of 'shipped' more  than about 10 days, but no older than about 3 weeks. Thus if you wait three weeks without manually sending the letter you start skipping customers. I simply send it every time I go to process orders each day. It will run in the background. It will also not resend the letter to the order twice. It sends to the email in the customers order, per order.

 

It only sends to the customer once per order, because it sends only to the email in a customer orders whose status is 'paid'. Once it sends the email it changes the status of that order to 'thank you' . You can see the programming and change what the status is changed to by going to:

 

admin>includes>modules>mail manager>sale_followup.php

 

and making the appropriate programming changes.

Edited by npn2531

Oscommerce site:

 

 

OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120

Link to comment
Share on other sites

 

 

It only sends to the customer once per order, because it sends only to the email in a customer orders whose status is 'paid'. Once it sends the email it changes the status of that order to 'thank you' . You can see the programming and change what the status is changed to by going to:

I mean 'shipped' not paid. 

Oscommerce site:

 

 

OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120

Link to comment
Share on other sites

Thanks! No wonder I missed it!.  I wonder if it would be possible to modify the script and set up a cron job that could be accessed to run the sale_followup once a day.  I have installed it and it works fine, but if we could automate it that would take away one more thing that someone has to remember to do.

Link to comment
Share on other sites

If you ran the follow sale letter once or twice a week, you would be sending out to all your sales and it only takes about three clicks. I am not familiar with how to setup cron job, but it is going to involve setting up something on your web server outside the php script itself. 

Oscommerce site:

 

 

OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...