TOPIC: Adding discount codes via custom code

Our event uses a lot of discount codes, hundreds in fact. We're trying to get away from having to manually enter each one and to automate the process. I have made it to the point where I have entries in _dtregister_codes and _dtregister_event_codes. What I find is while the entries look correct in the administrative interface, they aren't working. They work if I go into the event and save it, so at some level the out-of-band entries are correct. Is there one or more manipulation needed to get them working that someone could tell me?

Hello. In the _dtregister_codes table, make sure your manually entered codes have a "1" for "events_enable". That should do the trick... assuming the codes are published, have active date ranges in place, etc.

Thank you. We do the codes on a per-event basis. I did a diff on the databases with our addition vs. our addition+resaving the event. I determined that _feeorder also needs an entry. I've tested it in a case of one so far, but it's promising! Any advice on setting the "ordering" column. It appears that using max(ordering)+1 would be appropriate for each row (with WHERE eventId=<eventid#>).

Might be doubling up on the question here (I can add another topic if you'd like): is the feeorder in any way associated with calculating % basis of the final total? We are a non-profit and have an optional checkbox to add in the credit card processing fee to the checkout total. What I've noticed is that when people have a discount code, the % fee is based on the pre-discount total (e.g., 100 reg fee - 50 discount should have a % of 50, not 100).

Yes, that is the total purpose of fee ordering. If your fees are flat $ amounts, then it doesn't matter. If it is a percentage, then it TOTALLY matters at what point it is processed. And since everyone needs things processed differently... we added the fee ordering control years ago. So yes, if that's what you're doing, you definitely need the fee ordering established.

I've NEVER clicked on fee ordering. It's like it was invisible before you wrote that. Your assistance is appreciated. This is our third year with DTR and are quite pleased with it.

Yeah, easy to overlook one feature in the middle of thousands of them.

Glad DT Register has been good for you for these years! If you haven't posted a review on the JED ever, we'd appreciate you doing so:

extensions.joomla.org/extensions/extensi...s/events/dt-register

Thanks!