<img height="1" width="1" style="display:none;" alt="" src="https://px.ads.linkedin.com/collect/?pid=5096884&amp;fmt=gif">
Skip to content
MYOB2025.1-9
4 min read

MYOB Acumatica 2025.1 Retail & Commerce: simpler Shopify/BigCommerce imports, saner taxes, cleaner price lists

MYOB Acumatica 2025.1 Retail & Commerce: Guest Orders, Default Currency, Tax Mapping, and Price Lists
5:03

Release focus: This post breaks down four practical Retail Commerce enhancements in MYOB Acumatica 2025.1:

  1. import orders without customers (Shopify & BigCommerce),
  2. import Shopify orders/payments/refunds in the default store currency,
  3. improved Shopify tax mapping (same name, different rates), and
  4. smarter Shopify price list sync (only items with effective prices).

 

Why this matters

  • Lower admin overhead: Skip customer creation in Acumatica when you don’t need it.
  • No multicurrency? No problem: Keep Shopify imports in one currency for simpler accounting.
  • Accurate tax mapping: Handle duplicate tax names that differ by rate.
  • Merchandising control: Show only SKUs with an effective price to the right customer catalogue.

 

1) Import Shopify/BigCommerce orders without importing customers

What’s changed

You can now import orders while assigning them to a generic guest customer—no individual customers created in Acumatica.

The guest customer specified for a Shopify store

The guest customer specified for a Shopify store

How to configure

  • Store form:
    • Shopify Stores (BC201010) or BigCommerce Stores (BC201000).
  • Entities tab:
    • Sales OrderSync Direction = Import.
    • Customerdo not activate (leave Active unchecked).
  • Customers tab:
    • Set Generic Guest Customer to the account you want all imported orders to use.

 Behaviour: Each imported order is created for the guest customer. On Sales Orders (SO301000), Override Contact and Override Address are ticked; ship-to/bill-to details are filled from the external order.

Outcome

  • Faster onboarding; fewer records to maintain.
  • Order-level addresses retained for fulfilment and tax—without cluttering your customer master.

 

2) Import Shopify documents in the default store currency

What’s changed

If you don’t need multicurrency accounting in Acumatica, you can import orders, payments, refunds from Shopify in the store’s default currency, regardless of checkout currency.

The new currency setting on the Shopify Stores form

The new currency setting on the Shopify Stores form

How to configure

  • Shopify Stores (BC201010) → Orders tab: check Import in External Default Currency.
  • Payments tab: ensure mappings reference the default store currency.

Limitations & gotchas

  • Orders already imported before you enable this setting keep their original (paid) currency; related documents continue in that currency.
  • A credit-card payment imported in a currency different from the customer’s checkout currency can be captured/voided/refunded only in Shopify (not from Acumatica).

Outcome

  • One-currency AR for simpler posting, reconciliation, and reporting.

 

3) Shopify taxes: map same-name, different-rate taxes

What’s changed

Tax mapping now supports duplicate names with different rates.

How to configure

  • Create a Substitution List (SM206026) for taxes.
  • In Original Value, specify either:
    • <Tax Name> (if unique), or
    • <Tax Name> <Rate>% (e.g., Arkansas State Tax 6.5%) when multiple rates share the same name.
  • On Shopify Stores (BC201010) → Orders tab, set Taxes to your substitution list.

Tip: Supplying name and rate also works when the name is unique.

Outcome

  • Correct tax selection on import, fewer manual fixes.

The substitution list for taxes specified for a Shopify store

The substitution list for taxes specified for a Shopify store

4) Shopify price lists: export only items with an effective price

What’s changed

When syncing Price List for a Shopify store, Acumatica now builds customer catalogues that include only items whose prices in that price class are effective on the sync date. Others move to Excluded and are hidden from those customers.

The Included and Excluded sections of a product catalog at a Shopify store

The Included and Excluded sections of a product catalogue at a Shopify store

How it works

  • The catalogue corresponds to the Customer Price Class (from Sales Prices – AR202000).
  • On sync day, items with an effective price go to Included; items without an effective price go to Excluded.

Outcome

  • Customers see the right products at the right prices; no zero-price surprises.

 

Quick “Do This Now” checklist

Admins / eCom Ops

  1. Decide if you can skip customer imports; set Generic Guest Customer per store.
  2. For single-currency accounting, enable Import in External Default Currency and update payment mappings.
  3. Build a Tax Substitution List; include <name> <rate>% rows where needed.
  4. Review Price Classes and ensure effective dates are set for items that should appear in Shopify catalogues.

Finance

  • Validate GL postings with single-currency imports; test refunds/voids that must be actioned in Shopify.

Merchandising

  • Audit which SKUs belong in each price class and confirm their effective dates before running the sync.

 

FAQs

Q: If I import with a guest customer, do I lose buyer info?
A: The Acumatica customer is the guest account, but order-level contact/address are retained via overrides for fulfilment and reporting.

Q: Can I mix—some stores with guest customer, others full customer sync?
A: Yes. Configure per store. You can also change later if your CRM needs evolve.

Q: What happens to previously imported multi-currency orders after I switch to default currency import?
A: They stay in their original currency; related documents continue in that currency.

Q: How precise must the tax rate string be?
A: Match Shopify’s display (e.g., 0.125%, 6.5%). Using name + rate is safest where duplicates exist.

Q: Why are some products invisible to certain customers after a price list sync?
A: They’re in the catalogue’s Excluded list because no effective price exists for that price class on the sync date.

How Avanza Solutions can help

  • Configure guest customer flows and mappings for Shopify/BigCommerce.
  • Set up default-currency imports and validate your accounting impacts.
  • Build robust tax substitution lists and test edge cases.
  • Tune price classes and catalogue sync so customers see exactly what they should—at the right price.

Want us to implement this in your sandbox and hand you a quick SOP for eCom + Finance teams? We can.

Access the Full Release Notes Here

avatar
Juanita Potgieter
With over 20 years’ experience in various marketing and business development fields, Juanita is an action-oriented individual with a proven track record of creating marketing initiatives and managing new product development to drive growth. Prior to joining Verde, Juanita worked within strategic business development and marketing management roles at several international companies. Juanita is certified in both MYOB Acumatica and Oracle NetSuite.

RELATED ARTICLES