Contributors mailing list archives


Re: Product variant import (performance issue)

Elico Corp, Eric Caudal
- 26/01/2016 01:17:14
I would suggest to create csv and insert into SQL with copy function

Eric Caudal from my mobile device

-------- Original message --------
From: Raphaël Valyi <>
Date: 2016/01/26 07:38 (GMT+08:00)
To: Contributors <>
Subject: Re: Product variant import (performance issue)

An other idea: you could look at the SQL logs during the variant creation by Odoo. Then you temporarily patch the ORM to skip all the queries that are useless during the variant creation (like access rights checks etc...) not sure if that will be a faster hack though. Good luck.

On Mon, Jan 25, 2016 at 8:53 PM, Maxime Chambreuil <> wrote:

I have to create/import one product with 8692 variants. I left the creation runs for more than hour, no success.

Before I create a csv file with all the different combinations, I would like to know if you have a better suggestion.

Maxime Chambreuil
Ring ID: 239e01f6262afbf3c7d276d2c661173ddddc0340

Post to:

Raphaël Valyi
Founder and consultant
+55 21 3942-2434

Post to: