Skip to main content

Manage Walmart sales tax for states with Marketplace tax facilitator

Gogula R Bhavana
  • Updated

Walmart decided to take over 100% of sales tax responsibility for the WA, MN, CT, IA, OK, PA, SD, NJ, AL, DC, NE, SC, NY, ID, AR, IN, KY, NM, ND, RI, VA, VT, WV, WY, OH, AZ, CA, CO, ME, MD, MA, NV, TX, UT, HI, WI, IL, MI, NC, and GA states (including filing and remittance). Based on applicable tax laws, Walmart now calculates, collects, and remits sales tax for orders shipped to customers in these states. In case you are shipping an order to these states, the requirement is for you to be able to import the same order in NetSuite with 0 sales tax.

To understand more about the Sales Tax collection in Walmart, refer here.

Workaround for the order flows

You can overwrite the tax calculation logic by configuring mappings for the Order flow. After you configure the below mappings and run the “Walmart Order to NetSuite Order Add” flow, the order is imported with 0 sales tax. 

Important: The below handlebar expressions are for selective states. Configure the handlebar expressions as per your required state.

  1. Login to your integrator.io account.
  2. Click Walmart - NetSuite Integration App tile.
  3. Go to Integration Flows > Order > Walmart Order to NetSuite Order Add.
  4. Click on the Field Mappings icon next to the flow. The Mappings window is displayed.
  5. Based on your tax setup in your NetSuite account, such as line-level or body level taxes, add new mappings.
    Export Field (HTTP) Import Field (NetSuite)
    Body Level taxes 
    {{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'AK'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'DE'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'FL'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'KS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'LA'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MO'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MT'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'NH'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'OR'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'TN'}}F{{else}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}} istaxable
    {{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'AK'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'DE'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'FL'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'KS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'LA'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MO'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MT'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'NH'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'OR'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'TN'}}0{{else}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}} taxrate
    Line Level Taxes 
    {{#if orderLines.orderLine[*].item.sku}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'AK'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'DE'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'FL'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'KS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'LA'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MO'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MT'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'NH'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'OR'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'TN'}}0{{else}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{else}}{{/if}} item[*].taxrate1
    {{#if orderLines.orderLine[*].item.sku}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'AK'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'DE'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'FL'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'KS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'LA'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MO'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MT'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'NH'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'OR'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'TN'}}0{{else}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{else}}{{/if}} item[*].taxAmount
    {{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'AK'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'DE'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'FL'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'KS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'LA'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MO'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MT'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'NH'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'OR'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'TN'}}0{{else}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}} shippingtax1rate

  6. Click Save & Close. 

Tip: To see the imported taxes on the sales order, go to Sales Order > Etail tab > ETAIL TAX TOTAL VARIANCE.

Identifying tax setup in NetSuite

To verify your tax setup in your NetSuite account:

  1. Login to your NetSuite account.
  2. Go to Setup > Accounting > Set Up Taxes.  
  3. On the Set Up Taxes page:
    • If the “per-line taxes on transactions” box is selected, the taxes are applicable at the line level.
    • If the “per-line taxes on transactions” box is unchecked, the taxes are applicable at the body level.

Related articles

Comments

6 comments

Date Votes
  • David Eisen

    I tried adding these handlebars but am getting an error when running the flow that the expression is incorrect.

    0
  • KHAISAR AHMAD QA Lead

    Hello David Eisen
    Can we please get more details on the issue. What is the tax setup you are using? Are you using Line level Taxes or Body Level Taxes? Can you also please provide the error you are getting in the flow run.

    0
  • David Eisen

    Sure,

    We're using body level taxes, here's the error:

    "Failed to add Walmart Order# 2815784269456. Could not compile handle bar \"{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'AK'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'DE'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'FL'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' ‘KS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'LA'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MS'}}{{#compare (u...

    0
  • David Eisen

    Hi Khaisar,

    Have you had a chance to look into this error?

     

    0
  • KHAISAR AHMAD QA Lead
    • Edited

    Hello David Eisen

    Sorry for the delay. Yes, I tried debugging this further and able to find the issue. If you observe the below screenshot, for the state code KS, it is opened with an incorrect symbol. It has to be a single quote. I have pasted the updated handlebar below for both the mentioned mappings, 

    For "istaxable" field mapping

    {{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'AK'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'DE'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'FL'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'KS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'LA'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MO'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MT'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'NH'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'OR'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'TN'}}F{{else}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}

    For "taxrate" mapping

    {{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'AK'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'DE'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'FL'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'KS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'LA'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MO'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MT'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'NH'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'OR'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'TN'}}0{{else}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}

     

    Please review this and let us know if you are still facing the issue. 
    0
  • David Eisen

    Your fix is working well, 

    Thank you!

    0

Please sign in to leave a comment.