PROJECT Title: Create a CMS Landing Page in Magento that would include 3 columns to display several of our products that are sale items.
About Nightingale-Conant: Please visit our website at: www.nightingale.com Nightingale-Conant is the world's largest publisher of personal and spiritual growth audio programs. We have been in business for over 50 years and have published many top speakers/authors such as: Tony Robbins, Wayne Dyer, Marianne Williamson, and many, many more. We publish high-end programs in the price range between 9.95 and 999.95.
Project Description: Nightingale-Conant is relatively new to the Magento platform (we were previously on WordPress) . We need a template created for our sale items. We can drop in the products and all the details, pricing, etc. , we need the template created.
Sample of sale pages we like:
http://www.thegreatcourses.com/courses/all-formats/dvd?id=51136354&ai=114895&sa=MTH&cm_mmc=email-_-Email114895_20150502-_-body-_-shopnow&cmp=email
I like that this page has an area above the products for an image or copy that would describe the sale: http://www.thegreatcourses.com/tgc/courses/specialoffer?id=51136354&ai=114600&sa=MTH77&cm_mmc=email-_-Email114600_20150415-_-body-_-shopnow&cmp=email
CREATE THE SALE PAGE guidelines:
Must be responsive (mobile friendly)
Include our logo in the top area
Must include an area above the product areas for an image or at least headline and subhead copy.
Below the headline/sub head we want the sale items to be displayed in 3 columns.
Sale items should have 3 columns and allow for 18 or more products to be displayed.
for each of the products the following needs to be displayed (from the product database)
product image
product Title
Author
short description
retail price (only if the retail price can be displayed with a strikethrough (ie $89.95 )
Sale price
% discount from retail price
Learn More hyperlink (would link to the full product product page)
Add to cart button
PLEASE PROVIDE AN ESTIMATE OF WHAT IT WOULD COST TO CREATE THIS TEMPLATE SO WE COULD POPULATE IT WITH DIFFFERENT PRODUCTS.
PROJECT Title: Create a CMS Landing Page in Magento that would include 3 columns to display several of our products that are sale items.
About Nightingale-Conant: Please visit our website at: www.nightingale.com Nightingale-Conant is the world's largest publisher of personal and spiritual growth audio programs. We have been in business for over 50 years and have published many top speakers/authors such as: Tony Robbins, Wayne Dyer, Marianne Williamson, and many, many more. We publish high-end programs in the price range between 9.95 and 999.95.
Project Description: Nightingale-Conant is relatively new to the Magento platform (we were previously on WordPress) . We need a template created for our sale items. We can drop in the products and all the details, pricing, etc. , we need the template created.
Sample of sale pages we like:
http://www.thegreatcourses.com/courses/all-formats/dvd?id=51136354&ai=114895&sa=MTH&cm_mmc=email-_-Email114895_20150502-_-body-_-shopnow&cmp=email
I like that this page has an area above the products for an image or copy that would describe the sale: http://www.thegreatcourses.com/tgc/courses/specialoffer?id=51136354&ai=114600&sa=MTH77&cm_mmc=email-_-Email114600_20150415-_-body-_-shopnow&cmp=email
CREATE THE SALE PAGE guidelines:
Must be responsive (mobile friendly)
Include our logo in the top area
Must include an area above the product areas for an image or at least headline and subhead copy.
Below the headline/sub head we want the sale items to be displayed in 3 columns.
Sale items should have 3 columns and allow for 18 or more products to be displayed.
for each of the products the following needs to be displayed (from the product database)
product image
product Title
Author
short description
retail price (only if the retail price can be displayed with a strikethrough (ie $89.95 )
Sale price
% discount from retail price
Learn More hyperlink (would link to the full product product page)
Add to cart button
PLEASE PROVIDE AN ESTIMATE OF WHAT IT WOULD COST TO CREATE THIS TEMPLATE SO WE COULD POPULATE IT WITH DIFFFERENT PRODUCTS.
Let me know if the attached project is something you would be interested in doing.
If interested, please send your estimate.
hi!
i can complete your requirement as per your needs. i can complete it within your estimated budget itself. it doesn't takes me 5 days to complete. i can finish it within 5 days itself.
| Match | Count | SQL | Script |
| SELECT * FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='29021' AND A.category=B.CATID AND A.USERID=C.USERID | 1 | SELECT 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='29021'
AND A.category=B.CATID AND A.USERID=C.USERID | /opt/clerks-staging/docroot/viewwant.php 163 () () |
| SELECT * FROM ratings_buyer WHERE USERID=42070 | 1 | SELECT sum(good) as thumbup, sum(bad) as thumbdown
FROM ratings_buyer WHERE USERID=42070 | /opt/clerks-staging/docroot/include/functions/main.php 19523 GetRatingsAsBuyerTotal() () |
| SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 29021 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Magento%' ) LIMIT 4 | 1 | SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo
FROM wanttobuy A,
categories_wanttobuy B
WHERE A.wantid != 29021
AND A.category=B.CATID
AND A.active=1
AND (A.tags like '%Magento%' ) LIMIT 4 | /opt/clerks-staging/docroot/viewwant.php 551 () () |
| SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 29021 AND A.category=B.CATID AND A.active=1 AND A.USERID=42070 LIMIT 4 | 1 | SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo
FROM wanttobuy A, categories_wanttobuy B
WHERE A.wantid != 29021
AND A.category=B.CATID
AND A.active=1
AND A.USERID=42070
LIMIT 4 | /opt/clerks-staging/docroot/viewwant.php 568 () () |
| SELECT * FROM wantcomments a, seoclerks.members b WHERE a.PID='29021' AND a.USERID=b.USERID and b.status='1' AND a.status=1 order by a.CID asc | 1 | SELECT 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='29021' 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='29021' | 1 | UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='29021' | /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='29021' ORDER BY w.bidid ASC | 1 | SELECT 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='29021'
ORDER BY w.bidid ASC
| /opt/clerks-staging/docroot/viewwant.php 1192 () () |
| SELECT * FROM seoclerks.members as m WHERE m.USERID=359296 | 2 | SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations
FROM seoclerks.members as m
WHERE m.USERID=359296 SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=359296 | /opt/clerks-staging/docroot/viewwant.php 1258 () () /opt/clerks-staging/docroot/viewwant.php 1258 () () |
| SELECT * FROM seoclerks.members as m WHERE m.USERID=359977 | 1 | SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations
FROM seoclerks.members as m
WHERE m.USERID=359977 | /opt/clerks-staging/docroot/viewwant.php 1258 () () |
| SELECT * FROM categories_wanttobuy | 1 | SELECT * FROM categories_wanttobuy | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache() |
| SELECT * FROM posts WHERE USERID=42070 | 1 | SELECT sum(positive_ratings) as thumbup,
sum(negative_ratings) as thumbdown
FROM posts
WHERE USERID=42070 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetBuyerRatingsTotal() |
| SELECT * FROM categories | 1 | SELECT * FROM categories | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache() |
| select * from categories_software order by name asc | 1 | select * 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 asc | 1 | select * 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 asc | 1 | select * 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='359296' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='359296' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='359977' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='359977' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='42070' | 1 | SELECT profile_data FROM seoclerks.members WHERE USERID='42070' | /opt/clerks-staging/docroot/include/functions/main.php 1927 getUserBackground() include() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
| Avg Time | Count | SQL | Max | Min |
| 0.113452 | 1 | SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Mug%') ORDER BY total_recommendations desc LIMIT 0,40 | 0.113452 | 0.113452 |
