Field Type | Maximum Length |
---|---|
Currency | 15 Digits and a Maximum of 2 decimals |
Decimal | 15 Digits and a Maximum of 2 decimals |
64 Characters including @ and . | |
Freeform | 300 Characters |
Hyperlink | 999 Characters |
Long Text | 100,000 characters |
Phone Number | 21 Characters |
Rich Text | 999 Characters |
Field Group(Label) | 65 Characters |
Store Description (Item Record) | 4,000 Characters |
Featured Description | 1,000,000 Characters |
Detailed Description | 1,000,000 Characters |
Topics: Customization
The Import Assistant allows you to update items data for the following types of transactions: Cash Sale, Estimate, Invoice, Opportunity, Purchase Order, Sales Order, Vendor Bill, Vendor Credit, and Vendor Return Authorization. You can modify data for existing line items and/or add line items to existing transactions.
Topics: Customization
Be careful when entering numbers into a CSV file. Many spreadsheet programs do not allow or do not show leading zeros by default, which can be a problem if your data needs those leading zeros. You can work around this problem by formatting the cells in the spreadsheet program as text rather than numbers.
Topics: Customization
In order to set up your CSV files correctly before importing:
Topics: Customization