到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| MJ25041600059907 | TCHACO FEERIE男款跑步短裤-YS2063MU | 3XL | 庄镘洁 | 314721 | 352048 | 2026-01-15 10:41:44 | 1 | 2026-03-22 17:35:49.088968 |
| MJ25041600059906 | TCHACO FEERIE男款跑步短裤-YS2063MU | 2XL | 庄镘洁 | 314721 | 352048 | 2026-01-15 10:41:44 | 3 | 2026-03-22 17:35:49.087257 |
| MJ25041600059904 | TCHACO FEERIE男款跑步短裤-YS2063MU | L | 庄镘洁 | 314721 | 352048 | 2026-01-15 10:41:44 | 2 | 2026-03-22 17:35:49.085586 |
| MJ25041600059905 | TCHACO FEERIE男款跑步短裤-YS2063MU | XL | 庄镘洁 | 314721 | 352048 | 2026-01-15 10:41:44 | 1 | 2026-03-22 17:35:49.083855 |
| MJ25041600059911 | TCHACO FEERIE男款跑步短裤-YS2063MU | 2XS | 庄镘洁 | 314721 | 352048 | 2026-01-15 10:41:44 | 1 | 2026-03-22 17:35:49.081986 |
| MJ25041600059912 | TCHACO FEERIE男款跑步短裤-YS2063MU | 3XS | 庄镘洁 | 314721 | 352048 | 2026-01-15 10:41:44 | 1 | 2026-03-22 17:35:49.080257 |
| MJ25041600059918 | TCHACO FEERIE男款跑步短裤-YS2063MU | 4XS | 庄镘洁 | 314721 | 352048 | 2026-01-15 10:41:44 | 1 | 2026-03-22 17:35:49.078574 |
| ZT25122000219904 | Lemmonaid Yellow女款短上衣-头版-YS9409WKO | L | 曾亭 | 313042 | 352049 | 2026-01-15 10:42:52 | 1 | 2026-03-22 17:35:49.076928 |
| ZT25122000219901 | Lemmonaid Yellow女款短上衣-头版-YS9409WKO | XS | 曾亭 | 313042 | 352049 | 2026-01-15 10:42:52 | 1 | 2026-03-22 17:35:49.075219 |
| BH25123000039904 | MTB ICI男款短上衣-头版-YS9409MCD | L | 凌碧红 | 315449 | 352050 | 2026-01-15 10:43:27 | 1 | 2026-03-22 17:35:49.073580 |
| BH25123000039903 | MTB ICI男款短上衣-头版-YS9409MCD | M | 凌碧红 | 315449 | 352050 | 2026-01-15 10:43:27 | 6 | 2026-03-22 17:35:49.072020 |
| BH25123000039902 | MTB ICI男款短上衣-头版-YS9409MCD | S | 凌碧红 | 315449 | 352050 | 2026-01-15 10:43:27 | 1 | 2026-03-22 17:35:49.070422 |
| BH25123000039901 | MTB ICI男款短上衣-头版-YS9409MCD | XS | 凌碧红 | 315449 | 352050 | 2026-01-15 10:43:27 | 1 | 2026-03-22 17:35:49.068899 |
| BH25123000039911 | MTB ICI男款短上衣-头版-YS9409MCD | 2XS | 凌碧红 | 315449 | 352050 | 2026-01-15 10:43:27 | 1 | 2026-03-22 17:35:49.067345 |
| BH25122200049905 | BK SP5-B男款跑步短裤-二版-YS2063MX | XL | 凌碧红 | 313364 | 352051 | 2026-01-15 10:44:13 | 2 | 2026-03-22 17:35:49.065820 |
| BH25122200049904 | BK SP5-B男款跑步短裤-二版-YS2063MX | L | 凌碧红 | 313364 | 352051 | 2026-01-15 10:44:13 | 2 | 2026-03-22 17:35:49.064294 |
| BH25122200049903 | BK SP5-B男款跑步短裤-二版-YS2063MX | M | 凌碧红 | 313364 | 352051 | 2026-01-15 10:44:13 | 10 | 2026-03-22 17:35:49.062731 |
| BH25122200049902 | BK SP5-B男款跑步短裤-二版-YS2063MX | S | 凌碧红 | 313364 | 352051 | 2026-01-15 10:44:13 | 1 | 2026-03-22 17:35:49.061199 |
| RX25122200069903 | CUPCKE-Foot Traffic-A女款短袖连体衣-头版-YS9229WXZO | M | 袁日仙 | 313678 | 352053 | 2026-01-15 10:45:09 | 1 | 2026-03-22 17:35:49.059550 |
| RX25122200069902 | CUPCKE-Foot Traffic-A女款短袖连体衣-头版-YS9229WXZO | S | 袁日仙 | 313678 | 352053 | 2026-01-15 10:45:09 | 1 | 2026-03-22 17:35:49.057850 |