Skip to main content

Shopify Order Number vs. Order Name mapping

Comments

4 comments

  • Official comment
    Sree Vani Amara Senior Product Manager

    Hi David,

    Thank you for reaching out to us. Would like to understand why the customers create a new custom field to store the name in addition to default Celigo mapping. How do they plan to use that field? How can we make it more usable ? 

    Thanks,

    Vani

     

  • David Gollom Strategic Partner
    Top Contributor
    Celigo University Level 4: Legendary
    Answer Pro
    Great Answer
    Engaged

    Hi Sree,

    My question is half just curiosity.  I don't see the "number" as useful to anyone really. The name is what's seen within Shopify and the order Id is what you need to access the record via API.  From a usability perspective I sorta don't like using Otherrefnum to store the order name since the default label for that field is PO Number. Multichannel NetSuite users would have a mix of real customer PO numbers in that field along with shopify order numbers.  We've decided to create a field we call "external order number" for these types of users and another field call "external ordering system."  

    In this example the NetSuite users relabeled the PO Number and as you can see they prefixed their order names in Shopify.  This makes the Shopify Order Number field sort of useless.   

     

    1
  • David Gollom Strategic Partner
    Top Contributor
    Celigo University Level 4: Legendary
    Answer Pro
    Great Answer
    Engaged

    The other little usability "nice-to-have" that we implement for our customers (really for me??) is a deep link to the Shopify transaction on the NetSuite Sales Order/Invoice.  If you stored the store URL in NetSuite this could be totally data driven. I haven't seen the store URL so I hard code part of the path in a NetSuite formula sourced text field.  Below, you see the Shopify Admin URL which takes the user directly to the Shopify order.  It's a nice feature in my opinion.  

    2
  • Sree Vani Amara Senior Product Manager

    Thanks for taking the time to explain the details, David! We've added them to our backlog for evaluation. 

     
    0

Please sign in to leave a comment.