Important Notes about Importing Orders
If you are integrated to Accounts Receivable, you can select the Create new customers from import check box if you import orders for customers that don’t exist in Denali and you want to create records for these customers. Existing customers will also be updated with any changes. A Customer Import Report will appear during the import process that shows you the Denali customers that were created and updated.
To find existing customers, Denali matches customer email addresses to addresses in 3dCart. If the email address in 3dCart doesn’t exist on a Denali customer record, the new Customer Number in Denali will be the email address from 3dCart.
If you leave the check box unchecked and a customer does not exist in Denali, the order will import as a cash sale and no customer records will be updated.
Orders from 3dCart are imported into a separate batch and automatically post as part of the import process. After you check the Edit report and select to post your orders, a Posting report appears.
Because orders you import are considered paid for and complete in 3dCart, Denali uses the payment type WebPay to distinguish 3dCart orders on reports.
Orders will not import and you will receive an error report if any of the following are true:
The IN stock number in Denali does not match the 3dCart ID/Sku field.
You don’t have enough stock on hand to complete the order.
You use Multi-Location Inventory and the location you set up to use with 3dCart does not have enough stock on hand.
Invalid data is found.
Invoice numbers you import from 3dCart will be assigned new invoice numbers in Denali to prevent duplicate invoice numbers. You can reprint invoices from history to view the original 3dCart invoice number.
Orders from 3dCart automatically have the tax type WEBTAX distributed evenly across all detail lines on the orders. If you need to adjust tax amounts, you will need to enter adjustment transactions in Accounts Receivable. You cannot use WEBTAX on manually entered transactions.
If you import orders with serialized or lot numbered items, Denali will assign existing serial or lot numbers to the stock items based on the valuation method on the IN Code attached to the stock item.
Published date: 10/11/2021