WebStore: Order Confirmation Template and Screen

This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.

Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.

This is the place to report bugs and get support

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.
Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum.
This thread is closed to new posts. You must sign in to post in the forums.
6/12/2009 6:18:09 AM
Gravatar
Total Posts 149
Partner
mojoPortal Skinning, Custom Development and Support in Italy?
EffectiveWeb.it

WebStore: Order Confirmation Template and Screen

Sys op: Server Win 2003 - Client Vista
Database: SQL
mojoPortal: 2-3-0-4-b
Browsers: IE 7, Firefox 3.0.10, Google Chrome 2.0.172.30

Hi Joe,
my WebStore testing is going on...

I'have completed a test transaction on PayPal standard sandbox for a dummy product/offer of € 1,00 EUR and I have noticed the two issues described below. Are they somehow due to my wrong settings or are they a potential bug ?

Issue #1
After completing the transaction, OrderDetail.aspx page shows discrepancies between item list amount (1,00 €) and order total amount (100,00 €):

Riepilogo Ordine
ID Ordine 52569b11-f42c-4b68-b414-3478c4c1ff6c
Data Ordine 12/06/2009
Totale 100,00 €
Articoli
Articolo Prezzo Q.ta'
Pacchetti Prepagati di Prestazioni Personali Dirette Effective 1,00 € 1
Abbiamo ricevuto il tuo ordine ma il pagamento e' ancora in corso. Una volta ricevuta la notifica di completamento dal gestore del pagamento, i collegamenti per scaricare i prodotti ordinati saranno disponibili qui sotto.

Issue #2
After payment approval, buyer (and merchant in copy) receive the confirmation e-mail based on the wrong (en-US) message template (I have created the necessary it-IT templates for subject and text in \Data\MessageTemplates folder but they seem ignored) and message text does not show the correct currency symbols and total (see below).

Da: commerciale@effective.it [mailto:commerciale@effective.it]
Inviato: venerdì 12 giugno 2009 10.55
A: Stefano Santoni
Oggetto: Your Order from EffectiveWeb Store - Il Negozio on-line di Effective, Order ID: 52569b11-f42c-4b68-b414-3478c4c1ff6c

Dear Stefano Santoni

Thank You for Ordering from EffectiveWeb Store - Il Negozio on-line di Effective!

Your Order ID is 52569b11-f42c-4b68-b414-3478c4c1ff6c

If your order has shippable products, we will notify you when shipment has occurred.

If your order has downloadable products, they are available immediately by visiting our store:
http://www.effectiveweb.it/negozio.aspx
After signing in you will see a link for "My Account", click this link then choose "Order History", or you can just follow this link directly to your order:
http://www.effectiveweb.it/WebStore/OrderDetail.aspx?pageid=6&mid=63&orderid=52569b11-f42c-4b68-b414-3478c4c1ff6c

Order Details:
Pacchetti Prepagati di Prestazioni Personali Dirette Effective 1 @ 1,00
? (it should be € 1,00 EUR)


SubTotal: 1,00 ? (it should be € or EUR)
Discount: 0,00 ?
Shipping: 0,00 ?
Tax: 0,00 ?
Order Total: 100,00 ? (it should be 1,00 € or EUR)

P.S.: unfortunately, no tax details were returned by PayPal. Do you know whether PayPal standard settings can apply and return fixed tax percentage ?

thanks

Diego

6/19/2009 2:41:44 AM
Gravatar
Total Posts 149
Partner
mojoPortal Skinning, Custom Development and Support in Italy?
EffectiveWeb.it

Re: WebStore: Order Confirmation Template and Screen

Excuse me Joe,

I have upgraded to version 2.3.0.8 and found all fixes to all other bug notifications related to the Webstore Web (thanks!).
On the other hand, I see that you haven't had time to reply to this earlier post yet (I know you are very busy...).
As said I'm not sure whether this is a real bug, eventually fixed with 2.3.0.8 as well, or it is something due to wrong site/module settings.

Next week we plan to release our webstore and propose our supporting service to mojoPortal in Italy and Order Confirmation is rather critical.
Should I make another order-cycle test with version 2.3.0.8 and PayPal Sandbox or you have any other suggestions ?

Regards.
Diego

6/19/2009 7:11:54 AM
Gravatar
Total Posts 18439

Re: WebStore: Order Confirmation Template and Screen

Hi Diego,

The confirmation doesn't currently use the user's culture but the default culture which would be en-US as defined in Web.config Globalization section.

