到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| YK26012800059903 | Truebit-Pink女款背带短裤-头版-YS9163W | M | 何咏凯 | 323449 | 359009 | 2026-02-03 18:26:44 | 1 | 2026-03-22 17:35:36.375614 |
| DZ261200219905 | BMC 2026女款長上衣 | XL | 何佳欣 | 319164 | 359074 | 2026-02-04 11:03:50 | 2 | 2026-03-22 17:35:36.374116 |
| DZ261200219904 | BMC 2026女款長上衣 | L | 何佳欣 | 319164 | 359074 | 2026-02-04 11:03:50 | 2 | 2026-03-22 17:35:36.372570 |
| DZ261200219903 | BMC 2026女款長上衣 | M | 何佳欣 | 319164 | 359074 | 2026-02-04 11:03:50 | 2 | 2026-03-22 17:35:36.370950 |
| DZ261200209908 | BMC 2026男款長上衣 | 4XL | 何佳欣 | 319164 | 359074 | 2026-02-04 11:03:50 | 2 | 2026-03-22 17:35:36.369403 |
| DZ261200209907 | BMC 2026男款長上衣 | 3XL | 何佳欣 | 319164 | 359074 | 2026-02-04 11:03:50 | 1 | 2026-03-22 17:35:36.367904 |
| DZ261200209906 | BMC 2026男款長上衣 | 2XL | 何佳欣 | 319164 | 359074 | 2026-02-04 11:03:50 | 1 | 2026-03-22 17:35:36.366361 |
| DZ261200209904 | BMC 2026男款長上衣 | L | 何佳欣 | 319164 | 359074 | 2026-02-04 11:03:50 | 3 | 2026-03-22 17:35:36.364856 |
| DZ261200209903 | BMC 2026男款長上衣 | M | 何佳欣 | 319164 | 359074 | 2026-02-04 11:03:50 | 1 | 2026-03-22 17:35:36.363329 |
| LF26011700099907 | 25FLYERS-2女款T恤-头版-CY116WCO | 3XL | 罗兰方 | 320212 | 359075 | 2026-02-04 11:05:50 | 2 | 2026-03-22 17:35:36.361792 |
| LF26011700099906 | 25FLYERS-2女款T恤-头版-CY116WCO | 2XL | 罗兰方 | 320212 | 359075 | 2026-02-04 11:05:50 | 2 | 2026-03-22 17:35:36.360265 |
| LF26011700099905 | 25FLYERS-2女款T恤-头版-CY116WCO | XL | 罗兰方 | 320212 | 359075 | 2026-02-04 11:05:50 | 2 | 2026-03-22 17:35:36.358722 |
| LF26011700099904 | 25FLYERS-2女款T恤-头版-CY116WCO | L | 罗兰方 | 320212 | 359075 | 2026-02-04 11:05:50 | 3 | 2026-03-22 17:35:36.357213 |
| LF26011700099903 | 25FLYERS-2女款T恤-头版-CY116WCO | M | 罗兰方 | 320212 | 359075 | 2026-02-04 11:05:50 | 3 | 2026-03-22 17:35:36.355691 |
| LF26011700149906 | KRAFT-BHM NEW男款慢跑背心-头版-YS9347MKJO | 2XL | 罗兰方 | 320238 | 359076 | 2026-02-04 11:06:20 | 10 | 2026-03-22 17:35:36.354163 |
| LF26011700149905 | KRAFT-BHM NEW男款慢跑背心-头版-YS9347MKJO | XL | 罗兰方 | 320238 | 359076 | 2026-02-04 11:06:20 | 30 | 2026-03-22 17:35:36.352465 |
| LF26011700149904 | KRAFT-BHM NEW男款慢跑背心-头版-YS9347MKJO | L | 罗兰方 | 320238 | 359076 | 2026-02-04 11:06:20 | 85 | 2026-03-22 17:35:36.299544 |
| LF26011700149903 | KRAFT-BHM NEW男款慢跑背心-头版-YS9347MKJO | M | 罗兰方 | 320238 | 359076 | 2026-02-04 11:06:20 | 85 | 2026-03-22 17:35:36.298022 |
| LF26011700149902 | KRAFT-BHM NEW男款慢跑背心-头版-YS9347MKJO | S | 罗兰方 | 320238 | 359076 | 2026-02-04 11:06:20 | 40 | 2026-03-22 17:35:36.296493 |
| RX26011700149904 | Urbis 2025男款铁三背心-头版-YS9730MO | L | 袁日仙 | 319267 | 359077 | 2026-02-04 11:06:41 | 4 | 2026-03-22 17:35:36.294963 |