Post by haydent » Tue Feb 14, 2012 3:45 pm

Simple vQmod to show discounted products along with specials products, inside products specials page and module.

As well as show the different discounts available in the following views:

- Featured Module
- Category Products List
- Search Results List
- Special Module
- Special Products List

If you need others, just ask and ill add them.

It also fixes a bug i found and reported with sorting specials descending.

See "Additional Images" tab for sample screenshot.

Extension Page

User avatar
New member

Posts

Joined
Wed Nov 09, 2011 9:50 am
Location - Sydney, Australia

Post by ahwee321 » Wed Jul 18, 2012 2:25 pm

Hi haydent,

thanks for such a wonderful extension.

does it work with the 1.5.3.1 version of opencart though?

br

ahwee

Newbie

Posts

Joined
Wed Jul 18, 2012 2:23 pm

Post by haydent » Wed Jul 18, 2012 2:34 pm

you can try it i dont know, but it just may.

User avatar
New member

Posts

Joined
Wed Nov 09, 2011 9:50 am
Location - Sydney, Australia

Post by Bg-foxx » Mon Aug 13, 2012 11:32 am

Can this vQmod group certain discounted products on a single page?

I want to discount several of our products on the site and group them in one temporary page, the link of which I want to promote in an email. In other words I want to be able to show only the discounted product on one page. Is this possible?

New member

Posts

Joined
Wed Feb 22, 2012 7:55 am

Post by haydent » Mon Aug 13, 2012 3:43 pm

theoretically it could be done but not with my mod (or atleast modification to my mod)

User avatar
New member

Posts

Joined
Wed Nov 09, 2011 9:50 am
Location - Sydney, Australia

Post by Bg-foxx » Tue Aug 14, 2012 4:24 am

haydent wrote:theoretically it could be done but not with my mod (or atleast modification to my mod)
Thanks for the prompt reply!

Do you have any idea how I can get this done or if there is a mod out there that does that? I appreciate your help!

New member

Posts

Joined
Wed Feb 22, 2012 7:55 am

Post by haydent » Tue Aug 14, 2012 9:35 am

i dont know of any current mods that do it but havent looked.

did you want the grouped products to be not visible to general visitors ? as if you have a site search function it will have to modified to not list these products

ive done this sort of thing, by putting said products in a disabled category, but then you have to do some mods to make it visible again to the right people, i wouldnt be suprised if there was a mod that did this sort of thing.

User avatar
New member

Posts

Joined
Wed Nov 09, 2011 9:50 am
Location - Sydney, Australia

Post by Bg-foxx » Tue Aug 14, 2012 9:39 pm

No. I want to be able to group the discounted products in a temp group with a single URL, but I also want the products to show in their normal places in the different categories. When I remove the discount I want this temp URL to not exist any more and the products will show with no discount in their respective categories. I hope this makes sense.

It's for the purpose of me being able to send my newsletter subscribers to a single page that has only the temporarily discounted products.

New member

Posts

Joined
Wed Feb 22, 2012 7:55 am

Post by haydent » Wed Aug 15, 2012 7:40 am

i think the easiest way would be to assign said products to a secondary category.

User avatar
New member

Posts

Joined
Wed Nov 09, 2011 9:50 am
Location - Sydney, Australia

Post by Bg-foxx » Wed Aug 15, 2012 8:49 pm

That's what I'll do. Thanks for your replies.

New member

Posts

Joined
Wed Feb 22, 2012 7:55 am

Post by tango@gxm.dk » Mon Dec 31, 2012 9:26 pm

Hi There.
Great mod!!
At first install the mod resulted in a blank opencart. Having a look at the code I noticed, that it didn’t take table name prefix into consideration. Tables in my shop are prefixed “oc_” e.g. “oc_product”.
By adding

Code: Select all

" . DB_PREFIX . "

in front of any table name in $sql, $sql1, $sql2 and @sql3
e.g.

Code: Select all

$sql1 = "CREATE TEMPORARY TABLE " . DB_PREFIX . "product_discount_special AS (SELECT * FROM " . DB_PREFIX . "product_discount)";
the mod is now working perfect.
Regards Thomas

Newbie

Posts

Joined
Mon Dec 31, 2012 9:11 pm

Post by haydent » Fri Jan 04, 2013 8:04 pm

thanks for that ill have to fix it up

User avatar
New member

Posts

Joined
Wed Nov 09, 2011 9:50 am
Location - Sydney, Australia

Post by haydent » Mon Jan 07, 2013 5:35 am

ok this has been fixed and updated

User avatar
New member

Posts

Joined
Wed Nov 09, 2011 9:50 am
Location - Sydney, Australia

Post by webdesigniasi » Thu Jun 19, 2014 5:01 am

hello!
do you have a 1.5.6 version of this extension?
thanks!

New member

Posts

Joined
Wed Apr 23, 2014 1:34 am

Post by haydent » Thu Jun 19, 2014 9:08 pm

no but it could be adapted if the motivation was there

User avatar
New member

Posts

Joined
Wed Nov 09, 2011 9:50 am
Location - Sydney, Australia

Post by webdesigniasi » Fri Jun 20, 2014 12:41 am

haydent wrote:no but it could be adapted if the motivation was there
i'm interesed in the adaptasion. name the motivation!

New member

Posts

Joined
Wed Apr 23, 2014 1:34 am

Post by haydent » Fri Jun 20, 2014 7:59 pm

make an offer

User avatar
New member

Posts

Joined
Wed Nov 09, 2011 9:50 am
Location - Sydney, Australia

Post by webdesigniasi » Fri Jun 20, 2014 9:39 pm

haydent wrote:make an offer
i have no ideea. it's your work. you know best what it costs. name the price and we talk

New member

Posts

Joined
Wed Apr 23, 2014 1:34 am

Post by haydent » Sat Jun 21, 2014 3:38 pm

can you provide me with an installation to work on ?

User avatar
New member

Posts

Joined
Wed Nov 09, 2011 9:50 am
Location - Sydney, Australia

Post by webdesigniasi » Sat Jun 21, 2014 7:22 pm

what do you need?

New member

Posts

Joined
Wed Apr 23, 2014 1:34 am
Who is online

Users browsing this forum: No registered users and 2 guests