it is possible to achieve this if you go to your WordPress database via any Database management Tool, for example PHPMyAdmin, then find this Amelia's table for coupons,
and there for the column that stores the "coupon code",
we change the Database collation to one that is case insensitive, then it works.
We just made a test on a local Test site, you can see this Video how the coupon code automatically changes to capital, even when i just input a lower case letter on the booking Form, because when we do this, then any search on this column in the database ignores case sensitivity :
If you know your way around the database, you can do this yourself,
find this table named 'wp_amelia_coupons' ( wp_ is the default WP Database prefix, but on your site it could be different, you have to check what is the table prefix);
then check what is your current collation, when you find this column named 'code', go in the column settings,
and just set a similar collation, but ending with "ci" ( case insensitive);
In my case, the collation was uft8_bin , then i change to uft8_general_ci ( ci stands for case insensitive);
so you can change to any collation that is ending with the "ci" at the end, then save changes, and it should work.
Or, if you wish, you can run an SQL Query on your database, like this :
ALTER TABLE `wp_amelia_coupons` CHANGE `code` `code` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
( Just make sure to get the right table name, and the right collation for your site);
or if you want us to do this for you, it's not a problem,
we just need access to your database, either a URL with credentials for PHPMyAdmin, or access to your hosting panel, and from there we can do this for you.
Let me know how it goes.
If you send us credentials/access, please make sure to mark the reply as PRIVATE, for security purposes, so that only we can see that.
Hello,
Coupon codes are case sensitive, and it's confusing our students. Can we make them case insensitive?
Thanks
Hi, Stephanie
Thanks for reaching out to us
I am not sure if it will be possible with any workaround to make the coupons case insensitive at the moment,
since it would probably require custom coding, ( if that's the case, it would not be included in our support),
but we will check if something like that is possible with our 2nd level Team.
As soon as they confirm, we will report back right away.
Thank you for your patience.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi, Stephanie
Good news. We managed to make a workaround,
it is possible to achieve this if you go to your WordPress database via any Database management Tool, for example PHPMyAdmin, then find this Amelia's table for coupons,
and there for the column that stores the "coupon code",
we change the Database collation to one that is case insensitive, then it works.
We just made a test on a local Test site, you can see this Video how the coupon code automatically changes to capital, even when i just input a lower case letter on the booking Form, because when we do this, then any search on this column in the database ignores case sensitivity :
https://watch.screencastify.com/v/tqt3oN6k8k8wHixzj1Do
If you know your way around the database, you can do this yourself,
find this table named 'wp_amelia_coupons' ( wp_ is the default WP Database prefix, but on your site it could be different, you have to check what is the table prefix);
then check what is your current collation, when you find this column named 'code', go in the column settings,
and just set a similar collation, but ending with "ci" ( case insensitive);
In my case, the collation was uft8_bin , then i change to uft8_general_ci ( ci stands for case insensitive);
so you can change to any collation that is ending with the "ci" at the end, then save changes, and it should work.
Or, if you wish, you can run an SQL Query on your database, like this :
( Just make sure to get the right table name, and the right collation for your site);
or if you want us to do this for you, it's not a problem,
we just need access to your database, either a URL with credentials for PHPMyAdmin, or access to your hosting panel, and from there we can do this for you.
Let me know how it goes.
If you send us credentials/access, please make sure to mark the reply as PRIVATE, for security purposes, so that only we can see that.
Thanks
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables