Post by gtoc » Thu Nov 20, 2014 10:54 am

Hi, would it be possible to hide products but still be able to add them to an order in the back end?? This seems to stop this.

using 1.5.5.1

Thanks,

New member

Posts

Joined
Tue Apr 23, 2013 12:11 pm

Post by hamza2244 » Wed Feb 25, 2015 8:52 pm

without the code , next page link show


Image


with the code the next page link does not show
Image

Help .

code written by ainosilva

Newbie

Posts

Joined
Thu Sep 19, 2013 12:12 am

Post by hamza2244 » Wed Feb 25, 2015 9:26 pm

Image

This is the error still coming after i fixed the next page issue by myself , Theme is journal 2

Newbie

Posts

Joined
Thu Sep 19, 2013 12:12 am

Post by hamza2244 » Wed Feb 25, 2015 10:11 pm

Fixed it .

Newbie

Posts

Joined
Thu Sep 19, 2013 12:12 am

Post by Dirash » Fri Mar 06, 2015 9:30 am

Figure a simple way to solve the issue of hiding out of stock without doing any modification to the opencart source file. Using a trigger that checks the status of the order, if its status changes to Complete(status_id =5) it disables the product by setting the product status to 0

CREATE TRIGGER `trigger_name` AFTER UPDATE ON `oc_order`
FOR EACH ROW if NEW.order_status_id = 5 then
update oc_product
set status = 0
where product_id = (select product_id from oc_order_product where order_id = NEW.order_id)
and quantity = 0;
end if

Execute this sql statement on the table oc_order and change the name tigger_name to your preferred name.

Newbie

Posts

Joined
Fri Mar 06, 2015 9:27 am

Post by hamza2244 » Fri Mar 06, 2015 9:50 pm

http://www.opencart.com/index.php?route ... n_id=21241

This is a extension for journal 2 theme , will hide all out of stock product but you can still see the product using their direct link .
tested on journal 2.4.8 on opencart 1.5.5.1 , Test it on other versions and do tell me in comments , so i can tell others

Newbie

Posts

Joined
Thu Sep 19, 2013 12:12 am

Post by hamza2244 » Sun Mar 08, 2015 11:17 pm

This is to hide out of stock products in journal 2 theme , it will work with the super filter module of journal 2 , it will just hide the products , google and other search will be able to see the product using the link , that is good for seo .

Please, backup first!!

It works with the super filter module of journal theme , Custom sections , search , category and manufacturer

Hope it helps you!! :)

Comments and suggestions are appreciated

tested on journal 2.4.8

http://www.opencart.com/index.php?route ... ournal%202

Newbie

Posts

Joined
Thu Sep 19, 2013 12:12 am

Post by hamza2244 » Mon Mar 09, 2015 6:28 pm

Dirash wrote:Figure a simple way to solve the issue of hiding out of stock without doing any modification to the opencart source file. Using a trigger that checks the status of the order, if its status changes to Complete(status_id =5) it disables the product by setting the product status to 0

CREATE TRIGGER `trigger_name` AFTER UPDATE ON `oc_order`
FOR EACH ROW if NEW.order_status_id = 5 then
update oc_product
set status = 0
where product_id = (select product_id from oc_order_product where order_id = NEW.order_id)
and quantity = 0;
end if

Execute this sql statement on the table oc_order and change the name tigger_name to your preferred name.

You code disable the product , we are talking about hiding it from main website , but you will still be able to see the product if you have a direct product link . My code is not working , have some errors i am working on it , will see if it works or not.

Newbie

Posts

Joined
Thu Sep 19, 2013 12:12 am

Post by sigmamale » Thu May 28, 2015 3:56 am

hi hamza2244, are u'r problem already done???. I have the same problem with you.

Newbie

Posts

Joined
Thu May 28, 2015 3:53 am

Post by sigmamale » Thu May 28, 2015 7:34 pm

Hi hamza .. u'r link doesnt work. do you have another link or copy module? i need it urgent. thanks
hamza2244 wrote:This is to hide out of stock products in journal 2 theme , it will work with the super filter module of journal 2 , it will just hide the products , google and other search will be able to see the product using the link , that is good for seo .

Please, backup first!!

It works with the super filter module of journal theme , Custom sections , search , category and manufacturer

Hope it helps you!! :)

Comments and suggestions are appreciated

tested on journal 2.4.8

http://www.opencart.com/index.php?route ... ournal%202

Newbie

Posts

Joined
Thu May 28, 2015 3:53 am

Post by sigmamale » Thu May 28, 2015 7:37 pm

hi hamza thx for share. but your link doesnt work. do you have another link? thank you
hamza2244 wrote:This is to hide out of stock products in journal 2 theme , it will work with the super filter module of journal 2 , it will just hide the products , google and other search will be able to see the product using the link , that is good for seo .

Please, backup first!!

It works with the super filter module of journal theme , Custom sections , search , category and manufacturer

Hope it helps you!! :)

Comments and suggestions are appreciated

tested on journal 2.4.8

http://www.opencart.com/index.php?route ... ournal%202

Newbie

Posts

Joined
Thu May 28, 2015 3:53 am

Post by petroniolopes » Sun Oct 18, 2015 4:18 am

I installed plugin (files) at my opencart, but pagination don't show, it hide alone, if I remove plugin (files) worked normally with pagination showing up.

Did somebody can help me ?

Newbie

Posts

Joined
Sun Oct 18, 2015 4:08 am

Post by panagos » Tue Jan 19, 2016 11:48 pm

Hi guys

I recently released an extension which will hide categories with out of stock products as well as empty categories:

http://www.opencart.com/index.php?route ... n_id=24339

The plugin is multi-store enabled, and gives you fine-grained control over exactly how you want it to work. I even got it working with the journal theme.

I suspect it may solve your problem. If you need any further clarification on this please shout.

Rgds
Soteri

--
Soteri Panagou
Freelance Developer and Opencart Zealot

http://www.opencart.com/index.php?route ... @gmail.com


New member

Posts

Joined
Sun Oct 25, 2015 3:01 am


Post by opencart-solutions » Mon Jan 22, 2018 3:45 am

Hello
InStock Only for all page when show products: category, special, search, manufacturer
https://www.opencart.com/index.php?rout ... n_id=33009

Opencart Solutions | opencart-solutions.com


New member

Posts

Joined
Fri Jan 19, 2018 1:55 am

Post by opencart-solutions » Mon Jan 22, 2018 3:47 am

Hello
InStock Only for all page when show products: category, special, search, manufacturer
https://www.opencart.com/index.php?rout ... n_id=33009

Opencart Solutions | opencart-solutions.com


New member

Posts

Joined
Fri Jan 19, 2018 1:55 am
Who is online

Users browsing this forum: Bing [Bot] and 25 guests