Question

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

  • 21 February 2024
  • 5 replies
  • 79 views
bryanb39
Rank
Userlevel 6
Badge +5

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.  
 

https://www.fiverr.com/acudatica

5 replies

KarthikGajendran
Rank
Userlevel 7
Badge +2

@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. 

Technical Product Manager- Retail Commerce
bryanb39
Rank
Userlevel 6
Badge +5

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.  

https://www.fiverr.com/acudatica
bryanb39
Rank
Userlevel 6
Badge +5

@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?

https://www.fiverr.com/acudatica
bryanb39
Rank
Userlevel 6
Badge +5

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

https://www.fiverr.com/acudatica
simonliang91
Rank
Userlevel 5
Badge +1

@bryanb39 , I will look at it next week.

Reply


Terms & ConditionsCookie 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