Merge lp:~ajite/openerp-connector/7.0-magentoerpconnect-fix-000002 into lp:~openerp-connector-core-editors/openerp-connector-magento/7.0

[Augustin Cisterne-Kaas - www.elico-corp.com]

The changes that I have made are experimental.
At the moment, some of the previous unit tests are not working because you need to import product attribute sets before importing products.

It is quite stable on my local environment but it still obviously needs improvements.

To try the changes that I have made please use the following branch of the OpenLabs Magento add-on:

bzr branch lp:~ajite/openerp-connector/magento-model-oerp7.x-experimental

It adds 2 API methods in the Product attribute set API (search and info).

Added the export of products and categories.
Added the import of product attribute sets (We need to have them to export export products).
Added a new backend advanced option (Export record On save)
Added attributes in both magento.product.product and magento.product.category (that are required for the export)

Please import the product attribute sets before importing products
You need to have a product code and a product description for the product export function to succeed.

We can create and edit a category then export it to a given backend but we can't move the category to another parent category after the creation. In fact the magento setParentId() will not change the parent id. We need to implement the magento category API move method to make it work.

[Guewen Baconnier @ Camptocamp (gbaconnier-c2c)]

Hi Augustin,

Thanks for the MP.
I read through the diff and that seems already nice, you very well understood the mechanisms and how the synchronizations are supposed to work and that makes me happy.

I'll need to take more time to do a proper review, but I'm already reassured that you go in the right direction so I am quite comfortable if let you continue in this direction.

There is just one thing I want to comment on, about the choice to push the records on save.
Basically in your diff:

    push_on_save = record.backend_id.push_on_save
    if push_on_save:

This option is to remove, any created or modified record must always me exported to Magento, that's the design we choose. So we don't need anymore the methods to export the products or categories like in l.411,498.

Another thing about the monkey patching in l.522: this is a bad idea, because OpenERP may import the python code of uninstalled modules (it wouldn't have bad effects in this case, remark). There is other techniques [0][1] for replacing ConnectorUnit classes, but in that case I would just redefine the create method in the main 'magentoerpconnect' module.

[0] https://code.launchpad.net/~openerp-connector-core-editors/openerp-connector/7.0-connector-replacing-connectorunit-classes/+merge/172309
[1] https://code.launchpad.net/~openerp-connector-core-editors/openerp-connector/7.0-magentoerpconnect-replacing-connectorunit-classes/+merge/172311

[lp:~ajite/openerp-connector/7.0-magentoerpconnect-fix-000002]

906. By Augustin Cisterne-Kaas <email address hidden> on 2013-08-19

[ADD] Export categories and products. Import of product set attributes.

[Augustin Cisterne-Kaas - www.elico-corp.com (ajite)]

Hi Guewen,

Thank you for your feedback.

> Hi Augustin,
>
> Thanks for the MP.
> I read through the diff and that seems already nice, you very well understood
> the mechanisms and how the synchronizations are supposed to work and that
> makes me happy.
>
> I'll need to take more time to do a proper review, but I'm already reassured
> that you go in the right direction so I am quite comfortable if let you
> continue in this direction.
>

I am glad that I am heading in the right direction.

> There is just one thing I want to comment on, about the choice to push the
> records on save.
> Basically in your diff:
>
> push_on_save = record.backend_id.push_on_save
> if push_on_save:
>
> This option is to remove, any created or modified record must always me
> exported to Magento, that's the design we choose. So we don't need anymore the
> methods to export the products or categories like in l.411,498.
>

Don't you think that the "push on save" function might be useful for people in a marketing team who are working on a product description and want to save the changes as a draft before sending the final description to a backend ? I think that not having that option might lead to more mistakes from the end-users.

> Another thing about the monkey patching in l.522: this is a bad idea, because
> OpenERP may import the python code of uninstalled modules (it wouldn't have
> bad effects in this case, remark). There is other techniques [0][1] for
> replacing ConnectorUnit classes, but in that case I would just redefine the
> create method in the main 'magentoerpconnect' module.
>
>
> [0] https://code.launchpad.net/~openerp-connector-core-editors/openerp-
> connector/7.0-connector-replacing-connectorunit-classes/+merge/172309
> [1] https://code.launchpad.net/~openerp-connector-core-editors/openerp-
> connector/7.0-magentoerpconnect-replacing-connectorunit-classes/+merge/172311

I forgot to remove the monkey patch line 622. Hopefully you saw it ;)!

