Skip to main content
Question

Amount must be greater than zero for sale transactions when importing orders to Shopify

  • February 21, 2024
  • 6 replies
  • 264 views

bryanb39
Pro II
Forum|alt.badge.img+6

When exporting orders from Acumatica using the Shopify connector, it is requiring that the sale be > 0.  
 

Error on order : Transactions is invalid;
Error on transactions : Amount must be greater than zero for sale transactions


We use Acumatica to create replacement orders, giveaways, affiliate orders that have no revenue. Acumatica makes it easy to use Reason Code, plus it’s quicker to order from Acumatica than Shopify.

 We would like these orders to be in Shopify so the customer can see the history and so our 3PL can fulfill those orders using our current workflow.  

Has anyone experience this or know of a work around, other than creating the order in Shopify.  
 

6 replies

KarthikGajendran
Acumatica Moderator
Forum|alt.badge.img+3

@bryanb39  Shopify API doesn't allow to create 0$ order through APIs. 

@simonliang91  Could you please check if it is possible to create 0$ from Acumatica to Shopify? If not in Rest API, then may be using GQL. 


bryanb39
Pro II
Forum|alt.badge.img+6
  • Author
  • Pro II
  • February 21, 2024

Ah yes, that sound familiar.  So we may need to something like a penny of freight and write off in bulk periodically or with a BE for a quick fix.  I’m trying to get Customer Service and Marketing to use Acumatica more, this is a sticking point.  


bryanb39
Pro II
Forum|alt.badge.img+6
  • Author
  • Pro II
  • February 23, 2024

@KarthikGajendran @simonliang91 
With the API it appears like we should be able to create a $0 order with a Discount Code. 

I was trying to use Export Mapping to use a enter a discount code or a discount amount into the discount fields in Shopify, but I’m getting the error: “Object reference not set to an instance of an object.” when syncing.  

Do you have suggestions on how to get that mapping to work?


bryanb39
Pro II
Forum|alt.badge.img+6
  • Author
  • Pro II
  • March 22, 2024

@KarthikGajendran @simonliang91 Were you able to find anything new on this?  Any ideas on the best way to handle it? 


simonliang91
Acumatica Employee
Forum|alt.badge.img+1
  • Acumatica Employee
  • March 23, 2024

@bryanb39 , I will look at it next week.


  • Freshman I
  • June 19, 2025

We are working through processing warranty orders for Shopify B2B, but seeing that the sync errors when exporting a $0 order from Acumatica.

I've tested using discount codes to get the order to export from Acumatica but if its a 100% discount and the order total is $0 it fails

Looked at exporting these with a small amount of $.01 either on the item or on freight totals but that comes with it own problems - Shopify sees it as paid and wants to create a prepayment for the penny on the next sync…
I can filter on the payment entity to exclude where the Shopify payment gateway is null to prevent the payment from being created in Acumatica - but after the initial export sync to Shopify happens we cant affect the order total

Any ideas on how we can accomplish this or any examples of what other customers are doing? We are on 24.118, upgrading is not an option at this time.

Thanks