Borgas

Works like a charm Just copy mails/_partials to YOURTHEME/MAILS/LANGUAGES Edit as you wich

Hello Any solution for 1.7.8? Hello Already create the Orderhistory.php overide Can you point where is the sendemail function? I would like to send email with products that customer bought with a link I have {products} in modern theme, but is not showing nothing PS 1.7.8

Hello Prestashop version 1.7.8 Is it possible to insert in email theme (modern) the products that customer buy? I would like the customer get the list of prodcuts, even after order confirmation sent. And able to click on them and go to product page. I tried {meta_products} and {products} with no sucess Thank you

Hi Knacky Is it possible to point some how, how to extract from orders? I have one product with combinations, how can i get them but from orders. Thank you

Works great in 1.7.6 Is there a way to filter by id the feature? {if $feature.id_feature == 1 OR $feature.id_feature == 10 OR $feature.id_feature == 20 } This doens´t work in checkout, only in product pages

Hi After upgrade from 1.7.5 to 1.7.6 if you import anything from advance parameter - import, after job done the page doesn´t return to import configuration again. You have a clean page as i show in attachement

Hello I did manage to insert on list info such as phone ou phone mobile But when i try to put "company" the result is ambiguos I don´t want to enable B2B, because field "company" is beeing used for other info

Hi Forum Prestashop 1.6.1.18 I have a SQL request to export all orders with products to csv: SELECT d.id_order AS ID_Registo, o.reference AS ref, os.name AS Estado_Pagamento, o.date_upd AS Data, d.product_name AS Produto, d.product_reference AS Referencia, d.product_quantity AS Quantidade, d.product_price AS Preco_Produto, ai.company AS Matricula, CONCAT_WS( ' ', g.firstname, g.lastname ) AS Nome_Cliente, CONCAT_WS(' ', ad.address1, ad.address2, ad.other, ad.phone, ad.phone_mobile) AS Morada, ad.postcode AS Cod_Postal, ad.city AS Localidade, CONCAT_WS(' ', ai.address1, ai.address2, ai.other) AS Morada, g.email AS Email, ai.phone AS Telefone, ai.phone_mobile AS Telemóvel FROM psha_order_detail d LEFT JOIN psha_orders o ON ( d.id_order = o.id_order ) LEFT JOIN psha_customer g ON ( o.id_customer = g.id_customer ) LEFT JOIN psha_stock_available s ON (d.product_id = s.id_product) LEFT JOIN psha_address ad ON (o.id_address_delivery = ad.id_address) LEFT JOIN psha_address ai ON (o.id_address_invoice = ai.id_address) LEFT JOIN psha_group_lang gl ON ( g.id_default_group = gl.id_group ) LEFT JOIN psha_order_state_lang os ON ( o.current_state = os.id_order_state ) WHERE os.id_lang =1 GROUP BY d.id_order, d.product_name ORDER BY d.id_order DESC But 1 (only) product as a custom field. How can i show it on list/request??

