Skip to main content
Answer

Product Availability Issue with Shopify Connector

  • October 9, 2024
  • 7 replies
  • 129 views
B
Varsity I
Forum|alt.badge.img

Hello, 

We have our Shopify store setup to use Available for Shipping. The On Hand amount is 1,423 but it’s in a quality location and cannot be sold. The available for shipping amount is 0. However, in Shopify it’s showing the total amount on hand. 

Does anyone know what can be done to fix this? Thank you!

 

 

 

Best answer by Yuri Karpenko

@bclark , there could be a couple issues, but my troubleshooting would be:

  1. Check the SYNC HISTORY screen, and make sure that the product you’re talking about has a Processed status for the Stock Item entity. Also, click on the External ID link in the SYNC HISTORY and verify that it takes you to the right product in Shopify.
  2. Check SYNC HISTORY - Product Availability screen by filtering on the External ID, and make sure it’s Processed, and the date is recent. Better yet, manually sync that record.
  3. When filtered on the Product Availability entity on the SYNC HISTORY screen, click on the ERP ID link - it will take you to the Inventory Details screen. Observe the data and verify it’s correct (you will want to add locations one-by-one, because the popup window won’t have filter on the warehouse / location).

If the issue is still there, could you please share the screenshots or a screen recording of your troubleshooting?

Thank you and good luck in fixing this up!

7 replies

kkeating24
Varsity III
Forum|alt.badge.img+1
  • kkeating24
  • Varsity III
  • October 9, 2024

just a hunch, but does your Quality Location in your warehouse include inventory in QTY Available:

 

--attachment is the great fabricator of illusions; Reality can only be attained by someone who is detached. -s.w.
Chris Hackett
B
Varsity I
Forum|alt.badge.img
  • bclark
  • Author
  • Varsity I
  • October 9, 2024

@kkeating24 

No, that box is unchecked. 

 

kkeating24
Varsity III
Forum|alt.badge.img+1
  • kkeating24
  • Varsity III
  • October 9, 2024

You have 2 ACU inventory locations that are feeding your Shopify Location “Pick”.  Are both of those 0 available?

You’ve run the Prod Availability sync recently to reflect most current balances?

 

--attachment is the great fabricator of illusions; Reality can only be attained by someone who is detached. -s.w.
Chris Hackett
B
Varsity I
Forum|alt.badge.img
  • bclark
  • Author
  • Varsity I
  • October 10, 2024

@kkeating24 

Yes both Acumatica Locations have 0 Available. The one location has 1,423 on hand, all in that QC location that is not counted towards Available. 

And yes, I’ve rerun the Prepare and Process screens for Product Availability, and nothing changes. 

Yuri Karpenko
Captain II
Forum|alt.badge.img+6
  • Yuri Karpenko
  • Captain II
  • Answer
  • October 10, 2024

@bclark , there could be a couple issues, but my troubleshooting would be:

  1. Check the SYNC HISTORY screen, and make sure that the product you’re talking about has a Processed status for the Stock Item entity. Also, click on the External ID link in the SYNC HISTORY and verify that it takes you to the right product in Shopify.
  2. Check SYNC HISTORY - Product Availability screen by filtering on the External ID, and make sure it’s Processed, and the date is recent. Better yet, manually sync that record.
  3. When filtered on the Product Availability entity on the SYNC HISTORY screen, click on the ERP ID link - it will take you to the Inventory Details screen. Observe the data and verify it’s correct (you will want to add locations one-by-one, because the popup window won’t have filter on the warehouse / location).

If the issue is still there, could you please share the screenshots or a screen recording of your troubleshooting?

Thank you and good luck in fixing this up!

Yuri Karpenko | DM me if you need help building e-Commerce for your business or connecting it to Acumatica ERP
Chris Hackett
B
B
Varsity I
Forum|alt.badge.img
  • bclark
  • Author
  • Varsity I
  • October 10, 2024

@Yuri Karpenko 

 

Thank you. I’m still seeing the issue. I sent you a DM. Thanks!

Chris Hackett
Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • December 24, 2024

Hi ​@bclark were you able to find a solution? Thank you!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
Terms & ConditionsCookie settingsAccessibility statement
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