2 for 1 support special - - sql and currency amnesia

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}}

Home

Product Discus...

SmithCart

2 for 1 support special - - sql and currency amnesia

4/23/2012 12:29 PM

marc harris

Joined: 12/5/2010

Posts: 7

2 for 1 support special - - sql and currency amnesia

hi kevin i hope.

i mailled a couple of weeks ago regarding difficulties with dynamically adjusting all order quatities as the cart version 4.52 i think is not implementing a -1 figure and i now have over 12000 products on . would take ...anyway its not happening...some help on sql commands would be ace..ta

http://www.4siteonline.co.uk

http://www.4siteonline.co.uk/Products...

if i create links to products to email they always bring up the right product but currency setting defaults back to dollars..iv experianced this on other versions before but this time is no where near as bad.

4/30/2012 1:45 PM

Joined: 1/1/0001

Posts: 0

Re: 2 for 1 support special - - sql and currency amnesia

Hello,

The following SQL statement should update all you products to -1
UPDATE Smith_Products SET MinOrderQty=-1

Regarding the currency issue you reported when using a the ProductID in a link to navigate to the Product Details page and the currency will be shown as $ instead of the selected currency, I was able to replicate this issue and have sent this into our programming dept. I will postback to this thread as soon as we can provide an update.

Thanks,

4/30/2012 11:33 PM

Dave Smith

Joined: 7/28/2009

Posts: 1452

Re: 2 for 1 support special - - sql and currency amnesia

This issue has been fixed and will be available in the next cart release v4.99 scheduled for release in the next couple days.

Thanks for your feedback!

At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce