Saving the Cart? - SmithCart - Smith Consulting

Item		Qty	Total
	{{cartItem.ProductName}} SKU: {{cartItem.ProductSku}}	{{cartItem.Quantity \| number : 2}} x {{cartItem.UnitCost \| currency : '$' : 2}}	{{cartItem.UnitCost * cartItem.Quantity \| currency : '$' : 2}}
{{itemVariant.VariantHasText ? (itemVariant.VariantName + ': ' + itemVariant.VariantText) : (itemVariant.VariantGroup + ': ' + itemVariant.VariantName)}}
You have no items in your shopping cart.
Subtotal	{{minicart.cartTotals.SubTotal \| currency : '$' : 2}}

Item

Qty

Total

{{cartItem.ProductName}}
SKU: {{cartItem.ProductSku}}

{{cartItem.Quantity | number : 2}} x {{cartItem.UnitCost | currency : '$' : 2}}

{{itemVariant.VariantHasText ? (itemVariant.VariantName + ': ' + itemVariant.VariantText) : (itemVariant.VariantGroup + ': ' + itemVariant.VariantName)}}

You have no items in your shopping cart.

Subtotal

{{minicart.cartTotals.SubTotal | currency : '$' : 2}}

Image	Item	Qty	Total
	{{cartItem.ProductName}} SKU: {{cartItem.ProductSku}}	{{cartItem.Quantity \| number : 2}} x {{cartItem.UnitCost \| currency : '$' : 2}}	{{cartItem.UnitCost * cartItem.Quantity \| currency : '$' : 2}}
{{itemVariant.VariantHasText ? (itemVariant.VariantName + ': ' + itemVariant.VariantText) : (itemVariant.VariantGroup + ': ' + itemVariant.VariantName)}}
You have no items in your shopping cart.

Image

Item

Qty

Total

{{cartItem.ProductName}}
SKU: {{cartItem.ProductSku}}

{{cartItem.Quantity | number : 2}} x {{cartItem.UnitCost | currency : '$' : 2}}

{{itemVariant.VariantHasText ? (itemVariant.VariantName + ': ' + itemVariant.VariantText) : (itemVariant.VariantGroup + ': ' + itemVariant.VariantName)}}

You have no items in your shopping cart.

SKU

Product Name

Unit Cost

Qty

Line Total

{{itemVariant.VariantHasText ? (itemVariant.VariantName + ': ' + itemVariant.VariantText) : (itemVariant.VariantGroup + ': ' + itemVariant.VariantName)}}

You have no items in your saved shopping cart.

Status	Order No.	Order Date	Ship To	Order Total	Pay Total	Balance
Bill Me Later Open Ready To Ship Shipped Picked Up Cancelled Incomplete On Hold Back Ordered Returned {{order.Status}}	{{order.OrderID}}	{{order.OrderDate \| date : 'M/d/yyyy'}}	{{order.ShipFirstName}} {{order.ShipLastName}}, {{order.ShipAddress1}} {{order.ShipAddress2}}, {{order.ShipCity}}, {{order.ShipState}} {{order.ShipZipcode}}	{{order.GrandTotal \| currency : '$' : 2}}	{{order.PayTotal \| currency : '$' : 2}}	{{order.GrandTotal - order.PayTotal \| currency : '$' : 2}}

Status

Order No.

Order Date

Ship To

Order Total

Pay Total

Balance

Bill Me Later Open Ready To Ship Shipped Picked Up Cancelled Incomplete On Hold Back Ordered Returned {{order.Status}}

{{order.ShipFirstName}} {{order.ShipLastName}}, {{order.ShipAddress1}} {{order.ShipAddress2}}, {{order.ShipCity}}, {{order.ShipState}} {{order.ShipZipcode}}

10/28/2010 1:02 PM

Greg Baughman

Joined: 5/28/2010

Posts: 471

Saving the Cart?

Did I miss something in setting up the save cart feature (besides turning it on in the BuyNow setup)?

Clicking on "Save Cart" is throwing:

Error A critical error has occurred.
Invalid object name 'dnn_Smith_SavedCart'.

10/28/2010 1:54 PM

Scott Kelly

Joined: 3/11/2010

Posts: 1979

Re: Saving the Cart?

Does the table 'dnn_Smith_SavedCart' exist?

Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce

10/28/2010 2:00 PM

Greg Baughman

Joined: 5/28/2010

Posts: 471

Re: Saving the Cart?

No... the table dbo.Smith_SavedCart exists.... but not a table dnn_Smith_SavedCart

10/28/2010 2:36 PM

Scott Kelly

Joined: 3/11/2010

Posts: 1979

Re: Saving the Cart?

I checked the sql install scripts in the pa zip and it uses the objectqualifier variable so im not sure how you got the dnn_ maybe if you migrated the tables from another dnn portal that used the objectqualifer? To fix just remove the dnn_ and you should be fine.

-Scott

Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce

10/28/2010 2:53 PM

Greg Baughman

Joined: 5/28/2010

Posts: 471

Re: Saving the Cart?

I'm sorry.... I've had a really hard day... can you be specific on what I need to change?

10/28/2010 3:01 PM

Scott Kelly

Joined: 3/11/2010

Posts: 1979

Re: Saving the Cart?

just delete the "dnn_" in front of the table.

-Scott

Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce

10/28/2010 3:22 PM

Greg Baughman

Joined: 5/28/2010

Posts: 471

Re: Saving the Cart?

I don't have any table that says dnn_Smith_SavedCart.

I have a table that is called Smith_SavedCart

I am not sure what you're wanting me to change. I don't have the source code, and I don't think there's anything I can change in the ascx files.... I'm really not sure what I'm supposed to change here. Sorry to be dense, but it *seems* like an issue with the code-behind or something... unless there is somewhere else I should be looking?