OT: Is anyone here using PayPal IPN?

[J.S. \(UltraSuite\)]

If so, what datatypes are you using for your various IPN variables?

How do you handle shopping cart transactions with multiple-items? Do you
insert all items in one record, or in several records one per each
item_type, or in separate tables with user info in one table and
transactions in another table linked to the first with user_id? The last
seems to be the best option in terms of database normalization but does it
work fine with PayPal IPN?

Thanks!

J.S.

[Anthony Brown]

The second option is what I used.

I had a CF Page that recieves the IPN from Paypal and by extracting certain
variables I use that to insert into 3 tables.
Customer_tb
Order_tb
Orderdetails_tb

Now, I use the Website payment preferences, and data transfer instead of
IPN and it works better in my opinion.

-Anthony

"J.S. (UltraSuite)" <ultrasuite@nospam.com> wrote in message
news:cuv7sl$bb7$1@forums.macromedia.com...

> If so, what datatypes are you using for your various IPN variables?
>
> How do you handle shopping cart transactions with multiple-items? Do you
> insert all items in one record, or in several records one per each
> item_type, or in separate tables with user info in one table and
> transactions in another table linked to the first with user_id? The last
> seems to be the best option in terms of database normalization but does it
> work fine with PayPal IPN?
>
> Thanks!
>
> J.S.
>
>

[J.S. \(UltraSuite\)]

> Now, I use the Website payment preferences, and data transfer instead of

> IPN and it works better in my opinion.

Do you mean that you use the PDT variables on the autoreturn page to insert
the transaction values into your database? If so, why do you think it works
better than IPN? I have tested both in combination and I am not sure what
is the advantage of inserting the values into the database on that the
autoreturn page.

J.S.

--

"Anthony Brown" <anthony@kermy.com> wrote in message
news:cv0gko$f07$1@forums.macromedia.com...

> The second option is what I used.
>
> I had a CF Page that recieves the IPN from Paypal and by extracting
> certain variables I use that to insert into 3 tables.
> Customer_tb
> Order_tb
> Orderdetails_tb
>
> Now, I use the Website payment preferences, and data transfer instead of
> IPN and it works better in my opinion.
>
> -Anthony

[Anthony Brown]

Yes, I use the PDT vars.

I think having to use the identity token to recieve payment details is more
secure than IPN.

I agree though that for the most part they seem the same when it comes to
backend operations.



"J.S. (UltraSuite)" <ultrasuite@nospam.com> wrote in message
news:cv0sg3$10v$1@forums.macromedia.com...

>> Now, I use the Website payment preferences, and data transfer instead of
>> IPN and it works better in my opinion.

>
> Do you mean that you use the PDT variables on the autoreturn page to
> insert the transaction values into your database? If so, why do you think
> it works better than IPN? I have tested both in combination and I am not
> sure what is the advantage of inserting the values into the database on
> that the autoreturn page.
>
> J.S.
>
> --
>
> "Anthony Brown" <anthony@kermy.com> wrote in message
> news:cv0gko$f07$1@forums.macromedia.com...

>> The second option is what I used.
>>
>> I had a CF Page that recieves the IPN from Paypal and by extracting
>> certain variables I use that to insert into 3 tables.
>> Customer_tb
>> Order_tb
>> Orderdetails_tb
>>
>> Now, I use the Website payment preferences, and data transfer instead of
>> IPN and it works better in my opinion.
>>
>> -Anthony

>
>

[J.S. \(UltraSuite\)]

"Anthony Brown" <anthony@kermy.com> wrote in message
news:cv1c5j$k3k$1@forums.macromedia.com...

> Yes, I use the PDT vars.
>
> I think having to use the identity token to recieve payment details is
> more secure than IPN.
>
> I agree though that for the most part they seem the same when it comes to
> backend operations.

Thanks for your response.

J.S.