Bigcommerce平台产品展示排序讲解
发表于:2022-11-24 10:23:32浏览:14次TAG:
对于一个店铺来说在平台上,当消费者通过搜索关键词出来商品页面的时候,产品的排放的顺序是很重要的,一般消费者会选择靠前的产品,进行浏览下单,所以想要让自己的产品靠前展示,就要先了解平台产品展示的相关规则,今天我们就详细讲解一下这方面,希望能够帮助商家获得更多的利润,增加成交量。
一、产品展示排序的类型
用户可以选择七种不同的排序类型对店铺上显示的产品进行排序,这七种不同的排序方式是:精选、最新产品、最畅销、按字母顺序排列、按照字母倒叙顺序排列、平均客户评论、价格从高到底、价格从低到高。用户可以通过下拉选择器的方式,选择不同的排序类型,不同的排序类型会有相应的产品在页面上显示,当然产品显示的顺序不同,用户在建站的时候选择的主题不同,那选择器的外观和位置也可能不相同。
二、产品排序订单号规则
在前面讲过产品排序的七种类型,当用户选择精选这个方式的时候,排序顺序号能够让产品在分类页面有更多的选择性,但是如果用户选择的是除了精选这一项的其他六种方式,那这个排序订单号对其来说是没有用处的。
排序订单号规则:
1.当产品是从低到高排序的时候,排序的顺序在30的要比顺序在60的更加靠近顶端
2.在平台默认的规则中,所有产品的排序顺序都是零
3.是允许使用负数的,比如,负一是接近顶端的位置,而不是零
如何更新产品的排序订单号?
点击产品——查看——编辑产品的名称——选择其他详细信息选项——选择排序顺序字段——CSV批量更新顺序
三、默认产品的排序顺
这个是平台设置确定产品在类别页面上的显示顺序,可以通过店铺进行设置也可以通过产品的类别进行编辑,当用户想要突出评论最高或者销量最好,价格最低的时候可以更改产品的默认排序。
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-11-24 12:36:37 HTTP/1.1 GET : http://xn.iwdd.cn/home/article/detail/id/1546.html
- 运行时间 : 0.089500s [ 吞吐率:11.17req/s ] 内存消耗:2,041.99kb 文件加载:151
- 查询信息 : 30 queries
- 缓存信息 : 16 reads,0 writes
- 会话信息 : SESSION_ID=b4ac95b57c2bf1ddb9bb6a3af2e63d12
- CONNECT:[ UseTime:0.000477s ] mysql:host=127.0.0.1;port=3306;dbname=xn_iwdd_cn;charset=utf8mb4
- SHOW FULL COLUMNS FROM `cms_article` [ RunTime:0.000906s ]
- SELECT * FROM `cms_article` WHERE `id` = 1546 LIMIT 1 [ RunTime:0.000479s ]
- SHOW FULL COLUMNS FROM `cms_article_keywords` [ RunTime:0.000620s ]
- SELECT `i`.`aid`,`i`.`keywords_id`,`k`.`title` FROM `cms_article_keywords` `i` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`i`.`keywords_id` WHERE `i`.`aid` = '1546' AND `k`.`status` = '1' ORDER BY `i`.`create_time` ASC [ RunTime:0.000586s ]
- UPDATE `cms_article` SET `read` = `read` + 1 WHERE `id` = 1546 [ RunTime:0.004941s ]
- SHOW FULL COLUMNS FROM `cms_article_cate` [ RunTime:0.000622s ]
- SELECT * FROM `cms_article_cate` ORDER BY `sort` DESC [ RunTime:0.000358s ]
- SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.002149s ]
- SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 2 AND `status` = 1 LIMIT 1 [ RunTime:0.002170s ]
- SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 3 AND `status` = 1 LIMIT 1 [ RunTime:0.002290s ]
- SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 4 AND `status` = 1 LIMIT 1 [ RunTime:0.002063s ]
- SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 5 AND `status` = 1 LIMIT 1 [ RunTime:0.002270s ]
- SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 6 AND `status` = 1 LIMIT 1 [ RunTime:0.002328s ]
- SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 7 AND `status` = 1 LIMIT 1 [ RunTime:0.002086s ]
- SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 8 AND `status` = 1 LIMIT 1 [ RunTime:0.001914s ]
- SHOW FULL COLUMNS FROM `cms_keywords` [ RunTime:0.000659s ]
- SELECT * FROM `cms_keywords` WHERE `status` = 1 ORDER BY rand() , id desc LIMIT 20 [ RunTime:0.000390s ]
- SELECT `a`.`id`,`a`.`title`,`a`.`thumb`,`a`.`create_time`,`a`.`read`,`a`.`desc`,`f`.`filepath` FROM `cms_article` `a` LEFT JOIN `cms_file` `f` ON `a`.`thumb`=`f`.`id` WHERE `a`.`status` = '1' ORDER BY rand() , a.id desc LIMIT 10 [ RunTime:0.015213s ]
- SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '4023' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000490s ]
- SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '2571' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000395s ]
- SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3413' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000346s ]
- SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '2836' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000307s ]
- SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '335' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000287s ]
- SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1886' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000270s ]
- SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '4396' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000297s ]
- SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3794' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000394s ]
- SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '120' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000373s ]
- SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '845' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000340s ]
- SHOW FULL COLUMNS FROM `cms_user_log` [ RunTime:0.000601s ]
- INSERT INTO `cms_user_log` SET `uid` = 0 , `nickname` = '游客' , `type` = 'view' , `title` = '查看' , `content` = '游客在2024-11-24 12:36:37查看了Bigcommerce平台产品展示排序讲解文章详情' , `param_id` = 1546 , `param` = '[]' , `module` = 'home' , `controller` = 'article' , `function` = 'detail' , `ip` = '18.116.52.43' , `create_time` = 1732422997 [ RunTime:0.004582s ]
0.097166s