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
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?
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?
Thanks for the prompt reply!haydent wrote:theoretically it could be done but not with my mod (or atleast modification to my mod)
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!
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.
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.
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.
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.
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
in front of any table name in $sql, $sql1, $sql2 and @sql3
e.g.
the mod is now working perfect.
Regards Thomas
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)";Regards Thomas
i'm interesed in the adaptasion. name the motivation!haydent wrote:no but it could be adapted if the motivation was there
i have no ideea. it's your work. you know best what it costs. name the price and we talkhaydent wrote:make an offer
Who is online
Users browsing this forum: No registered users and 46 guests
