keat

I had exactly the same with PayPal Express. Customer places an order using his company details, delivery address etc. Paid with Express which then updates the cart with his personal details. We ended up shipping a £700 order to his home and not his business. I raised the question on here, and the answer was "This is how the express module is configured". I guess basically like it or lump it. We switched back to the standard module.

I'm now lost and confused. However, not to worry, I will be mirroring the site shortly to start work on our 2017 catalogue, so I'll install the foundation skin on the mirror and delve a little deeper.

I added a mug again.. clicked on the basket icon, which produces a popup prompting for 'Secure Checkout' This takes me to the 'Choose a Payment Method' page. I did nothing from there. Did you see the email ?

These results are from a standard search, searching the term T30. Then switching between product code high-low then low-high. MySQL Queries (217): [1] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_sessions` WHERE CubeCart_sessions.session_id = '237dde0e824085c50ced698e6b367a19' LIMIT 1; -- (0.000626802444458 sec) [NOT CACHED] [2] SELECT * FROM `CubeCart_hooks` WHERE CubeCart_hooks.enabled = '1' ORDER BY priority ASC ; -- (0.000626802444458 sec) [CACHE READ] [3] SELECT `php_code`, `unique_id`, `description`, `hook_trigger` FROM `CubeCart_code_snippet` WHERE CubeCart_code_snippet.enabled = '1' ORDER BY `priority` ASC ; -- (0.000626802444458 sec) [CACHE READ] [4] SELECT * FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.path = 'search' ; -- (0.000626802444458 sec) [CACHE READ] [5] SELECT SQL_CALC_FOUND_ROWS `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'logos' LIMIT 1; -- (0.000626802444458 sec) [CACHE READ] [6] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.folder = 'logos' LIMIT 1; -- (0.000626802444458 sec) [CACHE READ] [7] SELECT `folder` FROM `CubeCart_modules` WHERE CubeCart_modules.module = 'livehelp' AND CubeCart_modules.status = '1' ; -- (0.000626802444458 sec) [CACHE READ] [8] SELECT * FROM `CubeCart_currency` WHERE CubeCart_currency.code = 'GBP' ; -- (0.000626802444458 sec) [CACHE READ] [9] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_customer` WHERE CubeCart_customer.customer_id = '19834' LIMIT 1; -- (0.000626802444458 sec) [CACHE READ] [10] SELECT SQL_CALC_FOUND_ROWS `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'ccss' LIMIT 1; -- (0.000626802444458 sec) [CACHE READ] [11] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.folder = 'ccss' LIMIT 1; -- (0.000626802444458 sec) [CACHE READ] [12] SELECT `ip_address` FROM `CubeCart_ccss_ip_addresses` WHERE CubeCart_ccss_ip_addresses.trusted = '0' ; -- (0.000626802444458 sec) [CACHE READ] [13] SELECT `id`, `hits` FROM `CubeCart_search` WHERE CubeCart_search.searchstr = 'T30' ; -- (0.000626802444458 sec) [CACHE READ] [14] UPDATE `CubeCart_search` SET `hits` = '46' WHERE CubeCart_search.id = '9533'; -- (0.000392913818359 sec) [NOT CACHED] [15] SELECT `group_id` FROM `CubeCart_customer_membership` WHERE CubeCart_customer_membership.customer_id = '19834' ; -- (0.000392913818359 sec) [CACHE READ] [16] SHOW INDEX FROM `CubeCart_inventory`; -- (0.000392913818359 sec) [CACHE READ] [17] SHOW VARIABLES LIKE 'ft_min_word_len' -- (0.000392913818359 sec) [CACHE READ] [18] SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name RLIKE '[[::]]' OR I.description RLIKE '[[::]]' OR I.product_code RLIKE '[[::]]') LIMIT 12 OFFSET 0 -- (0.000392913818359 sec) [CACHE READ] [19] SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name RLIKE '[[::]]' OR I.description RLIKE '[[::]]' OR I.product_code RLIKE '[[::]]') -- (0.000392913818359 sec) [CACHE READ] [20] SELECT SQL_CALC_FOUND_ROWS `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'category_product_options' LIMIT 1; -- (0.000392913818359 sec) [CACHE READ] [21] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.folder = 'category_product_options' LIMIT 1; -- (0.000392913818359 sec) [CACHE READ] [22] SELECT `set_id` FROM `CubeCart_options_set_product` WHERE CubeCart_options_set_product.product_id = '4829' ; -- (0.000392913818359 sec) [CACHE READ] [23] SELECT * FROM `CubeCart_option_assign` WHERE CubeCart_option_assign.product = '4829' AND CubeCart_option_assign.set_member_id = '0' AND CubeCart_option_assign.set_enabled = '1' ; -- (0.000392913818359 sec) [CACHE READ] [24] SELECT `set_id` FROM `CubeCart_options_set_product` WHERE CubeCart_options_set_product.product_id = '4855' ; -- (0.000392913818359 sec) [CACHE READ] [25] SELECT * FROM `CubeCart_option_assign` WHERE CubeCart_option_assign.product = '4855' AND CubeCart_option_assign.set_member_id = '0' AND CubeCart_option_assign.set_enabled = '1' ; -- (0.000392913818359 sec) [CACHE READ] [26] SELECT `set_id` FROM `CubeCart_options_set_product` WHERE CubeCart_options_set_product.product_id = '5447' ; -- (0.000392913818359 sec) [CACHE READ] [27] SELECT * FROM `CubeCart_option_assign` WHERE CubeCart_option_assign.product = '5447' AND CubeCart_option_assign.set_member_id = '0' AND CubeCart_option_assign.set_enabled = '1' ; -- (0.000392913818359 sec) [CACHE READ] [28] SELECT `set_id` FROM `CubeCart_options_set_product` WHERE CubeCart_options_set_product.product_id = '6050' ; -- (0.000392913818359 sec) [CACHE READ] [29] SELECT * FROM `CubeCart_option_assign` WHERE CubeCart_option_assign.product = '6050' AND CubeCart_option_assign.set_member_id = '0' AND CubeCart_option_assign.set_enabled = '1' ; -- (0.000392913818359 sec) [CACHE READ] [30] SELECT `option_id`, `option_name`, `option_type`, `option_required`, `priority` FROM `CubeCart_option_group` WHERE `option_id` IN (1,1,1,1,1) ORDER BY `priority` ASC, `option_name` ASC ; -- (0.000392913818359 sec) [CACHE READ] [31] SELECT * FROM `CubeCart_option_value` WHERE CubeCart_option_value.option_id = '1' AND `value_id` IN (1,7,10,4,5) ORDER BY `priority` ASC, `value_name` ASC ; -- (0.000392913818359 sec) [CACHE READ] [32] SELECT * FROM `CubeCart_customer_membership` WHERE CubeCart_customer_membership.customer_id = '19834' ; -- (0.000392913818359 sec) [CACHE READ] [33] SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '4829' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.000392913818359 sec) [CACHE READ] [34] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_image_index` WHERE CubeCart_image_index.product_id = '4829' ORDER BY `main_img` DESC LIMIT 1; -- (0.000392913818359 sec) [CACHE READ] [35] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000392913818359 sec) [CACHE READ] [36] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000392913818359 sec) [CACHE READ] [37] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000392913818359 sec) [CACHE READ] [38] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000392913818359 sec) [CACHE READ] [39] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000392913818359 sec) [CACHE READ] [40] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000392913818359 sec) [CACHE READ] [41] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000392913818359 sec) [CACHE READ] [42] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000392913818359 sec) [CACHE READ] [43] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000392913818359 sec) [CACHE READ] [44] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000392913818359 sec) [CACHE READ] [45] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000392913818359 sec) [CACHE READ] [46] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'prod' AND CubeCart_seo_urls.item_id = '4829' ; -- (0.000392913818359 sec) [CACHE READ] [47] SELECT * FROM `CubeCart_customer_membership` WHERE CubeCart_customer_membership.customer_id = '19834' ; -- (0.000392913818359 sec) [CACHE READ] [48] SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '4855' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.000392913818359 sec) [CACHE READ] [49] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_image_index` WHERE CubeCart_image_index.product_id = '4855' ORDER BY `main_img` DESC LIMIT 1; -- (0.000392913818359 sec) [CACHE READ] [50] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2671' ; -- (0.000392913818359 sec) [CACHE READ] [51] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2671' ; -- (0.000392913818359 sec) [CACHE READ] [52] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2671' ; -- (0.000392913818359 sec) [CACHE READ] [53] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2671' ; -- (0.000392913818359 sec) [CACHE READ] [54] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2671' ; -- (0.000392913818359 sec) [CACHE READ] [55] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2671' ; -- (0.000392913818359 sec) [CACHE READ] [56] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2671' ; -- (0.000392913818359 sec) [CACHE READ] [57] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2671' ; -- (0.000392913818359 sec) [CACHE READ] [58] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2671' ; -- (0.000392913818359 sec) [CACHE READ] [59] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2671' ; -- (0.000392913818359 sec) [CACHE READ] [60] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2671' ; -- (0.000392913818359 sec) [CACHE READ] [61] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'prod' AND CubeCart_seo_urls.item_id = '4855' ; -- (0.000392913818359 sec) [CACHE READ] [62] SELECT * FROM `CubeCart_customer_membership` WHERE CubeCart_customer_membership.customer_id = '19834' ; -- (0.000392913818359 sec) [CACHE READ] [63] SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '5447' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.000392913818359 sec) [CACHE READ] [64] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_image_index` WHERE CubeCart_image_index.product_id = '5447' ORDER BY `main_img` DESC LIMIT 1; -- (0.000392913818359 sec) [CACHE READ] [65] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2691' ; -- (0.000392913818359 sec) [CACHE READ] [66] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2691' ; -- (0.000392913818359 sec) [CACHE READ] [67] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2691' ; -- (0.000392913818359 sec) [CACHE READ] [68] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2691' ; -- (0.000392913818359 sec) [CACHE READ] [69] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2691' ; -- (0.000392913818359 sec) [CACHE READ] [70] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2691' ; -- (0.000392913818359 sec) [CACHE READ] [71] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2691' ; -- (0.000392913818359 sec) [CACHE READ] [72] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2691' ; -- (0.000392913818359 sec) [CACHE READ] [73] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2691' ; -- (0.000392913818359 sec) [CACHE READ] [74] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2691' ; -- (0.000392913818359 sec) [CACHE READ] [75] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2691' ; -- (0.000392913818359 sec) [CACHE READ] [76] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'prod' AND CubeCart_seo_urls.item_id = '5447' ; -- (0.000392913818359 sec) [CACHE READ] [77] SELECT * FROM `CubeCart_customer_membership` WHERE CubeCart_customer_membership.customer_id = '19834' ; -- (0.000392913818359 sec) [CACHE READ] [78] SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '6050' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.000392913818359 sec) [CACHE READ] [79] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_image_index` WHERE CubeCart_image_index.product_id = '6050' ORDER BY `main_img` DESC LIMIT 1; -- (0.000392913818359 sec) [CACHE READ] [80] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2421' ; -- (0.000392913818359 sec) [CACHE READ] [81] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2421' ; -- (0.000392913818359 sec) [CACHE READ] [82] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2421' ; -- (0.000392913818359 sec) [CACHE READ] [83] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2421' ; -- (0.000392913818359 sec) [CACHE READ] [84] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2421' ; -- (0.000392913818359 sec) [CACHE READ] [85] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2421' ; -- (0.000392913818359 sec) [CACHE READ] [86] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2421' ; -- (0.000392913818359 sec) [CACHE READ] [87] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2421' ; -- (0.000392913818359 sec) [CACHE READ] [88] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2421' ; -- (0.000392913818359 sec) [CACHE READ] [89] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2421' ; -- (0.000392913818359 sec) [CACHE READ] [90] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2421' ; -- (0.000392913818359 sec) [CACHE READ] [91] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'prod' AND CubeCart_seo_urls.item_id = '6050' ; -- (0.000392913818359 sec) [CACHE READ] [92] SELECT SQL_CALC_FOUND_ROWS `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'languages' LIMIT 1; -- (0.000392913818359 sec) [CACHE READ] [93] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.folder = 'languages' LIMIT 1; -- (0.000392913818359 sec) [CACHE READ] [94] SELECT * FROM `CubeCart_currency` WHERE CubeCart_currency.active = '1' ; -- (0.000392913818359 sec) [CACHE READ] [95] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'login' ; -- (0.000392913818359 sec) [CACHE READ] [96] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'register' ; -- (0.000392913818359 sec) [CACHE READ] [97] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'search' ; -- (0.000392913818359 sec) [CACHE READ] [98] SELECT * FROM `CubeCart_customer_membership` WHERE CubeCart_customer_membership.customer_id = '19834' ; -- (0.000392913818359 sec) [CACHE READ] [99] SELECT `price`, `sale_price`, `product_id`,`description`,`name`, `price`-`sale_price` AS `saving` FROM `CubeCart_inventory` WHERE `price` > `sale_price` AND `sale_price` > 0 AND `status` = '1' LIMIT 6 -- (0.000392913818359 sec) [CACHE READ] [100] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'prod' AND CubeCart_seo_urls.item_id = '522' ; -- (0.000392913818359 sec) [CACHE READ]

Are you using Fantastico to install Cubecart. ? Have you tried downloading the install zip from the cubecart site then FTP upload the files to your public_html folder and running setup manually. ?

I found this. http://stackoverflow.com/questions/11779889/warning-session-start-function-session-start-open-tmp-sess-e07-42c14904 Talks about creating a tmp folder in public_html with permissions of 777 Maybe of some use ?

I added a mug or a plate to the cart and clicked the first 'secure checkout' button, but didn't proceed from there. Do you email at order pending or email at order processing ?

I just took a quick look and it's stuck on V6.12 setup screen.

Never thought of that !! That actually works.

I wanted to see what the checkout process looks like, to see if it will fix the problem with customers being able to click the back button and change his order after the store email is sent. I see on foundation that stage 1 of the checkout process, still has a 'Secure Checkout' button, can I assume that this is the point at which it sends the 'pending' store email to admin ? Or does the 'Pending' email get sent at the point where I choose my payment method and click the 2nd 'Secure Checkout' button ?

I thought i tried that, but here it is again. I chose to sort product_code, high to low, low to high and back again. [1] SHOW COLUMNS FROM CubeCart_sessions; -- (0.00100493431091 sec) [CACHE WRITE] [2] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_sessions` WHERE CubeCart_sessions.session_id = '237dde0e824085c50ced698e6b367a19' LIMIT 1; -- (0.000505924224854 sec) [NOT CACHED] [3] SELECT FOUND_ROWS() as Count; -- (0.000130176544189 sec) [NOT CACHED] [4] SHOW COLUMNS FROM CubeCart_hooks; -- (0.000916004180908 sec) [CACHE WRITE] [5] SELECT * FROM `CubeCart_hooks` WHERE CubeCart_hooks.enabled = '1' ORDER BY priority ASC ; -- (0.000521898269653 sec) [CACHE WRITE] [6] SHOW COLUMNS FROM CubeCart_code_snippet; -- (0.000680923461914 sec) [CACHE WRITE] [7] SELECT `php_code`, `unique_id`, `description`, `hook_trigger` FROM `CubeCart_code_snippet` WHERE CubeCart_code_snippet.enabled = '1' ORDER BY `priority` ASC ; -- (0.000389814376831 sec) [CACHE WRITE] [8] SHOW COLUMNS FROM CubeCart_seo_urls; -- (0.000720024108887 sec) [CACHE WRITE] [9] SELECT * FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.path = 'search' ; -- (0.000339984893799 sec) [CACHE WRITE] [10] SELECT SQL_CALC_FOUND_ROWS `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'logos' LIMIT 1; -- (0.000401973724365 sec) [CACHE WRITE] [11] SELECT FOUND_ROWS() as Count; -- (0.000109910964966 sec) [NOT CACHED] [12] SHOW COLUMNS FROM CubeCart_modules; -- (0.000743865966797 sec) [CACHE WRITE] [13] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.folder = 'logos' LIMIT 1; -- (0.000743865966797 sec) [CACHE READ] [14] SELECT `folder` FROM `CubeCart_modules` WHERE CubeCart_modules.module = 'livehelp' AND CubeCart_modules.status = '1' ; -- (0.000743865966797 sec) [CACHE READ] [15] SHOW COLUMNS FROM CubeCart_currency; -- (0.000882863998413 sec) [CACHE WRITE] [16] SELECT * FROM `CubeCart_currency` WHERE CubeCart_currency.code = 'GBP' ; -- (0.000344038009644 sec) [CACHE WRITE] [17] SHOW COLUMNS FROM CubeCart_customer; -- (0.00121998786926 sec) [CACHE WRITE] [18] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_customer` WHERE CubeCart_customer.customer_id = '19834' LIMIT 1; -- (0.000427961349487 sec) [CACHE WRITE] [19] SELECT FOUND_ROWS() as Count; -- (9.89437103271E-5 sec) [NOT CACHED] [20] SELECT SQL_CALC_FOUND_ROWS `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'ccss' LIMIT 1; -- (0.000405073165894 sec) [CACHE WRITE] [21] SELECT FOUND_ROWS() as Count; -- (0.000102996826172 sec) [NOT CACHED] [22] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.folder = 'ccss' LIMIT 1; -- (0.000275850296021 sec) [CACHE WRITE] [23] SELECT FOUND_ROWS() as Count; -- (9.48905944824E-5 sec) [NOT CACHED] [24] SHOW COLUMNS FROM CubeCart_ccss_ip_addresses; -- (0.000633955001831 sec) [CACHE WRITE] [25] SELECT `ip_address` FROM `CubeCart_ccss_ip_addresses` WHERE CubeCart_ccss_ip_addresses.trusted = '0' ; -- (0.000633955001831 sec) [CACHE READ] [26] SHOW COLUMNS FROM CubeCart_search; -- (0.000480175018311 sec) [CACHE WRITE] [27] SELECT `id`, `hits` FROM `CubeCart_search` WHERE CubeCart_search.searchstr = 'T30' ; -- (0.00773596763611 sec) [CACHE WRITE] [28] UPDATE `CubeCart_search` SET `hits` = '40' WHERE CubeCart_search.id = '9533'; -- (0.000241994857788 sec) [NOT CACHED] [29] SHOW COLUMNS FROM CubeCart_customer_membership; -- (0.000595092773438 sec) [CACHE WRITE] [30] SELECT `group_id` FROM `CubeCart_customer_membership` WHERE CubeCart_customer_membership.customer_id = '19834' ; -- (0.000595092773438 sec) [CACHE READ] [31] SHOW INDEX FROM `CubeCart_inventory`; -- (0.000423192977905 sec) [CACHE WRITE] [32] SHOW VARIABLES LIKE 'ft_min_word_len' -- (0.00036096572876 sec) [CACHE WRITE] [33] SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name RLIKE '[[::]]' OR I.description RLIKE '[[::]]' OR I.product_code RLIKE '[[::]]') LIMIT 12 OFFSET 0 -- (0.090763092041 sec) [CACHE WRITE] [34] SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name RLIKE '[[::]]' OR I.description RLIKE '[[::]]' OR I.product_code RLIKE '[[::]]') -- (0.0940189361572 sec) [CACHE WRITE] [35] SELECT SQL_CALC_FOUND_ROWS `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'category_product_options' LIMIT 1; -- (0.000530004501343 sec) [CACHE WRITE] [36] SELECT FOUND_ROWS() as Count; -- (0.000102996826172 sec) [NOT CACHED] [37] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.folder = 'category_product_options' LIMIT 1; -- (0.000244140625 sec) [CACHE WRITE] [38] SELECT FOUND_ROWS() as Count; -- (9.29832458496E-5 sec) [NOT CACHED] [39] SHOW COLUMNS FROM CubeCart_options_set_product; -- (0.000678062438965 sec) [CACHE WRITE] [40] SELECT `set_id` FROM `CubeCart_options_set_product` WHERE CubeCart_options_set_product.product_id = '4829' ; -- (0.000678062438965 sec) [CACHE READ] [41] SHOW COLUMNS FROM CubeCart_option_assign; -- (0.000653982162476 sec) [CACHE WRITE] [42] SELECT * FROM `CubeCart_option_assign` WHERE CubeCart_option_assign.product = '4829' AND CubeCart_option_assign.set_member_id = '0' AND CubeCart_option_assign.set_enabled = '1' ; -- (0.000653982162476 sec) [CACHE READ] [43] SELECT `set_id` FROM `CubeCart_options_set_product` WHERE CubeCart_options_set_product.product_id = '4855' ; -- (0.000653982162476 sec) [CACHE READ] [44] SELECT * FROM `CubeCart_option_assign` WHERE CubeCart_option_assign.product = '4855' AND CubeCart_option_assign.set_member_id = '0' AND CubeCart_option_assign.set_enabled = '1' ; -- (0.000653982162476 sec) [CACHE READ] [45] SELECT `set_id` FROM `CubeCart_options_set_product` WHERE CubeCart_options_set_product.product_id = '5447' ; -- (0.000653982162476 sec) [CACHE READ] [46] SELECT * FROM `CubeCart_option_assign` WHERE CubeCart_option_assign.product = '5447' AND CubeCart_option_assign.set_member_id = '0' AND CubeCart_option_assign.set_enabled = '1' ; -- (0.000653982162476 sec) [CACHE READ] [47] SELECT `set_id` FROM `CubeCart_options_set_product` WHERE CubeCart_options_set_product.product_id = '6050' ; -- (0.000653982162476 sec) [CACHE READ] [48] SELECT * FROM `CubeCart_option_assign` WHERE CubeCart_option_assign.product = '6050' AND CubeCart_option_assign.set_member_id = '0' AND CubeCart_option_assign.set_enabled = '1' ; -- (0.000806093215942 sec) [CACHE WRITE] [49] SHOW COLUMNS FROM CubeCart_option_group; -- (0.000576019287109 sec) [CACHE WRITE] [50] SELECT `option_id`, `option_name`, `option_type`, `option_required`, `priority` FROM `CubeCart_option_group` WHERE `option_id` IN (1,1,1,1,1) ORDER BY `priority` ASC, `option_name` ASC ; -- (0.000288963317871 sec) [CACHE WRITE] [51] SHOW COLUMNS FROM CubeCart_option_value; -- (0.000489950180054 sec) [CACHE WRITE] [52] SELECT * FROM `CubeCart_option_value` WHERE CubeCart_option_value.option_id = '1' AND `value_id` IN (1,7,10,4,5) ORDER BY `priority` ASC, `value_name` ASC ; -- (0.000369071960449 sec) [CACHE WRITE] [53] SELECT * FROM `CubeCart_customer_membership` WHERE CubeCart_customer_membership.customer_id = '19834' ; -- (0.000369071960449 sec) [CACHE READ] [54] SHOW COLUMNS FROM CubeCart_pricing_quantity; -- (0.000607013702393 sec) [CACHE WRITE] [55] SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '4829' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.000607013702393 sec) [CACHE READ] [56] SHOW COLUMNS FROM CubeCart_image_index; -- (0.000488042831421 sec) [CACHE WRITE] [57] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_image_index` WHERE CubeCart_image_index.product_id = '4829' ORDER BY `main_img` DESC LIMIT 1; -- (0.000266075134277 sec) [CACHE WRITE] [58] SELECT FOUND_ROWS() as Count; -- (9.70363616943E-5 sec) [NOT CACHED] [59] SHOW COLUMNS FROM CubeCart_filemanager; -- (0.000726938247681 sec) [CACHE WRITE] [60] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000298976898193 sec) [CACHE WRITE] [61] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000298976898193 sec) [CACHE READ] [62] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000298976898193 sec) [CACHE READ] [63] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000298976898193 sec) [CACHE READ] [64] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000298976898193 sec) [CACHE READ] [65] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000298976898193 sec) [CACHE READ] [66] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000298976898193 sec) [CACHE READ] [67] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000298976898193 sec) [CACHE READ] [68] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000298976898193 sec) [CACHE READ] [69] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000298976898193 sec) [CACHE READ] [70] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000298976898193 sec) [CACHE READ]

I put an order on for an Orange watch £10.00, and then clicked the back button and added another. I'm guessing as this is a test site, you may not monitor the emails ? Is it a Live store ? Do you receive store emails etc ?

The way we would do this is to add the item, and include words "Coming Soon" or "Due in Stock on DD/MM/YYYY" We then use stock level 0 and leave it this way until it arrives.

Nice one, I'm having that.

Here are the first 50 lines. Hopefully, what we are looking for is in here ? Queries (216): [1] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_sessions` WHERE CubeCart_sessions.session_id = '237dde0e824085c50ced698e6b367a19' LIMIT 1; -- (0.000606060028076 sec) [NOT CACHED] [2] SELECT * FROM `CubeCart_hooks` WHERE CubeCart_hooks.enabled = '1' ORDER BY priority ASC ; -- (0.000606060028076 sec) [CACHE READ] [3] SELECT `php_code`, `unique_id`, `description`, `hook_trigger` FROM `CubeCart_code_snippet` WHERE CubeCart_code_snippet.enabled = '1' ORDER BY `priority` ASC ; -- (0.000606060028076 sec) [CACHE READ] [4] SELECT SQL_CALC_FOUND_ROWS `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'logos' LIMIT 1; -- (0.000606060028076 sec) [CACHE READ] [5] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.folder = 'logos' LIMIT 1; -- (0.000606060028076 sec) [CACHE READ] [6] SELECT `folder` FROM `CubeCart_modules` WHERE CubeCart_modules.module = 'livehelp' AND CubeCart_modules.status = '1' ; -- (0.000606060028076 sec) [CACHE READ] [7] SELECT * FROM `CubeCart_currency` WHERE CubeCart_currency.code = 'GBP' ; -- (0.000606060028076 sec) [CACHE READ] [8] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_customer` WHERE CubeCart_customer.customer_id = '19834' LIMIT 1; -- (0.000606060028076 sec) [CACHE READ] [9] SELECT SQL_CALC_FOUND_ROWS `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'ccss' LIMIT 1; -- (0.000606060028076 sec) [CACHE READ] [10] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.folder = 'ccss' LIMIT 1; -- (0.000606060028076 sec) [CACHE READ] [11] SELECT `ip_address` FROM `CubeCart_ccss_ip_addresses` WHERE CubeCart_ccss_ip_addresses.trusted = '0' ; -- (0.000606060028076 sec) [CACHE READ] [12] SELECT `id`, `hits` FROM `CubeCart_search` WHERE CubeCart_search.searchstr = 'T30' ; -- (0.000606060028076 sec) [CACHE READ] [13] UPDATE `CubeCart_search` SET `hits` = '38' WHERE CubeCart_search.id = '9533'; -- (0.000380039215088 sec) [NOT CACHED] [14] SELECT `group_id` FROM `CubeCart_customer_membership` WHERE CubeCart_customer_membership.customer_id = '19834' ; -- (0.000380039215088 sec) [CACHE READ] [15] SHOW INDEX FROM `CubeCart_inventory`; -- (0.000380039215088 sec) [CACHE READ] [16] SHOW VARIABLES LIKE 'ft_min_word_len' -- (0.000380039215088 sec) [CACHE READ] [17] SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name RLIKE '[[::]]' OR I.description RLIKE '[[::]]' OR I.product_code RLIKE '[[::]]') LIMIT 12 OFFSET 0 -- (0.000380039215088 sec) [CACHE READ] [18] SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name RLIKE '[[::]]' OR I.description RLIKE '[[::]]' OR I.product_code RLIKE '[[::]]') -- (0.000380039215088 sec) [CACHE READ] [19] SELECT SQL_CALC_FOUND_ROWS `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'category_product_options' LIMIT 1; -- (0.000380039215088 sec) [CACHE READ] [20] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.folder = 'category_product_options' LIMIT 1; -- (0.000380039215088 sec) [CACHE READ] [21] SELECT `set_id` FROM `CubeCart_options_set_product` WHERE CubeCart_options_set_product.product_id = '4829' ; -- (0.000380039215088 sec) [CACHE READ] [22] SELECT * FROM `CubeCart_option_assign` WHERE CubeCart_option_assign.product = '4829' AND CubeCart_option_assign.set_member_id = '0' AND CubeCart_option_assign.set_enabled = '1' ; -- (0.000380039215088 sec) [CACHE READ] [23] SELECT `set_id` FROM `CubeCart_options_set_product` WHERE CubeCart_options_set_product.product_id = '4855' ; -- (0.000380039215088 sec) [CACHE READ] [24] SELECT * FROM `CubeCart_option_assign` WHERE CubeCart_option_assign.product = '4855' AND CubeCart_option_assign.set_member_id = '0' AND CubeCart_option_assign.set_enabled = '1' ; -- (0.000380039215088 sec) [CACHE READ] [25] SELECT `set_id` FROM `CubeCart_options_set_product` WHERE CubeCart_options_set_product.product_id = '5447' ; -- (0.000380039215088 sec) [CACHE READ] [26] SELECT * FROM `CubeCart_option_assign` WHERE CubeCart_option_assign.product = '5447' AND CubeCart_option_assign.set_member_id = '0' AND CubeCart_option_assign.set_enabled = '1' ; -- (0.000380039215088 sec) [CACHE READ] [27] SELECT `set_id` FROM `CubeCart_options_set_product` WHERE CubeCart_options_set_product.product_id = '6050' ; -- (0.000380039215088 sec) [CACHE READ] [28] SELECT * FROM `CubeCart_option_assign` WHERE CubeCart_option_assign.product = '6050' AND CubeCart_option_assign.set_member_id = '0' AND CubeCart_option_assign.set_enabled = '1' ; -- (0.000380039215088 sec) [CACHE READ] [29] SELECT `option_id`, `option_name`, `option_type`, `option_required`, `priority` FROM `CubeCart_option_group` WHERE `option_id` IN (1,1,1,1,1) ORDER BY `priority` ASC, `option_name` ASC ; -- (0.000380039215088 sec) [CACHE READ] [30] SELECT * FROM `CubeCart_option_value` WHERE CubeCart_option_value.option_id = '1' AND `value_id` IN (1,7,10,4,5) ORDER BY `priority` ASC, `value_name` ASC ; -- (0.000380039215088 sec) [CACHE READ] [31] SELECT * FROM `CubeCart_customer_membership` WHERE CubeCart_customer_membership.customer_id = '19834' ; -- (0.000380039215088 sec) [CACHE READ] [32] SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '4829' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.000380039215088 sec) [CACHE READ] [33] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_image_index` WHERE CubeCart_image_index.product_id = '4829' ORDER BY `main_img` DESC LIMIT 1; -- (0.000380039215088 sec) [CACHE READ] [34] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000380039215088 sec) [CACHE READ] [35] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000380039215088 sec) [CACHE READ] [36] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000380039215088 sec) [CACHE READ] [37] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000380039215088 sec) [CACHE READ] [38] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000380039215088 sec) [CACHE READ] [39] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000380039215088 sec) [CACHE READ] [40] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000380039215088 sec) [CACHE READ] [41] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000380039215088 sec) [CACHE READ] [42] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000380039215088 sec) [CACHE READ] [43] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000380039215088 sec) [CACHE READ] [44] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2195' ; -- (0.000380039215088 sec) [CACHE READ] [45] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'prod' AND CubeCart_seo_urls.item_id = '4829' ; -- (0.000380039215088 sec) [CACHE READ] [46] SELECT * FROM `CubeCart_customer_membership` WHERE CubeCart_customer_membership.customer_id = '19834' ; -- (0.000380039215088 sec) [CACHE READ] [47] SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '4855' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.000380039215088 sec) [CACHE READ] [48] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_image_index` WHERE CubeCart_image_index.product_id = '4855' ORDER BY `main_img` DESC LIMIT 1; -- (0.000380039215088 sec) [CACHE READ] [49] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2671' ; -- (0.000380039215088 sec) [CACHE READ] [50] SELECT * FROM `CubeCart_filemanager` WHERE CubeCart_filemanager.file_id = '2671' ; -- (0.000380039215088 sec) [CACHE READ]

