Hi Ray, 

Thanks for reaching out. Do you already use the MISys Manufacturing integration for Sage 50? It enables better inventory control for eCommerce. It may be something worth inquiring about. 

Warm Regards, 
Erzsi

we do not use MISys

Are you using Sage 50 Assemblies?  It allows you to create the kits in Sage 50 before you sell them based on the stock items available.

Shirley Byard

Master Certified Consultant

[email protected]

yes, we use assemblies in sage. The issue is that if we have, say 10 items left, and we use it in 20 different kits, we cannot have all those kits available, even though we could build any one of them......

and also, we have no way of sending ebay the proper available inventory for even regular parts (not kits/assemblies)

Hi Ray,

Which ecommerce platform are you using on your website?

Scott

If you look at your inventory management page for this item, it will tell you how many you have. and which assemblies they are in.   Also, you can have the program create a PO for you when you get to a certain level. 

I think this will help you manage what you have. 

Shirley Byard

Shopping Cart Elite currently does our website, and sends the inventory feeds to Amazon and ebay - BUT it does NOT connect to Sage50, so that the big issue

Hi Ray,

Apologies for the slow reply.

I author the CartSpan ecommerce integration for Sage 50 and QuickBooks accounting systems, which has functionality that will meet your specified needs.

CartSpan as the ability to determine how many of a given assembly (kit) you could safely offer online by factoring first-level BoM item quantities. This resolves your "10 items left, used by 20" quandary referenced above.  CartSpan will also push stock levels for individual items (that may be contained in kits) to the ecommerce system.  Here is a blog post that describes the process in greater detail.

Normally, CartSpan can be run in near-real-time, updating stock values online within 90 seconds.  But given the more involved calculations referenced above, a maximum update frequency of 15-30 minutes would apply based upon the size of your product catalog.

I've been doing this for quite a while now, but have never crossed paths with Shopping Cart Elite.   At first glace, I like their message and they appear to have a well-developed API for these types of integrations.  

For QuickBooks users, CartSpan already has capability to automatically create assemblies during the order import process.  This could also be extended to Sage 50 if you are interested in sharing the cost of development.  To distinguish these offerings from real assemblies, we could make it configurable to flag on the text 'kit' in the item description.

If interested, feel free to give me a call at the number listed at the top of the CartSpan website and we can chat further.

Thanks,
Scott Wheeler