The following section covers how to how to configure iPaaS.com to use the BigCommerce Avalara application for taxes. Some clients use Avalara to help calculate taxes.

Prerequisites
Avalara Cods in CP(TAX_COD,AUTH_COD,RUL_COD)
Avalara Tax Class Code on CP items (see https://taxcode.avatax.avalara.com/)

First, the MiSP will need to configure iPaaS.com bring up the tax class code on the CP product to the eccomerce site.

 

1. Log in to iPaaS.com.

2.  Select company profile.

3. Select "Subscription Management-Subscription" from menu.

4. Select the "Manage Mapping" button on the client's  CP's subscription.

 

Ho e user / Role Management Data Management Subscriptions Management Integration Monitoring and Diagnostics LOCK Subscriptions ALL ITEMS *ARCH CERTIFIED INTEGRATION MARKETPLACE & SUBSCRIBE CREATE DYNAMIC PRIVATE SEARCH Search EST NEW CLOUD APPLICATIa•a E'QOLLMENT IMPORT Integration Template Integration private Private Actions Fixed Fixed N/A N/A Active Commerce O NCR Gordy & Sons countervont

 

 

5. Select CP Product to iPaaS.com mapping collection.

6. Select "ADD NEW MAPPING".

7.  Select "Field" as type of data source from left "Source" dropdown.

8. Select ATTR_COD with Tax Class Info from right "Source" dropdown(Example: ATTR_COD_6).

 

Add New Mapping Mapping 會 闫 自 自 鬮 會 闫 自

 

9. Select "Field" as type of data destination from left "Destination" dropdown.

10. Select  field  TaxClass from right "Destination" dropdown.

11. Click "Save", then" Apply" at the bottom of the page

6u!ddev••q MON ppv bu!ddew

 

12. Select "Subscription Management-Subscription" from menu.

13. Select the "Manage Mapping" button on the client's  BC subscription.

 

Dashboard Subscription Subscriptions BigCommerce ONCR Counterpoint MARKETAACE & Type DYNAMIC PRIVATE Integration Type Private Private EWEST NEW CLOUD EALMENT Active Active

 

14. Select one of the  BC Product from iPaaS.com mapping collections(Add or Update).

15. Select "ADD NEW MAPPING".

16.  Select "Field" as type of data source from left "Source" dropdown

17. Select TaxClass Info from right "Source" dropdown(Example: ATTR_COD_6).

 

Add New Mapping Mapping 會 闫 自 自 鬮 會 闫 自

 

18.Select "Field" as type of data destination from left "Destination" dropdown.

19. Select  ProductTaxCode from right "Destination" dropdown.

20. Click "Save"   then"Apply" at the bottom of the page.

 

6u!ddev••q MON ppv bu!ddew


21. Select the other product collection.
22. Repeat steps 15-20 for the other collection.

 Next, We to modify the BC tax Mapping collection

 

1. Select the + button next to " Transaction-BC Order Headers to iPaaS

2. Navigate to "BC Order Tax to iPaaS"

3. Select "Edit" button
  


4. Navigate to amount mapping and select "Edit".
 5. Switch "TYPE" to dynamic formula.

6.  In "Source" body, type in Parent.TotalTax .
7. Click "Save", then apply at the bottom of the page.

  

 

Next , you will edit the some of default tax mappings in the CP Order Headers Collection.

 

1. Select the "Edit" Button next to " Transaction-CP Order Headers from iPaaS.

 

Transaction Transaction Transaction Transaction Transaction Payment Transaction CP Order Header Complete Update From IPaoS CP Order Header Cancel Update From IPanS CP Deposit Ticket From IPnnS CP Deposit Ticket - From IPaaS CP Deposit Ticket - Payment From IPaaS CP Deposit Ticket - GC Line From IPaaS e re

 

2. Navigate to "TAX_COD' field.

3. Select Edit.

 

Dynamic Formula Static Static Dynamic Formula Static Static Static Static Dynamic Formula Dynamic Formula Static Static Static Static Static • IsPrirnayShipping true". "Componf) WEB WEB "BC" + TransoctionNurnber WEB WEB WEB CustomerFromEmaiI(EmailAddress) FieldFromFirstMatch(ßCdresses. "IsPrimaryShippinq true "Shipping Method") AVA LARA WEBSITE WEBSITE Subtotal SHIP _ NAM _TYP STR_ID STA ID TKT_NO ooc_TYP DRWAD USR_ID SLS„REP cusr_NO TAX_COD TAX EXEMPT NO TIMES„PRTD ORO 9 9

 

4. Change "TYPES" field to Static.

5. Update "Source" field with CP  Avalara tax code. (Example  "AVALARA")

6. click "SAVE".

 

Edit Mapping

 

7. Click "APPLY".

 

TAX Static Static Field Field Field Static AVA LARA WEBSITE WEBSITE Subtotal DiscountArnount TaxAmount ShippingAmount coo TIMES_PRTD ORO TAX AMT 0R0_ror DOC„STAT

 

8. Select the + button next to " Transaction-CP Order Headers from iPaaS".

9. Navigate to "CP Order Tax From iPaaS".

10. Select "Edit" button.

 

Transaction Transaction Transaction Transaction Note Transaction Payment Transaction Line Transaction Transaction Note CP Order Header Complete Update From IPoaS CP Order Header Cancel Update From IPaaS CP Order Header From IPaaS CP Order Customer Note From IPaaS CP Order Payment From IPaaS CP Order Line From IPaaS ZP Order Tax From IPaaS cp order Staff Note From IPaas fi

 

11. Navigate to "AUTH_COD' field.

12. Select Edit.

13. Change "TYPES" field to Static.

14. Update "Source" field with CP tax code. (Example"AVALARA")

15. Click "SAVE".

 

Edit Mapping

 

 

16. Navigate to "RUL_COD' field.

17. Select Edit.

18. Change "TYPES" field to Static or Dynamic Formula.

19. Update "Source" field with CP tax rule code.( Example : AVALARA".)

20. Click "SAVE".

 

Edit Mapping Mappir



 21. Navigate to "TAX_AMT"' field.

22. Select Edit.

23. Change "TYPES" field to Dynamic Formula.

24 Update "Source" field with TaxAmountAvalaraSupport(Parent.Taxes, false).

25. Click "SAVE".

 

 

26. Navigate to "NORM_TAX_AMT"' field.

27. Select Edit.

28. Change "TYPES" field to Dynamic Formula.

29 Update "Source" field with TaxAmountAvalaraSupport(Parent.Taxes, true).

30. Click "SAVE".

 


 31. Click "APPLY".

 

Lastly, you will edit the some of default tax mappings in the CP Deposit Ticket Collection.

 

1 .Select the "Edit" Button next to " Transaction-CP Desposit Ticket from iPaaS".

 

Transaction Transaction Transaction Transaction Transaction Payment Transaction CP Order Header Complete Update From IPaoS CP Order Header Cancel Update From IPanS CP Deposit Ticket From IPnnS CP Deposit Ticket - From IPaaS CP Deposit Ticket - Payment From IPaaS CP Deposit Ticket - GC Line From IPaaS e re

 

2. Navigate to "TAX_COD' field.

3. Select Edit.

 

Dynamic Formula Static Static Dynamic Formula Static Static Static Static Dynamic Formula Dynamic Formula Static Static Static Static Static • IsPrirnayShipping true". "Componf) WEB WEB "BC" + TransoctionNurnber WEB WEB WEB CustomerFromEmaiI(EmailAddress) FieldFromFirstMatch(ßCdresses. "IsPrimaryShippinq true "Shipping Method") AVA LARA WEBSITE WEBSITE Subtotal SHIP _ NAM _TYP STR_ID STA ID TKT_NO ooc_TYP DRWAD USR_ID SLS„REP cusr_NO TAX_COD TAX EXEMPT NO TIMES„PRTD ORO 9 9

 

 

4. Change "TYPES" field to Static.

5. Update "Source" field with CP tax code.

6. Click "SAVE".

 

6u!dden

 

 

7. Select the + button next to " Transaction- CP Deposit Ticket from iPaaS".

8. Navigate to "CP Deposit Ticket - Tax From iPaaS".

9 Select "Edit" button.

 

Transaction Transaction Transaction Transaction Transaction Tax Transaction Payment Transaction Line CP Order r Complete Update From IPnaS CP Order Header Cancel Update From IPnaS CP Order Heade r From IPanS CP Deposit Ticket From IPaaS CP Deposit Ticket - TOA From IPaaS CP Deposit Ticket - Payment From IPaa± CP Deposit Ticket - GC Line From IPoaS 9

 

10. Navigate to "AUTH_COD' field.

11. Select Edit.

12. Change "TYPES" field to Static.

13. Update "Source" field with CP tax code(Example "AVALARA").

14. Click "SAVE".

 

Edit Mapping

 

 

15. Navigate to "RUL_COD' field.

16. Select Edit.

17. Change "TYPES" field to Static.

18. Update "Source" field with CP tax rule code(Example "AVALARA").

19. Click "SAVE".

 

Edit Mapping Mappir

 

20. Navigate to "TAX_AMT"' field.

21. Select Edit.

22. Change "TYPES" field to Dynamic Formula.

23 Update "Source" field with TaxAmountAvalaraSupport(Parent.Taxes, false).

24.  Click "SAVE


  

 

25. Navigate to "NORM_TAX_AMT"' field.

26. Select Edit.

27. Change "TYPES" field to Dynamic Formula.

28 Update "Source" field with TaxAmountAvalaraSupport(Parent.Taxes, true).

29. Click "SAVE".

 

 

 

30: Click "APPLY".