Skip to main content
Solved

Shopify connector change variant Inventory Policy based on mapping


Forum|alt.badge.img

Anyone know if it’s possible to set the variant Inventory Policy in Shopify based on the Item Status of the stock item in Acumatica? I’ve played around with the Export Mapping under the Stock Item entity but I can’t seem to get it to work. The Inventory Policy is a checkbox in Shopify so I tried the below formula but it had no affect in Shopify:
 

 

Best answer by KarthikGajendran

@mikeho  Which version are you using? in 22R1 this changed as per the below table. 

 

Here No Changes means that connector does not modify the existing value in Shopify. Yes means sets the check box as True and No means sets the checkbox as False. 

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

7 replies

brendan91
Semi-Pro III
Forum|alt.badge.img+1
  • Semi-Pro III
  • 92 replies
  • April 6, 2023

You can manage inventory policy on the stock items screen under the ecommerce tab.

 For future reference, if you want to see what fields you can map open up any screen in Shopify. For example open up an order or the products screen in Shopify and add .json at the end of the order or item URL. This is the data used by the connector to bring order information or item information into Acumatica and vice versa. If you open the .json in Firefox browser, the browser will organize the data in the json to be easier to read.

 


Forum|alt.badge.img
  • Author
  • Semi-Pro II
  • 228 replies
  • April 6, 2023

@brendan91 - we use Template items in Acumatica; it seems that this setting on the variant is only controlled by the Ecommerce tab on the Template Item. Is that correct? I’ve tried adjusting the settings on the Stock Item and nothing happens until I make the change to the Template Item.

This would not be ideal because we would need the Inventory Policy to be managed by the matrix items (independent from the Template). 


brendan91
Semi-Pro III
Forum|alt.badge.img+1
  • Semi-Pro III
  • 92 replies
  • April 7, 2023
mikeho wrote:

@brendan91 - we use Template items in Acumatica; it seems that this setting on the variant is only controlled by the Ecommerce tab on the Template Item. Is that correct? I’ve tried adjusting the settings on the Stock Item and nothing happens until I make the change to the Template Item.

This would not be ideal because we would need the Inventory Policy to be managed by the matrix items (independent from the Template). 

Gotcha, I understand your issue. I have not yet encountered this scenario, but this does seem like a design issue. I would like to learn how to work around this in the future as well.

Maybe @josh.fischer can weigh in.

 


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

@mikeho  Which version are you using? in 22R1 this changed as per the below table. 

 

Here No Changes means that connector does not modify the existing value in Shopify. Yes means sets the check box as True and No means sets the checkbox as False. 


Forum|alt.badge.img
  • Author
  • Semi-Pro II
  • 228 replies
  • April 24, 2023

Hi @KarthikGajendran - we are on 21R1 (in the process of upgrading to 22R2). Could it be a matter of this working correctly once we are finished upgrading?


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

@mikeho  That's right. But as always before the upgrade please test all your scenarios. 


Forum|alt.badge.img
  • Author
  • Semi-Pro II
  • 228 replies
  • June 22, 2023

@KarthikGajendran - can you advise where I can find that table (in the screenshot you provided) in the documentation? I’d like to review this further in depth and see if there are any changes in 23R1.


Reply


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