order details passed to paypal

[feemish]

Hi all,

I've checked the forum but cant find an answer to this particular problem.

I am set up with paypal as my sole psp ... actinic 7.0.6

everything is basically working ok... i get confirmation emails, and lots of orders.. etc.

The bug is that actinic doesnt pass on all the customer details to paypal.

Now i know it doesnt pass the actual order details... just the order number. Thats ok.

..and most of the customers address is passed to paypal ok.

But not all the details.

The customer fills out his phone number and email address in actinic, but when you get passed to the paypal page, these details are not included. So the customer has to enter them again..
Also the first name... and the county are missing from the address passed to paypal.

Not a big problem, i know, but still, i'm sure its a bit annoying for the customer to enter these details twice.
The paypal process is a bit 'lumpy' anyway, so it'd be nice to make it as least painful as possible.

I think these details are passed using NETQUOTEVAR:OCC_Values
but i cant find out how to edit these values so that paypal enters them into the correct field on its page...

Any clues greatly appreciated.

http://www.arka-shop.co.uk

[feemish]

woooah...

the silence...

Have i said something wrong... is it the dreaded 'p*ypal' word ?

Someone point me in the right direction please..

http://www.arka-shop.co.uk

[Bruce]

Mark,

Hi there, Apologies for this one not having a response as yet. The order details are all that is passed to PayPal from Actinic, when using normal PayPal. If you upgrade to v8 and use PayPal Pro, then these details will all be passed across.

Kind regards,

[feemish]

Hi Bruce,

Thanks for the reply, but thats not right.

I'm on standard Paypal. Actinic 7.0.3.

Check it out for yourself;
http://www.arka-shop.co.uk

At paypal click pay with credit card.

The form on the first paypal page is partially populated with details from actinic !

This is good, but some are missing... email... phone number comes through partially, country.

But most of the address is there and correct.

So if some of it is... surely all of it can be.. no?

Best Regards,
Mark

[feemish]

Having all the paypal fields fill by actinic would make the checkout process so much nicer.... and seeing as most of the fileds are being populated by info from actinic, i cant see a reason why it cant be tweaked to populate all the fileds.

I'm hunting around for this, but cant find the solution.

Mark

[Bruce]

Hi Mark,

Have you seen this thread http://community.actinic.com/showthread.php?t=34880? Check post #8.

Kind regards,

[feemish]

Hi Bruce,

Thanks for that, but i have seen it, tried it, and it doesnt help me.
That thread is about paypal express info.. going to actinic.

If someone would make a test purchase at my site.. they'll see what i mean.

Actinic is sending paypal most of the address details, and the paypal form is being correctly populated, with most details, from actinic.

Despite what you said earlier.
The order details are all that is passed to PayPal from Actinic, when using normal PayPal.
I'm using normal paypal... this just isnt true.

What i need to know is which file or process is sending the address and order details to Paypal so i can edit it to include the variables that are missing... email, phone etc...

Best Regards,
Mark

http://www.arka-shop.co.uk

[feemish]

apologies for bumping this thread...
but does anyone have a clue for me?
Mark

http://www.arka-shop.co.uk

[RuralWeb]

If you get no relpies it usually indicates that you are not going to get any info - bumping will not help you

[Rollerboy]

Hi all,

Newbie here. I'm having exactly this problem Feemish.. Have you discovered how or where the details are passed to paypal from actinic yet? As you say, seeing as some of the address details are passed to Paypal, it must be possible to pass on the rest.. It would make the paypal process less tedious for our customers for sure. Paypal is accounting for almost half our orders at the moment, so i'd like to smooth this process out as well.

Martin

[TraceyG]

Hi Mark,

I've been doing some tests regarding this and on your site, I had everything passed across except the phone number and the email address. According to our development team, the email address is not a field we pass because it was not specified in the integration document we got from Paypal and it is not a requirement to validate the payment. I can add it to the wishlist to pass this value across.

I'm investigating with the development why the telephone number isn't passed across.

[feemish]

Hi Tracey,

Thanks for looking into this for me.

What file or process passes the information to paypal?
Can this be edited to include the variables 'phone number' and 'email address'?

Thanks again,

Oh and RuralWeb, thanks for your comments as well... very helpful.

http://www.arka-shop.co.uk

[TraceyG]

Hi Mike,

We use a perl script to get the information that is transferred to Paypal. We have contacted them to find out if we can have that information passed across or if Paypal actually need it so that maybe we can remove the fields from their page.

I'll post back as soon as we get an answer.

[TraceyG]

Hi,

Just to let you know that we are still speaking to Paypal about this. The main problem with the phone number is that Paypal seem to deal with US phone numbers only and because of the way they split them up UK numbers don't get passed through. We have had various solutions from them but I haven't got them working fully yet - it depends on how a customer enters the phone number (ie with spaces or without).

