Skip to main content
Solved

Shoppify Mappings COO / Last Cost / Pricing

  • April 23, 2024
  • 5 replies
  • 100 views
kkeating24
Jr Varsity III
Forum|alt.badge.img

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

Best answer by tusharpandita74

@kkeating24:

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

View original
--attachment is the great fabricator of illusions; Reality can only be attained by someone who is detached. -s.w.
    Did this topic help you find an answer to your question?

    5 replies

    T
    Acumatica Employee
    Forum|alt.badge.img

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

    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett
    kkeating24
    Jr Varsity III
    Forum|alt.badge.img
    • kkeating24
    • Author
    • Jr Varsity III
    • 91 replies
    • May 8, 2024

    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

     

    --attachment is the great fabricator of illusions; Reality can only be attained by someone who is detached. -s.w.
    T
    Acumatica Employee
    Forum|alt.badge.img

    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? 

    kkeating24
    Jr Varsity III
    Forum|alt.badge.img
    • kkeating24
    • Author
    • Jr Varsity III
    • 91 replies
    • May 15, 2024

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

    --attachment is the great fabricator of illusions; Reality can only be attained by someone who is detached. -s.w.
    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett
    T
    Acumatica Employee
    Forum|alt.badge.img
    • tusharpandita74
    • Acumatica Employee
    • 20 replies
    • Answer
    • May 16, 2024

    @kkeating24:

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

    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett

    Reply


    Most helpful members this week

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    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