Question

Sync item status on individual matrix items

  • 13 March 2024
  • 3 replies
  • 29 views

Userlevel 1
Badge

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

Userlevel 5
Badge +1

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

 

Userlevel 1
Badge

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.

Userlevel 1
Badge

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

Reply


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