Comment 4 for bug 688225

Revision history for this message
Kyle Waid (midwest) wrote : Re: Importing products skip if entity_id = sku

Hi, Sorry the title, I mean

catalog_product_entity matches sku. This is an exact copy from one of our logs
[2010-12-07 17:42:53,128][gamma4] INFO:Magento Connection:Calling Method:catalog_product.info,Arguments:['101']
[2010-12-07 17:42:53,440][gamma4] INFO:Magento Connection:Query Returned:{'set': '63', 'weight': '9.0000', 'type_id': 'simple', 'featured_description': None, 'inventory_unit': None, 'options_container': 'container2', 'small_image_label': '', 'featured_product': None, 'bitterness_level': None, 'cost': None, 'thumbnail_label': '', 'minimal_price': None, 'beer_kit_color': None, 'aitfiles_title': None, 'url_key': 'all-ale-kit-of-the-month-club-w-dry-yeast', 'sku': '101', 'yeast_instructions': '<div class="yeast-instructions"><a href="/media/pdf-printouts/Dry.pdf" target="_blank">Dry Yeast | <a href="/media/pdf-printouts/Propagator.pdf" target="_blank">Wyeast Propagator</a> | <a href="/media/pdf-printouts/Activator.pdf" target="_blank">Wyeast Activator</a> | <a href="/media/pdf-printouts/WhiteLabs.pdf" target="_blank">White Labs</a></div>', 'inventory_qty_per_unit': None, 'custom_layout_update': '', 'old_id': None, 'page_layout': None, 'tax_class_id': '0', 'category_ids': [], 'meta_keyword': '', 'gift_message_available': '2', 'categories': [], 'custom_design_to': None, 'tier_price': [], 'manufacturer': None, 'type': 'simple', 'beer_kit_style': None, 'status': '1', 'meta_description': '', 'meta_title': '',

Now you see the argument is the same as the sku. When these two areas match meaning that the catalog_product_entity and the product sku are the same it wont add the product to the ERP database. This is the result

[2010-12-07 18:19:21,589][gamma4] INFO:ext synchro:Updated in OpenERP product.product from External Ref with external_id 100 and OpenERP id 458 successfully
[2010-12-07 18:19:21,826][gamma4] INFO:ext synchro:Updated in OpenERP product.product from External Ref with external_id 1746 and OpenERP id

You see it downloads in order. When it reaches that product with external Reference it doesnt say 101 it says 1746 and as a result that product isnt added to the database.