到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| 1231120639905 | 素尚3黑色抓绒长袖内搭衣 | XL | 黄婉婷 | 313832 | 350050 | 2026-01-09 10:55:58 | 5 | 2026-03-22 17:35:51.983661 |
| ZT25122200659906 | PHHI 2026男款短上衣-头版-YS9841MK | 2XL | 曾亭 | 313971 | 350051 | 2026-01-09 11:00:35 | 1 | 2026-03-22 17:35:51.982073 |
| ZT25122200659905 | PHHI 2026男款短上衣-头版-YS9841MK | XL | 曾亭 | 313971 | 350051 | 2026-01-09 11:00:35 | 1 | 2026-03-22 17:35:51.980446 |
| ZT25122200659904 | PHHI 2026男款短上衣-头版-YS9841MK | L | 曾亭 | 313971 | 350051 | 2026-01-09 11:00:35 | 1 | 2026-03-22 17:35:51.978858 |
| ZT25122200659903 | PHHI 2026男款短上衣-头版-YS9841MK | M | 曾亭 | 313971 | 350051 | 2026-01-09 11:00:35 | 2 | 2026-03-22 17:35:51.976865 |
| ZT25122200659902 | PHHI 2026男款短上衣-头版-YS9841MK | S | 曾亭 | 313971 | 350051 | 2026-01-09 11:00:35 | 1 | 2026-03-22 17:35:51.974971 |
| LF25121700119905 | PD-COAST男款短袖连体衣-二版-YS9251MZB | XL | 罗兰方 | 312271 | 350052 | 2026-01-09 11:01:07 | 2 | 2026-03-22 17:35:51.973111 |
| LF25121700119904 | PD-COAST男款短袖连体衣-二版-YS9251MZB | L | 罗兰方 | 312271 | 350052 | 2026-01-09 11:01:07 | 3 | 2026-03-22 17:35:51.971498 |
| LF25121700119903 | PD-COAST男款短袖连体衣-二版-YS9251MZB | M | 罗兰方 | 312271 | 350052 | 2026-01-09 11:01:07 | 3 | 2026-03-22 17:35:51.969900 |
| LF25122200019902 | PD-26BIBS女款背带短裤-头版-YS2218WA | S | 罗兰方 | 313703 | 350054 | 2026-01-09 11:02:18 | 2 | 2026-03-22 17:35:51.968327 |
| YY25122000029903 | WT GFiber Supreme男款背带短裤-头版-YS2047MBO | M | 刘莹滢 | 312479 | 350055 | 2026-01-09 11:04:01 | 12 | 2026-03-22 17:35:51.966655 |
| LF25122200019901 | PD-26BIBS女款背带短裤-头版-YS2218WA | XS | 罗兰方 | 313703 | 350054 | 2026-01-27 17:57:19 | 3 | 2026-03-22 17:35:51.966543 |
| YY25122000019903 | WT GFiber Supreme女款背带短裤-头版-YS2047WBAO | M | 刘莹滢 | 312479 | 350055 | 2026-01-09 11:04:01 | 2 | 2026-03-22 17:35:51.963909 |
| YY25122000019902 | WT GFiber Supreme女款背带短裤-头版-YS2047WBAO | S | 刘莹滢 | 312479 | 350055 | 2026-01-09 11:04:01 | 1 | 2026-03-22 17:35:51.962261 |
| ZT2411160349903 | 904Duval女款背带短裤-YS9113W | M | 曾亭 | 311596 | 350056 | 2026-01-09 11:04:56 | 1 | 2026-03-22 17:35:51.960680 |
| ZT2411160439903 | 904Duval男款背带短裤-YS9153MZ | M | 曾亭 | 311596 | 350056 | 2026-01-09 11:04:56 | 1 | 2026-03-22 17:35:51.959075 |
| ZT2411160439902 | 904Duval男款背带短裤-YS9153MZ | S | 曾亭 | 311596 | 350056 | 2026-01-09 11:04:56 | 3 | 2026-03-22 17:35:51.957316 |
| LF25122200029902 | PD-26BIBS-2男款背带短裤-头版-YS2218MA | S | 罗兰方 | 314141 | 350060 | 2026-01-09 11:05:41 | 1 | 2026-03-22 17:35:51.955417 |
| RX25122200119903 | CUPCKE-Foot Traffic男款背带短裤-头版-YS9113MO | M | 袁日仙 | 313678 | 350061 | 2026-01-09 11:06:20 | 1 | 2026-03-22 17:35:51.953396 |
| RX25122200119902 | CUPCKE-Foot Traffic男款背带短裤-头版-YS9113MO | S | 袁日仙 | 313678 | 350061 | 2026-01-09 11:06:20 | 1 | 2026-03-22 17:35:51.950619 |