My use case is a little strange, but here's part of how we would like our inventory to work:
We have an ebay store and have written software to download our active items to import into the inventory. Initially we were looking to just do a simple CSV import, but found that we can't import quantity and this would've introduced problems with items that change. We added database access to our program to dump the active items directly into Odoo's database. This is working fine for the most part, except the On Hand Quantity does not always reflect what the database reports.
When importing initially, it is correct, but when we update the quantity (through the database, through odoo, through selling an item), it breaks and gives a seemingly random number in return.
The tables that we change when importing data are in this order:
Is there just a table that we're forgetting to update, or is it something to do with how it calculates quantity? If it's the latter, where can I change that? We have no need for the system to calculate the quantity, just deduct when we sell.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 4/21/16, 5:14 PM|
|Seen: 582 times|
|Last updated: 5/17/16, 2:24 AM|