Skip to main content

Hello @simonliang91 @KarthikGajendran et al. 

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

https://help.acumatica.com/(W(11))/Help?ScreenId=ShowWiki&pageid=5ecd0d16-a869-4ccb-bf09-7ffb05f25a4e

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)?

Cheers,

k2

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 (https://acumatica-builds.s3.amazonaws.com/builds/23.2/ReleaseNotes/AcumaticaERP_2023R2_ReleaseNotes_full.pdf. 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).   


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

 


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? 


@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. 


@kkeating24:

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


Reply