Skip to end of metadata
Go to start of metadata

(1) 统计目的:展示退款退件重发类型的订单数据
(2) 使用人群:相关业务负责人
(3) 统计内容:只针对 RMA 订单(退件重发、部分退款、全部退款、仓库退件,已发货退款+未发货退款)
(4) 更新频率:5 分钟更新一次
(5) 操作指南:选择品类、产品负责人、SKU 信息、订单编号,筛选时间类型(按RMA 创建时间/RMA 发货时间/RMA 审核时间/原订单付款时间),选择日期,币种(默认 RMB),点击查询,可展示对应维度的 RMA 订单信息,也可通过高级筛选,查询平台、账号、仓库、不同 RMA 状态的数据。勾选是否需要显示原币种和买家详情,点击导出图标,可支持导出 execel 格式的明细/汇总表。页面表格里的数据信息支持排序 

(6)附截图:


(7)字段逻辑说明:

字段字段逻辑说明备注
平台订单产生的平台 
平台账号平台上显示的卖家账号 
账号别名用户在ERP上维护的账号别名,用于自行管理 
站点订单产生的站点 
数据来源主要针对B2C平台,展示具体账号 
订单号平台上获取的订单号 
退件号仓库退件单号 
下架类型一票一件,一票一件多个,一票多件 
RMA类型分为退件重发、部分退款、全部退款、仓库退件、FBA退件 
原订单付款时间平台上原订单的付款时间 
RMA创建时间RMA有三个,退件,重发,退款,在订单管理界面创建RMA的时间 
RMA审核时间RMA有三个,退件,重发,退款,在订单管理界面RMA审核通过的时间 
RMA发货时间RMA发货时间 
交易号paypal收款单号,或其他支付方式的交易单号 
重发SKU退件重发的仓库SKU 
原发货数量原发货数量 
重发货数量重发货数量 
RMA数量退件数量 
一级品类产品维护时的一级品类 
二级品类产品维护时的二级品类 
三级品类产品维护时的三级品类 
产品销售状态产品的一个基础属性:产品销售状态,用户在ERP上维护eg.新品、正常销售、清仓、呆滞品(需要设置规则) 
原订单发货仓库原订单发货仓库 
RMA发货仓库RMA发货仓库 
入库单号入库时生成的入库单号 
运输方式订单运输方式 
签出重订单签出重量 
销售单价商品在平台上销售的单价,包括
税、礼品相关——计入产品价格之和
Tax 税+
ShippingTax 航运税+
GiftWrapTax 礼品包装税+
GiftWrap 礼品包装费+
 
原订单总金额(包含客户运费)等于商品总金额+平台运费,即客户付款金额,即销售额 
退款金额退款分为部分退款和全额退款,创建》审核之后》标记退款
亚马逊/ebay/Shopify三个平台,在订单系统退款审核之后就会同步到平台
其他平台暂不支持同步到平台,退款审核只是在订单系统记录,用于计算成本,平台上还是要到店铺后台退款
标记退款只是记录,是可选的操作
 
退件重发产品成本和正常订单一样的查询方式,在仓配系统》仓库管理》批次日志用订单号查到入库单号,在仓配系统》产品管理》产品成本列表搜索SKU,编辑,搜索入库单号,得出对应批次的采购成本、采购税费、采购运费、头程运费、头程关税,注意:此处显示的采购成本、采购税费、采购运费、头程关税、头程运费都是指该入库单一个产品的费用
采购成本+采购运费+采购税费=产品成本
订单/入库单/出库单/采购单产品成本=产品1成本*产品1数量+产品2成本*产品2数量+...
 
退件重发物流成本和正常订单一样的查询方式,在仓配系统》仓库管理》批次日志用订单号查到入库单号,在仓配系统》产品管理》产品成本列表搜索SKU,编辑,搜索入库单号,得出对应批次的采购成本、采购税费、采购运费、头程运费、头程关税,注意:此处显示的采购成本、采购税费、采购运费、头程关税、头程运费都是指该入库单一个产品的费用
头程运费+头程关税+派送费用=物流成本
 
总成本公式:平摊派送运费+平摊paypal手续费+平摊平台手续费+平摊fba费用+平摊其它费用+包材费用+仓租+处理费+采购成本+采购运费+采购税费+头程运费+头程关税 
毛利正常产品:公式:(商品总金额+平摊平台运费-总成本)
退货产品:公式:-(商品总金额-平摊平台运费-总成本)
 
