到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| MY25122200059902 | LABEL deep forest green男款背带短裤-头版-YS9163MCO | S | 胡美英 | 313314 | 351200 | 2026-01-12 17:56:19 | 4 | 2026-03-22 17:35:50.471336 |
| MY25122200059901 | LABEL deep forest green男款背带短裤-头版-YS9163MCO | XS | 胡美英 | 313314 | 351200 | 2026-01-12 17:56:19 | 2 | 2026-03-22 17:35:50.469765 |
| MY25122200049905 | LABEL deep forest green女款背带短裤-头版-YS9163WADO | XL | 胡美英 | 313314 | 351200 | 2026-01-12 17:56:19 | 2 | 2026-03-22 17:35:50.468013 |
| MY25122200049904 | LABEL deep forest green女款背带短裤-头版-YS9163WADO | L | 胡美英 | 313314 | 351200 | 2026-01-12 17:56:19 | 2 | 2026-03-22 17:35:50.466410 |
| MY25122200049903 | LABEL deep forest green女款背带短裤-头版-YS9163WADO | M | 胡美英 | 313314 | 351200 | 2026-01-12 17:56:19 | 3 | 2026-03-22 17:35:50.464867 |
| MY25122200049902 | LABEL deep forest green女款背带短裤-头版-YS9163WADO | S | 胡美英 | 313314 | 351200 | 2026-01-12 17:56:19 | 4 | 2026-03-22 17:35:50.463309 |
| MY25122200049901 | LABEL deep forest green女款背带短裤-头版-YS9163WADO | XS | 胡美英 | 313314 | 351200 | 2026-01-12 17:56:19 | 3 | 2026-03-22 17:35:50.461775 |
| MY25122200049911 | LABEL deep forest green女款背带短裤-头版-YS9163WADO | 2XS | 胡美英 | 313314 | 351200 | 2026-01-12 17:56:19 | 1 | 2026-03-22 17:35:50.460214 |
| RX25121300319903 | CUPCKE-26Valkyrie女款短袖连体衣-头版-YS9229WXPO | M | 袁日仙 | 311240 | 351201 | 2026-01-12 17:56:44 | 2 | 2026-03-22 17:35:50.458589 |
| MY25121700109905 | KNCT GTB25男款背带短裤-头版-YS2129MO | XL | 胡美英 | 312288 | 351203 | 2026-01-12 17:57:08 | 1 | 2026-03-22 17:35:50.457007 |
| MY25121700109904 | KNCT GTB25男款背带短裤-头版-YS2129MO | L | 胡美英 | 312288 | 351203 | 2026-01-12 17:57:08 | 6 | 2026-03-22 17:35:50.455367 |
| MY25121700109903 | KNCT GTB25男款背带短裤-头版-YS2129MO | M | 胡美英 | 312288 | 351203 | 2026-01-12 17:57:08 | 5 | 2026-03-22 17:35:50.453525 |
| MY25121700109902 | KNCT GTB25男款背带短裤-头版-YS2129MO | S | 胡美英 | 312288 | 351203 | 2026-01-12 17:57:08 | 3 | 2026-03-22 17:35:50.451281 |
| MJ25101000079904 | RADA 1MBS男款短上衣-头版-YS9640MZFO | L | 庄镘洁 | 312480 | 351204 | 2026-01-12 17:57:30 | 5 | 2026-03-22 17:35:50.398654 |
| MJ25101000079905 | RADA 1MBS男款短上衣-头版-YS9640MZFO | XL | 庄镘洁 | 312480 | 351204 | 2026-03-17 17:20:03 | 4 | 2026-03-22 17:35:50.398545 |
| MJ25101000079903 | RADA 1MBS男款短上衣-头版-YS9640MZFO | M | 庄镘洁 | 312480 | 351204 | 2026-01-12 17:57:30 | 1 | 2026-03-22 17:35:50.396072 |
| MJ25101000079902 | RADA 1MBS男款短上衣-头版-YS9640MZFO | S | 庄镘洁 | 312480 | 351204 | 2026-01-12 17:57:30 | 2 | 2026-03-22 17:35:50.394509 |
| RX25122200129904 | CUPCKE-Foot Traffic女款短上衣-头版-YS9421WCO | L | 袁日仙 | 313678 | 351205 | 2026-01-12 17:58:27 | 1 | 2026-03-22 17:35:50.392897 |
| ZT25123000299903 | Blue70 26 MTB女款长上衣-头版-YS9605WO | M | 曾亭 | 315006 | 351206 | 2026-01-12 17:58:57 | 2 | 2026-03-22 17:35:50.391307 |
| BH25111900169903 | LBW 26 CC Black女款短上衣-头版-YS9470WZGO | M | 凌碧红 | 316410 | 351211 | 2026-01-12 18:01:47 | 1 | 2026-03-22 17:35:50.389729 |