Payment status problem related to currency

-- url of the page with the problem -- : dmendoza.us/hikashop1/index.php/sandy-hook-store/all-products
-- HikaShop version -- : 2.2.3 Starter
-- Joomla version -- : 3.1.5
-- PHP version -- : 5.3.23
-- Browser(s) name and version -- : firefox 25.0.1
-- Error-message(debug-mod must be tuned on) -- : None

I have been setting up a site to allow use of USD (for US customers) and EURO (for French customers). I have sales tax set up for US New Jersey (US State) customers and all other US customers pay no sales tax. I have VAT set up for French customers. Therefore I have your currency switcher module deployed to switch between USD and EUR. My main currency (in config) is set to USD. I am using PayPal Standard (originally live, but then I switched to Paypal sandbox).

First I created customers with US addresses (in NJ and other states) and have had no problems with Paypal payments (once they pay on Paypal their status always changes to confirmed on Hikashop). Then I created a customer with a French address. When I have the currency switcher set to USD and then have the French customer complete their order in checkout and subsequently pay on Paypal (in USD) all is fine and works the same as I found with my US test customers. However, when I change the currency switcher to EUR (this works fine and all amounts are converted correctly), and the customer subsequently pays on paypal...on Hikashop the order status stays in created. This is the only case where this happens (French customer paying using EUR currency). When the same French customer buys the same item and the currency switcher is first set to USD instead of EUR it works perfectly.

I checked the raw server logs. Here is the notification for the case where Hikashop works correctly (status is changed to confirmed because French customer pays in USD):

173.0.82.126 - - [18/Dec/2013:20:03:09 -0800] "POST /hikashop1/index.php?option=com_hikashop&ctrl=checkout&task=notify¬if_payment=paypal&tmpl=component&lang=en&Itemid=299 HTTP/1.0" 200 4983 "-" "PayPal IPN ( www.paypal.com/ipn )"

Here is the problem case (same French cust paying for same item using EUR):

173.0.82.126 - - [18/Dec/2013:20:50:10 -0800] "POST /hikashop1/index.php?option=com_hikashop&ctrl=checkout&task=notify¬if_payment=paypal&tmpl=component&lang=en&Itemid=275 HTTP/1.0" 200 5187 "-" "PayPal IPN ( www.paypal.com/ipn )"

I noticed in both cases the status code is 200, but there is a different number after that. Is this a clue? I don't know if this is a secondary HTTP code or what?

I also tried enabling debugging in the Paypal plugin per your documentation but no log file was created in media/com_hikashop/upload/safe of the site.

Thank you for your help.

Dan

Hi Dan,
You'll be able to check your payment log file through "Hikashop->System->Configuration->Main" by using the "See the report" button of your Payment log file option.
Can you please :
- Check that the debug mode option is ON through your Paypal payment configuration page
- Test it again
- Show me your Payment log file content.

Hi Mohamed,

Thank you for your quick response. I tested again insuring that the payment module had debug set to yes. However, no log file is created. When I click the "See the report" button in configuration/files, I see this:

The log file is empty /home/danshand/public_html/hikashop1/media/com_hikashop/upload/safe/logs/report_630965280.log

I confirmed using filezilla, that there is no .log file in hikashop1/media/com_hikashop/upload.

Should I create a text file and give it that name: report_630965280.log, and upload it there and re-do? Do you think that would create the output?

Thanks
Dan

Is the file components/com_hikashop/upload/safe/logs/report.log writable ? Normally, you should get reports in that file when paypal sends a notification. If you don't there are only two possibilities:
1. the file is not writable
2. paypal didn't trigger the plugin :

However, when I change the currency switcher to EUR (this works fine and all amounts are converted correctly), and the customer subsequently pays on paypal...on Hikashop the order status stays in created

Hi Mohamed,

