到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| BH25121700069904 | MTB Cro Sage男款T恤-头版-YS9068MAX | L | 凌碧红 | 312387 | 349206 | 2026-01-06 17:54:23 | 40 | 2026-03-22 17:35:53.289061 |
| BH25121700069903 | MTB Cro Sage男款T恤-头版-YS9068MAX | M | 凌碧红 | 312387 | 349206 | 2026-01-06 17:54:23 | 30 | 2026-03-22 17:35:53.287269 |
| BH25121700069902 | MTB Cro Sage男款T恤-头版-YS9068MAX | S | 凌碧红 | 312387 | 349206 | 2026-01-06 17:54:23 | 10 | 2026-03-22 17:35:53.285682 |
| BH25121700069901 | MTB Cro Sage男款T恤-头版-YS9068MAX | XS | 凌碧红 | 312387 | 349206 | 2026-01-06 17:54:23 | 4 | 2026-03-22 17:35:53.284165 |
| ZT25121700289904 | PalmCoast sport女款短上衣-头版-YS9409WO | L | 曾亭 | 312025 | 349211 | 2026-01-06 17:55:11 | 1 | 2026-03-22 17:35:53.282300 |
| ZT25121700279903 | PalmCoast sport男款短上衣-头版-YS9409MO | M | 曾亭 | 312025 | 349211 | 2026-01-06 17:55:11 | 1 | 2026-03-22 17:35:53.280589 |
| ZT25121700279902 | PalmCoast sport男款短上衣-头版-YS9409MO | S | 曾亭 | 312025 | 349211 | 2026-01-06 17:55:11 | 2 | 2026-03-22 17:35:53.279072 |
| ZT25121700279901 | PalmCoast sport男款短上衣-头版-YS9409MO | XS | 曾亭 | 312025 | 349211 | 2026-01-06 17:55:11 | 1 | 2026-03-22 17:35:53.277496 |
| ZT25122200559908 | Blue70 26-2男款POLO衫-头版-YS9697MLO | 4XL | 曾亭 | 314497 | 349212 | 2026-01-06 17:55:37 | 1 | 2026-03-22 17:35:53.275966 |
| ZT25122200559905 | Blue70 26-2男款POLO衫-头版-YS9697MLO | XL | 曾亭 | 314497 | 349212 | 2026-01-06 17:55:37 | 1 | 2026-03-22 17:35:53.274371 |
| ZT25122200559904 | Blue70 26-2男款POLO衫-头版-YS9697MLO | L | 曾亭 | 314497 | 349212 | 2026-01-06 17:55:37 | 1 | 2026-03-22 17:35:53.272838 |
| ZT25122200559903 | Blue70 26-2男款POLO衫-头版-YS9697MLO | M | 曾亭 | 314497 | 349212 | 2026-01-06 17:55:37 | 2 | 2026-03-22 17:35:53.271255 |
| RX25112200499905 | LBCC-25Black女款长上衣-二版-YS9406WKBO | XL | 袁日仙 | 308263 | 349213 | 2026-01-06 17:56:01 | 1 | 2026-03-22 17:35:53.269639 |
| RX25112200499904 | LBCC-25Black女款长上衣-二版-YS9406WKBO | L | 袁日仙 | 308263 | 349213 | 2026-01-06 17:56:01 | 10 | 2026-03-22 17:35:53.268104 |
| RX25112200499903 | LBCC-25Black女款长上衣-二版-YS9406WKBO | M | 袁日仙 | 308263 | 349213 | 2026-01-06 17:56:01 | 20 | 2026-03-22 17:35:53.266492 |
| RX25112200499902 | LBCC-25Black女款长上衣-二版-YS9406WKBO | S | 袁日仙 | 308263 | 349213 | 2026-01-06 17:56:01 | 23 | 2026-03-22 17:35:53.264987 |
| RX25112200499901 | LBCC-25Black女款长上衣-二版-YS9406WKBO | XS | 袁日仙 | 308263 | 349213 | 2026-01-06 17:56:01 | 20 | 2026-03-22 17:35:53.263428 |
| RX25112200499911 | LBCC-25Black女款长上衣-二版-YS9406WKBO | 2XS | 袁日仙 | 308263 | 349213 | 2026-01-06 17:56:01 | 6 | 2026-03-22 17:35:53.261886 |
| RX25122000449904 | Rattlesnake女款短上衣-头版-YS9735WT | L | 袁日仙 | 312508 | 349216 | 2026-01-06 17:57:47 | 2 | 2026-03-22 17:35:53.260319 |
| RX25122000449903 | Rattlesnake女款短上衣-头版-YS9735WT | M | 袁日仙 | 312508 | 349216 | 2026-01-06 17:57:47 | 1 | 2026-03-22 17:35:53.258766 |