Downloadable Product Link

May 1, 2010 at 2:51 PM

HI Guys,

I am having some realy problems getting the downloadable product link working

using 2.0.11

I have inlcuded a Ebook product.

In my productdetailtemplate I included both the following

Download: [TAG:DOCPURCHASEDLINK][TAG:DOCPURCHASED]

Download: [TAG:DOCPURCHASEDLINK1][TAG:DOCPURCHASED1]

 

But still can see to get a downloadable link.

I have tested with multiple purchases. Clsoing the purchase, marking as paid.

 

I am besides myself. If there any one experincing the same problems.

Any suggestion urgently required.

 

Thanks

Robert

 

Coordinator
May 1, 2010 at 3:34 PM

Hi Robert.

The tag  [TAG:DOCPURCHASED1] should work??...if you use [TAG:DOC1], does that display?

I've just done a test on the demo websites and guess what ...it didn;t work??

I'm unsure why at the moment, but I'll make a note to have a look.

Non of the code releated to this has changesd recently, so we must be missing something somewhere?

Have you changed any status codes, because to check for a valid purchase it uses this SQL..

select Count(O.OrderID)
from NB_Store_Orders as O
inner join dbo.NB_Store_OrderDetails as OD on OD.OrderID = O.OrderID
inner join dbo.NB_Store_Model as M on M.ModelID = OD.ModelID
where userid = @UserID
and (O.OrderStatusID = 40 or O.OrderStatusID =  70)
and ProductID = @ProductID

 

Perhaps one thing you can try in order to find out if it is the order stauts is to remove the status check....

 

ALTER     PROCEDURE [dbo].[NEvoweb_NB_Store_Products_CheckPurchased]
@ProductID int,
@UserID int
AS
begin

select Count(O.OrderID)
from NB_Store_Orders as O
inner join dbo.NB_Store_OrderDetails as OD on OD.OrderID = O.OrderID
inner join dbo.NB_Store_Model as M on M.ModelID = OD.ModelID
where userid = @UserID
--and (O.OrderStatusID = 40 or O.OrderStatusID =  70)
and ProductID = @ProductID
 
end

 

Regards,

Dave.

 

May 1, 2010 at 4:13 PM

HI Lee,

Thanks for the reply.

The [TAG:DOC1] [TAG:DOCLINK1]DOCDESC1] work. But they display whether you’re logged in or not and whether you have purchased or not, and whether you’ve paid or not.

So don’t think it’s the one where looking for.

Really appreciate the help on this. I’m kinda desperate.

Thanks

Cheers

Robert

The Just Shall Live By Faith

For all your web needs

Integralwebsolutions

The Brave Programmer Blog

btn_viewmy_160x33[1]

From: leedavi [mailto:notifications@codeplex.com]
Sent: 01 May 2010 05:34 PM
To: robert@integralwebsolutions.co.za
Subject: Re: Downloadable Product Link [NBStore:211232]

From: leedavi

Hi Robert.

The tag [TAG:DOCPURCHASED1] should work??...if you use [TAG:DOC1], does that display?

I've just done a test on the demo websites and guess what ...it didn;t work??

I'm unsure why at the moment, but I'll make a note to have a look.

Non of the code releated to this has changesd recently, so we must be missing something somewhere?

Have you changed any status codes, because to check for a valid purchase it uses this SQL..

select Count(O.OrderID)
from NB_Store_Orders as O
inner join dbo.NB_Store_OrderDetails as OD on OD.OrderID = O.OrderID
inner join dbo.NB_Store_Model as M on M.ModelID = OD.ModelID
where userid = @UserID
and (O.OrderStatusID = 40 or O.OrderStatusID = 70)
and ProductID = @ProductID

Perhaps one thing you can try in order to find out if it is the order stauts is to remove the status check....

ALTER PROCEDURE [dbo].[NEvoweb_NB_Store_Products_CheckPurchased]
@ProductID int,
@UserID int
AS
begin

