Learn how to import data into Ordway using the Import Wizard or Traditional Import Tool, and compare the features and objects supported by each method.
Contents
- Import Data in Ordway
- Choose an Import Method
- Import Method Comparison
- Import and Export Support by Object
- Next Steps
Import Data in Ordway
Ordway provides two tools for importing data in bulk:
- Import Wizard — a guided import experience that helps you prepare, map, review, and import data.
- Traditional Import Tool — a simpler file-based import process for supported objects.
Choose the import method that best fits your data, workflow, and level of guidance required.
Choose an Import Method
Import Wizard
Use the Import Wizard when you want a guided experience for importing supported Ordway objects.
The Import Wizard provides features such as:
- Guided import steps
- Field mapping
- Saved field mappings
- Data review before import
- Error identification and resolution
- Import history
- Import results in the Ordway UI
- Support for multi-sheet import files for applicable objects
You can access the Import Wizard by navigating to:
Menu > Operations > Import Data
The Import Wizard supports imports of up to 25,000 records per import.
For detailed information about the Import Wizard and its workflow, see Import Wizard Overview.
Traditional Import Tool
Use the Traditional Import Tool when you need a straightforward, file-based import process for a supported object.
The Traditional Import Tool lets you upload an import file and download the import results.
To access the Traditional Import Tool, navigate to the object you want to import and select:
More > Imports
For example: Menu > Invoices > More > Imports
The Traditional Import Tool requires you to format the import file before uploading it.
Import Method Comparison
The following table provides a high-level comparison of the two import methods.
| Feature | Traditional Import Tool | Import Wizard |
|---|---|---|
| Guided import experience | No | Yes |
| Field mapping | No | Yes |
| Remove fields from mapping | No | Yes |
| Save custom field mappings | No | Yes |
| Review and modify data before import | No | Yes |
| Fix errors before or after import | No | Yes |
| View import history | No | Yes |
| View import results in the UI | No | Yes |
| Download import results | Yes | Yes |
| Email import results to multiple contacts | Yes | Yes |
Note: Feature availability may vary by object. See the support matrix below for the import methods available for each object.
Import and Export Support by Object
The following table shows whether each object supports the Traditional Import Tool, Import Wizard, and export functionality.
| Object | Traditional Import | Import Wizard | Export |
| Contacts | ✓ | ✓ | ✓ |
| Customers | ✓ | ✓ | ✓ |
| Orders | ✓ | ✓ | ✓ |
| Payments | ✓ | ✓ | ✓ |
| Plans & Charges | ✓ | ✓ | ✓ |
| Products | ✓ | ✓ | ✓ |
| Subscription Contracts | ✓ | ✓ | ✓ |
| Usage | ✓ | ✓ | — |
| Account Types | ✓ | — | ✓ |
| Billing Schedules | ✓ | — | ✓ |
| Chart of Accounts | ✓ | — | ✓ |
| Coupons | ✓ | — | ✓ |
| Credits | ✓ | ✓ | ✓ |
| Currencies | ✓ | ✓ | ✓ |
| Financial Periods | ✓ | — | ✓ |
| Invoices | ✓ | ✓ | ✓ |
| Journal Entries | ✓ | — | ✓ |
| Price Books | ✓ | — | ✓ |
| Quotes | ✓ | ✓ | ✓ |
| Refunds | — | — | ✓ |
| Revenue Rules | ✓ | — | ✓ |
| Revenue Schedules | ✓ | — | ✓ |
Important: Validate this matrix against the current product before publishing. Object support can change as additional objects are migrated to the Import Wizard.
Next Steps
Choose the workflow you want to learn more about:
- Import Wizard Overview — Learn how the Import Wizard works and how to import data using the guided workflow.
- Import Wizard: Getting Started — Learn how to prepare an import file, import data, and view import history.
- Traditional Import Tool — Learn how to use the Traditional Import Tool.
- Export Data — Learn how to export data from Ordway.
Comments
0 comments
Please sign in to leave a comment.