SEOClerks

No website app? No Problem! Here's what I did



Write the reason you're deleting this FAQ

No website app? No Problem! Here's what I did

If you're like the majority of people who are asking if there is an app for this marketplace, there isn't, but there is a way to use some other apps and systems to make your notification system come directly to your smartphone.  Yes, it does take a little tinkering and adding a URL here and there, but that's not a big deal if you're serious about selling on this platform.

An app makes the website feel more like it's connected to your mobile device and not just a site that is online.  You can still go to the marketplace and browse anything you want to because the code is super responsive, but a lot of people want an app to click on, so they don't have to type the domain into their browser and start from there.

An app takes a step or two out of the equation, but in today's lifestyle that is cumbersome, which is why my little trick will help you out No website app?  No Problem!  Here


Website Shortcut App
There is an app that allows you to add shortcuts to the screen of your mobile device.  You can go to the play store and search "Website Shortcut," and you will see a few there.  I went with the one that was literally named "Website Shortcut" and I'm glad I did.

Here's what it looks like in the store:

No website app?  No Problem!  Here




All you do is add the URL, Name, and Thumbnail image.

No website app?  No Problem!  Here




When creating a shortcut, you can add literally any URL and thumbnail you want.  I like using various shortcuts for websites I'm frequently on, and you can do the same if you're a seller, but it's really up to you lol.

No website app?  No Problem!  Here


As you can see, I even have a shortcut to a 1-hour loop of Baby Shark because I have a toddler who loves it.  I was sick of opening YouTube, looking for the 1-hour loop version, and then playing it.  Now I click on the shortcut and it auto plays.  My son even figured this out and now takes my phone and clicks on the shortcut all by himself lol.  Since I have YouTube set to open in the app for every video on that platform, it works very well for my purposes and keeps me from pulling out my hair when my son is losing his mind.


Pair with IdealMikes response method
What got me thinking about my shortcut was Mikes trick to getting notifications to his mobile device.  I've been using my shortcut trick for a long time and recently paired it with Mikes method to decrease my response time.  Let me tell you, this pairing works like a charm and helps out a ton if you're a seller.

Mikes method helps you get notifications right to your mobile device, almost immediately, and you can then login and respond to anyone that has left a comment on your orders or pretty much anything you get notified for.

Mikes Response Time Trick:  https://www.seoclerk.com/faq/18654...Sauce-to-Success

I won't go into detail too much because Mike wrote out a discussion for it already, so I'll give you bullet points.

What you can do with Mikes response time trick:
- Ability to update your orders within an hour of them being ordered/updated by the buyer.
- Ability to update your orders within an hour of any update by your buyer.
- Ability to leave your rating within an hour of the buyer completing/rating it.
- Ability to reply to all questions/comments left on your service comments area.



In conclusion
If you want an app for this marketplace, you'll need to pair up my trick with Mikes, and you will essentially have everything you need that an app can provide.  Since the marketplace is responsive, you won't have any problem loading it on your mobile device, and if you're using my trick to use shortcuts then you'll get to the desired page immediately without having to open your browser and type in the URL of where you're trying to go No website app?  No Problem!  Here


Thanks for reading No website app?  No Problem!  Here

- Tommy Carey
https://www.seoclerks.com/user/TommyCarey

Comments

Please login or sign up to leave a comment

Join
anwebservices
Great tip. Actually i will try this application for some other needs too and i like your idea. However i simply use separate email application where i get email notifications from seoclerks (with bell sound too) so i can keep my response time low as much i can and that helps me a lot. Yeah i get notified about some other emails too, but it doesn't worry me to disregard unimportant messages



Are you sure you want to delete this post?

TommyCarey
I get email notifications as well but I like this method better because it streamlines my entire process and allows me to respond as soon as possible. You can literally reduce your response time to mere minutes haha No website app?  No Problem!  Here

The email notification process is pretty good, and it can be used along with my "app" method, but I do like Mikes method as well. You can get the notification and just open up the direct page to your inbox, sales page, manage orders, etc. and take action immediately. It doesn't save a ton of time, but it reduces a couple of steps, and we all know that people like to be lazy and take as few steps as possible to complete a task lol No website app?  No Problem!  Here



Are you sure you want to delete this post?

BrownBackler
this is a great tip. i still think seoclerks should create an app though. it will come much handy



Are you sure you want to delete this post?

TommyCarey
It would definitely come in handy, but you can use this method until the app is started and released to the public No website app?  No Problem!  Here



Are you sure you want to delete this post?

idealmike
Graet post mate!
"until the app is started and released to the public"
Are you saying an app is in the works? No website app?  No Problem!  Here



Are you sure you want to delete this post?

waqasswakeel
Great Idea I'm Thinking That SeoClerk Should Has Their APP Which Help me to Check and Active on my Account outdoor or out of my office.
But Now your Idea is Amazing Let me Try this.



Are you sure you want to delete this post?

Order Now
Process Time: 1.5631959438324

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

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

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

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

SELECT * FROM categories_faq WHERE CATID='43'1SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='43'

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

SELECT * FROM seoclerks.members WHERE USERID=198211SELECT googleplus_profile FROM seoclerks.members WHERE USERID=19821

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

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='28720' 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='28720' 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=187483 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=187483 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=187490 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=187490 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=187507 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=187507 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=187567 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=187567 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=187737 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=187737 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=187834 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=187834 LIMIT 5

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

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

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

SELECT * FROM questions WHERE quesid!='28720' AND status='1' AND (question like '%No website app? Problem! I did%' OR question like '%website%' OR question like '%app?%' OR question like '%Problem!%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='28720' AND status='1' AND (question like '%No website app? Problem! I did%' OR question like '%website%' OR question like '%app?%' OR question like '%Problem!%') -- ORDER BY RAND() LIMIT 15

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

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

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

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

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

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID='1177' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='1177' 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=28720%' 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=28720%' 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='254580.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='254580.jpg'

/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='385509.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='385509.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
4.1351391SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (42,64,90) AND gtags like'%Include%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 404.1351394.135139
0.2070801SELECT COUNT(A.wantid) AS total FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID 0.2070800.207080
0.0819671SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (29,73,74,75,76,104,105) AND gtags like'%ap%' AND type !=99 order by A.lastgigedit desc limit 240, 400.0819670.081967