到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| DQ2407160099908 | 24ARROW-GRAY男款抓绒长上衣-CD044MBAO | 4XL | 吕丹琪 | 313321 | 351688 | 2026-01-14 10:50:10 | 3 | 2026-03-22 17:35:49.486242 |
| DQ2407160099904 | 24ARROW-GRAY男款抓绒长上衣-CD044MBAO | L | 吕丹琪 | 313321 | 351688 | 2026-01-14 10:50:10 | 10 | 2026-03-22 17:35:49.484673 |
| YY26010700109906 | WT HCE Orange IRI女款T恤-头版-YS9681WO | 2XL | 刘莹滢 | 316017 | 351689 | 2026-01-14 10:51:12 | 1 | 2026-03-22 17:35:49.483134 |
| ZT25122200519905 | Blue70 26男款短上衣-头版-YS9409MEKO | XL | 曾亭 | 314140 | 351690 | 2026-01-14 10:51:48 | 1 | 2026-03-22 17:35:49.481557 |
| ZT25122200519904 | Blue70 26男款短上衣-头版-YS9409MEKO | L | 曾亭 | 314140 | 351690 | 2026-01-14 10:51:48 | 1 | 2026-03-22 17:35:49.480012 |
| ZT25122200519903 | Blue70 26男款短上衣-头版-YS9409MEKO | M | 曾亭 | 314140 | 351690 | 2026-01-14 10:51:48 | 1 | 2026-03-22 17:35:49.478481 |
| ZT25122200509902 | Blue70 26 LW男款短上衣-头版-YS9409MEKO | S | 曾亭 | 314140 | 351690 | 2026-01-14 10:51:48 | 1 | 2026-03-22 17:35:49.476991 |
| ZT25122200579905 | Blue70 26 Tri男款短上衣-头版-YS9730MFO | XL | 曾亭 | 314497 | 351691 | 2026-01-14 10:52:14 | 1 | 2026-03-22 17:35:49.475419 |
| ZT25123000529904 | Picky 26女款短袖连体衣-头版-YS9212MJF | L | 曾亭 | 315255 | 351692 | 2026-01-14 10:52:39 | 2 | 2026-03-22 17:35:49.473846 |
| ZT25123000179905 | Picky 26 MTB男款T恤-头版-YS9492MO | XL | 曾亭 | 314757 | 351693 | 2026-01-14 10:53:19 | 1 | 2026-03-22 17:35:49.472297 |
| ZT25123000179904 | Picky 26 MTB男款T恤-头版-YS9492MO | L | 曾亭 | 314757 | 351693 | 2026-01-14 10:53:19 | 1 | 2026-03-22 17:35:49.470662 |
| ZT25123000149902 | Picky 26女款短上衣-头版-YS9409WKO | S | 曾亭 | 314757 | 351693 | 2026-01-14 10:53:19 | 1 | 2026-03-22 17:35:49.469068 |
| RX25122000219903 | CUPCKE-Form Racing-A男款短上衣-头版-YS9788MO | M | 袁日仙 | 312493 | 351694 | 2026-01-14 10:53:41 | 1 | 2026-03-22 17:35:49.467142 |
| RX26010700659907 | stelvio-SC童装T恤-二版-YS296KHO | 3XL | 袁日仙 | 316064 | 351696 | 2026-01-14 10:55:22 | 1 | 2026-03-22 17:35:49.465356 |
| 1261110239906 | 无界黑色女款短上衣 | 2XL | 林树 | 285898 | 351799 | 2026-01-14 15:52:00 | 5 | 2026-03-22 17:35:49.463768 |
| 1261110239905 | 无界黑色女款短上衣 | XL | 林树 | 285898 | 351799 | 2026-01-14 15:52:00 | 5 | 2026-03-22 17:35:49.461999 |
| 1261110239904 | 无界黑色女款短上衣 | L | 林树 | 285898 | 351799 | 2026-01-14 15:52:00 | 10 | 2026-03-22 17:35:49.460411 |
| 1261110239903 | 无界黑色女款短上衣 | M | 林树 | 285898 | 351799 | 2026-01-14 15:52:00 | 40 | 2026-03-22 17:35:49.458821 |
| 1261110239902 | 无界黑色女款短上衣 | S | 林树 | 285898 | 351799 | 2026-01-14 15:52:00 | 40 | 2026-03-22 17:35:49.457214 |
| 1261110239901 | 无界黑色女款短上衣 | XS | 林树 | 285898 | 351799 | 2026-01-14 15:52:00 | 10 | 2026-03-22 17:35:49.455601 |