Duties Import Shopify

​@TamaraW 

Acumatica has landed costs functionality which can be used for duties but this is for purchases.

Could you utilise a new tax id for this purpose?

​@aiwan thanks for the response. 

Never thought about using the tax ID for that purpose. 
Maybe this could be an option. 

I’m not quite sure if this error message is somehow related to the duties topic. But i have one order in Shopify where we collected taxes and duties. 
The customer then told us, that he wanted to cancel one item. So we edited the order in shopify and refunded the amount of the item + tax + duties. This edit caused the following error message when i tried to synch it:
Invalid object name 'SOQuickPrepaymentInvoice'.

We’re not creating prepayments, so the error message doesn’t really makes sense for me.
 

Hi ​@TamaraW were you able to find a solution? Thank you!

​@Chris Hackett no, not yet. 
The tax ID doesn’t seem to be a good workaround.

I’ll give an update when i found a proper solution.

could you create a non-stock item as the duty and import it that way?   how are the duties getting calculated on the order in shopify? 

​@kkeating24 was also my idea but i’m not sure how to set it up in the e-commerce/objects section of Accumatica. This is how it looks like in Shopify:
 

So i need to say: If there are duties in the order, add a non-stock item to the order with the amount of the duties line in shopify.

Any ideas how i can set it up?

I’m not a shopify developer, but I know apps like FLOW can interject and add things.   

Or can you send the JSON of the order to see if it is contained there?  if it is we might be able to map it...

All you need to do is add “.JSON” to the Order URL. 

​@kkeating24 i’m not able to send you the whole json information (GDPR), but what i can see with duties is:

"currency":"EUR","current_subtotal_price":"30.07","current_subtotal_price_set":{"shop_money":{"amount":"30.07","currency_code":"EUR"},"presentment_money":{"amount":"34.99","currency_code":"USD"}},"current_total_additional_fees_set":null,"current_total_discounts":"0.00","current_total_discounts_set":{"shop_money":{"amount":"0.00","currency_code":"EUR"},"presentment_money":{"amount":"0.00","currency_code":"USD"}},"current_total_duties_set":{"shop_money":{"amount":"4.51","currency_code":"EUR"},"presentment_money":{"amount":"5.25","currency_code":"USD"}},"current_total_price":"39.30","current_total_price_set":{"shop_money":{"amount":"39.30","currency_code":"EUR"},"presentment_money":{"amount":"45.73","currency_code":"USD"}},"current_total_tax":"0.00","current_total_tax_set":{"shop_money":{"amount":"0.00","currency_code":"EUR"},"presentment_money":{"amount":"0.00","currency_code":"USD"}},"customer_locale":"en-US","device_id":null,"discount_codes":[],"duties_included":false,

but also in the same order this:

"original_total_additional_fees_set":null,"original_total_duties_set":{"shop_money":{"amount":"4.51","currency_code":"EUR"},"presentment_money":{"amount":"5.25","currency_code":"USD"}},

ok, interesting, are you familiar with how to use the entity mapping in ACU?  you might need to play around with that “original_total_duties_set” to see if you can get it to work...otherwise this is feeling a bit like a customization...

​@kkeating24 do you mean with entity mapping this section?:

that’s correct. 

We've built a customs intelligence add-on that connects to Acumatica and calculates the full landed cost for every purchase order involving international trade.

  THE PROBLEM

  Acumatica doesn't have native fields for customs duties. Most teams either email their customs broker (and wait days), use spreadsheets (and get it
  wrong), or create workarounds like tax IDs and non-stock items for duty amounts.

  HOW IT WORKS

  1. Click "Import from Acumatica" — select any open PO
  2. Each line item is auto-classified into the correct HS commodity code
  3. Full customs cost calculated: import duty + VAT/GST + anti-dumping surcharges
  4. Required border documents listed (Bill of Lading, Certificate of Origin, etc.)
  5. FTA savings flagged — if a preferential rate exists for your trade route
  6. Sanctions screening on every trade route
  7. Click "Push to Acumatica" — customs summary written to the PO's Notes field

  No customisation project. No custom fields. Works on any Acumatica instance.

  REAL EXAMPLE

  PO 000557 — Cumin from Germany to UK:
  • HS Code: 0904.12 (auto-classified from "Cumin Ground - India")
  • Import duty: EUR 20.92 (4% MFN)
  • VAT: EUR 0 (food is zero-rated in UK)
  • Total landed: EUR 543.92
  • Documents: Bill of Lading, CDS Declaration, Commercial Invoice, Certificate of Origin, EORI
  • Sanctions: CLEAR

  Time to calculate: 5 seconds.

  COVERAGE

  • 47 countries (US, UK, EU 27, India, China, Brazil, Saudi Arabia, Australia, and more)
  • 565,000+ commodity codes from official government tariff databases
  • 60+ trade agreements with preferential rates
  • 2,170 anti-dumping measures
  • Daily automated monitoring for rate changes

  We're an existing Acumatica OEM partner (Phlo Systems / OpsPhlo).

  Full walkthrough with screenshots: https://customs-compliance.ai/blog/acumatica-po-enrichment

  Happy to do a demo for anyone interested — saurabh.goyal@phlo.io