Skip to Content
Menú
This question has been flagged

Hello, could someone explain to me how I can import products with the location or warehouse where they are located and the quantity?

Avatar
Descartar
Best Answer

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.


Avatar
Descartar
Best Answer

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.

Avatar
Descartar
Related Posts Respostes Vistes Activitat
2
de gen. 21
4829
2
de juny 18
4750
1
de set. 17
9289
0
de nov. 15
3081
6
de maig 24
3168