到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| JB25121300119902 | ES16-2025 03 v2男款长上衣-头版-YS8037MDO | S | 郑杰彬 | 311335 | 349336 | 2026-01-07 10:50:22 | 5 | 2026-03-22 17:35:53.063330 |
| JB25120900039906 | GB MOUTH男款风衣-二版-YS9687MC | 2XL | 郑杰彬 | 310858 | 349337 | 2026-01-07 10:52:18 | 15 | 2026-03-22 17:35:53.061820 |
| JB25120900039903 | GB MOUTH男款风衣-二版-YS9687MC | M | 郑杰彬 | 310858 | 349337 | 2026-01-07 10:52:18 | 20 | 2026-03-22 17:35:53.060293 |
| ZT25122200309905 | TriRig 26 Cargo男款背带短裤-头版-YS9153MGB | XL | 曾亭 | 313296 | 349338 | 2026-01-07 10:53:34 | 1 | 2026-03-22 17:35:53.058769 |
| ZT25122200279904 | TriRig 26男款铁三短裤-头版-YS2083MC | L | 曾亭 | 313296 | 349338 | 2026-01-07 10:53:34 | 4 | 2026-03-22 17:35:53.057249 |
| ZT25122200279903 | TriRig 26男款铁三短裤-头版-YS2083MC | M | 曾亭 | 313296 | 349338 | 2026-01-07 10:53:34 | 3 | 2026-03-22 17:35:53.055719 |
| MY25093000149904 | cycling duo aoe男款短上衣-头版-YS8052M | L | 胡美英 | 309271 | 349339 | 2026-01-07 10:53:58 | 3 | 2026-03-22 17:35:53.054145 |
| MY25093000149903 | cycling duo aoe男款短上衣-头版-YS8052M | M | 胡美英 | 309271 | 349339 | 2026-01-07 10:53:58 | 5 | 2026-03-22 17:35:53.052234 |
| MY25093000149902 | cycling duo aoe男款短上衣-头版-YS8052M | S | 胡美英 | 309271 | 349339 | 2026-01-07 10:53:58 | 7 | 2026-03-22 17:35:52.999014 |
| YK25122200039904 | NORINTT半指手套-YS17033 | L | 何咏凯 | 315111 | 349341 | 2026-01-07 10:55:49 | 1 | 2026-03-22 17:35:52.997494 |
| YK25122200039903 | NORINTT半指手套-YS17033 | M | 何咏凯 | 315111 | 349341 | 2026-01-07 10:55:49 | 2 | 2026-03-22 17:35:52.995965 |
| 3211600389900 | 散袋烟供粉 | F | 洪育钊 | 315188 | 349425 | 2026-01-07 14:41:21 | 250 | 2026-03-22 17:35:52.994412 |
| RX25121300289906 | CUPCKE-26Valhalla-A男款短袖连体衣-头版-YS9229MCKO | 2XL | 袁日仙 | 311240 | 349471 | 2026-01-07 15:56:18 | 1 | 2026-03-22 17:35:52.992716 |
| RX25121300289905 | CUPCKE-26Valhalla-A男款短袖连体衣-头版-YS9229MCKO | XL | 袁日仙 | 311240 | 349471 | 2026-01-07 15:56:18 | 2 | 2026-03-22 17:35:52.991207 |
| RX25121300289904 | CUPCKE-26Valhalla-A男款短袖连体衣-头版-YS9229MCKO | L | 袁日仙 | 311240 | 349471 | 2026-01-07 15:56:18 | 5 | 2026-03-22 17:35:52.989388 |
| RX25121300289903 | CUPCKE-26Valhalla-A男款短袖连体衣-头版-YS9229MCKO | M | 袁日仙 | 311240 | 349471 | 2026-01-07 15:56:18 | 2 | 2026-03-22 17:35:52.987847 |
| RX25121300289902 | CUPCKE-26Valhalla-A男款短袖连体衣-头版-YS9229MCKO | S | 袁日仙 | 311240 | 349471 | 2026-01-07 15:56:18 | 2 | 2026-03-22 17:35:52.986307 |
| ZT25121700179907 | USF 26男款短袖连体衣-头版-YS9212MJFO | 3XL | 曾亭 | 311994 | 349476 | 2026-01-07 15:57:29 | 1 | 2026-03-22 17:35:52.984798 |
| ZT25121700179904 | USF 26男款短袖连体衣-头版-YS9212MJFO | L | 曾亭 | 311994 | 349476 | 2026-01-07 15:57:29 | 3 | 2026-03-22 17:35:52.982911 |
| JB25121700149905 | O4N Solocycling-W男款背带短裤-头版-YS9153MO | XL | 郑杰彬 | 312378 | 349480 | 2026-01-07 15:59:26 | 1 | 2026-03-22 17:35:52.981356 |