到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| ZT26011700049905 | Wright SRO男款POLO衫-头版-YS9697MLO | XL | 曾亭 | 319938 | 358378 | 2026-02-02 10:56:30 | 42 | 2026-03-22 17:35:38.087353 |
| ZT26011700049904 | Wright SRO男款POLO衫-头版-YS9697MLO | L | 曾亭 | 319938 | 358378 | 2026-02-02 10:56:30 | 81 | 2026-03-22 17:35:38.085645 |
| ZT26011700049903 | Wright SRO男款POLO衫-头版-YS9697MLO | M | 曾亭 | 319938 | 358378 | 2026-02-02 10:56:30 | 18 | 2026-03-22 17:35:38.083732 |
| ZT26011700049902 | Wright SRO男款POLO衫-头版-YS9697MLO | S | 曾亭 | 319938 | 358378 | 2026-02-02 10:56:30 | 12 | 2026-03-22 17:35:38.081853 |
| BH26011400039905 | Vector Aboitiz男款短上衣-头版-YS9699MLK | XL | 凌碧红 | 319568 | 358379 | 2026-02-02 10:56:54 | 1 | 2026-03-22 17:35:38.080077 |
| BH26011400039904 | Vector Aboitiz男款短上衣-头版-YS9699MLK | L | 凌碧红 | 319568 | 358379 | 2026-02-02 10:56:54 | 2 | 2026-03-22 17:35:38.078481 |
| BH26011400039903 | Vector Aboitiz男款短上衣-头版-YS9699MLK | M | 凌碧红 | 319568 | 358379 | 2026-02-02 10:56:54 | 3 | 2026-03-22 17:35:38.076707 |
| BH26011400039902 | Vector Aboitiz男款短上衣-头版-YS9699MLK | S | 凌碧红 | 319568 | 358379 | 2026-02-02 10:56:54 | 3 | 2026-03-22 17:35:38.075085 |
| BH26011400039901 | Vector Aboitiz男款短上衣-头版-YS9699MLK | XS | 凌碧红 | 319568 | 358379 | 2026-02-02 10:56:54 | 4 | 2026-03-22 17:35:38.073424 |
| RX26011700139903 | Urbis 2025女款铁三背心-头版-YS9730WO | M | 袁日仙 | 319267 | 358380 | 2026-02-02 10:57:16 | 1 | 2026-03-22 17:35:38.071716 |
| RX26011700139902 | Urbis 2025女款铁三背心-头版-YS9730WO | S | 袁日仙 | 319267 | 358380 | 2026-02-02 10:57:16 | 2 | 2026-03-22 17:35:38.069814 |
| BH26012100069905 | MTB BRR男款T恤-头版-YS9068MAC | XL | 凌碧红 | 320630 | 358381 | 2026-02-02 10:57:35 | 1 | 2026-03-22 17:35:38.067891 |
| BH26012100069904 | MTB BRR男款T恤-头版-YS9068MAC | L | 凌碧红 | 320630 | 358381 | 2026-02-02 10:57:35 | 2 | 2026-03-22 17:35:38.066072 |
| BH26012100069903 | MTB BRR男款T恤-头版-YS9068MAC | M | 凌碧红 | 320630 | 358381 | 2026-02-02 10:57:35 | 6 | 2026-03-22 17:35:38.064092 |
| BH26012100069902 | MTB BRR男款T恤-头版-YS9068MAC | S | 凌碧红 | 320630 | 358381 | 2026-02-02 10:57:35 | 1 | 2026-03-22 17:35:38.062104 |
| MJ26012100139905 | TCHACO INTERCLUBE男款POLO衫-头版-YS9450MO | XL | 庄镘洁 | 320646 | 358382 | 2026-02-02 10:58:38 | 11 | 2026-03-22 17:35:38.060281 |
| MJ26012100139907 | TCHACO INTERCLUBE男款POLO衫-头版-YS9450MO | 3XL | 庄镘洁 | 320646 | 358382 | 2026-02-02 10:58:38 | 2 | 2026-03-22 17:35:38.058378 |
| MJ26012100139906 | TCHACO INTERCLUBE男款POLO衫-头版-YS9450MO | 2XL | 庄镘洁 | 320646 | 358382 | 2026-02-02 10:58:38 | 5 | 2026-03-22 17:35:38.056488 |
| MJ26012100139902 | TCHACO INTERCLUBE男款POLO衫-头版-YS9450MO | S | 庄镘洁 | 320646 | 358382 | 2026-02-02 10:58:38 | 4 | 2026-03-22 17:35:38.054009 |
| MJ26012100139904 | TCHACO INTERCLUBE男款POLO衫-头版-YS9450MO | L | 庄镘洁 | 320646 | 358382 | 2026-02-02 10:58:38 | 8 | 2026-03-22 17:35:37.998920 |