到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| ZT25071900229904 | MUMU cargo black new男款背带短裤-YS9153MGD | L | 曾亭 | 317376 | 355952 | 2026-01-26 11:25:21 | 5 | 2026-03-22 17:35:42.671301 |
| ZT25071900229903 | MUMU cargo black new男款背带短裤-YS9153MGD | M | 曾亭 | 317376 | 355952 | 2026-01-26 11:25:21 | 7 | 2026-03-22 17:35:42.669707 |
| RX26011000209904 | BALMORAL-CHAMPIOM 2025男款POLO衫-头版-YS874MK | L | 袁日仙 | 317640 | 355953 | 2026-01-26 11:25:46 | 3 | 2026-03-22 17:35:42.668082 |
| RX26011000209906 | BALMORAL-CHAMPIOM 2025男款POLO衫-头版-YS874MK | 2XL | 袁日仙 | 317640 | 355953 | 2026-01-26 11:25:46 | 1 | 2026-03-22 17:35:42.666406 |
| RX26011000209905 | BALMORAL-CHAMPIOM 2025男款POLO衫-头版-YS874MK | XL | 袁日仙 | 317640 | 355953 | 2026-01-26 11:25:46 | 1 | 2026-03-22 17:35:42.664897 |
| RX26011000209903 | BALMORAL-CHAMPIOM 2025男款POLO衫-头版-YS874MK | M | 袁日仙 | 317640 | 355953 | 2026-01-26 11:25:46 | 1 | 2026-03-22 17:35:42.663339 |
| RX26011000209902 | BALMORAL-CHAMPIOM 2025男款POLO衫-头版-YS874MK | S | 袁日仙 | 317640 | 355953 | 2026-01-26 11:25:46 | 3 | 2026-03-22 17:35:42.661789 |
| RX26011000199905 | BALMORAL-CHAMPION 2025女款POLO衫-头版-YS874WK | XL | 袁日仙 | 317640 | 355953 | 2026-01-26 11:25:46 | 3 | 2026-03-22 17:35:42.660237 |
| RX26011000199904 | BALMORAL-CHAMPION 2025女款POLO衫-头版-YS874WK | L | 袁日仙 | 317640 | 355953 | 2026-01-26 11:25:46 | 2 | 2026-03-22 17:35:42.658648 |
| RX26011000199903 | BALMORAL-CHAMPION 2025女款POLO衫-头版-YS874WK | M | 袁日仙 | 317640 | 355953 | 2026-01-26 11:25:46 | 1 | 2026-03-22 17:35:42.657110 |
| RX26011000199901 | BALMORAL-CHAMPION 2025女款POLO衫-头版-YS874WK | XS | 袁日仙 | 317640 | 355953 | 2026-01-26 11:25:46 | 1 | 2026-03-22 17:35:42.655556 |
| 1231600579900 | 2023-WEDNESDAY(深红)魔术头巾 | F | 黄婉婷 | 316536 | 355954 | 2026-01-26 11:26:14 | 10 | 2026-03-22 17:35:42.654015 |
| ZT26011400139907 | Boston Scientific White男款背带短裤-头版-YS9110MAO | 3XL | 曾亭 | 319589 | 355986 | 2026-01-26 13:30:27 | 2 | 2026-03-22 17:35:42.652318 |
| ZT26011400139906 | Boston Scientific White男款背带短裤-头版-YS9110MAO | 2XL | 曾亭 | 319589 | 355986 | 2026-01-26 13:30:27 | 6 | 2026-03-22 17:35:42.600413 |
| ZT26011400139904 | Boston Scientific White男款背带短裤-头版-YS9110MAO | L | 曾亭 | 319589 | 355986 | 2026-01-26 13:30:27 | 2 | 2026-03-22 17:35:42.598816 |
| BH25111900259904 | LBW 26 CA男款背带短裤-头版-YS2047MPB | L | 凌碧红 | 319588 | 355987 | 2026-01-26 13:31:06 | 3 | 2026-03-22 17:35:42.597261 |
| BH25111900259902 | LBW 26 CA男款背带短裤-头版-YS2047MPB | S | 凌碧红 | 319588 | 355987 | 2026-01-26 13:31:06 | 2 | 2026-03-22 17:35:42.595672 |
| BH25111900239905 | LBW 26 CC男款背带短裤-头版-YS2047MXA | XL | 凌碧红 | 319588 | 355987 | 2026-01-26 13:31:06 | 1 | 2026-03-22 17:35:42.594136 |
| 1261110369909 | 糖渍橙蓝短上衣 | 5XL | 林树 | 316438 | 356026 | 2026-01-26 15:34:00 | 10 | 2026-03-22 17:35:42.590991 |
| 1261110369908 | 糖渍橙蓝短上衣 | 4XL | 林树 | 316438 | 356026 | 2026-01-26 15:34:00 | 10 | 2026-03-22 17:35:42.589370 |