You mean media/com_hikashop/upload/safe/logs/report.log, not components/com_hikashop/... right? In my installation there was no logs folder in safe folder (and therefore no report.log file in logs directory because the directory did not exist). So I just created the directory logs inside safe and added a text file that I changed the name to report.log.

After that I made a purchase from a US customer in USD. Everything worked (as it normally does with USD) on HIkashop and paypal sides. Customer paid on paypal and status changed to confirmed on hikashop and the 2 emails went out to customer (created and confirmed) from hikashop. However, nothing was written to my newly created logs/report.log.

Regarding write permissions: I checked on filezilla: all the directories are set to 755 - write only to owner (in the path: media/com_hikashop/upload/safe/logs) and the new file, report.log I set to 666 (write to owner, group and public). Are these settings correct? Should the new file also be set to 755?

Ok, I also checked the raw logs. I see:

173.0.82.126 - - [23/Dec/2013:10:11:26 -0800] "POST /hikashop1/index.php?option=com_hikashop&ctrl=checkout&task=notify¬if_payment=paypal&tmpl=component&lang=en&Itemid=299 HTTP/1.0" 200 5182 "-" "PayPal IPN ( www.paypal.com/ipn )"

Doesn't this confirm that the notification from paypal did occur? I also found a similiar log when I tested with euro the other day (It's shown in my first message below).

I can also try creating report_630965280.log (the file mentioned in Payment Log file option) which does not exist now in my files, turn on debug and re-test if you want. Not sure what would be helpful now.

(Also I just checked and debug was still on (in your paypal plugin display) from the other day when I just tested USD case.)

Thanks for all your help,
Dan

Hi Mohamed,

I just wanted to followup, as I finally resolved the Order Status issue regarding my customers paying using EUR currency.

What was happening is that my merchant account on the paypal sandbox had its profile set to ASK if payments were received in a different currency than the currency held. When I looked at the transactions for this account I saw that all the test payments that I sent in EUR were all in Unclaimed status, and there is a drop down button to accept or deny the payment. When I accepted one of these payments, the notification was sent and Hikashop immediately changed the status to confirmed and sent the email to the customer.

After that I went into the profile and changed it to accept and convert EUR payments to USD automatically. After that I tried another purchase in Hikashop using EUR. It was accepted and converted automatically and Hikashop changed the status automatically from created to confirmed just like orders done in USD.

So in the end Hikashop was correct in not changing the order status to confirmed yet because the payment was not completed on Paypal yet.

However, just out of curiosity I tried a few other things to get the payment log that you originally mentioned. I noticed that in Hikashop configuration, the payment log file was set to media/com_hikashop/upload/safe/logs/report_630965280.log. I added a text file with this name to the logs directory but still did not get anything written to the file (with paypal payment plugin set to debug on). I also tried creating a report.log text file, adding that to the logs directory and setting the Hikashop configuration payment log file to this file, and still no logs. I set the permissions for the entire path (all directories and the log files themselves) to 777 - except the subfolder of the entire website because if this folder is set to 777 I get a server error for the site, so I reset it to 755 to avoid the server error - but still no logs. Any idea why I cannot get these payment logs?

Thanks
Dan

Hi Jerome,

Thanks for your response. I have the debug button in the plugin turned on. Still I have not been able to get anything written to the log file.
See attached file for a screen print of the configuration of my plugin. Is there something else I need to do to get the log?

Thanks
Dan

Here is the screen shot.

Hi,

Sorry for this very late reply, do you have solved your problem ?
If not, thanks to update HikaShop, that could probably help you.

I am having this same issue with the log file being empty. It does not exist in the media directory that is listed in the main settings. Tried creating it but that did not work. It is mentioned in this thread that there is supposed to be an uploads directory in the com_Hikashop directory. For me that does not exist at all. Paypal settings Debug on, Allow notifications on, validation mode off. What gives?

Hi,

You potentially have folder permissions problems.
Thanks to try to change the access rights to 775. If the access are not correct, so we can't create a file of write in that file.