Really I think it should use the site default language since the store/site is in a single language the confirmation email should be in the same language as the store rather than try to adapt to the user browser language preference. Its a similar issue in the forums, once upon a time it used the users language and then I would receive forum notifications in a different language so I change dit to use the default culture. Confirmation email is also copied to a store admin so it should be in the store/site language.

You can configure it to use a different file name per site with the config setting

<add key="Site1-ConfirmationEmailPlainTextTemplate" value="DefaultOrderConfirmationPlainTextEmailTemplate.config" />
<add key="Site1-ConfirmationEmailSubjectTemplate" value="DefaultOrderConfirmationEmailSubjectTemplate.config" />

but for now you would need to prefix the name with en-US even if the contents are Italian (unless you change the default cutlure but this would require no missing resource keys or message templates). I will look into improving this as it should be possible to specify and use a default culture/language for the site even if the web.config globalization setting defaults to en-US.

Hope it helps,

Joe

6/19/2009 7:44:45 AM
Gravatar
Total Posts 149
Partner
mojoPortal Skinning, Custom Development and Support in Italy?
EffectiveWeb.it

Re: WebStore: Order Confirmation Template and Screen

Ciao Joe,

I suspected something like that but I was looking for your confirmation instead of proceeding by guessing.
I agree with you, I definitely don't want to change the default culture from en-US to it-IT because, even if I'm carefully translating all resources into Italian at every new release I'd like to ensure that all features are working fine after any site updates.
(by the way, I'm working on version 2.3.0.8 resources and templates and you will receive a copy by e-mail today or on Monday for future distribution). 

For the moment, I will set custom templates in Italian with en-US prefix as you suggest but would this solve the currecy issue as well ?
And what about the miscalculation on OrderDetail.aspx and Order confirmation message ?
(item amount=1,00 € and order total amount =100,00 €)

Test was performed with version 2-3-0-4-b and I have seen that othe currency issues have been solved by 2-3-0-8. Is total calculation solved as well ? 

Regards.
Diego

 

6/19/2009 7:56:23 AM
Gravatar
Total Posts 18439

Re: WebStore: Order Confirmation Template and Screen

I "thought" I fixed this but if you confirm there still exists a problem I will investigate further. Ideally if you can show me the problem on the demo site it will help me track it down.

Best,

Joe

6/19/2009 7:59:26 AM
Gravatar
Total Posts 149
Partner
mojoPortal Skinning, Custom Development and Support in Italy?
EffectiveWeb.it

Re: WebStore: Order Confirmation Template and Screen

Hold on Joe..
let me fix the template a make another test.
I'll let you know the go/no-go response.
Diego

6/19/2009 9:29:41 AM
Gravatar
Total Posts 149
Partner
mojoPortal Skinning, Custom Development and Support in Italy?
EffectiveWeb.it

Re: WebStore: Order Confirmation Template and Screen

Here we are!

I have created the appropriate Message Templates (with us-EN- prefix) and set a reference to them in user.config.
Then, with another user (same of last week test) I went to the webstore and entered a new order (same order).
After payment release on PayPal sandbox, user and site administrator received the OrderConfirmation message based on the new correct custom template.

Nevertheless, I confirm that calculation and curency issues are still there on both:

OrderDetail.aspx (item price 1,00 € and total amount 100,00 €)

ID Ordine 7b051e0e-7b5a-46fe-8ada-9508e00f1093
Data Ordine 19/06/2009
Totale 100,00 €  (it should be 1,00 €)

Articoli
Articolo                                                                                          Prezzo    Q.ta'
Pacchetti Prepagati di Prestazioni Personali Dirette Effective    1,00 €     1

and Order Confirmation Message (same calculation problem with additional currency symbols problems)

...
Dettagli Ordine:
Pacchetti Prepagati di Prestazioni Personali Dirette Effective 1 @ 1,00 ?

SubTotale : 1,00 ?
Sconto : 0,00 ?
Spedizione : 0,00 ?
Tasse : 0,00 ?
Totale Ordine: 100,00 ?
 

As Administrator, I verified in Order History and found both test orders (previous test and current) with total amount of 100,00 € and item details for 1,00 €.

The only further difference between the two test orders (2.3.0.4.b vs. 2.3.0.8) is that after order confirmation, the user who placed the order cannot have access to order details form oderconfirmation link (permissions error) nor from My Account / Order History (order is simply not listed).

Comments:
The currency errors seem the same of "Offer Details" you already fixed
Miscalculation could be related as well to separators/punctuation settings.
Permission to Order Detail are new (previous test was fine)

6/19/2009 10:07:14 AM
Gravatar
Total Posts 18439

Re: WebStore: Order Confirmation Template and Screen

Hi Diego,

I'm not able to produce the order total problem on demo.mojoportal.com. I was able to produce the issue where the euro symbol is replaced by the ? in the confirmation email, and I was able to solve it by putting this in user.config

<add key="DisableDotNetOpenMail" value="true" />

apparently the builtin system.net mail classes work better in terms of automatic correct encoding. I may nee to disable donetopenmail by default or even do away with it entirely.

I was also not able to produce the access denied error when viewing order history.

Best,

Joe

6/19/2009 10:16:42 AM
Gravatar
Total Posts 18439

Re: WebStore: Order Confirmation Template and Screen

The only time I get access denied is if I try to view the order while signed in as a different user than the one who made the order. 

Note that for products with FulfillmentType = None a user can checkout without sign in or registration. A user is created and that user could sign in after using the password recovery. The user can see the order detail (which shows no customer information just order information) if he is signed in as the user connected with the order or if he is not signed in at all, but if he is signed in as someone else he gets access denied.

6/19/2009 11:09:32 AM
Gravatar
Total Posts 149
Partner
mojoPortal Skinning, Custom Development and Support in Italy?
EffectiveWeb.it

Re: WebStore: Order Confirmation Template and Screen

Joe,

I have set <add key="DisableDotNetOpenMail" value="true" /> in my user.config and the € symbol came out.
Should I expect the "@" symbol before the price should be "EUR" (as shown in offer details) ?
Regarding the Order Total, nothing new: item and subtotal are 1,00 € and total is 100,00 €. I will make more test on Monday with another product.

Dettagli Ordine:
Pacchetti Prepagati di Prestazioni Personali Dirette Effective 1 @ 1,00 €

SubTotale : 1,00 €
Sconto : 0,00 €
Spedizione : 0,00 €
Tasse : 0,00 €
Totale Ordine: 100,00 €
 

 

Regarding the permission problem, I think the situation was probably due to something else.

My web Store module is visible to authenticated users only: unless the session is expired I think no unregistered user's order should be possible.
Anyway, all test orders are visible to the Admninistrator and are all assigned to the same registered user who entered it.

The last test (#3), after paypal checkout, user got back to the webstore and (surprise) had no problem to access the OrderDetail.aspx page.
Only difference betwenn test #2 and #3 is the following:
- in test #2 the merchant approved the payment BEFORE and THEN the user tried to go back to order details clicking the mail link
- in test #3 user went back to the site (and OrderDetail page showed the message that the payment was still under revision; THEN merchant approved the payment.
I don't know if this tells anything to you...

By the way, if product fulfillment is a suspect cause of the issue, do you suggest to set FulfillmentType <> None for products wich are not downloadable nor shippable ? (they are packages of consulting hours which require just an invoice)
Is there a toggle to disable the possibility to enter an order without logging in ?

I will make more test next week. now I have to focus on completing th eItalian translation of 2.3.0.8 before you release another upgrade.
Have a nice weekend.
Diego

6/23/2009 8:52:08 AM
Gravatar
Total Posts 149
Partner
mojoPortal Skinning, Custom Development and Support in Italy?
EffectiveWeb.it

Re: WebStore: Wrong Order Owner / Wrong Order Total Amount

Hi Joe,
after you could not reproduce the issues on your demo site, I made further tests.

I can confirm that:

1) Not all orders are assigned to the correct user

After the payment on PayPal, the buyer clicks the button to return to the Merchant site.
At this point, sometimes, I get a permission error from mojoPortal.
Apparently this happens because the order is not assigned to the correct site user therefore the buyer can't access the order detail.
Order is assigned to "admin xxx@xxxxxx.xx " (the administrator site user I used before logging out and and logging in again with the buyer user yyy@yyyyyyy.yy ).
Is this something related to the inheritance of wrong browser session parameters ?

2) Transactions are miscalculated by multiplying by 100 the order amount (on PayPal account the amount is correct)

