Wordpress ecommerce plugin problem

samsonthomas · 09-09-2009, 06:42 AM

Hi I am trying to add a digital audio product on my wordpress site. I found the ecommerce plugin which I installed. I made a test purchase and went through with the payment through paypal successfully but only problem is that paypal did not redirect to my site for the download after the payment.

Couldn't get much help on the forums of the plugin. Hope to get it here. I went to the documentation site of the plugin and here's what I found.

Product Download

f you are selling a digital product, here is where you upload the associated file. Note: Some web hosts will time out and appear to crash when you try to upload large files. If this happens you can upload files to wp-content/uploads/wpsc/downloadables using your FTP client and then associate them manually. If you are uploading a file via FTP you can get it to work with the shop module. Here we go:

Upload the file via FTP and copy the name of the file
Then go to {url replaced} and create a hash code out of that filename and note/copy the MD5 code after generating
Go to your server’s database and create a new item in wp_product_files (id, filename, mimetype and idhash, date doesn’t matter)
In your FTP program choose the file and rename it with the generated MD5 hash code
If you have done everything right and refresh the product page in WP e-Commerce you should see the exact filename
Now you can choose it and offer it as downloadable file

Now, I can understand everything in that guide, except the step marked in red. What is he saying? Do I need to create a new SQL database on the server? And I cannot find anything called wp_product_files?

Can anyone here help me on this? Thanks very much.

john_kennedy · 09-09-2009, 06:54 AM

No, the table should have been created when you installed the plugin. Go into your hosting companies control panel and find a link to phpmyadmin. Then, find our database if you have more than one and finally select the table wp_product_files. Click on the pencil icon to edit the table and add your product as instructed. Save and you should be good to go.

Also, do you have IPN turned on in PayPal? If not, you will need to activate that as well. It is under Profile/Instant Payment Notification Preferences. Turn it on and insert your websites URL in the box. It doesn't matter what you put there as the plugin will send its own return URL.

John

samsonthomas · 09-11-2009, 02:19 AM

Hey John,

Thanks for your help. that was quick.

I did what you said. I edited the table, turned the IPN on but still Paypal doesn't redirect to my website again for the download.

What am I missing?

Thanks once again for your help.

john_kennedy · 09-11-2009, 05:46 AM

OK, one other thing to check. Make certain the Auto Return is activated in PayPal. Is is in Profiles/Website Payment Preferences.

PM me the plugin name so I can take a look. If you can't get this one to work, I know of another one that will work and isn't so complicated.

John

samsonthomas · 09-17-2009, 02:55 AM

Hi John
I turned the auto return on. But its asking for return url. What should be the return URL in this case? Does it matter if I put the URL of my homepage?

I think the plugin should be sending the return url in any case.

samsonthomas · 10-05-2009, 01:35 AM

Hi John

I sent you a PM. can you please help me on this.

DynamicRevelation · 10-12-2009, 05:57 AM

Your return url should point simply to the download page or the file itself...

yourdomain.com/downloadfolder/product.pdf oryourdomain.com/downloadpage/

09-09-2009, 06:42 AM	#1
samsonthomas Home Biz Mentor Join Date: May 2009 Posts: 45 Thanks: 1 Thanked 2 Times in 2 Posts Social Networking	Wordpress ecommerce plugin problem Hi I am trying to add a digital audio product on my wordpress site. I found the ecommerce plugin which I installed. I made a test purchase and went through with the payment through paypal successfully but only problem is that paypal did not redirect to my site for the download after the payment. Couldn't get much help on the forums of the plugin. Hope to get it here. I went to the documentation site of the plugin and here's what I found. Product Download f you are selling a digital product, here is where you upload the associated file. Note: Some web hosts will time out and appear to crash when you try to upload large files. If this happens you can upload files to wp-content/uploads/wpsc/downloadables using your FTP client and then associate them manually. If you are uploading a file via FTP you can get it to work with the shop module. Here we go: Upload the file via FTP and copy the name of the file Then go to {url replaced} and create a hash code out of that filename and note/copy the MD5 code after generating Go to your server’s database and create a new item in wp_product_files (id, filename, mimetype and idhash, date doesn’t matter) In your FTP program choose the file and rename it with the generated MD5 hash code If you have done everything right and refresh the product page in WP e-Commerce you should see the exact filename Now you can choose it and offer it as downloadable file Now, I can understand everything in that guide, except the step marked in red. What is he saying? Do I need to create a new SQL database on the server? And I cannot find anything called wp_product_files? Can anyone here help me on this? Thanks very much.
	Download The Best Home Biz Startup Guide - Free - Get your hands on the most comprehensive 151 page online home business startup guide now for Free. Get Automatic Unique Content For Your Blog - Free - Tutorials to launch niche money-making blogs, Free Software and prizes worth $4174.20 including cash - Limited Time Offer