select Count(O.OrderID)
from NB_Store_Orders as O
inner join dbo.NB_Store_OrderDetails as OD on OD.OrderID = O.OrderID
inner join dbo.NB_Store_Model as M on M.ModelID = OD.ModelID
where userid = @UserID
--and (O.OrderStatusID = 40 or O.OrderStatusID = 70)
and ProductID = @ProductID

end

Regards,

Dave.

Read the full discussion online.

To add a post to this discussion, reply to this email (NBStore@discussions.codeplex.com)

To start a new discussion for this project, email NBStore@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe on CodePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at CodePlex.com

May 1, 2010 at 4:37 PM

Hi Lee,

Sorry forgot to answer:

As I understood the download link should only display when the order status is changed to Payment OK or Closed. I tried both to no avail.

The orderstatusID for these Two are 40 and 70. Which to me should work.

On the SQL Query I get a count of two rows. Which is correct.

As in:

select Count(O.OrderID)

from NB_Store_Orders as O

inner join dbo.NB_Store_OrderDetails as OD on OD.OrderID = O.OrderID

inner join dbo.NB_Store_Model as M on M.ModelID = OD.ModelID

where userid = 88

and (O.OrderStatusID = 40 or O.OrderStatusID =  70)

and ProductID = 2

Changing the SP made no change. Purchase Download link still not available.

Cheers

Robert

The Just Shall Live By Faith

For all your web needs

Integralwebsolutions

The Brave Programmer Blog

btn_viewmy_160x33[1]

From: leedavi [mailto:notifications@codeplex.com]
Sent: 01 May 2010 05:34 PM
To: robert@integralwebsolutions.co.za
Subject: Re: Downloadable Product Link [NBStore:211232]

From: leedavi

Hi Robert.

The tag [TAG:DOCPURCHASED1] should work??...if you use [TAG:DOC1], does that display?

I've just done a test on the demo websites and guess what ...it didn;t work??

I'm unsure why at the moment, but I'll make a note to have a look.

Non of the code releated to this has changesd recently, so we must be missing something somewhere?

Have you changed any status codes, because to check for a valid purchase it uses this SQL..

select Count(O.OrderID)
from NB_Store_Orders as O
inner join dbo.NB_Store_OrderDetails as OD on OD.OrderID = O.OrderID
inner join dbo.NB_Store_Model as M on M.ModelID = OD.ModelID
where userid = @UserID
and (O.OrderStatusID = 40 or O.OrderStatusID = 70)
and ProductID = @ProductID

Perhaps one thing you can try in order to find out if it is the order stauts is to remove the status check....

ALTER PROCEDURE [dbo].[NEvoweb_NB_Store_Products_CheckPurchased]
@ProductID int,
@UserID int
AS
begin

select Count(O.OrderID)
from NB_Store_Orders as O
inner join dbo.NB_Store_OrderDetails as OD on OD.OrderID = O.OrderID
inner join dbo.NB_Store_Model as M on M.ModelID = OD.ModelID
where userid = @UserID
--and (O.OrderStatusID = 40 or O.OrderStatusID = 70)
and ProductID = @ProductID

end

Regards,

Dave.

Read the full discussion online.

To add a post to this discussion, reply to this email (NBStore@discussions.codeplex.com)

To start a new discussion for this project, email NBStore@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe on CodePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at CodePlex.com

Editor
May 1, 2010 at 8:21 PM
Edited May 1, 2010 at 8:43 PM

Hi Robert and Dave

I have just been checking this issue out as we had indended to implement software downloads shortly.

Here is my discovery:

SQL procedure NEvoweb_NB_Store_Products_CheckPurchased - Works Correctly.

However, I could not get the documents download to display after going through the sale process and completing payment when I used [TAG:DOCPURCHASED1].

