Avalara Consumer Shipping Report

Functionality

The Avalara Consumer Shipping Report App enables you to export shipping orders in the Avalara format.

For quick access to the topic you are looking for, click the corresponding link below:

• Setup
• Exporting Shipping Orders with the Avalara Consumer Shipping Report
• How to download reports with Alcohol Percentage

Installing the Avalara Consumer Shipping Report App

Navigate to the app store in your Commerce7 admin panel and click on the Avalara Consumer Shipping Report app. You need to have an Admin Owner role to see this page.

Click on the INSTALL button to install the application. After the installation is complete, the application will show up under the Reports menu page from your admin panel.

Exporting Shipping Orders with the Avalara Consumer Shipping Report App

To export your shipping orders in the Avalara format you’ll need to run an order report. To run an Order Report, first head into Reports from your Admin panel then click on the Order Reports. 

From there, scroll down until you see the Avalara Consumer Shipping Report option and click on it. 

Once inside the Avalara Consumer Shipping Report window, select a start and end date for the data you wish the report to export. Then click on Submit

Once you click submit several things will happen:

1. The app will run the report and you will get a notification stating that you will receive an email with the report shortly
2. You will also see the report you submitted listed on the same window below the submit button. 
3. When the report is done you should receive an email with the report attached for download.

Once the report has been processed, you can also download it from within the app. By this time, you should also have received the email containing your report.

You should keep in mind that the Download Link expires within 24 hours. 

How to download reports with Alcohol Percentage

When setting up a product in Commerce7, under the variant and pricing section you'll see a field named Alcohol Percentage. This field represents the PCT_ALCOHOL column in the Avalara Report.

You'll need to make sure your products in C7 have the alcohol percentage stated in this field.