category Module side bar 2.1.0.1
Hi Guys, i'm trying to display the subcategories related to parent only what i have achieved sofar is here is the category.php controller $categories = $this->model_catalog_category->getCategories(0); $category_info = $this->model_catalog_category->getCategory($data['category_id']); $data['parent_na...
Jump to post- Wed Mar 01, 2017 6:45 pm
- Replies 0
- Views 636
show subcategory only on category page
Guys please help me out Im having hard time to display only the subcategory related to parent id in URL . Category page
Jump to post- Thu Feb 16, 2017 2:53 am
- Replies 0
- Views 519
Re: opencart SQL Query Result issue
Thanks for help
Jump to post- Sat Jun 18, 2016 1:14 am
- Replies 2
- Views 521
opencart SQL Query Result issue
guys I have the below Query to get all order_product table with a result of 73 Order $sql = "SELECT op.name AS productname, op.order_id AS order_id, op.quantity AS quantity, op.total AS total, pv.vendorname AS vendorname, vc.commission_type AS commission_type, vc.commission_name AS commission_n...
Jump to post- Fri Jun 17, 2016 9:31 am
- Replies 2
- Views 521
Re: Order table export sql error
Thanks Fido-X for reply however i removed the if statement and replaced it with
Code: Select all
$sql .= "WHERE o.order_id > '0'";- Wed Jun 15, 2016 7:59 pm
- Replies 5
- Views 938
Re: Order table export sql error
Thanks for your reply however even removing those fields didn't solve it
Jump to post- Wed Jun 15, 2016 7:40 pm
- Replies 5
- Views 938
Order table export sql error
Guys i'm trying to export order table with below function protected function getOrders( &$languages, $offset=null, $rows=null, $min_id=null, $max_id=null ) { $sql = "SELECT "; $sql .= " o.order_id,"; $sql .= " o.invoice_no,"; $sql .= " o.shipping_address_2,&quo...
Jump to post- Wed Jun 15, 2016 6:26 am
- Replies 5
- Views 938
Re: OCMOD xml issue
Sorted out thanks anyways
Jump to post- Tue Jun 14, 2016 5:55 am
- Replies 2
- Views 647
Re: OCMOD xml issue
The XML code is showing outside the log
Jump to post- Tue Jun 14, 2016 5:40 am
- Replies 2
- Views 647
OCMOD xml issue
Hello Guys,
I have created new ocmod file and everything works as expected however i'm getting this on Modifications page
Capture.PNG (28.19 KiB) Viewed 647 times
- Tue Jun 14, 2016 5:16 am
- Replies 2
- Views 647
order product table
Hi Guys, how to use $this->model_sale_order->getOrderProducts($this->request->get['order_id']); $this->load->model('sale/order'); was added to the top of the file when i use it i get this Notice: Undefined index: order_id in admin\controller\localisation\vendor_orders.php on line 180 i need to fetch...
Jump to post- Sun May 29, 2016 7:52 pm
- Replies 1
- Views 648
out of stock label
I'm attempting to add outofstock label to product.tpl image <?php if ($product_info['quantity'] <= 0) {?> <img class="outofstock" width="120" height="120" style="z-index: 1000; position: absolute; top: 0; left: 0" src="image/data/oos.png" alt="&...
Jump to post- Mon May 23, 2016 4:30 pm
- Replies 7
- Views 6420
LEFT JOIN 3 tables
Hi All, I need to join another table in this function with a name vendors, is that possible public function getProducts($data = array()) { $sql = "SELECT * FROM " . DB_PREFIX . "product p LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) WHE...
Jump to post- Mon May 09, 2016 4:15 pm
- Replies 0
- Views 418
Product_list issue opencart 2.1.0.2
Hi Guys, i have new table called vendors, and i need to Join that table with the below function, to echo vendors name in product_list.tpl file in Admin/Model/Product.php public function getProducts($data = array()) { $sql = "SELECT * FROM " . DB_PREFIX . "product p LEFT JOIN " . ...
Jump to post- Sat May 07, 2016 5:48 am
- Replies 0
- Views 298
Re: custom filed in product_form opencart 2.1.0.2
Solved Thanks for help
Jump to post- Thu May 05, 2016 6:19 pm
- Replies 9
- Views 974
Re: custom filed in product_form opencart 2.1.0.2
Guys Any one could tell what is the root cause of the error
Jump to post- Thu May 05, 2016 5:34 pm
- Replies 9
- Views 974
Re: custom filed in product_form opencart 2.1.0.2
I don't need to echo that field in front end i just need it to work in backend
Jump to post- Thu May 05, 2016 4:30 am
- Replies 9
- Views 974
Re: custom filed in product_form opencart 2.1.0.2
still throwing the same error
Code: Select all
p.image, p.seller_price- Wed May 04, 2016 11:48 pm
- Replies 9
- Views 974
Re: custom filed in product_form opencart 2.1.0.2
but Neither SKU nor MPN addedd to the
Code: Select all
public function getProduct($product_id) {Code: Select all
return array(- Wed May 04, 2016 11:25 pm
- Replies 9
- Views 974
