到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| DZ261000109902 | Brunei 2026男款短袖连体衣 | S | 何佳欣 | 324283 | 360044 | 2026-02-06 16:30:04 | 5 | 2026-03-22 17:35:33.967121 |
| DZ261200239907 | 台中IMC鐵馬聯誼會男款長上衣 | 3XL | 何佳欣 | 320387 | 360045 | 2026-02-06 16:30:36 | 3 | 2026-03-22 17:35:33.964454 |
| DZ261200239906 | 台中IMC鐵馬聯誼會男款長上衣 | 2XL | 何佳欣 | 320387 | 360045 | 2026-02-06 16:30:36 | 10 | 2026-03-22 17:35:33.961830 |
| DZ261200239905 | 台中IMC鐵馬聯誼會男款長上衣 | XL | 何佳欣 | 320387 | 360045 | 2026-02-06 16:30:36 | 10 | 2026-03-22 17:35:33.959111 |
| DZ261200239904 | 台中IMC鐵馬聯誼會男款長上衣 | L | 何佳欣 | 320387 | 360045 | 2026-02-06 16:30:36 | 11 | 2026-03-22 17:35:33.956214 |
| DZ261200239903 | 台中IMC鐵馬聯誼會男款長上衣 | M | 何佳欣 | 320387 | 360045 | 2026-02-06 16:30:36 | 5 | 2026-03-22 17:35:33.899165 |
| DZ261200239901 | 台中IMC鐵馬聯誼會男款長上衣 | XS | 何佳欣 | 320387 | 360045 | 2026-02-06 16:30:36 | 1 | 2026-03-22 17:35:33.897446 |
| DZ261000059903 | 赤道2026男款短袖连体衣 | M | 黄伟懿 | 318414 | 360046 | 2026-02-06 16:31:13 | 2 | 2026-03-22 17:35:33.895855 |
| DZ261000069903 | 赤道2026女款短袖连体衣 | M | 黄伟懿 | 318414 | 360046 | 2026-02-06 16:31:13 | 1 | 2026-03-22 17:35:33.894061 |
| DZ261000069902 | 赤道2026女款短袖连体衣 | S | 黄伟懿 | 318414 | 360046 | 2026-02-06 16:31:13 | 4 | 2026-03-22 17:35:33.892412 |
| DZ261100219902 | 赤道2026女款短上衣 | S | 黄伟懿 | 318414 | 360046 | 2026-02-06 16:31:13 | 2 | 2026-03-22 17:35:33.890863 |
| DZ261100259905 | 顶呱呱2026-竞技女款短上衣 | XL | 黄伟懿 | 318407 | 360047 | 2026-02-06 16:31:50 | 2 | 2026-03-22 17:35:33.889003 |
| DZ261100259903 | 顶呱呱2026-竞技女款短上衣 | M | 黄伟懿 | 318407 | 360047 | 2026-02-06 16:31:50 | 2 | 2026-03-22 17:35:33.887101 |
| DZ261100259902 | 顶呱呱2026-竞技女款短上衣 | S | 黄伟懿 | 318407 | 360047 | 2026-02-06 16:31:50 | 5 | 2026-03-22 17:35:33.885264 |
| RX26011000349905 | 25Stelvio-C35护腿-二版-4204MO | XL | 袁日仙 | 318898 | 360049 | 2026-02-06 16:33:36 | 8 | 2026-03-22 17:35:33.881777 |
| RX26011000349904 | 25Stelvio-C35护腿-二版-4204MO | L | 袁日仙 | 318898 | 360049 | 2026-02-06 16:33:36 | 10 | 2026-03-22 17:35:33.879875 |
| RX26011000349903 | 25Stelvio-C35护腿-二版-4204MO | M | 袁日仙 | 318898 | 360049 | 2026-02-06 16:33:36 | 10 | 2026-03-22 17:35:33.878089 |
| RX26011000349902 | 25Stelvio-C35护腿-二版-4204MO | S | 袁日仙 | 318898 | 360049 | 2026-02-06 16:33:36 | 8 | 2026-03-22 17:35:33.876448 |
| LF26011400059902 | 26Sharjah男款短上衣-头版-YS9406MDJO | S | 罗兰方 | 319643 | 360050 | 2026-02-06 16:34:11 | 10 | 2026-03-22 17:35:33.874881 |
| LF26011400059901 | 26Sharjah男款短上衣-头版-YS9406MDJO | XS | 罗兰方 | 319643 | 360050 | 2026-02-06 16:34:11 | 10 | 2026-03-22 17:35:33.873221 |