This is a question not really about "programming" (is not specific to any language or database), but more of design and architecture. It's also a question of the type "What the best way to do X". I hope does no cause to much "religious" controversy. In the past I have developed systems that in one way or another, keep some form of inven...
Hi there, We currently have an inventory management system that was built in-house. It works great, and we are constantly innovating it. This past Fall, we began selling products directly on one of our websites via a Shopping Cart checkout. Our inventory management system runs off a server in the office, while the three websites we c...
As I often work without a fast or even any internet connection, I have a webserver that serves commonly used documentation, for example: Various programming languages (php, Python, Java, ...) Various libraries (for example pthreads) Various open books RFCs IETF drafts Wikipedia (text-only, the uncompressed English dumpfile weighs 20GB!...
I'm about to start on a little project i'm trying to do where I create a C++ program to store inventory data into a file ( I guess a .txt will do ) • Item Description • Quantity on Hand • Wholesale Cost • Retail Cost • Date Added to Inventory I need to be able to: • Add new records to the file • Display any record in the f...
Hi, on my website I sell unique items. I have programmed it so that on the selling page, users can select any amount of these items, and it calculates the cost. The key is that I only have 1 of each of these items. So I need the shopping cart system to not allow the payment to go through unless it is available. I've been searching for a...
Hi, I'm looking for some help understanding how to generate pages from a database to create a catalog of items, each with different URLs. All I can seem to find through google are products that will do this for me, or full e-commerce solutions. I don't want a shopping cart! Just an inventory. Also, perhaps someone could recommend their ...
I would like to design a Inventory system. Some key features listed below. Multi User Multi Branch Support Online and offline Invoicing Multi Currency Language requirements : - C# 2.0 SQL2005 Server I appreciate your valuable suggestions and ideas to design perfect Inventory system. If you have any Database sample model to des...
Hi, I am new to Spring framework. I was recently part of a Task where an estimation for a Spring/Hibernate based web application was being prepared. We had Functional & Business requirements and detailed Use Cases. I was asked to prepare a list of the inventory or Work Item types (Controllers, Entities, DAOs, ServiceClasses, Application...
Hi magento users, Is there any possibility for connecting an external inventory management program with magento? Our customer wants to keep magento's stock synchronized with the "real" stock of his products. ...
Hello, I would like to ask a rather, general, high-level introductory kind of question regarding inventory management. So, I was wondering if anyone on SO had any experience/knowledge, or worked with in the past in inventory, supply chain, procurement management settings. What typical problems or challenges one might find in this field...
What's the best relational structure for implementing a FIFO product inventory? I need that the product entries be stored grouped by entry date and entry price, but sales from the existing stock be made in a First-In-First-Out manner, in which the product quantity representing the sale would be subtracted from the oldest entries first. T...
Hi. Can anyone recommend a good open-source inventory-agent, which would help enumerate both the running software and the installed hardware? I'm actually looking to couple SIGAR (or alternatives) with such agent, to integrate the servers statistics into a single view. Thanks in advance. ...
Our current database layout for store inventory includes a table that houses a record for each item and includes the item attributes such as price, cost, description, SKU, etc. Each store then has a table that has the SKU and the Quantity, and a few other attributes that are different for each store depending on the SKU. Although this ...
I am looking for a free/commercial PHP based inventory management software with source code. We would like to integrate this software with our core application. Any leads ? ...
I'm upgrading an inventory system for a jewllery store that was originally built with MS Access. The application stores items, customers, vendors, and displays data about items stored. Reporting tool should be considered to generate reports for items in a printable format. The system should be built in C#, but I've not made the decisio...
Hello, This is not a question related to a specific language, rather on the correct methodology of architectural of handling inventory. Consider the following structure for storing software: platforms (platformID*, platformName) titles (titleID*, titleName) And the following is a joiner table for unique products products (platform...
Dear Stackoverflowers I would like to develop a Network Inventory application that works on any operating system. Reports on every possible resource attacehd to a network. Reports all pertinent details of hardware and software. Thats (and i hate to use the phrase) my "End Game". However I am running before i can crawl here. I have no e...
I have two tables in my database, one for In and one for Out. They have two columns, Quantity and Price. How can I write a SQL-query that selects the correct price? In example: If I have 3 items in for 75 and then 3 items in for 80. Then I have two out for 75, and the third out should be for 75 (X) and the fourth out should be for 80 (Y...
Inventory Requisition Process: Whenever a user requires inventory, user generates an inventory requisition, and if the inventory is available, the inventory will be directly issued and user’s inventory account will be updated. In case the inventory is not available, the purchase order will be generated for the required inventory to the c...
Hello, I'm trying to create a javascript avatar. E.G with Head Items, body items etc... I have a PHP script that queries the database and retrieves the current items the avatar/user is wearing, it's response is in a serialised array. The item/avatar images are in E.G: http://blahblahblahBlah.com/graphic/itemtype/id.png Thank you in adv...