到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| MY2404020159902 | windsock2 bont white鞋套-MT009 | S | 胡美英 | 308872 | 352677 | 2026-01-16 17:30:53 | 40 | 2026-03-22 17:35:48.175329 |
| MY25052600169904 | Aquasock bont black 防水鞋套 | L | 胡美英 | 308868 | 352681 | 2026-01-16 17:31:50 | 20 | 2026-03-22 17:35:48.173720 |
| MY25052600169903 | Aquasock bont black 防水鞋套 | M | 胡美英 | 308868 | 352681 | 2026-01-16 17:31:50 | 20 | 2026-03-22 17:35:48.172205 |
| MY25052600169902 | Aquasock bont black 防水鞋套 | S | 胡美英 | 308868 | 352681 | 2026-01-16 17:31:50 | 25 | 2026-03-22 17:35:48.170623 |
| MY25052600159904 | Aquasock bont white 防水鞋套 | L | 胡美英 | 308868 | 352681 | 2026-01-16 17:31:50 | 20 | 2026-03-22 17:35:48.169069 |
| MY25052600159903 | Aquasock bont white 防水鞋套 | M | 胡美英 | 308868 | 352681 | 2026-01-16 17:31:50 | 25 | 2026-03-22 17:35:48.167515 |
| MY25052600159902 | Aquasock bont white 防水鞋套 | S | 胡美英 | 308868 | 352681 | 2026-01-16 17:31:50 | 35 | 2026-03-22 17:35:48.165901 |
| JN25120300039903 | Vibrance长指手套 | M | 陈锦娜 | 317422 | 352685 | 2026-01-16 17:34:57 | 1 | 2026-03-22 17:35:48.164302 |
| LF25021200089906 | 25Stelvio-C33鞋套 | 2XL | 罗兰方 | 317417 | 352683 | 2026-02-07 15:54:17 | 23 | 2026-03-22 17:35:48.164194 |
| MY26010300029900 | Pillar black男款针织袜 | F | 胡美英 | 317430 | 352687 | 2026-01-16 17:36:37 | 1 | 2026-03-22 17:35:48.161205 |
| MY26010300019900 | Pillar white男款针织袜 | F | 胡美英 | 317430 | 352687 | 2026-01-16 17:36:37 | 1 | 2026-03-22 17:35:48.159594 |
| ZT26011000369906 | ENVE 26 MTB男款长上衣-头版-YS9605MO | 2XL | 曾亭 | 317329 | 352688 | 2026-01-16 17:40:14 | 1 | 2026-03-22 17:35:48.157986 |
| ZT26011000369904 | ENVE 26 MTB男款长上衣-头版-YS9605MO | L | 曾亭 | 317329 | 352688 | 2026-01-16 17:40:14 | 2 | 2026-03-22 17:35:48.156376 |
| JB26011000029904 | O4N 26 White-2接筒袜-头版-YS9940EAY | L | 郑杰彬 | 317452 | 352693 | 2026-01-16 17:53:46 | 1 | 2026-03-22 17:35:48.154781 |
| JB26011000019904 | O4N 26 White-1接筒袜-头版-YS9940EAL | L | 郑杰彬 | 317452 | 352693 | 2026-01-16 17:53:46 | 1 | 2026-03-22 17:35:48.152905 |
| MJ26011000029904 | RADA-305 2025男款背带短裤-二版-YS2029MDC | L | 庄镘洁 | 317453 | 352695 | 2026-01-16 17:55:27 | 1 | 2026-03-22 17:35:48.102571 |
| MJ25040100249904 | RADA-305 2025男款短上衣-YS9640MZBO | L | 庄镘洁 | 317453 | 352695 | 2026-01-16 17:55:27 | 1 | 2026-03-22 17:35:48.101038 |
| YL26010700059903 | AZ 2in1 Stripe-1男款跑步短裤-头版-YS2211MDCO | M | 甘雅玲 | 317455 | 352704 | 2026-01-16 17:56:56 | 1 | 2026-03-22 17:35:48.099481 |
| MJ26011000019903 | TCHACO SONANGOL Zipper男款POLO衫-头版-YS9450MCO | M | 庄镘洁 | 317456 | 352709 | 2026-01-16 18:01:51 | 1 | 2026-03-22 17:35:48.097971 |
| MJ25053000149904 | TCHACO SONANGOL男款跑步背心-YS9787MXO | L | 庄镘洁 | 317456 | 352709 | 2026-01-16 18:01:51 | 1 | 2026-03-22 17:35:48.096392 |