[Guewen Baconnier @ Camptocamp (gbaconnier-c2c)]

On 08/19/2013 09:13 AM, Augustin Cisterne-Kaas (www.elico-corp.com) wrote:
>
>> There is just one thing I want to comment on, about the choice to push the
>> records on save.
>> Basically in your diff:
>>
>> push_on_save = record.backend_id.push_on_save
>> if push_on_save:
>>
>> This option is to remove, any created or modified record must always me
>> exported to Magento, that's the design we choose. So we don't need anymore the
>> methods to export the products or categories like in l.411,498.
>>
>
> Don't you think that the "push on save" function might be useful for people in a marketing team who are working on a product description and want to save the changes as a draft before sending the final description to a backend ? I think that not having that option might lead to more mistakes from the end-users.
>

You are right, that could be a nice option, I would be more in favor of
a single field on the 'magento.product.product' or
'magento.product.category', a 'ready' boolean field, the export being
skipped while it is not True. I don't like the global option.

Although, for records which are already exported, we'll miss the sync of
the changes (in both cases, "push on save" global option or "ready"
field) if the option is deactivated and we don't push them manually and
that could be a problem.

Anyhow, I need a bit more reflexion on that, but my feeling is that for
such cases, we should never deactivate the exports and just use the
"visibility" or "active" field of Magento.

[Guewen Baconnier @ Camptocamp (gbaconnier-c2c)]

On 08/19/2013 09:51 AM, Guewen Baconnier @ Camptocamp wrote:
> Anyhow, I need a bit more reflexion on that, but my feeling is that for
> such cases, we should never deactivate the exports and just use the
> "visibility" or "active" field of Magento.
>
That would also prevent many issues with cross-linking between records,
e.g. export a child category but parent category's not yet exported, or
export a product linked (cross-sell, up-sell, ...) to a product not yet
exported.

--
Guewen Baconnier
Business Solutions Software Developer

Camptocamp SA
PSE A, CH-1015 Lausanne
Phone: [phone]
Office: [phone]
http://www.camptocamp.com/

[lp:~ajite/openerp-connector/7.0-magentoerpconnect-fix-000002]

907. By Augustin Cisterne-Kaas <email address hidden> on 2013-08-19

Removed Global "Push On Save" button

[Augustin Cisterne-Kaas - www.elico-corp.com (ajite)]

> On 08/19/2013 09:51 AM, Guewen Baconnier @ Camptocamp wrote:
> > Anyhow, I need a bit more reflexion on that, but my feeling is that for
> > such cases, we should never deactivate the exports and just use the
> > "visibility" or "active" field of Magento.
> >
> That would also prevent many issues with cross-linking between records,
> e.g. export a child category but parent category's not yet exported, or
> export a product linked (cross-sell, up-sell, ...) to a product not yet
> exported.
>
>
> --
> Guewen Baconnier
> Business Solutions Software Developer
>
> Camptocamp SA
> PSE A, CH-1015 Lausanne
> Phone: [phone]
> Office: [phone]
> http://www.camptocamp.com/

You are absolutely right.
I have removed the global "push on save" option. I will try to think about something else.

[lp:~ajite/openerp-connector/7.0-magentoerpconnect-fix-000002]

908. By Augustin Cisterne-Kaas <email address hidden> on 2013-08-22

[ADD] Added the unlink method.

909. By Augustin Cisterne-Kaas <email address hidden> on 2013-08-22

[FIX] Improved push of products

910. By Augustin Cisterne-Kaas <email address hidden> on 2013-08-22

[FIX] Removed debug message

[Augustin Cisterne-Kaas - www.elico-corp.com (ajite)]

I have improved the way data were sent. I have added some required attributes in 'magento.product.product'.

I was able to push 2500 products with custom attribute sets and custom attributes without any problem. I have created another module to handle the custom attributes that were needed for my case.

