← Back to team overview

openerp-connector-community team mailing list archive

Re: Import Orders Not Working

 

Hi Kevin, 
This reminds me of my first trys order to invoice syncronization (though the orders came through..  perhaps after I gave each customer Accounting entries individually... what follows is a more complete fix I believe) 

I don't know if this is the exact problem but...
What fixed it for me is going into each Product Category in OpenERP which was imported and which has Products and being sure that I have Accounting Entries for the Category, which in turn will apply to the Products.

You may to do the same for each Customer.  I recall setting something in Settings that gives the correct value to each customer as well (From Eric C: "You can set them up at OpeneRP or company level in settings/Parameters/Configuration"

>From my response email: "Thank you Eric!

I was able to do this by duplicating an AR and an AP entry for a customer, then removing the attribution.  Fills in the fields now when I create a customer in OpenERP.  Perhaps this will allow the Amazon/Paypal Invoices to travel through now as well...  In fact I just tested and it worked! Hoo Ra!

The invoice imports were being blocked because there was no default AR/AP entry, while the Orders (from Magento) were able to come in as they were coming in as orders.  Invoices could be made when AR/AP per customer were manually applied.  Now the full order imports (seems to have an Automatic Payment attached even)..."

Perhaps this will help.
Good Luck.

Landis

----- Original Message -----
From: "jan-philipp fischer" <jan-philipp.fischer@xxxxxxxxxxxxxx>
To: openerp-connector-community@xxxxxxxxxxxxxxxxxxx
Sent: Monday, January 27, 2014 7:57:11 AM
Subject: Re: [Openerp-connector-community] Import Orders Not Working

Am 2014-01-27 15:44, schrieb Kevin Dennis:
> In the hopes that it will help, I’ve included the details of my
> environment below:
> 
> OpenERP
> Version 7.0-20140113-182049
> Postgres: (PostgreSQL) 9.2.4
> OS: Mac OS X 10.8.5 (xnu-2050.48.12~1/RELEASE_X86_64 x86_64)
> 
> Magento
> Version 1.7.0.2
> MySQL: Ver 14.14 Distrib 5.1.69, for redhat-linux-gnu (x86_64) using
> readline 5.1
> OS: CentOS 3.11.6-x86_64
> 
> Thanks in advance,
> 
> Kevin D.
> 
> 
> On Jan 27, 2014, at 6:55 AM, Kevin Dennis <kldennis@xxxxxxxxxxxxx> 
> wrote:
> 
> No, nothing. There are no failed jobs and nothing to be reviewed in
> the Checkpoint. Is the SQL error normal (__nonzero__() is deprecated)?
> 
> Any suggestions?
> 
> Kevin D.
> 
> On Jan 27, 2014, at 1:47 AM, Guewen Baconnier
> <guewen.baconnier@xxxxxxxxxxxxxx> wrote:
Hey Kevin,

don't know if that can be a problem but perhabs it is OS X. Don't try 
to install it on it. Will install it on OS X 10.9 later.

Can you try your OpenERP installation on Debian or Ubuntu? That should 
be better all in all i think.

Just a guess.

> 
> On 01/25/2014 10:13 PM, Kevin Dennis wrote:
>> Hi. I am having difficulty importing orders from Magento to OpenERP 
>> using the connector. When I try to manually import orders 
>> (Connectors->Magento->Backends) I get the following output (I only 
>> have one order in Magento):
>> 
>> 2014-01-25 20:52:01,078 23628 INFO openerp_011314 
>> openerp.addons.magentoerpconnect.sale: search for magento saleorders 
>> {'created_at': {'gt': '2013/01/25 20:45:28'}, 'state': {'neq': 
>> 'canceled'}, 'store_id': {'in': [u'1']}}  returned ['100000001']
>> 2014-01-25 20:53:01,082 23628 WARNING openerp_011314 openerp.sql_db: 
>> __nonzero__() is deprecated. (It is too expensive to test a 
>> connection.)
>> 
>> Imports of categories, products, and customers have worked fine… Any 
>> help would be greatly appreciated.
>> 
>> Thanks,
>> 
>> Kevin D.
>> 
> 
> Hi,
> 
> I see nothing unexpected in this log, it found the 100000001 sales 
> order.
> 
> Do you have a failed job in Connector > Jobs ?
> 
> --
> Guewen Baconnier
> Business Solutions Software Developer
> 
> Camptocamp SA
> PSE A, CH-1015 Lausanne
> Phone: +41 21 619 10 39
> Office: +41 21 619 10 10
> http://www.camptocamp.com/
> 
> --
> Mailing list: https://launchpad.net/~openerp-connector-community
> Post to     : openerp-connector-community@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openerp-connector-community
> More help   : https://help.launchpad.net/ListHelp
> 
> 
> --
> Mailing list: https://launchpad.net/~openerp-connector-community
> Post to     : openerp-connector-community@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openerp-connector-community
> More help   : https://help.launchpad.net/ListHelp

-- 
Mailing list: https://launchpad.net/~openerp-connector-community
Post to     : openerp-connector-community@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~openerp-connector-community
More help   : https://help.launchpad.net/ListHelp


Follow ups

References