Webinar about Paypal

Scriptcase 7 Discussion
#1

To be able to reproduce the sample I showed in the webinar some things needs to be solved in the webshop sample application:

  1. Table names are now case sensitive in MySQL. In some applications SC is using uppercase for tablenames which needs to be set to lowercase
  2. The emailing is hard-coded in the source and needs to be changed to your settings
  3. The setglobal does not work as it has syntax errors somewhere. Just change the sc_redir and set the vars to be passed in there.
  4. Somewhere there is a last insert id() but the syntax is not correct.

These issues are due to the fact that the sample is old and probabely created upon an older edition of MySQL, but it should not be hard to solve.

To setup paypal, create a paypal account and verify that, then create a developer account. Then create your sandbox account which are needed for testing.

DO NOT RELY ON THE CONFIRMATION PAGE to store payment data. First the global variables are not set which you need to determine data of your customer, second this message only appears if the customer clicks on ‘go back to the webshop’.

ONLY PROCESS THE IPN page. This is a hidden page which is called by paypal. Within this process you must use the PayPal data to finalize your transaction. The globals contain address of your customer etc.

USE the hidden variable as this is needed for enhanced security, see the webinar for explanation (it will be available on the website of SC soon.

To test the IPN message it’s most likely that you need to deploy your application first. Paypal will call your application from the internet and it’s very likely that your pc is not listening :wink:

When you go into production **ALWAYS USE HTTPS **

If there are more questions, please put them here.

//
Thanks for the nice words of some followers. I’m aware that I’m not native English and talking in a microphone with only your screen in front of you is completely different than doing the same in a room full of people as I’m used to. But it was a good experience. If you have subjects you want me to present some next time, please let me know.

#2

Was a great webinar Albert, thanks for the briefing.

I asked about owing a beer to you, but Marcia didn’t told you :stuck_out_tongue:

#3

[QUOTE=Giu;23442]Was a great webinar Albert, thanks for the briefing.

I asked about owing a beer to you, but Marcia didn’t told you :P[/QUOTE]

Always nice to drink a beer with friends. Who knows, Spain is not that far.

#4

SC conference

How about a SC user conference - that would give me a good excuse to come over to Europe and meet all of you. Or we could have it here in Florida :slight_smile:

As I emailed, it was a great webinar Albert. I could understand it all - no problems on the language at all.
Peace,
Jamie

#5

[QUOTE=onmountain;23455]How about a SC user conference - that would give me a good excuse to come over to Europe and meet all of you. Or we could have it here in Florida :slight_smile:

As I emailed, it was a great webinar Albert. I could understand it all - no problems on the language at all.
Peace,
Jamie[/QUOTE]

Could be interesting, but this kind of events are expensive (in money and time) to organize.

Maybe could be interesting to try with something like a hangouts hackaton meeting or something like this, to see reception.

Let me think about it.

#6

great summary and its a good webinar…

play pokies

#7

Hi Albert,
I’ve seen every single secon of your webinar. You’ve reproduced an error giving an amount with euros, something like 100€ and not 100 as number.
Well, I need to pay in EUR and not in USD, how can I send the currency_code variable to PayPal ? There’s nothing to setup at PayPal level, I’ve talked with them today, we only need to set that parameter and everything is fine !

I’ve tryed with this and it runs perfectly :

<form action=“https://www.paypal.com/cgi-bin/webscr” method=“post”>
<input type=“hidden” name=“cmd” value="_xclick">
<input type=“hidden” name=“business” value="paypal@sardaterra.com" >
<input type=“hidden” name=“item_name” value=“Union Jack Flag”>
<input type=“hidden” name=“amount” value=“20”>
<input type=“hidden” name=“currency_code” value=“EUR”>
<input type=“hidden” name=“undefined_quantity” value=“1”>
<input type=“image” src=“https://www.paypal.com/en_US/i/btn/x-click-butcc.gif” border=“0” name=“submit” width=“73” height=“44”>
</form>

How can we do ?

Thank you
Raimondo Zoroddu