到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| ZT25121300249904 | PACE 25男款防风背心-头版-YS9046MEO | L | 曾亭 | 330223 | 371388 | 2026-03-13 11:15:23 | 1 | 2026-03-22 17:35:23.968336 |
| BH26013100039903 | SG TDF Orange女款短上衣-头版-YS8010W | M | 凌碧红 | 324274 | 371390 | 2026-03-13 11:16:24 | 1 | 2026-03-22 17:35:23.961701 |
| RX25120300159903 | BNE-CC 2021 yellow男款短上衣-二版-YS9040MDK | M | 袁日仙 | 329511 | 371391 | 2026-03-13 11:18:51 | 1 | 2026-03-22 17:35:23.960150 |
| RX26030900019903 | BNE-CC 2021 yellow女款短上衣-二版-YS9040WDK | M | 袁日仙 | 329511 | 371391 | 2026-03-13 11:18:51 | 1 | 2026-03-22 17:35:23.958370 |
| RX26030900019905 | BNE-CC 2021 yellow女款短上衣-二版-YS9040WDK | XL | 袁日仙 | 329511 | 371391 | 2026-03-13 11:18:51 | 1 | 2026-03-22 17:35:23.956437 |
| MN26030700159906 | 904Duval new男款背带短裤-头版-YS9153MZD | 2XL | 林美霓 | 330011 | 371392 | 2026-03-13 11:19:21 | 1 | 2026-03-22 17:35:23.954502 |
| MN26030700159902 | 904Duval new男款背带短裤-头版-YS9153MZD | S | 林美霓 | 330011 | 371392 | 2026-03-13 11:19:21 | 1 | 2026-03-22 17:35:23.952591 |
| MN26030700149901 | 904Duval new女款背带短裤-头版-YS9113WZ | XS | 林美霓 | 330011 | 371392 | 2026-03-13 11:19:21 | 1 | 2026-03-22 17:35:23.899568 |
| JB26022800059904 | O4N IKA男款短上衣-头版-YS9406MO | L | 郑杰彬 | 327601 | 371394 | 2026-03-13 11:19:48 | 9 | 2026-03-22 17:35:23.898020 |
| JB26022800059903 | O4N IKA男款短上衣-头版-YS9406MO | M | 郑杰彬 | 327601 | 371394 | 2026-03-13 11:19:48 | 3 | 2026-03-22 17:35:23.896454 |
| MJ26030400089904 | TCHACO MUXIMA-1男款T恤-头版-YS9681MO | L | 庄镘洁 | 328893 | 371395 | 2026-03-13 11:20:31 | 5 | 2026-03-22 17:35:23.894929 |
| MJ26030400089905 | TCHACO MUXIMA-1男款T恤-头版-YS9681MO | XL | 庄镘洁 | 328893 | 371395 | 2026-03-13 11:20:31 | 5 | 2026-03-22 17:35:23.893370 |
| MJ26030400089903 | TCHACO MUXIMA-1男款T恤-头版-YS9681MO | M | 庄镘洁 | 328893 | 371395 | 2026-03-13 11:20:31 | 5 | 2026-03-22 17:35:23.891838 |
| MJ26030400089902 | TCHACO MUXIMA-1男款T恤-头版-YS9681MO | S | 庄镘洁 | 328893 | 371395 | 2026-03-13 11:20:31 | 5 | 2026-03-22 17:35:23.890180 |
| DQ26020900029906 | RV-WHITE运动文胸 | 2XL | 吕丹琪 | 325027 | 371445 | 2026-03-13 14:30:24 | 31 | 2026-03-22 17:35:23.879270 |
| DQ26020900029905 | RV-WHITE运动文胸 | XL | 吕丹琪 | 325027 | 371445 | 2026-03-13 14:30:24 | 56 | 2026-03-22 17:35:23.877624 |
| 1261220059909 | 逸竞黑色背带短裤 | 5XL | 林树 | 316474 | 371468 | 2026-03-13 15:22:00 | 10 | 2026-03-22 17:35:23.871141 |
| 1261220059908 | 逸竞黑色背带短裤 | 4XL | 林树 | 316474 | 371468 | 2026-03-13 15:22:00 | 10 | 2026-03-22 17:35:23.869563 |
| ZT26030400079903 | BB PaloAlto 26女款背带短裤-头版-YS2025WY | M | 曾亭 | 328864 | 371494 | 2026-03-13 15:40:27 | 1 | 2026-03-22 17:35:23.794297 |
| ZT26030400079902 | BB PaloAlto 26女款背带短裤-头版-YS2025WY | S | 曾亭 | 328864 | 371494 | 2026-03-13 15:40:27 | 5 | 2026-03-22 17:35:23.792766 |