This is what I got when I tried to change high to low or low to high [218] SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '1247' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.000195980072021 sec) [CACHE WRITE] [219] SELECT CI.* , C.status FROM `CubeCart_category_index` AS CI, `CubeCart_category` AS C WHERE CI.product_id = '1965' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.000262975692749 sec) [CACHE WRITE] [220] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'prod' AND CubeCart_seo_urls.item_id = '1965' ; -- (0.000243902206421 sec) [CACHE WRITE] [221] SELECT * FROM `CubeCart_customer_membership` WHERE CubeCart_customer_membership.customer_id = '19834' ; -- (0.000243902206421 sec) [CACHE READ] [222] SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '1965' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.000194072723389 sec) [CACHE WRITE] [223] SELECT CI.* , C.status FROM `CubeCart_category_index` AS CI, `CubeCart_category` AS C WHERE CI.product_id = '1304' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.000262975692749 sec) [CACHE WRITE] [224] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'prod' AND CubeCart_seo_urls.item_id = '1304' ; -- (0.000235795974731 sec) [CACHE WRITE] [225] SELECT * FROM `CubeCart_customer_membership` WHERE CubeCart_customer_membership.customer_id = '19834' ; -- (0.000235795974731 sec) [CACHE READ] [226] SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '1304' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.000192165374756 sec) [CACHE WRITE] [227] SELECT CI.* , C.status FROM `CubeCart_category_index` AS CI, `CubeCart_category` AS C WHERE CI.product_id = '64' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.000271081924438 sec) [CACHE WRITE] [228] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'prod' AND CubeCart_seo_urls.item_id = '64' ; -- (0.000221014022827 sec) [CACHE WRITE] [229] SELECT * FROM `CubeCart_customer_membership` WHERE CubeCart_customer_membership.customer_id = '19834' ; -- (0.000221014022827 sec) [CACHE READ] [230] SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '64' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.000200033187866 sec) [CACHE WRITE] [231] SELECT CI.* , C.status FROM `CubeCart_category_index` AS CI, `CubeCart_category` AS C WHERE CI.product_id = '1924' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.000289916992188 sec) [CACHE WRITE] [232] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'prod' AND CubeCart_seo_urls.item_id = '1924' ; -- (0.000228881835938 sec) [CACHE WRITE] [233] SELECT * FROM `CubeCart_customer_membership` WHERE CubeCart_customer_membership.customer_id = '19834' ; -- (0.000228881835938 sec) [CACHE READ] [234] SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '1924' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.000207185745239 sec) [CACHE WRITE] [235] SELECT CI.* , C.status FROM `CubeCart_category_index` AS CI, `CubeCart_category` AS C WHERE CI.product_id = '1925' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.000261068344116 sec) [CACHE WRITE] [236] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'prod' AND CubeCart_seo_urls.item_id = '1925' ; -- (0.000224113464355 sec) [CACHE WRITE] [237] SELECT * FROM `CubeCart_customer_membership` WHERE CubeCart_customer_membership.customer_id = '19834' ; -- (0.000224113464355 sec) [CACHE READ] [238] SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '1925' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.000192880630493 sec) [CACHE WRITE] [239] SELECT CI.* , C.status FROM `CubeCart_category_index` AS CI, `CubeCart_category` AS C WHERE CI.product_id = '1459' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.000274896621704 sec) [CACHE WRITE] [240] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'prod' AND CubeCart_seo_urls.item_id = '1459' ; -- (0.000233888626099 sec) [CACHE WRITE] [241] SELECT * FROM `CubeCart_customer_membership` WHERE CubeCart_customer_membership.customer_id = '19834' ; -- (0.000233888626099 sec) [CACHE READ] [242] SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '1459' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.000188827514648 sec) [CACHE WRITE] [243] SELECT CI.* , C.status FROM `CubeCart_category_index` AS CI, `CubeCart_category` AS C WHERE CI.product_id = '535' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.000275850296021 sec) [CACHE WRITE] [244] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'prod' AND CubeCart_seo_urls.item_id = '535' ; -- (0.000231981277466 sec) [CACHE WRITE] [245] SELECT * FROM `CubeCart_customer_membership` WHERE CubeCart_customer_membership.customer_id = '19834' ; -- (0.000231981277466 sec) [CACHE READ] [246] SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '535' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.000211954116821 sec) [CACHE WRITE] [247] SELECT CI.* , C.status FROM `CubeCart_category_index` AS CI, `CubeCart_category` AS C WHERE CI.product_id = '235' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.000266075134277 sec) [CACHE WRITE] [248] SELECT `path` FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.type = 'prod' AND CubeCart_seo_urls.item_id = '235' ; -- (0.000238180160522 sec) [CACHE WRITE] [249] SELECT * FROM `CubeCart_customer_membership` WHERE CubeCart_customer_membership.customer_id = '19834' ; -- (0.000238180160522 sec) [CACHE READ] [250] SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '235' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.000195026397705 sec) [CACHE WRITE]