We have, however, got it to pass across the email address and to do this you need to go to your site folder and within the CommonOCC folder open the 'OCCPayPalTemplate.pl' in a text editor such as notepad. Search for:


AddPostValues ('&', 'night_phone_c', $nPart2, $OPTION, $REDIRECT);

and add the following on a new line after this one:


AddPostValues ('&', 'email', $::InvoiceContact{EMAIL}, $OPTION, $NOENCODE);


Close and save the file and update the site.

I'll post back with the solution for the phone number as soon as I have it working correctly.

[feemish]

Hi Tracey,

Thanks for that !!

Every tweak helps make the process a bit smoother.

http://www.arka-shop.co.uk

[feemish]

Hi Tracey,

Any news on the phone number bit..?

Best Regards,
Mark

http://www.arka-shop.co.uk

[TraceyG]

Sorry Mark, we'd put a support query into Paypal. I'll chase our developer who was dealing with them to see if there's a response yet?

[TraceyG]

Hi Mark,

We have a way of passing the telephone number but not sure what effect this will have at Paypal's end:

- first take a backup of your current 'OCCPayPalTemplate.pl' file in your 'site/CommonOCC' folder
- then open the file in a text editor such as 'notepad'
- locate the line:

my ($nAreaCode, $nPart1, $nPart2);

- you will see:

my ($nAreaCode, $nPart1, $nPart2);
$nPart2 = $::InvoiceContact{PHONE};
if ($nPart2 =~ /(\d{3}).*(\d{3}).*(\d{4})/)
{
$nAreaCode = $1;
$nPart1 = $2;
$nPart2 = $3;
}

AddPostValues ('&', 'night_phone_a', $nAreaCode, $OPTION, $NOENCODE);
AddPostValues ('&', 'night_phone_b', $nPart1, $OPTION, $NOENCODE);
AddPostValues ('&', 'night_phone_c', $nPart2, $OPTION, $REDIRECT);

- replace this with:

AddPostValues ('&', 'night_phone_b', $::InvoiceContact{PHONE}, $OPTION, $NOENCODE);

This will then always pass the phone number entered in Actinic to the 'night_phone_b' variable at Paypal and will then display in the phone field at Paypal, however, we can't guarantee that this will work for all variations of phone numbers (ie US/UK/ with spaces / without spaces etc). I would think that if the majority of customers are from the UK then this will work but you would need to test it further for customers from other countries.

[feemish]

Thanks Tracey,
I'll give that a try.
Best Regards,
Mark

http://www.arka-shop.co.uk

[feemish]

Well that does pass the phone number....

It adds a +44 at the start? Regardless of which country you choose... Cant see how it does that.

Whilst checking this using other countries, I've noticed that Actinic doesnt pass on the 'country' to Paypal..
Whichever country you choose, when you get to Paypal it lists it as UK.

Can we pass the country correctly to Paypal as well..?
How would we do that?

Best Regards,
Mark

http://www.arka-shop.co.uk

[feemish]

Looking at OCCPaypalTemplate.pl it doesnt look like the country variable is passed on to Paypal at all...?
AddPostValues ('&', 'first_name', $sFirstName, $OPTION, $REDIRECT);
AddPostValues ('&', 'last_name', $sLastName, $ALWAYS, $REDIRECT);
AddPostValues ('&', 'address1', $::InvoiceContact{ADDRESS1}, $ALWAYS, $REDIRECT);
AddPostValues ('&', 'address2', $::InvoiceContact{ADDRESS2}, $OPTION, $REDIRECT);
AddPostValues ('&', 'city', $::InvoiceContact{ADDRESS3}, $OPTION, $REDIRECT);
AddPostValues ('&', 'state', $::InvoiceContact{ADDRESS4}, $OPTION, $REDIRECT);
AddPostValues ('&', 'zip', $::InvoiceContact{POSTALCODE}, $OPTION, $REDIRECT);
AddPostValues ('&', 'night_phone_b', $::InvoiceContact{PHONE}, $OPTION, $NOENCODE);
AddPostValues ('&', 'email', $::InvoiceContact{EMAIL}, $OPTION, $NOENCODE);

'country' is included in the html variable for prepopulating Paypal payment pages... according to the Paypal integration pdf.

TABLE A.8 HTML Variables for Prepoluating Payment Pages with Buyer Information
Variable Description Requirements
Character
Limit
address1 Street (1 of 2 fields) Alphanumeric 100
address2 Street (2 of 2 fields) Alphanumeric 100
city City Alphanumeric 40
country Sets shipping and billing country. See
Appendix C for allowable country codes.
Alphabetic 2
first_name First name Alphabetic 32
last_name Last name Alphabetic 64

It seems a bit duff that the original OCCPaypalTemplate doesnt pass on ; phone number, email address, or country ! doesnt it?

