SEOClerks

eCommerce Apple products bidding/auction store

eCommerce Apple products bidding/auction store

I need some professionals to create a web/internet store where i can both sell apple products for a pre fixed price and a auction/bidding system which auto bids the product untill the specified minimum price is archieved.

the product line will be mainly Apple iPhone's

there should be seperate sections or pages in the same internet site, where one will be selling all the items with different specifications for a fixed price like "buy it now" and another page should contain auctioning items.

items in the fixed section should be seperated and put for sale by type of iPhone and cappacity,
i.e. iPhone 7 32gb iPhone 7 64gb etc and iPhone 7+ 32gb etc.
when the costumer clicks on the iPhone he wants, then he can choose the color for the phone and place an order.

for the page with auctions;
there should be iPhones with different types (i.e. 7 and 7+) and also different colors and gb's listed in auction page.
these auctions should be renewed and reauctioned when they end so we can ship the phone to whom won the last auction and start a new one automatically so new costumers can bid.

the start page should contain both few items from "buy it now" and auction bidding. Like; "hot sellings"

there should also be;
contact us
about us
costumer login page / user page and "my account" page containing users purchases and status for the bought item.
customer service page with live chat and the chat and if its possible the chat should also be linked to phone number or some form for alerting or sending push notification or such so the person who is hired to answer the questions get notified.

items will be paid with either creditcard or bank debit card worldwide

the whole website must be dynamic and mobile friendly.
it must also be seo friendly.
we will also use time to time seo boost services, so if you also work with this, its bonus for you.

if you also can create a app, this is a bonus for you, and we can also pay you for that.

the website should look clean and apple.com alike theme. Menu bars etc should look nice like apple.

the website should also have compatibility to add ad banners at left and right.

there should also be email service which sends emails to customers weekendly with discount coupons.

customer information should be stored in a database which site administrators can use to search for orders and payments name surname phone number email etc to find the costumer.

there should also be a lojality function wich customer can have a link and give it to its friends so if someone comes to the site with that referer link and buys, the customer gets % of the made purchase every time. And the costumer has its own lojality card too wich is if he buys i.e. 20 phones, he gets one for half price.

The site can be built from scratch or by using wordpress joomla or other platforms.

let us hear if you can deliver this for us, and what your price would be, and how long it will take to deliver this work.


Requirements

Seo level 3 or higher is prioritized.
web design
online store
application


Skills Required

Webdesign Webdesigner Wordpress Joomla Programming Website

Bids

hi, i will design clean and professional ecommerce store for apple products. i have excellent experience in ecommerce web store designing. i will provide high quality work with complete satisfaction. if you still looking for it then do contact me for further communication.
examples:
http://www.true-renegade.myshopify.com
https://cosmic-ore.mysho

consider it done! we are experts in joomla,wordpress, core php, html, css and bootstrap technologies. we are certified
professionals having combined experience of 25 years.



we have brought customization jobsfor joomla and wordpress. our head joomla developer has 10 years of experience
so practically he has been around when joomla wa

no need to explain much and to complicate stuff. all i can say is this is what our agency will be providing

  • installation of the website depending on your needs
  • full time customer support even after sales
  • all the feautures you want

here are some extras our agency can give
  1. wp plugins to help your marketin

i can do it for 500$ but you should spend little more to buy some php tools for this
is it ok
estimate fulll cost less than 600$
gurenteed
for your apple product store

ecommerce apple products bidding/auction store

since you are planning to create an online store or an e-commerce site with an extra function of bidding, we can help you with it. the functionalities are similar to our project. i.e an e-commerce site of nepal. http://nfinityplus.com/ this was not a costly project but for apple products we need to work on the designs and functionalities as w

Bid On Listing Created 9 years ago in Programming

Other jobs by OneShootDown

Order Now
Process Time: 0.17906498908997

Possible Duplicate queries found!
MatchCountSQLScript
SELECT * FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='52756' AND A.category=B.CATID AND A.USERID=C.USERID1SELECT A.*, B.name, B.seo, C.username, C.userlevel, C.footer_code, C.rating, C.ratingcount, C.googleplus_profile, C.total_recommendations, C.USERID, C.profilepicture, C.average_response_time, C.lastlogin, C.addtime FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='52756' AND A.category=B.CATID AND A.USERID=C.USERID