Hi Forum I manage to add Carrier to Orders List, saving a file named "AdminOrdersController.php" inside override/controllers/admin and this works showing the Carrier in order list Can you help me how can i show the custom field saved in cart before order??? PS 1.6.1.18 <?php class AdminOrdersController extends AdminOrdersControllerCore { public function __construct() { $this->bootstrap = true; $this->table = 'order'; $this->className = 'Order'; $this->lang = false; $this->addRowAction('view'); $this->explicitSelect = true; $this->allow_export = true; $this->deleted = false; $this->context = Context::getContext(); $this->_select = ' a.id_currency, a.id_order AS id_pdf, CONCAT(LEFT(c.`firstname`, 1), \'. \', c.`lastname`) AS `customer`, osl.`name` AS `osname`, IF(carrier.`name` = "0", "-", carrier.`name`) AS `carriername`, os.`color`, IF((SELECT so.id_order FROM `'._DB_PREFIX_.'orders` so WHERE so.id_customer = a.id_customer AND so.id_order < a.id_order LIMIT 1) > 0, 0, 1) as new, country_lang.name as cname, IF(a.valid, 1, 0) badge_success'; $this->_join = ' LEFT JOIN `'._DB_PREFIX_.'customer` c ON (c.`id_customer` = a.`id_customer`) LEFT JOIN `'._DB_PREFIX_.'address` address ON address.id_address = a.id_address_delivery LEFT JOIN `'._DB_PREFIX_.'country` country ON address.id_country = country.id_country LEFT JOIN `'._DB_PREFIX_.'country_lang` country_lang ON (country.`id_country` = country_lang.`id_country` AND country_lang.`id_lang` = '.(int)$this->context->language->id.') LEFT JOIN `'._DB_PREFIX_.'carrier` carrier ON a.id_carrier = carrier.id_carrier LEFT JOIN `'._DB_PREFIX_.'order_state` os ON (os.`id_order_state` = a.`current_state`) LEFT JOIN `'._DB_PREFIX_.'order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = '.(int)$this->context->language->id.')'; $this->_orderBy = 'id_order'; $this->_orderWay = 'DESC'; $this->_use_found_rows = true; $statuses = OrderState::getOrderStates((int)$this->context->language->id); foreach ($statuses as $status) { $this->statuses_array[$status['id_order_state']] = $status['name']; } $this->fields_list = array( 'id_order' => array( 'title' => $this->l('ID'), 'align' => 'text-center', 'class' => 'fixed-width-xs' ), 'reference' => array( 'title' => $this->l('Reference') ), 'new' => array( 'title' => $this->l('New client'), 'align' => 'text-center', 'type' => 'bool', 'tmpTableFilter' => true, 'orderby' => false, 'callback' => 'printNewCustomer' ), 'customer' => array( 'title' => $this->l('Customer'), 'havingFilter' => true, ), ); if (Configuration::get('PS_B2B_ENABLE')) { $this->fields_list = array_merge($this->fields_list, array( 'company' => array( 'title' => $this->l('Company'), 'filter_key' => 'c!company' ), )); } $this->fields_list = array_merge($this->fields_list, array( 'total_paid_tax_incl' => array( 'title' => $this->l('Total'), 'align' => 'text-right', 'type' => 'price', 'currency' => true, 'callback' => 'setOrderCurrency', 'badge_success' => true ), 'payment' => array( 'title' => $this->l('Payment') ), 'carriername' => array( 'title' => $this->l('Carrier'), 'type' => 'text', 'align' => 'text-center', 'class' => 'fixed-width-xl', 'filter_key' => 'carrier!name', 'filter_type' => 'text', 'order_key' => 'carrier!name' ), 'osname' => array( 'title' => $this->l('Status'), 'type' => 'select', 'color' => 'color', 'list' => $this->statuses_array, 'filter_key' => 'os!id_order_state', 'filter_type' => 'int', 'order_key' => 'osname' ), 'date_add' => array( 'title' => $this->l('Date'), 'align' => 'text-right', 'type' => 'datetime', 'filter_key' => 'a!date_add' ), 'id_pdf' => array( 'title' => $this->l('PDF'), 'align' => 'text-center', 'callback' => 'printPDFIcons', 'orderby' => false, 'search' => false, 'remove_onclick' => true ) )); if (Country::isCurrentlyUsed('country', true)) { $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS(' SELECT DISTINCT c.id_country, cl.`name` FROM `'._DB_PREFIX_.'orders` o '.Shop::addSqlAssociation('orders', 'o').' INNER JOIN `'._DB_PREFIX_.'address` a ON a.id_address = o.id_address_delivery INNER JOIN `'._DB_PREFIX_.'country` c ON a.id_country = c.id_country INNER JOIN `'._DB_PREFIX_.'country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = '.(int)$this->context->language->id.') ORDER BY cl.name ASC'); $country_array = array(); foreach ($result as $row) { $country_array[$row['id_country']] = $row['name']; } $part1 = array_slice($this->fields_list, 0, 3); $part2 = array_slice($this->fields_list, 3); $part1['cname'] = array( 'title' => $this->l('Delivery'), 'type' => 'select', 'list' => $country_array, 'filter_key' => 'country!id_country', 'filter_type' => 'int', 'order_key' => 'cname' ); $this->fields_list = array_merge($part1, $part2); } $this->shopLinkType = 'shop'; $this->shopShareDatas = Shop::SHARE_ORDER; if (Tools::isSubmit('id_order')) { // Save context (in order to apply cart rule) $order = new Order((int)Tools::getValue('id_order')); $this->context->cart = new Cart($order->id_cart); $this->context->customer = new Customer($order->id_customer); } $this->bulk_actions = array( 'updateOrderStatus' => array('text' => $this->l('Change Order Status'), 'icon' => 'icon-refresh') ); AdminController::__construct(); } }

Se está a utilizar o template do prestashop o mais certo é o formato csv estar errado Após criar o csv em excel, abra o ficheiro com o notepad do windows e "gravar como" e veja se o formato está em UTF-8

Obrigado pela resposta. Essa parte eu sei de atribuir nomes para identificar os divs. O que pretendia era inserir uma imagem "atrás" do div page. Mas resolvi o problema modules/themeconfigurator/theme4.css .columns-container { background: url(../img/footer.png) bottom no-repeat; background-color:#FFF; }

Já consegui adicionar a imagem conforme queria, mas não faz os 100% de largura como pretendia... modules/themeconfigurator/theme4.css .columns-container { background: url(../img/footer.png) bottom no-repeat; background-color:#FFF; }

Olá A usar o tema original em Prestashop 1.6.1.10 Queria adicionar um "div" antes do "footer" a cinza escura, de forma a aparecer uma imagem de rodapé em toda a largura A inserir na "zona" marcada a amarelo conforme a imagem em anexo Tenho alguns conhecimentos de css e uso dreamweaver

O ideal é visualizar através do Firefox e usar a consola de "code inspector"... Com isso saberá sempre qual o ficheiro a modificar