First on Hand stock with import from XLSX

Question

Dear All,

I'm using Odoo Online and i have make more than 100 items products. for now i want input stock in warehouse to Odoo, but if manually is wasting many time. If any quick import with data from excel?

For example i will export 1 product from odoo product for get the ID product, and then i can't find on hand stock. please help me

Binkal Vadaliya (biva) · Answer

To import stock, follow these steps:

1. Navigate to Inventory > Product and export the product.
2. In the exported Excel file, add two fields: *Location* and *Counted Quantity*.
3. Enter the appropriate values in the Excel file.
4. Import the updated file back into Inventory > Inventory Adjustments.

I've also attached an Excel file to help you analyze the flow.
https://docs.google.com/spreadsheets/d/1TX5m4H-RG9q3URbIFGTofuire35mKRo_/edit?usp=sharing&ouid=113238170375315008226&rtpof=true&sd=tru

İlgili Gönderiler	Cevaplar	Görünümler
import product with stock Çözüldü stock import	4 Haz 24	13383
Import stock in products stock import odooV8	3 Haz 24	9495
large Purchase Order excel import import excel purchase_order	4 May 24	3034
OdooV13 write a module to get an excel file as input Çözüldü import excel odooV13	3 Kas 23	7567
Upload excel and import to sale order line Çözüldü import sale.order.line excel	1 Ara 21	4845

Bu soru işaretlendi

Enjoying the discussion? Don't just read, join in!