Section for service discounts?

Samalan Level 1

February 27, 2014, 5:14 pm

9

Write the reason you're deleting this FAQ

Section for service discounts?

Hello,

I believe there should be a section on the forum where people can post discounts to their service or a special promotion they have running, like I have a buy 2 get 1 free offer for my service. It would help people find great deals and help sellers find new customers.

What are your thoughts?

Comments

Please login or sign up to leave a comment

Join

mqss

I think it would be overcrowded by people offering hundreds of "special offers" per day.

12 years ago

Are you sure you want to delete this post?

Sean101

I agree with both.
I think it would be a good idea to have something like that, but I do think it would be spammed a really lot.

12 years ago

Are you sure you want to delete this post?

mqss

I think there should be a limit like 500$ services sold = forum promotion available.

12 years ago

Are you sure you want to delete this post?

Samalan

Instead of the services sold, maybe it could use the levels, it could be a benefit for the promotion part I guess.

12 years ago

Are you sure you want to delete this post?

NaturalWriter

Good day to all!!

The discounted services is a great idea. I feel though there would have to be rules and guidelines.
@mqss had a good suggestion with having a start price. I'm not saying $500, but there would have to be a set amount required. It would demolish listings being posted with $1, $5, $10, etc services, therefore eliminating every person known to man posting.

When it comes to the "people offering hundreds of "special offers" per day." perhaps it could be made like the bumping system, BUT the individuals can ONLY list ONE "Special Offer" listing per day. That should cut down on the overflow, in addition maybe it can also have it's own search so people wouldn't have to scroll down page after page of "specials" that their not looking for.

"Strive not to be a man of success, but rather to be a man of value."
~Albert Einstein

12 years ago

Are you sure you want to delete this post?

Beverly

I can understand why there would be spam issues involved in such a situation. However, maybe if each user were allowed to create ONE forum thread that could be updated when a new discount or sale price is available for their own services, rather than creating a new post every time they wanted to advertise.

And, all these threads would be on their own subforum. This is commonly done on promotion or advertising forums. And, the member would simply bump the thread if anything new is available to offer. But, bumping for bumping sake just to get the thread to the top might be reason to have the thread deleted.

12 years ago

Are you sure you want to delete this post?

hitmeasap

There's a "Guaranteed only" option on the marketplace, which allows people to see all the services that has a guarantee from the provider. How about adding a "On Sale" section instead of creating forum threads?

The forum has a "advertising" section already, which is used by some people from time to time. Mostly to tell people about something cool & unique they offer and not just when they put their services on sale. However, allowing people to advertise their "Get 2 pay for 1" multiple times per day will be extremely over-used and I'd never browse such a thread.. I think most people will be tired of all the "new junk" that's being posted every minute.. That's why I personally would prefer a "On sale" option directly on the marketplace instead of forums threads/posts.

With that said, I can't say that I actually believe in more sales & more exposure with such an option.. I think most people know what they're looking for and I don't think they'll spend time browsing tons of "on sale" services just to save a couple of bucks doing so, but I'd still prefer such an option instead of using the forum for advertising this way. Just my 2 cents.

/hitmeasap

12 years ago

Are you sure you want to delete this post?

Jagger

People are always spamming their services on forum anyway in threads (check out my service/link, etc). A subforum for this would just give moderators a place to move all that spam rather than having to delete it. And, there is a good reason for the members to be able to advertise. More advertising even on forum equals more sales and more site revenue and everyone wins.

12 years ago

Are you sure you want to delete this post?

Process Time: 0.069015026092529

Possible Duplicate queries found!

Match	Count	SQL	Script
SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400	1	SELECT querystring, added FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400	/opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once()
SELECT * FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='12248'	1	SELECT q.*, c.seo as CatSEO, c.name as CatName, c.parentid FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='12248'	/opt/clerks-staging/docroot/viewfaq.php 496 () ()
SELECT * FROM seoclerks.members WHERE USERID='11173'	1	SELECT * FROM seoclerks.members WHERE USERID='11173'	/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
SELECT * FROM categories_faq WHERE CATID='39'	1	SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='39'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType()
SELECT * FROM seoclerks.members WHERE USERID=11173	1	SELECT googleplus_profile FROM seoclerks.members WHERE USERID=11173	/opt/clerks-staging/docroot/include/functions/main.php 16914 GetGooglePlusProfileFromId() ()
SELECT * FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=12248 LIMIT 5	1	SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=12248 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='12248' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc	1	SELECT a.answer, a.USERID, a.upvotes, a.downvotes, a.ansid, a.parentid, a.combined_votes, a.date_answered, b.username, b.userlevel, b.profilepicture FROM answers a, seoclerks.members b WHERE a.quesid='12248' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc	/opt/clerks-staging/docroot/viewfaq.php 1245 () ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=57902 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=57902 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=57903 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=57903 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=57904 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=57904 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=57905 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=57905 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=57907 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=57907 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=57908 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=57908 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=57909 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=57909 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=57910 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=57910 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
UPDATE questions SET total_views = total_views + 1 WHERE quesid='12248'	1	UPDATE questions SET total_views = total_views + 1 WHERE quesid='12248'	/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
SELECT * FROM questions WHERE quesid!='12248' AND status='1' AND (question like '%Section service discounts?%' OR question like '%Section%' OR question like '%service%' OR question like '%discounts?%') -- ORDER BY RAND() LIMIT 15	1	SELECT quesid, question, seo, userid FROM questions WHERE quesid!='12248' AND status='1' AND (question like '%Section service discounts?%' OR question like '%Section%' OR question like '%service%' OR question like '%discounts?%') -- ORDER BY RAND() LIMIT 15	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM seoclerks.members WHERE USERID='1159' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='1159' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='750' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='750' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='14524' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='14524' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='13166' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='13166' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='4245' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='4245' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=12248%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID	1	SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=12248%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM categories	1	SELECT * FROM categories	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()
select * from categories_software order by name asc	1	select * from categories_software order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories()
select * from categories_wanttobuy order by name asc	1	select * from categories_wanttobuy order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories()
select * from categories_wanttotrade order by name asc	1	select * from categories_wanttotrade order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories()
SELECT * FROM seoclerks.members WHERE USERID='2077.png'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='2077.png'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='1856.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='1856.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='11173.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='11173.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='168430.png'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='168430.png'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='147.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='147.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='6160.png'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='6160.png'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
select * from categories_faq order by name asc	1	select * from categories_faq order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()

Invalid SQL

count(*)	sql1	error_msg

Expensive SQL

Tuning the following SQL could reduce the server load substantially

Load

Count

SQL

Max

Min

Suspicious SQL

The following SQL have high average execution times

Avg Time

Count

SQL

Max

Min