[solved] (my own fault), wrong currency on paypal orders.

[jeremy-]

Ive currently got my vendor set to AUD, and some products set to AUD. I've moved away from the sandbox and I'm testing live transactions for a few dollars to make sure things are working.

When I submit my transactions for some reason they seem to appear in USD, I'm probably missing something here, can you offer any ideas?

Cheers.

[netshine]

Check the 'order' tab of your order form to see what currency is specified there. You can of course delete any currencies that you are not using.

[jeremy-]

Ive got more information so i can better articulate my issue now, I'm still having problems, though.

- So Ive checked the vendor, the currency is correct.
- I tried changing the order form to manually use AUD.
- I checked the product which is under AUD
- I checked the individual order which shows "australian dollars" in the select
- And I checked the invoice which shows "australian dollars" in the select.[/li]

Im wondering whether it has something to do with the Paypal checkout. Each time i test paying for the transaction, it has PAYPAL (US) https:// in the address bar. Although I would assume you can still issue different currencies to the US paypal, maybe thats an incorrect guess.

One particularity of the way I am testing is that I am clicking the 'pay this invoice' from the invoices screen and paying from here, rather than using an automatic pay at the point of purchase, this is the way I am hoping to use nbill for my business case with 3 weeks payment terms.

What would be the best way to debug at which level the issue is happening. I suppose if i can confirm that the everything is fine in the database until the payment gateway we could suspect the problem could be there? There might have been a few times I have downloaded miscellaneous fixes you have posted here for users, or a time I have updated nbill. I'm sure I havnt changed any programming except layout. I'm wondering whether though I should try reinstalling nbill.

[jeremy-]

I've narrowed it down quite a lot, if I view the invoice in the administrator and click save, I can see the currency being applied and the gateway is then applied. So despite the fact that the dropdown states "Australian Dollars" in the VIEW area, it actually isnt being applied at the database end.

This matches the lack of AUD entries in the database. Each time the invoice said "australian dollars" on the view area but had nothing in the database.

The problem (appears to be) that the order form is somehow not applying the currency. Again, I'm confident I didnt do anything to compromise the order form on my end but I cant be 100%.

I'm thinking the best way to proceed would be to test it on another form from scratch as a first measure to see if its some peculiarity in my specific form or a system issue.

[netshine]

Are you using the free Paypal gateway that comes with nBill, or the 3rd party Paypal Pro gateway? If the latter, try using the built-in Paypal gateway and see if the same problem occurs.

[jeremy-]

When I use an order form, the order form shows 'order summary' with AUD next to the value, yet when the order is added to the database, the currency SQL field in jos_nbill_orders is left empty. Leaving it as empty to default to vendor AUD or entering AUD manually do not change the result. Creating a new form also does not affect the result.

If I open the order or invoice on the admin side, and click save, the SQL data is added to the database which fixes the problems. This means it must be at instancing the order the problem occurs.

---

I went to a clean installation and rebuilt my changes and the problem was fixed. Im assuming it was either me installing a bugfix i saw you do for somebody else or , (more likely) an edit i did caused an issue. I apologize for making a support request based on an issue that i probably caused... I wasnt sure where to start bugfixing at the start.