This error is systematic.
Could it be anything due to the mojoPortal-PayPal (Standard) interface/handler which does not convert correctly punctuation required from EUR currency and/or local culture ?

Here follows the "wrong order" hystory, resuming in one order the two errors (underlined):

Web Store > Gestione Negozio > Storico Ordini
Utente Sito admin EffectiveWeb xxx@xxxxxx.xx                      <----- (expected buyer user is yyy)
ID Ordine 42220f8b-b76d-4811-baee-e4dbdf603ca8
Stato Ordine
Nome Cliente yyy
<…>
Indirizzo Email yyy@yyyyyyy.yy
Codici Sconto
Dati Personalizzati
Articoli
EffectiveWeb Hosting – Servizi di Web Hosting presso Effective
Totale 42.000,00 €                                                                       <----- (expected amount is 420,00 €)
Metodo Pagamento: PayPal
 

Registro PayPal
Tipo Richiesta Tipo Pagamento Stato Pagamento ID Transazione Totale Carrello Imposte/Tasse Totale Commissioni Saldo Creato UTC

StandardCheckout 420,0000 0,0000 0,0000 0,0000 0,0000 23/06/2009 12.44.49
IPN cart Pending 6RA687627P057080K 42000,0000 0,0000 1463,0000 0,0000 40537,0000 23/06/2009 12.49.30
PDT cart Pending 6RA687627P057080K 420,0000 0,0000 42000,0000 1463,0000 40537,0000 23/06/2009 12.49.50
IPN cart Completed 6RA687627P057080K 42000,0000 0,0000 1463,0000 0,0000 40537,0000 23/06/2009 12.53.04
 

