Would it be possible to combine Templatecodes external listings module (E.L.M) with 68C coupons in the following way? A client - let's say a School - wishes to raise funds. In return for incorporating the E.L.M onto their school website I offer them a coupon named 'yourschool50' which they can share freely with parents, colleagues, friends etc. I understand that the E.L.M can make use of quite sophisticated search strings but can it pick up on ad's that have been placed using a particular coupon, in this case 'yourschool50'? If that is NOT possible then the rest of this request is void. If it CAN be done then can we also monitor how many instances of the coupon have been used and display that in the search results as well? What's in it for the School? Well the coupon is unlimited and carries no price reduction or at best a modest one, perhaps equivalent to 10%. The school can promote this on it's website, flyers and at special events to offer parents advertising on MY68CLASSIFIEDS site where the schools fundraising event receives 50% of the cost of their ads. That's good for the parents and good for the school. The E.L.M would need to display the relevant ads and something like "Friends of The School have posted 59 ads at myclassifieds.co.uk and raised £29.50 for the school so far! Thank you." I would deliver a cheque to the school each month. So we'd need to pull the number of uses of the Coupon Code and also divide it by 50% to produce and display the schools running total. What's in it for me? Well I'll still receive some revenue (40-50%) but, importantly in this early stage, I'll hopefully be building up some awareness, goodwill and the beginnings of an advertiser base. Does an idea like this have any merit?
No matter what I tried I couldn't find the right search string. If 68C could let me know if it simply isn't possible in a search to identify ads placed using a specific coupon code then I'll stop spending anymore time on this. Many thanks
David is correct, the order contains the coupon code used not the listing, and nothing is built into search the orders. You could use the existing module hooks and alter the query, but if you are not familiar with SQL and PHP it might be a bit difficult.
Your most straightforward "hack" would be to make a php file to use in the admin only that does a mySQL search on the orders table based on the coupon code that you are using. Of course if you also have different Ad listing packages, you would also then need to loop that search based on the product as well to figure out how much you owe them. Bottom line is that this isn't a straight forward easy fix to do what you are looking for.
Ok, thank you all for taking the time to think about it and reply. Even that it is not worth pursuing is knowledge worth having.
