Shoppify Mappings COO / Last Cost / Pricing

  • 24 April 2024
  • 5 replies

Userlevel 2

Hello @simonliang91 @KarthikGajendran et al. 

I was looking through the mappings and wanted to see if we have any updates to the following:

For Shopify integrations I have the need to map:

  1. Country Of Origin - I don’t see this as a field value that is mappable in the entity screen and it is not mapped out of the box. 
  2. Last Cost vs. Current Cost - i know there are couple threads out there (one that I started) but it seems the customization focuses on Matrix Items.  It would be nice if we had the option to choose which one, as I have an example where the valuation is FIFO and it is not pulling last cost.  It is pulling the current cost (from Standard Cost) so this is effectively 0 in our scenario. 
  3. Pricing - a general question - does the mapping consider sales pricing at all?  either promotional or worksheet based (non b2b)?




Best answer by tusharpandita74 16 May 2024, 19:48

View original

5 replies

Userlevel 3

Hi @kkeating24:

In order to map country of origin from ERP to Shopify, you can use the following fields in ERP section:


B2B features needs to be enabled for exporting sales prices of products for customer price classes for companies. We added this functionality in the product in 23R2 ( Without B2B features we do not support export of Sales Prices. Please note, the price list feature is only available in Shopify for companies (B2B Offering).   

Userlevel 2

Thanks @tusharpandita74 - for the country of origin, what is the “external object/field”?   How does it know to update this drop down:

Shopify Shipping Info


Userlevel 3

Hi @kkeating24 

The Country/Region of origin field of Shopify is not available in the list of external fields available for mapping.

Could you please advise on the use case/business, on how you will be using this field? 

Userlevel 2

@tusharpandita74  - we have several customers that sell on shopify that are either required to, or would appreciate the ability to post the Country of Origin for their products.   It can be entered via Shopify, but if they have 3,000+ items it would be great if it could be managed via the connector. 

Userlevel 3


We are checking if the field can be added in mapping. 


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved