到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| ZT25051600339906 | SixGap 25 White sport男款短上衣-YS9409MO | 2XL | 曾亭 | 314037 | 351133 | 2026-01-12 16:00:28 | 1 | 2026-03-22 17:35:50.868451 |
| ZT25062800439904 | SixGap 25 Black男款短上衣-YS9409MEKO | L | 曾亭 | 314037 | 351133 | 2026-01-12 16:00:28 | 2 | 2026-03-22 17:35:50.866516 |
| ZT25062800439903 | SixGap 25 Black男款短上衣-YS9409MEKO | M | 曾亭 | 314037 | 351133 | 2026-01-12 16:00:28 | 1 | 2026-03-22 17:35:50.864553 |
| RX25122200109904 | CUPCKE-Foot Traffic女款背带短裤-头版-YS9113WO | L | 袁日仙 | 313678 | 351138 | 2026-01-12 16:02:06 | 1 | 2026-03-22 17:35:50.862313 |
| ZT25122000239904 | Lemmonaid Yellow Cargo男款背带短裤-头版-YS9153MGB | L | 曾亭 | 313042 | 351139 | 2026-01-12 16:02:40 | 1 | 2026-03-22 17:35:50.860000 |
| ZT25122000239903 | Lemmonaid Yellow Cargo男款背带短裤-头版-YS9153MGB | M | 曾亭 | 313042 | 351139 | 2026-01-12 16:02:40 | 2 | 2026-03-22 17:35:50.857781 |
| ZT25123001189902 | DHL25女款背带短裤-头版-YS9113WZ | S | 曾亭 | 315529 | 351140 | 2026-01-12 16:04:35 | 2 | 2026-03-22 17:35:50.855550 |
| ZT25123001179909 | DHL25男款背带短裤-头版-YS9153MZD | 5XL | 曾亭 | 315529 | 351140 | 2026-01-12 16:04:35 | 1 | 2026-03-22 17:35:50.853298 |
| ZT25123001179907 | DHL25男款背带短裤-头版-YS9153MZD | 3XL | 曾亭 | 315529 | 351140 | 2026-01-12 16:04:35 | 1 | 2026-03-22 17:35:50.799732 |
| ZT25123001179908 | DHL25男款背带短裤-头版-YS9153MZD | 4XL | 曾亭 | 315529 | 351140 | 2026-01-12 16:04:35 | 1 | 2026-03-22 17:35:50.798170 |
| ZT25123001179906 | DHL25男款背带短裤-头版-YS9153MZD | 2XL | 曾亭 | 315529 | 351140 | 2026-01-12 16:04:35 | 1 | 2026-03-22 17:35:50.796200 |
| ZT25123001179905 | DHL25男款背带短裤-头版-YS9153MZD | XL | 曾亭 | 315529 | 351140 | 2026-01-12 16:04:35 | 2 | 2026-03-22 17:35:50.794562 |
| ZT25123001179904 | DHL25男款背带短裤-头版-YS9153MZD | L | 曾亭 | 315529 | 351140 | 2026-01-12 16:04:35 | 2 | 2026-03-22 17:35:50.793018 |
| ZT25123001179903 | DHL25男款背带短裤-头版-YS9153MZD | M | 曾亭 | 315529 | 351140 | 2026-01-12 16:04:35 | 1 | 2026-03-22 17:35:50.791410 |
| MY25121700039904 | VLCT white2男款短上衣-头版-YS8008MZ | L | 胡美英 | 312720 | 351141 | 2026-01-12 16:05:22 | 7 | 2026-03-22 17:35:50.789832 |
| MY25121700039903 | VLCT white2男款短上衣-头版-YS8008MZ | M | 胡美英 | 312720 | 351141 | 2026-01-12 16:05:22 | 15 | 2026-03-22 17:35:50.787939 |
| MY25121700039902 | VLCT white2男款短上衣-头版-YS8008MZ | S | 胡美英 | 312720 | 351141 | 2026-01-12 16:05:22 | 15 | 2026-03-22 17:35:50.785995 |
| MY25121700039901 | VLCT white2男款短上衣-头版-YS8008MZ | XS | 胡美英 | 312720 | 351141 | 2026-01-12 16:05:22 | 6 | 2026-03-22 17:35:50.784425 |
| MY25121700039911 | VLCT white2男款短上衣-头版-YS8008MZ | 2XS | 胡美英 | 312720 | 351141 | 2026-01-12 16:05:22 | 6 | 2026-03-22 17:35:50.782838 |
| MY25121700039912 | VLCT white2男款短上衣-头版-YS8008MZ | 3XS | 胡美英 | 312720 | 351141 | 2026-01-12 16:05:22 | 2 | 2026-03-22 17:35:50.781189 |