HomeHome Product Discus... Product Discus...SmithCartSmithCartUserUser's Shopping Cart Data
Previous
 
Next
New Post
3/11/2010 6:37 AM
 

Where are the items in a user's shopping cart stored? I assumed it would be the Smith_ShoppingCart table but when I add a product to the cart there doesn't seem to be a record of that product added to that table.

I want to add items to a user's shopping cart via a stored procedure on a button click in a custom module and then redirect them to the checkout page so they can enter their Credit Card information. Some of our products are service and it doesn't make sense to make them go through the first couple steps of the cart process.

Thanks

 
New Post
3/11/2010 2:11 PM
 

The Smith_ShoppingCart table is used internally in the cart code to temporarily store items that have been added to cart and its not recommended that you create your own stored procedure to add products to the Smith_ShoppingCart table as there are other session variables that are set by the cart that are required for checkout. If you want to add products directly to the cart then you can pass the product id int he querystring to the cart page. See the following forum post:

http://www.smith-consulting.com/forums/forumid/1/postid/219/scope/posts.aspx#219

Thanks,

Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
3/12/2010 9:42 AM
 

Thanks, is there any way to achieve this and skip to step one of the checkout? For these services, I don't want to land on the cart page because quantity isn't going to be a factor and if they increase that and then checkout, I'll have a mess on my hands.

I can't remove the quantity because we do have some products where that will be needed.

May plan was to redirect to /Cart/tabid/171/ctl/step1/mid/777/Default.aspx on the button click in my custom module and turn off the "< Back" button using javascript.

Thanks again

**UPDATE: Never mind, I was able to hide the buttons and columns I wanted using some javascript but I'm wondering if there's a way I can make sure the cart is empty and if it's not. can I empty it programmatically?**

 
New Post
3/12/2010 10:29 AM
 

Currently there is no way that you can empty the cart using an external javascript or stored procedure. The only way that you would be able to accomplish this would be to purchase the source code and make a custom modification. Please contact sales@smithcart.com to inquire about purchasing the cart source code.

Thanks,

Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
3/12/2010 11:16 AM
 

Thanks Scott but my client already paid quite a bit extra for the cart due to some custom modifications so I don't think spending more for the source code is in the cards.

 
New Post
3/12/2010 11:28 AM
 

I will need to check with the dev team to see if its possible I will reply when I have an answer.


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
3/31/2010 9:31 AM
 

Scott, I no longer need the ability to clear the cart on the fly so you can forget about trying to find that information for me but I have another issue. I have no idea how you're storing the shopping cart items but the items are appearing across different users.

e.g. If I start out with a completely empty cart, login as a user and add an item, if I don't complete the payment process, logout, and login as a different user, the item the first user added is in the second user's cart (as well as the first). I imagine it would be in the cart no matter what user I login as.

I'm not sure if this is how your cart always behave, if it's a result from the custom programming we paid for, or a defect in the ?productid= querystring way to add a product.

Thanks

 
New Post
3/31/2010 9:44 AM
 

Also, after adding an item using /tabid/171/ctl/Cart/mid/777/Default.aspx?productid=2, if I go to another page and then go back and view the cart by clicking the "View Cart" button without the productid in the querysting (i.e. /tabid/171/ctl/Cart/mid/777/Default.aspx) an additional product gets added to the cart the first time I do that.

This leads me to believe that session variables are not getting cleared properly not only at logout but also during the insertion of a product via the querystring (i.e. ?productid=2)

Thanks

 
New Post
4/1/2010 10:53 AM
 

I tested this on our test installs and was not able to replicate. I added a product to the cart using the querystring https://www.smith-consulting.com/buynow/ctl/cart/mid/480.aspx?productid=1 then clicked continue shopping then clicked view cart from the porduct list page and product detail page and I have only one item in my cart. Did you change the link on your view cart buttons or are you you clicking a link with an href that has teh product id in the querystring?


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
4/1/2010 1:15 PM
 

Scott, this seems to only happen in IE and this is the scenario that causes it for me

· Start with empty cart
· Pass in: /tabid/171/ctl/Cart/mid/777/Default.aspx?productid=1 (product is now in cart)
· Select the page with the cart from the DNN menu
· Click View Cart
· Second instance of the product IS added (even though the querystring is now /tabid/171/ctl/Cart/mid/777/Default.aspx)
 
New Post
4/1/2010 5:02 PM
 

What version of ie are you running? Could be a security setting in your ie.


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartUserUser's Shopping Cart Data