Return-Path: Delivered-To: apmail-ofbiz-user-archive@www.apache.org Received: (qmail 47980 invoked from network); 3 May 2008 02:31:15 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 3 May 2008 02:31:15 -0000 Received: (qmail 94070 invoked by uid 500); 3 May 2008 02:31:15 -0000 Delivered-To: apmail-ofbiz-user-archive@ofbiz.apache.org Received: (qmail 94058 invoked by uid 500); 3 May 2008 02:31:15 -0000 Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ofbiz.apache.org Delivered-To: mailing list user@ofbiz.apache.org Received: (qmail 94047 invoked by uid 99); 3 May 2008 02:31:15 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 02 May 2008 19:31:15 -0700 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [205.178.146.61] (HELO omr11.networksolutionsemail.com) (205.178.146.61) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 03 May 2008 02:30:29 +0000 Received: from mail.networksolutionsemail.com (ns-omr11.mgt.hosting.dc2.netsol.com [10.49.6.74]) by omr11.networksolutionsemail.com (8.13.6/8.13.6) with SMTP id m432Ufbd010583 for ; Fri, 2 May 2008 22:30:42 -0400 Received: (qmail 30668 invoked by uid 78); 3 May 2008 02:30:41 -0000 Received: from unknown (HELO ?127.0.0.1?) (bjfree@free-man.net@208.54.15.148) by ns-omr11.lb.hosting.dc2.netsol.com with SMTP; 3 May 2008 02:30:41 -0000 Message-ID: <481BCDFC.5030801@free-man.net> Date: Fri, 02 May 2008 19:29:16 -0700 From: BJ Freeman User-Agent: Thunderbird 1.5.0.13 (Windows/20070809) MIME-Version: 1.0 To: user@ofbiz.apache.org Subject: Re: using XML Import to load orders References: <17021665.post@talk.nabble.com> <481B34F9.60506@free-man.net> <17026145.post@talk.nabble.com> In-Reply-To: <17026145.post@talk.nabble.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org I read in the xml in its native format from the website I then convert to maps needed for the service calls. 1)check to see if a customer exist if not create based on the order 2)if a customer exist is the ship already in the customer info, if not put order on hold as a possbile forgery 3)Create order header 4) add items to order 5) add payment 6) add ecas to verify payment info for fraud (not in ofbiz) 7) check order against inventory or Dropshipper (not in ofbiz) 8) put on hold if no inventory or until verrify with dropshipper (not in ofbiz 9) let ofbiz take over from here. Jim Yanda sent the following on 5/2/2008 12:21 PM: > Hi BJ, > Can you give me a little detail about how you made the import? Did you use > the XML Import or did you write directly to the database? > Thanks, > Jim > > > BJ Freeman wrote: >> I did an import that created a order as if it was generated by ofbiz. >> but using the services you can be sure that the order is entered >> properly, even if is paid for on the website. >> >> Jim Yanda sent the following on 5/2/2008 8:19 AM: >>> Hello, >>> We have an external webstore and would like to load the orders from there >>> into OFBiz using the XML Import in Web Tools. Is this feasible and has >>> anyone done this? Can you give me the gist of how its done? We've done >>> Party >>> and Contact loads using a spreadsheet to build the XML and that worked >>> nicely. But we realize loading orders is more involved; headers, lines, >>> syncing the catalog, checking for existing Parties, etc. >>> Tips and advice appreciated. >>> Thanks. Jim >>> >>> >> >> >