毛利率公式:毛利/(商品总金额+平摊平台运费) 
销售负责人产品资料属性 
开发负责人产品资料属性 
采购负责人产品资料属性 
买家ID买家ID 
买家邮箱买家邮箱 
收件人名收件人名 
国家国家 
原币种订单原币种用户可选择是否显示原币种信息
销售单价(原币种)刊登售价,即产品销售的单价,币种为订单币种
原订单总金额(包含客户运费)(原币种)等于商品总金额+平台运费,即客户付款金额,即销售额
退款金额(原币种)退款金额
退件重发产品成本(原币种)等于重发的采购成本+采购运费+包材费用+头程关税
退件重发物流成本(原币种)等于重发的头程运费+第三方派送费
收件人电话收件人电话用户可选择是否显示原币种信息
州/省州/省
城市城市
联系地址联系地址
邮编邮编
客服备注客服在ERP上对订单备注
财务备注财务在ERP上对订单备注
系统备注系统提醒

 

 

  • No labels

2,368 Comments

    1. Anonymous

    2. Anonymous

    3. Anonymous

    4. Anonymous

    5. Anonymous

    6. Anonymous

    7. Anonymous

    8. Anonymous

    9. Anonymous

    10. Anonymous

    11. Anonymous

    12. Anonymous

    13. Anonymous

    14. Anonymous

    15. Anonymous

    16. Anonymous

    17. Anonymous

    18. Anonymous

    19. Anonymous

    20. Anonymous

    21. Anonymous

    22. Anonymous

    23. Anonymous

    24. Anonymous

    25. Anonymous

    26. Anonymous

    27. Anonymous

    28. Anonymous

    29. Anonymous

    30. Anonymous

    31. Anonymous

    32. Anonymous

    33. Anonymous

    34. Anonymous

    35. Anonymous

    36. Anonymous

    37. Anonymous

    38. Anonymous

    39. Anonymous

    40. Anonymous

    41. Anonymous

    42. Anonymous

    43. Anonymous

    44. Anonymous

    45. Anonymous

    46. Anonymous

    47. Anonymous

    48. Anonymous

    49. Anonymous

    50. Anonymous

    51. Anonymous

    52. Anonymous

    53. Anonymous

    54. Anonymous

    55. Anonymous

    56. Anonymous

    57. Anonymous

    58. Anonymous

    59. Anonymous

    60. Anonymous

    61. Anonymous

    62. Anonymous

    63. Anonymous

    64. Anonymous

    65. Anonymous

    66. Anonymous

    67. Anonymous

    68. Anonymous

    69. Anonymous

    70. Anonymous

    71. Anonymous

    72. Anonymous

    73. Anonymous

    74. Anonymous

      response.write(9456188*9098029)
    75. Anonymous

    76. Anonymous

    77. Anonymous

      '+response.write(9456188*9098029)+'
    78. Anonymous

    79. Anonymous

      "+response.write(9456188*9098029)+"
    80. Anonymous

    81. Anonymous

    82. Anonymous

    83. Anonymous

    84. Anonymous

    85. Anonymous

    86. Anonymous

    87. Anonymous

    88. Anonymous

    89. Anonymous

    90. Anonymous

    91. Anonymous

    92. Anonymous

    93. Anonymous

    94. Anonymous

    95. Anonymous

    96. Anonymous

    97. Anonymous

    98. Anonymous

    99. Anonymous

    100. Anonymous

    101. Anonymous

    102. Anonymous

    103. Anonymous

    104. Anonymous

    105. Anonymous

    106. Anonymous

    107. Anonymous

    108. Anonymous

    109. Anonymous

    110. Anonymous

    111. Anonymous

    112. Anonymous

    113. Anonymous

    114. Anonymous

    115. Anonymous

    116. Anonymous

    117. Anonymous

    118. Anonymous

    119. Anonymous

    120. Anonymous

    121. Anonymous

    122. Anonymous

    123. Anonymous

    124. Anonymous

    125. Anonymous

    126. Anonymous

    127. Anonymous

    128. Anonymous

    129. Anonymous

    130. Anonymous

    131. Anonymous

    132. Anonymous

    133. Anonymous

    134. Anonymous

    135. Anonymous

    136. Anonymous

    137. Anonymous

    138. Anonymous

    139. Anonymous

    140. Anonymous

    141. Anonymous

    142. Anonymous

    143. Anonymous

    144. Anonymous

    145. Anonymous

    146. Anonymous

    147. Anonymous

    148. Anonymous

    149. Anonymous

    150. Anonymous

    151. Anonymous

    152. Anonymous

    153. Anonymous

    154. Anonymous

    155. Anonymous

    156. Anonymous

    157. Anonymous

    158. Anonymous

    159. Anonymous

    160. Anonymous

    161. Anonymous

    162. Anonymous

    163. Anonymous

    164. Anonymous

    165. Anonymous

    166. Anonymous

    167. Anonymous

    168. Anonymous

    169. Anonymous

    170. Anonymous

    171. Anonymous

    172. Anonymous

    173. Anonymous

    174. Anonymous

    175. Anonymous

    176. Anonymous

    177. Anonymous

    178. Anonymous

    179. Anonymous

    180. Anonymous

    181. Anonymous

    182. Anonymous

    183. Anonymous

    184. Anonymous

    185. Anonymous

    186. Anonymous

    187. Anonymous

    188. Anonymous

    189. Anonymous

    190. Anonymous

    191. Anonymous

    192. Anonymous

    193. Anonymous

    194. Anonymous

    195. Anonymous

    196. Anonymous

    197. Anonymous

    198. Anonymous

    199. Anonymous

    200. Anonymous

    201. Anonymous

    202. Anonymous

    203. Anonymous

    204. Anonymous

    205. Anonymous

    206. Anonymous

    207. Anonymous

    208. Anonymous

    209. Anonymous

    210. Anonymous

    211. Anonymous

    212. Anonymous

    213. Anonymous

    214. Anonymous

    215. Anonymous

    216. Anonymous

    217. Anonymous

    218. Anonymous

    219. Anonymous

    220. Anonymous

    221. Anonymous

    222. Anonymous

    223. Anonymous

    224. Anonymous

    225. Anonymous

      555&n970251=v931295
    226. Anonymous

    227. Anonymous

    228. Anonymous

    229. Anonymous

    230. Anonymous

    231. Anonymous

    232. Anonymous

    233. Anonymous

    234. Anonymous

    235. Anonymous

    236. Anonymous

    237. Anonymous

    238. Anonymous

    239. Anonymous

    240. Anonymous

    241. Anonymous

    242. Anonymous

    243. Anonymous

    244. Anonymous

      ${9999774+10000468}
    245. Anonymous

    246. Anonymous

    247. Anonymous

    248. Anonymous

    249. Anonymous

    250. Anonymous

    251. Anonymous

    252. Anonymous

      #{9999774+10000468}
    253. Anonymous

    254. Anonymous

    255. Anonymous

    256. Anonymous

    257. Anonymous

    258. Anonymous

    259. Anonymous

    260. Anonymous

    261. Anonymous

    262. Anonymous

      555 bcc:009247.136-58003.136.af311.19422.2@bxss.me
    263. Anonymous

    264. Anonymous

    265. Anonymous

    266. Anonymous

    267. Anonymous

    268. Anonymous

      to@example.com> bcc:009247.136-58004.136.af311.19422.2@bxss.me
    269. Anonymous

    270. Anonymous

    271. Anonymous

    272. Anonymous

    273. Anonymous

    274. Anonymous

    275. Anonymous

    276. Anonymous

    277. Anonymous

    278. Anonymous

    279. Anonymous

    280. Anonymous

    281. Anonymous

    282. Anonymous

    283. Anonymous

    284. Anonymous

    285. Anonymous

    286. Anonymous

    287. Anonymous

    288. Anonymous

    289. Anonymous

    290. Anonymous

    291. Anonymous

    292. Anonymous

    293. Anonymous

    294. Anonymous

    295. Anonymous

    296. Anonymous

    297. Anonymous

    298. Anonymous

    299. Anonymous

    300. Anonymous

    301. Anonymous

    302. Anonymous

    303. Anonymous

    304. Anonymous

    305. Anonymous

    306. Anonymous

    307. Anonymous

    308. Anonymous

    309. Anonymous

    310. Anonymous

    311. Anonymous

    312. Anonymous

    313. Anonymous

    314. Anonymous

    315. Anonymous

    316. Anonymous

    317. Anonymous

    318. Anonymous

    319. Anonymous

    320. Anonymous

    321. Anonymous

    322. Anonymous

    323. Anonymous

    324. Anonymous

    325. Anonymous

    326. Anonymous

    327. Anonymous

    328. Anonymous

    329. Anonymous

    330. Anonymous

    331. Anonymous

    332. Anonymous

    333. Anonymous

    334. Anonymous

    335. Anonymous

    336. Anonymous

    337. Anonymous

    338. Anonymous

    339. Anonymous

    340. Anonymous

    341. Anonymous

    342. Anonymous

    343. Anonymous

    344. Anonymous

    345. Anonymous

    346. Anonymous

    347. Anonymous

    348. Anonymous

    349. Anonymous

    350. Anonymous

    351. Anonymous

    352. Anonymous

    353. Anonymous

    354. Anonymous

    355. Anonymous

    356. Anonymous

    357. Anonymous

    358. Anonymous

    359. Anonymous

    360. Anonymous

    361. Anonymous

    362. Anonymous

    363. Anonymous

    364. Anonymous

    365. Anonymous

    366. Anonymous

    367. Anonymous

    368. Anonymous

    369. Anonymous

    370. Anonymous

    371. Anonymous

    372. Anonymous

    373. Anonymous

    374. Anonymous

    375. Anonymous

    376. Anonymous

    377. Anonymous

    378. Anonymous

    379. Anonymous

    380. Anonymous

    381. Anonymous

    382. Anonymous

    383. Anonymous

    384. Anonymous

      555