SEOClerks

How to mark service as "Sold Out"?



Write the reason you're deleting this FAQ

How to mark service as "Sold Out"?

Hi. I want to know hw to mark my gig as sold out?
I dont want to remove it. Just want to mark it as sold out. Thanks !

Comments

Please login or sign up to leave a comment

Join
exjordanary
Because of you, your wish is Granted!! You can now Mark Gigs as SOLD OUT!!

See HERE:

https://www.seoclerks.com/forum/threads/mark-your-services-as-sold-out.694/

-ex



Are you sure you want to delete this post?

ionicware
You can't, however, you can simply suspend your services from https://www.seoclerks.com/manage_services and when you are ready to offer those services again just re-enable.



Are you sure you want to delete this post?

exjordanary
Although, it wouldn't be a terrible idea to allow Buyers to still see your service (especially as "Sold Out"). Or at least Mark our service "extras" as Sold Out.

I have learned through my years of Online Marketing that being Sold Out and allowing Buyers to see your Product or Service, actually creates more Demand for it.

People tend to want things they cannot have.
They also tend to want something more when they see that other people get to have it, but they don't.
Especially when it was other people getting it, that resulted in the very reason why they don't get to.

In business, people say it's good to be a "Yes" Man. That's what you would call a "Sellout".
But I think it makes for good, healthy business to "Just Say No" once in a while.
There's a difference between being a "Sellout", and being "Sold out".

To be a "Sellout" means you'll do anything for that Sale (even if it means the quality of your Service will suffer).
But being "Sold Out" makes you look Desirable & Honest.

I'm sick of all the "Double Offers", and the "but Wait! There's More!!", and all the "30% Off Sales", etc. etc.

To me, the only thing a "30% Off Sale" tells me, is that they were just ripping me off by 30% prior to the Sale. (makes me wonder about all their other Non-Sale Items).
It also makes their Product/Service seem "undesirable" and less attractive when it's being "Devalued" using very Old-Fashioned marketing strategies.

In all Advertising & Business, Visibility & Consistency are key.

I think that rather than "Suspend" a service (*poof* be gone), it would be much more effective for Sellers if they could keep their services Visible (with a Sold Out sign?) so that Buyers could at least see what they're missing, anticipate their Order (or place Pre-Orders), and perhaps strike up a conversation with the Seller about it's availability. This would at least allow Sellers to Plant the Seeds of a Client/Seller relationship.
We all know that if Money were to grow on Trees, you'd still have to plant the seed.
Why do you think Pirates used to bury all that Treasure?

Hope this Helps,



Are you sure you want to delete this post?

Maranatha
Wow thank you very much Jordan ! =) and also to you exJordanary. Its really a great feature for me. How to mark service as "Sold Out"?



Are you sure you want to delete this post?

snoovie
Yeah... jordan is here... suspend your gig buddy... it's so easy... other user can't see and can't order your gig anymore



Are you sure you want to delete this post?

rocky
you can simply suspend your services from.your wish is Granted.thank you



Are you sure you want to delete this post?

Order Now
Process Time: 0.23872995376587

Possible Duplicate queries found!
MatchCountSQLScript
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='1983'1SELECT 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='1983'

/opt/clerks-staging/docroot/viewfaq.php 496 () ()

SELECT * FROM seoclerks.members WHERE USERID='8619'1SELECT * FROM seoclerks.members WHERE USERID='8619'

/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()

SELECT * FROM seoclerks.members WHERE USERID=86191SELECT googleplus_profile FROM seoclerks.members WHERE USERID=8619

/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=1983 LIMIT 51SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=1983 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='1983' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc1SELECT 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='1983' 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=11298 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=11298 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=11290 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=11290 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=11295 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=11295 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=11361 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=11361 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=13360 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=13360 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=24206 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=24206 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

UPDATE questions SET total_views = total_views + 1 WHERE quesid='1983'1UPDATE questions SET total_views = total_views + 1 WHERE quesid='1983'

/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()

SELECT * FROM questions WHERE quesid!='1983' AND status='1' AND (question like '%How mark gig "Sold Out"?%' OR question like '%mark%' OR question like '%"Sold%' OR question like '%Out"?%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='1983' AND status='1' AND (question like '%How mark gig "Sold Out"?%' OR question like '%mark%' OR question like '%"Sold%' OR question like '%Out"?%') -- ORDER BY RAND() LIMIT 15

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

SELECT * FROM seoclerks.members WHERE USERID='9' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='9' limit 1

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

SELECT * FROM seoclerks.members WHERE USERID='7171' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='7171' limit 1

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

SELECT * FROM seoclerks.members WHERE USERID='2875' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='2875' limit 1

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

SELECT * FROM seoclerks.members WHERE USERID='5705' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='5705' limit 1

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

SELECT * FROM seoclerks.members WHERE USERID='3489' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='3489' 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=1983%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID 1SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=1983%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

SELECT * FROM categories1SELECT * FROM categories

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

select * from categories_software order by name asc1select * 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 asc1select * 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 asc1select * 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='3764.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='3764.png'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='1.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='1.png'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='8619.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='8619.png'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='4140.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='4140.jpg'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='33379.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='33379.jpg'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

select * from categories_faq order by name asc1select * from categories_faq order by name asc

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()

Invalid SQL

count(*)sql1error_msg

Expensive SQL

Tuning the following SQL could reduce the server load substantially
LoadCountSQLMaxMin

Suspicious SQL

The following SQL have high average execution times
Avg TimeCountSQLMaxMin