XLS《说明》

"如何准备您的配送确认模板" "使用该模板创建配送确认文件,将订单的配送时间和方式告知您的买家.

您所提供的信息将显示在买家的"我的账户"区域.请参阅卖家平台上的"订单"选项卡->"上传订单相关文件",了解如何上传该文件的相关说明." "如何使用配送确认模板的各项功能" "此模板含有验证宏,可以帮助您正确地填写模板.您可以自行决定是否开启验证宏,但我们建议您在学会如何使用模板前,开启这些验证宏.以下便是关于如何使用验证宏的有用提示列表." "启用宏:如果您在打开该文件时禁用了验证宏,则需要关闭此文件,然后重新打开,以便将其启用.重新打开文件之后,请选中随之出现安全警告对话框中的"始终信任此来源的宏".接下来,选择"启用宏".这样,您每次打开文件时,均会启用宏.如果您不确定如何正确填写该盘点模板,我们强烈建议您启用宏." "下拉菜单:如果您想要在出现下拉菜单的单元格中输入数据,则必须从下拉菜单中选择一个值.您无法键入自己的值,即使该值是有效的.如果您收到错误消息,请删除当前值,然后从下拉菜单中选择其他值." "卓越亚马逊工具栏:启用宏时,会出现该浮动工具栏.通过该工具栏,您可以快速登录到卖家平台,"验证"选项和切换按钮可以用来打开或关闭验证功能.要登录到卖家平台,您的Internet连接必须已经激活.您可以通过"验证"按钮,对输入模板的数据进行验证.无论您是否已打开验证,该功能均将启动.如果您已关闭卓越亚马逊工具栏,则可以通过从"视图"菜单中选择"工具栏->卓越亚马逊",来重新将其打开." "定义:双击单元格,将会显示该单元格的定义内容.通过该定义,您可以大致了解该单元格的要求级别、定义、可接受的值和可输入的示例.这样,您可以对单元格中所输入的内容进行快速验证." ".log文件:宏将会在与商品模板相同的位置创建一个错误和警告的.log文件.警告将会告知仍需输入内容的单元格.错误即为宏故障.您在成功上传库存文件之后,便可以将此.log文件删除." "第一步" "打开包含您所确认订单的订单报告.您需要将订单中所包含的部分信息复制到该模板中." "第二步" "点击"配送确认"选项卡,输入与您所确认配送相关的相应数据.为帮助您了解每一输入项,点击"数据定义"选项卡.您可以在要上传的单个文件中包含多个配送确认.您所提供的信息越全面,买家与您的联系次数就越少." "第三步" "您在将数据填入"配送确认"选项卡并准备生成上传文件时,请首先将此文件另存为Excel工作簿.接下来,请选择"配送确认"选项卡,并将文件保存为"Unicode文本(*.txt)"文件.该文本文件即是您要通过卖家平台上传的文件." "仍有疑问?" "如果您没有在上述说明或"数据定义"中找到您需要的解答,请访问卖家平台帮助中心获取更多支持." "卖家平台帮助中心" "定义-配送确认模板",,

, "粗体输入项均为必填项,但您所提供的信息越全面,买家与您的联系次数就越少.",,

, "标签名称","描述","可接受的值","示例" "订单编号","订单的卓越亚马逊唯一可显示编码,在您的订单报告中予以提供.","17位的字母数字文本,格式为#123-1234567-1234567" "订单商品编号","订单中商品的卓越亚马逊唯一可显示编码,在您的订单报告中予以提供.如果您所确认的是整个订单的配送,则该项不是必填项.有关拆分货件,请参阅以下说明.","14位的正整数.","12345678901234" "数量","如果买家订购了同一商品的多个单位,则此数字即是在此货件中包含的该商品数量.如果您要拆分货件,则您必须在配送确认中,为所有拆分货件均提供商品数量,这样,买家在每个货件抵达时才知道其中应包含的商品数量.","正整数.","23456" "发货日期","订单/商品实际配送或提货的日期,这取决于订单中指定的配送方式.要获取如何上传该报告的相关说明,请登录到您的卓越亚马逊卖家账户,然后点击交易页面.","日期的格式为:yyyy-mm-dd(年-月-日),表明商品的发货日期.", "承运人名称","配送商品的运输承运人.开放字符串.","从"有效值"工作表中选择某个值.","长沙创一" "追踪编码","商品货件的追踪编码.","字母数字文本;