The write and unlink functions are both working well.

I am not happy with my import product category mapper. How can I improve it ? I have tried to use a binder but that did not work well... Is there anyway to avoid the O(n*m) loop ?

[Guewen Baconnier @ Camptocamp (gbaconnier-c2c)]

On 08/22/2013 12:08 PM, Augustin Cisterne-Kaas (www.elico-corp.com) wrote:
> I have improved the way data were sent. I have added some required attributes in 'magento.product.product'.
>
> I was able to push 2500 products with custom attribute sets and custom attributes without any problem. I have created another module to handle the custom attributes that were needed for my case.
>
> The write and unlink functions are both working well.
>

Nice news! I'll have a look.

> I am not happy with my import product category mapper. How can I improve it ? I have tried to use a binder but that did not work well... Is there anyway to avoid the O(n*m) loop ?
>
Just to be sure, you speak about ProductProductExportMapper.category()
right?
I don't think we can avoid the O(n*m) loop, at least using the ORM, we
could maybe do it with SQL but with a penalty in clarity.
However, we can simplify the function by iterating over a single list
(record.categ_id + record.categ_ids)

Untested:

     @mapping
     def category(self, record):
         all_categs = [record.categ_id] + record.categ_ids
         mag_categ_ids = [m_categ.magento_id for categ in all_categs
                          for m_categ in categ.magento_bind_ids
                          if m_categ.backend_id.id ==
self.backend_record.id]
     return {'categories': mag_categ_ids}

[Augustin Cisterne-Kaas - www.elico-corp.com (ajite)]

> > I am not happy with my import product category mapper. How can I improve it
> ? I have tried to use a binder but that did not work well... Is there anyway
> to avoid the O(n*m) loop ?
> >
> Just to be sure, you speak about ProductProductExportMapper.category()
> right?
> I don't think we can avoid the O(n*m) loop, at least using the ORM, we
> could maybe do it with SQL but with a penalty in clarity.
> However, we can simplify the function by iterating over a single list
> (record.categ_id + record.categ_ids)
>
> Untested:
>
> @mapping
> def category(self, record):
> all_categs = [record.categ_id] + record.categ_ids
> mag_categ_ids = [m_categ.magento_id for categ in all_categs
> for m_categ in categ.magento_bind_ids
> if m_categ.backend_id.id ==
> self.backend_record.id]
> return {'categories': mag_categ_ids}

Yes. The syntax looks much better like that even though it is still O(n*m). I will update it as soon as I possible.
I think that it's better to avoid the SQL request.

Unmerged revisions

910. By Augustin Cisterne-Kaas <email address hidden> on 2013-08-22

[FIX] Removed debug message

909. By Augustin Cisterne-Kaas <email address hidden> on 2013-08-22

[FIX] Improved push of products

908. By Augustin Cisterne-Kaas <email address hidden> on 2013-08-22

[ADD] Added the unlink method.

907. By Augustin Cisterne-Kaas <email address hidden> on 2013-08-19

Removed Global "Push On Save" button

906. By Augustin Cisterne-Kaas <email address hidden> on 2013-08-19

[ADD] Export categories and products. Import of product set attributes.

905. By Augustin Cisterne-Kaas <email address hidden> on 2013-08-18

[ADD] Export categories and products. Import of product set attributes.

=== modified file 'magentoerpconnect/__init__.py'
--- magentoerpconnect/__init__.py	2013-05-02 12:30:40 +0000
+++ magentoerpconnect/__init__.py	2013-08-22 07:24:16 +0000
@@ -6,6 +6,7 @@
 import magento_model
 import product
 import product_category
+import product_attribute_set
 import partner
 import partner_category
 import invoice

=== modified file 'magentoerpconnect/magento_model.py'
--- magentoerpconnect/magento_model.py	2013-08-15 08:01:46 +0000
+++ magentoerpconnect/magento_model.py	2013-08-22 07:24:16 +0000
@@ -218,6 +218,16 @@
                                'import_products_from_date', context=context)
         return True
 
