Overview
Avalara is a cloud-based software company that provides tax compliance solutions for businesses of all sizes. Their AvaTax solution helps automate transaction tax calculations and the tax filing process. They help businesses stay compliant with tax laws and regulations while reducing the time and resources required to manage tax compliance.
Sellercloud integrates with Avalara AvaTax via API plugins. The integration allows you to send orders from your Sellercloud account to Avalara and take your tax management to the next level.
Prerequisites
Before you can activate the integration:
- Designate a Company for this integration.
- Contact Sellercloud Support.
- Request to have the Avalara plugin installed on your server.
- Request to have the following custom settings added to your account:
Custom Company Settings
- AvalaraUserName – Your Avalara account’s login username.
- AvalaraPassword – Your Avalara account’s login password.
- AvalaraAccountID – From the Avalara portal under Account in the top right.
- AvalaraCompanyID – From the bolded part in the Avalara portal’s URL: https://admin.avalara.com/cup/a/2001573826/c/2747720/settings.
- AvalaraCompanyCode – From the Avalara portal, under Settings > Company details > Company code.
- AvalaraUseProdAPI – Switches between using the sandbox and production API URL.
Custom Order Columns
- AvalaraExported and AvalaraRefundExported – These columns get marked as True on orders that are successfully sent to Avalara.
Custom Product Column (Optional)
- AvalaraEntityUseCode – Sends the products entity use code if populated.
- Tax Code – On product defaults is also sent to Avalara if populated.
Integrate Avalara
Once you activate the plugin by following the steps below, it will start exporting orders to Avalara in Comma-Separated Values (CSV) format on a regular basis. When Avalara registers an order export without errors, Sellercloud updates the queued job with the ID of the batch export on the Avalara service.
Keep the following details in mind:
- When exported orders are refunded, Sellercloud sends Customer Paid: 0 and Tax: 0.
- When exported orders are marked as “Tax handled by channel,” Sellercloud sends Tax: 0.
Before you move on, create a Saved Search for orders. Filter by:
- Company: Choose the company with Avalara custom settings
- AvalaraExported: False
- AvalaraRefundExported: False
You can add any other filters to narrow down the scope of the export and send specific types of orders to Avalara.
To create a Scheduled Task that regularly exports orders from Sellercloud to Avalara:
- Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
- Click the green + icon: Create New Scheduled Task.
- Complete as follows:
- Click Task Type and select Export Orders.
- Set the Task Name.
- Select the Company.
- Select the Start Time.
- Click CREATE.
- The following message appears at the bottom of your screen: “Scheduled task created successfully. Click Here to configure the task details.” – click the link.
- Click the Edit button on the top right.
- In the Details section:
- Click the User ID menu and select your ID.
- Click the Saved Search menu and select the saved search you created earlier.
- Click the Export Via menu and select Avalara API Bulk Order Export.
- Check Mark Orders As Exported.
- In the Export Options section, leave Export To on None.
- In the Frequency section, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
- In the General section, click the Enable toggle button.
- Click Save on the top right.