09-09-2009, 06:54 AM	#2
john_kennedy HyperActive Warrior War Room Member Join Date: Dec 2002 Location: Mobile, AL , USA. Posts: 302 Thanks: 75 Thanked 49 Times in 44 Posts Social Networking Contact Info	Re: Wordpress ecommerce plugin problem No, the table should have been created when you installed the plugin. Go into your hosting companies control panel and find a link to phpmyadmin. Then, find our database if you have more than one and finally select the table wp_product_files. Click on the pencil icon to edit the table and add your product as instructed. Save and you should be good to go. Also, do you have IPN turned on in PayPal? If not, you will need to activate that as well. It is under Profile/Instant Payment Notification Preferences. Turn it on and insert your websites URL in the box. It doesn't matter what you put there as the plugin will send its own return URL. John

09-11-2009, 02:19 AM	#3
samsonthomas Home Biz Mentor Join Date: May 2009 Posts: 45 Thanks: 1 Thanked 2 Times in 2 Posts Social Networking	Re: Wordpress ecommerce plugin problem Hey John, Thanks for your help. that was quick. I did what you said. I edited the table, turned the IPN on but still Paypal doesn't redirect to my website again for the download. What am I missing? Thanks once again for your help.
	Download The Best Home Biz Startup Guide - Free - Get your hands on the most comprehensive 151 page online home business startup guide now for Free. Get Automatic Unique Content For Your Blog - Free - Tutorials to launch niche money-making blogs, Free Software and prizes worth $4174.20 including cash - Limited Time Offer

09-11-2009, 05:46 AM	#4
john_kennedy HyperActive Warrior War Room Member Join Date: Dec 2002 Location: Mobile, AL , USA. Posts: 302 Thanks: 75 Thanked 49 Times in 44 Posts Social Networking Contact Info	Re: Wordpress ecommerce plugin problem OK, one other thing to check. Make certain the Auto Return is activated in PayPal. Is is in Profiles/Website Payment Preferences. PM me the plugin name so I can take a look. If you can't get this one to work, I know of another one that will work and isn't so complicated. John

09-17-2009, 02:55 AM	#5
samsonthomas Home Biz Mentor Join Date: May 2009 Posts: 45 Thanks: 1 Thanked 2 Times in 2 Posts Social Networking	Re: Wordpress ecommerce plugin problem Hi John I turned the auto return on. But its asking for return url. What should be the return URL in this case? Does it matter if I put the URL of my homepage? I think the plugin should be sending the return url in any case.
	Download The Best Home Biz Startup Guide - Free - Get your hands on the most comprehensive 151 page online home business startup guide now for Free. Get Automatic Unique Content For Your Blog - Free - Tutorials to launch niche money-making blogs, Free Software and prizes worth $4174.20 including cash - Limited Time Offer

10-05-2009, 01:35 AM	#6
samsonthomas Home Biz Mentor Join Date: May 2009 Posts: 45 Thanks: 1 Thanked 2 Times in 2 Posts Social Networking	Re: Wordpress ecommerce plugin problem Hi John I sent you a PM. can you please help me on this.
	Download The Best Home Biz Startup Guide - Free - Get your hands on the most comprehensive 151 page online home business startup guide now for Free. Get Automatic Unique Content For Your Blog - Free - Tutorials to launch niche money-making blogs, Free Software and prizes worth $4174.20 including cash - Limited Time Offer

10-12-2009, 05:57 AM	#7
DynamicRevelation Battle-Axe War Room Member Join Date: Oct 2008 Location: Colorado Springs Posts: 43 Blog Entries: 2 Thanks: 19 Thanked 3 Times in 3 Posts Social Networking Contact Info	Re: Wordpress ecommerce plugin problem Your return url should point simply to the download page or the file itself... yourdomain.com/downloadfolder/product.pdf oryourdomain.com/downloadpage/
	Internet Strategic Marketing Plan Internet Business Marketing Plan & Market Online Business Startup Plan *DynamicRevelation.com*