*/ /* Temporary fix until GH sorts out the WebStory input in HQM */ $WebStory = str_replace( array( '","', '",,"', '",', ',"' ), "", $WebStory );
$product = "CAVENDISH"
$ads = AdsSource
AdsSource::$startQuote = "["
AdsSource::$endQuote = "]"
AdsSource::$connected = false
AdsSource::$fullDebug = false
AdsSource::$error = NULL
AdsSource::$affected = NULL
AdsSource::$numRows = NULL
AdsSource::$took = NULL
AdsSource::$_result = NULL
AdsSource::$_queriesCnt = 0
AdsSource::$_queriesTime = NULL
AdsSource::$_queriesLog = array
AdsSource::$_queriesLogMax = 200
AdsSource::$_queryCache = array
AdsSource::$_baseConfig = array
AdsSource::$__descriptions = array
AdsSource::$_sources = NULL
AdsSource::$connection = resource
AdsSource::$config = array
AdsSource::$configKeyName = "ads"
AdsSource::$_transactionStarted = false
AdsSource::$cacheSources = true
$query = "
SELECT
loo.Category,
WebStory,
lup.WebInfo,
LCASE(Product) AS title,
RetailPrice AS price,
NextPrice AS wasPrice,
QuickStock AS quickstock,
NextPriceChange,
IIF( ( NextPrice > 0 AND NextPrice > RetailPrice AND TIMESTAMPDIFF( SQL_TSI_DAY, NextPriceChange, CURRENT_DATE() ) < 150 ), true, false ) AS discountLive
FROM PRODUCTLOOKUP lup
-- next line should be a JOIN not a LEFT JOIN
JOIN PRODUCTLOOK loo ON loo.Cat_No = lup.ReferenceItem
WHERE
NAME = 'CAVENDISH'
AND
loo.Discontinued IS NULL
AND loo.WebDefault = True"
$prod = array()
ProductDetail::fetchProductDetail() - APP/models/product_detail.php, line 48
ProductsController::index() - APP/controllers/products_controller.php, line 43
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
Notice (8): Undefined variable: WebInfo [APP/models/product_detail.php, line 52]
$product = "CAVENDISH"
$ads = AdsSource
AdsSource::$startQuote = "["
AdsSource::$endQuote = "]"
AdsSource::$connected = false
AdsSource::$fullDebug = false
AdsSource::$error = NULL
AdsSource::$affected = NULL
AdsSource::$numRows = NULL
AdsSource::$took = NULL
AdsSource::$_result = NULL
AdsSource::$_queriesCnt = 0
AdsSource::$_queriesTime = NULL
AdsSource::$_queriesLog = array
AdsSource::$_queriesLogMax = 200
AdsSource::$_queryCache = array
AdsSource::$_baseConfig = array
AdsSource::$__descriptions = array
AdsSource::$_sources = NULL
AdsSource::$connection = resource
AdsSource::$config = array
AdsSource::$configKeyName = "ads"
AdsSource::$_transactionStarted = false
AdsSource::$cacheSources = true
$query = "
SELECT
loo.Category,
WebStory,
lup.WebInfo,
LCASE(Product) AS title,
RetailPrice AS price,
NextPrice AS wasPrice,
QuickStock AS quickstock,
NextPriceChange,
IIF( ( NextPrice > 0 AND NextPrice > RetailPrice AND TIMESTAMPDIFF( SQL_TSI_DAY, NextPriceChange, CURRENT_DATE() ) < 150 ), true, false ) AS discountLive
FROM PRODUCTLOOKUP lup
-- next line should be a JOIN not a LEFT JOIN
JOIN PRODUCTLOOK loo ON loo.Cat_No = lup.ReferenceItem
WHERE
NAME = 'CAVENDISH'
AND
loo.Discontinued IS NULL
AND loo.WebDefault = True"
$prod = array(
"WebStory" => ""
)
$WebStory = ""
ProductDetail::fetchProductDetail() - APP/models/product_detail.php, line 52
ProductsController::index() - APP/controllers/products_controller.php, line 43
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
Notice (8): Undefined variable: discountLive [APP/models/product_detail.php, line 53]
$product = "CAVENDISH"
$ads = AdsSource
AdsSource::$startQuote = "["
AdsSource::$endQuote = "]"
AdsSource::$connected = false
AdsSource::$fullDebug = false
AdsSource::$error = NULL
AdsSource::$affected = NULL
AdsSource::$numRows = NULL
AdsSource::$took = NULL
AdsSource::$_result = NULL
AdsSource::$_queriesCnt = 0
AdsSource::$_queriesTime = NULL
AdsSource::$_queriesLog = array
AdsSource::$_queriesLogMax = 200
AdsSource::$_queryCache = array
AdsSource::$_baseConfig = array
AdsSource::$__descriptions = array
AdsSource::$_sources = NULL
AdsSource::$connection = resource
AdsSource::$config = array
AdsSource::$configKeyName = "ads"
AdsSource::$_transactionStarted = false
AdsSource::$cacheSources = true
$query = "
SELECT
loo.Category,
WebStory,
lup.WebInfo,
LCASE(Product) AS title,
RetailPrice AS price,
NextPrice AS wasPrice,
QuickStock AS quickstock,
NextPriceChange,
IIF( ( NextPrice > 0 AND NextPrice > RetailPrice AND TIMESTAMPDIFF( SQL_TSI_DAY, NextPriceChange, CURRENT_DATE() ) < 150 ), true, false ) AS discountLive
FROM PRODUCTLOOKUP lup
-- next line should be a JOIN not a LEFT JOIN
JOIN PRODUCTLOOK loo ON loo.Cat_No = lup.ReferenceItem
WHERE
NAME = 'CAVENDISH'
AND
loo.Discontinued IS NULL
AND loo.WebDefault = True"
$prod = array(
"WebStory" => "",
"WebInfo" => "<p></p>"
)
$WebStory = ""
ProductDetail::fetchProductDetail() - APP/models/product_detail.php, line 53
ProductsController::index() - APP/controllers/products_controller.php, line 43
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
Notice (8): Undefined variable: quickstock [APP/models/product_detail.php, line 57]
$product = "CAVENDISH"
$ads = AdsSource
AdsSource::$startQuote = "["
AdsSource::$endQuote = "]"
AdsSource::$connected = false
AdsSource::$fullDebug = false
AdsSource::$error = NULL
AdsSource::$affected = NULL
AdsSource::$numRows = NULL
AdsSource::$took = NULL
AdsSource::$_result = NULL
AdsSource::$_queriesCnt = 0
AdsSource::$_queriesTime = NULL
AdsSource::$_queriesLog = array
AdsSource::$_queriesLogMax = 200
AdsSource::$_queryCache = array
AdsSource::$_baseConfig = array
AdsSource::$__descriptions = array
AdsSource::$_sources = NULL
AdsSource::$connection = resource
AdsSource::$config = array
AdsSource::$configKeyName = "ads"
AdsSource::$_transactionStarted = false
AdsSource::$cacheSources = true
$query = "
SELECT
loo.Category,
WebStory,
lup.WebInfo,
LCASE(Product) AS title,
RetailPrice AS price,
NextPrice AS wasPrice,
QuickStock AS quickstock,
NextPriceChange,
IIF( ( NextPrice > 0 AND NextPrice > RetailPrice AND TIMESTAMPDIFF( SQL_TSI_DAY, NextPriceChange, CURRENT_DATE() ) < 150 ), true, false ) AS discountLive
FROM PRODUCTLOOKUP lup
-- next line should be a JOIN not a LEFT JOIN
JOIN PRODUCTLOOK loo ON loo.Cat_No = lup.ReferenceItem
WHERE
NAME = 'CAVENDISH'
AND
loo.Discontinued IS NULL
AND loo.WebDefault = True"
$prod = array(
"WebStory" => "",
"WebInfo" => "<p></p>"
)
$WebStory = ""
ProductDetail::fetchProductDetail() - APP/models/product_detail.php, line 57
ProductsController::index() - APP/controllers/products_controller.php, line 43
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
Notice (8): Undefined variable: title [APP/models/product_detail.php, line 66]
$product = "CAVENDISH"
$ads = AdsSource
AdsSource::$startQuote = "["
AdsSource::$endQuote = "]"
AdsSource::$connected = false
AdsSource::$fullDebug = false
AdsSource::$error = NULL
AdsSource::$affected = NULL
AdsSource::$numRows = NULL
AdsSource::$took = NULL
AdsSource::$_result = NULL
AdsSource::$_queriesCnt = 0
AdsSource::$_queriesTime = NULL
AdsSource::$_queriesLog = array
AdsSource::$_queriesLogMax = 200
AdsSource::$_queryCache = array
AdsSource::$_baseConfig = array
AdsSource::$__descriptions = array
AdsSource::$_sources = NULL
AdsSource::$connection = resource
AdsSource::$config = array
AdsSource::$configKeyName = "ads"
AdsSource::$_transactionStarted = false
AdsSource::$cacheSources = true
$query = "
SELECT
loo.Category,
WebStory,
lup.WebInfo,
LCASE(Product) AS title,
RetailPrice AS price,
NextPrice AS wasPrice,
QuickStock AS quickstock,
NextPriceChange,
IIF( ( NextPrice > 0 AND NextPrice > RetailPrice AND TIMESTAMPDIFF( SQL_TSI_DAY, NextPriceChange, CURRENT_DATE() ) < 150 ), true, false ) AS discountLive
FROM PRODUCTLOOKUP lup
-- next line should be a JOIN not a LEFT JOIN
JOIN PRODUCTLOOK loo ON loo.Cat_No = lup.ReferenceItem
WHERE
NAME = 'CAVENDISH'
AND
loo.Discontinued IS NULL
AND loo.WebDefault = True"
$prod = array(
"WebStory" => "",
"WebInfo" => "<p></p>",
"toutImage" => "lpg-graphic.gif",
"toutAlt" => "Lowest Price Guaranteed"
)
$WebStory = ""
ProductDetail::fetchProductDetail() - APP/models/product_detail.php, line 66
ProductsController::index() - APP/controllers/products_controller.php, line 43
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
Notice (8): Undefined variable: Category [APP/models/product_detail.php, line 68]
$product = "CAVENDISH"
$ads = AdsSource
AdsSource::$startQuote = "["
AdsSource::$endQuote = "]"
AdsSource::$connected = false
AdsSource::$fullDebug = false
AdsSource::$error = NULL
AdsSource::$affected = NULL
AdsSource::$numRows = NULL
AdsSource::$took = NULL
AdsSource::$_result = NULL
AdsSource::$_queriesCnt = 0
AdsSource::$_queriesTime = NULL
AdsSource::$_queriesLog = array
AdsSource::$_queriesLogMax = 200
AdsSource::$_queryCache = array
AdsSource::$_baseConfig = array
AdsSource::$__descriptions = array
AdsSource::$_sources = NULL
AdsSource::$connection = resource
AdsSource::$config = array
AdsSource::$configKeyName = "ads"
AdsSource::$_transactionStarted = false
AdsSource::$cacheSources = true
$query = "
SELECT
loo.Category,
WebStory,
lup.WebInfo,
LCASE(Product) AS title,
RetailPrice AS price,
NextPrice AS wasPrice,
QuickStock AS quickstock,
NextPriceChange,
IIF( ( NextPrice > 0 AND NextPrice > RetailPrice AND TIMESTAMPDIFF( SQL_TSI_DAY, NextPriceChange, CURRENT_DATE() ) < 150 ), true, false ) AS discountLive
FROM PRODUCTLOOKUP lup
-- next line should be a JOIN not a LEFT JOIN
JOIN PRODUCTLOOK loo ON loo.Cat_No = lup.ReferenceItem
WHERE
NAME = 'CAVENDISH'
AND
loo.Discontinued IS NULL
AND loo.WebDefault = True"
$prod = array(
"WebStory" => "",
"WebInfo" => "<p></p>",
"toutImage" => "lpg-graphic.gif",
"toutAlt" => "Lowest Price Guaranteed",
"title" => ""
)
$WebStory = ""
ProductDetail::fetchProductDetail() - APP/models/product_detail.php, line 68
ProductsController::index() - APP/controllers/products_controller.php, line 43
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
Notice (8): Undefined variable: ReferenceItem [APP/models/product_detail.php, line 148]
ProductDetail::fetchSwatches() - APP/models/product_detail.php, line 148
ProductsController::index() - APP/controllers/products_controller.php, line 46
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
Notice (8): Undefined variable: ReferenceItem [APP/models/product_detail.php, line 167]
AND loo.Discontinued IS NULL AND NOT loo.webSwatchURL IS NULL AND loo.RetailPrice > 50";
$product = "CAVENDISH"
$ads = AdsSource
AdsSource::$startQuote = "["
AdsSource::$endQuote = "]"
AdsSource::$connected = false
AdsSource::$fullDebug = false
AdsSource::$error = NULL
AdsSource::$affected = NULL
AdsSource::$numRows = NULL
AdsSource::$took = NULL
AdsSource::$_result = NULL
AdsSource::$_queriesCnt = 0
AdsSource::$_queriesTime = NULL
AdsSource::$_queriesLog = array
AdsSource::$_queriesLogMax = 200
AdsSource::$_queryCache = array
AdsSource::$_baseConfig = array
AdsSource::$__descriptions = array
AdsSource::$_sources = NULL
AdsSource::$connection = resource
AdsSource::$config = array
AdsSource::$configKeyName = "ads"
AdsSource::$_transactionStarted = false
AdsSource::$cacheSources = true
$ReferenceCat_No = ""
$query = "
SELECT DISTINCT
Variant AS swatchAlias,
SupVariant AS supplierSwatchAlias,
REPLACE( webSwatchURL, '\', '/' ) AS swatchImage,
QUICKSTOCK AS quickStock
FROM PRODUCTLOOK
WHERE Product= 'CAVENDISH'
AND Item = ''
AND webDefault=True
AND Discontinued IS NULL
AND not webSwatchURL IS NULL
AND RetailPrice > 50
ORDER BY RetailPrice ASC, Variant ASC, QUICKSTOCK ASC"
$swatches = array()
ProductDetail::fetchSwatches() - APP/models/product_detail.php, line 167
ProductsController::index() - APP/controllers/products_controller.php, line 46
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
Notice (8): Undefined variable: ReferenceItem [APP/models/product_detail.php, line 181]
AND Discontinued IS NULL AND not webSwatchURL IS NULL AND RetailPrice > 50 " );
$product = "CAVENDISH"
$ads = AdsSource
AdsSource::$startQuote = "["
AdsSource::$endQuote = "]"
AdsSource::$connected = false
AdsSource::$fullDebug = false
AdsSource::$error = NULL
AdsSource::$affected = NULL
AdsSource::$numRows = NULL
AdsSource::$took = NULL
AdsSource::$_result = NULL
AdsSource::$_queriesCnt = 0
AdsSource::$_queriesTime = NULL
AdsSource::$_queriesLog = array
AdsSource::$_queriesLogMax = 200
AdsSource::$_queryCache = array
AdsSource::$_baseConfig = array
AdsSource::$__descriptions = array
AdsSource::$_sources = NULL
AdsSource::$connection = resource
AdsSource::$config = array
AdsSource::$configKeyName = "ads"
AdsSource::$_transactionStarted = false
AdsSource::$cacheSources = true
$ReferenceCat_No = ""
$query = "
SELECT
su.cslvariant,
mat.MaterialDescription
FROM PRODUCTLOOK loo
JOIN SUPPLIERSWATCHES su ON su.CSLVariant = loo.Variant
JOIN MATERIALSUBTYPES mat ON su.MaterialDescription = mat.MaterialSubtype
WHERE loo.Product= 'CAVENDISH'
AND loo.Item = ''
AND loo.webDefault=True
AND loo.Discontinued IS NULL
AND NOT loo.webSwatchURL IS NULL
AND loo.RetailPrice > 50"
$swatches = array()
$swatchDescriptions = array()
ProductDetail::fetchSwatches() - APP/models/product_detail.php, line 181
ProductsController::index() - APP/controllers/products_controller.php, line 46
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
Notice (8): Undefined variable: ReferenceVariant [APP/models/product_detail.php, line 208]
// put the reference swatch at the top $refSwatch = $swatches[$ReferenceVariant];
$product = "CAVENDISH"
$ads = AdsSource
AdsSource::$startQuote = "["
AdsSource::$endQuote = "]"
AdsSource::$connected = false
AdsSource::$fullDebug = false
AdsSource::$error = NULL
AdsSource::$affected = NULL
AdsSource::$numRows = NULL
AdsSource::$took = NULL
AdsSource::$_result = NULL
AdsSource::$_queriesCnt = 0
AdsSource::$_queriesTime = NULL
AdsSource::$_queriesLog = array
AdsSource::$_queriesLogMax = 200
AdsSource::$_queryCache = array
AdsSource::$_baseConfig = array
AdsSource::$__descriptions = array
AdsSource::$_sources = NULL
AdsSource::$connection = resource
AdsSource::$config = array
AdsSource::$configKeyName = "ads"
AdsSource::$_transactionStarted = false
AdsSource::$cacheSources = true
$ReferenceCat_No = ""
$query = "
SELECT
su.cslvariant,
mat.MaterialDescription
FROM PRODUCTLOOK loo
JOIN SUPPLIERSWATCHES su ON su.CSLVariant = loo.Variant
JOIN MATERIALSUBTYPES mat ON su.MaterialDescription = mat.MaterialSubtype
WHERE loo.Product= 'CAVENDISH'
AND loo.Item = ''
AND loo.webDefault=True
AND loo.Discontinued IS NULL
AND NOT loo.webSwatchURL IS NULL
AND loo.RetailPrice > 50"
$swatches = array()
$swatchDescriptions = array()
$swatchPrices = array()
$recommendedSwatches = array()
$premiumSwatches = array()
$moneySavingSwatches = array()
ProductDetail::fetchSwatches() - APP/models/product_detail.php, line 208
ProductsController::index() - APP/controllers/products_controller.php, line 46
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
Notice (8): Undefined index: [APP/models/product_detail.php, line 208]
// put the reference swatch at the top $refSwatch = $swatches[$ReferenceVariant];
$product = "CAVENDISH"
$ads = AdsSource
AdsSource::$startQuote = "["
AdsSource::$endQuote = "]"
AdsSource::$connected = false
AdsSource::$fullDebug = false
AdsSource::$error = NULL
AdsSource::$affected = NULL
AdsSource::$numRows = NULL
AdsSource::$took = NULL
AdsSource::$_result = NULL
AdsSource::$_queriesCnt = 0
AdsSource::$_queriesTime = NULL
AdsSource::$_queriesLog = array
AdsSource::$_queriesLogMax = 200
AdsSource::$_queryCache = array
AdsSource::$_baseConfig = array
AdsSource::$__descriptions = array
AdsSource::$_sources = NULL
AdsSource::$connection = resource
AdsSource::$config = array
AdsSource::$configKeyName = "ads"
AdsSource::$_transactionStarted = false
AdsSource::$cacheSources = true
$ReferenceCat_No = ""
$query = "
SELECT
su.cslvariant,
mat.MaterialDescription
FROM PRODUCTLOOK loo
JOIN SUPPLIERSWATCHES su ON su.CSLVariant = loo.Variant
JOIN MATERIALSUBTYPES mat ON su.MaterialDescription = mat.MaterialSubtype
WHERE loo.Product= 'CAVENDISH'
AND loo.Item = ''
AND loo.webDefault=True
AND loo.Discontinued IS NULL
AND NOT loo.webSwatchURL IS NULL
AND loo.RetailPrice > 50"
$swatches = array()
$swatchDescriptions = array()
$swatchPrices = array()
$recommendedSwatches = array()
$premiumSwatches = array()
$moneySavingSwatches = array()
ProductDetail::fetchSwatches() - APP/models/product_detail.php, line 208
ProductsController::index() - APP/controllers/products_controller.php, line 46
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
Notice (8): Undefined variable: ReferenceVariant [APP/models/product_detail.php, line 209]
// put the reference swatch at the top $refSwatch = $swatches[$ReferenceVariant]; unset( $swatches[$ReferenceVariant] );
$product = "CAVENDISH"
$ads = AdsSource
AdsSource::$startQuote = "["
AdsSource::$endQuote = "]"
AdsSource::$connected = false
AdsSource::$fullDebug = false
AdsSource::$error = NULL
AdsSource::$affected = NULL
AdsSource::$numRows = NULL
AdsSource::$took = NULL
AdsSource::$_result = NULL
AdsSource::$_queriesCnt = 0
AdsSource::$_queriesTime = NULL
AdsSource::$_queriesLog = array
AdsSource::$_queriesLogMax = 200
AdsSource::$_queryCache = array
AdsSource::$_baseConfig = array
AdsSource::$__descriptions = array
AdsSource::$_sources = NULL
AdsSource::$connection = resource
AdsSource::$config = array
AdsSource::$configKeyName = "ads"
AdsSource::$_transactionStarted = false
AdsSource::$cacheSources = true
$ReferenceCat_No = ""
$query = "
SELECT
su.cslvariant,
mat.MaterialDescription
FROM PRODUCTLOOK loo
JOIN SUPPLIERSWATCHES su ON su.CSLVariant = loo.Variant
JOIN MATERIALSUBTYPES mat ON su.MaterialDescription = mat.MaterialSubtype
WHERE loo.Product= 'CAVENDISH'
AND loo.Item = ''
AND loo.webDefault=True
AND loo.Discontinued IS NULL
AND NOT loo.webSwatchURL IS NULL
AND loo.RetailPrice > 50"
$swatches = array()
$swatchDescriptions = array()
$swatchPrices = array()
$recommendedSwatches = array()
$premiumSwatches = array()
$moneySavingSwatches = array()
$refSwatch = null
ProductDetail::fetchSwatches() - APP/models/product_detail.php, line 209
ProductsController::index() - APP/controllers/products_controller.php, line 46
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
Notice (8): Undefined variable: ReferenceVariant [APP/models/product_detail.php, line 210]
$product = "CAVENDISH"
$ads = AdsSource
AdsSource::$startQuote = "["
AdsSource::$endQuote = "]"
AdsSource::$connected = false
AdsSource::$fullDebug = false
AdsSource::$error = NULL
AdsSource::$affected = NULL
AdsSource::$numRows = NULL
AdsSource::$took = NULL
AdsSource::$_result = NULL
AdsSource::$_queriesCnt = 0
AdsSource::$_queriesTime = NULL
AdsSource::$_queriesLog = array
AdsSource::$_queriesLogMax = 200
AdsSource::$_queryCache = array
AdsSource::$_baseConfig = array
AdsSource::$__descriptions = array
AdsSource::$_sources = NULL
AdsSource::$connection = resource
AdsSource::$config = array
AdsSource::$configKeyName = "ads"
AdsSource::$_transactionStarted = false
AdsSource::$cacheSources = true
$ReferenceCat_No = ""
$query = "
SELECT
su.cslvariant,
mat.MaterialDescription
FROM PRODUCTLOOK loo
JOIN SUPPLIERSWATCHES su ON su.CSLVariant = loo.Variant
JOIN MATERIALSUBTYPES mat ON su.MaterialDescription = mat.MaterialSubtype
WHERE loo.Product= 'CAVENDISH'
AND loo.Item = ''
AND loo.webDefault=True
AND loo.Discontinued IS NULL
AND NOT loo.webSwatchURL IS NULL
AND loo.RetailPrice > 50"
$swatches = array()
$swatchDescriptions = array()
$swatchPrices = array()
$recommendedSwatches = array()
$premiumSwatches = array()
$moneySavingSwatches = array()
$refSwatch = null
ProductDetail::fetchSwatches() - APP/models/product_detail.php, line 210
ProductsController::index() - APP/controllers/products_controller.php, line 46
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
What a fantastic service! From the minute we walked into the store at Warrington until the minute our sofa and chairs were delivered we received an excellent service. We would especially like to thank Martin Taylor, Sales Adviser for the thoroughly efficient, friendly and excellent service we received. The delivery guys were also extremely friendly and helpful. We ordered the furniture on Sunday afternoon and it was delivered on the Wednesday! Prior to this we have not used CSL before but will certainly do so in future and we will be recommending it to all our friends and family. We are absolutely delighted with the sofa and chairs - they have transformed the room - they are stunning! Well done to all at CSL for a second to none service. Many thanks
Andrew Salmon
2nd September 2010
Thought Mike Smith was very helpful, also the delivery guys were wonderful, the first two were great, and the two who came today were great to, so comical and friendly, all in all a nice team and a good service.
I just wanted to say how impressive the service and after service from you has been. Thank you to ALL staff I have had dealings with from sales staff at Warrington branch, delivery guys, customer servie staff and the technician who visited my house earlier this morning. Your professionalism is outstanding! Thank you very much
We visited the store on two occasions and on both found staff to be both knowledgeable and helpful. The assistant Janice who finally sold us our furniture was friendly and efficient and processed our order quickly having helped us reach a final decision and gave us valuable advice over the care of our furniture in the future. In fact all members of staff we encountered were pleasant and helpful.
We were really impressed with the help, advice and friendliness of the staff at the Nottingham Branch. Staff were on hand to greet you upon arrival but didnt hassle or pester you whilst in store. Our sales advisor Steve was really helpful, gave us lots of information about the products, fab care advice and looked after us right til the finish. Fantastic customer service!
I would just like to make you aware of your Stockport store, everyone there who I have met are absolutely lovely. Superb, friendly staff through and through! Andy was extremely helpful and didnt follow me around, unlike your competition! Everyone was extremely lovely from start to finish, from Andy and Phil in the store to Sean & Steve who delivered out suite (and carried it up the stairs to the third floor!). I would be greatful if you could pass on my appreciation to these kind people who were always friendly and helpful (and still smiling after squeezing the suite through our corridor!).
Thank you and we will be back when we need an updated suite!
Delivery was prompt and the delivery guys were great. We encounted a problem with a the wiring on the sofa and when we contacted your support we were amazed at your FAST service to put the problem right!! Many thanks and we would highly recommend your company!!!!!!!!!11
We recently purchased a three seater recliner settee and 2 recliner chairs. The sales person was very helpful and delivery was very swift. However, on receiving the furniture we found the settee to be too big. This proved not to be a problem and we exchanged it for a 2 seater settee. All went very well and was sorted within a week with the exchanges being made with no fuss. We were delighted with everyone from the sales person to the two delivery men who showed us how to look after the furniture and did not leave until we were satisfied. Well done to CSL.
Ordered a new suite via telephone, spoke to advisor Abraham who was very patient and helpful in the ordering, a really excellent person to communicate to over the phone and extremely helpful, thanks.
just a note to thank Nigel Soult for his help in selecting our furniture. We were considering a purchase from DFS from their "expressions" suite. Nigel had first hand knowledge of this suite and was able to give us both pros and cons for this and the raffles suite that we finally selected. Thanks again Nigel. Martin and Lisa (chesterfield)
I would like to thank daz & mike for delivering my new corner suite,they were polite friendley and very professional, giving us all the care instructions we required. a very efficient delivery service.
--------------------------------------------------------------------------------
On delivery of our corner suite the delivery men Lee and Paul were great very helpful and polite. They left no mess gave after care and were very helpful.
recently bought furniture from the warrington branch with the service particularly good from the sales consultant Mark Devaney very informative and helpful went out of his way to aid in a partucular purchase
We visited the store on two occasions and on both found staff to be both knowledgeable and helpful. The assistant (Jan) who finally sold us our furniture was friendly and efficient and processed our order quickly having helped us reach a final decision and gave us valuable advice over the care of our furniture in the future. In fact all members of staff we encountered were pleasant and helpful.
Just took delivery of our leather suite which we purchased in May from Gateshead store. Delivery men Tony and Andy were every bit as professional,polite and friendly as Dave the salesman had been.A smooth run up to delivery and a phone call on the day to say they would be here in 20mins and they were! Gave instructions on how to care for the suite and underlined the customer service number on the invoice before they left.
We would like to thank Suzie at the Gateshead branch for her excellent service,advise and down to earth approach upon our visit to buy a new sofa. She is a credit to the company and would like
more people to take on her sales approach
We would like to thank Suzie at the Gateshead branch for her excellent service,advise and down to earth approach upon our visit to buy a new sofa. She is a credit to the company and would like
more people to take on her sales approach
Every new sofa from CSL come with a 5 year guarantee as standard.
At CSL we don’t allow any sofa to go on sale within our stores that we aren’t totally confident will perform to the highest standards
We know that not only do you want great value furniture, you want it to last and that’s why quality and durability are our main
criteria for selection as well as value. In order to be on sale within our stores and online, every sofa is thoroughly inspected
and assessed, with any potential design flaws removed before they ever go into production. – that way, we can ensure that are customers
are getting the very best and reduce the likelyhood of failure under normal use. This allows us to then offer our unique 5 year guarantee on every sofa.
Read more
Unlike other national and regional sofa retailers, CSL still offers local delivery, totally free of charge within a 50 mile radius of any of our superstores.
Better still selected items and colours in this range are part of our amazing 72 Hour – Express Delivery Range.
By ordering today you could be sat o your new designer furniture as quick as the day after tomorrow, sometime even next day.
We’re the only UK furniture retailer to keep a high level of stock to ensure that we can get many of our products to you quickly and in the case of some products,
immediately. This means your new sofa could be in your home in as little as 72 hours and you can get on with welcoming your new furniture into its new home.
Unlike other national and regional sofa retailers, CSL still offers local delivery, totally free of charge within a 50 mile radius of any of our superstores.
Better still selected items and colours in this range are part of our amazing 72 Hour – Express Delivery Range. By ordering today you could be sat o your new designer furniture as quick as the day after tomorrow, sometime even next day.
We’re the only UK furniture retailer to keep a high level of stock to ensure that we can get many of our products to you quickly and in the case of some products, immediately. This means your new sofa could be in your home in as little as 72 hours and you can get on with welcoming your new furniture into its new home.
Testimonials and Reviews
”Thought Mike Smith was very helpful, also the delivery guys were wonderful, the first two were great, and the two who came today were great to, so comical and friendly, all in all a nice team and a good service....“
”I just wanted to say how impressive the service and after service from you has been. Thank you to ALL staff I have had dealings with from sales staff at Warrington branch, delivery guys, customer servie staff and the technician who visited my house earlier this morning. Your professionalism is outstanding! Thank you very much ...“
”We visited the store on two occasions and on both found staff to be both knowledgeable and helpful. The assistant Janice who finally sold us our furniture was friendly and efficient and processed our order quickly having helped us reach a final decision and gave us valuable advice over the care of our furniture in the future. In fact all members of staff we encountered were pleasant and helpful....“
”We were really impressed with the help, advice and friendliness of the staff at the Nottingham Branch. Staff were on hand to greet you upon arrival but didnt hassle or pester you whilst in store. Our sales advisor Steve was really helpful, gave us lots of information about the products, fab care advice and looked after us right til the finish. Fantastic customer service!...“
”I would just like to make you aware of your Stockport store, everyone there who I have met are absolutely lovely. Superb, friendly staff through and through! Andy was extremely helpful and didnt follow me around, unlike your competition! Everyone was extremely lovely from start to finish, from Andy and Phil in the store to Sean & Steve who delivered out suite (and carried it up the stairs to the third floor!). I would be greatful if you could pass on my appreciation to these kind people who were always friendly and helpful (and still smiling after squeezing the suite through our corridor!).
Thank you and we will be back when we need an updated suite!
”Excellent service from the delivery men Wayne and Glynn. They were quick and efficient and gave some excellent advice on how to look after the sofas....“
”Delivery was prompt and the delivery guys were great. We encounted a problem with a the wiring on the sofa and when we contacted your support we were amazed at your FAST service to put the problem right!! Many thanks and we would highly recommend your company!!!!!!!!!11
”We recently purchased a three seater recliner settee and 2 recliner chairs. The sales person was very helpful and delivery was very swift. However, on receiving the furniture we found the settee to be too big. This proved not to be a problem and we exchanged it for a 2 seater settee. All went very well and was sorted within a week with the exchanges being made with no fuss. We were delighted with everyone from the sales person to the two delivery men who showed us how to look after the furniture and did not leave until we were satisfied. Well done to CSL....“
”Ordered a new suite via telephone, spoke to advisor Abraham who was very patient and helpful in the ordering, a really excellent person to communicate to over the phone and extremely helpful, thanks....“
”just a note to thank Nigel Soult for his help in selecting our furniture. We were considering a purchase from DFS from their "expressions" suite. Nigel had first hand knowledge of this suite and was able to give us both pros and cons for this and the raffles suite that we finally selected. Thanks again Nigel. Martin and Lisa (chesterfield)...“
”I would like to thank daz & mike for delivering my new corner suite,they were polite friendley and very professional, giving us all the care instructions we required. a very efficient delivery service....“
--------------------------------------------------------------------------------
On delivery of our corner suite the delivery men Lee and Paul were great very helpful and polite. They left no mess gave after care and were very helpful.
...“
”recently bought furniture from the warrington branch with the service particularly good from the sales consultant Mark Devaney very informative and helpful went out of his way to aid in a partucular purchase...“
”We visited the store on two occasions and on both found staff to be both knowledgeable and helpful. The assistant (Jan) who finally sold us our furniture was friendly and efficient and processed our order quickly having helped us reach a final decision and gave us valuable advice over the care of our furniture in the future. In fact all members of staff we encountered were pleasant and helpful....“
”Just took delivery of our leather suite which we purchased in May from Gateshead store. Delivery men Tony and Andy were every bit as professional,polite and friendly as Dave the salesman had been.A smooth run up to delivery and a phone call on the day to say they would be here in 20mins and they were! Gave instructions on how to care for the suite and underlined the customer service number on the invoice before they left....“
”We would like to thank Suzie at the Gateshead branch for her excellent service,advise and down to earth approach upon our visit to buy a new sofa. She is a credit to the company and would like
more people to take on her sales approach
”We would like to thank Suzie at the Gateshead branch for her excellent service,advise and down to earth approach upon our visit to buy a new sofa. She is a credit to the company and would like
more people to take on her sales approach
Our customer service goes on way after you leave our store
We try to combine first class service, a wealth of experience and top quality products to ensure you never feel the need to call
upon our after sales care team. But, if you ever have to get in touch, you’ll find we’re always happy to help.
With CSL you can choose your sofa then choose your own way to both buy it and to complete payment but always paying only the cash price shown.
Your options are:
Tell us the monthly payment that fits your budget, the deposit that you’d like to pay and we do the rest, allowing you to take up to 4 years
to pay with no charges and no interest ever. Typical 0% APR*
Simply pay a minimum of a 10% deposit, then pay no payments at all and no interest and as long as you settle the full balance within 12 months you only
ever pay the cash price. No charges and No interest. (Failure to pay results in a further 36 months credit at 29.*% APR Typical)
Simply pay a deposit with your order (in-store or On-line) and pay your balance prior to delivery by telephone, in store, online or via your iPhone
with a credit or debit card.
Everybody is different and everyone likes to be able to choose and pay for their furniture in a way that suits them. CSL offer many ways to purchase a
new sofa or chair that make life and budgeting that little bit easier.