一、從超級商城匯出資料
- 於左側導覽點選「匯出商品資料」
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Fs%2Fb01f5cf0-e954-4ee1-ab29-214818aba43e%2F%25E6%2588%25AA%25E5%259C%2596_2023-07-14_%25E4%25B8%258A%25E5%258D%258812.40.03.png%3Fid%3D53c24a6c-b864-4b03-a3d9-9e7e3dc0c801%26table%3Dblock%26spaceId%3D91ad2990-31e6-4a23-b6d8-ba6233a2cc72%26expirationTimestamp%3D1689674400000%26signature%3DHgNBfeAIDhK4GmXI2asXy3qpfWJ_48jsE963wCrL0fE?table=block&id=53c24a6c-b864-4b03-a3d9-9e7e3dc0c801&cache=v2)
- 根據您的需求,設定篩選條件,並點選「搜尋」。並確認搜尋結果
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Fs%2Fe97d64b9-8ecb-44bd-b6de-0b9181a38514%2F%25E6%2588%25AA%25E5%259C%2596_2023-07-14_%25E4%25B8%258A%25E5%258D%258812.47.04.png%3Fid%3D7192cd2f-56d1-4cde-844e-903807e1317a%26table%3Dblock%26spaceId%3D91ad2990-31e6-4a23-b6d8-ba6233a2cc72%26expirationTimestamp%3D1689674400000%26signature%3D3ghe_bXG3YZOa0KS6Mt3akhD3oCtxGiMRpcK-Zhglhc?table=block&id=7192cd2f-56d1-4cde-844e-903807e1317a&cache=v2)
- 確認「搜尋」結果是否符合預期
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Fs%2F2e850943-7c53-4613-a7c3-ad020ab500eb%2F%25E6%2588%25AA%25E5%259C%2596_2023-07-14_%25E4%25B8%258B%25E5%258D%25883.13.10.png%3Fid%3D7f252296-af0e-42fb-a9aa-035c1cf741a1%26table%3Dblock%26spaceId%3D91ad2990-31e6-4a23-b6d8-ba6233a2cc72%26expirationTimestamp%3D1689674400000%26signature%3DIZrRvyhX2WdSR4oS1ecCEPIDIuTcs_Ej0gXp-AnUqYE?table=block&id=7f252296-af0e-42fb-a9aa-035c1cf741a1&cache=v2)
- 符合預期,並選擇您所需要的下載格式。若您有購買商店,請選擇「下載商品資料(拍賣商店格式)」,若無購買商店,則選擇「下載商品資料(拍賣一般格式)」
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Fs%2F1287d388-3dbf-4778-88af-40beb80d2de6%2F%25E6%2588%25AA%25E5%259C%2596_2023-07-14_%25E4%25B8%258B%25E5%258D%25883.13.10%25E6%258B%25B7%25E8%25B2%259D.png%3Fid%3Db0fa0b34-b92a-43e0-aeb8-cc772c027db0%26table%3Dblock%26spaceId%3D91ad2990-31e6-4a23-b6d8-ba6233a2cc72%26expirationTimestamp%3D1689674400000%26signature%3Doy79ieeuITGqaKFwKcwcSuSX2Zt0NSeR0Km-LCcah9U?table=block&id=b0fa0b34-b92a-43e0-aeb8-cc772c027db0&cache=v2)
- 確認下載的條件及內容,若條件及內容正確,請點選「確認並下載」,即可開始下載
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Fs%2F989bce23-bbc6-4372-b29c-f78b01381c93%2FScreen_Shot_2023-07-17_at_14.39.44.png%3Fid%3D5ad3d6fd-47fc-47e1-a9e7-f9f5b856dac3%26table%3Dblock%26spaceId%3D91ad2990-31e6-4a23-b6d8-ba6233a2cc72%26expirationTimestamp%3D1689674400000%26signature%3DwHikhfrvv6GpM7lQEydpfVdmKJ1Kujj0W2pOnzSqMKU?table=block&id=5ad3d6fd-47fc-47e1-a9e7-f9f5b856dac3&cache=v2)
- 進入下載進度條,當筆數與下載進度一致時,即下載完成。下載中無法做任何的操作。若希望中斷下載,請點選「中斷」按鈕。
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Fs%2Fc9cf9dec-efb1-41d7-83b7-b72ddd9e327e%2FScreen_Shot_2023-07-17_at_14.40.05.png%3Fid%3D4aea61ac-583a-4bed-90e2-a975712a6ecc%26table%3Dblock%26spaceId%3D91ad2990-31e6-4a23-b6d8-ba6233a2cc72%26expirationTimestamp%3D1689674400000%26signature%3DCThCVFt0qHOMatkZtYTASC7KguCeNkTQJX0jTvEbjtY?table=block&id=4aea61ac-583a-4bed-90e2-a975712a6ecc&cache=v2)
- 下載完成,可點選「檢視已下載檔案」將會帶到檔案管理員/Finder 上,以標示出目前的下載檔案為何。
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Fs%2F095169da-cfa8-4d41-a13a-2f7e582a7c4b%2FScreen_Shot_2023-07-17_at_15.01.40.png%3Fid%3D698f84a3-2d12-440a-b3c8-b540a2bcaa5f%26table%3Dblock%26spaceId%3D91ad2990-31e6-4a23-b6d8-ba6233a2cc72%26expirationTimestamp%3D1689674400000%26signature%3DAx3_1a30hznPbmCiaN5W9bZffcUQUxAzkm2QC1d8X1I?table=block&id=698f84a3-2d12-440a-b3c8-b540a2bcaa5f&cache=v2)
二、於Excel 新增/編輯拍賣刊登必填資訊
- 確認「類別」是否有填寫。並設定「所在地區」為台灣的城市名
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Fs%2F04fbd7e0-a63d-45d8-9180-542c5d840a40%2F2023-07-06_13-59-54.jpg%3Fid%3D34c48835-7ff1-4b5b-bc1a-5b2097fb5d97%26table%3Dblock%26spaceId%3D91ad2990-31e6-4a23-b6d8-ba6233a2cc72%26expirationTimestamp%3D1689674400000%26signature%3Dnv1goLr-4Z_KuzxhygDQNdzF3zRGS3mifjNCbA3PGno?table=block&id=34c48835-7ff1-4b5b-bc1a-5b2097fb5d97&cache=v2)
- 「全店運費設定」可於左方連結査看確認。以下方的設定為例,當使用「套用全店運費」時,「收款方式」需要相對應的設定。下方大多為取貨/貨到付款類的,這邊需要一併設定「接受輕鬆付全家取貨付款」+ 「接受輕鬆付7-11取貨付款」+ 「接受輕鬆付萊爾富取貨付款」 + 「接受輕鬆付郵局貨到付款」為 yes。並且因有「宅配貨運」及「大型/超重物品運送」等設定,需要另外設定「接受輕鬆付現金付款」or 「接受輕鬆付信用卡一次付清」為收款方式。
PS: 以下為範例,還是以要您實際能使用的「運費設定」為主唷
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Fs%2Fea782334-96e5-4120-893f-26c4318bef6b%2FScreen_Shot_2023-07-17_at_16.38.27.png%3Fid%3Dc496a4a4-f4d0-4054-809f-cf908a9fb4da%26table%3Dblock%26spaceId%3D91ad2990-31e6-4a23-b6d8-ba6233a2cc72%26expirationTimestamp%3D1689674400000%26signature%3DmCNSHTV2jay-vRtjU_AKW411tmJD-ITfzyNSEBg-An8?table=block&id=c496a4a4-f4d0-4054-809f-cf908a9fb4da&cache=v2)
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Fs%2F43fea11e-bb9c-4849-be8b-35efc940ed82%2FScreen_Shot_2023-07-17_at_16.36.19.png%3Fid%3Dd95a1a9d-d708-4eb0-a913-2c07595dca45%26table%3Dblock%26spaceId%3D91ad2990-31e6-4a23-b6d8-ba6233a2cc72%26expirationTimestamp%3D1689674400000%26signature%3Diw0fSnGqZE98WTLWdqqNuuWGsXaCc8fOFBJ54IMiO0o?table=block&id=d95a1a9d-d708-4eb0-a913-2c07595dca45&cache=v2)
- 若不使用「套用全店運費」,則「收款方式」必須與「運送與運費」相同對應.
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Fs%2Ff9ef93ca-9ebb-463a-b517-15e1a795c5a1%2FScreen_Shot_2023-07-17_at_16.59.01.png%3Fid%3Da47f11c9-af36-405b-bb77-b1f143dfa9b9%26table%3Dblock%26spaceId%3D91ad2990-31e6-4a23-b6d8-ba6233a2cc72%26expirationTimestamp%3D1689674400000%26signature%3Dopz_frjXG3aurS6xYB2dxJAZBbmxOz0ikIV3oFvT9Nk?table=block&id=a47f11c9-af36-405b-bb77-b1f143dfa9b9&cache=v2)
三、下載拍賣「大量刊登助手」工具
- 點擊下方連結下載拍賣「大量刊登助手」:
⬇️ 點我下載
![notion image](https://www.notion.so/image/https%3A%2F%2Ffile.notion.so%2Ff%2Fs%2F9bbba8b4-6614-442f-b801-050f57bbb2e3%2FScreen_Shot_2023-07-17_at_17.03.51.png%3Fid%3D8636c3b8-77ee-4566-a54d-053bcc127d57%26table%3Dblock%26spaceId%3D91ad2990-31e6-4a23-b6d8-ba6233a2cc72%26expirationTimestamp%3D1689674400000%26signature%3D3Hnheve56EFBArTk8rkk40DHwfVsYIvPcrPL5YKAxC8?table=block&id=8636c3b8-77ee-4566-a54d-053bcc127d57&cache=v2)
- 完成後,請登入您的拍賣帳號
四、商品批次匯入拍賣
- 於左側導覽點選「大量新增商品」。
![notion image](https://www.notion.so/image/https%3A%2F%2Fwww.ec-mart.com%2Fimages%2Fmanual%2Fyahooauction%2Fcreate_buynow_1.png%3Fid%3D1c287a3d18d65b6fc745?table=block&id=780b7a8b-79ee-47ac-a02b-0c7bcf0c5487&cache=v2)
- 點擊標題右方選單,點選「直購」切換至新增直購。
![notion image](https://www.notion.so/image/https%3A%2F%2Fwww.ec-mart.com%2Fimages%2Fmanual%2Fyahooauction%2Fcreate_buynow_2.png%3Fid%3D02533e5e9c7fdaca4dcf?table=block&id=1c35c4c0-9194-4cab-994e-453dc09b30c2&cache=v2)
- 選擇 .csv 或 .xlsx 檔案和商品圖資料夾後,點選「匯入」。
![notion image](https://www.notion.so/image/https%3A%2F%2Fwww.ec-mart.com%2Fimages%2Fmanual%2Fyahooauction%2Fcreate_buynow_3.png%3Fid%3D128a0d6223aa18745e5f?table=block&id=49821a2b-4528-4800-ad96-8395861250a3&cache=v2)
- 查看匯入的檔案是否為您欲上傳的商品,如果是,按「上傳」。
![notion image](https://www.notion.so/image/https%3A%2F%2Fwww.ec-mart.com%2Fimages%2Fmanual%2Fyahooauction%2Fcreate_buynow_4.png%3Fid%3D78e03f1713a7a4495fbd?table=block&id=11a0c663-a79a-4291-953d-4b2f56849fb0&cache=v2)
- 如果此次上傳會產生額外費用,會彈出警告訊息,點選「確定」繼續。
- 等待上傳作業完成。(注意:上傳進度全數完成前請勿關閉程式!)
![notion image](https://www.notion.so/image/https%3A%2F%2Fwww.ec-mart.com%2Fimages%2Fmanual%2Fyahooauction%2Fcreate_buynow_6.png%3Fid%3D7e10886d79927bb090d9?table=block&id=b12b93ad-d93f-4ece-b69e-8aa08fa9a2f6&cache=v2)
- 查看上傳結果,如正確無誤,按「完成」結束操作。
![notion image](https://www.notion.so/image/https%3A%2F%2Fwww.ec-mart.com%2Fimages%2Fmanual%2Fyahooauction%2Fcreate_buynow_7.png%3Fid%3D31b6bf6d760fe846ff3f?table=block&id=48459c51-e33f-42cc-8f97-4fa8e35b51b5&cache=v2)