I tried to setup the Paypal smart buttons through the help file here: https://www.ecommercetemplates.com/help/ecommplus/paypal-smart-buttons.asp

I'm using ASP V7.2.4. I created a REST app, and when I go to the credentials, I copied the client ID from the paypal site into the client ID field of my admin. I assume that the "secret" on the paypal side is the "password" on the ECT side.

When I enter in my info in my admin, I get the error displayed below. Any help is appreciated.

Microsoft Access Database Engine error '80040e57'

The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.

/vsadmin/inc/incfunctions.asp, line 1939

I just checked our test account and the password we have there is 80 characters. How many do you have for yours?

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

Both my Client ID and Secret are 80 characters long

In that case then that field should really be able to handle a max of 255 characters normally. Do you have MS Access there and are you able to check the size of the payprovder->payProvData2 column? If not then can you send me the site FTP login to my email (vince AT ecommercetemplates DOT com) and I'll look.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

I do have MS Access, I downloaded the DB and it does claim 255 characters max for the fields in the payProvData2 column (as well as payProvData3).

I will note though, that payProvData1 is a limit of 50. I'm not sure if that is part of the problem.

Yes, if your Client ID is 80 characters then changing the payProvData1 to 255 chars should sort this out.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

That did the trick, but I can't seem to get the Smart Buttons to work.

When I click on either the paypal or paypal credit buttons, there's a popup that immediately closes. When I click on the credit card portion, it shifts to the left but nothing happens.

Can you try a test transaction with Chrome and then on the payments page, right click in the body of the page and select, "Inspect" and that should open the Chrome Object Inspector. Then you should see, "Elements, Console, Sources, Network, ..." and click on "Console" of those. Then try clicking on the smart buttons in the main window and any problems should be reported in the Console. Then can you let me know what, if anything, is displayed there?

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

4 seperate lines that are referring to https://www.paypalobjects.com/api/checkout.js

checkout.js:2844 ppxo_no_token_passed_to_payment Object
print @ checkout.js:2844

checkout.js:2844 ppxo_unhandled_error Object
print @ checkout.js:2844

checkout.js:990 Uncaught Error: No value passed to payment
at checkout.js:24369
at ZalgoPromise._proto.dispatch (checkout.js:1020)
at ZalgoPromise._proto.resolve (checkout.js:972)
at checkout.js:946
at ZalgoPromise._proto.dispatch (checkout.js:1020)
at ZalgoPromise._proto.resolve (checkout.js:972)
at ZalgoPromise._proto.dispatch (checkout.js:1039)
at ZalgoPromise._proto.resolve (checkout.js:972)
at checkout.js:946
at XMLHttpRequest.<anonymous> (checkout.js:1644)
at Object._RECEIVE_MESSAGE_TYPE.<computed> [as postrobot_message_response] (checkout.js:5243)
at receiveMessage (checkout.js:5279)
at messageListener (checkout.js:5301)

checkout.js:24663 Uncaught Error: Error: No value passed to payment
at checkout.js:24369
at ZalgoPromise._proto.dispatch (checkout.js:1020)
at ZalgoPromise._proto.resolve (checkout.js:972)
at checkout.js:946
at ZalgoPromise._proto.dispatch (checkout.js:1020)
at ZalgoPromise._proto.resolve (checkout.js:972)
at ZalgoPromise._proto.dispatch (checkout.js:1039)
at ZalgoPromise._proto.resolve (checkout.js:972)
at checkout.js:946
at XMLHttpRequest.<anonymous> (checkout.js:1644)
at Object._RECEIVE_MESSAGE_TYPE.<computed> [as postrobot_message_response] (checkout.js:5243)
at receiveMessage (checkout.js:5279)
at messageListener (checkout.js:5301)
at checkout.js:6178
at checkout.js:6181
at checkout.js:6008
at checkout.js:6003
at checkout.js:6004
at replaceObject (checkout.js:6007)
at checkout.js:6009
at checkout.js:6005
at checkout.js:6006
at replaceObject (checkout.js:6007)

Hi sparksm2
I tried searching for that error and one possibility that came up a few times was that you are using the sandbox credentials for the production account or vice versa. If that doesn't help, can you send the site FTP login details to my email and I'll have a check to see what is going on.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

Just to be clear, this is what should be done:
1) go to: https://developer.paypal.com/developer/applications/
2) click on "My Apps & Credentials"
3) click on the name of the REST Api app that I want to use (I created a Sandbox app, not a Live app)
4) copy the "Client ID" from the Paypal site and paste that into the "Client ID" field on my ECT site.
5) copy the "Secret" from the Paypal site and paste that into the "Password" field on my ECT site.

Is this correct?

This is my first time using these features in Paypal, so it's possible I'm missing something very obvious and basic those who've used this before.

Basic Question #1) I logged into the develop side of paypal using my main paypal account that normally accepts payments, I'm assuming that Paypal knows that the dev account is linked to my paypal account, right? If not, how do I link the account tied to the REST Api to my account?

Basic Question #2) When I log into the paypal dev site, there are two default sandbox accounts that were auto generated. Do I need to make a different sandbox account?

Basic Question #3) On the default account that was automatically made by paypal that I'm using for my REST Api, the account type is "Business" but has a link to "Upgrade to Pro". Does it need to be the Pro account or stay as Business?
--------------
I'm 99% confident I can copy & paste in the user and password fields in correctly but it's possible I'm not entering the correct fields. This is likely a simple goof on my end or some sort of disconnect between the dev account and my paypal account.

Does something else need to be enabled or disabled for these to work? We're currently using Paypal Direct and Paypal Express and they function fine but the Smart Buttons is a much more elegant way to accept paypal than the current solution that takes you off-site. I'm new to the developer site of paypal, so I might need some of this explained to me like I'm five years old.

