SEOClerks

Custom Magento Features + Floating Footer Flash Ad Banner

Custom Magento Features + Floating Footer Flash Ad Banner

I need someone to copy some Magento features from a competitors website and feature it on my home page.

You need to implement these two features organized on my page.

#1 - Custom Search - This will be the main feature that gets customers to interact with the website. The source that has this feature is Vapor Nation , please visit the site and bid accordingly of how much work it will take.

Step 1 - Customers Choose what type of vaporizer they want - portable, desktop or pen


Step 2 - Customers choose the material they want the vaporizer to utilize : Oils, waxes or herb.

Step 3 - If users chose portable they choose the type of materials they want to vape with: Herbs, Oils or Waxes and on Step 3 they choose the Heating Source: Butane, Flame or Battery . If users choose Desktop - Users choose for step 2 the materials they want to vape with - Oils, waxes or herbs and then they choose the delivery method: Whip-style, Forced-air or dual.

Step 3 Portable (Image Below)


Last Step is the Results. A bunch of vaporizer listings from what the users imputed shows the results within the search box.



#2 -
Floating Count Down Banner- Please see Vapor Nation to check out the floating banner that has a countdown on specific store wide savings and different offers depending what they promote throughout the holidays.


Requirements

Requirements :

  • Must be an expert in understanding + Programming Magento Coding
  • Must be an expert in PHP, SQL, Java, CSS, HTML
  • Must know how to design and structure websites
  • Must be an expert in graphics
  • Must know and understand what and how to read codes and implement coding
  • Must complete this job exactly as I need and describe.


By bidding and accepting this job, you must agree if I feel you're lazy, slacking, not knowledge with this job or can complete it, I can cancel with a full refund at any time and any of your work done is yours to keep and legally I wouldn't be allowed to use it if this were to be canceled.

Note - I will pay bonuses for performance, communication, straight time worked and speed as well as experience and expertise. Im a serious businessman, take work seriously and expect perfect results.


Skills Required

Php Sql Java Javascript Magento Htm Html Css Python Ecommerce Graphics Design Development Magentodevelop Expert

Bids

order now ..inbox me for more discuss

Bid On Listing Created 10 years ago in Programming

Other jobs by johnuno11

Order Now
Process Time: 0.80196595191956

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 wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='33165' 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='33165' AND A.category=B.CATID AND A.USERID=C.USERID

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

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

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

SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 33165 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Php Sql Java Javascript Magento Htm Html Css Python Ecommerce Graphics Design Development Magentodevelop Expert%' ) LIMIT 41SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 33165 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Php Sql Java Javascript Magento Htm Html Css Python Ecommerce Graphics Design Development Magentodevelop Expert%' ) LIMIT 4

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

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

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

SELECT * FROM wantcomments a, seoclerks.members b WHERE a.PID='33165' 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='33165' 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='33165'1UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='33165'

/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='33165' 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='33165' ORDER BY w.bidid ASC

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

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

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

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

/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=420081SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=42008

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

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

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

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

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

/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.1467911SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 75691 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%ANDROID Application app%' ) LIMIT 40.1467910.146791
0.1394121SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 33165 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Php Sql Java Javascript Magento Htm Html Css Python Ecommerce Graphics Design Development Magentodevelop Expert%' ) LIMIT 40.1394120.139412