Custom Inventory Tracking Add-on

[extragear]

Greetings:

Its mentioned in the documentation for the Shopsite version 10 that,

you can use a customer inventory tracking add-on if you have a third-party add-on module.


So, Is there third-party add-on module available? Or is it the case we have to design something ourselves?

Thanks

Tim Sweeney

Cycleluggage.com

[Jim]

I haven't heard of any being developed yet. But I would think that the application would need to be developed to meet your specific needs so it would probably need to be developed specifically for your site.

[extragear]

Jim -

Thanks for the clarification. Yes, that makes sense. In our situation:

We use MOM (mail order manager) to handle our backend operation. Then we have our suppliers inventory. For example about 50% of our orders are dropped shipped. Our suppliers for the most part provide us with a FTP area where we can log in and get a excel file containing their (the suppliers) part number and the related inventory count in each of their warehouses. This info is updated every hour.

Combining the inventory count from our warehouse (what MOM shows) and the inventory count from the suppliers while taking into account the warehouse location probably needs a custom solution for integrating into Shopsite.

Although I had the idea of using Access to combine the data from the various sources and create one centralized database. For example the database would have the sku (as used in Shopsite), the total combined inventory count, then the inventory count on a per warehouse basis with an associated zip code for possible time in transit use.

We could then take this centralized database representing,

SKU number, total inventory count, inventory count on a per warehouse basis and upload it to the MYSQL database that our host Lexiconn provides.

At this point the third party application would query this database to determine if the item was in stock any where. Where it was in stock. Provide time in transit estimates when the shopper clicks recalculates after
entering their zipcode. As well as providing shipping options other than just standard ground UPS. For example, we could provide an additional shipping option other than free standard ground ups such as $12 to ship standard ground UPS from suppliers warehouse.

While I am not a programmer, I would be interested in hearing whether theoretically what I have suggested above is possible using a custom add-on such as the inventory addon. I realize that probably other add-ons would be needed to achieve the other objects such as querying the MYSQL database to determine time in transit information.

Any comments or insight would be greatly appreciated.

Thanks

Tim Sweeney


Cycleluggage.com