VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 Add-ons for VP-ASP
 Paypal IPN - automatic order completion
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Happy
VP-ASP New User

90 Posts

Posted - September 04 2007 :  12:37:28  Show Profile  Reply with Quote
A customer not clicking the "Go back to Merchant" link on PayPal site is a big problem that all IPN users face. While VP-ASP have built a button in Admin to resolve this, it is not a full solution since it does not happen immediately and automatically.

I have modified the pages to have the confirmation email and stock adjustment to happen automatically, even when the member does not return to the site. The basic philosophy I have used is to trigger these events in paypalipncallback.asp rather than from shopthanks.asp.

I am happy to offer these changed files to anyone who is interested. Please download free from www.myfinestjewelry.com/ipn/ipn.zip. If you have a moment after than, just add a line in this thread as feedback.

Thanks,
Happy

nadeem
Starting Member

8 Posts

Posted - September 06 2007 :  14:02:37  Show Profile  Reply with Quote
Good Job. Since I use Basic Paypal interface, not sure if same thing can be implemented there? I wish that if customer does not click to return to merchant site, email is shoot to Customer and Merchant with special flag.

Thanks.
Go to Top of Page

Happy
VP-ASP New User

90 Posts

Posted - September 11 2007 :  20:15:55  Show Profile  Reply with Quote
Hi nadeem,

I do not think it will be possible with basic Paypal. This will work only with IPN.

Thanks,
Happy
Go to Top of Page

bohem
Starting Member

6 Posts

Posted - September 22 2007 :  06:49:32  Show Profile  Reply with Quote
Hi Happy.

Tried your link... Couldn't load. Can you please send the zip?
In advance, thanks
[email protected]
Go to Top of Page

goshen
VP-ASP New User

132 Posts

Posted - September 22 2007 :  22:14:47  Show Profile  Reply with Quote
Try:
www.myfinestjewelry.com/ipn/ipn.zip

the period behind the link is causing the page not to load.
Happy - Can you please share how you were able to achieve the pay by type dynamically? That how did you logically query the database to retrieve each type by category, stone, color, and price range. This is what I have been wanting to implement without hard coding the html.

Also I am interested in how you styled the table/box holding best sellers on the homepage with alternating colors.

By the way, your website design is 5 Star!
Go to Top of Page

Happy
VP-ASP New User

90 Posts

Posted - September 24 2007 :  18:41:52  Show Profile  Reply with Quote
Goshen,

Thanks for resolving Bohem's problem and for your kind words.

The Shop By Type drop lists are not generated dynamically - they are hard coded since the categories/ranges are rather static. Based on the selections one does in the drop downs, I then query the database to display the matching products.

The Best Sellers is done based on CSS styles. I alternate the class name for alternate table element, as below:

<!-- P1 start -->
<td class="content" valign="top" width="25%"><table class="sechdr" cellpadding="4" valign=top border=0 width=100%>
<tr>
<td align=center><A href=shopexd.asp?id=<%=p1(3)%>><img class="b1" width="110" width="110" src=images/thumbs/<%=p1(0) & ".gif"%> width="120" height="90" alt="<%=p1(2)%>"></a></td>
</tr>
<tr>
<td valign=top><h1 class="sp"><%=p1(2)%></h1><span id="greentext"><%=p1(1)%></span><br />
</td>
</tr>
</table></td>
<!-- P1 end -->
<!-- P2 starts -->
<td class="content" valign="top" width="25%"><table class="sechdr2" cellpadding="4" border=0 width=100%>
<tr>
<td align=center><A href=shopexd.asp?id=<%=p2(3)%>><img class="b1" width="110" src=images/thumbs/<%=p2(0) & ".gif"%> width="120" height="90" alt="<%=p2(2)%>"></a></td>
</tr>
<tr>
<td valign=top><h1 class="sp"><%=p2(2)%></h1><span id="greentext"><%=p2(1)%></span><br />
</td>
</tr>
</table></td>
<!-- P2 ends -->
<!-- P3 start -->
<td class="content" valign="top" width="25%"><table class="sechdr" cellpadding="4" border=0 width=100%>
<tr>
<td align=center><A href=shopexd.asp?id=<%=p3(3)%>><img class="b1" width="110" src=images/thumbs/<%=p3(0) & ".gif"%> width="120" height="90" alt="<%=p3(2)%>"></a></td>
</tr>
<tr>
<td valign=top><h1 class="sp"><%=p3(2)%></h1><span id="greentext"><%=p3(1)%></span><br />
</td>
</tr>
</table></td>
<!-- P3 ends -->

where p1(), p2() etc. are arrays (p1() for product 1) which I populate from the MySQL db.



Thanks,
Happy
Go to Top of Page

goshen
VP-ASP New User

132 Posts

Posted - September 24 2007 :  19:43:40  Show Profile  Reply with Quote
thanks..
Go to Top of Page

FolkDude
Starting Member

USA
10 Posts

Posted - August 25 2008 :  17:02:13  Show Profile  Visit FolkDude's Homepage  Reply with Quote
I found this solution to be a good one, except when selling downloadable goods. I had been including a secure hyperlink in the confirmation email, so obviously, it was a problem if the email didn't get sent.

Once I moved the logic to paypalipncallback.asp, though, I discovered that the secure hyperlinks were no longer included in the email. Apparently, it's a timing issue. The database doesn't yet know that the item has been paid for, so the link is not generated.

I'm working around the problem by ALSO including the hyperlink on the shopthanks.asp page, and including the following blurb at the bottom of the confirmation email:

***** IF YOU HAVE ORDERED DOWNLOADABLE GOODS (PDF files, MP3 files, etc.) *****

To download your product(s):

1. Log in to your account at [domain]/shopcustadminlogin.asp
2. Click "Review Previous Orders" (under "Orders")
3. Click on [orderid] in the "Order #" column
4. Click on the name of the product(s) at the top of the screen



FolkDude Creative Services - www.folkdude.com
Go to Top of Page

FolkDude
Starting Member

USA
10 Posts

Posted - November 20 2010 :  17:26:10  Show Profile  Visit FolkDude's Homepage  Reply with Quote
OK, so I've implemented this change on a few 6.5 carts, with much success (thanks again, Happy!) -- but now I'm working with my first installation of 7.0. This annoying "problem" still exists, and the VP-ASP code has evolved quite a bit. Has anyone been able to successfully move the appropriate code from shopthanks.asp to paypalipncallback.asp in version 7.0 yet?

FolkDude Creative Services - www.folkdude.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000