到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| DZ251001019901 | W-ROAD SUIT YBT 26男款短袖连体衣 | XS | 黄瑞辉 | 316065 | 357974 | 2026-01-31 17:39:58 | 1 | 2026-03-22 17:35:38.667997 |
| 1241110599907 | 目标白色短上衣 | 3XL | 黄婉婷 | 315959 | 357975 | 2026-01-31 17:40:29 | 3 | 2026-03-22 17:35:38.666466 |
| 1241110599906 | 目标白色短上衣 | 2XL | 黄婉婷 | 315959 | 357975 | 2026-01-31 17:40:29 | 3 | 2026-03-22 17:35:38.664937 |
| 1241110599905 | 目标白色短上衣 | XL | 黄婉婷 | 315959 | 357975 | 2026-01-31 17:40:29 | 3 | 2026-03-22 17:35:38.663092 |
| 1241110599904 | 目标白色短上衣 | L | 黄婉婷 | 315959 | 357975 | 2026-01-31 17:40:29 | 1 | 2026-03-22 17:35:38.661548 |
| 1221110689907 | READY(准备)(黄色)短上衣 | 3XL | 黄婉婷 | 317916 | 357976 | 2026-01-31 17:41:03 | 2 | 2026-03-22 17:35:38.660001 |
| 1221110689906 | READY(准备)(黄色)短上衣 | 2XL | 黄婉婷 | 317916 | 357976 | 2026-01-31 17:41:03 | 3 | 2026-03-22 17:35:38.658421 |
| 1221110689905 | READY(准备)(黄色)短上衣 | XL | 黄婉婷 | 317916 | 357976 | 2026-01-31 17:41:03 | 3 | 2026-03-22 17:35:38.656897 |
| 1221110689904 | READY(准备)(黄色)短上衣 | L | 黄婉婷 | 317916 | 357976 | 2026-01-31 17:41:03 | 2 | 2026-03-22 17:35:38.655336 |
| 1221110679907 | GO(开始)(绿色)短上衣 | 3XL | 黄婉婷 | 317916 | 357976 | 2026-01-31 17:41:03 | 2 | 2026-03-22 17:35:38.653695 |
| 1221110679906 | GO(开始)(绿色)短上衣 | 2XL | 黄婉婷 | 317916 | 357976 | 2026-01-31 17:41:03 | 3 | 2026-03-22 17:35:38.651201 |
| 1221110679905 | GO(开始)(绿色)短上衣 | XL | 黄婉婷 | 317916 | 357976 | 2026-01-31 17:41:03 | 3 | 2026-03-22 17:35:38.598664 |
| 1221110679904 | GO(开始)(绿色)短上衣 | L | 黄婉婷 | 317916 | 357976 | 2026-01-31 17:41:03 | 2 | 2026-03-22 17:35:38.597161 |
| MJ26012400379907 | TCHACO FADA男款T恤-头版-YS9681MO | 3XL | 庄镘洁 | 322192 | 357977 | 2026-01-31 17:42:05 | 3 | 2026-03-22 17:35:38.595561 |
| MJ26012400379906 | TCHACO FADA男款T恤-头版-YS9681MO | 2XL | 庄镘洁 | 322192 | 357977 | 2026-01-31 17:42:05 | 5 | 2026-03-22 17:35:38.593944 |
| MJ26012400379905 | TCHACO FADA男款T恤-头版-YS9681MO | XL | 庄镘洁 | 322192 | 357977 | 2026-01-31 17:42:05 | 8 | 2026-03-22 17:35:38.592366 |
| MJ26012400379904 | TCHACO FADA男款T恤-头版-YS9681MO | L | 庄镘洁 | 322192 | 357977 | 2026-01-31 17:42:05 | 8 | 2026-03-22 17:35:38.590566 |
| MJ26012400379903 | TCHACO FADA男款T恤-头版-YS9681MO | M | 庄镘洁 | 322192 | 357977 | 2026-01-31 17:42:05 | 6 | 2026-03-22 17:35:38.588779 |
| MJ26012400379902 | TCHACO FADA男款T恤-头版-YS9681MO | S | 庄镘洁 | 322192 | 357977 | 2026-01-31 17:42:05 | 5 | 2026-03-22 17:35:38.587081 |
| ZT26012100359905 | infinity build男款抓绒夹克-头版-YS9655M | XL | 曾亭 | 320875 | 357978 | 2026-01-31 17:42:35 | 1 | 2026-03-22 17:35:38.585391 |