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.

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

6/12/2009 6:18:09 AM

Diego Mora

Total Posts 149

View Posts

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

Diego Mora

Total Posts 149

View Posts

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

Joe Audette

Total Posts 18439

View Posts

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

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

Diego Mora

Total Posts 149

View Posts

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

Joe Audette

Total Posts 18439

View Posts

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

Diego Mora

Total Posts 149

View Posts

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

Diego Mora

Total Posts 149

View Posts

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

Joe Audette

Total Posts 18439

View Posts

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

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

Joe Audette

Total Posts 18439

View Posts

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

Diego Mora

Total Posts 149

View Posts

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

Diego Mora

Total Posts 149

View Posts

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)

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