So you use Shopify to sell your products and you’d like to use inFlow to track them for you without having to repeat your work. Well, you’re in luck! There’s an article on the Shopify website here: How do I Export my orders… Once you have the file, you will have to make minor changes to your file.
- remove the # before your order number, CSV format doesn’t properly recognize this
- ensure that your “created at” column includes order dates only (times must be removed) and is formatted the same as your computer’s date format.
Once you’ve made these changes, you’re ready to import. We suggest making the following matches:
inFlow Field | Shopify Field |
| |
Customer Information | |
Customer | Billing Name |
Phone | Billing Phone |
Addresses (Billing Address) | |
Address Line 1 | Billing Address Line 1 |
Address Line 2 | Billing Address Line 2 |
City | Billing City |
State/Province | Billing Province |
Country | Billing Country |
Zip/Postal Code | Billing Zip |
Addresses (Shipping Info) | |
Company Name | Shipping Name |
Address Line 1 | Shipping Address 1 |
Address Line 2 | Shipping Address 2 |
City | Shipping City |
State/Province | Shipping Province |
Country | Shipping Country |
Zip/Postal | Shipping Zip |
Currency Code | Currency |
Order Info | |
Order Date | Created At |
Order Number | Name |
Freight | Shipping |
Amount Paid | Total |
Item Info | |
Item Name/Code | Lineitem name |
Item Quantity | Lineitem quantity |
Unit Price | Lineitem price |
Item Subtotal | Subtotal |
If you have any questions or concerns with your imports please get in touch!