Magento OpenERP Connector

Openerp 6.1 doesn't import magento's order anymore

Asked by Tizzone Laurent

Hello,

All was working fine & suddenly openerp doesn't import magento's order automatically or manually when I push the import order button. I'm running opernerp 6.1 & mangento 1.7
I don't have any errors synchro errors...
Someone have any clue?

Thanks.

Laurent

Question information

Language:
English Edit question
Status:
Answered
For:
Magento OpenERP Connector Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Willi Kreißl (6-willx-h) said : 		#1

Hey Laurent,

The Magento-Module adds an additional field called "imported" into the table "sales_flat_order".
Only orders with "imported"-value 0 will be imported.

Use this SQL-Command to reset all "imported"-values to 0:
UPDATE `sales_flat_order` SET `imported` = '0'

Hope this fixes this error :)

If this doesn't help, take a look at the last synchronisation details in OpenERP:
(MAGENTOERPCONNECT->Reporting->Last Syncronisation Details)

Revision history for this message
Tizzone Laurent (laurent-tizzone) said : 		#2

Hi Willi,

Thank you very much for your answer. I took a look. All my orders ares set to 1 on my magento database. I will try that & let you know.
Anyway thank you very much again!
Laurent

Revision history for this message
Diego Madrigali (burdo3417) said : 		#3

Not working for me neither.

Y tried updating the fields to 0 with the above command.

All fields were changed to 0, but orders still are not getting imported.

Can you help with this problem?

Provide an answer of your own, or ask Tizzone Laurent for more information if necessary.

To post a message you must log in.