1
Общие вопросы / Re: Как ценник в спецпредложениях ниже сместить?
« : Марта 17, 2014, 07:26:52 pm »
Благодарю !
🔶 Свежий релиз CMS Legosp 6.3.1
😎 Новый универсальный шаблон "Store"
👉 Новая услуга "Бесплатный SEO анализ" вашего сайта!
🔴 6 супер модулей всего за 👉100$ В разделе модули "Комплект из 6-ти модулей"
💣 УРА! Мы обновили дизайн сайта!
☁️ Интернет-магазин в облаке Legosp CLOUD!⚡⚡⚡
В этом разделе можно просмотреть все сообщения, сделанные этим пользователем.
ЗИМНИЙ КОСТЮМ РЫБОЛОВА(Размер:58-60, Рост:180-190) 61 2 470руб. 150 670руб.
ЗИМНИЙ КОСТЮМ РЫБОЛОВА(Рост:170-180, Размер:50-52)
в зависимости от того, по-моему-как выбирал клиент.SELECT sum(`price_surplus`) price_surplus, GROUP_CONCAT(CONCAT(O.`name`,':',V.`name`) SEPARATOR ', ') variants FROM `SS_product_options` as O join `SS_products_opt_val_variants` as V on (O.optionID=V.optionID and V.variantID in (49)) join `SS_product_options_values` as OV on (V.variantID=OV.variantID and productID=166)
UPDATE `SS_product_options_values` SET `count` = `count`-2 WHERE `productID` = 166 and variantID in (49)
INSERT INTO `SS_ordered_carts` SET `orderID`='5',`productID`='166',`name`='ЛЕТНИЙ КОСТЮМ МОДЕЛЬ-1 Размер 46(Рост:175-185)',`Price`='1196',`Quantity`='2'
UPDATE SS_products SET items_sold=items_sold+1, in_stock=in_stock-2 WHERE productID=166
SELECT P.name, Price, product_code, hurl, categoryID,email manager_email, online_name FROM SS_products as P LEFT JOIN SS_manager as M on (M.ID=P.managerID) WHERE productID=126
SELECT sum(`price_surplus`) price_surplus, GROUP_CONCAT(CONCAT(O.`name`,':',V.`name`) SEPARATOR ', ') variants FROM `SS_product_options` as O join `SS_products_opt_val_variants` as V on (O.optionID=V.optionID and V.variantID in (9,11)) join `SS_product_options_values` as OV on (V.variantID=OV.variantID and productID=126)
UPDATE `SS_product_options_values` SET `count` = `count`-2 WHERE `productID` = 126 and variantID in (9,11)
INSERT INTO `SS_ordered_carts` SET `orderID`='5',`productID`='126',`name`='ЗИМНИЙ КОСТЮМ РЫБОЛОВА(Размер:62-64, Рост:180-190)',`Price`='2520',`Quantity`='2'
UPDATE SS_products SET items_sold=items_sold+1, in_stock=in_stock-2 WHERE productID=126
SELECT P.name, Price, product_code, hurl, categoryID,email manager_email, online_name FROM SS_products as P LEFT JOIN SS_manager as M on (M.ID=P.managerID) WHERE productID=128
SELECT sum(`price_surplus`) price_surplus, GROUP_CONCAT(CONCAT(O.`name`,':',V.`name`) SEPARATOR ', ') variants FROM `SS_product_options` as O join `SS_products_opt_val_variants` as V on (O.optionID=V.optionID and V.variantID in (8,11)) join `SS_product_options_values` as OV on (V.variantID=OV.variantID and productID=128)
UPDATE `SS_product_options_values` SET `count` = `count`-8 WHERE `productID` = 128 and variantID in (8,11)
INSERT INTO `SS_ordered_carts` SET `orderID`='5',`productID`='128',`name`='ЗИМНИЙ КОСТЮМ ОХОТНИКА(Размер:58-60, Рост:180-190)',`Price`='2780',`Quantity`='8'
UPDATE SS_products SET items_sold=items_sold+1, in_stock=in_stock-8 WHERE productID=128
SELECT P.name, Price, product_code, hurl, categoryID,email manager_email, online_name FROM SS_products as P LEFT JOIN SS_manager as M on (M.ID=P.managerID) WHERE productID=251
SELECT sum(`price_surplus`) price_surplus, GROUP_CONCAT(CONCAT(O.`name`,':',V.`name`) SEPARATOR ', ') variants FROM `SS_product_options` as O join `SS_products_opt_val_variants` as V on (O.optionID=V.optionID and V.variantID in (49,14)) join `SS_product_options_values` as OV on (V.variantID=OV.variantID and productID=251)
UPDATE `SS_product_options_values` SET `count` = `count`-1 WHERE `productID` = 251 and variantID in (49,14)
INSERT INTO `SS_ordered_carts` SET `orderID`='5',`productID`='251',`name`='ЗИМНИЙ КОСТЮМ Universal Размер 46-48(Цвет:цифра, Рост:175-185)',`Price`='2970',`Quantity`='1'
UPDATE SS_products SET items_sold=items_sold+1, in_stock=in_stock-1 WHERE productID=251
SELECT P.name, Price, product_code, hurl, categoryID,email manager_email, online_name FROM SS_products as P LEFT JOIN SS_manager as M on (M.ID=P.managerID) WHERE productID=127
SELECT sum(`price_surplus`) price_surplus, GROUP_CONCAT(CONCAT(O.`name`,':',V.`name`) SEPARATOR ', ') variants FROM `SS_product_options` as O join `SS_products_opt_val_variants` as V on (O.optionID=V.optionID and V.variantID in (8,11,14)) join `SS_product_options_values` as OV on (V.variantID=OV.variantID and productID=127)
UPDATE `SS_product_options_values` SET `count` = `count`-2 WHERE `productID` = 127 and variantID in (8,11,14)
INSERT INTO `SS_ordered_carts` SET `orderID`='5',`productID`='127',`name`='ЗИМНИЙ КОСТЮМ Universal(Цвет:цифра, Рост:180-190, Размер:58-60)',`Price`='3070',`Quantity`='2'
UPDATE SS_products SET items_sold=items_sold+1, in_stock=in_stock-2 WHERE productID=127
SELECT P.name, Price, product_code, hurl, categoryID,email manager_email, online_name FROM SS_products as P LEFT JOIN SS_manager as M on (M.ID=P.managerID) WHERE productID=205
SELECT sum(`price_surplus`) price_surplus, GROUP_CONCAT(CONCAT(O.`name`,':',V.`name`) SEPARATOR ', ') variants FROM `SS_product_options` as O join `SS_products_opt_val_variants` as V on (O.optionID=V.optionID and V.variantID in (8,11)) join `SS_product_options_values` as OV on (V.variantID=OV.variantID and productID=205)
UPDATE `SS_product_options_values` SET `count` = `count`-1 WHERE `productID` = 205 and variantID in (8,11)
INSERT INTO `SS_ordered_carts` SET `orderID`='5',`productID`='205',`name`='Зимний костюм \"Ирбис\"(Размер:58-60, Рост:180-190)',`Price`='4000',`Quantity`='1'
UPDATE SS_products SET items_sold=items_sold+1, in_stock=in_stock-1 WHERE productID=205
Shop-Script FREE «Lego Edition»
Приносим наши извинения!
В настоящее время ведуться технические работы на сервере.
Пожалуйста, зайдите позднее.
Project Homepage|Documentation|Support Forums
Раз уж это тестовый, то может обновитесь и поставите последнюю версию 6.1.2 !Обновился, заказ проходит, НО теперь нет допов ни в последней странице для клиента, ни в письме...только пустые скобочки
И не забывайте после изменений на сайте, чистить папку кеша.
Вашему заказу присвоен номер: 3
Заказчик: Саня ОООПР
Телефон: 6524
e-mail: [email protected]
Адрес: Уебск
Днаворпа 5
Наименование Количество Цена Сумма
Зимний костюм "Ирбис"() 5 3 900руб. 19 500руб.
ЗИМНИЙ КОСТЮМ Universal() 5 2 970руб. 14 850руб.
ЗИМНИЙ КОСТЮМ Universal Размер 46-48() 5 2 970руб. 14 850руб.
ЗИМНИЙ КОСТЮМ ОХОТНИКА() 4 2 680руб. 10 720руб.
ЗИМНИЙ КОСТЮМ РЫБОЛОВА() 4 2 370руб. 9 480руб.
Итого:
69 400руб.
Комментарий:
Мы свяжемся с Вами для подтверждения заказа в ближайшее время.
select name from SS_product_options where optionID=3
select povalt.name name, povt.count count, cast(250+IFNULL(povt.price_surplus,0) as decimal(10,2)) Price from SS_products_opt_val_variants as povalt left join SS_product_options_values as povt on povt.variantID=povalt.variantID where povalt.variantID=43 and productID=199
UPDATE `SS_product_options_values` SET `count`='-4' WHERE variantID=43
INSERT INTO `SS_ordered_carts` SET `orderID`='8',`productID`='199',`name`='Велобахилы(Размер:42-43)',`Price`='250.00',`Quantity`='4'
UPDATE SS_products SET items_sold=items_sold+1, in_stock=in_stock-4 WHERE productID=199
SELECT P.name, Price, product_code, hurl, categoryID,email manager_email, online_name FROM SS_products as P LEFT JOIN SS_manager as M on (M.ID=P.managerID) WHERE productID=181
select name from SS_product_options where optionID=8
select povalt.name name, povt.count count, cast(250+IFNULL(povt.price_surplus,0) as decimal(10,2)) Price from SS_products_opt_val_variants as povalt left join SS_product_options_values as povt on povt.variantID=povalt.variantID where povalt.variantID=27 and productID=181
UPDATE `SS_product_options_values` SET `count`='-3' WHERE variantID=27
INSERT INTO `SS_ordered_carts` SET `orderID`='8',`productID`='181',`name`='Веломайки(Размер:XL (52))',`Price`='250.00',`Quantity`='3'
UPDATE SS_products SET items_sold=items_sold+1, in_stock=in_stock-3 WHERE productID=181
SELECT P.name, Price, product_code, hurl, categoryID,email manager_email, online_name FROM SS_products as P LEFT JOIN SS_manager as M on (M.ID=P.managerID) WHERE productID=130
INSERT INTO `SS_ordered_carts` SET `orderID`='8',`productID`='130',`name`='Велорюкзак Universal Velo-50',`Price`='1800',`Quantity`='4'
UPDATE SS_products SET items_sold=items_sold+1, in_stock=in_stock-4 WHERE productID=130
SELECT P.name, Price, product_code, hurl, categoryID,email manager_email, online_name FROM SS_products as P LEFT JOIN SS_manager as M on (M.ID=P.managerID) WHERE productID=170
select name from SS_product_options where optionID=5
select povalt.name name, povt.count count, cast(840+IFNULL(povt.price_surplus,0) as decimal(10,2)) Price from SS_products_opt_val_variants as povalt left join SS_product_options_values as povt on povt.variantID=povalt.variantID where povalt.variantID=67 and productID=170
UPDATE `SS_product_options_values` SET `count`='-5' WHERE variantID=67
INSERT INTO `SS_ordered_carts` SET `orderID`='8',`productID`='170',`name`='Рюкзак \"Аэро-30\"(Цвет:красный)',`Price`='840.00',`Quantity`='5'
UPDATE SS_products SET items_sold=items_sold+1, in_stock=in_stock-5 WHERE productID=170
SELECT P.name, Price, product_code, hurl, categoryID,email manager_email, online_name FROM SS_products as P LEFT JOIN SS_manager as M on (M.ID=P.managerID) WHERE productID=170
select name from SS_product_options where optionID=5
select povalt.name name, povt.count count, cast(840+IFNULL(povt.price_surplus,0) as decimal(10,2)) Price from SS_products_opt_val_variants as povalt left join SS_product_options_values as povt on povt.variantID=povalt.variantID where povalt.variantID=68 and productID=170
UPDATE `SS_product_options_values` SET `count`='-5' WHERE variantID=68
INSERT INTO `SS_ordered_carts` SET `orderID`='8',`productID`='170',`name`='Рюкзак \"Аэро-30\"(Цвет:синий)',`Price`='840.00',`Quantity`='5'
UPDATE SS_products SET items_sold=items_sold+1, in_stock=in_stock-5 WHERE productID=170
SELECT P.name, Price, product_code, hurl, categoryID,email manager_email, online_name FROM SS_products as P LEFT JOIN SS_manager as M on (M.ID=P.managerID) WHERE productID=153
INSERT INTO `SS_ordered_carts` SET `orderID`='8',`productID`='153',`name`='Рюкзак \"Всегда с тобой\"',`Price`='360',`Quantity`='1'
UPDATE SS_products SET items_sold=items_sold+1, in_stock=in_stock-1 WHERE productID=153
SELECT P.name, Price, product_code, hurl, categoryID,email manager_email, online_name FROM SS_products as P LEFT JOIN SS_manager as M on (M.ID=P.managerID) WHERE productID=263
INSERT INTO `SS_ordered_carts` SET `orderID`='8',`productID`='263',`name`='\"CAMPER - 4\" /ROCK LAND/2012',`Price`='5970',`Quantity`='2'
UPDATE SS_products SET items_sold=items_sold+1, in_stock=in_stock-2 WHERE productID=263
SELECT P.name, Price, product_code, hurl, categoryID,email manager_email, online_name FROM SS_products as P LEFT JOIN SS_manager as M on (M.ID=P.managerID) WHERE productID=265
INSERT INTO `SS_ordered_carts` SET `orderID`='8',`productID`='265',`name`='\"FAMILY 4\"/ROCK LAND/2012',`Price`='7000',`Quantity`='5'
UPDATE SS_products SET items_sold=items_sold+1, in_stock=in_stock-5 WHERE productID=265
SELECT P.name, Price, product_code, hurl, categoryID,email manager_email, online_name FROM SS_products as P LEFT JOIN SS_manager as M on (M.ID=P.managerID) WHERE productID=205
select name from SS_product_options where optionID=3
select povalt.name name, povt.count count, cast(3900+IFNULL(povt.price_surplus,0) as decimal(10,2)) Price from SS_products_opt_val_variants as povalt left join SS_product_options_values as povt on povt.variantID=povalt.variantID where povalt.variantID=8 and productID=205
UPDATE `SS_product_options_values` SET `count`='-16' WHERE variantID=8
select name from SS_product_options where optionID=4
select povalt.name name, povt.count count, cast(4000.00+IFNULL(povt.price_surplus,0) as decimal(10,2)) Price from SS_products_opt_val_variants as povalt left join SS_product_options_values as povt on povt.variantID=povalt.variantID where povalt.variantID=11 and productID=205
UPDATE `SS_product_options_values` SET `count`='-24' WHERE variantID=11
INSERT INTO `SS_ordered_carts` SET `orderID`='8',`productID`='205',`name`='Зимний костюм \"Ирбис\"(Размер:58-60,Рост:180-190)',`Price`='4000.00',`Quantity`='2'
UPDATE SS_products SET items_sold=items_sold+1, in_stock=in_stock-2 WHERE productID=205
SELECT P.name, Price, product_code, hurl, categoryID,email manager_email, online_name FROM SS_products as P LEFT JOIN SS_manager as M on (M.ID=P.managerID) WHERE productID=127
select name from SS_product_options where optionID=3
select povalt.name name, povt.count count, cast(2970+IFNULL(povt.price_surplus,0) as decimal(10,2)) Price from SS_products_opt_val_variants as povalt left join SS_product_options_values as povt on povt.variantID=povalt.variantID where povalt.variantID=8 and productID=127
UPDATE `SS_product_options_values` SET `count`='-19' WHERE variantID=8
select name from SS_product_options where optionID=4
select povalt.name name, povt.count count, cast(3070.00+IFNULL(povt.price_surplus,0) as decimal(10,2)) Price from SS_products_opt_val_variants as povalt left join SS_product_options_values as povt on povt.variantID=povalt.variantID where povalt.variantID=11 and productID=127
UPDATE `SS_product_options_values` SET `count`='-27' WHERE variantID=11
select name from SS_product_options where optionID=5
select povalt.name name, povt.count count, cast(3070.00+IFNULL(povt.price_surplus,0) as decimal(10,2)) Price from SS_products_opt_val_variants as povalt left join SS_product_options_values as povt on povt.variantID=povalt.variantID where povalt.variantID=13 and productID=127
UPDATE `SS_product_options_values` SET `count`='-8' WHERE variantID=13
INSERT INTO `SS_ordered_carts` SET `orderID`='8',`productID`='127',`name`='ЗИМНИЙ КОСТЮМ Universal(Размер:58-60,Рост:180-190,Цвет:зимний лес)',`Price`='3070.00',`Quantity`='3'
UPDATE SS_products SET items_sold=items_sold+1, in_stock=in_stock-3 WHERE productID=127
SELECT P.name, Price, product_code, hurl, categoryID,email manager_email, online_name FROM SS_products as P LEFT JOIN SS_manager as M on (M.ID=P.managerID) WHERE productID=128
select name from SS_product_options where optionID=3
select povalt.name name, povt.count count, cast(2680+IFNULL(povt.price_surplus,0) as decimal(10,2)) Price from SS_products_opt_val_variants as povalt left join SS_product_options_values as povt on povt.variantID=povalt.variantID where povalt.variantID=8 and productID=128
UPDATE `SS_product_options_values` SET `count`='-24' WHERE variantID=8
select name from SS_product_options where optionID=4
select povalt.name name, povt.count count, cast(2780.00+IFNULL(povt.price_surplus,0) as decimal(10,2)) Price from SS_products_opt_val_variants as povalt left join SS_product_options_values as povt on povt.variantID=povalt.variantID where povalt.variantID=11 and productID=128
UPDATE `SS_product_options_values` SET `count`='-32' WHERE variantID=11
INSERT INTO `SS_ordered_carts` SET `orderID`='8',`productID`='128',`name`='ЗИМНИЙ КОСТЮМ ОХОТНИКА(Размер:58-60,Рост:180-190)',`Price`='2780.00',`Quantity`='5'
UPDATE SS_products SET items_sold=items_sold+1, in_stock=in_stock-5 WHERE productID=128
SELECT P.name, Price, product_code, hurl, categoryID,email manager_email, online_name FROM SS_products as P LEFT JOIN SS_manager as M on (M.ID=P.managerID) WHERE productID=126
select name from SS_product_options where optionID=3
select povalt.name name, povt.count count, cast(2370+IFNULL(povt.price_surplus,0) as decimal(10,2)) Price from SS_products_opt_val_variants as povalt left join SS_product_options_values as povt on povt.variantID=povalt.variantID where povalt.variantID=8 and productID=126
UPDATE `SS_product_options_values` SET `count`='-26' WHERE variantID=8
select name from SS_product_options where optionID=4
select povalt.name name, povt.count count, cast(2470.00+IFNULL(povt.price_surplus,0) as decimal(10,2)) Price from SS_products_opt_val_variants as povalt left join SS_product_options_values as povt on povt.variantID=povalt.variantID where povalt.variantID=11 and productID=126
UPDATE `SS_product_options_values` SET `count`='-34' WHERE variantID=11
INSERT INTO `SS_ordered_carts` SET `orderID`='8',`productID`='126',`name`='ЗИМНИЙ КОСТЮМ РЫБОЛОВА(Размер:58-60,Рост:180-190)',`Price`='2470.00',`Quantity`='2'
UPDATE SS_products SET items_sold=items_sold+1, in_stock=in_stock-2 WHERE productID=126
далее