Comment 31 for bug 688225

Revision history for this message
Kyle Waid (midwest) wrote :

Hi, Thank you for continued support. I eventually found another way that worked. It could be perhaps we were using a different magento version than you? We are using 1.3.2.4.

What I did was compare the table in OpenERP to the Magento Entity_id table. I first downloaded what products I could. Then on a dummy database I ran a special query and nulled all of the skus where they conflict using the list I got. I then downloaded all of our orders and the products imported that way. I noticed that if I click import products, it will overwrite the original ones, erasing the skus so when I imported orders it detected the missing products but didnt overwrite the ones already there. When I get all of the products, I drop that database and sync with the live site. Hey it works for me. I checked also and it appears to correctly map the products because it looks like the import orders maps the product based on the name field.