{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["第一阶段问题标","下一里程碑内容"],"not_rendered":{"charts":0,"images":12,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"第一阶段问题标","index":0,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["模块","问题描述","提交日期","紧急程度","e码头确认","预计完成日期","状态","备注"]
["收银台","收银台，订单核销打印的小票内容中，修改内容\n1、取消优惠后单价列，以及优惠列 （因为现实不对应）\n2、促销减价总金额为优惠，促销减价的优惠显示为商品优惠金额，优惠合计改为：积分抵扣及优惠金额合计，具体如下：\n   商品合计： \n   积分抵扣合计：\n   积分抵扣金额：\n   商品优惠金额：\n   积分抵扣及优惠金额合计\n   实收:\n   支付渠道：","2022-01-07","一级","你们后面还有其它的营销活动，这些优惠是否考虑过要不要在这里拆分显示？如何展示？\n按照整理活动统一方案考虑","2022-03-15","已解决"]
["收银台","打印小票中下方的二维码，按照后台给出的尺寸上传之后，在前端打印变形了，需提供一个新的尺寸","2022-01-07","一级",null,"2022-02-15","已解决"]
["接口","展销厅订单支付后，传给会员系统的订单缺少商品明细","2021-12-30","一级","4个接口里，没有要求传商品明细","2022-02-15","已解决","4个接口里，没有要求传商品明细\n说明： 在“订单同步接口”中是有商品明细集合字段的"]
["接口","展销厅订单退款后，会员系统未扣减成长值","2021-12-30","一级","对接4个接口里，没有对应扣减成长值相关","2022-02-15","二期解决","对接4个接口里，没有对应扣减成长值相关\n说明：是“订单同步接口-回退”只要传了回退，会员系统是会自动处理的"]
["管理台","管理台-首页，退款订单、待发货订单、已发货订单、待付款订单、已完成订单的统计，均为0\n（需确认是否能正常统计不同状态的订单）","2021-12-29","一级",null,"2022-02-15","已解决"]
["管理台","管理台-订单管理-线下订单，查看详情，商品数据中的总计不正确","2021-12-29","一级",null,"2022-02-15","已解决"]
["管理台","管理台-订单管理-线下订单，未能查到订单的发货人、收货人地址信息、运单编号、清关状态、清关编号  ","2021-12-29","一级","不影响现有业务，放到二期","2022-03-15","未解决"]
["管理台","管理台-订单管理-线下订单，导出daily sales report，订单支付状态存在错误，84151585923072、84428986859520已退款，支付状态却是：订单已发货","2021-12-29","一级",null,"2022-02-15","海控不要求解决"]
["收银台","进入收银员登录页面，第1次登录提示未配置机器码，登录失败，然后再次点击登录才能成功。（每次刷新登录都会出现）","2021-12-20","二级",null,"2022-03-15","未解决","远程协助处理"]
["收银台","收银台，积分抵扣金额、商品优惠应分开，商品列表中增加积分抵扣金额\n（曾经提出过的问题，被删没了，现补回）","2021-12-31","二级",null,"2022-03-15","未解决"]
["管理台","管理台-订单管理-线下订单，导出销售报表，报：{\"msg\":\"Unparseable date: \\\"\\\"\",\"code\":500}\n（22日提出并屏蔽过）","2021-12-29","二级",null,"2022-03-15","未解决"]
["管理台","营销活动没有名称，多个活动并行容易混乱","2022-01-10","二级",null,"2022-03-15","未解决"]
["管理台","管理台-积分赠送规则设置，门店商品积分类型，需能查看到商品名称，并能按sku、名称进行条件查询","2022-01-10","二级",null,"2022-03-15","未解决"]
["管理台","门店商品积分只能模板批量导入，不能单个新增","2022-01-10","二级",null,"2022-03-15","未解决"]
["管理台","管理台-活动管理，积分抵扣活动，新增、修改活动商品，门店id, 营销活动编号2项无法选择，也不需使用的问题\n（建议屏蔽门店id, 营销活动编号这2项）","2021-12-29","三级",null,"2022-03-15","未解决"]
["管理台","收银台，录入会员手机号与提交订单后录入的手机号不一致时，应将这2个手机号在后台订单中分别记录为会员手机号、收货人手机号","2021-12-31","三级",null,"2022-03-15","未解决"]
["管理台","管理台-订单管理-线下订单，需将订单列表中的优惠分出促销优惠、积分抵扣","2021-12-31","三级",null,"2022-03-15","未解决"]
["收银台","收银台，商品加入购车，点击【计算优惠后价格】，不填会员信息并计算优惠后，提交订单，并付款，付款窗口中，会员手机号显示了订单中收货人的手机号，不付款并关闭窗口，收银主页面底部的会员手机号也显示成了收货人手机事情（订单填入的收货人手机号，与会员手机号不一致时，不应变为会员手机号）","2021-12-29","三级",null,"2022-03-15","未解决","下一阶段处理"]
["收银台","收银台主页面，需支持100%比例时也能够完整显示","2021-12-29","三级",null,"2022-03-15","未解决","下一阶段处理"]
["管理台","管理台-积分赠送规则设置，分别设置了A门店、B门店的门店、商品积分赠送规则，分别进行A、B门店的下订，未能分别按A门店、B门店的积分规则进行赠送，而是都使用了同一个门店或商品赠送规则","2021-12-29","三级",null,"2022-03-15","未解决","下一阶段处理"]
["管理台","管理台-活动管理，新增临时促销、积分抵扣活动，活动门店选择了A门店，增加活动商品。然后将活动门店改为B门店，已增加的商品在B门店未能得到优惠处理。\n（解决建议：已添加商品的活动禁止修改活动门店，或修改活动门店后，活动中已有的商品能正常得到优惠处理）","2021-12-29","三级",null,"2022-03-15","未解决","下一阶段处理"]
["接口","会员积分中活动积分和普通积分的分配","2022-01-10","三级",null,"2022-03-15","未解决","下一期处理"]

{"sheet":"下一里程碑内容","index":1,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[[3,0,4,0],[5,0,6,0]]}
["模块","功能内容","e码头确认","预计完成日期","状态","备注"]
["接口","商品价格更新\n说明：由e码头提供商品信息接口，免税mall通过调用商品接口来更新商品的价格，及基本信息。",null,null,null,"将“电子价签”进行变更"]
["优惠","商品活动（优惠券）\n详情参照业务原型：https://dawn-pound-535.notion.site/b0c4854b0d6f4e8aa55539b8158bba25"]
["门店进货","展销品申请入库（录入到收银系统，入库单录入）备注信息：展销品申请入库"]
[null,"快递收货（录入到收银系统，入库单录入）备注信息：快递收货"]
["门店出货","展销品申请出库至保税仓（录入到收银系统，出库单录入）备注信息：库至保税仓"]
[null,"客户提货（正常的收银系统销售）"]