到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| 1231600759905 | 2023-WEEKEND(黑色)内搭背心 | XL | 何佳欣 | 320391 | 361514 | 2026-02-10 15:31:06 | 3 | 2026-03-22 17:35:30.978342 |
| 1231600759904 | 2023-WEEKEND(黑色)内搭背心 | L | 何佳欣 | 320391 | 361514 | 2026-02-10 15:31:06 | 5 | 2026-03-22 17:35:30.976652 |
| 1231600759903 | 2023-WEEKEND(黑色)内搭背心 | M | 何佳欣 | 320391 | 361514 | 2026-02-10 15:31:06 | 11 | 2026-03-22 17:35:30.975121 |
| 1231600759902 | 2023-WEEKEND(黑色)内搭背心 | S | 何佳欣 | 320391 | 361514 | 2026-02-10 15:31:06 | 3 | 2026-03-22 17:35:30.973583 |
| MJ26012400309900 | Balutia小布帽-头版-YS4043 | F | 庄镘洁 | 320933 | 361515 | 2026-02-10 15:33:44 | 150 | 2026-03-22 17:35:30.972051 |
| ZT25120300109905 | PARIA25 Leopard男款T恤-头版-YS9068MT | XL | 曾亭 | 323286 | 361516 | 2026-02-10 15:37:03 | 2 | 2026-03-22 17:35:30.970528 |
| ZT25120300109904 | PARIA25 Leopard男款T恤-头版-YS9068MT | L | 曾亭 | 323286 | 361516 | 2026-02-10 15:37:03 | 5 | 2026-03-22 17:35:30.969051 |
| ZT25120300109903 | PARIA25 Leopard男款T恤-头版-YS9068MT | M | 曾亭 | 323286 | 361516 | 2026-02-10 15:37:03 | 3 | 2026-03-22 17:35:30.967397 |
| ZT25120300109902 | PARIA25 Leopard男款T恤-头版-YS9068MT | S | 曾亭 | 323286 | 361516 | 2026-02-10 15:37:03 | 3 | 2026-03-22 17:35:30.965848 |
| ZT25120300109901 | PARIA25 Leopard男款T恤-头版-YS9068MT | XS | 曾亭 | 323286 | 361516 | 2026-02-10 15:37:03 | 2 | 2026-03-22 17:35:30.964339 |
| ZT25052600039906 | PARIA25 Grain男款T恤-YS9068MT | 2XL | 曾亭 | 323286 | 361516 | 2026-02-10 15:37:03 | 1 | 2026-03-22 17:35:30.962826 |
| ZT25052600039905 | PARIA25 Grain男款T恤-YS9068MT | XL | 曾亭 | 323286 | 361516 | 2026-02-10 15:37:03 | 4 | 2026-03-22 17:35:30.961236 |
| ZT25052600039904 | PARIA25 Grain男款T恤-YS9068MT | L | 曾亭 | 323286 | 361516 | 2026-02-10 15:37:03 | 5 | 2026-03-22 17:35:30.959490 |
| ZT25052600039903 | PARIA25 Grain男款T恤-YS9068MT | M | 曾亭 | 323286 | 361516 | 2026-02-10 15:37:03 | 5 | 2026-03-22 17:35:30.957903 |
| ZT25052600039902 | PARIA25 Grain男款T恤-YS9068MT | S | 曾亭 | 323286 | 361516 | 2026-02-10 15:37:03 | 1 | 2026-03-22 17:35:30.956239 |
| ZT25120300099906 | PARIA25 Skull男款T恤-头版-YS9068MT | 2XL | 曾亭 | 323286 | 361516 | 2026-02-10 15:37:03 | 1 | 2026-03-22 17:35:30.954654 |
| ZT25120300099904 | PARIA25 Skull男款T恤-头版-YS9068MT | L | 曾亭 | 323286 | 361516 | 2026-02-10 15:37:03 | 5 | 2026-03-22 17:35:30.953078 |
| ZT25120300099905 | PARIA25 Skull男款T恤-头版-YS9068MT | XL | 曾亭 | 323286 | 361516 | 2026-02-10 15:37:03 | 2 | 2026-03-22 17:35:30.950551 |
| ZT25120300099903 | PARIA25 Skull男款T恤-头版-YS9068MT | M | 曾亭 | 323286 | 361516 | 2026-02-10 15:37:03 | 5 | 2026-03-22 17:35:30.898238 |
| ZT25120300099902 | PARIA25 Skull男款T恤-头版-YS9068MT | S | 曾亭 | 323286 | 361516 | 2026-02-10 15:37:03 | 2 | 2026-03-22 17:35:30.896624 |