Sync province retail shipping tax to NetSuite

Colorado retail delivery fee is tax applied in colorado province.

$0.27 for the motor vehicle.

It is applied only one time if multiple shipments are available.

It added along with the tax as retail delivery tax

If the items are non taxable then it would not be applied.

If the items are a mixture of taxable and non-taxable then fee will be applied when there are multiple items.

For digital products, no fee is applied.

It is applied only when the shipment is to a colorado address.

Settings and Mapping that we have to add as follows:

In the Shopify province tax field, enter the province name of your choice, that collects the shipping tax retail fee. See the order JSON example below for the province name.

In the NetSuite shipping tax field, choose a non-inventory NetSuite item to track Shopify province tax as a separate line item on the NetSuite sales order. 

Mapping

To update the custom lookup mapping on the TaxRetailFee field:

1. Navigate to the Flows tab.
2. Click Edit Mappings of the Shopify order to NetSuite sales order (add) flow.
3. On the TaxRetailFee field, click the Settings() button.
4. In the Field mapping type, select Lookup.
5. In the Options, select Static: Value to value.
6. In the Export field value, enter the province name.
7. In the Import field value, enter the value according to the province name entered in the export field value.
8. Click Save.