长度在1到50个字符之间(含1和50).","22344455" "配送方式","商品的配送方式.","字母数字文本;

长度在1到50个字符之间(含1和50).","平邮" ,,

, "关于拆分货件的重要说明:" "如果买家向您订购了多件商品,而您以多个货件来配送订单,则您要确认的每个货件的"订单编号"、"订单商品编号"、"数量"和"发货日期"均为必填项.",,

, ,,

,,

"TemplateType=OrderFulfillment","Version=2.0","本行内容只供卓越亚马逊使用,请不要对本行进行修改或删除.", "订单编号","订单商品编号","数量","发货日期","承运人名称","追踪编码","配送方式" "order-id","order-item-id","quantity","ship-date","carrier-name","tracking-number","ship-method" "承运人名称", "博纳盛世","BoNaShengShiExpress" "北京飞翔","BeiJingFeiXiangExpress" "北京金磊","BeiJingJinLeiExpress" "北京天成大通","TianChengDaTongExpress" "北京小红帽","BeiJingXiaoHongMaoExpress" "北京一统","BeiJingYiTongExpress" "北京宅急送","ZJSExpress" "重庆华宇","ChongQingHuaYuExpress" "长沙创一","ChangShaChuangYiExpress" "常州海航","ChangZhouHaiHangExpress" "DHL","DHL" "大连小红马","DaLianXiaoHongMaExpress" "福州飞远","FuZhouFeiYuanExpress" "深圳银捷","ShenZhenYinJieExpress" "广州快客杰","KuaiKeJieExpress" "港中能达","GangZhongNengDaExpress" "广州邮局","GuangZhouPostOfficeEMS" "广州宅急送","ZJSExpress" "合肥汇文","HeFeiHuiWenExpress" "海南百家网","HNBJWExpress" "海南华迅","HaiNanHuaXunExpress" "哈尔滨捷迅","HeErBinJieXunExpress" "杭州特能","HangZhouTeNengExpress" "长春信捷","ChangChunXinJieExpress" "吉林宅急送","ZJSExpress" "济南双建","JiNanShuangJianExpress" "北京卓配","JODS" "江苏门对门","JSD2D" "廊坊邮局","LangFangPostOfficeEMS" "梅州通路","MeiZhouTongLuExpress" "宁波特能","NingBoTeNengExpress" "南京特能","NanJingTeNengExpress" "内蒙华赫","NeiMengHuaHeExpress" "南宁腾达","NanNingTengDaExpress" "青岛海红","QingDaoHaiHongExpress" "四川雪狐","XueHuExpress" "山东元智","ShanDongYuanZhiExpress" "上海天地直复","TNT" "上海天地直复","TNT" "上海特能","ShangHaiTeNengExpress" "上海特能","ShangHaiTeNengExpress" "上海天地直复","TNT" "上海天地直复","TNT" "双井邮局","GuangZhouPostOfficeEMS" "陕西飞远","ShanXiFeiYuanExpress" "沈阳众人行","ShenYangZhongRenXingExpress" "深圳飞远","ShenZhenFeiYuanExpress" "深圳海盛","ShenZhenHaiShengExpress" "深圳海盛","ShenZhenHaiShengExpress" "苏州邮局","GuangZhouPostOfficeEMS" "苏州特能","SuZhouTeNengExpress" "天津卓配","JODS" "太原纵横","TaiYuanZongHengExpress" "太原纵横","TaiYuanZongHengExpress" "UPS","UPS" "武汉特能","WuHanTeNengExpress" "无锡特能","WuXiTeNengExpress" "广东邮政","YCC" "云南宅急送","ZJSExpress" "浙江ABC","ZJABC" "宅急送","ZJSExpress" "浙江宅急送","ZJSExpress" "郑州建华","ZhengZhouJianHuaExpress" "临时宅急送","ZJSExpress" "北京小红帽","BeiJingXiaoHongMaoExpress" "成都雪狐","XueHuExpress"