+    def import_product_attribute_set(self, cr, uid, ids, context=None):
+        if not hasattr(ids, '__iter__'):
+            ids = [ids]
+        self.check_magento_structure(cr, uid, ids, context=context)
+        session = ConnectorSession(cr, uid, context=context)
+        for backend_id in ids:
+            import_batch.delay(session, 'magento.product.attribute.set',
+                               backend_id)
+        return True
+
     def update_product_stock_qty(self, cr, uid, ids, context=None):
         if not hasattr(ids, '__iter__'):
             ids = [ids]

=== modified file 'magentoerpconnect/magento_model_view.xml'
--- magentoerpconnect/magento_model_view.xml	2013-08-15 08:01:46 +0000
+++ magentoerpconnect/magento_model_view.xml	2013-08-22 07:24:16 +0000
@@ -91,6 +91,13 @@
                                         string="Import in background"/>
                                 </group>
                                 <group>
+                                    <label string="Import product attribute sets" class="oe_inline"/>
+                                    <button name="import_product_attribute_set"
+                                        type="object"
+                                        class="oe_highlight"
+                                        string="Import in background"/>
+                                </group>
+                                <group>
                                     <label string="Import sales orders from all store views" class="oe_inline"/>
                                     <button name="import_sale_orders"
                                         type="object"

=== modified file 'magentoerpconnect/product.py'
--- magentoerpconnect/product.py	2013-07-26 09:06:53 +0000
+++ magentoerpconnect/product.py	2013-08-22 07:24:16 +0000
@@ -79,12 +79,34 @@
         # XXX website_ids can be computed from categories
         'website_ids': fields.many2many('magento.website',
                                         string='Websites',
-                                        readonly=True),
+                                        required=True),
         'created_at': fields.date('Created At (on Magento)'),
         'updated_at': fields.date('Updated At (on Magento)'),
         'product_type': fields.selection(_product_type_get,
                                          'Magento Product Type',
                                          required=True),
