SEOClerks

How do you search for US Sellers?



Write the reason you're deleting this FAQ

How do you search for US Sellers?

In my experience on SEOClerks, I find that US sellers often offer more customer service then foreign sellers. Communication is better, and the overall experience is much more enjoyable. Not to mention, the services offered are genuine and not bot automated.

Therefore, I would like to know if anyone knows how to search US Sellers on SEOClerks, and if not, I believe this is a feature that SEOClerks should have. As it would improve buyer satisfaction and overall optimization.

Comments

Please login or sign up to leave a comment

Join
procoder
Hi, it's not possible to sort freelancers by country. But, if you want to hire a freelancer go to this link https://www.seoclerk.com/freelancers

Thank you,
Procoder



Are you sure you want to delete this post?

TommyCarey
When you do a search for a service you want to purchase, you can see that there are flags on the listings and that's how you can determine who is from the United States and anywhere else in the world.

I actually need some programming done so I did a search to use as an example.

The path I took was Marketplace >> Programming >> PHP

I then looked through the freelancers that popped up who are offering PHP services, but I did not click on any yet. This is where you can search for people from the United States.

Look on the listings that are showing up and you can see the flags. If you want freelancers from the United States then you'll want to right click and open in new tab on all the users with an American Flag

A quick shot of what I saw:
How do you search for US Sellers?
I quickly found 2 freelancers on SeoClerks offering programming.

This is the only way to search based on country of origin, but it should work for you just fine How do you search for US Sellers?

I wouldn't count out people in other countries though. If you're worried about the response time, just look at their profile page and see how long on average it will take them to respond. I've found tons of freelancers from other countries here on SeoClerks and I've sent each of them multiple orders after the first test order. Don't count someone out just because they're from another country that is not the USA ;)

Thanks,

Razzy



Are you sure you want to delete this post?

idealmike
Yeah I agree with the OP. I guess it's because they talk the same English language so there is no language barrier or confusion in translation like there can be when you're talking to a non-US seller or buyer or just person sometimes. I'd imagine though that non-US people say the same thing about speaking to people in their own language in that it would probably be easier for them to speak to someone that speaks the same language as they do. And when it's easier, that's what makes the experience a better one. Where as it's not always possible to have that same level of communication and understanding like there is when two people speak different languages. So it's definitely the language that helps make the experience a better one when working as a freelancer or a buyer of a freelancers services.
Therefore, I would like to know if anyone knows how to search US Sellers on SEOClerks, and if not, I believe this is a feature that SEOClerks should have. As it would improve buyer satisfaction and overall optimization.

Well, other than the flags you see on peoples profiles you can also see the flag on the service you are interested in on any category so you can know which ones are by US sellers for example. And you can always create a Want To Buy as well requesting some work by US sellers only. Although depending on what you're asking for you might get a few non-US people place a bid anyway just because they can. Actually, it would be good if you could create a WTB but limit only certain countries sellers from bidding on it that could be good but creating one asking for something and stating that you want only a US seller would probably do the trick just as well.

Hope this helps!

Mike.



Are you sure you want to delete this post?

ajlancer
Hi BroadcastKing thanks for your question and I agree with your feel and yes if your seller or buyer from same country, you can communicate more easily rather than non native. But I have little question, do you want quality service or just want good communication? If you prefer only good communication for understanding each other, I have no more word to say such matter. But, as my common sense say everybody should search good quality of service either afford to good communication.
Moreover, SEOclerks still does not add such feature for filtering by country. So, if you want to know or searching seller from your country like USA, please visit each seller profile to know and there must to see country flag.

Thanks by Ajlancer



Are you sure you want to delete this post?

BroadcastKing
Just wanted to Thank all you guys for the Quick reply, and Yes, I understand that other people that speak other languages may also like to organize the flags by sellers that speak their native tongue. So this would be great if it was not just US Sellers, but also for all countries. Reason being, even though I can see some US Sellers on the list, and I can just click those, it would be much more helpfull to me, to see an entire list of just US Flags. As someone else, would like to see an entire list of just their flags. Communication is key, and I value that over pricing and feedbacks.



Are you sure you want to delete this post?

EliteWriter
You can see the flag on a seller's profile page, but I do not think you can sort by country. Having said that I would like to point out that although I respect your opinion that you want a US seller I do not think that you can generalize. There are many non US sellers who can offer prompt replies, quick turnaround and a great quality service. Rather than focusing on the country I suggest you check the reputation of the seller by seeing his or her rating, and the recommendations that are available on the profile page of each seller.



Are you sure you want to delete this post?

Everett
I totally agree with you. You can not judge one's character, customer service, or quality of service solely based upon the country they reside in. The marketplace is global, and therefore will have sellers around the globe. Sure, some sellers may not properly speak English as well as a native English speaker but that doesn't mean that their services quality isn't as good as another person who speaks English fluently.



Are you sure you want to delete this post?

Order Now
Process Time: 0.24734401702881

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='17566'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='17566'

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

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

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

SELECT * FROM seoclerks.members WHERE USERID=4781921SELECT googleplus_profile FROM seoclerks.members WHERE USERID=478192

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

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='17566' 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='17566' 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=95706 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=95706 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=95709 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=95709 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=95714 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=95714 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=95855 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=95855 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=95724 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=95724 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=95750 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=95750 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=95820 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=95820 LIMIT 5

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

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

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

SELECT * FROM questions WHERE quesid!='17566' AND status='1' AND (question like '%How search Sellers?%' OR question like '%search%' OR question like '%Sellers?%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='17566' AND status='1' AND (question like '%How search Sellers?%' OR question like '%search%' OR question like '%Sellers?%') -- ORDER BY RAND() LIMIT 15

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

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

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

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID='632' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='632' 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=17566%' 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=17566%' 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='377074.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='377074.png'

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

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

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

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

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

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID='2951.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='2951.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
0.1420711SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%WebDeveloper%' OR A.skills LIKE '%WebDeveloper%') ORDER BY A.lastgigedit desc LIMIT 0,400.1420710.142071