Morning Harvest is an offline silver jewelry brand targeting the Hong Kong market. To assist in establishing a premium, trustworthy digital image and meet complex e-commerce operational needs, ROLLLL DESIGN was responsible for the overall website architecture, in-depth development of the frontend user experience, and backend management system. This project aims to create a one-stop e-commerce platform that not only beautifully showcases jewelry products but also drives member loyalty and enables precision marketing.
Main Highlights
Intelligent Membership System & Dynamic Tiering Engine: We developed the core membership rule engine, which supports automatic VIP tier upgrades for customers based on their accumulated spending. The backend provides highly customizable condition-setting capabilities (such as specifying spending amounts within defined time periods), enabling clients to flexibly design loyalty programs and achieve precise customer segmentation and lifecycle management.
Flexible Product Management & Personalized Frontend Display: We built a robust product management backend that supports setting independent pricing and inventory for a single product (e.g., a ring) based on different specifications such as color and size. On the frontend, we implemented multi-dimensional display and sorting (e.g., by new arrivals, bestsellers, recommendations) and record browsing history for each user to provide a personalized browsing experience, effectively boosting conversion and repeat purchase rates.
Automated Marketing Tools & Integrated Customer Outreach: Pop-up & Shopping Credit Strategy: Can be configured to display a pop-up to first-time visitors and grant shopping credit. The rules are customizable (e.g., credit upon reaching a certain spend threshold) and can have an expiration date.
Result
Through ROLLLL DESIGN's customized development, Morning Harvest has successfully transformed from a jewelry brand into an online store with deeply integrated functionalities, autonomous operations, and a seamless user experience. This platform has significantly enhanced the client's operational efficiency and data-driven decision-making capabilities, establishing a core technological engine for sustainable growth within the highly competitive online jewelry market.
Free Consultation
Get Free Consultation Now
Our professional team has rich technical experience and advanced development capabilities, and can tailor IT technical solutions for you according to your needs.
We will reply to you within one day
基本文件流程错误SQL调试
请求信息 : 2026-06-16 10:14:30 HTTP/2.0 GET : https://rolllldesign.com/en/portfolio/morning-harvest.html
SHOW FULL COLUMNS FROM `dlm_user` [ RunTime:0.001168s ]
SELECT * FROM `dlm_user` WHERE `status` = 1 AND `token` = 'IQgMASigQqeRBupHLONwCyxaU' LIMIT 1 [ RunTime:0.000352s ]
SHOW FULL COLUMNS FROM `dlm_site` [ RunTime:0.000720s ]
SELECT * FROM `dlm_site` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000265s ]
SHOW FULL COLUMNS FROM `dlm_nav` [ RunTime:0.000690s ]
SELECT `id`,COALESCE(name_en, name) as name,COALESCE(sub_en, sub) as sub,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,parent_id as parentid,`linkurl`,COALESCE(title_en, title) as title,COALESCE(keywords_en, keywords) as keywords,COALESCE(description_en, description) as description FROM `dlm_nav` WHERE `tpl` = 'morning-harvest' AND `catid` = -1 ORDER BY `status` DESC LIMIT 1 [ RunTime:0.000255s ]
SELECT `id`,COALESCE(name_en, name) as name,COALESCE(sub_en, sub) as sub,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,parent_id as parentid,`linkurl`,COALESCE(title_en, title) as title,COALESCE(keywords_en, keywords) as keywords,COALESCE(description_en, description) as description FROM `dlm_nav` WHERE `status` = 1 AND `linkurl` LIKE '%morning-harvest.html%' ORDER BY `status` DESC LIMIT 1 [ RunTime:0.000207s ]
SELECT `id`,COALESCE(name_en, name) as name,COALESCE(sub_en, sub) as sub,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,parent_id as parentid,`linkurl`,COALESCE(title_en, title) as title,COALESCE(keywords_en, keywords) as keywords,COALESCE(description_en, description) as description FROM `dlm_nav` WHERE `status` = 1 AND `linkurl` LIKE '%morning-harvest%' ORDER BY `status` DESC LIMIT 1 [ RunTime:0.000205s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `status` = 1 AND `parent_id` = 0 ORDER BY `sort` ASC [ RunTime:0.000198s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 14 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000239s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 15 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000187s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 15 AND `thumb_url` LIKE '%images%' ORDER BY `sort` ASC LIMIT 3 [ RunTime:0.000198s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 22 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000232s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 22 AND `thumb_url` LIKE '%images%' ORDER BY `sort` ASC LIMIT 3 [ RunTime:0.000214s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 27 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000288s ]
SHOW FULL COLUMNS FROM `dlm_article` [ RunTime:0.000915s ]
SELECT `id`,title_en as name,url_en as linkurl,`thumb_url`,thumb_alt_en as thumb_alt FROM `dlm_article` WHERE `status` = 1 ORDER BY `is_rec` DESC,`sort` ASC LIMIT 3 [ RunTime:0.000334s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 30 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000230s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `status` = 1 AND `parent_id` = 0 ORDER BY `sort` ASC [ RunTime:0.000487s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 14 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000288s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 15 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000226s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 15 AND `thumb_url` LIKE '%images%' ORDER BY `sort` ASC LIMIT 3 [ RunTime:0.000238s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 22 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000222s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 22 AND `thumb_url` LIKE '%images%' ORDER BY `sort` ASC LIMIT 3 [ RunTime:0.000221s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 27 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000290s ]
SELECT `id`,title_en as name,url_en as linkurl,`thumb_url`,thumb_alt_en as thumb_alt FROM `dlm_article` WHERE `status` = 1 ORDER BY `is_rec` DESC,`sort` ASC LIMIT 3 [ RunTime:0.000332s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 30 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000253s ]
SHOW FULL COLUMNS FROM `dlm_weblink` [ RunTime:0.000924s ]
SELECT * FROM `dlm_weblink` ORDER BY `sort` ASC [ RunTime:0.000220s ]
SHOW FULL COLUMNS FROM `dlm_ai_stats` [ RunTime:0.001052s ]
SHOW FULL COLUMNS FROM `dlm_goods` [ RunTime:0.001133s ]
SELECT g_result_en as result,g_cdate as create_time,b.thumb as cat_thumb,g_link as link,seo_title_en as seo_title,seo_keywords_en as seo_keywords,seo_description_en as seo_description,b.catname_en as catname_en,b.catname as catname_cn,`b`.`catid`,g_imgs as imgs,g_tag_en as tag,g_thumb as thumb,g_thumb_alt_en as thumb_alt,g_description_en as description,g_content_en as content,g_param as param,g_ad_en as ad,g_sub_en as sub,g_ids as ids,g_extra as extra,g_name_en as name FROM `dlm_goods` `a` LEFT JOIN `dlm_goods_cat` `b` ON `b`.`catid`=`a`.`g_cat2` WHERE `a`.`g_state` = '2' AND `a`.`g_seo_en` = 'morning-harvest' LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,name_en as name,`catid`,sub_en as sub,`thumb_url`,thumb_alt_en as thumb_alt,parent_id as parentid,`linkurl`,title_en as title,keywords_en as keywords,description_en as description FROM `dlm_nav` WHERE `tpl` = 'portfolio' AND `catid` = 1 ORDER BY `parent_id` ASC,`id` ASC LIMIT 1 [ RunTime:0.000320s ]
SHOW FULL COLUMNS FROM `dlm_web` [ RunTime:0.001689s ]
SELECT id as w_id,`page_code`,`mp4`,name_en as name,link_name_en as link_name,`link_url`,sub_en as sub,description_en as description,`k`,`image_url`,image_url_alt_en as image_url_alt,`tpl`,`data1`,`data2`,`data3`,`data4`,`data5`,`data6`,`data7`,`data8`,`data9`,`data10`,`data11`,`data12`,`data13`,`data14`,`data1_image_url`,data1_image_alt_en as data1_image_alt,`data1_out_mp4`,`data1_type`,`data1_show`,`data2_image_url`,data2_image_alt_en as data2_image_alt,`data2_out_mp4`,`data2_type`,`data2_show`,`data3_image_url`,data3_image_alt_en as data3_image_alt,`data3_out_mp4`,`data3_type`,`data3_show`,`data4_image_url`,data4_image_alt_en as data4_image_alt,`data4_out_mp4`,`data4_type`,`data4_show`,`data5_image_url`,data5_image_alt_en as data5_image_alt,`data5_out_mp4`,`data5_type`,`data5_show`,`data6_image_url`,data6_image_alt_en as data6_image_alt,`data6_out_mp4`,`data6_type`,`data6_show`,`data7_image_url`,data7_image_alt_en as data7_image_alt,`data7_out_mp4`,`data7_type`,`data7_show`,`data8_image_url`,data8_image_alt_en as data8_image_alt,`data8_out_mp4`,`data8_type`,`data8_show`,`data9_image_url`,data9_image_alt_en as data9_image_alt,`data9_out_mp4`,`data9_type`,`data9_show`,`data10_image_url`,data10_image_alt_en as data10_image_alt,`data10_out_mp4`,`data10_type`,`data10_show`,`data11_image_url`,data11_image_alt_en as data11_image_alt,`data11_out_mp4`,`data11_type`,`data11_show`,`data12_image_url`,data12_image_alt_en as data12_image_alt,`data12_out_mp4`,`data12_type`,`data12_show`,`data13_image_url`,data13_image_alt_en as data13_image_alt,`data13_out_mp4`,`data13_type`,`data13_show`,`data14_image_url`,data14_image_alt_en as data14_image_alt,`data14_out_mp4`,`data14_type`,`data14_show` FROM `dlm_web` WHERE `catdir` = 'home' LIMIT 1 [ RunTime:0.000595s ]
