到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| MJ26030700169905 | TCHACO PUMANGOL Zipper男款POLO衫-头版-YS9450MCO | XL | 庄镘洁 | 330076 | 374243 | 2026-03-18 15:45:56 | 2 | 2026-03-22 17:35:21.868064 |
| MJ26030700169904 | TCHACO PUMANGOL Zipper男款POLO衫-头版-YS9450MCO | L | 庄镘洁 | 330076 | 374243 | 2026-03-18 15:45:56 | 2 | 2026-03-22 17:35:21.866014 |
| MJ26030700169903 | TCHACO PUMANGOL Zipper男款POLO衫-头版-YS9450MCO | M | 庄镘洁 | 330076 | 374243 | 2026-03-18 15:45:56 | 2 | 2026-03-22 17:35:21.863716 |
| MJ26030700169902 | TCHACO PUMANGOL Zipper男款POLO衫-头版-YS9450MCO | S | 庄镘洁 | 330076 | 374243 | 2026-03-18 15:45:56 | 2 | 2026-03-22 17:35:21.861395 |
| MJ26030700169901 | TCHACO PUMANGOL Zipper男款POLO衫-头版-YS9450MCO | XS | 庄镘洁 | 330076 | 374243 | 2026-03-18 15:45:56 | 2 | 2026-03-22 17:35:21.859629 |
| MJ26030700169911 | TCHACO PUMANGOL Zipper男款POLO衫-头版-YS9450MCO | 2XS | 庄镘洁 | 330076 | 374243 | 2026-03-18 15:45:56 | 2 | 2026-03-22 17:35:21.857693 |
| MN26030400089904 | Infinit 26 Blue女款铁三短裤-头版-YS2083WC | L | 林美霓 | 329729 | 374244 | 2026-03-18 15:47:00 | 3 | 2026-03-22 17:35:21.856081 |
| MN26030400089901 | Infinit 26 Blue女款铁三短裤-头版-YS2083WC | XS | 林美霓 | 329729 | 374244 | 2026-03-18 15:47:00 | 1 | 2026-03-22 17:35:21.854141 |
| BH26030700079906 | MTB HOTR男款T恤-头版-YS9068MAJ | 2XL | 凌碧红 | 330577 | 374246 | 2026-03-18 15:47:27 | 2 | 2026-03-22 17:35:21.852356 |
| BH26030700079905 | MTB HOTR男款T恤-头版-YS9068MAJ | XL | 凌碧红 | 330577 | 374246 | 2026-03-18 15:47:27 | 6 | 2026-03-22 17:35:21.799368 |
| BH26030700079903 | MTB HOTR男款T恤-头版-YS9068MAJ | M | 凌碧红 | 330577 | 374246 | 2026-03-18 15:47:27 | 2 | 2026-03-22 17:35:21.797539 |
| YL26020900019907 | Trailrider-1男款山地车短裤-头版-YS2039MH | 3XL | 甘雅玲 | 326611 | 374247 | 2026-03-18 15:48:14 | 3 | 2026-03-22 17:35:21.795349 |
| YL26020900019906 | Trailrider-1男款山地车短裤-头版-YS2039MH | 2XL | 甘雅玲 | 326611 | 374247 | 2026-03-18 15:48:14 | 3 | 2026-03-22 17:35:21.793515 |
| YL26020900019905 | Trailrider-1男款山地车短裤-头版-YS2039MH | XL | 甘雅玲 | 326611 | 374247 | 2026-03-18 15:48:14 | 5 | 2026-03-22 17:35:21.791543 |
| YL26020900019904 | Trailrider-1男款山地车短裤-头版-YS2039MH | L | 甘雅玲 | 326611 | 374247 | 2026-03-18 15:48:14 | 4 | 2026-03-22 17:35:21.789556 |
| YL26020900019903 | Trailrider-1男款山地车短裤-头版-YS2039MH | M | 甘雅玲 | 326611 | 374247 | 2026-03-18 15:48:14 | 3 | 2026-03-22 17:35:21.787219 |
| YL26020900019902 | Trailrider-1男款山地车短裤-头版-YS2039MH | S | 甘雅玲 | 326611 | 374247 | 2026-03-18 15:48:14 | 2 | 2026-03-22 17:35:21.785430 |
| 1261220029906 | 驰影黑色女款背带短裤 | 2XL | 林树 | 316461 | 374366 | 2026-03-18 17:01:00 | 14 | 2026-03-22 17:35:21.773798 |
| 1261220029905 | 驰影黑色女款背带短裤 | XL | 林树 | 316461 | 374366 | 2026-03-18 17:01:00 | 18 | 2026-03-22 17:35:21.772055 |
| 1261220029904 | 驰影黑色女款背带短裤 | L | 林树 | 316461 | 374366 | 2026-03-18 17:01:00 | 16 | 2026-03-22 17:35:21.770405 |