' Shopping Cart - Cellar 360
Log In | Create Account
Username:
Password:
  Always Remember Me
      On This Computer
 

Forgot your username or password?
Click Here.

 

 |  Empty Cart

Shopping Cart

Qty Product Price Total
There are currently no products in your shopping cart.

 

Right Side Position 1
 

About Us  |   Privacy Policy  |   Terms and Conditions  |   Customer Care  |   Contact Us  |  
Copyright © 2017, Cellar360, Napa, CA., All Rights Reserved.
 
Query
Template: /share/production/deployment/vinsuite-production/cfcs/cartitems.cfc
Execution Time: 20.2 ms
Record Count: 0
Cached: No
Lazy: No
SQL:
SELECT
ci.CartItemID
,ci.ThirdPartySupplierID
,ci.ThirdPartyStoreID
,ci.WineryID
,ci.CartID
,ci.isWine
,ci.BottleCount
,ci.Quantity
,ci.ProductCategoryID
,ci.ProductTypeID
,ci.ProductPriceID
,ci.ProductID
,ci.ProductKeyID
,ci.ProductPriceKeyID
,ci.ProductName
,ci.ProductSKU
,ci.Description
,ci.OriginalPrice
,ci.Discount
,dbo.BankersRound(ci.Price,2) AS Price
,ci.OriginalShippingPrice
,ci.ShippingDiscount
,ci.ShippingPrice
,ci.isLowestCostShipping
,ci.DiscountOld
,ci.PriceUnits
,ci.Weight
,ci.WineTypeID
,ci.WineVintage
,ci.isCase
,ci.WineBottleSizeID
,wbs.winebottlesize
,ci.WineBrandID
,ci.WineVarietalID
,ci.WineAppellationID
,ci.ProductReportTypeID
,ci.ShipperID
,ci.ShippingSKU
,ci.DateAdded
,ci.DateModified
,ci.WishListQuantity
,ci.CustomizedPrice
,ci.TokenID
,ci.KitID
,(ci.Quantity*ci.OriginalPrice) as ExtendedOriginalPrice
,(ci.Quantity*dbo.BankersRound(ci.Price,2)) as ExtendedPrice
,(ci.Quantity*ci.OriginalShippingPrice) as ExtendedOriginalShippingPrice
,(ci.Quantity*ci.ShippingPrice) as ExtendedShippingPrice
,(ci.Quantity*ci.CustomizedPrice) as ExtendedCustomizedPrice
,case when ci.priceunits = 'Case(s)' then case when ci.quantity=0 then cast(0 as money) else case when ci.bottlecount=0 then cast(0 as money) else cast(dbo.BankersRound(ci.Price,2)/(ci.bottlecount * ci.quantity) as money) end end else cast(dbo.BankersRound(ci.Price,2) as money) end as UnitPrice
,isnull(ci.CustomizedPrice, dbo.BankersRound(ci.Price,2)) as RealPrice
,ci.RefundAmount
,ci.OriginalCartItemID
,p.photopath
,p.picture
,0 as EffectivePrice
,0 as ExtendedEffectivePrice
FROM CartItems ci
left join winebottlesizes wbs on ci.winebottlesizeid = wbs.winebottlesizeid
left join products p on p.productid = ci.productid
WHERE ci.CartID='E0D93AAF-63F4-42E2-8203-AA8A8FD2DBE0'
ORDER BY ci.DateAdded
  CartItemID ThirdPartySupplierID ThirdPartyStoreID WineryID CartID isWine BottleCount Quantity ProductCategoryID ProductTypeID ProductPriceID ProductID ProductKeyID ProductPriceKeyID ProductName ProductSKU Description OriginalPrice Discount Price OriginalShippingPrice ShippingDiscount ShippingPrice isLowestCostShipping DiscountOld PriceUnits Weight WineTypeID WineVintage isCase WineBottleSizeID winebottlesize WineBrandID WineVarietalID WineAppellationID ProductReportTypeID ShipperID ShippingSKU DateAdded DateModified WishListQuantity CustomizedPrice TokenID KitID ExtendedOriginalPrice ExtendedPrice ExtendedOriginalShippingPrice ExtendedShippingPrice ExtendedCustomizedPrice UnitPrice RealPrice RefundAmount OriginalCartItemID photopath picture EffectivePrice ExtendedEffectivePrice

Welcome to cellar360.com.

To view the Cellar 360 website you must be of legal drinking age within your country of residence. If no such laws exist in your country, you must be over 21 to visit our website.