Manage Walmart sales tax for states with Marketplace tax facilitator – Celigo Help Center

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.

Login to your integrator.io account.
Click Walmart - NetSuite Integration App tile.
Go to Integration Flows > Order > Walmart Order to NetSuite Order Add.
Click on the Field Mappings icon next to the flow. The Mappings window is displayed.

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

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:

Login to your NetSuite account.
Go to Setup > Accounting > Set Up Taxes.
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.

Comments

6 comments

David Eisen

July 26, 2021 20:30
I tried adding these handlebars but am getting an error when running the flow that the expression is incorrect.
0
KHAISAR AHMAD QA Lead

July 27, 2021 11:40
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

July 27, 2021 21:41
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

August 11, 2021 15:08
Hi Khaisar,

Have you had a chance to look into this error?
0

KHAISAR AHMAD QA Lead

August 12, 2021 15:56
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.

David Eisen

August 16, 2021 14:25
Your fix is working well,

Thank you!
0

Please sign in to leave a comment.

Workaround for the order flows

Identifying tax setup in NetSuite

Related articles