主要將Yahoo拍賣後台的訂單下載後,匯入電商訂單模組的待出貨訂單,進行揀貨、列印及包裝後轉至銷貨單扣庫,過程中進行品號對應的整理(只需對應一次,下次就不用再對應了)
下載Y拍後台已出貨訂單方式
1、Yahoo拍賣登入後,點選【賣家管理-管理訂單】
![](https://1305382038-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-LIKjg8fhBLiNWmBhadT%2F-LIKjtrWZZPP3DsCUGXx%2FA02-001-Y%E6%8B%8D%E5%BE%8C%E5%8F%B0.png?generation=1532594477664836&alt=media)
2、建議先產生寄件編號,接著,按右上方【匯出訂單】
![](https://1305382038-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-M4IA07ZxoYqYFcmWLcP%2F-M4IASYrBwwaX3eJSCa6%2F2020-04-07_094340.png?alt=media&token=79e2799b-f867-4fde-8106-11268d4ef277)
3、選擇要匯出的訂單區間,出貨狀態建議請擇【出貨檔上傳成功,待寄貨(已叫件)】的訂單,設定好後按【確認匯出】
![](https://1305382038-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-M4HEFp6QYzuarQljgvN%2F-M4HLBQQJxUWgCNyruLb%2F2020-04-07_095355.png?alt=media&token=93e6a84b-ee80-4dab-8373-dcf5c0149f0e)
4、確認檔案下載成功,請勿開啟再儲存喔!匯入時直接用下載下來的原檔才可以,因為另存後格式會被改變就無法匯入了
![](https://1305382038-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-M4HEFp6QYzuarQljgvN%2F-M4HMv0L9zb2Lc8-4jon%2F2020-04-07_095542.png?alt=media&token=65156728-2c91-461d-ad8b-0366025b4429)
![](https://1305382038-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-M4HEFp6QYzuarQljgvN%2F-M4HUAQjj_4uSQ-sljC3%2F2020-04-07_103157.png?alt=media&token=caf9ed2d-1668-4565-a1d6-e4ccc92befed)
二、將Y拍的訂單匯入待出貨訂單中
1、開啟待出貨訂單
回到雲端電商訂單模組,點選【電商匯入中心-待出貨訂單】,有3處可開啟
(1)左邊選單【電商匯入中心-待出貨訂單】
(2)流程圖的【電商-待出貨訂單】
(3)流程圖的【電商-Yahoo拍賣】
![](https://1305382038-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-M4HEFp6QYzuarQljgvN%2F-M4HUzDIC90LGvX18iod%2F2020-04-07_103711.png?alt=media&token=cf2eb840-a315-4c87-be23-c5860de47196)
點 (3)流程圖的【電商-Yahoo拍賣】會預設上方查詢條件為【Yahoo拍賣】,所以不用自已選擇,就可以一進入只看到Y拍的訂單
![](https://1305382038-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-M4HEFp6QYzuarQljgvN%2F-M4HmLXwKzz57exaIN17%2F2020-04-07_115621.png?alt=media&token=e09dd36f-737c-4f11-a895-378af22a6be6)
2、開始執行點選【匯入】
![](https://1305382038-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-M3QLP6IEDNgdd7Mlck4%2F-M3QQWv30TBve5mjUNr1%2F2020-03-27_175838.png?alt=media&token=376e4987-2be4-43e5-a0fe-ff75310398ed)
(1)請選擇要匯入的是哪一間商店的資料:選擇要匯入的店舖
(2)選擇檔案:將剛才下載的csv檔選入
(3)項下有選項:檔案的折扣金額為【賣家】或【電商平台】提供
例如買家買100元,折扣20元,實付80元
若 選【賣家】則在Y拍的折扣金額會匯到銷貨單折扣商品 - 20,故銷貨單的總金額會是80元;反之若選【電商平台】提供,則折扣金額不會匯入銷貨單,銷貨單的金額即為100元
(4)、確認後點選【匯入】
![](https://1305382038-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-M4HEFp6QYzuarQljgvN%2F-M4HnNY8iccQDsT3dbGj%2F2020-04-07_120201.png?alt=media&token=d62f52ce-2a70-4303-b36c-a06b9b224e7c)
(5)匯入成功接著按【到待出貨訂單】
![](https://1305382038-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-M4HpvyTmOYKTZRJskRm%2F-M4Hr9lWWmkL65hnwvm3%2F2020-04-07_120242.png?alt=media&token=a32d64c7-d533-4da9-8e7f-f4af1c88d641)
(6)即可看到剛才匯入的Y拍訂單
![](https://1305382038-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-M4HpvyTmOYKTZRJskRm%2F-M4HrIqp6UZD2bK3drh1%2F2020-04-07_121640-Y%E6%8B%8D%E5%BE%85%E5%87%BA%E8%B2%A8%E8%A8%82%E5%96%AE%E5%AE%8C%E6%95%B4%E5%9C%96-%E9%A6%AC%E8%B3%BD%E5%85%8B.png?alt=media&token=f0484450-fb01-4105-a3a0-7752f6b8fe3c)
三、列印揀貨單或補貨建議表
【揀貨單報表】
1、勾選要預計出貨的訂單
2、依您的揀貨習慣,看要在【全部】頁勾選要出貨訂單,或分不同配送去選擇
3、在【全部】頁選取後按【揀貨】
在【全部】頁揀貨,即不分物流方式,例如A商品第1張711訂單有2件和第2張OK訂單1件,裡面都有同樣的A商品需求共有3件,選擇【合併揀貨】即不分配送方式,產生合併後的數量共揀A商品3件
若在【711】、【全家】等物流頁選擇【揀貨】,則就會分出【配送】方式合併數量帶出
![](https://1305382038-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-M4HrOAqSxmKz7UL4YI-%2F-M4HsRSf8JE7m6Aj-UgU%2F2020-04-07_122358.png?alt=media&token=8a68dbf6-57a6-4d1e-a0a3-ad06f61bb270)
在揀貨時若系統有發現未對應的商品,則也會對應畫面,需先對應好才可繼續揀貨
在畫面中請在【公司商品編號】開窗選入在系統內對應的商品
【對應數量】通常填寫"1",但假設若平台商品為"T牌溼紙巾8入" ,則表示賣出一組,就會扣8pcs,故此欄就應輸入"8"
對應好後按【下一步】
![](https://1305382038-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-M4HrOAqSxmKz7UL4YI-%2F-M4HshJiBwF4FdANIgS1%2F2020-04-07_122518.png?alt=media&token=d67585b6-19a8-41d6-ac88-6866a00b8671)
對應完成後按【揀貨單列印】,會產生一個頁籤帶出揀貨單的報表,
![](https://1305382038-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-M4HrOAqSxmKz7UL4YI-%2F-M4HyMxpNNeiXWR9sNP8%2F2020-04-07_124830.png?alt=media&token=192aa0a0-f7cc-4650-9f58-92581377a8de)
您可以列印後到倉庫揀貨,揀好的貨可在【揀貨確認】欄勾選做記號,避免重覆揀貨
![](https://1305382038-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-M4HrOAqSxmKz7UL4YI-%2F-M4HytWcvp7R8L7K66v9%2F2020-04-07_125216.png?alt=media&token=bcc27134-fa64-4cbf-bbf0-6c189c38bbf7)
產生揀貨資料後,回到剛才的待出貨訂單,可按【完成】回到【待出貨訂單】首頁
![](https://1305382038-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-M4HrOAqSxmKz7UL4YI-%2F-M4HzC2uCDx9OH1y5Jkd%2F2020-04-07_125339.png?alt=media&token=c8f9ba64-0b56-4d4c-8ab3-9700f94bbdd0)
【補貨建議報表】
若系統帳上庫存不足,就會出現需補貨的畫面,依訂單需求量帶出建議的補貨數量,可按右上方【補貨建議表】產生報表
![](https://1305382038-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-M4HrOAqSxmKz7UL4YI-%2F-M4HvfD7xGFO9ythfROb%2F2020-04-07_123756.png?alt=media&token=43ccb4f6-ff46-424b-9194-60de53194283)
產生後的補貨建議表
![](https://1305382038-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-M4HrOAqSxmKz7UL4YI-%2F-M4HxV7-4hlqz86SOF4h%2F2020-04-07_123952.png?alt=media&token=4f60246e-e0b1-4206-a8b1-d36aebd421f5)
四、店到店列印裝箱單(訂購單)-目前無提供列印寄件單
建議可先在Y拍先出貨產生【寄件編號】再匯入A1,這樣訂單內容中會有寄件編號的記錄,但目前Y拍功能不提供列印寄件單,只提供列印裝箱單喲!
勾選後按【列印】選擇裝箱單需要的格式,有二種格式1.【裝箱單(A5)】、1.【裝箱單(A4不分頁)】
![](https://1305382038-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-M4HrOAqSxmKz7UL4YI-%2F-M4I-YXbY9EIeCnUrnuf%2F2020-04-07_125910.png?alt=media&token=48e109f6-27cc-4eff-9513-698091778d6e)
【裝箱單(A5)】
![](https://1305382038-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-M4HrOAqSxmKz7UL4YI-%2F-M4I02-gFpiC27OVEujg%2F2020-04-07_130127.png?alt=media&token=92b233eb-6386-4d9b-aefa-23d15cc31a8b)
【裝箱單(A4)不分頁】
![](https://1305382038-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-M4HrOAqSxmKz7UL4YI-%2F-M4I0aSjkNzpcFrEVLnI%2F2020-04-07_130340.png?alt=media&token=35226d5e-08d8-4173-8aa3-f12a0ccebf2c)
五、託運轉出
主要是將【其他】訂單的內容製定宅配物流需要的Excel格式後,轉出格式提供Excel格式給物流出貨,或匯入至物流公司後台的系統再印宅配單等
六、Y拍訂單轉銷貨單
將Y拍訂單產生至進銷存模組銷貨單扣庫,並產生Y拍未收帳款
1、勾選單據
2、按【轉銷貨單】
![](https://1305382038-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-M4HrOAqSxmKz7UL4YI-%2F-M4I1mhHOcCl0HRK8ABk%2F2020-04-07_130917.png?alt=media&token=efa596dc-03b0-47cb-ad64-1b0959bb3eb5)
3、確認要拋轉銷貨單的日期後,按【確認】
![](https://1305382038-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-M4HrOAqSxmKz7UL4YI-%2F-M4I2M27HmA58GuoxrOO%2F2020-04-07_131144.png?alt=media&token=3c50a819-b0ab-408e-b76d-8a9f8ed1a77d)
4、轉銷貨單完成會出現下列畫面,可點選銷貨單號會開啟新的頁籤帶出這張銷貨單
![](https://1305382038-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-M4HrOAqSxmKz7UL4YI-%2F-M4I2fsBXxykw6Fbuhue%2F2020-04-07_131312.png?alt=media&token=651cf754-0b9e-4c12-8311-6d5156f20114)
5、查看銷貨單
(1)【銷貨單】瀏覽畫面中【備註】欄會有電商的資訊,一般未發生退貨等狀況,會利用備註欄,貼入Y拍的訂單號,找到該張銷貨單再做銷退
![](https://1305382038-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-M4HrOAqSxmKz7UL4YI-%2F-M4I55nG6ua9b2onSBYe%2F2020-04-07_132035.png?alt=media&token=9457796a-653a-4155-b2d6-5cc2cb461807)
(2)點開銷貨單後可看詳細銷售內容
【銷貨單】的詳細內容中【聯絡人】可看到賣家資訊,單頭【備註】欄及單身最右方【電商平台】【商店名稱】【交易序號】【訂單單號】都有露天訂單的資料帶出,這樣就完成Y拍出貨囉!
之後在【輕鬆付帳付】收到成交金額,可再做收款單沖帳
![](https://1305382038-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-M4HrOAqSxmKz7UL4YI-%2F-M4I3iJ_8KvEATTCHjOq%2F2020-04-07_131518-%E9%A6%AC%E8%B3%BD%E5%85%8B%E5%BE%8C%E7%9A%84%E9%8A%B7%E8%B2%A8%E5%96%AE.png?alt=media&token=c75fb106-21b6-4323-8dd6-afc735f0cc3b)
6、轉銷貨單時系統若發現商品對應檔無符合資料,則也會出現對應畫面
![](https://1305382038-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-M4HrOAqSxmKz7UL4YI-%2F-M4I7-0VPpye4nAP2z3d%2F2020-04-07_122518.png?alt=media&token=9e42de3f-6ac1-4870-9151-0a2c3a01b4d1)
7、在【待出貨訂單】作業時有轉過銷貨單,則會整行變灰色的,並且不允許再次轉至銷貨單,避免重覆入帳的情況發生
![](https://1305382038-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHpTK_xLF7VhdDL%2F-M4HrOAqSxmKz7UL4YI-%2F-M4I7e6QSHbmPDHM-ad0%2F2020-04-07_133409-%E8%BD%89%E9%81%8E%E9%8A%B7%E8%B2%A8%E5%96%AE%E7%81%B0%E8%89%B2%E7%9A%84-%E5%8A%A0%E6%A1%86%E7%B7%9A.png?alt=media&token=bd881eba-5080-4bcf-a8ee-660cc68890d9)
The End