到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| DQ202305090049906 | HOLO23-Red半指手套-MT018 | 2XL | 吕丹琪 | 318095 | 358643 | 2026-02-02 18:16:44 | 8 | 2026-03-22 17:35:37.070729 |
| DQ202305090049905 | HOLO23-Red半指手套-MT018 | XL | 吕丹琪 | 318095 | 358643 | 2026-02-02 18:16:44 | 10 | 2026-03-22 17:35:37.069239 |
| DQ202305090049904 | HOLO23-Red半指手套-MT018 | L | 吕丹琪 | 318095 | 358643 | 2026-02-02 18:16:44 | 10 | 2026-03-22 17:35:37.067712 |
| DQ202305090049903 | HOLO23-Red半指手套-MT018 | M | 吕丹琪 | 318095 | 358643 | 2026-02-02 18:16:44 | 10 | 2026-03-22 17:35:37.066199 |
| DQ202305090049902 | HOLO23-Red半指手套-MT018 | S | 吕丹琪 | 318095 | 358643 | 2026-02-02 18:16:44 | 5 | 2026-03-22 17:35:37.064636 |
| DQ202305090049901 | HOLO23-Red半指手套-MT018 | XS | 吕丹琪 | 318095 | 358643 | 2026-02-02 18:16:44 | 2 | 2026-03-22 17:35:37.063130 |
| DQ20230420019906 | HOLO-23半指手套-MT018 | 2XL | 吕丹琪 | 318095 | 358643 | 2026-02-02 18:16:44 | 8 | 2026-03-22 17:35:37.061411 |
| DQ20230420019905 | HOLO-23半指手套-MT018 | XL | 吕丹琪 | 318095 | 358643 | 2026-02-02 18:16:44 | 60 | 2026-03-22 17:35:37.059879 |
| DQ20230420019904 | HOLO-23半指手套-MT018 | L | 吕丹琪 | 318095 | 358643 | 2026-02-02 18:16:44 | 80 | 2026-03-22 17:35:37.058323 |
| DQ20230420019903 | HOLO-23半指手套-MT018 | M | 吕丹琪 | 318095 | 358643 | 2026-02-02 18:16:44 | 60 | 2026-03-22 17:35:37.056801 |
| DQ20230420019902 | HOLO-23半指手套-MT018 | S | 吕丹琪 | 318095 | 358643 | 2026-02-02 18:16:44 | 25 | 2026-03-22 17:35:37.055234 |
| DQ20230420019901 | HOLO-23半指手套-MT018 | XS | 吕丹琪 | 318095 | 358643 | 2026-02-02 18:16:44 | 8 | 2026-03-22 17:35:37.052991 |
| RX26010700789903 | SG-X Bella Velo半指手套-MT018 | M | 袁日仙 | 318070 | 358644 | 2026-02-02 18:18:03 | 4 | 2026-03-22 17:35:37.000669 |
| RX26010700789902 | SG-X Bella Velo半指手套-MT018 | S | 袁日仙 | 318070 | 358644 | 2026-02-02 18:18:03 | 14 | 2026-03-22 17:35:36.998978 |
| RX26010700789901 | SG-X Bella Velo半指手套-MT018 | XS | 袁日仙 | 318070 | 358644 | 2026-02-02 18:18:03 | 2 | 2026-03-22 17:35:36.997200 |
| ZT26011000849905 | WSC 25半指手套-YS17049MO | XL | 曾亭 | 318083 | 358645 | 2026-02-02 18:18:27 | 4 | 2026-03-22 17:35:36.995405 |
| ZT26011000849904 | WSC 25半指手套-YS17049MO | L | 曾亭 | 318083 | 358645 | 2026-02-02 18:18:27 | 10 | 2026-03-22 17:35:36.993502 |
| ZT26011000849903 | WSC 25半指手套-YS17049MO | M | 曾亭 | 318083 | 358645 | 2026-02-02 18:18:27 | 6 | 2026-03-22 17:35:36.991500 |
| DQ210310019906 | BONAVELOTT半指手套-YS17033 | 2XL | 吕丹琪 | 318088 | 358646 | 2026-02-02 18:18:51 | 50 | 2026-03-22 17:35:36.989801 |
| DQ210310019905 | BONAVELOTT半指手套-YS17033 | XL | 吕丹琪 | 318088 | 358646 | 2026-02-02 18:18:51 | 70 | 2026-03-22 17:35:36.987993 |