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.
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.