Max quantity that can be assembled for a kit. Can be used to update commerce store

  • 1 March 2024
  • 3 replies
  • 52 views
mahmoudsabaa32
Rank
Userlevel 1

This topic provides a workaround to calculate the max possible quantity that can be assembled for a non-stock kit or a stock kit. And uses an import scenario to update an attribute on the non-stock kit for the max availability. 

Assumptions:

1-Create an attribute KITAVAIL and assign to the non-stock kit class
 

2-There is a condition to filter on the warehouse storing the components used to assemble the kit
 

 

Hint: The GI pulls stock and non-stock kit. it can be enhanced to only pull non-stock kit. 

Precaution: The import scenario that I attached is only updating the availability for non-stock kit. it will FAIL on stock kits, you might need to create another import scenario for this purpose. 

How to use it:

1-Import the GI:”Kit Max Availability.xml”

2-Create import scenario:IN202000-UpdateKitaAvailability.xml

 

Since the import scenario is based on a GI it is dynamic, you can run it manually or run using a schedule. 

 

 

Screenshot from the import scenario :
 

 

Commerce connector use: The import scenario will show/hide the non-stock kit based on the availability using the formula in the above screenshot 

“=IIf( [InventoryItem_Formulaffdc1a6b00e64948bf4b9f59d7eb191d]>0, 'Store Default', 'Set as Unavailable' )”

 

Screenshot from the GI results
 

 

2 Attachments

3 replies

Yuri Karpenko
Rank
Userlevel 7
Badge +6

@mahmoudsabaa32 , this is a good workaround, thank you! However, Acumatica can do better, because we need those max available quantity for e-commerce integrations. So, it would make sense to put a routine into Acumatica business logic that would keep track of components and update INSiteStatus table upon changes to the components’ inventory counts. This way, we could utilize standard Acumatica commerce connectors (to BC and Shopify).

I assume approach above can work for non-stock kits only, which is fine.

Yuri Karpenko | DM me if you need help building e-Commerce for your business or connecting it to Acumatica ERP
mahmoudsabaa32
Rank
Userlevel 1

@Yuri Karpenko You are absolutely correct. few notes here

1-The above method can work for both, stock and non-stock. 

2-In the import scenario I undated the non-stock item to show or hide it based on the quantity available for assembly. I had customers that used the Entity mapping to pass the attribute value to a custom field in BigCommerce as per the screenshot below
 

3-For stock items. Instead of using the Kit availability attribute, you can change your import scenario to push the quantity to the Availability adjustment under the commerce tab, which will affect the availability for the stock kits right away without the need for any changes in the mapping
 

 

4-Lastly, the import scenario should be scheduled to update the kit availability rather than running it manual, which automates the whole process 
 

 

Yuri Karpenko
Rank
Userlevel 7
Badge +6

@mahmoudsabaa32 , excellent points! Thank you very much!

Yuri Karpenko | DM me if you need help building e-Commerce for your business or connecting it to Acumatica ERP

Reply


Terms & ConditionsCookie 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