You can download CSV files from Magento once you’ve made your sales.
To export orders from Magento:
- From the Admin panel, select System > Import/Export > Export.
- Under Export Settings, set Entity Type to Orders.
- In the Entity Attributes list, mark the checkbox of each attribute group you want to exclude from the export.
- Click Continue to generate the CSV file. After Magento Go exports and generates the CSV file, you are asked to download it.
TIP: The Macintosh version of Microsoft Office supports multiple CSV file formats. When saving your CSV file, be sure to save it as a CSV (MS Windows) file type (source: http://www.magentocommerce.com/knowledge-base/entry/how-to-export-orders)
Importing the file to inFlow
Once you have a file from Magento you can import it into inFlow in the following manner:
- Go to Main Menu > General > Import Data.
- Choose Sales Orders as your data type.
- Click Browse and select the file that you’d like to import (the one you made in step one).
- Click Next.
- Choose whether you want to import your orders as open or closed.
- Match the columns within your Magento file to the columns in inFlow. We suggest the following matches:
inFlow Field | Magento Field |
| |
Customer Information | |
Customer | _order_address_firstname _order_address_lastname *These two fields have to be combined. |
Phone | _order_address_telephone |
_order_address_email | |
Fax | _order_address_fax |
Addresses (Billing Address) | |
Billing Address 1 | _order_address_street |
City | _order_address_city |
State/Province | _order_address_region |
Country | _order_address_country |
Zip/Postal Code | _order_address_postcode |
Order Info | |
Order Date | created_at |
Order Number | increment_id |
Order Remarks | shipping_description |
Freight | shipping_amount |
Amount Paid | total_paid |
Location | store_name |
Tax Rate 1 | _order_item_tax_percentage |
Item Info | |
Item Name/Code | _order_item_name |
Item Subtotal | subtotal |
Item Quantity | _order_item_quantity_ordered |
Item Discount | _order_item_discount_amount |
7. Click Next to finish.