So customers have to type this all in again at paypal.

I've adjusted the template so now 'email' gets populated.. and 'phone number' (sort of).. Now i want 'country' to be populated as well.

I've noticed that the country code in actinic for the UK is UK whereas Paypal wants it to be GB. I presume i can just change this in 'locations'

I just need the correct snippet of code to put in OCCPaypalTemplate.pl to pass the country code to Paypal.

I'm expecting its something like this...

AddPostValues ('&', 'country', $::InvoiceContact{country}, $OPTION, $NOENCODE);

although the country is a 2 digit code..

Any clues anyone?

Mark

[TraceyG]

Hi Mark,

Try the following:

- open 'OCCPaypalTemplate.pl' in your site folder and search for:

AddPostValues ('&', 'zip', $::InvoiceContact{POSTALCODE}, $OPTION, $REDIRECT);

- after the above enter:

my $sCountry = $::InvoiceContact{COUNTRY};
$sCountry =~ s/^GB$/UK/;
AddPostValues ('&', 'country', $sCountry, $OPTION, $REDIRECT);

This should translate UK to GB if necessary and pass the country across. Don't change the country code in the locations list as this could cause problems elsewhere. Obviously, take a backup of your perl file before changing it.

[feemish]

Hi Tracey,

Thanks for that, but unfortunately, it doesnt seem to work.

After including tha above code, Arriving at the Paypal page.. the country is always United Kingdom, whichever country i choose at the Actinic page...

Best Regards,
Mark

http://www.arka-shop.co.uk

[TraceyG]

Hi Mark,

I got the developers to take another look at it and they have suggested using the following code (this passes the country code whereas the previous passed the country name):

my $sCountry = $::g_LocationInfo{INVOICE_COUNTRY_CODE};
$sCountry =~ s/^GB$/UK/;
AddPostValues ('&', 'country', $sCountry, $OPTION, $REDIRECT);

[feemish]

Hi Tracey,

Thanks for that, it seems to work well now..

Its much better... if someone now for example chooses 'germany' as their country, the paypal page they land on is now in German!
All looks lots better. Thanks.

Mark

http://www.arka-shop.co.uk

[Mox]

Hi, I have the same problem as this (v6) and have followed these instructions carefully, yet only the email address is coming through properly.

The phone number is coming through although is being prefixed with +012 and then the number I've typed which also starts 012

The country code doesn't seem to be acknowledged if it's anything other than Uk for some reason.

Has there been any development on this issue since the last post on this thread does anyone know?

Many thanks
Michelle

[feemish]

Hi,

My set up is still working as it should, after following the above.
I'm afraid i dont know why yours shouldnt be... sorry,

Best Regards,
Mark

http://www.arka-shop.co.uk

[Mox]

Ok, thanks Mark.

This is my code snipet, I wonder if you or anyone might be able to spot the potential problem?

It's v6, I don't know if that makes a difference?


AddPostValues ('&', 'first_name', $sFirstName, $OPTION, $REDIRECT);
AddPostValues ('&', 'last_name', $sLastName, $ALWAYS, $REDIRECT);
AddPostValues ('&', 'address1', $::InvoiceContact{ADDRESS1}, $ALWAYS, $REDIRECT);
AddPostValues ('&', 'address2', $::InvoiceContact{ADDRESS2}, $OPTION, $REDIRECT);
AddPostValues ('&', 'city', $::InvoiceContact{ADDRESS3}, $OPTION, $REDIRECT);
AddPostValues ('&', 'state', $::InvoiceContact{ADDRESS4}, $OPTION, $REDIRECT);
AddPostValues ('&', 'zip', $::InvoiceContact{POSTALCODE}, $OPTION, $REDIRECT);
my $sCountry = $::g_LocationInfo{INVOICE_COUNTRY_CODE};
$sCountry =~ s/^GB$/UK/;
AddPostValues ('&', 'country', $sCountry, $OPTION, $REDIRECT);

my ($nAreaCode, $nPart1, $nPart2);
$nPart2 = $::InvoiceContact{PHONE};
if ($nPart2 =~ /(\d{3}).*(\d{3}).*(\d{4})/)
{
$nAreaCode = $1;
$nPart1 = $2;
$nPart2 = $3;
}

AddPostValues ('&', 'night_phone_a', $nAreaCode, $OPTION, $NOENCODE);
AddPostValues ('&', 'night_phone_b', $::InvoiceContact{PHONE}, $OPTION, $NOENCODE);
AddPostValues ('&', 'night_phone_c', $nPart2, $OPTION, $REDIRECT);
AddPostValues ('&', 'email', $::InvoiceContact{EMAIL}, $OPTION, $NOENCODE);
#
# end of the invoice address details

Many thanks in advance
Michelle

[feemish]

Hi Michelle,

