Search found 12 matches

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

xxvirusxx wrote:
Fri Jun 21, 2019 9:14 pm
You want something like this?
https://www.opencart.com/index.php?rout ... n_id=23095
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 post
  • 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
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?

Jump to post
  • 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

Page 1 of 1

Search found 12 matches