Hi Sparksm2
It is quite a bit more complicated to set up a sandbox account, but do you have the PayPal Checkout set to demo mode in the ECT payment providers admin? If not, the cart won't use the sandbox site.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

I have a test store that I've been trying to get the smart buttons to work on. On there, the Paypal Direct and Paypal Express options are disabled and only the smart buttons are enabled.

So, what needs to be done to get these up and working?

The ECT help file essentially says 2 things:

1) "Once you have created your account with PayPal you can log into your store control panel, choose Payment Providers from the menu and then locate the payment provider listed as "PayPal Checkout" and click on the Modify button."

2) "You can obtain the Client ID and Password by logging into developer.paypal.com with your live account. Then click on “My apps & Credentials” on the left. Next, find your REST app, and after clicking on it, you would be able to see the Client ID and secret, as shown below:"

------

If there additional, more complicated, steps to this setup then what are they and how do we get this working? The smart buttons seem like a nice feature that solves a few problems that I have but the documentation for the implementation is lacking.

I still can't seem to get these to work at all. If anyone who has these integrated into their website can help me, that would be much appreciated.

Hi there
Could you possibly give us more details about how things are going wrong? For instance, are you getting an error message or something like that? As mentioned previously, I wouldn't set up a sandbox account as that will just complicate things more.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

So, just to clarify, do NOT use a sandbox account?

I was basing most of my experience from the help file here: https://www.ecommercetemplates.com/help/ecommplus/paypal-smart-buttons.asp which clearly shows a screenshot of sandbox API credentials.

I created a "Live" Rest API app just now and it still doesn't work. These are the errors I get:

ppxo_no_token_passed_to_payment Object
print @ checkout.js:2848

checkout.js:2848 ppxo_unhandled_error Object
print @ checkout.js:2848

checkout.js:986 Uncaught Error: No value passed to payment
at checkout.js:23983
at ZalgoPromise._proto.dispatch (checkout.js:1016)
at ZalgoPromise._proto.resolve (checkout.js:968)
at checkout.js:942
at ZalgoPromise._proto.dispatch (checkout.js:1016)
at ZalgoPromise._proto.resolve (checkout.js:968)
at ZalgoPromise._proto.dispatch (checkout.js:1035)
at ZalgoPromise._proto.resolve (checkout.js:968)
at checkout.js:942
at XMLHttpRequest.<anonymous> (checkout.js:1648)
at Object._RECEIVE_MESSAGE_TYPE.<computed> [as postrobot_message_response] (checkout.js:5246)
at receiveMessage (checkout.js:5282)
at messageListener (checkout.js:5304)

Can you send me details of your test site to my email please?

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

I'm sorry for the delay here but just to let you know I have narrowed the problem down and I'm on to PayPal about it. Hopefully I can sort things out with them and I'll let you know when I have any news.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

Thanks for the update Vince.

I'm sorry for the delay in getting back to you but I've been back and forward with PayPal a few times on this and they are saying it's not really their problem. I can kind of see their point but that really makes it a Windows Server problem and we're not really going to get them to make big changes to Classic ASP so I really don't think we are going to get a resolution to this. My apologies that you spent time on this bit I don't really see what else to do other than pull support for Smart Buttons on ASP.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

Ok. That's unfortunate but it is what it is. If fixing this isn't possible then making we can make some changes to the ECT side of things to get rid of some nagging PayPal Express problems that I have, which I was hoping to fix with the Smart Buttons.

I think for me, the solution is to simply revert the way that PayPal Express works back to an older version where it would send users to checkout step 2 upon logging in.

1) Shipping price problems:

Problem: Every day I get calls about how the shipping estimator will give the customer a price of $xx.xx (always lower) but when they checkout with PayPal it is $xx.xx (always higher). The cause of this is an estimated rate from USPS on the first step of the checkout, followed by a higher rate from FedEx (the default service for us) that gets passed along to PayPal.

I always have to tell the customer that they will be brought back to the site to get that lower rate which was in the estimate. They always say "but it says Pay Now, are you sure?!" "Yes... I am sure, trust me". I go through this song and dance multiple times a day.

I upgraded not too long ago and the PayPal Express behavior changed from what I was used to in an older version. Before, it would have the customer login on checkout step 1 and then send them to checkout step 2. This older method would not pass along the shipping cost info and we used to not have this problem.

Ideal solution 1: Revert the PayPal Express behavior to not pull a shipping rate upon login, and send them back to checkout step 2.
Ideal solution 2: Have the customer select the shipping they want, and THEN log into PayPal to pay. It was my understanding that this is how the Smart Buttons would work.

2) No "additional information" box

Problem: Again, I upgraded not too long ago and the PayPal Express behavior changed from what I was used to in an older version. Before, it would have the customer login on checkout step 1 and then send them to checkout step 2 where they can type out additional information. Since the PayPal Express now skips from step 1 to step 3, there is no box for the customer to type in additional information.

Ideal solution 1: Revert the PayPal Express behavior send customers to checkout step 2 after logging into PayPal.
Ideal solution 2: Add an "Additional Information" box to checkout step 3
Ideal solution 3: Have the customers use checkout step 2, and THEN log into PayPal to pay. It was my understanding that this is how the Smart Buttons would work.

3) No "Ship To" vs "Bill To"

Problem: Yet again, skipping the checkout step 2 is killing my customers. Many of them call up asking why they can't specify an address on our site for a different ship to. Maybe they can change the address in PayPal but that's not what they want to do, which requires a multiple time a day explanation.

Ideal solution 1: Revert the PayPal Express behavior send customers to checkout step 2 after logging into PayPal.
Ideal solution 2: Have the customers use checkout step 2, and THEN log into PayPal to pay. It was my understanding that this is how the Smart Buttons would work.