Then I did a search of the NB_Store source code looking for TAG:DCOPURCHASED and could not find this tag mentioned in source, but did find TAG:DOCPURCHASEDLINK.

I changed my ProductDetails template from [TAG:DOCPURCHASED1]  to [TAG:DOCPURCHASEDLINK1] and it all worked as expected with a download link [description only, no icon], however, when looking at the customer order I do not see any link to download when the order status is PaymentOK or CLOSED.

Using Version 2.0.11

ProductTemplate.vb appears to be only testing for TAG:DOCPURCHASEDLINK ...

If _aryTempl(lp).ToUpper.StartsWith("TAG:DOCLINK") Or _aryTempl(lp).StartsWith("TAG:DOCPURCHASEDLINK") Then

Robert

You did mention that you had both TAG:DOCPURCHASED and TAG:DOCPURCHASEDLINK in your product details template.

TAG:DOCPURCHASED just does not work for me.

The only way I could replicate your issue was if the document did not have a description, in this case the link to download the document will not show.

I hope this all makes sense at 5:50 am, and it helps diagnose the issue

Craig

 

 

May 2, 2010 at 6:35 AM

Thanks for the reply.

Yes the SP works correctly.

I replaced the productdetails template tag with [TAG:DOCPURCHASEDLINK1] and it seemed to work correctly

I’m going to try and add an extra link for an extra document and add the tag [TAG:DOCPURCHASEDLINK2]. Hopefully that will add the second document. I will let you guys know.

I don’t see any reason why this should not work.

Thanks for the effort Guys,

Much appreciated.

Robert

The Just Shall Live By Faith

For all your web needs

Integralwebsolutions

The Brave Programmer Blog

btn_viewmy_160x33[1]

From: technica [mailto:notifications@codeplex.com]
Sent: 01 May 2010 10:22 PM
To: robert@integralwebsolutions.co.za
Subject: Re: Downloadable Product Link [NBStore:211232]

From: technica

Hi Robert and Dave

I have just been checking this issue our as we had indended to implement software downloads shortly.

Here is my discovery:

SQL procedure NEvoweb_NB_Store_Products_CheckPurchased - Works Correctly.

However, I could not get the documents download to display after going through the sale process and completing payment when I used [TAG:DOCPURCHASED1].

Then I did a search of the NB_Store source code looking for TAG:DCOPURCHASED and could not find this tag mentioned in source, but did find TAG:DOCPURCHASEDLINK.

I changed my ProductDetails template from [TAG:DOCPURCHASED1] to [TAG:DOCPURCHASEDLINK1] and it all worked as expected.

Using Version 2.0.11

ProductTemplate.vb appears to be only testing for TAG:DOCPURCHASEDLINK<font size="2">

</font>If _aryTempl(lp).ToUpper.StartsWith("TAG:DOCLINK") Or _aryTempl(lp).StartsWith("TAG:DOCPURCHASEDLINK") Then

Robert

You did mention that you had both TAG:DOCPURCHASED and TAG:DOCPURCHASEDLINK in your product details template.

TAG:DOCPURCHASED just does not work for me.

The only way I could replicate your issue was if the document did not have a description, in this case the link to download the document will not show.

I hope this all makes sense at 5:50 am, and it helps diagnose the issue

Craig

Read the full discussion online.

To add a post to this discussion, reply to this email (NBStore@discussions.codeplex.com)

To start a new discussion for this project, email NBStore@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe on CodePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at CodePlex.com

Coordinator
May 2, 2010 at 8:38 AM

OK, Thx for all the feedback.  It looks like there is some kind of issue here, I've not got the time to look at it immediatly, but I will create a work item and get a solution out for the next release. (Hopefully the next beta will be released within the next couple of weeks)

Regards,

Dave.

Coordinator
May 2, 2010 at 8:39 AM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.
May 19, 2010 at 10:13 AM

Since the [Tag:DOCPURCHASEDLINK1] is working I changed the description of the document to include a reference to the download image as a workaround.

