> For the complete documentation index, see [llms.txt](https://docs.a1erp.digiwin.com/a1ordermanual/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.a1erp.digiwin.com/a1ordermanual/05.-qi-ta-dian-shang/04excel-hui-ru-xiao-huo-dan.md).

# 07.04 Excel匯入銷貨單

其他電商主要是使用此作業，目的是快速將其他電商的訂單匯入系統銷貨單扣庫入帳

需使用系統提供的標準Excel格式，將訂單內容整理在內匯入資料

### 其他電商-Excel匯入銷貨單 操作說明

1、開啟Excel匯入銷貨單作業

![](https://3741211229-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-LuawqMbM1B3qrDpVzza%2F-Lub0cPUHTziYGhBdnt1%2F2019-11-26_172403.jpg?alt=media\&token=18154bf3-9689-4639-9e38-b3bb7bf63871)

2、【下載格式檔】

![](https://3741211229-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-LJRhjX35yaYRIfkfXwl%2F-LJRia-0SlRQ5HHGBLGK%2F04-026.png?alt=media\&token=72ccca47-8c50-44b7-a064-9e9615152557)

\
3、開啟標準Excel格式檔

![](https://3741211229-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-LJRhjX35yaYRIfkfXwl%2F-LJRihIZIm3ErNDUyyi7%2F04-027.png?alt=media\&token=611c0ea1-26d5-445c-bdea-23947c6e7183)

![](https://3741211229-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-LJRhjX35yaYRIfkfXwl%2F-LJRirbqfpTg71_lnBeb%2F04-029.png?alt=media\&token=18b1ba4d-848c-40d2-bd42-0cdabff24980)

4、整理訂單資料後存檔關閉

![](https://3741211229-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-LJRhjX35yaYRIfkfXwl%2F-LJRiyJTZ_KuKNorAk8p%2F04-028.png?alt=media\&token=e37ee8bc-2be7-48a4-8caa-f3034e0beb72)

\
5、重回【Excel匯入銷貨單】作業，按【下一步】

![](https://3741211229-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-LJRhjX35yaYRIfkfXwl%2F-LJRjDxImOJthiGGoHPR%2F04-030.png?alt=media\&token=8bc794b8-141e-4223-8222-c822cfcf33ce)

6、選擇檔案、選擇店舖，按【 下一步】

![](https://3741211229-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-LJRhjX35yaYRIfkfXwl%2F-LJRjPjH-OgXcIXQAi5d%2F04-031.png?alt=media\&token=68f449d9-b914-4520-a27c-7e5e2e4a8103)

7、瀏覽資料無問題，下一步

![](https://3741211229-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-LJRhjX35yaYRIfkfXwl%2F-LJRjnU3h7lPI2_0NH84%2F04-032.png?alt=media\&token=e6457776-ca6b-4411-b3de-c8ccef289a03)

8、發現【商品編號對應】作業無對應商品時，可在【檢查資料】步驟直接對應

![](https://3741211229-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-LJRhjX35yaYRIfkfXwl%2F-LJRk4b0f0BSGjIn17jB%2F04-033.png?alt=media\&token=827b4029-9cac-4ab9-ab18-0601673495e6)

\
9、對應後按下一步

![](https://3741211229-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-LJRhjX35yaYRIfkfXwl%2F-LJRkDAu84dt1JE5lw4Z%2F04-034.png?alt=media\&token=aaf2a503-dd80-40cd-9890-3dabe56ecf16)

\
10、確認【銷貨客戶】欄是否為等會兒匯入的【銷貨單】要帶入的客戶，確認好後按【轉銷貨單】

![](https://3741211229-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-LJRhjX35yaYRIfkfXwl%2F-LJRkX4MP3c12T0ElSke%2F04-035.png?alt=media\&token=ccec1ae4-a59e-4e2a-9f36-06873ae02d20)

11、即可匯入來在其他電商的銷貨單囉！

![](https://3741211229-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-LJRhjX35yaYRIfkfXwl%2F-LJRknZAYOD3x_Ql8cMy%2F04-037.png?alt=media\&token=f738b15d-9788-4e45-a518-35330599ebbd)