Перейти к содержимому
Меню
Чтобы взаимодействовать с сообществом, необходимо зарегистрироваться.
Этот вопрос был отмечен
2 Ответы
889 Представления

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

Аватар
Отменить
Лучший ответ

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.

Аватар
Отменить
Related Posts Ответы Просмотры Активность
2
янв. 21
5113
2
июн. 18
4892
1
сент. 17
9500
0
нояб. 15
3219
6
мая 24
3414