I hope this helps to understand the reason and by-pass the problems with different settings and/or fixes.
Otherwise, I'm stuck and can't use the Web Store.
(if necessary you can register on www.EffectiveWeb.it I can provide you with Admin role)

 

6/23/2009 9:16:52 AM
Gravatar
Total Posts 149
Partner
mojoPortal Skinning, Custom Development and Support in Italy?
EffectiveWeb.it

Re: WebStore: Order Confirmation Template and Screen

P.S.: After last release, offers are now correctly sorted by order rank in Product list but not in product detail (-product.aspx) where they are still sorted by price.

Regards.
Diego

6/23/2009 9:26:28 AM
Gravatar
Total Posts 18439

Re: WebStore: Order Confirmation Template and Screen

Hi Diego,

As a consulting partner who offers mojoPortal development services it would be nice if you could debug these problems using the source code and propose a solution since you are in a better position to produce this problem than I am. My PayPal accounts are configured for US currency to support my own testing. I would set break points in the WebStorePayPalIPNHandlerProvider.cs and also in WebStorePayPalPDTHandlerProvider.cs and see what is happening when the order comes back and how it is parsing the amounts.

The relevant code is possibly here:

CultureInfo currencyCulture;
if (currencyUsed.Length > 0)
{
currencyCulture = ResourceHelper.GetCurrencyCulture(currencyUsed);
}
else
{
//Currency currency = new Currency(store.DefaultCurrencyId);
//currencyCulture = ResourceHelper.GetCurrencyCulture(currency.Code);
Currency currency = siteSettings.GetCurrency();
currencyCulture = ResourceHelper.GetCurrencyCulture(currency.Code);
currencyUsed = currency.Code;
}

decimal grossAmount = 0;
decimal.TryParse(paymentGross, NumberStyles.Currency, currencyCulture, out grossAmount);
decimal feeAmount = 0;
decimal.TryParse(payPalFee, NumberStyles.Currency, currencyCulture, out feeAmount);
decimal taxAmount = 0;
decimal.TryParse(payPalTax, NumberStyles.Currency, currencyCulture, out taxAmount);
decimal shippingAmount = 0;
decimal.TryParse(payPalShipping, NumberStyles.Currency, currencyCulture, out shippingAmount);
decimal settleAmount = 0;
decimal.TryParse(payPalSettlement, NumberStyles.Currency, currencyCulture, out settleAmount);

I would also look directly in the mp_PayPalLog table to see the raw response which is not displayed in the UI so you can see how the amounts are formatted when they come back from paypal.

I think I may understand the problem with the permission and will make a change to try and solve it. The Cart cookie is independent of the user authentication cookie so if you were logged in as admin and created the cart it assigned the admin user to the cart. I just need to add some additional logic if you login as a different user and already have a cart I need to add a check if the current user on the cart matches the login user and if not change it to the login user. 

It would be nice if you could do your testing using a build from svn trunk, that way if I fix something like this cart issue you can confirm it and we can work out these issues before the next release.

Best,

Joe

6/24/2009 5:11:54 PM
Gravatar
Total Posts 18439

Re: WebStore: Order Confirmation Template and Screen

Hi Diego,

I have been chewing on this problem (or parhaps it has been chewing on me ;-))

Its very difficult setting up a debuging environment for testing PayPal, it requires a dev machine with a public facing fixed ip address and setting up dns records etc.

So I realize my hope that you could do this may have been optimistic. Its just that its no less difficult for me, I got it working some time ago well enough to test it with my sandbox account. But I'm one guy and testing other currencies and such is a lot of time consuming work just to setup the test environments and thats a first step in which I may not still be able to produce the bug. I just don't have the resources to do that kind of exploratory debugging myself.

