到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| ZT26011000679901 | GetRAD sport女款背带短裤-头版-YS9149WJ | XS | 曾亭 | 318039 | 357868 | 2026-01-31 14:55:43 | 2 | 2026-03-22 17:35:38.753345 |
| ZT26011000679911 | GetRAD sport女款背带短裤-头版-YS9149WJ | 2XS | 曾亭 | 318039 | 357868 | 2026-01-31 14:55:43 | 2 | 2026-03-22 17:35:38.751086 |
| WT26011700049902 | spatz FASTA LH女款背带短裤-头版-YS2078WFO | S | 黄婉婷 | 320040 | 357869 | 2026-01-31 14:57:22 | 5 | 2026-03-22 17:35:38.699611 |
| RX26011000269904 | Pineapples女款背带短裤-头版-YS9196WC | L | 袁日仙 | 318218 | 357875 | 2026-01-31 14:58:59 | 3 | 2026-03-22 17:35:38.698088 |
| RX26011000269903 | Pineapples女款背带短裤-头版-YS9196WC | M | 袁日仙 | 318218 | 357875 | 2026-01-31 14:58:59 | 2 | 2026-03-22 17:35:38.696542 |
| RX26011000269902 | Pineapples女款背带短裤-头版-YS9196WC | S | 袁日仙 | 318218 | 357875 | 2026-01-31 14:58:59 | 1 | 2026-03-22 17:35:38.695012 |
| ZT26012100039905 | Elite Spine white-1男款背带短裤-二版-YS9153MZD | XL | 曾亭 | 320237 | 357876 | 2026-01-31 14:59:22 | 1 | 2026-03-22 17:35:38.693446 |
| ZT26012100039904 | Elite Spine white-1男款背带短裤-二版-YS9153MZD | L | 曾亭 | 320237 | 357876 | 2026-01-31 14:59:22 | 1 | 2026-03-22 17:35:38.691920 |
| ZT26012100059904 | Elite Spine white-1女款背带短裤-头版-YS9113WZ | L | 曾亭 | 320084 | 357877 | 2026-01-31 14:59:48 | 1 | 2026-03-22 17:35:38.690375 |
| ZT26012100059903 | Elite Spine white-1女款背带短裤-头版-YS9113WZ | M | 曾亭 | 320084 | 357877 | 2026-01-31 14:59:48 | 1 | 2026-03-22 17:35:38.688650 |
| ZT26012100059902 | Elite Spine white-1女款背带短裤-头版-YS9113WZ | S | 曾亭 | 320084 | 357877 | 2026-01-31 14:59:48 | 1 | 2026-03-22 17:35:38.686979 |
| BH25111900299903 | LBW 26 Coureur抓绒护臂-头版-YS4053Y | M | 凌碧红 | 319588 | 357878 | 2026-01-31 15:00:06 | 1 | 2026-03-22 17:35:38.685158 |
| 1261600119903 | 拼色印记紫色小布帽 | M | 林树 | 316451 | 357961 | 2026-01-31 17:20:00 | 100 | 2026-03-22 17:35:38.683284 |
| 1261600119902 | 拼色印记紫色小布帽 | S | 林树 | 316451 | 357961 | 2026-01-31 17:20:00 | 100 | 2026-03-22 17:35:38.681050 |
| 1261600089903 | 拼色印记粉蓝小布帽 | M | 林树 | 316451 | 357965 | 2026-01-31 17:26:00 | 100 | 2026-03-22 17:35:38.679480 |
| 1261600089902 | 拼色印记粉蓝小布帽 | S | 林树 | 316451 | 357965 | 2026-01-31 17:26:00 | 100 | 2026-03-22 17:35:38.677936 |
| 1261600099903 | 拼色印记粉紫小布帽 | M | 林树 | 316451 | 357966 | 2026-01-31 17:27:00 | 100 | 2026-03-22 17:35:38.676225 |
| 1261600099902 | 拼色印记粉紫小布帽 | S | 林树 | 316451 | 357966 | 2026-01-31 17:27:00 | 100 | 2026-03-22 17:35:38.674291 |
| DZ251001019904 | W-ROAD SUIT YBT 26男款短袖连体衣 | L | 黄瑞辉 | 316065 | 357974 | 2026-01-31 17:39:58 | 2 | 2026-03-22 17:35:38.672704 |
| DZ251001019903 | W-ROAD SUIT YBT 26男款短袖连体衣 | M | 黄瑞辉 | 316065 | 357974 | 2026-01-31 17:39:58 | 6 | 2026-03-22 17:35:38.671035 |