Overview of how to import shopping cart fields
Specifically designed for eBay and Amazon order export
formats you can add a column in the mapping file for Freight
and Sales Tax
amounts that can be added to Sales Orders, Sales Receipts, Estimates, Invoices, Credit Memo, Bills and Check type maps.
When mapped Axis will create a new line in the transaction for that associated item and amount.
Steps to setup shopping cart fields
Follow the steps to set up:
- In the import module click on the More options button.
- Select from the drop down lists the items in QuickBooks that you would like the Freight, Insurance, Discount and Sales Tax (see above) amounts to be assigned to and click OK.
- In the mappings screen at the end of the maps are new fields for Freight, Insurance, Discount and Sales Tax, select the column in your import file that contains the amounts.
- Save your mapping and import the file and these items will be added to the sale in QuickBooks
When importing Discounts they can only be dollar amounts and not a discount percentage.
For orders that have multiple lines the columns that contain the shopping cart fields should have the amount in the last row as that is which row Axis uses to read the amount