Jump to content
thirty bees forum
  • 0

Advanced Stock Management and CSV



I have multiple suppliers for one product. I also use advanced stock. I also use CSV import. Because if You have 300 product and each of them can have 3 to 12 combination then it's impossible to put all this in database without automation. Now I discover that if all is OK and You need to change something in products then it's very easy to make an CSV file and import it. Unfortunately this will mess up with stock quantity. For example if You have 5 different supplier then importing an CSV where all five are present, TB also generates stock movement. If there are already 10 item, then with first supplier there is movement to add 10. Next product with the same ID and product code will make stock movement to add summary of all existing items, in actual case it adds 20. With fifth supplier you have 320 item on your stock. Is this a bug or I'm making something wrong ? Because if this isn't bug then this CSV isn't useful. There are extra stock movements in SQL table stock_mvt. If i delete these, is this solution ? Or if I delete something from SQL table it makes something worse ?

Thank You

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...