Focto

Есть мультимагазин оптовый и розничный (на OcShop). Создал 2 покупателей (оптового и розничного). Оба покупателя могут авторизироваться как в рознице так и в оптовом магазине. Как сделать авторизацию Оптовых покупателей только в оптовом магазине, а розничных только в розничном? У каждого покупателя в столбце store_id таблицы oc_customer проставлены соответствующие id магазинов.

Спасибо!

Как сделать редирект на главную страницу, а не в личный кабинет при входе на сайт ?

После установки на сайт TurboCache, со временем в меню главная категория (Каталог товаров) имеет class="active", даже если указатель мыши не наведен. (OcShop 1.5.6.3.1, шаблон Rubber ) Исправляется очисткой кэша, Если ли другое способы, чтобы постоянно не чистить кэш из-за этого?

Здравствуйте! Существуют ли API на Opencart для взаимодействия с базами данных?

Спасибо за модуль!!!

Здравствуйте! Такая ситуация, в интернет-магазине есть Оптовые покупатели и есть Розничные. Нужно чтобы при заказе от розничного покупателя заявка приходила на один email, а от оптового на другой. Есть ли какие-нибудь модули, которые могут это осуществить? Можно это реализовать Мультимагазином, например для оптовиков сделать свой сайт (opt.site.ru) а для розницы (site.ru)?

Скорее всего не настроен фильтр для той категории в которой его не видно. Я делал так, создавал группы фильтров с аналогичными названиями Категорий каталога и в каждой группе указывал к каким категориям товаров они относятся. Затем создавал сами фильтры, которые в свою очередь приписывал к группам фильтров в поле entry_coolfilter_groups. Если не помогло, посмотри логи, может где-то ошибки.

А как добавлял остальные?

Подскажите, как добавить в модуль фильтрацию по наличию? Я думаю это очень актуально, особенно для большого количества товаров.

Дополнения - Модули - Фильтр товаров Coolfilter, количество товаров.

сократил до Total time 2.2479 seconds | Total queries:41 убрав в модуле подсчет товаров.

TurboCache поможет???

