到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| JB26010700119912 | Sara 瑜伽文胸-二版-YS9333WO | 3XS | 郑杰彬 | 316270 | 357229 | 2026-01-29 16:34:58 | 1 | 2026-03-22 17:35:40.179888 |
| ZT26012100249904 | LA MOZ Black男款短上衣-头版-YS9640MCAO | L | 曾亭 | 319716 | 357231 | 2026-01-29 16:35:50 | 3 | 2026-03-22 17:35:40.178344 |
| ZT26012100249903 | LA MOZ Black男款短上衣-头版-YS9640MCAO | M | 曾亭 | 319716 | 357231 | 2026-01-29 16:35:50 | 4 | 2026-03-22 17:35:40.176811 |
| ZT26012100249902 | LA MOZ Black男款短上衣-头版-YS9640MCAO | S | 曾亭 | 319716 | 357231 | 2026-01-29 16:35:50 | 1 | 2026-03-22 17:35:40.175271 |
| ZT26012100249901 | LA MOZ Black男款短上衣-头版-YS9640MCAO | XS | 曾亭 | 319716 | 357231 | 2026-01-29 16:35:50 | 1 | 2026-03-22 17:35:40.173575 |
| ZT26011700419901 | BH 26 white Speed女款短上衣-头版-YS9842WDO | XS | 曾亭 | 320070 | 357232 | 2026-01-29 16:36:17 | 1 | 2026-03-22 17:35:40.172075 |
| YY26011400029900 | NUR-Black小布帽-头版-YS9917X | F | 刘莹滢 | 319296 | 357233 | 2026-01-29 16:36:45 | 50 | 2026-03-22 17:35:40.170490 |
| ZT26010700139905 | BH 26 white男款背带短裤-头版-YS9153MZD | XL | 曾亭 | 319638 | 357234 | 2026-01-29 16:37:19 | 6 | 2026-03-22 17:35:40.168969 |
| ZT26010700139904 | BH 26 white男款背带短裤-头版-YS9153MZD | L | 曾亭 | 319638 | 357234 | 2026-01-29 16:37:19 | 32 | 2026-03-22 17:35:40.167432 |
| ZT26010700139902 | BH 26 white男款背带短裤-头版-YS9153MZD | S | 曾亭 | 319638 | 357234 | 2026-01-29 16:37:19 | 12 | 2026-03-22 17:35:40.165786 |
| ZT26010700139901 | BH 26 white男款背带短裤-头版-YS9153MZD | XS | 曾亭 | 319638 | 357234 | 2026-01-29 16:37:19 | 1 | 2026-03-22 17:35:40.162664 |
| ZT26010700139911 | BH 26 white男款背带短裤-头版-YS9153MZD | 2XS | 曾亭 | 319638 | 357234 | 2026-01-29 16:37:19 | 1 | 2026-03-22 17:35:40.161171 |
| RX26010700249906 | raw-26Liquid-A男款短上衣-头版-YS9640MYGO | 2XL | 袁日仙 | 316014 | 357236 | 2026-01-29 16:37:57 | 6 | 2026-03-22 17:35:40.159638 |
| RX26010700249905 | raw-26Liquid-A男款短上衣-头版-YS9640MYGO | XL | 袁日仙 | 316014 | 357236 | 2026-01-29 16:37:57 | 16 | 2026-03-22 17:35:40.158101 |
| RX26010700249904 | raw-26Liquid-A男款短上衣-头版-YS9640MYGO | L | 袁日仙 | 316014 | 357236 | 2026-01-29 16:37:57 | 20 | 2026-03-22 17:35:40.156435 |
| RX26010700249903 | raw-26Liquid-A男款短上衣-头版-YS9640MYGO | M | 袁日仙 | 316014 | 357236 | 2026-01-29 16:37:57 | 14 | 2026-03-22 17:35:40.154853 |
| RX26010700249902 | raw-26Liquid-A男款短上衣-头版-YS9640MYGO | S | 袁日仙 | 316014 | 357236 | 2026-01-29 16:37:57 | 12 | 2026-03-22 17:35:40.153250 |
| MJ26012100119906 | TCHACO MUXIMA男款T恤-头版-YS9681MO | 2XL | 庄镘洁 | 320646 | 357238 | 2026-01-29 16:38:21 | 3 | 2026-03-22 17:35:40.151078 |
| MJ26012100119905 | TCHACO MUXIMA男款T恤-头版-YS9681MO | XL | 庄镘洁 | 320646 | 357238 | 2026-01-29 16:38:21 | 8 | 2026-03-22 17:35:40.098601 |
| MJ26012100119904 | TCHACO MUXIMA男款T恤-头版-YS9681MO | L | 庄镘洁 | 320646 | 357238 | 2026-01-29 16:38:21 | 9 | 2026-03-22 17:35:40.097075 |