到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| RX26012100129901 | LBCC-26 PRO RC Pewter男款背带短裤-头版-YS9134MKEO | XS | 袁日仙 | 320629 | 360225 | 2026-02-07 10:36:53 | 18 | 2026-03-22 17:35:33.475618 |
| RX26012100129911 | LBCC-26 PRO RC Pewter男款背带短裤-头版-YS9134MKEO | 2XS | 袁日仙 | 320629 | 360225 | 2026-02-07 10:36:53 | 2 | 2026-03-22 17:35:33.473882 |
| ZT25061400169904 | Elite 85男款短上衣-YS9842MEO | L | 曾亭 | 320237 | 360227 | 2026-02-07 10:37:46 | 1 | 2026-03-22 17:35:33.472275 |
| ZT25061400169903 | Elite 85男款短上衣-YS9842MEO | M | 曾亭 | 320237 | 360227 | 2026-02-07 10:37:46 | 1 | 2026-03-22 17:35:33.470719 |
| ZT26012100319902 | LA MOZ Black女款三铁连体衣-头版-YS9252WAO | S | 曾亭 | 320633 | 360228 | 2026-02-07 10:38:10 | 4 | 2026-03-22 17:35:33.469186 |
| RX2412200079905 | LBCC-25AIR-grey男款背带短裤-YS2151MO | XL | 袁日仙 | 307288 | 360229 | 2026-02-07 10:39:17 | 3 | 2026-03-22 17:35:33.467324 |
| RX2412200079904 | LBCC-25AIR-grey男款背带短裤-YS2151MO | L | 袁日仙 | 307288 | 360229 | 2026-02-07 10:39:17 | 17 | 2026-03-22 17:35:33.465665 |
| RX2412200079903 | LBCC-25AIR-grey男款背带短裤-YS2151MO | M | 袁日仙 | 307288 | 360229 | 2026-02-07 10:39:17 | 20 | 2026-03-22 17:35:33.464151 |
| RX2412200079902 | LBCC-25AIR-grey男款背带短裤-YS2151MO | S | 袁日仙 | 307288 | 360229 | 2026-02-07 10:39:17 | 16 | 2026-03-22 17:35:33.462412 |
| RX2412200079901 | LBCC-25AIR-grey男款背带短裤-YS2151MO | XS | 袁日仙 | 307288 | 360229 | 2026-02-07 10:39:17 | 7 | 2026-03-22 17:35:33.460855 |
| RX2412200079911 | LBCC-25AIR-grey男款背带短裤-YS2151MO | 2XS | 袁日仙 | 307288 | 360229 | 2026-02-07 10:39:17 | 1 | 2026-03-22 17:35:33.459318 |
| BH26011700039907 | MTB 26 Indigo Topo男款短衬衫-头版-YS9724MX | 3XL | 凌碧红 | 319595 | 360231 | 2026-02-07 10:39:46 | 5 | 2026-03-22 17:35:33.457615 |
| BH26011700039906 | MTB 26 Indigo Topo男款短衬衫-头版-YS9724MX | 2XL | 凌碧红 | 319595 | 360231 | 2026-02-07 10:39:46 | 10 | 2026-03-22 17:35:33.456044 |
| BH26011700039905 | MTB 26 Indigo Topo男款短衬衫-头版-YS9724MX | XL | 凌碧红 | 319595 | 360231 | 2026-02-07 10:39:46 | 30 | 2026-03-22 17:35:33.454412 |
| BH26011700039904 | MTB 26 Indigo Topo男款短衬衫-头版-YS9724MX | L | 凌碧红 | 319595 | 360231 | 2026-02-07 10:39:46 | 40 | 2026-03-22 17:35:33.452586 |
| BH26011700039903 | MTB 26 Indigo Topo男款短衬衫-头版-YS9724MX | M | 凌碧红 | 319595 | 360231 | 2026-02-07 10:39:46 | 25 | 2026-03-22 17:35:33.399535 |
| BH26011700039902 | MTB 26 Indigo Topo男款短衬衫-头版-YS9724MX | S | 凌碧红 | 319595 | 360231 | 2026-02-07 10:39:46 | 4 | 2026-03-22 17:35:33.397997 |
| BH26011700039901 | MTB 26 Indigo Topo男款短衬衫-头版-YS9724MX | XS | 凌碧红 | 319595 | 360231 | 2026-02-07 10:39:46 | 2 | 2026-03-22 17:35:33.396430 |
| RX26012100099905 | LBCC-26 PRO RC black女款背带短裤-二版-YS9115WEPO | XL | 袁日仙 | 319718 | 360232 | 2026-02-07 10:40:20 | 9 | 2026-03-22 17:35:33.394905 |
| RX26012100099904 | LBCC-26 PRO RC black女款背带短裤-二版-YS9115WEPO | L | 袁日仙 | 319718 | 360232 | 2026-02-07 10:40:20 | 23 | 2026-03-22 17:35:33.393357 |