Product type always Consumable

[Guilleret Florian]

When I import product from magent . They're always Consumable type instead of stockable type. How can I fix this ?

[Kyle Waid (midwest)]

Good point, I agree this is a bug. To fix it you must have the database tool pgadmin

Open your schema from the drop down menu after you add your server then click "Query Tool"
execute this query

UPDATE product_template
SET type = 'product'
WHERE type = 'consu'

This will change all consumable products to stockable products

[Guilleret Florian (guilleret-florian)]

Ok thanks Kyle.

But my catalog grow every day ( 20 products per day ).

I ever "tune" openerpmagento connector to synchronize magento // openerp every 5 minutes. ( In magento I create a table with object who have to be imported in openerp ). And openerp request magento api every 5 minutes to import or upadte only object who need it.

So is there a way to do it in code ? maybe change refential mapping no ?

[Kyle Waid (midwest)]

you should do database mod once, then future create products in erp and upload them to magento as they are created. We funded new functionality. Now you can easily create a product in one form, open magento fields for specifics, then on the right click export to shop. It is not advisable to create products in magento and continously download them. Its definitely possible to alter the 'consu' to 'product' but im not sure easliy, and I dont have the time to figure it out now.

[Raphaël Valyi - http://www.akretion.com (rvalyi)]

I'm not sure if that's a bug on our side. The issue is that OpenERP itself makes consumable the default in v6. I have a customer selling downloadable product we map as consumable, so it's not like it would be systematically a wrong match.

What you can do alternatively is open the product form with the GTK client, then right-click over a 'stockable' product type and makes it a default? Then any new product created via Magento or not will be 'stockable instead.

Also, let me remind you that the expected work flow of the connector is to administer the product catalog in OpenERP and push it to Magento, not the reverse. The catalog import from Magento doesn't claim to be more than a migration utility function, it really lags behind the export feature.

[Kyle Waid (midwest)]

Wow thats cool, I didnt know you could do that. So really you could create one product at first, and set to stockable and then the import should create them all as stockable.

[Kyle Waid (midwest)]

Informal purposes Not a bug