Post by OC2PS » Thu Aug 23, 2012 12:14 am

Not sure if it's just me, or if other have had this issue too.

When creating a coupon, I can choose the categories to which the coupon applies. However, seems the categories are not saved - when I click Edit for the coupon, all categories are unselected.

FIX:
i2Paq wrote:Coupons by Category
This vqmod changes the behavior of the category selector in the coupon code admin pages. Basically, it uses true categories for determining whether the code is valid or not, and not a static product list.

This will help users to not have to refresh the coupon code after adding new products.
Works like a charm!
Last edited by i2Paq on Wed Apr 03, 2013 5:18 pm, edited 1 time in total.
Reason: Fix added

OC2PS
OC 2.3.0.2, vQmod 2.6.2, Journal2 theme
Arcfesték, Csillámtetoválás, Henna
Image
Check out: All my extensions | My FREE extensions


User avatar
Active Member

Posts

Joined
Wed Jul 22, 2009 4:15 am
Location - Hungary

Post by OC2PS » Tue Sep 04, 2012 9:25 am

Any ideas?

OC2PS
OC 2.3.0.2, vQmod 2.6.2, Journal2 theme
Arcfesték, Csillámtetoválás, Henna
Image
Check out: All my extensions | My FREE extensions


User avatar
Active Member

Posts

Joined
Wed Jul 22, 2009 4:15 am
Location - Hungary

Post by tmas73 » Thu Sep 13, 2012 5:23 am

Same problem here. Nothing saves! I am on Opencart 1.5.4.1

Newbie

Posts

Joined
Mon Feb 13, 2012 12:01 pm

Post by OC2PS » Mon Sep 17, 2012 7:14 pm

Bump

OC2PS
OC 2.3.0.2, vQmod 2.6.2, Journal2 theme
Arcfesték, Csillámtetoválás, Henna
Image
Check out: All my extensions | My FREE extensions


User avatar
Active Member

Posts

Joined
Wed Jul 22, 2009 4:15 am
Location - Hungary

Post by qiux » Thu Dec 13, 2012 2:55 am

Is it a bug or we are doing something wrong here? i also meet this problem, i doing search anywhere but got no luck and answer yet.
Here is the related topic. http://forum.opencart.com/viewtopic.php?f=115&t=56862

Any idea?

Newbie

Posts

Joined
Wed Aug 22, 2012 10:17 pm

Post by toolsandtimber » Mon Jan 28, 2013 7:06 pm

Hi guys is there any update on this? We have just lost out on £120 because this failed to restrict our categories!!!

New member

Posts

Joined
Wed Nov 23, 2011 5:47 pm

Post by OC2PS » Thu Jan 31, 2013 4:51 pm

Does this work for anybody? Is it just a few of us that can't get this to work?

OC2PS
OC 2.3.0.2, vQmod 2.6.2, Journal2 theme
Arcfesték, Csillámtetoválás, Henna
Image
Check out: All my extensions | My FREE extensions


User avatar
Active Member

Posts

Joined
Wed Jul 22, 2009 4:15 am
Location - Hungary

Post by grgr » Thu Jan 31, 2013 5:40 pm

OC2PS wrote:Does this work for anybody? Is it just a few of us that can't get this to work?
What you are looking for won't work for anyone as the code and database table/fields don't exist for 'Categories' as that is not how it works.

When you tick a Category in the category list, all the products under that category should be added to the products list in the box below.

The system does not check for a category at checkout, it checks for a product. On the basis that the products belong to a category that you have allowed for the coupon, it's a seudo category check.

The advantage of this is that if there is a product or two in the category that you don't want to allow, then you can just delete the product from the resultant product list.

-
Image Image Image Image
VIEW ALL EXTENSIONS * EXTENSION SUPPORT * WEBSITE * CUSTOM REQUESTS


User avatar
Active Member
Online

Posts

Joined
Mon Mar 28, 2011 4:08 pm
Location - UK

Post by OC2PS » Thu Jan 31, 2013 7:41 pm

grgr wrote:When you tick a Category in the category list, all the products under that category should be added to the products list in the box below.

The system does not check for a category at checkout, it checks for a product. On the basis that the products belong to a category that you have allowed for the coupon, it's a pseudo category check.
And that would be fine, except it doesn't seem to work that way. Checking a category does not add its products to the products box - neither before nor after saving.

OC2PS
OC 2.3.0.2, vQmod 2.6.2, Journal2 theme
Arcfesték, Csillámtetoválás, Henna
Image
Check out: All my extensions | My FREE extensions


