|
|
 |
 |
Joined: 6/1/2010
Posts: 179
|
|
|
Hi,
I have several questions regarding some odd behaviors...
With the newest 7.20 cart the system at times started sending us semi-duplicate mails. One would come through with a 0 amount, and the other with the order amount. The order number is the sa me...
First:
Thank you for your order. Your Order Total is: $0.00
Then right after:
Thank you for your order. Your Order Total is: $149.95
Is there a way to stop the 2 emails for a single order? This only happens sometimes.
My next question is one regarding older items in our cart. They show up weird, like below. Is there a way to fix the database so you do not get these weird entries in older orders?
| Sub Total: |
($79,228,162,514,264,337,593,543,950,335.00) |
| Discount: |
$0.00 |
| Tax: |
$0.00 |
| Handling: |
$0.00 |
| Shipping: |
$34.95 |
| Surcharge: |
$0.00 |
| Order Total: |
($79,228,162,514,264,337,593,543,950,335.00) |
| Payment Total: |
$0.00 |
| Credit Total: |
$0.00 |
| Balance: |
$134.90 |
Thanks!
Steve
|
|
|
|
 | |
|
|
 |
Joined: 7/28/2009
Posts: 1452
|
|
|
Regarding the email issue I will have to test that and see if I can replicate it. Regarding the old orders showing weird subtotal, check your "Smith_StoreOrders" table and make sure you have no null values in the subtotal and grandtotal fields. If you see null values for those field you will need to write a sql statement to update them. About 2 years ago we added the subtotal and grandtotal fields, prior to that they were calculated fields is the reason you are seeing the issue.
At your service,
Dave Smith
|
|
|
|
| |
|
|
|
|
Joined: 6/1/2010
Posts: 179
|
|
|
Thanks, the query to replace the NULL's with 0 fixed it.
I did discover another $0.00 email was sent... this time it came after the original order... like 30 minutes. It appears to only occur on download products. The $0.00 email does not have the Billing Information section filled out, where the one with the full amount does have Billing Information.
Maybe the above will guide you in some way!
Thanks,
S
teve
|
|
|
|
| |
|
|
 |
Joined: 1/1/0001
Posts: 0
|
|
|
Hi Steve,
Email Confirmations should be sent immediately after a completed Order. I tested checking out with a Downloadable Product and the Price is coming thru in the the Email. Are you using Product Level Email Templates or do you have any of the following options enabled in your Store Settings?
- Request Quote Email
- Third Party CC
- Email Download Link
- Email Manufacturers
Thanks!
|
|
|
|
| |
|
|
|
|
Joined: 6/1/2010
Posts: 179
|
|
|
Hi Kevin,
Email Download Link is the only one selected.
We get an email basically at the same time as the full order. It is the exact same as the main receipt except Billing Address is not in it, and the totals look like this:
SubTotal: $49.95
Discount : -$0.00
Shipping Fee : $0.00
Handling Charge : $0.00
Sales Tax $0.00
Total $0.00
|
|
|
|
| |
|
|
|
Joined: 1/1/0001
Posts: 0
|
|
|
Hi Steve,
I sent you an email with a download link to the latest version of the Cart. Please download, install and check if you are still experiencing the price issue in the Email Confirmation. Please be advised that you may need to delete and re-add the default Email Templates as we have redesigned them for a more professional look.
As always, it is always recommended that you first do the upgrade in a test environment and make sure you have a full backup before installing on your live site in case you need to rollback.
Thanks!
|
|
|
|
| |
|
|
|
|
Joined: 6/1/2010
Posts: 179
|
|
|
Hi Kevin... I will try to get it installed soon and let you know.
Thanks!
Steve
|
|
|
|
| |
|
|
|
|
Joined: 6/1/2010
Posts: 179
|
|
|
I made the site update and refreshed the email templates. We will see how it all works!
Thanks,
Steve
|
|
|
|
| |
|
|
|
|
Joined: 6/1/2010
Posts: 179
|
|
|
Quick report...
We did not get an order yet, but in a test re-send of the email with the new templates, there is a missing closing tag as part of the download link. I guess this is for [ORDERDETAILS]. The link shows up as < a href="http://www.my_website.com//LinkClick.aspx?fileticket=aabbcc">Download.
EDIT - There appears to be an extra a href tag added. When saving the email locally, something like this shows up...
< a href="<a href="
|
|
|
|
| |
|
|
|
|
Joined: 6/1/2010
Posts: 179
|
|
|
It appears the extra $0.00 emails have stopped. I looked at the raw invoices to see why the Download link URL is broken... It appears that the a href tag has a space between the < and the a... < a href. In an editor when I removed the space, it showed OK.
Is there a way to edit the html for [ORDERDETAILS] to remove the space?
|
|
|
|
| |
|
|
|
|
Joined: 6/1/2010
Posts: 179
|
|
|
Hi,
I looked everywhere for a file to fix to repair the broken download links. Can you tell me what to fix to get the links corrected? Is there a template for [ORDERDETAILS]? I could also fix the font in the headings, which does not match the font in the new templates.
Thanks,
Steve
|
|
|
|
| |
|
|
|
Joined: 7/28/2009
Posts: 1452
|
|
|
The fix for the download link is in code behind. I will have programming work on it and send you a hotfix by tomorrow.
At your service,
Dave Smith
|
|
|
|
| |
|
|
|
Joined: 7/28/2009
Posts: 1452
|
|
|
Steve,
I just emailed you the fix for the email download link, let me know if that works for you. In regards to the font issue, we don't set any fonts in the email, the [ORDERDETAILS] token is an html table and the header row uses <TH> tag.
At your service,
Dave Smith
|
|
|
|