到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| RX25112900039905 | LBCC-25 Asphalt女款防风背心-二版-YS9099WCO | XL | 袁日仙 | 306785 | 351473 | 2026-01-13 15:42:34 | 1 | 2026-03-22 17:35:49.890161 |
| RX25112900039904 | LBCC-25 Asphalt女款防风背心-二版-YS9099WCO | L | 袁日仙 | 306785 | 351473 | 2026-01-13 15:42:34 | 2 | 2026-03-22 17:35:49.888503 |
| RX25112900039903 | LBCC-25 Asphalt女款防风背心-二版-YS9099WCO | M | 袁日仙 | 306785 | 351473 | 2026-01-13 15:42:34 | 8 | 2026-03-22 17:35:49.886916 |
| RX25112900039902 | LBCC-25 Asphalt女款防风背心-二版-YS9099WCO | S | 袁日仙 | 306785 | 351473 | 2026-01-13 15:42:34 | 10 | 2026-03-22 17:35:49.885204 |
| RX25112900039901 | LBCC-25 Asphalt女款防风背心-二版-YS9099WCO | XS | 袁日仙 | 306785 | 351473 | 2026-01-13 15:42:34 | 6 | 2026-03-22 17:35:49.883325 |
| RX25112900039911 | LBCC-25 Asphalt女款防风背心-二版-YS9099WCO | 2XS | 袁日仙 | 306785 | 351473 | 2026-01-13 15:42:34 | 1 | 2026-03-22 17:35:49.881158 |
| JB25121300059907 | ES16-2025 01 v2男款风衣-头版-YS8030MJ | 3XL | 郑杰彬 | 311237 | 351474 | 2026-01-13 15:43:01 | 5 | 2026-03-22 17:35:49.879395 |
| JB25121300059908 | ES16-2025 01 v2男款风衣-头版-YS8030MJ | 4XL | 郑杰彬 | 311237 | 351474 | 2026-01-13 15:43:01 | 5 | 2026-03-22 17:35:49.877669 |
| JB25121300059906 | ES16-2025 01 v2男款风衣-头版-YS8030MJ | 2XL | 郑杰彬 | 311237 | 351474 | 2026-01-13 15:43:01 | 5 | 2026-03-22 17:35:49.875864 |
| JB25121300059905 | ES16-2025 01 v2男款风衣-头版-YS8030MJ | XL | 郑杰彬 | 311237 | 351474 | 2026-01-13 15:43:01 | 15 | 2026-03-22 17:35:49.874095 |
| JB25121300059904 | ES16-2025 01 v2男款风衣-头版-YS8030MJ | L | 郑杰彬 | 311237 | 351474 | 2026-01-13 15:43:01 | 15 | 2026-03-22 17:35:49.871945 |
| JB25121300059903 | ES16-2025 01 v2男款风衣-头版-YS8030MJ | M | 郑杰彬 | 311237 | 351474 | 2026-01-13 15:43:01 | 10 | 2026-03-22 17:35:49.870098 |
| JB25121300059902 | ES16-2025 01 v2男款风衣-头版-YS8030MJ | S | 郑杰彬 | 311237 | 351474 | 2026-01-13 15:43:01 | 5 | 2026-03-22 17:35:49.868376 |
| LF2403270379905 | 24Degree女款背带短裤-CD006W | XL | 罗兰方 | 311663 | 351475 | 2026-01-13 15:43:35 | 2 | 2026-03-22 17:35:49.866692 |
| LF2403270379904 | 24Degree女款背带短裤-CD006W | L | 罗兰方 | 311663 | 351475 | 2026-01-13 15:43:35 | 3 | 2026-03-22 17:35:49.864989 |
| LF2403270379903 | 24Degree女款背带短裤-CD006W | M | 罗兰方 | 311663 | 351475 | 2026-01-13 15:43:35 | 12 | 2026-03-22 17:35:49.862944 |
| LF2403270379902 | 24Degree女款背带短裤-CD006W | S | 罗兰方 | 311663 | 351475 | 2026-01-13 15:43:35 | 12 | 2026-03-22 17:35:49.861112 |
| ZT25123001059904 | DHL25 Carbon男款慢跑背心-头版-YS9726MA | L | 曾亭 | 315570 | 351477 | 2026-01-13 15:45:25 | 3 | 2026-03-22 17:35:49.859250 |
| ZT25123001059903 | DHL25 Carbon男款慢跑背心-头版-YS9726MA | M | 曾亭 | 315570 | 351477 | 2026-01-13 15:45:25 | 1 | 2026-03-22 17:35:49.857524 |
| LF25123000059904 | JR BASIC BLACK童装长裤-头版-YS2276M | L | 罗兰方 | 316605 | 351526 | 2026-01-13 17:03:08 | 1 | 2026-03-22 17:35:49.855567 |