到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| MJ26030700179902 | TCHACO PUMANGOL男款POLO衫-头版-YS9450MO | S | 庄镘洁 | 330076 | 374413 | 2026-03-18 17:30:15 | 4 | 2026-03-22 17:35:21.670990 |
| RX26030700049900 | 23Stelvio-D7魔术头巾-二版-YS9946 | F | 袁日仙 | 330159 | 374414 | 2026-03-18 17:30:46 | 35 | 2026-03-22 17:35:21.667873 |
| RX26031100039900 | Mauro小背包-三版-YS9939 | F | 袁日仙 | 332556 | 374419 | 2026-03-18 17:33:20 | 1 | 2026-03-22 17:35:21.661815 |
| MY26031100039905 | ENSO black女款压缩跑步短裤-头版-YS2256W | XL | 胡美英 | 332560 | 374422 | 2026-03-18 17:37:28 | 1 | 2026-03-22 17:35:21.660219 |
| ZT25120600159907 | Hewitt男款T恤-头版-YS9068MT | 3XL | 曾亭 | 332561 | 374423 | 2026-03-18 17:38:49 | 1 | 2026-03-22 17:35:21.658607 |
| MJ26030400019902 | CycloWatt男款背带短裤-头版-YS9163MCO | S | 庄镘洁 | 332562 | 374425 | 2026-03-18 17:40:23 | 2 | 2026-03-22 17:35:21.656930 |
| JB26030700049905 | FIND YOURS-1男款跑步背心-头版-YS8127MO | XL | 郑杰彬 | 332564 | 374429 | 2026-03-18 17:41:21 | 1 | 2026-03-22 17:35:21.655252 |
| JB26030700039903 | FIND YOURS-2男款跑步背心-头版-YS8127MO | M | 郑杰彬 | 332564 | 374429 | 2026-03-18 17:41:21 | 1 | 2026-03-22 17:35:21.653585 |
| ZT26030700189903 | Conifer 26TT半指手套-YS17033O | M | 曾亭 | 332548 | 374438 | 2026-03-18 17:52:57 | 5 | 2026-03-22 17:35:21.651441 |
| ZT26030700189902 | Conifer 26TT半指手套-YS17033O | S | 曾亭 | 332548 | 374438 | 2026-03-18 17:52:57 | 11 | 2026-03-22 17:35:21.598797 |
| ZT26030700189911 | Conifer 26TT半指手套-YS17033O | 2XS | 曾亭 | 332548 | 374438 | 2026-03-18 17:52:57 | 2 | 2026-03-22 17:35:21.597127 |
| ZT26030700189901 | Conifer 26TT半指手套-YS17033O | XS | 曾亭 | 332548 | 374438 | 2026-03-18 17:52:57 | 2 | 2026-03-22 17:35:21.595563 |
| ZT26030400339902 | Higher Dose半指手套-YS17033O | S | 曾亭 | 328672 | 374439 | 2026-03-18 17:53:30 | 10 | 2026-03-22 17:35:21.594003 |
| ZT26030400339901 | Higher Dose半指手套-YS17033O | XS | 曾亭 | 328672 | 374439 | 2026-03-18 17:53:30 | 19 | 2026-03-22 17:35:21.592289 |
| MJ26030400109904 | RADA Lawrence 2026半指手套-MT018O | L | 庄镘洁 | 328671 | 374440 | 2026-03-18 17:53:55 | 16 | 2026-03-22 17:35:21.590648 |
| MJ26030400109903 | RADA Lawrence 2026半指手套-MT018O | M | 庄镘洁 | 328671 | 374440 | 2026-03-18 17:53:55 | 16 | 2026-03-22 17:35:21.589079 |
| MJ26030400109901 | RADA Lawrence 2026半指手套-MT018O | XS | 庄镘洁 | 328671 | 374440 | 2026-03-18 17:53:55 | 4 | 2026-03-22 17:35:21.587285 |
| YY26030400279905 | BLACKMILE-26 LETAPE半指手套-MT018 | XL | 刘莹滢 | 328670 | 374446 | 2026-03-18 17:54:32 | 5 | 2026-03-22 17:35:21.585506 |
| YY26030400279904 | BLACKMILE-26 LETAPE半指手套-MT018 | L | 刘莹滢 | 328670 | 374446 | 2026-03-18 17:54:32 | 13 | 2026-03-22 17:35:21.583714 |
| YY26030400279903 | BLACKMILE-26 LETAPE半指手套-MT018 | M | 刘莹滢 | 328670 | 374446 | 2026-03-18 17:54:32 | 12 | 2026-03-22 17:35:21.581917 |