c2c-oerpscenario team mailing list archive

[Kyle Waid <688225@xxxxxxxxxxxxxxxxxx>]

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.

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/688225

Title:
  Importing products skip if catalog_product_entity = sku crisscross

Status in Magento Open ERP Connector:
  Fix Released

Bug description:
  When we were importing our orders about 500 of our products would not import. We couldnt figure out why. We downloaded what we could and dumped it to a log file

We discovered that when magento was returning the products OpenERP would not add the product to the database if the catalog_entity matched the sku. We are not sure why it happens

Is there any way to fix this?