Use AccountEdge, Shopify, & EasyCSV Together
How to get Shopify Orders into AccountEdge.
Quick Links:
- Set up your data flow from Shopify to AccountEdge
- When will AccountEdge have an automated way to import Shopify Orders?
- What are the field names that AccountEdge look for when automatching? or what fields can AccountEdge set from their CSV import function?
- Having trouble importing into AccountEdge? Watch this video from AccountEdge
Follow along: Shopify to AccountEdge quick setup video
Set up your import flow from Shopify to AccountEdge
- Log into EasyCSV
- Install the EasyCSV Shopify App in your Shopify Admin. You can choose the free plan for testing or the Project Plan. We offer easy refunds if EasyCSV is not the solution for you. Just ping our support team via chat or email and we get back to everyone.
- Create a new sheet import page on EasyCSV.io by choosing your source as: Shopify Orders.
- Choose to send data to AccountEdge.
- AccountEdge currently has NO automated way to get Shopify Orders into AccountEdge. So EasyCSV can email you a CSV file for simple AccountEdge import every time a new Shopify Order is made. You could also choose to push CSV files to Google Drive, Dropbox, FTP, S3, or others instead of emailing it to yourself.
- At the bottom of the import flow, put in the email address you want the Shopify Order CSVs to be sent to.
- At the top of your import flow, turn on your automated fetcher to look for new Shopify Orders every 10-20 min and save.
- Now, every 10-20 min, EasyCSV will check for new Shopify Orders. Then make a CSV file so you can import it quickly into Account Edge and email the file to you. Or put it on your cloud drive of choice.
- Download each CSV file to your own computer.
- Open AccountEdge
- If the Customer for the order is NOT in AccountEdge yet you may want to import the CSV first to create the customer record. Open AccountEdge and in the upper-left select: File > Import Data > Cards > Customers
- When the “Import File” screen appears, make sure the “Import File Format” is set as displayed in the video above.
- Press “Continue”
- Select the CSV file you want to import from your computer.
- Select “Automatch”, then match any other fields you want from the CSV file to the AccountEdge fields, and then Press “Import.”
- Check the log if the records are skipped.
- Once the customer is in the AccountEdge database you can import the CSV file as an order.
- Open AccountEdge and select: File > Import Data > Transactions > Sales > Item Sales
- When the “Import File” screen appears, make sure the “Import File Format” is set as displayed in the video above.
- Press “Continue”
- Select CSV file from your computer and press “Open.”
- Select “Automatch”, then match any other fields you want from the CSV file to the AccountEdge fields, and then Press “Import.”
- Check the log if the records are skipped.
When will AccountEdge have an automated way to import Shopify Orders?
We don't know and are just trying to help highlight a solution that can help people in the short term. We have asked AccountEdge for a way we can send Shopify Order CSVs some place where they can automatically import them but they are not looking for partners at this time. This question would be best asked to AccountEdge support.
What are the field names that AccountEdge look for when automatching? or what fields can AccountEdge set from their CSV import function?
You can see the list of fields in the Account Edge Help Center for CSV Imports by clicking: Sales-Item >
Having trouble importing into AccountEdge? Watch this video from AccountEdge
The video makes some recommendations that don't make sense for importing from Shopify. Here are some good viewpoints:
- CSV files are ok for import.
- You will NOT want to choose to UNIQUE by Record ID as that value is the record if in AccountEdge. This value does not exist from Shopify.