Jump to content

thejackal

Members
  • Posts

    1
  • Joined

  • Last visited

Everything posted by thejackal

  1. Hi, Currently most of the themes are grid and list based with pictures. I am trying to do a B2B site that is strictly table-based without pictures . Is there such a theme available? Many thanks!
  2. No, the source code was original and I didn't touch it. Maybe I cut and pasted it weird in the forum, but the code was exactly the way you put it above in order-edit.php. Do you think this has anything to do with me setting up as multi-shop?
  3. Hi, I get the following error when trying to 'add product' in 'edit order'. Notice: Undefined index: id_tax in /home/xxx/xxxx/store/admin-xxx/triple_edit/order-edit.php on line 121 MySQL error 1054: Unknown column 'pl.name' in 'field list' Generated by URL '/store/admin-xxx/triple_edit/order-edit.php' with Query 'select p.weight,p.ean13,p.upc,p.reference,p.supplier_reference,p.quantity, ps.*,pl.name,pl.id_lang,l.iso_code,t.rate as tax_rate,t.id_tax, tl.name as tax_name from ps_product_shop ps left join ps_product p on p.id_product=ps.id_product left join ps_lang l on pl.id_lang=l.id_lang left join ps_tax_rule tr on tr.id_tax_rules_group=ps.id_tax_rules_group AND tr.id_country='21' AND tr.id_state='0' left join ps_tax t on t.id_tax=tr.id_tax left join ps_tax_lang tl on t.id_tax=tl.id_tax AND tl.id_lang='1' WHERE ps.id_shop='1' AND ps.id_product='176' ' I am using prestashop 1.5.6.2 Thanks for any help!
  4. To solve the duplicate categories showing up in multi-shop configurations, modify in /modules/homecategories/homecategories.php: Replace function hookHome($params) { global $smarty, $cookie, $link; $id_customer = (int)$params['cookie']->id_customer; $id_group = $id_customer ? Customer::getDefaultGroupId($id_customer) : _PS_DEFAULT_CUSTOMER_GROUP_; $id_lang = (int)$params['cookie']->id_lang; $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS(' SELECT c.*, cl.* FROM `'._DB_PREFIX_.'category` c LEFT JOIN `'._DB_PREFIX_.'category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = '.$id_lang.') LEFT JOIN `'._DB_PREFIX_.'category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE level_depth > 1 And level_depth < 3 AND c.`active` = 1 AND cg.`id_group` = '.$id_group.' With function hookHome($params) { global $smarty, $cookie, $link; $shop_id = (int)$this->context->shop->id; $id_customer = (int)$params['cookie']->id_customer; $id_group = $id_customer ? Customer::getDefaultGroupId($id_customer) : _PS_DEFAULT_CUSTOMER_GROUP_; $id_lang = (int)$params['cookie']->id_lang; $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS(' SELECT c.*, cl.* FROM `'._DB_PREFIX_.'category` c LEFT JOIN `'._DB_PREFIX_.'category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = '.$id_lang.') LEFT JOIN `'._DB_PREFIX_.'category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE level_depth > 1 And level_depth < 3 AND c.`active` = 1 AND cg.`id_group` = '.$id_group.' AND cl.`id_shop` = '.$shop_id.'
×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More