User avatar
Active Member

Posts

Joined
Wed Jul 22, 2009 4:15 am
Location - Hungary

Post by grgr » Thu Jan 31, 2013 8:37 pm

OC2PS wrote:Checking a category does not add its products to the products box - neither before nor after saving.
It should do, may take a few moments if there are a lot of products in the category.

Otherwise try the Console tab in Firebug to see what is happening.

-
Image Image Image Image
VIEW ALL EXTENSIONS * EXTENSION SUPPORT * WEBSITE * CUSTOM REQUESTS


User avatar
Active Member
Online

Posts

Joined
Mon Mar 28, 2011 4:08 pm
Location - UK

Post by cagbaazee » Wed Feb 13, 2013 1:51 pm

I m also facing same problem but it give me the display
Notice: Undefined index: left in /home/sssssssscx/public_html/eshoppy.org/opencart/catalog/model/checkout/coupon.php on line 60Notice: Undefined index: right in /home/ssssssscx/public_html/eshoppy.org/opencart/catalog/model/checkout/coupon.php on line 60Notice: Error: Unknown column 'c.left' in 'where clause'
Error No: 1054
SELECT COUNT(*) AS total FROM `oc_product_to_category` p2c LEFT JOIN `oc_category` c ON (p2c.category_id = c.category_id) WHERE p2c.`product_id` = '10245' AND c.`left` BETWEEN '0' AND '0' in /home/rapbaycx/public_html/eshoppy.org/opencart/system/database/mysql.php on line 50

do any one know how to resolve it

Thanks

Newbie

Posts

Joined
Wed Feb 13, 2013 1:31 pm

Post by tolinho » Thu Feb 14, 2013 12:48 am

Hi,
I also have this problem.
The coupon does not restrict for the selected categorys.
Its always appled.

Any advise?

Im running Open Cart 1541

New member

Posts

Joined
Sat Jul 21, 2012 2:01 am

Post by i2Paq » Fri Mar 29, 2013 6:41 pm

Ran into this BUG today!

I'm having a major e-mail send out to 30.000 people this weekend, there is 5% discount for everyone who uses the discount code and now I find that it does not work for categories (nor does it add any product from the selected category).

How am I going to solve this?

Adding all my products manually?

This is undo-able as it also shows all the inactive product!!!

I'm using 1.5.4.1

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by i2Paq » Wed Apr 03, 2013 5:05 pm

Coupons by Category
This vqmod changes the behavior of the category selector in the coupon code admin pages. Basically, it uses true categories for determining whether the code is valid or not, and not a static product list.

This will help users to not have to refresh the coupon code after adding new products.
Works like a charm!

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by tolinho » Wed Apr 03, 2013 6:46 pm

i2Paq wrote:Coupons by Category
This vqmod changes the behavior of the category selector in the coupon code admin pages. Basically, it uses true categories for determining whether the code is valid or not, and not a static product list.

This will help users to not have to refresh the coupon code after adding new products.
Works like a charm!
Thanks for charing!
Ill give it a try :)

New member

Posts

Joined
Sat Jul 21, 2012 2:01 am

Post by bruno05 » Sat Sep 14, 2013 7:05 am

Anyone fix this for 1.5.5.1? Cannot believe this is a bug and no one seems to have fixed it since 1.5.4.x.

Newbie

Posts

Joined
Tue Aug 13, 2013 2:07 pm

Post by bruno05 » Sun Sep 29, 2013 4:41 pm

Found a fix in the forums. Thanks you.

Newbie

Posts

Joined
Tue Aug 13, 2013 2:07 pm

Post by jackie » Wed Oct 02, 2013 8:48 am

Hi - using 1.5.4.1, I have the same problem (coupons by category doesn't work - when it should be loading the category's products into the table, it does not load anything into the table...) The categories I've chosen are not saved.
We can set up coupons for specific products, and for the entire site, but need the category option to work.

How was this solved?

I understand from reading the posts that version 1.5.5.1 uses a different scheme for the coupons - could someone who uses this in 1.5.4.1 explain how you got it to work properly?


Thank you!!!
We also discovered this while trying to send out a newsletter with the coupons!

New member

Posts

Joined
Thu Mar 01, 2012 11:26 pm

Post by i2Paq » Wed Oct 02, 2013 2:21 pm

jackie wrote:Hi - using 1.5.4.1,
How was this solved?
Did you actually read this topic?

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands
Who is online

Users browsing this forum: No registered users and 8 guests