Retail Commerce: Import of Shopify

Documents in the Default Store Currency

Retail Commerce: Import of Shopify Documents in the Default Store Currency

A Shopify store can support multiple currencies, one of which is the default store currency. Users can pay their orders in a currency that is different than the default one.

In MYOB Acumatica 2024 R2 and previous versions, the system imported an order and the related documents, such as payments and refunds, from a Shopify store in the currency in which the order was paid in the store.

To support the scenarios when users do not need multicurrency accounting, MYOB Acumatica 2025.1 allows administrative users to import orders and the related payments and refunds from Shopify using only the default store currency.

Importing Documents in the Default Store Currency

To make the system import documents from the Shopify store in only the default store currency, an administrative user selects the Import in External Default Currency check box on the Orders tab of the Shopify Stores (BC201010) form. (See the following screenshot.)

Figure 1. The new currency setting on the Shopify Stores form

With the check box selected, the system imports orders from the Shopify store in the default store currency even if they were paid in another currency. The system can import all the documents related to these orders as payments and refunds in the default store currency as well. To set this up, the administrative user also configures proper mappings that have the default store currency on the Payments tab of the Shopify Stores form.

The following limitations apply to the import of documents in the default store currency:

• If a Shopify order has already been imported to MYOB Acumatica in a currency that is different than the default store currency before the Import in External Default Currency check box is selected on the Orders tab of the Shopify Stores form, all the documents related to that order will be imported in the same order currency even with the Import in External Default Currency check box selected for the store.
• If a credit card payment is imported to MYOB Acumatica in a currency other than the one in which the customer paid in the Shopify store, the payment can be captured, voided, or refunded only in the Shopify store.