到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| JB25121300089904 | ES16-2025 1409 v2男款长上衣-头版-YS8037MDO | L | 郑杰彬 | 311335 | 348727 | 2026-01-05 15:45:11 | 15 | 2026-03-22 17:35:54.097139 |
| JB25121300089902 | ES16-2025 1409 v2男款长上衣-头版-YS8037MDO | S | 郑杰彬 | 311335 | 348727 | 2026-01-05 15:45:11 | 9 | 2026-03-22 17:35:54.094547 |
| JB25121300089901 | ES16-2025 1409 v2男款长上衣-头版-YS8037MDO | XS | 郑杰彬 | 311335 | 348727 | 2026-01-05 15:45:11 | 3 | 2026-03-22 17:35:54.091958 |
| RX25122000379903 | Jlife-Raid MTB 2025-C男款短上衣-头版-YS9640MY | M | 袁日仙 | 313204 | 348733 | 2026-01-05 15:45:36 | 1 | 2026-03-22 17:35:54.089251 |
| ZT25122200499904 | Blue70 26 LW男款T恤-头版-YS9068MT | L | 曾亭 | 314140 | 348734 | 2026-01-05 15:46:01 | 2 | 2026-03-22 17:35:54.086673 |
| ZT25122200499907 | Blue70 26 LW男款T恤-头版-YS9068MT | 3XL | 曾亭 | 314140 | 348734 | 2026-01-05 15:46:01 | 1 | 2026-03-22 17:35:54.084238 |
| ZT25122200499905 | Blue70 26 LW男款T恤-头版-YS9068MT | XL | 曾亭 | 314140 | 348734 | 2026-01-05 15:46:01 | 2 | 2026-03-22 17:35:54.081661 |
| ZT25122200499903 | Blue70 26 LW男款T恤-头版-YS9068MT | M | 曾亭 | 314140 | 348734 | 2026-01-05 15:46:01 | 1 | 2026-03-22 17:35:54.079351 |
| ZT25121300399907 | WSC 25男款短上衣-头版-YS9470MYBO | 3XL | 曾亭 | 311346 | 348735 | 2026-01-05 15:46:30 | 2 | 2026-03-22 17:35:54.077135 |
| ZT25121300399906 | WSC 25男款短上衣-头版-YS9470MYBO | 2XL | 曾亭 | 311346 | 348735 | 2026-01-05 15:46:30 | 1 | 2026-03-22 17:35:54.075105 |
| ZT25121300399905 | WSC 25男款短上衣-头版-YS9470MYBO | XL | 曾亭 | 311346 | 348735 | 2026-01-05 15:46:30 | 3 | 2026-03-22 17:35:54.073520 |
| ZT25121300399904 | WSC 25男款短上衣-头版-YS9470MYBO | L | 曾亭 | 311346 | 348735 | 2026-01-05 15:46:30 | 7 | 2026-03-22 17:35:54.071996 |
| ZT25121300399903 | WSC 25男款短上衣-头版-YS9470MYBO | M | 曾亭 | 311346 | 348735 | 2026-01-05 15:46:30 | 6 | 2026-03-22 17:35:54.070432 |
| ZT25121300399902 | WSC 25男款短上衣-头版-YS9470MYBO | S | 曾亭 | 311346 | 348735 | 2026-01-05 15:46:30 | 1 | 2026-03-22 17:35:54.068851 |
| ZT25121300399901 | WSC 25男款短上衣-头版-YS9470MYBO | XS | 曾亭 | 311346 | 348735 | 2026-01-05 15:46:30 | 1 | 2026-03-22 17:35:54.067281 |
| DQ25122200029906 | 25Heat-Black女款抓绒长上衣-二版-CD044WAO | 2XL | 吕丹琪 | 313300 | 348740 | 2026-01-05 15:48:31 | 5 | 2026-03-22 17:35:54.065681 |
| RX25122000429905 | Rattlesnake-black男款背带短裤-头版-YS9113MVO | XL | 袁日仙 | 312508 | 348736 | 2026-02-26 16:21:07 | 2 | 2026-03-22 17:35:54.065572 |
| DQ25122200029905 | 25Heat-Black女款抓绒长上衣-二版-CD044WAO | XL | 吕丹琪 | 313300 | 348740 | 2026-01-05 15:48:31 | 5 | 2026-03-22 17:35:54.062956 |
| DQ25122200029904 | 25Heat-Black女款抓绒长上衣-二版-CD044WAO | L | 吕丹琪 | 313300 | 348740 | 2026-01-05 15:48:31 | 15 | 2026-03-22 17:35:54.061266 |
| DQ25122200029902 | 25Heat-Black女款抓绒长上衣-二版-CD044WAO | S | 吕丹琪 | 313300 | 348740 | 2026-01-05 15:48:31 | 7 | 2026-03-22 17:35:54.059522 |