HomeHome Product Discus... Product Discus...SmithCartSmithCartIssues with the cartIssues with the cart
Previous
 
Next
New Post
4/22/2010 11:42 AM
 

Hi,

I downloaded the trial edition of Smith Cart today, and while I was generally impressed with it (particularly its easy configuration and smooth DNN integration), I came across some issues, and wondered if anyone has solutions for them.

  1. If you select the Show Customer Reviews option in Settings, and click on a product detail link, you get the error message: "The stored procedure 'dbo.Smith_ListProductReview' doesn't exist." I guess the provider script in the package is out of date. (Fixed 02.82.00)
  2. if you try to check out an order with value zero, it is supposed to skip the payment step in the checkout, but doesn't, at least if you have PayPal Website Payments Standard configured as your Payment Gateway. PayPal doesn't allow you to check out a zero-valued transaction, so the order fails. This use case is effectively disabled because of this. (Fixed 02.82.00 + patch)
  3. if you check out a non-zero valued order, when you return from PayPal, the basket is not emptied as it probably should be to avoid repeat orders. (Fixed 02.82.00 + patch)
  4. if you are already logged in to DNN when you place an order, and the user doesn't already have a customer record, the customer that is created for the purchase is not linked with the logged in user. The DNNUserName field set of the customer is set to the email address, but no DNN account is created. Every time a purchase is made, a new customer account is created.
  5. No customers show up in the Manage Customers screen
  6. The Catalogue Show Options button (/DesktopModules/Smith.BuyNow/images/options.gif) is missing from the package

I'm keen to find out if there are solutions to the above as otherwise the module meets the requirements I'm currently working to.

Paul Taylor


Paul Taylor
Dotcom Software Solutions Ltd

DotNetNuke, ASP.NET and SQL Server Development
 
New Post
4/22/2010 1:40 PM
 

Customer reviews are a new feature in the cart just released. We will be releasing v2.82 of the cart by the end of the day that fixes all the issues reported including the one with customer reviews please send an email to skelly@smith-consulting.com so i can send you the latest version.


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
4/22/2010 3:04 PM
 

Great news, thanks.

By the way, another small thing I forgot to mention in my earlier post. In the case of digital products (ie. those which have a download file set), stock control doesn't really apply as they are never going to run out. However, the same rules currently apply as for physical products: if there are zero in hand, it refuses to sell you one, and in this scenario, it doesn't really make sense. It's easy enough to put the max stock in hand value against the product and add some more every now and then so that it never reaches zero, but it might be a small usability enhancement if you could just set stock in hand at zero and not have to worry about it for digital products.

Just a thought.


Paul Taylor
Dotcom Software Solutions Ltd

DotNetNuke, ASP.NET and SQL Server Development
 
New Post
4/22/2010 3:19 PM
 

I definitely agree and we already have on our dev list the ability to turn off the qty on hand feature at the product level.

Thanks for the great feedback!

-Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
4/23/2010 12:32 AM
 

Another question. I want to use PayPal Website Payments pro. What Url do I configure in the PayPal account as the IPN callback Url? I don't see any mention of it in the documentation. Does the cart send the notification Url to PayPal with the payment request?


Paul Taylor
Dotcom Software Solutions Ltd

DotNetNuke, ASP.NET and SQL Server Development
 
New Post
4/23/2010 2:10 AM
 
  • No order confirmation emails are received, neither at "store to" email address, nor customers. (Fixed 02.82.00 + patch)
  • In order management, select an order and click on Send Email button. You get error: "Column 'ProductSKU' does not belong to table Table." (Fixed 02.82.00)
  • In My Account, click on Invoice link for an order. You get error "Input string was not in a correct format." (Fixed 02.82.00)

Paul Taylor
Dotcom Software Solutions Ltd

DotNetNuke, ASP.NET and SQL Server Development
 
New Post
4/23/2010 2:28 AM
 

Tried installing the module in a shared hosting environment, and it crashes the site with "Cannot aquire required permissions" exception for FileHelper.dll.

