Does anyone integrate Shopify with Netsuite? We’re...
# general
r
Does anyone integrate Shopify with Netsuite? We’re managing a few clients and penny rounding on tax is quite a topic. We’ve implemented restlets to push a penny rounding on the total by changing the tax1amnt but on multiple quantities, the variance is more common. If anyone has faced similar, would be great to hear some feedback on what how you tackled this
a
Honestly, Avalara is the best option. When you use Avalara in Shopify and Netsuite, there is no issue the rounding.
👍 1
p
We use Avalara in shopify, and have it post tax to Netsuite. we have it set not to recalculate the tax. So it keeps the calculation done in shopify.
👍 1
j
If you're using a prebuilt Celigo Flow between Shopify and NetSuite, the variance is tracked in a custom field. You can also choose to have the amount posted as a line item on the NetSuite transaction, linked to an item you select in the settings.
m
We’ve seen this come up a lot with Shopify <> NetSuite, especially around tax penny rounding and quantity variances. One option to look at is Blue Onion — it’s built to reconcile Shopify, Amazon, payment processors, and NetSuite down to the penny without custom scripts. It automatically handles penny rounding issues and quantity mismatches so you don’t have to rely on manual restlets or workarounds. Happy to share more if that’s helpful but worth checking out if you’re looking for a cleaner long-term solution.