But an idea occurred to me if you are not able easily to setup an environment where you can step through the code, if you would work with me I could provide pre-compiled builds that you would have to install to see if the problems get solved. I think after an initial full installation I would be able to send you just a dll at a time to try to solve it. I can put in extra logging statements to help me diagnose what is the problem and you could process transactions and send me the logs to continue step by step to diagnose and solve it.

If that would work better let me know and I'll contact you off list to proceed.

Ideally if you could send me some data from rows of processed orders that you already have in the mp_PayPalLog table, all I need is the raw response field as this data can give me ideas what might be going wrong in the code and things to try for solving it.

Best,

Joe

6/25/2009 2:22:32 AM
Gravatar
Total Posts 149
Partner
mojoPortal Skinning, Custom Development and Support in Italy?
EffectiveWeb.it

Re: WebStore: Order Confirmation Template and Screen

Hi Joe,

Thanks for the support. I fully understand your time and infrastructure resources aren't unlimited and I really appreciate your availability.

We started our involvement in mojoPortal project a few months ago and after some testing we decided a progressive resource assignment.
In our small team (two partners and some consultants) at the moment I am the (only) one who is dedicating his time to the project.
Our plan of involvement in the project is based on the following steps:

  1. basic knowledge of the solution
  2. testing, setting-up
  3. building test/demo/training site
  4. custom skin design
  5. create hosting, design environment
  6. pilot site (tra il poco e l'abbastanza)
  7. translations
  8. 1st customer project (release goal: july)
  9. company production site dedicated to mojoPortal and to our traditional customer community
  10. start selling some services on-line with mojoPortal (to seek for some returns on our investments)
  11. setting-up our development environment
  12. create basic custom features
  13. develop custom applications

At the moment we are at step 9 and step 8 is covering more or less the cost of previous activities.
The success of step 10 is crucial to us to keep pushing as we were planning the official lounch of our production website by the end of June.
Nevertheless, despite the webstore struggles, we are moving on step 9 and 10 to satisfy some customer requests for step 8 and to do so I involved our .NET programmer, but (I must admit) we are not yet fully operational as we are used to for all other activities of our company.
Soon I will install myself the development environment of mojoPortal for Visual Studio and will start working on it.

For the webstore issues therefore, we are not yet so "effective" to start looking into the code and debugging. Besides, you have already pointed out the difficulty of setting up a debugging environment for testing Pay.

All this "bla bla" to say that your proposal to work with precompiled dll's is absolutely welcome. We could use our production site where all webstore and PayPal settings are already in place as a debug environment and send back to you the logs and feedback of any tests.

Looking forward for your contact.
Many Thanks!
Diego

6/25/2009 6:06:28 AM
Gravatar
Total Posts 18439

Re: WebStore: Order Confirmation Template and Screen

Hi Diego,

I'll contact you this afternoon with a link to download a new full package to upgrade your site. I will add a bunch of logging statements to help gather clues.

In the mean time if you could send me some data from your mp_PayPalLog table, just copy the contents of the RawResponse field from some existing rows where the problems occurred and paste into a text file. That may help me guess at what the problem is and what to try to fix it.

Best,

Joe

6/25/2009 7:47:29 AM
Gravatar
Total Posts 149
Partner
mojoPortal Skinning, Custom Development and Support in Italy?
EffectiveWeb.it

Re: WebStore: Order Confirmation Template and Screen

Hi Joe,

I've just sent by email the mp_PayPalLog for the transaction mentioned in this thread (4 records).

I'll wait for further instructions.

Diego

6/26/2009 6:02:05 AM
Gravatar
Total Posts 149
Partner
mojoPortal Skinning, Custom Development and Support in Italy?
EffectiveWeb.it

Re: WebStore: Order Confirmation Template and Screen

Dear Joe,

the fix you sent me works fine!
The test transaction in Euro with PayPal standard was completed as expected without any problems.
No more debugging is necessary. You can include the fix it in next release.

We can proceed now on our roadmap.
Should any further test be necessary, do not hesitate to contact me.

Thanks for the patience and competence.
The deserved beer is on the way!

Diego

6/26/2009 7:25:17 AM
Gravatar
Total Posts 18439

Re: WebStore: Order Confirmation Template and Screen

Excellent! I will be putting out a new release with this fix soon.

Many thanks for your help and the beers!

Cheers,

Joe 

You must sign in to post in the forums. This thread is closed to new posts.