+        'attribute_set_id': fields.many2one('product.attribute.set',
+                                            string='Attribute Set',
+                                            required=True),
+        'visibility': fields.selection(
+            [('1', 'Not Visible Individually'),
+             ('2', 'Catalog'),
+             ('3', 'Search'),
+             ('4', 'Catalog, Search')],
+            string='Visibility in Magento',
+            required=True),
+        'tax_class': fields.selection(
+            [('0', 'None'),
+             ('2', 'Default'),
+             ('3', 'Taxable Goods'),
+             ('4', 'Shipping')],
+            string='Tax Class in Magento',
+            ),
+        'status': fields.selection(
+            [('1', 'Enabled'),
+             ('2', 'Disabled')],
+            string='Status in Magento',
+            required=True),
         'manage_stock': fields.selection(
             [('use_default', 'Use Default Config'),
              ('no', 'Do Not Manage Stock'),
@@ -195,6 +217,9 @@
                 in self._call('%s.list' % self._magento_model,
                               [filters] if filters else [{}])]
 
+    def create(self, data):
+        return self._call('%s.create'% self._magento_model,[data.pop('product_type'),data.pop('attrset'),data.pop('sku'),data])
+
     def read(self, id, storeview_id=None, attributes=None):
         """ Returns the information of a record
 
@@ -356,6 +381,9 @@
               ('type_id', 'product_type'),
               ('created_at', 'created_at'),
               ('updated_at', 'updated_at'),
+              ('visibility', 'visibility'),
+              ('tax_class_id', 'tax_class'),
+              ('status', 'status')
               ]
 
     @mapping
@@ -372,6 +400,16 @@
         return
 
     @mapping
+    def set(self, record):
+        binder = self.get_binder_for_model('magento.product.attribute.set')
+        set_id = binder.to_openerp(record['set'])
+        if set_id is None:
+            raise MappingError("The product attribute set with "
+                               "magento id %s is not imported." %
+                               record['set'])
+        return {'attribute_set_id': set_id}
+
+    @mapping
     def website_ids(self, record):
         website_ids = []
         binder = self.get_binder_for_model('magento.website')

=== added file 'magentoerpconnect/product_attribute_set.py'
--- magentoerpconnect/product_attribute_set.py	1970-01-01 00:00:00 +0000
+++ magentoerpconnect/product_attribute_set.py	2013-08-22 07:24:16 +0000
@@ -0,0 +1,94 @@
+# -*- coding: utf-8 -*-
+
+import logging
+from openerp.osv import fields, orm, osv
+import openerp.addons.decimal_precision as dp
+from openerp.addons.connector.unit.mapper import (mapping,
+                                                  ImportMapper,
+                                                 )
+from .backend import magento
+from openerp.addons.magentoerpconnect.unit.backend_adapter import GenericAdapter
+from openerp.addons.magentoerpconnect.unit.import_synchronizer import (BatchImportSynchronizer,
+                                                                       DelayedBatchImport,
+                                                                       MagentoImportSynchronizer
+                                                                      )
+from openerp.addons.magentoerpconnect.unit.binder import MagentoModelBinder
+from openerp.addons.connector.queue.job import job
+
+
+from openerp.tools.translate import _
+_logger = logging.getLogger(__name__)
+ 
+class product_attribute_set(orm.Model):
+  _name = 'product.attribute.set'
+
+  _columns = {
+    'name': fields.char('name', required=True),
+    'magento_bind_ids': fields.one2many('magento.product.attribute.set', 'openerp_id',
+                                            string="Magento Bindings"),
+  }
+
+  
+
+
+
+class magento_product_attribute_set(orm.Model):
+	_name = 'magento.product.attribute.set'
+	_inherit = 'magento.binding'
+	_inherits = {'product.attribute.set': 'openerp_id'}
+
+	_columns = {
+	    'openerp_id': fields.many2one('product.attribute.set',
+	                                   string='Magento order',
+	                                   required=True,
+	                                   ondelete='cascade'),
+      'created_at': fields.date('Created At (on Magento)'),
+      'updated_at': fields.date('Updated At (on Magento)'),
+	}
+
+	_sql_constraints = [
+	    ('magento_uniq', 'unique(backend_id, magento_id)',
+	     'A partner tag with same ID on Magento already exists.'),
+	]
+
+
+@magento
+class ProductAttributeSetBatchImport(MagentoImportSynchronizer):
+    _model_name = ['magento.product.attribute.set']
+
+@magento
+class ProductAttributeSetBatchImport(DelayedBatchImport):
+    """ Import the Magento Products.
+
+    For every product category in the list, a delayed job is created.
+    Import from a date
+    """
+    _model_name = ['magento.product.attribute.set']
+
+
+@magento
+class ProductAttributeSetAdapter(GenericAdapter):
+    _model_name = 'magento.product.attribute.set'
+    _magento_model = 'ol_catalog_product_attributeset'
+
+
+@magento
+class ProductAttributeSetImportMapper(ImportMapper):
+    _model_name = 'magento.product.attribute.set'
+
+    direct = [('attribute_set_id', 'magento_id'),
+              ('attribute_set_name', 'name')
+              ]
+
+    @mapping
+    def backend_id(self, record):
+        return {'backend_id': self.backend_record.id}
+        
+@job
+def product_attribute_set_import_batch(session, model_name, backend_id, filters=None):
+    """ Prepare a batch import of records from Magento """
+    if filters is None:
+        filters = {}
+    env = get_environment(session, model_name, backend_id)
+    importer = env.get_connector_unit(ProductAttributeSetBatchImport)
+    importer.run(filters)
\ No newline at end of file

=== modified file 'magentoerpconnect/product_category.py'
--- magentoerpconnect/product_category.py	2013-07-26 09:06:53 +0000
+++ magentoerpconnect/product_category.py	2013-08-22 07:24:16 +0000
@@ -49,6 +49,8 @@
                                       required=True,
                                       ondelete='cascade'),
         'description': fields.text('Description', translate=True),
+        'is_active': fields.boolean('Active in magento'),
+        'include_in_menu': fields.boolean('Include in magento menu'),
         'magento_parent_id': fields.many2one(
             'magento.product.category',
              string='Magento Parent Category',
@@ -99,6 +101,9 @@
             else:
                 raise
 
+    def create(self, data):
+        return self._call('%s.create'% self._magento_model,[data['parent_id'],data])
+
     def search(self, filters=None, from_date=None):
         """ Search records according to some criterias and returns a
         list of ids
@@ -216,6 +221,8 @@
 
     direct = [
             ('description', 'description'),
+            ('is_active','is_active'),
+            ('include_in_menu','include_in_menu')
             ]
 
     @mapping

=== modified file 'magentoerpconnect/product_view.xml'
--- magentoerpconnect/product_view.xml	2013-04-03 12:12:56 +0000
+++ magentoerpconnect/product_view.xml	2013-08-22 07:24:16 +0000
@@ -68,7 +68,12 @@
                         <field name="magento_id"/>
                         <field name="created_at" readonly="1"/>
                         <field name="updated_at" readonly="1"/>
+                        <field name="visibility" />
+                        <field name="tax_class" />
+                        <field name="status" />
                         <field name="product_type" readonly="1"/>
+                        <field name="website_ids" />
+                        <field name="attribute_set_id" />
                     </group>
                     <group string="Inventory Options">
                         <field name="manage_stock"/>
@@ -96,5 +101,22 @@
             </field>
         </record>
 
+        <record id="product_attribute_set_action_form" model="ir.actions.act_window">
+            <field name="name">Product Attribute Set</field>
+            <field name="type">ir.actions.act_window</field>
+            <field name="res_model">product.attribute.set</field>
+            <field name="view_type">form</field>
+            <field name="view_mode">tree,form</field>
+            <field name="help" type="html">
+              <p class="oe_view_nocontent_create">
+                Click to create a product attribute set
+              </p>
+            </field>
+        </record>
+
+        <menuitem action="product_attribute_set_action_form"
+            groups="base.group_no_one"
+            id="menu_product_attribute_set_action_form"
+            parent="product.prod_config_main" sequence="3"/>
     </data>
 </openerp>

=== modified file 'magentoerpconnect/unit/binder.py'
--- magentoerpconnect/unit/binder.py	2013-05-02 12:30:40 +0000
+++ magentoerpconnect/unit/binder.py	2013-08-22 07:24:16 +0000
@@ -53,6 +53,7 @@
             'magento.sale.order',
             'magento.sale.order.line',
             'magento.account.invoice',
+            'magento.product.attribute.set',
         ]
 
     def to_openerp(self, external_id, unwrap=False):

