Skip to main content
Solved

Shopify Customer Pickup Issues with Autogenerated Emails

K
Freshman I
Forum|alt.badge.img
  • KEL
  • Freshman I
  • 20 replies

We are using the Shopify shipping option for the customer to pickup in our store. However, when the order goes to the warehouse to pick/pack/ship it is confirmed shipped when the order goes to the store to await pickup. 

This triggers Shopify to notify the customer that their order is on the way. Shopify has a multi-email system set up so you can email the customer that the order is ready for pick up (which is what it is not shipped), but Acumatica can’t send different information to Shopify to specify which email to send, or so I was told during our integration.

Is there any way to have Acumatica not trigger the email if a certain shipment option is selected? I would rather no email than a misleading one being sent to these customers. But I don’t want all our other customers not to get their shipping information emails.

Or has anyone found a way to send out different emails for different shipping options in Shopify with Acumatica? Even if it is a third party partner app. 

Best answer by Yuri Karpenko

@KEL , you can try with this custom mapping on the Entities screen in Acumatica:

 

Please note that I didn’t test it, and obviously your ship via codes are probably different, but you get the idea, right?

Let us know if this worked!

View original
    Did this topic help you find an answer to your question?

    10 replies

    Yuri Karpenko
    Captain II
    Forum|alt.badge.img+6
    • Yuri Karpenko
    • Captain II
    • 373 replies
    • Answer
    • October 11, 2024

    @KEL , you can try with this custom mapping on the Entities screen in Acumatica:

     

    Please note that I didn’t test it, and obviously your ship via codes are probably different, but you get the idea, right?

    Let us know if this worked!

    Yuri Karpenko | DM me if you need help building e-Commerce for your business or connecting it to Acumatica ERP
    Chris Hackett
    StacieJurczak41
    K
    3 people like this
    • Chris Hackett
      Chris Hackett
    • StacieJurczak41
      StacieJurczak41
    • K
      KEL
    KarthikGajendran
    Acumatica Moderator
    Forum|alt.badge.img+3

    @KEL  Please try to see a ship via that is not a common carrier(Will call option enabled) in the Shipment. When the Will Call Ship Via is used in the Shipment, then the connector will not send any update to Shopify from Acumatica. 

    Technical Product Manager- Retail Commerce
    Chris Hackett
    StacieJurczak41
    2 people like this
    • Chris Hackett
      Chris Hackett
    • StacieJurczak41
      StacieJurczak41
    K
    Freshman I
    Forum|alt.badge.img
    • KEL
    • Author
    • Freshman I
    • 20 replies
    • October 11, 2024
    Yuri Karpenko wrote:

    @KEL , you can try with this custom mapping on the Entities screen in Acumatica:

     

    Please note that I didn’t test it, and obviously your ship via codes are probably different, but you get the idea, right?

    Let us know if this worked!

     

    @Yuri Karpenko Looks like the notify customer is already in use. Which I don’t quite understand because Shopify is sending emails.  But our mapping looks like it should not be sending any.

     

     

    Yuri Karpenko
    Captain II
    Forum|alt.badge.img+6

    @KEL , the issue with the mapping you already have is that it has False in quotes. You need to put simply False in that field, no equal sign, no quotes, etc. Try that and check if it does anything.

    Yuri Karpenko | DM me if you need help building e-Commerce for your business or connecting it to Acumatica ERP
    Chris Hackett
    StacieJurczak41
    2 people like this
    • Chris Hackett
      Chris Hackett
    • StacieJurczak41
      StacieJurczak41
    K
    Freshman I
    Forum|alt.badge.img
    • KEL
    • Author
    • Freshman I
    • 20 replies
    • October 14, 2024
    KarthikGajendran wrote:

    @KEL  Please try to see a ship via that is not a common carrier(Will call option enabled) in the Shipment. When the Will Call Ship Via is used in the Shipment, then the connector will not send any update to Shopify from Acumatica. 

    @KarthikGajendran Not sure what you are saying here. Our ship via for these is CPU - Customer Pick Up not a carrier. But I see no will call option nor any carrier associated with that ship via code nr any way to add a carrier to that ship via code.  

    K
    Freshman I
    Forum|alt.badge.img
    • KEL
    • Author
    • Freshman I
    • 20 replies
    • October 14, 2024
    Yuri Karpenko wrote:

    @KEL , the issue with the mapping you already have is that it has False in quotes. You need to put simply False in that field, no equal sign, no quotes, etc. Try that and check if it does anything.

    @Yuri Karpenko I don’t want to stop Shopify from sending the notifications I just need it not to send notifications to any order with a ship via code of CPU. 

    Mind explaining the coding on that for me?

    =iif([BCShipments → Shipment.ShipVia]=’CPU’, False, True) 
     

    Would CPU be in quotes and what does the False, True values mean? 

    Yuri Karpenko
    Captain II
    Forum|alt.badge.img+6

    @KEL , absolutely!

    This mapping is overriding the value you send to the Notify Customer field in Shopify (columns External Object, External field in the screenshot above). And the formula you shared says:

    if the ShipVia code is CPU, then DO NOT notify the customers,

    otherwise - DO notify the customer.

    The formula looks right to me with single quotes around CPU.

    Yuri Karpenko | DM me if you need help building e-Commerce for your business or connecting it to Acumatica ERP
    Chris Hackett
    StacieJurczak41
    K
    3 people like this
    • Chris Hackett
      Chris Hackett
    • StacieJurczak41
      StacieJurczak41
    • K
      KEL
    K
    Freshman I
    Forum|alt.badge.img
    • KEL
    • Author
    • Freshman I
    • 20 replies
    • October 14, 2024

    @Yuri Karpenko Thank you for your help and patience with me. I will test this out and let you know. 

    Chris Hackett
    StacieJurczak41
    2 people like this
    • Chris Hackett
      Chris Hackett
    • StacieJurczak41
      StacieJurczak41
    K
    Freshman I
    Forum|alt.badge.img
    • KEL
    • Author
    • Freshman I
    • 20 replies
    • October 14, 2024

    Well my test order just confirmed shipment in our warehouse and I still received the email from Shopify that the order is on the way. 😕

     

    @Yuri Karpenko it did not work.

     

    Yuri Karpenko
    Captain II
    Forum|alt.badge.img+6

    @KEL , I just tested it, and it worked. One issue I see in your screenshot above is that the mapping line is not active. You have to click the Active checkbox, and then save the mapping.

    Here’s my recording of testing this mapping out: https://www.loom.com/share/b7f2c46045444869a51c9cb4609e37e8

    Hope this helps and resolves your issue!

    Yuri Karpenko | DM me if you need help building e-Commerce for your business or connecting it to Acumatica ERP
    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