Skip to main content
Question

Sync item status on individual matrix items


Forum|alt.badge.img

I am having trouble controlling sales of different matrix items. We sell both on Shopify and enter order directly in Acumatica, so the item status field is important when we need to shut off sales. Most of our items are set up at template items, each template has different package sizes. We often have to set the item status to “No Sales” when we are sold out of a package size.

When we have to turn off multiple matrix items under the template, it often times fails in the sync to Shopify saying “No matrix items are generated”. This is turn does nothing on Shopify and will allow sales to come down on items we are sold out of.

Has anyone else experienced this issue with the ecommerce connector? Ideally we want to have template items so we can have multiple options on one product page, but we want to control each matrix item like it is a single stock item.

3 replies

simonliang91
Acumatica Employee
Forum|alt.badge.img+1
  • Acumatica Employee
  • 76 replies
  • March 13, 2024

@mralyea , during the TemplateItem sync process, the connector will check the status of matrix items, we only export the matrix item with “Active” status. If no matrix item with Active status, connector will throw the error message.

If you want to control the item in Shopify, you can setup the Availability in each matrix item, if you set the “When Qty Unavailable” to “Set as Unavailable” and the inventory goes to 0, it will not be purchased in Shopify.
 

 


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 36 replies
  • March 14, 2024

Hi @simonliang91 that is what we currently do, however we need to mark the item as no sales so we don’t take any direct entry orders that come in via the mail or phone. So then we still get the error on many template sync records. The issue with the error sitting on the template is we usually have to manually resync that record if we need to turn it back on or need to update shopify with new product related information.


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 36 replies
  • March 14, 2024

Also a side question, what is that Availability Adjustment field? Is that apart of a newer version? 


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