Bigcommerce平台产品展示排序讲解
发表于:2022-11-24 10:23:32浏览:12次TAG:
对于一个店铺来说在平台上,当消费者通过搜索关键词出来商品页面的时候,产品的排放的顺序是很重要的,一般消费者会选择靠前的产品,进行浏览下单,所以想要让自己的产品靠前展示,就要先了解平台产品展示的相关规则,今天我们就详细讲解一下这方面,希望能够帮助商家获得更多的利润,增加成交量。
一、产品展示排序的类型
用户可以选择七种不同的排序类型对店铺上显示的产品进行排序,这七种不同的排序方式是:精选、最新产品、最畅销、按字母顺序排列、按照字母倒叙顺序排列、平均客户评论、价格从高到底、价格从低到高。用户可以通过下拉选择器的方式,选择不同的排序类型,不同的排序类型会有相应的产品在页面上显示,当然产品显示的顺序不同,用户在建站的时候选择的主题不同,那选择器的外观和位置也可能不相同。
二、产品排序订单号规则
在前面讲过产品排序的七种类型,当用户选择精选这个方式的时候,排序顺序号能够让产品在分类页面有更多的选择性,但是如果用户选择的是除了精选这一项的其他六种方式,那这个排序订单号对其来说是没有用处的。
排序订单号规则:
1.当产品是从低到高排序的时候,排序的顺序在30的要比顺序在60的更加靠近顶端
2.在平台默认的规则中,所有产品的排序顺序都是零
3.是允许使用负数的,比如,负一是接近顶端的位置,而不是零
如何更新产品的排序订单号?
点击产品——查看——编辑产品的名称——选择其他详细信息选项——选择排序顺序字段——CSV批量更新顺序
三、默认产品的排序顺
这个是平台设置确定产品在类别页面上的显示顺序,可以通过店铺进行设置也可以通过产品的类别进行编辑,当用户想要突出评论最高或者销量最好,价格最低的时候可以更改产品的默认排序。
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-11-24 08:45:37 HTTP/1.1 GET : http://xn.iwdd.cn/home/article/detail/id/3278.html
- 运行时间 : 0.081014s [ 吞吐率:12.34req/s ] 内存消耗:2,041.64kb 文件加载:151
- 查询信息 : 30 queries
- 缓存信息 : 16 reads,0 writes
- 会话信息 : SESSION_ID=9912ea6931df78ca1ffffb62fd52eeea
- CONNECT:[ UseTime:0.000471s ] mysql:host=127.0.0.1;port=3306;dbname=xn_iwdd_cn;charset=utf8mb4
- SHOW FULL COLUMNS FROM `cms_article` [ RunTime:0.000765s ]
- SELECT * FROM `cms_article` WHERE `id` = 3278 LIMIT 1 [ RunTime:0.000375s ]
- SHOW FULL COLUMNS FROM `cms_article_keywords` [ RunTime:0.000411s ]
- 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` = '3278' AND `k`.`status` = '1' ORDER BY `i`.`create_time` ASC [ RunTime:0.000354s ]
- UPDATE `cms_article` SET `read` = `read` + 1 WHERE `id` = 3278 [ RunTime:0.004602s ]
- SHOW FULL COLUMNS FROM `cms_article_cate` [ RunTime:0.000536s ]
- SELECT * FROM `cms_article_cate` ORDER BY `sort` DESC [ RunTime:0.000250s ]
- SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.001898s ]
- SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 2 AND `status` = 1 LIMIT 1 [ RunTime:0.001884s ]
- SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 3 AND `status` = 1 LIMIT 1 [ RunTime:0.001739s ]
- SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 4 AND `status` = 1 LIMIT 1 [ RunTime:0.001654s ]
- SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 5 AND `status` = 1 LIMIT 1 [ RunTime:0.001576s ]
- SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 6 AND `status` = 1 LIMIT 1 [ RunTime:0.001563s ]
- SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 7 AND `status` = 1 LIMIT 1 [ RunTime:0.001612s ]
- SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 8 AND `status` = 1 LIMIT 1 [ RunTime:0.001491s ]
- SHOW FULL COLUMNS FROM `cms_keywords` [ RunTime:0.000412s ]
- SELECT * FROM `cms_keywords` WHERE `status` = 1 ORDER BY rand() , id desc LIMIT 20 [ RunTime:0.000318s ]
- 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.013890s ]
- SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1749' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000472s ]
- SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '2377' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000326s ]
- SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '4172' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000381s ]
- SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1444' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000282s ]
- SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3056' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000293s ]
- SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1402' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000278s ]
- SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3950' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000248s ]
- SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3806' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000225s ]
- SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '2407' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000261s ]
- SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '946' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000218s ]
- SHOW FULL COLUMNS FROM `cms_user_log` [ RunTime:0.000544s ]
- INSERT INTO `cms_user_log` SET `uid` = 0 , `nickname` = '游客' , `type` = 'view' , `title` = '查看' , `content` = '游客在2024-11-24 08:45:37查看了Bigcommerce平台产品展示排序讲解文章详情' , `param_id` = 3278 , `param` = '[]' , `module` = 'home' , `controller` = 'article' , `function` = 'detail' , `ip` = '3.129.67.248' , `create_time` = 1732409137 [ RunTime:0.004653s ]
0.088605s