到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| ZT25122000149904 | Tarpon 25 green男款T恤-头版-YS9068MT | L | 曾亭 | 312639 | 347793 | 2026-01-02 10:42:22 | 5 | 2026-03-22 17:35:55.496930 |
| ZT25122000149905 | Tarpon 25 green男款T恤-头版-YS9068MT | XL | 曾亭 | 312639 | 347793 | 2026-01-02 10:42:22 | 6 | 2026-03-22 17:35:55.495335 |
| ZT25122000149906 | Tarpon 25 green男款T恤-头版-YS9068MT | 2XL | 曾亭 | 312639 | 347793 | 2026-01-02 10:42:22 | 1 | 2026-03-22 17:35:55.493807 |
| ZT25122000149907 | Tarpon 25 green男款T恤-头版-YS9068MT | 3XL | 曾亭 | 312639 | 347793 | 2026-01-02 10:42:22 | 1 | 2026-03-22 17:35:55.492229 |
| RX25120600149902 | Team Nvoke 2025男款长上衣-头版-YS9462MA | S | 袁日仙 | 309370 | 347794 | 2026-01-02 10:42:49 | 2 | 2026-03-22 17:35:55.490662 |
| RX25120600149903 | Team Nvoke 2025男款长上衣-头版-YS9462MA | M | 袁日仙 | 309370 | 347794 | 2026-01-02 10:42:49 | 2 | 2026-03-22 17:35:55.489101 |
| RX25120600149904 | Team Nvoke 2025男款长上衣-头版-YS9462MA | L | 袁日仙 | 309370 | 347794 | 2026-01-02 10:42:49 | 1 | 2026-03-22 17:35:55.487559 |
| DQ20221217089907 | 007c-2反光骑行夹克 | 3XL | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 5 | 2026-03-22 17:35:55.485914 |
| DZ251203139902 | 凯乐石VG2617219藤灰紫女款长上衣 | S | 黄瑞辉 | 314020 | 347860 | 2026-02-04 11:22:51 | 3 | 2026-03-22 17:35:55.485767 |
| DZ251203129903 | 凯乐石VG2617119简欧白男款长上衣 | M | 黄瑞辉 | 314018 | 347856 | 2026-02-04 11:22:51 | 3 | 2026-03-22 17:35:55.485765 |
| DZ251106959902 | 凯乐石VG2617218简欧白女款短上衣 | S | 黄瑞辉 | 314020 | 347860 | 2026-02-04 11:22:51 | 3 | 2026-03-22 17:35:55.485763 |
| DZ251106949903 | 凯乐石VG2617118深鸢尾紫男款短上衣 | M | 黄瑞辉 | 314018 | 347856 | 2026-02-04 11:22:51 | 3 | 2026-03-22 17:35:55.485759 |
| DQ20221217089908 | 007c-2反光骑行夹克 | 4XL | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 5 | 2026-03-22 17:35:55.480824 |
| DQ20221217089909 | 007c-2反光骑行夹克 | 5XL | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 5 | 2026-03-22 17:35:55.479146 |
| DQ20221217089910 | 007c-2反光骑行夹克 | 6XL | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 7 | 2026-03-22 17:35:55.477343 |
| DQ20221217099901 | 007c-3反光骑行夹克 | XS | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 2 | 2026-03-22 17:35:55.475621 |
| DQ20221217099902 | 007c-3反光骑行夹克 | S | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 2 | 2026-03-22 17:35:55.473687 |
| DQ20221217099903 | 007c-3反光骑行夹克 | M | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 25 | 2026-03-22 17:35:55.471904 |
| DQ20221217099904 | 007c-3反光骑行夹克 | L | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 25 | 2026-03-22 17:35:55.470038 |
| DQ20221217099905 | 007c-3反光骑行夹克 | XL | 吕丹琪 | 297389 | 347891 | 2026-01-02 15:15:35 | 20 | 2026-03-22 17:35:55.468130 |