Shopify Orders show as "Balance Due"

Gabe Parr

• July 22, 2022 19:01

We have integrated orders specifically assigned with tags to be pushed from NetSuite to Shopify and hard-coded "paid" into the field "order.financial_status"

However, when the order syncs it shows "Paid by Customer" = $0.00 and below that it states "Balance (customer owes you)" = whatever the total value of the order is.

Has anyone else experienced this and how does one fix it?

I have tried various methods of hard-coding the order.total_outstanding field with no success. 

0

• 

  KHAISAR AHMAD QA Lead

  • August 12, 2022 07:41

  

  

  

  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

  • August 12, 2022 14:13

  

  

  

  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

  • August 12, 2022 14:16

  

  

  

  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

  • August 12, 2022 14:34

  

  

  

  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.