HHmm, your code doesnt look like mine, are you sure you followed the above carefully.. my code looks like this;

#
# supply the cardholder's address details
#
my ($sFirstName, $sLastName);
$sLastName = $::InvoiceContact{NAME}; # default to a blank first name and complete last name
if ($sLastName =~ /^([^ ]+) (.+)/) # if the name field looks to contain at least two name parts
{
$sFirstName = $1; # break the name up
$sLastName = $2;
}
AddPostValues ('&', 'first_name', $sFirstName, $OPTION, $REDIRECT);
AddPostValues ('&', 'last_name', $sLastName, $ALWAYS, $REDIRECT);
AddPostValues ('&', 'address1', $::InvoiceContact{ADDRESS1}, $ALWAYS, $REDIRECT);
AddPostValues ('&', 'address2', $::InvoiceContact{ADDRESS2}, $OPTION, $REDIRECT);
AddPostValues ('&', 'city', $::InvoiceContact{ADDRESS3}, $OPTION, $REDIRECT);
AddPostValues ('&', 'state', $::InvoiceContact{ADDRESS4}, $OPTION, $REDIRECT);
AddPostValues ('&', 'zip', $::InvoiceContact{POSTALCODE}, $OPTION, $REDIRECT);
my $sCountry = $::g_LocationInfo{INVOICE_COUNTRY_CODE};
$sCountry =~ s/^GB$/UK/;
AddPostValues ('&', 'country', $sCountry, $OPTION, $REDIRECT);
AddPostValues ('&', 'night_phone_b', $::InvoiceContact{PHONE}, $OPTION, $NOENCODE);
AddPostValues ('&', 'email', $::InvoiceContact{EMAIL}, $OPTION, $NOENCODE);
#
# end of the invoice address details
#
#

Good luck,
Mark

[Mox]

Many thanks Mark. I've made my code look identical to yours, although it hasn't made any difference :(

Maybe it's because I'm on v6 whereas you're on v7.

:rolleyes:

[feemish]

I cant see that being on v6 would make a difference to this...
sorry i dont know what else to suggest though...

[Mox]

No worries Mark, thanks for your help anyway.

Michelle

[NigelRS]

Well I have read this thread and lots of others and still see no solution.

I recently integrated PayPalPro as our payment system (updated from PayPal standard) within the checkout pages in Actinic. I have Business MultiSite v8.5.3 and still orders processed are passing no details over to PayPal so none of our orders are covered by the PayPal protection scheme, nor can our dispatch department print dispatch docs from 1 area (e.g. print directly off PayPal) as half the addresses are missing.

Orders we receive via our eBay outlets do enter the full information. Our tax is set to 'simple' as we don't go VAT regsitered until next month. I am not sure what other settings we require.

If it makes any sense our url is www.lifetools.com and we use Actinic as a back-end ecommerce solution to processing orders as our site is 'information heavy'.

Thanks from :confused:

P.S. If it makes any difference we will be upgrading to v9 early next week.

[TraceyG]

and still orders processed are passing no details over to PayPal
Is this happening on all orders? One potential problem that I can see is that if someone ships the order to a different address to the invoice address then the country field become a free text field on the inovice address page. This isn't allowed with Paypal Pro as they require the ISO country code to be passed to them. In this case you will have to set your tax to 'advanced' and the 'Tax by Location' to 'Tax by Invoice Address' to ensure that ISO codes are used on both the invoice and delivery address pages. You can set the VAT rate to 0.00.

[NigelRS]

Thanks...but it still isn't working. I have Business Plus v9.0.3 and all orders processed via PayPal Pro are not sending the addresses over. I had it set on simple mode, I had it set on Tax by Delivery and have just changed it to Tax by Invoice address (with VAT set to 0) - in no circumstance was any address passed over. That is regardless of if the delivery address is the same as the invoice address, or different, neither circumstance works.

I will take it up with support as we have a full support contract, so I hope they can shed some more light on this matter.

[munyaradzi.bu]

Hie Guys Forgive for coming late. Here is the solution to your problem.
Go to paypal site highlight the fileds and access the DOM panel.View the source. what you need to do is to match your fileds of paypal and your fields just before you post.

For example in your module paypal.php
<input type="hidden" name="H_PhoneNumber" value="<?php echo $_SESSION['phone']?>">

and name="H_PhoneNumber" is the filed in paypal and am transfering my data from $_SESSION['phone'] to the paypal field. you can chat with me on skpe if the need still arises . however am now strugling with adding more fileds to paypal and use the:

os1
on1 etc . may someone explain in details how can i use this effectively and under what conditions.
thanks

[feemish]

The country code fix from TraceyG seems to have stopped working.
see here;
http://community.actinic.com/showthread.php?t=44174

update: actually the code is wrong :eek: follow the link to the correct snippet