newbie_prestashop

Hi, Problem while saving custom field which is add in cart rule condition . Created one field 'usertype' in ps_cart_rule table..also define in cartrule.php like public $usertype; 'usertype' => array('type' => self::TYPE_INT), in condition.tpl i have write, <select name="selecttype"> <option value="0"> Select Type </option> {foreach from=$resultstype item=type} <option value="{$type['id']}"> {$type['name']}</option> {/foreach} </select> where can i write code for save selecttype?

Hi,, How can i add phone no on orders tab back office? Some changes done in adminorderscontroller.php add in query select ad.phone_mobile and LEFT JOIN `'._DB_PREFIX_.'address` ad ON (ad.`id_customer` = a.`id_customer`) like $this->_select = ' a.id_currency, a.id_order AS id_pdf, CONCAT(LEFT(c.`firstname`, 1), \'. \', c.`lastname`) AS `customer`, osl.`name` AS `osname`, os.`color`, IF((SELECT COUNT(so.id_order) FROM `'._DB_PREFIX_.'orders` so WHERE so.id_customer = a.id_customer) > 1, 0, 1) as new,ad.phone_mobile'; $this->_join = ' LEFT JOIN `'._DB_PREFIX_.'customer` c ON (c.`id_customer` = a.`id_customer`) 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.') LEFT JOIN `'._DB_PREFIX_.'address` ad ON (ad.`id_customer` = a.`id_customer`) '; $this->_orderBy = 'id_order'; $this->_orderWay = 'DESC'; and 'phone_mobile' => array( 'title' => $this->l('phone'), 'width' => 140, ), its working but there is some orders is repeated in list. Can anyone sugguest solution.

Hi, I have added two custom field in order-carrier tpl page, id_is,name_is. It is saving this field values in ps_cart,ps_orders tbl in five steps checkout..but when Order process type is "one page checkout" it is not saving...any solution? 1. add field to table ps_cart and ps_orders. 2. define field in cart and order classes. 3. edit parentordercontroller.php put in _processCarrier() $this->context->cart->id_is = (Tools::getValue('id_is')); $this->context->cart->name_is = (int)(Tools::getValue('name_is')); 4. edit paymentmodule.php put in validateOrder() $order->id_is = $this->context->cart->id_is; $order->name_is = $this->context->cart->name_is; please reply.

Solved !!

I have disable customer,Purpose of disable the customer is He/she should not be allowed to put the order. it is fine from front end but order is generated for disable customer from back office.how can i fetch only active customer at the time of create order from back office. where can i change query ( want to add and `active=1`) for search query? thanks in adv.

I have delete facebookpsconnect dir from module ..back-office is working fine but my front is showing error related to db. like,,You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` ' at line 6

Download all project files from server using ftp....there is some file related to facebook is failed during download .....ie modules/facebookpsconnect/conf/comman.conf.php is missing not able to download that file ..and also back-office module section not working . If i don't want facebookpsconnect module then from where can i delete that module..my modules not working at back-office..

Hello I am trying to configure(set) Prestashp site from server to localhost. follws prcedure as, 1. download all files from server using ftp and export db from live site. 2. copy all files in my localhost directory (localhost/psc_testone) 3. Create db as "psc_testone" and import the database using the phpMyAdmin. 4. Using PHPMyAdmin and go to the table "ps_configuration" and change 2 line PS_SHOP_DOMAIN and PS_SHOP_DOMAIN_SSL to localhost. 5. In table "ps_shop_url" and change DOMAIN and DOMAIN_SSL to localhost and physical_uri to /project folder/ 6. Updating config settings: config/settings.inc.php and change database name user . after all of this prestashop site not accesible..showing blank site. how can i set it? is anything missing?