Solved

Tracking of Non-Stock Items in BigCommerce

  • 5 March 2024
  • 4 replies
  • 82 views
T
Rank
Userlevel 2
Badge

We use non-stock items to create bundle items such as a lamp and shade. We are tracking inventory of these items by running a report to generate quantities and importing those quantities into an attribute. I would like to use this attribute to update the inventory level of the non-stock item in BigCommerce and I have mapped it to do so in the entity settings.

However the numbers do not update in BigCommerce and remain as zero. I was wondering if anyone has any insight on why this might be the case or if they have another solution they are using that works. I could just map the attribute into a custom field, but I would rather that these stock and non-stock items are handled in the same way to prevent confusion.

 

Mapping of attribute to inventory level on Entity screen

 

I can see in event logging that Acumatica is sending the request to update the inventory level to the number stored in that attribute, but it remains 0 in BigCommerce.

\"inventory_level\":40
Stock quantity remains 0 in BigCommerce

 

icon

Best answer by freddydelrio39 6 March 2024, 03:10

View original

4 replies

P
Rank
Userlevel 3

Curious if you tried using a Kit as the bundle instead of a non-stock item.

T
Rank
Userlevel 2
Badge

@pauldubuque13 Yes, we did. I believe we decided against using them due to this issue: Non-Stock Kits with manually lotted components | Community (acumatica.com)

And I think we did not want to create them as stock kits as we want to store the components separately in our warehouse although I’m not 100% sure on this. Maybe @courtneyb could clarify

F
Rank
Userlevel 2
Badge

@tararosenthal You are able to sync Attributes to a lot of fields in BigCommerce, however Product Availability is not one of the fields where this is possible. It would require a customization on the BC side to switch the value which is complicated. 

I have had another client that did not want to export any product availability from Acumatica to BigCommerce. The way we were able to work around this was to create a GI in Acumatica with the Inventory ID and the product availability they wanted (you could display the Stock Item and this Attribute you created). They would export this excel file every morning from Acumatica and manually import it into BigCommerce. 

-FDR ~ Acumatica Consultant ~ Ecommerce Specialist
T
Rank
Userlevel 2
Badge

@freddydelrio39 Thank you for clarifying that that mapping does not work. I think we are going to set up some processes so that everything is tracked as an attribute and mapped as a custom field due to the above issue and this bug: BigCommerce - Product Availability & Inventory Settings Function Gap to Allow Preorders? | Community (acumatica.com)

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