到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| ZT26011700589904 | ALOVE GoldTT半指手套- YS17033O | L | 曾亭 | 323693 | 360350 | 2026-02-07 15:55:15 | 4 | 2026-03-22 17:35:32.992239 |
| ZT26011700619902 | ALOVE black-TT半指手套-YS17033O | S | 曾亭 | 323693 | 360350 | 2026-03-18 18:08:19 | 38 | 2026-03-22 17:35:32.992159 |
| ZT26011700589903 | ALOVE GoldTT半指手套- YS17033O | M | 曾亭 | 323693 | 360350 | 2026-02-07 15:55:15 | 8 | 2026-03-22 17:35:32.989636 |
| ZT26011700599903 | ALOVE greenTT半指手套-YS17033O | M | 曾亭 | 323693 | 360350 | 2026-02-07 15:55:15 | 9 | 2026-03-22 17:35:32.987998 |
| ZT26011700589902 | ALOVE GoldTT半指手套- YS17033O | S | 曾亭 | 323693 | 360350 | 2026-03-18 18:08:19 | 33 | 2026-03-22 17:35:32.987878 |
| ZT26011700599902 | ALOVE greenTT半指手套-YS17033O | S | 曾亭 | 323693 | 360350 | 2026-02-07 15:55:15 | 14 | 2026-03-22 17:35:32.985277 |
| ZT26011700599901 | ALOVE greenTT半指手套-YS17033O | XS | 曾亭 | 323693 | 360350 | 2026-02-07 15:55:15 | 5 | 2026-03-22 17:35:32.983671 |
| DQ26011700139906 | HOLO-LIGHTGRAY半指手套-MT018 | 2XL | 吕丹琪 | 323692 | 360352 | 2026-02-07 15:55:44 | 8 | 2026-03-22 17:35:32.982112 |
| DQ26011700139905 | HOLO-LIGHTGRAY半指手套-MT018 | XL | 吕丹琪 | 323692 | 360352 | 2026-02-07 15:55:44 | 20 | 2026-03-22 17:35:32.980502 |
| DQ26011700139904 | HOLO-LIGHTGRAY半指手套-MT018 | L | 吕丹琪 | 323692 | 360352 | 2026-02-07 15:55:44 | 20 | 2026-03-22 17:35:32.978933 |
| DQ26011700139903 | HOLO-LIGHTGRAY半指手套-MT018 | M | 吕丹琪 | 323692 | 360352 | 2026-02-07 15:55:44 | 20 | 2026-03-22 17:35:32.977060 |
| DQ26011700139902 | HOLO-LIGHTGRAY半指手套-MT018 | S | 吕丹琪 | 323692 | 360352 | 2026-02-07 15:55:44 | 5 | 2026-03-22 17:35:32.975449 |
| DQ26011700139901 | HOLO-LIGHTGRAY半指手套-MT018 | XS | 吕丹琪 | 323692 | 360352 | 2026-02-07 15:55:44 | 2 | 2026-03-22 17:35:32.973801 |
| RX26012100119905 | LBCC-26 PRO RC Green女款背带短裤-头版-YS9115WEPO | XL | 袁日仙 | 320629 | 360358 | 2026-02-07 15:58:33 | 4 | 2026-03-22 17:35:32.972206 |
| RX26012100119904 | LBCC-26 PRO RC Green女款背带短裤-头版-YS9115WEPO | L | 袁日仙 | 320629 | 360358 | 2026-02-07 15:58:33 | 16 | 2026-03-22 17:35:32.970567 |
| RX26012100119903 | LBCC-26 PRO RC Green女款背带短裤-头版-YS9115WEPO | M | 袁日仙 | 320629 | 360358 | 2026-02-07 15:58:33 | 29 | 2026-03-22 17:35:32.968913 |
| RX26012100119902 | LBCC-26 PRO RC Green女款背带短裤-头版-YS9115WEPO | S | 袁日仙 | 320629 | 360358 | 2026-02-07 15:58:33 | 30 | 2026-03-22 17:35:32.967105 |
| RX26012100119901 | LBCC-26 PRO RC Green女款背带短裤-头版-YS9115WEPO | XS | 袁日仙 | 320629 | 360358 | 2026-02-07 15:58:33 | 15 | 2026-03-22 17:35:32.965229 |
| RX26012100119911 | LBCC-26 PRO RC Green女款背带短裤-头版-YS9115WEPO | 2XS | 袁日仙 | 320629 | 360358 | 2026-02-07 15:58:33 | 1 | 2026-03-22 17:35:32.963564 |
| ZT26013100319907 | Brive riders童装T恤-头版-YS8034MDO | 3XL | 曾亭 | 324279 | 360381 | 2026-02-07 16:26:34 | 2 | 2026-03-22 17:35:32.961895 |