SEOClerks

Collections (Sub tabs on Services tab)



Write the reason you're deleting this FAQ

Collections (Sub tabs on Services tab)

Just a suggestion for me for Collections or Sub Tabs to the Services Tab.

We want to have Collections
- the SERVICES TAB should have sub tabs under it, so people can choose which services should SEOClerks display - for example, i can put over 50 services, but when a client comes to my profile, they surely won't check all of them and they can't see the BEST services because some of them are on page 3 or so and that's a missed sale...

So when a DJ comes to my profile, they can select SoundCloud Sub Tab and only soundcloud services will be shown.
-Check the screenshot
Collections (Sub tabs on Services tab)

This will bring more sales to everyone. It's very useful for sellers having over 10 services and it's even more useful to buyers.

The sellers, will collect THEIR OWN services, so when buyers come to the profile, they will have more detailed view - they won't miss the services on Page 10.
Instead going from page 1 to page 10 and back to page 7 to find a service for SoundCloud Likes, they can pick the tab for SoundCloud Likes and get only the SoundCloud services for LIKES.

Another example
Collection of services for $1 - a tab that when is clicked will only show services that the seller offers for $1

Comments

Please login or sign up to leave a comment

Join
ionicware
Collections are a definite addition that is needed although they will be called "Packages" (as in an SEO Package). Any more support for this one?



Are you sure you want to delete this post?

Vivadh
yes i am with the idea ..



Are you sure you want to delete this post?

Sean101
Sounds Good. Collections (Sub tabs on Services tab)
I see 2 ideas here though..

1) User Gig Categories..
When someone visits my profile, they hover over tab heading "Services", this bring a drop-down menu of categories, but not all the categories on the marketplace, just the categories for the gigs I have. This could also be done with the "Want to Buy" & "Want to Trade" tabs, although the drop-down menu for them only works once you have click on tab. Collections (Sub tabs on Services tab)

2) Packages / Collections / Bundles..
I will use "Packages" when I type here, but the name of it isn't really relevant in this post. This will be a new 4th tab, after "Services", before "Want to Buy". When you click on this tab, you can then hover over the tab title (just like suggestion 1), the drop-down menu will have Package 1, Package 2, etc.. but they can be renamed by the seller to whatever, these packages will also be on the actual tab too with an image just like the services are on the other tabs. So for example, I could create a package and call it "Advertising Pack", I can add 10 Max services in packages, in this package I add some of my gigs selling ad space on my websites and buyers can buy it as a whole buy ordering the "Advertising Package" from me. These packages could be create just like gigs where you would go to create "Create Package", then Title it, then choose up to 10 gigs to add, set a price for it, add images, etc.. Discounts, codes, etc.. could be added to just like on the create gig page. Collections (Sub tabs on Services tab)



Are you sure you want to delete this post?

Order Now
Process Time: 0.77009916305542

Possible Duplicate queries found!
MatchCountSQLScript
SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-864001SELECT 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='12499'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='12499'

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

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

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

SELECT * FROM categories_faq WHERE CATID='39'1SELECT 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=191461SELECT googleplus_profile FROM seoclerks.members WHERE USERID=19146

/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=12499 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=12499 LIMIT 5

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='12499' 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='12499' 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=59389 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=59389 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=59390 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=59390 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=59391 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=59391 LIMIT 5

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

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

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

SELECT * FROM questions WHERE quesid!='12499' AND status='1' AND (question like '%Collections (Sub tabs Services tab)%' OR question like '%Collections%' OR question like '%(Sub%' OR question like '%tabs%' OR question like '%Services%' OR question like '%tab)%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='12499' AND status='1' AND (question like '%Collections (Sub tabs Services tab)%' OR question like '%Collections%' OR question like '%(Sub%' OR question like '%tabs%' OR question like '%Services%' OR question like '%tab)%') -- ORDER BY RAND() LIMIT 15

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

SELECT * FROM seoclerks.members WHERE USERID='1535' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='1535' 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 11SELECT 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='9399' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='9399' limit 1

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

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

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

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 members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=12499%' 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=12499%' 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='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='59947.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='59947.png'

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

SELECT * FROM seoclerks.members WHERE USERID='1856.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='1856.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