Bigcommerce平台产品展示排序讲解
发表于:2022-11-24 10:23:32浏览:11次TAG:
对于一个店铺来说在平台上,当消费者通过搜索关键词出来商品页面的时候,产品的排放的顺序是很重要的,一般消费者会选择靠前的产品,进行浏览下单,所以想要让自己的产品靠前展示,就要先了解平台产品展示的相关规则,今天我们就详细讲解一下这方面,希望能够帮助商家获得更多的利润,增加成交量。
一、产品展示排序的类型
用户可以选择七种不同的排序类型对店铺上显示的产品进行排序,这七种不同的排序方式是:精选、最新产品、最畅销、按字母顺序排列、按照字母倒叙顺序排列、平均客户评论、价格从高到底、价格从低到高。用户可以通过下拉选择器的方式,选择不同的排序类型,不同的排序类型会有相应的产品在页面上显示,当然产品显示的顺序不同,用户在建站的时候选择的主题不同,那选择器的外观和位置也可能不相同。
二、产品排序订单号规则
在前面讲过产品排序的七种类型,当用户选择精选这个方式的时候,排序顺序号能够让产品在分类页面有更多的选择性,但是如果用户选择的是除了精选这一项的其他六种方式,那这个排序订单号对其来说是没有用处的。
排序订单号规则:
1.当产品是从低到高排序的时候,排序的顺序在30的要比顺序在60的更加靠近顶端
2.在平台默认的规则中,所有产品的排序顺序都是零
3.是允许使用负数的,比如,负一是接近顶端的位置,而不是零
如何更新产品的排序订单号?
点击产品——查看——编辑产品的名称——选择其他详细信息选项——选择排序顺序字段——CSV批量更新顺序
三、默认产品的排序顺
这个是平台设置确定产品在类别页面上的显示顺序,可以通过店铺进行设置也可以通过产品的类别进行编辑,当用户想要突出评论最高或者销量最好,价格最低的时候可以更改产品的默认排序。
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-11-24 04:12:41 HTTP/1.1 GET : http://xn.iwdd.cn/home/article/detail/id/2447.html
- 运行时间 : 0.092159s [ 吞吐率:10.85req/s ] 内存消耗:2,041.98kb 文件加载:151
- 查询信息 : 30 queries
- 缓存信息 : 16 reads,0 writes
- 会话信息 : SESSION_ID=05eaefd0cb8ac5eb9ef2d29c9c85a707
- CONNECT:[ UseTime:0.000523s ] mysql:host=127.0.0.1;port=3306;dbname=xn_iwdd_cn;charset=utf8mb4
- SHOW FULL COLUMNS FROM `cms_article` [ RunTime:0.000698s ]
- SELECT * FROM `cms_article` WHERE `id` = 2447 LIMIT 1 [ RunTime:0.000426s ]
- SHOW FULL COLUMNS FROM `cms_article_keywords` [ RunTime:0.000509s ]
- 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` = '2447' AND `k`.`status` = '1' ORDER BY `i`.`create_time` ASC [ RunTime:0.000393s ]
- UPDATE `cms_article` SET `read` = `read` + 1 WHERE `id` = 2447 [ RunTime:0.004559s ]
- SHOW FULL COLUMNS FROM `cms_article_cate` [ RunTime:0.000663s ]
- SELECT * FROM `cms_article_cate` ORDER BY `sort` DESC [ RunTime:0.000411s ]
- SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.002345s ]
- SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 2 AND `status` = 1 LIMIT 1 [ RunTime:0.002284s ]
- SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 3 AND `status` = 1 LIMIT 1 [ RunTime:0.002868s ]
- SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 4 AND `status` = 1 LIMIT 1 [ RunTime:0.002385s ]
- SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 5 AND `status` = 1 LIMIT 1 [ RunTime:0.002044s ]
- SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 6 AND `status` = 1 LIMIT 1 [ RunTime:0.002082s ]
- SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 7 AND `status` = 1 LIMIT 1 [ RunTime:0.002330s ]
- SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 8 AND `status` = 1 LIMIT 1 [ RunTime:0.002150s ]
- SHOW FULL COLUMNS FROM `cms_keywords` [ RunTime:0.000537s ]
- SELECT * FROM `cms_keywords` WHERE `status` = 1 ORDER BY rand() , id desc LIMIT 20 [ RunTime:0.000456s ]
- 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.014240s ]
- SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1540' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000483s ]
- SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '182' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000275s ]
- SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '628' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000305s ]
- SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '2845' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000252s ]
- SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1138' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000262s ]
- SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '974' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000315s ]
- SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3526' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000242s ]
- SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1672' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000222s ]
- 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.000226s ]
- SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3037' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000235s ]
- SHOW FULL COLUMNS FROM `cms_user_log` [ RunTime:0.000494s ]
- INSERT INTO `cms_user_log` SET `uid` = 0 , `nickname` = '游客' , `type` = 'view' , `title` = '查看' , `content` = '游客在2024-11-24 04:12:42查看了Bigcommerce平台产品展示排序讲解文章详情' , `param_id` = 2447 , `param` = '[]' , `module` = 'home' , `controller` = 'article' , `function` = 'detail' , `ip` = '18.221.90.184' , `create_time` = 1732392762 [ RunTime:0.004628s ]
0.100581s