Hello, could someone explain to me how I can import products with the location or warehouse where they are located and the quantity?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
Hi,
You can follow the steps to import the product,
1- Add 'Location' column in the sheet.
2- Import the sheet.
Result
Hope it helps.
I'd suggest you go to
Inventory -> Operations -> Adjustments: Physical Inventory
From here, got to Actions (cog symbol) -> Import records
This allows you to download an "Import Template for Inventory Adjustments".
Then, all you need to do is to add a new column "location" in that xlsx File which holds the locations (i.e. "WH/Stock"), fill in your data, and import the file.
In theory, your import file could be as simple as this:
Any kind of new import process should however always be tested first, to see what the actual result will be. You could do so, and play around with the fields, for example in demo.odoo.com - or, obviously better, in a staging environment of your own database, so you can see what certain imports will lead to given your products may have stock levels set already.
Heads up: You'll most likely encounter issues when trying to create new products while importing stock levels, so make sure you have your products (for example by the means of yet another import you do beforehand in the product list) and locations already set up.
Don't forget to hit "Apply" when the result is ok.
Another approach, if you don't want to deal with imports: directly fill up the list in Odoo (same path, Inventory -> Operations -> Adjustments: Physical Inventory) - this list allows for directly entering the counted quantities of your products / creating new stock levels in new locations.
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign upRelated Posts | Replies | Views | Activity | |
---|---|---|---|---|
|
2
Jan 21
|
4742 | ||
|
2
Jun 18
|
4711 | ||
|
1
Sep 17
|
9235 | ||
|
0
Nov 15
|
3036 | ||
|
6
May 24
|
3065 |