Nothing sinister, I just want to place an order on a Foundation skin site so I can take a look at the checkout process. I use the Mican skin and am considering a change. It will be obvious that it's a test order. TIA

I'm still on 6.10

I got the error when choosing the url "Pick a carton size here" http://packagingdielines.com/pick-a-carton-size-here.html I'd suggest that the 'Pick a Carton Size' page does not exist.

Sorry about lack of response. I've just tried on my Galaxy S5 (phone), in landscape and it's fine. If I remember i'll try it on my aging nexus 7 later this evening

I just tried to add the snippet, but I can't see the trigger class.catalogue.product_sort I found this in GitHub https://github.com/cubecart/v6/commit/4c61aaf128bb5c58cde8fb958e0aac1013d0f579 Now the option appears in the drop down, however, it doesn't seem to have any effect.

If it helps at all, I also tried this today. When choosing the 'POF' button, the site goes straight back to the home page. I don't see the status bar 'Transferring, Please Wait' And the order is still stuck on 'Pending' I have 'send confirmation email' checked.

Sorted. definitely more responsive initially. I assume that any new images will start to be uploaded to the source folder ? However, if this is the case, then a similar update once every 12 months won't be hard work.

I got the impression previously that this process was to separate images in to many directories. I didn't realise that it was all images in to one directory. Maybe I'll look at this then.

I found the orphaned entries in the cubecart_filemanager table. However, this got me thinking about the slow page refresh when editing a product. Maybe I could export the inventory, file manager and image_index tables and use something like MS Access to link the tables and run a query to find which images are not associated with a product. If i then remove these entries from the file manger table, it might speed up the page refresh. any thoughts ?