"<img src="/Portals/1/Pictures/disk.png" border="0"> Description of software product "

Then both the download picture and the description is shown.

This works in version 2.0.11

Now waiting for a next release of this great product.

 

May 20, 2010 at 3:46 AM

Ran into this issue today... glad it was already discovered ;-)

Now... about links to the product detail page being included in the email sent to the customer... I don't see this working at all.  I ran across one item that said it had to be "enabled", but I've not seen anything to enable it.

Anyone have this working?  Can you give me a clue?

Thanks!

Steve

Coordinator
May 20, 2010 at 7:12 AM

Use the "productlinksoncart.flag" detting...you can find a list of settings in the documentation.html that's installed with NB_Store.

Regards.

Dave.

May 20, 2010 at 10:08 AM

Hi,

I have still promblems with the Download Product.

I guess I did something wrong, but I do not know what. Where comes the data to the TAG?

Here are my Questions:

[TAG:DOCPURCHASEDLINK]

1. Is this the right way for implementing a Download Link?

I placed the TAG into the description of the Product and the TAG will be display always without any replacement.

I add a entry under settings with the name DOCPURCHASEDLINK.

 

2. How can I implement a downloadlink when I will use the Store Anonymous payment option –DNN registration not required

Please in detail.

 

Can anybody give me an idea how can I setup the system?

Thanks!

Guido

May 20, 2010 at 10:30 AM

@Dave

I  added the productlinksoncart.flag to the Utilities->settings list and set the value to "True".
But still no productlinks in the cart.
Can I use the verbs "False" and "True for this setting or do I have to use "0" and "1" ?

@GreenGrass
Use [TAG:DOCPURCHASEDLINK1] to indicate the first document attached to your product.
You do not need to add  the setting DOCPURCHASEDLINK.  It's a TAG not a setting.
Add the TAG to the productlist.template and productdetail.template will do the trick.

Regards,

Arie 

Coordinator
May 20, 2010 at 12:13 PM
advandalen wrote:

I  added the productlinksoncart.flag to the Utilities->settings list and set the value to "True".
But still no productlinks in the cart.
Can I use the verbs "False" and "True for this setting or do I have to use "0" and "1" ?

That's always confusing. I've been using 1 and 0 for that setting and it's working. Give it a shot.

Rob

May 20, 2010 at 2:12 PM

soory Arie,

but I don't get it working.

I use the shop with an Anonymous payment. Could this be a reason.

Can I do the [TAG:DOCPURCHASEDLINK1] into the Payment email and where sould it be placed ?

Thanks!

Guido

 

May 20, 2010 at 2:25 PM
Edited May 20, 2010 at 2:31 PM

@robax

Product links are only shown after payment.
Only visible in the order history.

Links are not available in the current cart before payment

@GreenGrass
This thread (at the end) tells me it is not available for anonymous purchases

http://nbstore.codeplex.com/Thread/View.aspx?ThreadId=82552

Coordinator
May 20, 2010 at 3:10 PM

Just to confirm...

- The links to the products are only in the order history and the email that is sent to the client.

- anonymous purchases can;t use  the download links option, because the store doesn;t know if the user has purchased the product or not....the store simply does not know who purchased anything when anonymous purchases are allowed, therefore it can;t make a download availble to the user!

Regards,

Dave.

May 21, 2010 at 4:53 PM
leedavi wrote:

Use the "productlinksoncart.flag" detting...you can find a list of settings in the documentation.html that's installed with NB_Store.

Regards.

Dave.

Dave - THANKS!  That did get the link to show up.  Guess I hadn't 'parsed' that info from the doc.  I greatly appreciate the speedy reply!

 

Steve

May 22, 2010 at 10:00 AM

Thanks Dave,

the Downloadlink works now as expected.

I appreciate your assistence and the fast reply.

Thanks

Guido