Emergency

If you need this how-to, your best option is to use the Lynx web browser in a terminal session on the server. It is text-mode only. Obviously, you will first copy the backup on the server file-system.

Terminal based

Often, you don’t need to restore images or attachments. They are recorded in the  server filesystem. In this case, you can remove the filestore/ part from the backup file and use the one already on your server (see below). It is the heavier part of the backup. Assuming the database name is www and the owner is odoo, proceed as below (this way you can reuse your filestore/ folder) :

$ sudo su postgres
$ dropdb www
$ createdb -O odoo www
$ psql www < dump.sql

Restoring database from web browser

First, increase http server time-out, don’t forget to restart the daemon.

Following nginx documentation, you can set client_max_body_size to 25M ( or any value you need ) in the following context : http, server, location. So just set it wherever you want. For example :

# increase size to 300 MB for restoring backups
client_max_body_size 300M;

Launch the database manager https://[odoo_url]/web/database/manager and follow the instructions to upload your backup file.

$ dropdb database_name

$ createdb new_database_name

$ createdb -O db_user_name new_database_name

/var/lib/odoo/filestore/[new_database_name]]

$ psql new_database_name < dump.sql

$ pg_restore -d any_database_name -U root -C dump.sql

$ cat backup.dump.zip | unzip | psql new_database_name

In Odoo, inventories are managed through Inventory / Inventory Control / Inventory Adjustments. Importing your stock, means creating an inventory adjustment. You will import your first stock (initial inventory), using exactly the same procedure as later stock’s imports.

Minimal prerequisites

• At least one warehouse created (should be done automaticaly)
• Products and variants already imported

First obvious option is to create a new Inventory Adjustment, checking the « All products » option. Then press Start Inventory button : products will be populated. You can modify stock inline in Real Quantity column. But with lots of products, you will prefer to do that in a spreadsheet :

1. keep your first Inventory Adjustment in draft mode,
2. go back to Inventory Adjustments, select your inventory, export it (select the required fields as the below list),
3. update your spreadsheet and import it back.

Required fields to export / import

• Company (company id) : company_id/id, usually « base.main_company »
  (this field should have only one record)
• Inventoried Location (warehouse) : location_id/id, with only one warehouse it will be « stock.stock_location_stock »
  (this field should have only one record)
• Inventory Reference (inventory name) : name, whatever
  (this field should have only one record)
• Inventories / Product (product external id) : line_ids/product_id/id
• Inventories / Product Name : line_ids/product_name
• Inventories /Checked Quantity (product stock) : line_ids/product_qty

You will get also (automaticaly added) :

• Stock inventory id (external id) : id
• Inventories : line_ids/location_id/id

Step by step how-to import products stock in Odoo

Open a spreadsheet, populate it with your product names, product external id and product quantity — much easier to export them from Odoo ; export from product’s variants if you use them.

Rename your columns as follow :

• Product name : line_ids/product_name
• Product external id : line_ids/product_id/id
• Product quantity : line_ids/product_qty

Add following columns (corresponding to field’s name) at the end. The order doesn’t matter :

• company_id/id
  (this column will contain one record on the first line only, usually « base.main_company »)
• location_id/id
  (this column will contain one record on the first line only, usually « stock.stock_location_stock »)
• name
  (this column will contain one record on the first line only, put whatever you want)
• line_ids/location_id/id
  (every line will contain the same value as the first line of location_id/id)

Save it as a CSV file. Open Odoo Inventory menu, go to Inventory Adjustment and press the Import button.

Once imported, a new entry will be created in Draft status. Open the entry and press Start Inventory. Validate the inventory if everything is ok.

Odoo apps are well integrated. Products datas are shared accros modules, and the accounting module can « talk » very well with the inventory one. Doing everything in Odoo is easy. But sometimes you need just a spreadsheet with your past inventory at a precise date. That functionality is a bit hidden. Here’s how to enable it :

1. install the Accounting module
2. enable multi-location inventory
3. switch to developper mode to see hidden menus
4. go to Inventory / Reports / Aging inventory

To export :

Quickly done

… but product name, stock and stock value only

1. on the right of the list view, click on Tableau Croisé dynamique
2. now click on the download icon (xls file)

Complete nightmare

… but you may be able to export every needed field

1. from list view unfold all products, check the checkbox
2. click on Action / Export
3. click on all available fields
4. choose your fields, don’t forget inventory moves, quants and associated dates
5. export
6. try to play with your spreadsheet
7. go to Quickly done