=== modified file 'magentoerpconnect_catalog/__init__.py'
--- magentoerpconnect_catalog/__init__.py	2013-03-19 15:41:34 +0000
+++ magentoerpconnect_catalog/__init__.py	2013-08-22 07:24:16 +0000
@@ -1,1 +1,6 @@
 # -*- coding: utf-8 -*-
+
+import connector
+import consumer
+import product
+import product_category
\ No newline at end of file

=== modified file 'magentoerpconnect_catalog/__openerp__.py'
--- magentoerpconnect_catalog/__openerp__.py	2013-03-19 15:41:34 +0000
+++ magentoerpconnect_catalog/__openerp__.py	2013-08-22 07:24:16 +0000
@@ -26,7 +26,7 @@
  'category': 'Connector',
  'depends': ['magentoerpconnect',
              'product_links',
-             'product_images',
+             #'product_images',
              ],
  'author': 'MagentoERPconnect Core Editors',
  'license': 'AGPL-3',
@@ -44,7 +44,7 @@
 """,
  'images': [],
  'demo': [],
- 'data': [],
+ 'data': ['product_view.xml'],
  'installable': True,
  'application': False,
 }

=== added file 'magentoerpconnect_catalog/connector.py'
--- magentoerpconnect_catalog/connector.py	1970-01-01 00:00:00 +0000
+++ magentoerpconnect_catalog/connector.py	2013-08-22 07:24:16 +0000
@@ -0,0 +1,12 @@
+# -*- coding: utf-8 -*-
+
+from openerp.osv import orm
+
+
+class magentoerpconnect_export_partner_installed(orm.AbstractModel):
+    """Empty model used to know if the module is installed on the
+    database.
+
+    If the model is in the registry, the module is installed.
+    """
+    _name = 'magentoerpconnect_catalog.installed'
\ No newline at end of file

=== added file 'magentoerpconnect_catalog/consumer.py'
--- magentoerpconnect_catalog/consumer.py	1970-01-01 00:00:00 +0000
+++ magentoerpconnect_catalog/consumer.py	2013-08-22 07:24:16 +0000
@@ -0,0 +1,25 @@
+# -*- coding: utf-8 -*-
+
+from functools import wraps
+from openerp.addons.connector.event import (on_record_write,
+                                            on_record_create,
+                                            on_record_unlink
+                                            )
+from openerp.addons.magentoerpconnect.unit.export_synchronizer import export_record
+import openerp.addons.magentoerpconnect.consumer as magentoerpconnect
+
+
+@on_record_create(model_names=['magento.product.category', 'magento.product.product'])
+@on_record_write(model_names=['magento.product.category', 'magento.product.product'])
+def delay_export(session, model_name, record_id, fields=None):
+    magentoerpconnect.delay_export(session, model_name,
+                                   record_id, fields=fields)
+
+@on_record_write(model_names=['product.category','product.product'])
+def delay_export_all_bindings(session, model_name, record_id, fields=None):
+    magentoerpconnect.delay_export_all_bindings(session, model_name,
+                                                record_id, fields=fields)
+
+@on_record_unlink(model_names=['magento.product.category', 'magento.product.product'])
+def delay_unlink(session, model_name, record_id):
+	magentoerpconnect.delay_unlink(session, model_name, record_id)

=== added file 'magentoerpconnect_catalog/product.py'
--- magentoerpconnect_catalog/product.py	1970-01-01 00:00:00 +0000
+++ magentoerpconnect_catalog/product.py	2013-08-22 07:24:16 +0000
@@ -0,0 +1,95 @@
+# -*- coding: utf-8 -*-
+
+from openerp.osv import fields, orm, osv
+from openerp.addons.connector.queue.job import job
+from openerp.addons.connector.unit.mapper import (mapping,
+                                                  changed_by,
+                                                  ExportMapper)
+from openerp.addons.magentoerpconnect.unit.delete_synchronizer import (
+        MagentoDeleteSynchronizer)
+from openerp.addons.magentoerpconnect.unit.export_synchronizer import (
+        MagentoExporter)
+from openerp.addons.magentoerpconnect.backend import magento
+from openerp.addons.magentoerpconnect.product import ProductProductAdapter
+from openerp.addons.connector.exception import MappingError
+
+@magento
+class ProductProductDeleteSynchronizer(MagentoDeleteSynchronizer):
+    """ Partner deleter for Magento """
+    _model_name = ['magento.product.product']
+
+
+@magento
+class ProductProductExport(MagentoExporter):
+    _model_name = ['magento.product.product']
+
+@magento
+class ProductProductExportMapper(ExportMapper):
+    _model_name = 'magento.product.product'
+
+    # direct = [('name', 'name'),
+    #           ('description', 'description'),
+    #           ('weight', 'weight'),
+    #           ('list_price', 'price'),
+    #           ('description_sale', 'short_description'),
+    #           ('default_code', 'sku'),
+    #           ('product_type', 'type'),
+    #           ('created_at', 'created_at'),
+    #           ('updated_at', 'updated_at'),
+    #           ('status', 'status'),
+    #           ('visibility', 'visibility'),
+    #           ('product_type', 'product_type')
+    #           ]
+    @mapping
+    def all(self, record):
+        return {'name': record.name,
+                'description': record.description,
+                'weight': record.weight,
+                'price': record.list_price,
+                'short_description': record.description_sale,
+                'type': record.product_type,
+                'created_at': record.created_at,
+                'updated_at': record.updated_at,
+                'status': record.status,
+                'visibility': record.visibility,
+                'product_type': record.product_type }
+
+    @mapping
+    def sku(self, record):
+        sku = record.default_code
+        if not sku:
+            raise MappingError("The product attribute default code cannot be empty.")
+        return {'sku': sku}
+
+    @mapping
+    def set(self, record):
+        binder = self.get_binder_for_model('magento.product.attribute.set')
+        set_id = binder.to_backend(record.attribute_set_id.id)
+        return {'attrset': set_id}
+
+    @mapping
+    def tax(self, record):
+        tax_class_id = record.tax_class if record.tax_class else 0
+        return {'tax_class_id': tax_class_id}
+
+    @mapping
+    def website_ids(self, record):
+        website_ids = []
+        for website_id in record.website_ids:
+            magento_id = website_id.magento_id
+            website_ids.append(magento_id)
+        return {'website_ids': website_ids}
+
+    @mapping
+    def category(self, record): 
+        categ_ids = []
+        if record.categ_id:
+            for m_categ in record.categ_id.magento_bind_ids:
+                if m_categ.backend_id.id == self.backend_record.id:
+                    categ_ids.append(m_categ.magento_id) 
+
+        for categ in record.categ_ids:
+            for m_categ in categ.magento_bind_ids:
+                if m_categ.backend_id.id == self.backend_record.id:
+                    categ_ids.append(m_categ.magento_id)            
+        return {'categories': categ_ids}

=== added file 'magentoerpconnect_catalog/product_category.py'
--- magentoerpconnect_catalog/product_category.py	1970-01-01 00:00:00 +0000
+++ magentoerpconnect_catalog/product_category.py	2013-08-22 07:24:16 +0000
@@ -0,0 +1,55 @@
+# -*- coding: utf-8 -*-
+
+from openerp.osv import fields, orm, osv
+from openerp.addons.connector.unit.mapper import (mapping,
+                                                  changed_by,
+                                                  ExportMapper)
+from openerp.addons.magentoerpconnect.unit.delete_synchronizer import (
+        MagentoDeleteSynchronizer)
+from openerp.addons.magentoerpconnect.unit.export_synchronizer import (
+        MagentoExporter)
+from openerp.addons.magentoerpconnect.backend import magento
+from openerp.addons.magentoerpconnect.product_category import ProductCategoryAdapter
+
+@magento
+class ProductCategoryDeleteSynchronizer(MagentoDeleteSynchronizer):
+    """ Partner deleter for Magento """
+    _model_name = ['magento.product.category']
+
+
+@magento
+class ProductCategoryExport(MagentoExporter):
+    _model_name = ['magento.product.category']
+
+@magento
+class ProductCategoryExportMapper(ExportMapper):
+    _model_name = 'magento.product.category'
+
+    direct = [('description', 'description'),
+    		  ('name', 'name'), #change that to mapping top level category has no name
+             ]
+    @mapping
+    def sort(self, record):
+        return {'default_sort_by':'price', 'available_sort_by': 'price'}
+
+    @mapping
+    def parent(self, record):
+        """ Magento root category's Id equals 1 """
+        parent_id = record.magento_parent_id.magento_id
+        if not parent_id:
+            parent_id = 1
+        return {'parent_id':parent_id}
+
+    @mapping
+    def active(self, record):
+        is_active = record['is_active']
+        if not is_active:
+            is_active = 0
+        return {'is_active':is_active}
+
+    @mapping
+    def menu(self, record):
+        include_in_menu = record['include_in_menu']
+        if not include_in_menu:
+            include_in_menu = 0
+        return {'include_in_menu':include_in_menu}
\ No newline at end of file

=== added file 'magentoerpconnect_catalog/product_view.xml'
--- magentoerpconnect_catalog/product_view.xml	1970-01-01 00:00:00 +0000
+++ magentoerpconnect_catalog/product_view.xml	2013-08-22 07:24:16 +0000
@@ -0,0 +1,16 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<openerp>
+	<data>
+		<record id="view_magento_product_category_form" model="ir.ui.view">
+			<field name="name">magento.product.category.form</field>
+			<field name="model">magento.product.category</field>
+			<field name="inherit_id" ref="magentoerpconnect.view_magento_product_category_form" />
+			<field name="arch" type="xml" >
+				<field name="magento_id" position="replace">
+					<field name="is_active" />
+					<field name="include_in_menu" />
+				</field>
+			</field>
+		</record>
+	</data>
+</openerp>
\ No newline at end of file