If Full Trust is really needed for that dll, that rules out shared hosting environments, which is a show-stopper for many sites.


Paul Taylor
Dotcom Software Solutions Ltd

DotNetNuke, ASP.NET and SQL Server Development
 
New Post
4/23/2010 3:11 AM
 

What trust level are you running? We have many customers running the cart on shared hosting platforms so I know the cart runs on shared hosting. The filehelper.dll is used by the serial number management feature for importing csv files. It is possible that there is a conflict with the filehelper.dll on your system where there is another application besides the cart referencing an earlier version of the same fileHelper assembly dll.

The only feature in the cart that uses the filehelper is serial number management so if you arn't using serial number managment in the cart then you can remove that dll fro the zip file.


At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
4/23/2010 3:42 AM
 

Hi,

The server runs under medium trust. No other module in the site uses FileHelper.dll. I have also configured my local development PC using the same config file as the hosting provider (they gave me a copy for reference), and it reproduces the problem. I can also confirm there is no other copy of that DLL on my PC. If the serial number management module accesses directories outside of the web, that's likely why it is complaining. Medium trust limits you to within the web.

I'm not interested in the serial number feature for this present requirement, so the workaround you suggest sounds like it will work. Thanks.


Paul Taylor
Dotcom Software Solutions Ltd

DotNetNuke, ASP.NET and SQL Server Development
 
New Post
4/23/2010 9:51 AM
 

In regards to your question about PayPal Website Payments pro and the IPN callback, did you mean paypal standard? Because Paypal pro doesnt use ipn


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
4/23/2010 11:19 AM
 

Attached is a new dll for step 1 please copy the dll in the zip to your \bin folder it will fix the following 2 items you reported from your original post:

2. if you try to check out an order with value zero, it is supposed to skip the payment step in the checkout, but doesn't, at least if you have PayPal Website Payments Standard configured as your Payment Gateway. PayPal doesn't allow you to check out a zero-valued transaction, so the order fails. This use case is effectively disabled because of this.


3. if you check out a non-zero valued order, when you return from PayPal, the basket is not emptied as it probably should be to avoid repeat orders.


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
 Login to download attachment
New Post
4/24/2010 1:24 AM
 

Hi Scott,

Sorry, yes, I meant PayPal Standard.


Paul Taylor
Dotcom Software Solutions Ltd

DotNetNuke, ASP.NET and SQL Server Development
 
New Post
4/24/2010 2:04 AM
 

Attached is an updated step1 dll it will fix items 2-5 from your original post. Please copy the dll in the zip to your \bin folder


At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
 Login to download attachment
New Post
4/24/2010 2:44 AM
 

Hi Dave,

Thanks for the dll updates. I have applied them both and retested. Here's what I found:

if you try to check out an order with value zero, it is supposed to skip the payment step in the checkout, but doesn't, at least if you have PayPal Website Payments Standard configured as your Payment Gateway. PayPal doesn't allow you to check out a zero-valued transaction, so the order fails. This use case is effectively disabled because of this.

if you check out a non-zero valued order, when you return from PayPal, the basket is not emptied as it probably should be to avoid repeat orders.

Both of these scenarios now work correctly now except that the Back button on the Order Processed Confirmation page doesn't take you back to the shop, as I imagine it should. It just leaves you on the confirmation page with an empty order. In addition the order confirmation emails now get sent correctly.

Will retest the other items as soon as I can and will let you know.


Paul Taylor
Dotcom Software Solutions Ltd

DotNetNuke, ASP.NET and SQL Server Development
 
New Post
4/24/2010 3:04 AM
 

Hi Dave,

If you want to see the installation / configuration I'm testing, I have it on a staging server here: http://dotcom.lab.dotcomsoftwaresolutions.co.uk/en/Shop.aspx. You can check out in my PayPal sandbox using the following account:

PayPal email: noddy@noddyisp.co.uk

Password: noddypwd

Hope that helps


Paul Taylor
Dotcom Software Solutions Ltd

DotNetNuke, ASP.NET and SQL Server Development
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartIssues with the cartIssues with the cart