Почему такие долгие запросы Total time 31.1422 seconds | Total queries:68 query time:0.0792 seconds | controller: ControllerModuleCoolfilter SELECT MIN(pr.price) as min, MAX(pr.price) as max, MIN((SELECT pd2.price FROM oc_product_discount pd2 WHERE pd2.product_id = pr.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1)) AS discount, MIN((SELECT ps.price FROM oc_product_special ps WHERE ps.product_id = pr.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1)) AS special FROM `oc_product` pr LEFT JOIN `oc_product_to_category` ct ON (pr.product_id = ct.product_id) WHERE pr.status = 1 AND ct.category_id IN (126,144,145,146,147,148,149,150,151,152,143,142,129,128,127,130,131,132,133,134,135,141,140,139,138,137,136) query time:1.056 seconds | controller: ControllerModuleCoolfilter SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN (SELECT pr.product_id, pr.price, (SELECT pd2.price FROM `oc_product_discount` pd2 WHERE pd2.product_id = pr.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) discount, (SELECT ps.price FROM `oc_product_special` ps WHERE ps.product_id = pr.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) special FROM `oc_product` pr LEFT JOIN `oc_product_to_category` ct ON (pr.product_id = ct.product_id) WHERE pr.status = '1') tb ON (p.product_id = tb.product_id) LEFT JOIN oc_product_filter parp_4 ON (p.product_id = parp_4.product_id) LEFT JOIN oc_filter_description fdp_4 ON (parp_4.filter_id = fdp_4.filter_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '126'AND tb.price >= '0' AND (tb.discount IS NULL OR tb.discount >= '0') AND (tb.special IS NULL OR tb.special >= '0') AND tb.price <= '9999999' AND (tb.discount IS NULL OR tb.discount <= '9999999') AND (tb.special IS NULL OR tb.special <= '9999999') AND (fdp_4.language_id = '1' AND parp_4.filter_id IN ('29')) query time:1.0385 seconds | controller: ControllerModuleCoolfilter SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN (SELECT pr.product_id, pr.price, (SELECT pd2.price FROM `oc_product_discount` pd2 WHERE pd2.product_id = pr.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) discount, (SELECT ps.price FROM `oc_product_special` ps WHERE ps.product_id = pr.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) special FROM `oc_product` pr LEFT JOIN `oc_product_to_category` ct ON (pr.product_id = ct.product_id) WHERE pr.status = '1') tb ON (p.product_id = tb.product_id) LEFT JOIN oc_product_filter parp_4 ON (p.product_id = parp_4.product_id) LEFT JOIN oc_filter_description fdp_4 ON (parp_4.filter_id = fdp_4.filter_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '126'AND tb.price >= '96382' AND (tb.discount IS NULL OR tb.discount >= '96382') AND (tb.special IS NULL OR tb.special >= '96382') AND tb.price <= '9999999' AND (tb.discount IS NULL OR tb.discount <= '9999999') AND (tb.special IS NULL OR tb.special <= '9999999') AND (fdp_4.language_id = '1' AND parp_4.filter_id IN ('29')) query time:0.0005 seconds | controller: ControllerModuleCoolfilter SELECT DISTINCT f.filter_id as value, f.filter_group_id as id, fd.name as name FROM `oc_filter` f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) WHERE f.filter_group_id IN (3,2,5,4) AND language_id = '1' ORDER BY f.sort_order query time:1.0834 seconds | controller: ControllerModuleCoolfilter SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN (SELECT pr.product_id, pr.price, (SELECT pd2.price FROM `oc_product_discount` pd2 WHERE pd2.product_id = pr.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) discount, (SELECT ps.price FROM `oc_product_special` ps WHERE ps.product_id = pr.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) special FROM `oc_product` pr LEFT JOIN `oc_product_to_category` ct ON (pr.product_id = ct.product_id) WHERE pr.status = '1') tb ON (p.product_id = tb.product_id) LEFT JOIN oc_product_filter parp_4 ON (p.product_id = parp_4.product_id) LEFT JOIN oc_filter_description fdp_4 ON (parp_4.filter_id = fdp_4.filter_id) LEFT JOIN oc_product_filter parp_2 ON (p.product_id = parp_2.product_id) LEFT JOIN oc_filter_description fdp_2 ON (parp_2.filter_id = fdp_2.filter_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '126'AND tb.price >= '0' AND (tb.discount IS NULL OR tb.discount >= '0') AND (tb.special IS NULL OR tb.special >= '0') AND tb.price <= '96382' AND (tb.discount IS NULL OR tb.discount <= '96382') AND (tb.special IS NULL OR tb.special <= '96382') AND (fdp_4.language_id = '1' AND parp_4.filter_id IN ('29')) AND (fdp_2.language_id = '1' AND parp_2.filter_id IN ('7')) query time:1.0288 seconds | controller: ControllerModuleCoolfilter SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN (SELECT pr.product_id, pr.price, (SELECT pd2.price FROM `oc_product_discount` pd2 WHERE pd2.product_id = pr.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) discount, (SELECT ps.price FROM `oc_product_special` ps WHERE ps.product_id = pr.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) special FROM `oc_product` pr LEFT JOIN `oc_product_to_category` ct ON (pr.product_id = ct.product_id) WHERE pr.status = '1') tb ON (p.product_id = tb.product_id) LEFT JOIN oc_product_filter parp_4 ON (p.product_id = parp_4.product_id) LEFT JOIN oc_filter_description fdp_4 ON (parp_4.filter_id = fdp_4.filter_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '126'AND tb.price >= '0' AND (tb.discount IS NULL OR tb.discount >= '0') AND (tb.special IS NULL OR tb.special >= '0') AND tb.price <= '96382' AND (tb.discount IS NULL OR tb.discount <= '96382') AND (tb.special IS NULL OR tb.special <= '96382') AND (fdp_4.language_id = '1' AND parp_4.filter_id IN ('28')) query time:1.027 seconds | controller: ControllerModuleCoolfilter SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN (SELECT pr.product_id, pr.price, (SELECT pd2.price FROM `oc_product_discount` pd2 WHERE pd2.product_id = pr.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) discount, (SELECT ps.price FROM `oc_product_special` ps WHERE ps.product_id = pr.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) special FROM `oc_product` pr LEFT JOIN `oc_product_to_category` ct ON (pr.product_id = ct.product_id) WHERE pr.status = '1') tb ON (p.product_id = tb.product_id) LEFT JOIN oc_product_filter parp_4 ON (p.product_id = parp_4.product_id) LEFT JOIN oc_filter_description fdp_4 ON (parp_4.filter_id = fdp_4.filter_id) LEFT JOIN oc_product_filter parp_2 ON (p.product_id = parp_2.product_id) LEFT JOIN oc_filter_description fdp_2 ON (parp_2.filter_id = fdp_2.filter_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '126'AND tb.price >= '0' AND (tb.discount IS NULL OR tb.discount >= '0') AND (tb.special IS NULL OR tb.special >= '0') AND tb.price <= '96382' AND (tb.discount IS NULL OR tb.discount <= '96382') AND (tb.special IS NULL OR tb.special <= '96382') AND (fdp_4.language_id = '1' AND parp_4.filter_id IN ('29')) AND (fdp_2.language_id = '1' AND parp_2.filter_id IN ('6')) query time:1.0224 seconds | controller: ControllerModuleCoolfilter SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN (SELECT pr.product_id, pr.price, (SELECT pd2.price FROM `oc_product_discount` pd2 WHERE pd2.product_id = pr.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) discount, (SELECT ps.price FROM `oc_product_special` ps WHERE ps.product_id = pr.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) special FROM `oc_product` pr LEFT JOIN `oc_product_to_category` ct ON (pr.product_id = ct.product_id) WHERE pr.status = '1') tb ON (p.product_id = tb.product_id) LEFT JOIN oc_product_filter parp_4 ON (p.product_id = parp_4.product_id) LEFT JOIN oc_filter_description fdp_4 ON (parp_4.filter_id = fdp_4.filter_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '126'AND tb.price >= '0' AND (tb.discount IS NULL OR tb.discount >= '0') AND (tb.special IS NULL OR tb.special >= '0') AND tb.price <= '96382' AND (tb.discount IS NULL OR tb.discount <= '96382') AND (tb.special IS NULL OR tb.special <= '96382') AND (fdp_4.language_id = '1' AND parp_4.filter_id IN ('27')) и тд.. и как это исправить?

Мне нужно чтобы клиенту приходило HTML письмо, а админу XLS (или CSV) файл в письме, автоматически.

Есть ли какие-нибудь модули (платные или бесплатные) для отправки заказа на почту в виде xls или csv? Например покупатель оформил заказ, ему на почту приходит заказ в виде html(стандартный) и администратору в виде xls или csv-файла.

Проделал все как указано выше, столбец отображается, но пустой и в таблице БД в столбце sku нет данных. В чем может быть причина?

данная ошибка поялвяется потому что в в таблице oc_order_product нет столбца upc

Добавил в foreach ($data['products'] as $product) { upc = '" . $this->db->escape($product['upc']) . "', в файле /catalog/model/checkout/order.php стало так: foreach ($data['products'] as $product) { $this->db->query("INSERT INTO " . DB_PREFIX . "order_product SET order_id = '" . (int)$order_id . "', product_id = '" . (int)$product['product_id'] . "', name = '" . $this->db->escape($product['name']) . "', model = '" . $this->db->escape($product['model']) . "', quantity = '" . (int)$product['quantity'] . "', upc = '" . $this->db->escape($product['upc']) . "', price = '" . (float)$product['price'] . "', total = '" . (float)$product['total'] . "', tax = '" . (float)$product['tax'] . "', reward = '" . (int)$product['reward'] . "'"); $order_product_id = $this->db->getLastId(); при нажатии подтвердить выскакивает сообщение Notice: Undefined index: upc in .../catalog/model/checkout/order.php on line 9Notice: Error: Unknown column 'upc' in 'field list' Error No: 1054 INSERT INTO oc_order_product SET order_id = '36', product_id = '56', name = 'Товар', model = '023500000', quantity = '1', upc = '', price = '100', total = '100', tax = '0', reward = '0' in .../system/database/mysql.php on line 50

Разобрался с добавление company_id. В файле /catalog/model/checkout/order.php, добавил '{company}' и 'company_id' => $order_info['payment_company_id'] было if ($order_info['payment_address_format']) { $format = $order_info['payment_address_format']; } else { $format = '{firstname} {lastname}' . "\n" . '{company}' . "\n" . '{address_1}' . "\n" . '{address_2}' . "\n" . '{city} {postcode}' . "\n" . '{zone}' . "\n" . '{country}'; } $find = array( '{firstname}', '{lastname}', '{company}', '{address_1}', '{address_2}', '{city}', '{postcode}', '{zone}', '{zone_code}', '{country}' ); $replace = array( 'firstname' => $order_info['payment_firstname'], 'lastname' => $order_info['payment_lastname'], 'company' => $order_info['payment_company'], 'address_1' => $order_info['payment_address_1'], 'address_2' => $order_info['payment_address_2'], 'city' => $order_info['payment_city'], 'postcode' => $order_info['payment_postcode'], 'zone' => $order_info['payment_zone'], 'zone_code' => $order_info['payment_zone_code'], 'country' => $order_info['payment_country'] ); стало if ($order_info['payment_address_format']) { $format = $order_info['payment_address_format']; } else { $format = '{firstname} {lastname}' . "\n" . '{company}' . "\n" . '{company_id}' . "\n" . '{address_1}' . "\n" . '{address_2}' . "\n" . '{city} {postcode}' . "\n" . '{zone}' . "\n" . '{country}'; } $find = array( '{firstname}', '{lastname}', '{company}', '{company_id}', '{address_1}', '{address_2}', '{city}', '{postcode}', '{zone}', '{zone_code}', '{country}' ); $replace = array( 'firstname' => $order_info['payment_firstname'], 'lastname' => $order_info['payment_lastname'], 'company' => $order_info['payment_company'], 'company_id' => $order_info['payment_company_id'], 'address_1' => $order_info['payment_address_1'], 'address_2' => $order_info['payment_address_2'], 'city' => $order_info['payment_city'], 'postcode' => $order_info['payment_postcode'], 'zone' => $order_info['payment_zone'], 'zone_code' => $order_info['payment_zone_code'], 'country' => $order_info['payment_country'] ); в том же файле только ниже, было $template->data['payment_address'] = str_replace(array("\r\n", "\r", "\n"), '<br />', preg_replace(array("/\s\s+/", "/\r\r+/", "/\n\n+/"), '<br />', trim(str_replace($find, $replace, $format)))); if ($order_info['shipping_address_format']) { $format = $order_info['shipping_address_format']; } else { $format = '{firstname} {lastname}' . "\n" . '{company}' . "\n" . '{address_1}' . "\n" . '{address_2}' . "\n" . '{city} {postcode}' . "\n" . '{zone}' . "\n" . '{country}'; } $find = array( '{firstname}', '{lastname}', '{company}', '{address_1}', '{address_2}', '{city}', '{postcode}', '{zone}', '{zone_code}', '{country}' ); $replace = array( 'firstname' => $order_info['shipping_firstname'], 'lastname' => $order_info['shipping_lastname'], 'company' => $order_info['shipping_company'], 'address_1' => $order_info['shipping_address_1'], 'address_2' => $order_info['shipping_address_2'], 'city' => $order_info['shipping_city'], 'postcode' => $order_info['shipping_postcode'], 'zone' => $order_info['shipping_zone'], 'zone_code' => $order_info['shipping_zone_code'], 'country' => $order_info['shipping_country'] ); стало $template->data['payment_address'] = str_replace(array("\r\n", "\r", "\n"), '<br />', preg_replace(array("/\s\s+/", "/\r\r+/", "/\n\n+/"), '<br />', trim(str_replace($find, $replace, $format)))); if ($order_info['shipping_address_format']) { $format = $order_info['shipping_address_format']; } else { $format = '{firstname} {lastname}' . "\n" . '{company}' . "\n" . '{company_id}' . "\n" . '{address_1}' . "\n" . '{address_2}' . "\n" . '{city} {postcode}' . "\n" . '{zone}' . "\n" . '{country}'; } $find = array( '{firstname}', '{lastname}', '{company}', '{company_id}', '{address_1}', '{address_2}', '{city}', '{postcode}', '{zone}', '{zone_code}', '{country}' ); $replace = array( 'firstname' => $order_info['shipping_firstname'], 'lastname' => $order_info['shipping_lastname'], 'company' => $order_info['shipping_company'], 'company_id' => $order_info['payment_company_id'], 'address_1' => $order_info['shipping_address_1'], 'address_2' => $order_info['shipping_address_2'], 'city' => $order_info['shipping_city'], 'postcode' => $order_info['shipping_postcode'], 'zone' => $order_info['shipping_zone'], 'zone_code' => $order_info['shipping_zone_code'], 'country' => $order_info['shipping_country'] );

Нужно добавить вывод значения из company_id между Компания и Адрес (в таблицу Информация о покупателе) и столбец значения 'upc' между столбцами количество и цена в таблице Товар? Знаю что надо смотреть в /catalog/model/checkout/order.php и /catalog/view/theme/шаблон/template/checkout/checkout.tpl, пытался сделать по аналогии с Адресом и названием компании, но ничего не вышло. Помогите, пожалуйста!

Это может быть подсчет товаров в каждой подкатегории?

Индексы проставлял согласно этой статьи http://ocshop.info/tormozit-opencart-chast-2/

Скажите, почему такие долгие запросы query time:0.1718 seconds | controller: ControllerProductCategory в Корне каталога? Как это испровить? Поможет ли TurboCache?

Спасибо!!! Буду двигаться в этом направлении.