到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| RX25123000109904 | CUPCKE-Central Illinois Athlete Club女款短上衣-头版-YS9421WCO | L | 袁日仙 | 314056 | 351465 | 2026-01-13 15:37:34 | 2 | 2026-03-22 17:35:49.974043 |
| RX25123000109902 | CUPCKE-Central Illinois Athlete Club女款短上衣-头版-YS9421WCO | S | 袁日仙 | 314056 | 351465 | 2026-01-13 15:37:34 | 1 | 2026-03-22 17:35:49.971959 |
| ZT25123000519904 | Picky 26女款抓绒夹克-头版-YS9655WBT | L | 曾亭 | 315255 | 351466 | 2026-01-13 15:38:52 | 1 | 2026-03-22 17:35:49.969902 |
| ZT25122200749903 | KSU 25男款短袖连体衣-头版-YS9212MJFO | M | 曾亭 | 313991 | 351468 | 2026-01-13 15:40:29 | 1 | 2026-03-22 17:35:49.967848 |
| JB25122200149905 | LHippo v4男款短袖三铁连体衣-三版-YS9251MHR | XL | 郑杰彬 | 314041 | 351467 | 2026-01-27 15:50:35 | 20 | 2026-03-22 17:35:49.967658 |
| JB25122200149904 | LHippo v4男款短袖三铁连体衣-三版-YS9251MHR | L | 郑杰彬 | 314041 | 351467 | 2026-01-27 15:50:35 | 102 | 2026-03-22 17:35:49.967656 |
| JB25122200149903 | LHippo v4男款短袖三铁连体衣-三版-YS9251MHR | M | 郑杰彬 | 314041 | 351467 | 2026-01-27 15:50:35 | 152 | 2026-03-22 17:35:49.967654 |
| JB25122200149902 | LHippo v4男款短袖三铁连体衣-三版-YS9251MHR | S | 郑杰彬 | 314041 | 351467 | 2026-01-27 15:50:35 | 80 | 2026-03-22 17:35:49.967650 |
| ZT25122200749902 | KSU 25男款短袖连体衣-头版-YS9212MJFO | S | 曾亭 | 313991 | 351468 | 2026-01-13 15:40:29 | 1 | 2026-03-22 17:35:49.962542 |
| MN25123000049906 | Blue70 26-2女款POLO衫-头版-YS9697WCT | 2XL | 林美霓 | 314991 | 351470 | 2026-01-13 15:41:03 | 1 | 2026-03-22 17:35:49.960944 |
| MN25123000029904 | Blue70 26 Tri女款短上衣-头版-YS9730WDO | L | 林美霓 | 314991 | 351470 | 2026-01-13 15:41:03 | 2 | 2026-03-22 17:35:49.959199 |
| MN25123000029903 | Blue70 26 Tri女款短上衣-头版-YS9730WDO | M | 林美霓 | 314991 | 351470 | 2026-01-13 15:41:03 | 1 | 2026-03-22 17:35:49.957472 |
| ZT25122200229903 | TriRig 26女款慢跑背心-头版-YS9726W | M | 曾亭 | 313671 | 351471 | 2026-01-13 15:41:29 | 1 | 2026-03-22 17:35:49.955657 |
| ZT25122200229902 | TriRig 26女款慢跑背心-头版-YS9726W | S | 曾亭 | 313671 | 351471 | 2026-01-13 15:41:29 | 1 | 2026-03-22 17:35:49.953955 |
| ZT26010700169906 | Ocala 25 Coach男款T恤-头版-YS9068MT | 2XL | 曾亭 | 316037 | 351472 | 2026-01-13 15:42:03 | 1 | 2026-03-22 17:35:49.951956 |
| RX25112900049904 | LBCC-25 Asphalt男款防风背心-二版-YS9099MEO | L | 袁日仙 | 306785 | 351473 | 2026-01-13 15:42:34 | 7 | 2026-03-22 17:35:49.898950 |
| RX25112900049905 | LBCC-25 Asphalt男款防风背心-二版-YS9099MEO | XL | 袁日仙 | 306785 | 351473 | 2026-01-13 15:42:34 | 5 | 2026-03-22 17:35:49.897244 |
| RX25112900049903 | LBCC-25 Asphalt男款防风背心-二版-YS9099MEO | M | 袁日仙 | 306785 | 351473 | 2026-01-13 15:42:34 | 9 | 2026-03-22 17:35:49.895579 |
| RX25112900049902 | LBCC-25 Asphalt男款防风背心-二版-YS9099MEO | S | 袁日仙 | 306785 | 351473 | 2026-01-13 15:42:34 | 12 | 2026-03-22 17:35:49.893835 |
| RX25112900049901 | LBCC-25 Asphalt男款防风背心-二版-YS9099MEO | XS | 袁日仙 | 306785 | 351473 | 2026-01-13 15:42:34 | 1 | 2026-03-22 17:35:49.892113 |