到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| DZ261000179903 | 均一自由車隊2026女款短袖连体衣 | M | 何佳欣 | 329873 | 374238 | 2026-03-18 15:41:53 | 2 | 2026-03-22 17:35:21.900547 |
| DZ261000179902 | 均一自由車隊2026女款短袖连体衣 | S | 何佳欣 | 329873 | 374238 | 2026-03-18 15:41:53 | 1 | 2026-03-22 17:35:21.898978 |
| RX26030400119900 | LBCC-Gravelle Estrie魔术头巾-二版-YS9946 | F | 袁日仙 | 328611 | 374239 | 2026-03-18 15:42:54 | 15 | 2026-03-22 17:35:21.897406 |
| ZT26030400039905 | BB PaloAlto 26男款抓绒背心-头版-YS9046MEO | XL | 曾亭 | 328849 | 374240 | 2026-03-18 15:43:25 | 3 | 2026-03-22 17:35:21.895872 |
| ZT26030400039904 | BB PaloAlto 26男款抓绒背心-头版-YS9046MEO | L | 曾亭 | 328849 | 374240 | 2026-03-18 15:43:25 | 15 | 2026-03-22 17:35:21.894248 |
| ZT26030400039903 | BB PaloAlto 26男款抓绒背心-头版-YS9046MEO | M | 曾亭 | 328849 | 374240 | 2026-03-18 15:43:25 | 18 | 2026-03-22 17:35:21.892697 |
| ZT26030400039902 | BB PaloAlto 26男款抓绒背心-头版-YS9046MEO | S | 曾亭 | 328849 | 374240 | 2026-03-18 15:43:25 | 12 | 2026-03-22 17:35:21.891123 |
| ZT26030400039901 | BB PaloAlto 26男款抓绒背心-头版-YS9046MEO | XS | 曾亭 | 328849 | 374240 | 2026-03-18 15:43:25 | 7 | 2026-03-22 17:35:21.889569 |
| ZT26030400039911 | BB PaloAlto 26男款抓绒背心-头版-YS9046MEO | 2XS | 曾亭 | 328849 | 374240 | 2026-03-18 15:43:25 | 3 | 2026-03-22 17:35:21.887776 |
| MN26030700079902 | Higher Dose男款防风背心-头版-YS9046MEO | S | 林美霓 | 330439 | 374241 | 2026-03-18 15:44:55 | 1 | 2026-03-22 17:35:21.886227 |
| MN26030700079901 | Higher Dose男款防风背心-头版-YS9046MEO | XS | 林美霓 | 330439 | 374241 | 2026-03-18 15:44:55 | 8 | 2026-03-22 17:35:21.884529 |
| MN26030700079911 | Higher Dose男款防风背心-头版-YS9046MEO | 2XS | 林美霓 | 330439 | 374241 | 2026-03-18 15:44:55 | 2 | 2026-03-22 17:35:21.882980 |
| MN26030700019902 | Higher Dose女款抓绒长上衣-头版-YS9618WT | S | 林美霓 | 330439 | 374241 | 2026-03-18 15:44:55 | 1 | 2026-03-22 17:35:21.881221 |
| ZT26022800219908 | Infinit 26 Yellow LW男款T恤-头版-YS9068MT | 4XL | 曾亭 | 328035 | 374242 | 2026-03-18 15:45:23 | 1 | 2026-03-22 17:35:21.879369 |
| ZT26022800219906 | Infinit 26 Yellow LW男款T恤-头版-YS9068MT | 2XL | 曾亭 | 328035 | 374242 | 2026-03-18 15:45:23 | 1 | 2026-03-22 17:35:21.877849 |
| ZT26022800219905 | Infinit 26 Yellow LW男款T恤-头版-YS9068MT | XL | 曾亭 | 328035 | 374242 | 2026-03-18 15:45:23 | 1 | 2026-03-22 17:35:21.876328 |
| ZT26022800219904 | Infinit 26 Yellow LW男款T恤-头版-YS9068MT | L | 曾亭 | 328035 | 374242 | 2026-03-18 15:45:23 | 5 | 2026-03-22 17:35:21.874774 |
| ZT26022800219903 | Infinit 26 Yellow LW男款T恤-头版-YS9068MT | M | 曾亭 | 328035 | 374242 | 2026-03-18 15:45:23 | 2 | 2026-03-22 17:35:21.873043 |
| MJ26030700169907 | TCHACO PUMANGOL Zipper男款POLO衫-头版-YS9450MCO | 3XL | 庄镘洁 | 330076 | 374243 | 2026-03-18 15:45:56 | 2 | 2026-03-22 17:35:21.871243 |
| MJ26030700169906 | TCHACO PUMANGOL Zipper男款POLO衫-头版-YS9450MCO | 2XL | 庄镘洁 | 330076 | 374243 | 2026-03-18 15:45:56 | 2 | 2026-03-22 17:35:21.869643 |