Skip to main content

Shopify Orders show as "Balance Due"

Comments

4 comments

  • KHAISAR AHMAD QA Lead

    Hello Gabe Parr
    As per the Shopify API documentation, the API we use "POST Orders" do not support creating the Orders directly in Paid status. 
    As per the review you should be sending either Pending or Authorized statuses, post which you will be able to capture the Order in Shopify Admin portal. By this process, once you capture the Order from UI, the related transaction will as well be created and also the related text i.e., Balance and Paid amounts will 

    Hope this answers your question. Please let us know if you have any further questions. 

    cc Sree Vani Amara


     
    
    
    0
  • Gabe Parr
    Awesome Follow-up
    Engaged
    Celigo University Level 1: Skilled

    Perhaps that is the case with some, but our configuration is better served to have the status as "paid" since in this instance the transactions have already been captured and accounted for.

    For more information on how we ended up solving this issue - as it appears you work for Celigo - you should be able to access Ticket 121681 and review it.

    For anyone else following this thread, please let me know if you would like to see what we came up with.

    0
  • Justin Bodin
    Great Answer
    Celigo University Level 2: Seasoned
    Engaged

    Gabe Parr yes! Please, I'd like to see the solution too. Not sure if it matches your use case, but we have a good number of credit card sales orders which reps enter directly into NetSuite where we authorize, fulfill, and then bill/capture. I would like to bring those billed orders over to Shopify as "paid" status, as you suggest.

    Thanks for sharing!  

    0
  • Gabe Parr
    Awesome Follow-up
    Engaged
    Celigo University Level 1: Skilled

    Justin Bodin

    Sure! We have a Custom flow that takes the Order from NetSuite and sends it to Shopify to fulfill - meaning the authorize/capture/bill is already completed. So I am not sure if that flow follows your processes or not. Using the Custom Flow allows us to have some better isolation from the Standard flows available for use between Shopify and NetSuite that we use in their intended use.

    In our case, we ended up using a combination of hard-coded mapping and also added a transformed mapping as follows:

    So #1 and #2 are the hard-coded entries - hence the "" on the word(s). For #3 - in the NetSuite Saved Search, we made sure to export this field and named it AmountTotal for Transformation prior to Import to Shopify.

    1

Please sign in to leave a comment.