Page 1 of 1
Search found 12 matches
Re: default product sort by stock_status_id
Replace this: ORDER BY p.sort_order With this: ORDER BY p.stock_status_id SELECT p.product_id,p.stock_status_id, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE ...
Jump to post- Sat Jun 22, 2019 4:26 am
- Replies 4
- Views 265
Re: Display out of stock items at the end of category
Hello, no, I want to sort catalog by product_stock_id where all products out of stock will be at the end, then 15days, then preorder and at the top in stock products. Jump to postxxvirusxx wrote: ↑Fri Jun 21, 2019 9:14 pmYou want something like this?
https://www.opencart.com/index.php?rout ... n_id=23095
- Sat Jun 22, 2019 3:49 am
- Replies 6
- Views 1316
Re: Sort by stock status
Hi, I'm searching that too. All I can find is sort by quantities, but not for stock_status_id
Jump to post- Wed Jun 19, 2019 2:19 am
- Replies 1
- Views 611
default product sort by stock_status_id
Hello, I'm looking some code for v2.1 oc something like that: if (isset($data['sort']) && in_array($data['sort'], $sort_data)) { if ($data['sort'] == 'pd.name' || $data['sort'] == 'p.model') { // Original // $sql .= " ORDER BY LCASE(" . $data['sort'] . ")"; ...
Jump to post- Wed Jun 19, 2019 12:28 am
- Replies 4
- Views 265
Re: Display out of stock items at the end of category
Have you tried searching the forums or looking at the code itself? Only spent a few minutes on this, so there might be a more sensible place to make the edit, or this edit might be a bad one, but I gave it a very quick test and it seemed to work (only tried the first part of the IF, it would be eas...
Jump to post- Tue Jun 18, 2019 11:55 pm
- Replies 6
- Views 1316
Re: order status list empty after opencart upgrade 1.5.4 to 3.0.2
yes, i have done the permisions thing...
Jump to post- Sat Sep 29, 2018 9:30 pm
- Replies 2
- Views 112
order status list empty after opencart upgrade 1.5.4 to 3.0.2
i can see there is in database in table order_status, but in admin doesnt show, i cant save settings, i think there is something with languages because admin was missing some strings, can some one help me?
Jump to post- Sat Sep 29, 2018 9:23 pm
- Replies 2
- Views 112
Re: cod product data from cart
Fatal error: Class 'Context' not found in/catalog/controller/payment/cod.php on line 5
Jump to post- Tue Mar 28, 2017 2:13 am
- Replies 4
- Views 1276
Re: cod product data from cart
I do: foreach($this->cart->getProducts() as $product) { $this->load->model('catalog/product'); $product_info = $this->model_catalog_product->getProduct($product['product_id']); if($product_info['my_data']=='1') return; } But when i try to check cash on delivery where $product_info['my_data']==0 i ge...
Jump to post- Tue Mar 28, 2017 2:02 am
- Replies 4
- Views 1276
cod product data from cart
how to access product data from cart in cod.php model? $this->product_info['my_data'] doesnt work, i created that input my_data in db and changing using admin products data tab do i need to add something to controller? what i'm trying to do is when my_data is set in at least one product in the cart ...
Jump to post- Thu Mar 16, 2017 9:48 pm
- Replies 4
- Views 1276
cod ir product data
kaip modelyje cod.php pasiekti produktu kurie yra krepšelyje duomenis?
$this->product_info['mano_duomenys'] neveikia,
aš čia pats sukūriau papildoma laukeli duomenu bazej gal dar reikia kažką pridėt kontroleryje?
- Thu Mar 16, 2017 9:39 pm
- Replies 1
- Views 1500
UNIT PRICE SUFFIX [oc2]
Sveiki, kaip padaryti kad prie pasirinktų prekių galmėtų rodyti ilgio vienetus prie kainos eg.: € / m², € / m3, € / m, € / vnt ir tiesiog €?
Jump to post- Sun Mar 13, 2016 4:24 pm
- Replies 0
- Views 2191
Search found 12 matches