/opt/clerks-staging/docroot/viewwant.php 163 () ()

SELECT * FROM ratings_buyer WHERE USERID=2750531SELECT sum(good) as thumbup, sum(bad) as thumbdown FROM ratings_buyer WHERE USERID=275053

/opt/clerks-staging/docroot/include/functions/main.php 19523 GetRatingsAsBuyerTotal() ()

SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 52756 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Webdesign Webdesigner Wordpress Joomla Programming Website%' ) LIMIT 41SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 52756 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Webdesign Webdesigner Wordpress Joomla Programming Website%' ) LIMIT 4

/opt/clerks-staging/docroot/viewwant.php 551 () ()

SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 52756 AND A.category=B.CATID AND A.active=1 AND A.USERID=275053 LIMIT 41SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 52756 AND A.category=B.CATID AND A.active=1 AND A.USERID=275053 LIMIT 4

/opt/clerks-staging/docroot/viewwant.php 568 () ()

SELECT * FROM wantcomments a, seoclerks.members b WHERE a.PID='52756' AND a.USERID=b.USERID and b.status='1' AND a.status=1 order by a.CID asc1SELECT a.comment, a.USERID, a.CID, a.time_added, a.istranslated, a.parentid, b.username, b.profilepicture FROM wantcomments a, seoclerks.members b WHERE a.PID='52756' AND a.USERID=b.USERID and b.status='1' AND a.status=1 order by a.CID asc

/opt/clerks-staging/docroot/viewwant.php 835 () ()

UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='52756'1UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='52756'

/opt/clerks-staging/docroot/include/functions/main.php 1729 update_wantviewcount() ()

SELECT * FROM wantbids as w, seoclerks.members AS m WHERE w.active=1 AND m.USERID=w.USERID AND m.status=1 AND w.USERID>0 AND w.wantid='52756' ORDER BY w.bidid ASC 1SELECT w.bidid, w.PID, w.comment, w.title, w.pricepublic, w.USERID, w.adjustedprice, w.ip, m.profilepicture FROM wantbids as w, seoclerks.members AS m WHERE w.active=1 AND m.USERID=w.USERID AND m.status=1 AND w.USERID>0 AND w.wantid='52756' ORDER BY w.bidid ASC

/opt/clerks-staging/docroot/viewwant.php 1192 () ()

SELECT * FROM seoclerks.members as m WHERE m.USERID=5867881SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=586788

/opt/clerks-staging/docroot/viewwant.php 1258 () ()

SELECT * FROM seoclerks.members as m WHERE m.USERID=5953081SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=595308

/opt/clerks-staging/docroot/viewwant.php 1258 () ()

SELECT * FROM seoclerks.members as m WHERE m.USERID=5853561SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=585356

/opt/clerks-staging/docroot/viewwant.php 1258 () ()

SELECT * FROM seoclerks.members as m WHERE m.USERID=4097401SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=409740

/opt/clerks-staging/docroot/viewwant.php 1258 () ()

SELECT * FROM seoclerks.members as m WHERE m.USERID=4372281SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=437228

/opt/clerks-staging/docroot/viewwant.php 1258 () ()

SELECT * FROM seoclerks.members as m WHERE m.USERID=4950651SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=495065

/opt/clerks-staging/docroot/viewwant.php 1258 () ()

SELECT * FROM categories_wanttobuy1SELECT * FROM categories_wanttobuy

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

SELECT * FROM posts WHERE USERID=2750531SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=275053

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID='275053'1SELECT profile_data FROM seoclerks.members WHERE USERID='275053'

/opt/clerks-staging/docroot/include/functions/main.php 1927 getUserBackground() include()

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.2817401SELECT 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 ORDER BY A.viewcount desc LIMIT 0,400.2817400.281740
0.1116991SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 52756 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Webdesign Webdesigner Wordpress Joomla Programming Website%' ) LIMIT 40.1116990.111699
0.1053021SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 47466 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Youtube Youtubecomment Yo Youtubelikes%' ) LIMIT 40.1053020.105302