Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

...

In this section, you'll configure how customers are created and matched during the order import:

Field Description
Mark customers as non-taxable if no tax was charged Marks customers as non-taxable if no tax was charged on the order.
Uppercase all name informationImports the customer name details in uppercase.
Match orders to customers based on name and email address if possibleMatch orders to customers based on name and email address if possible
Match orders to customers based on name and city if possibleMatch orders to customers based on name and city if possible.
Automatically update customers with the latest information from orderAutomatically updates customers with the latest information from order
Import by company name instead of last name, first name when possibleImport by company name instead of last name, first name when possible
Default TermsSet's the default terms that apply to purchase orders
Default TypeSet's the default purchase type.
Import as Customer

Select this only if you wish to have all the orders imported from UltraCart assigned to a single customer record.
This is typically used to assigned the imported customers as "UltraCart Customers" or "Web Orders", or something similar.

Info

PLEASE NOTE: Configuring the 'Import as Customer' will override the other "matching" settings. If you wish to have the customers imported to their own customer record, please leave this drop-down menu unconfigured (the blank option in the drop-down list is selected.


...

When configuring items within QBO, make sure that the UltraCart ItemID is the same as either the QuickBooks Item Name or Item SKU, otherwise the item will not be recognized and the import will fail. 

See also: https://quickbooks.intuit.com/learn-support/en-us/manage-lists/import-products-and-services-from-excel/00/185613

Info
titleQuickbooks Codes do not apply to QBO integration

If you are migrating to QBO from the QB desktop and have previously been using UltraBooks with QB desktop application, please note that the "QuickBooks Codes" you previously configured are not valid with the QBO integration. If you were using the QuickBooks codes for item mapping, you'll need to configure the Ultracart ItemID in either the QBO Item Name or QBO Item SKU. (NOT the UltraCart SKU field, but the QuickBooks Online SKU field.)


Error Queue

The last section is the Error Queue. 


Related Documentation

https://quickbooks.intuit.com/learn-support/en-us/manage-lists/import-products-and-services-from-excel/00/185613

...