Please contact the admin and include the following SQL Code:
SELECT
P.vcSKU AS cartpid,
P.vcSKU AS pid,
P.vcSKU AS sku,
P.LIST_PR_AMT AS msrp,
IFNULL(P.decConsumerPriceOverride, CASE WHEN ( IFNULL(P.decConsumerPrice,0.00) <= 0.00 ) THEN P.LIST_PR_AMT ELSE P.decConsumerPrice END) AS price,
P.ITM_TXT AS name,
P.CAT_TXT AS description,
P.RTL_WGT_QTY AS weight,
P.vcUrl AS url,
P.UPS_IND AS ups,
P.intInStockQuantity AS stockquantity,
P.vcManufacturer AS manufacturer,
P.vcImageName AS image,
'/images/thumbnails/' AS imagedir,
C.intQuantity AS quantity,
P.decNumStars AS num_stars,
P.intNumCustomerReviews AS num_reviews,
0 AS alt_supplier,
P.enIsTaxFree AS taxfree,
P.enIsShippingFree AS shipfree,
P.enIsAlternateSupplier AS alt_supplier
FROM CART C, ITEM P
WHERE
C.vcSessionID ='54cfd93eed517c3e8ce7fe2eb27046f3'
AND C.vcProductCode = P.vcSKU
AND P.enIsActive = 'YES'
ORDER BY 1
