Skip to main content
Solved

Product Availability Issue with Shopify Connector

B
Jr Varsity III
Forum|alt.badge.img
  • bclark
  • Jr Varsity III
  • 69 replies

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!

View original
Did this topic help you find an answer to your question?

7 replies

kkeating24
Jr Varsity III
Forum|alt.badge.img
  • kkeating24
  • Jr Varsity III
  • 89 replies
  • 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
1 person likes this
  • Chris Hackett
    Chris Hackett
B
Jr Varsity III
Forum|alt.badge.img
  • bclark
  • Author
  • Jr Varsity III
  • 69 replies
  • October 9, 2024

@kkeating24 

No, that box is unchecked. 

 

kkeating24
Jr Varsity III
Forum|alt.badge.img
  • kkeating24
  • Jr Varsity III
  • 89 replies
  • 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
1 person likes this
  • Chris Hackett
    Chris Hackett
B
Jr Varsity III
Forum|alt.badge.img
  • bclark
  • Author
  • Jr Varsity III
  • 69 replies
  • 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
  • 374 replies
  • 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
2 people like this
  • Chris Hackett
    Chris Hackett
  • B
    bclark
B
Jr Varsity III
Forum|alt.badge.img
  • bclark
  • Author
  • Jr Varsity III
  • 69 replies
  • October 10, 2024

@Yuri Karpenko 

 

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

Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • 2754 replies
  • 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*.

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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