Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Page 2 of 7
Import/Export orders? 
 
the311guy
Sr. Member
 
Avatar
Total Posts:  120
Joined:  2007-10-18
 

Can I be a client, and can I request this feature? haha.

 
Magento Community Magento Community
Magento Community
Magento Community
 
nicolas46
Sr. Member
 
Total Posts:  210
Joined:  2008-04-09
Toulouse
 

I guest your client gone work on the order with his ERP; for exemple I will invoice them or cancelled or send....

In order to have a right information on “My account” page of yours customers, i assume you gone import your order with the new data, isn’t it ?, can you give us more informations on that please.

 
Magento Community Magento Community
Magento Community
Magento Community
 
nicolas46
Sr. Member
 
Total Posts:  210
Joined:  2008-04-09
Toulouse
 

i have the PHP|Architect book aswell and I am trying to implement the “hello world “ sample (at the begin of chapter 10)
I just copy/paste the code in the right file but all I get is a 404 page >:-(

app/etc/modules/Company.xml

<?xml version="1.0"?>
<config>
    <
modules>    
        <
Company_AdminRest>
            <
active>true</active>
            <
codePool>local</codePool>
        </
Company_AdminRest>
    </
modules>
</
config>

app/code/local/Company/AdminRest/config.xml

<?xml version="1.0"?>
<config>
    <
modules>
        <
Company_AdminRest>
        <
version>0.6.0</version>
        </
Company_AdminRest>
    </
modules>
    <
admin>
        <
routers>
            <
adminrest>
                <use>
admin</use>
                <
args>
                    <
module>Company_AdminRest</module>
                    <
frontName>adminrest</frontName>
                </
args>
            </
adminrest>
        </
routers>
    </
admin>
</
config>

app/code/local/Company/AdminRest/controllers/IndexController.php :

<?php
class Company_AdminRest_IndexController
    
extends Mage_Adminhtml_Controller_Action
{
    
public function indexAction()
    
{
        
echo "Hello, World.";
    
}
}

...../magento/index.php/adminrest -->404 !!

What am i doing wrong please ?

[update]

Solved (i don’t know why but it’s working now so...)

 
Magento Community Magento Community
Magento Community
Magento Community
 
freshwebs
Sr. Member
 
Total Posts:  153
Joined:  2008-05-27
Leicestershire, UK
 

Seems a little bit pricey to me. Also, there’s no guarantee that if I did donate that you’d get the $20k required to develop the module & deliver it to us all. Seems too risky a punt at the moment.
Don’t let me put others off tho’.
Eddie

 
Magento Community Magento Community
Magento Community
Magento Community
 
porterhouse
Jr. Member
 
Total Posts:  27
Joined:  2008-02-23
 

yeah, would need to be some agreement about getting money back if you couldn’t meet the threshhold and a statement of work outlining expectations.

 
Magento Community Magento Community
Magento Community
Magento Community
 
ZDOG
Jr. Member
 
Total Posts:  7
Joined:  2008-04-22
 

20+K for an export module!

I thought this was PHP, not SAP wink

I think we’d like to hear your ideas about what you could deliver for that amount, then tweak accordingly.

If you get 40 people at $500 each and the module needs to work with everything from Quickbooks to Peachtree to SAP to Oracle to Microsoft then I’m pretty confident *everyone* will end up unsatisfied.

We’d prefer to buy a module that exports all product and customer info on a per order basis in XML that we could then parse for import into our system (SAP B1).

 
Magento Community Magento Community
Magento Community
Magento Community
 
dan_w
Sr. Member
 
Total Posts:  290
Joined:  2008-01-04
 

I’m just curious about a couple of things. Is this an order export module or an integration module? Can’t say I’m very familiar with Peachtree or SAP, but I have integrated quickbooks/quickbooks pos before and generally the method was either webconnector or rds. In the past on other shopping carts people built modules that exported orders in quickbooks iif format, but I’m not sure if intuit allows iif imports anymore. I haven’t worked with it for a while. I’d be interested to know the specs of what could realistically be expected, ie choices to export orders in csv, xml, qbxml, or what have you, or is this a more seamless approach through a piece of middleware. Like I said, I’m not familiar with peachtree or microsoft or SAP, so I don’t know if they allow direct file imports for sales, but I’d be curious to know exactly what the order export module would do. I know you say you’d try to tailor it to the requests of the donors, but you certainly have to have a general framework in place.

 
Magento Community Magento Community
Magento Community
Magento Community
 
te-brian
Jr. Member
 
Total Posts:  2
Joined:  2008-06-23
 

To fix the problem with headers being sent, you need to exit after you are done echoing all the xml.  I also added a header() call to set the content type and echoed more appropriate doc type info before any xml.

 
Magento Community Magento Community
Magento Community
Magento Community
 
redpen
Sr. Member
 
Total Posts:  254
Joined:  2008-01-23
 
te-brian - 27 July 2008 01:57 PM

To fix the problem with headers being sent, you need to exit after you are done echoing all the xml.  I also added a header() call to set the content type and echoed more appropriate doc type info before any xml.

How do you use the code to view a particular order ref, and list all the items bought?

 
Magento Community Magento Community
Magento Community
Magento Community
 
nicolas46
Sr. Member
 
Total Posts:  210
Joined:  2008-04-09
Toulouse
 

oh oh So...if i understand well, there is now a export module but only for people who paid confused ...

 
Magento Community Magento Community
Magento Community
Magento Community
 
hyteckit
Sr. Member
 
Avatar
Total Posts:  166
Joined:  2008-04-01
Los Angeles, CA
 

Hey, I’ll do it for $2000.  I’m that cheap to hire.

 
Magento Community Magento Community
Magento Community
Magento Community
 
XTENTO
Member
 
Avatar
Total Posts:  50
Joined:  2008-09-03
Location: Magento Universe
 

Hi everybody,

I started developing an order export module some days ago.
The module currently has those features discussed in here, and I think I will send out the first beta in like a week.
I am looking for beta-testers. If you are interested, contact me through private messaging.
Please contact me with some details. Tell me which features you want, and in which format you need the export, just what you want to tell me how your order export module would have to look like.
Best would be if you for example send me a xml-template how your order would have to look like.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Kerry Hatcher
Sr. Member
 
Avatar
Total Posts:  96
Joined:  2008-07-15
Macon, GA
 

I’m working on an ACT! CRM/Peachtree Account connector, maybe we should put our heads together.

Thanks,

 
Magento Community Magento Community
Magento Community
Magento Community
 
XTENTO
Member
 
Avatar
Total Posts:  50
Joined:  2008-09-03
Location: Magento Universe
 

Yep, that would be nice.

In my order export module, you can modify how your xml output should look really easily through the backend.
I am using XSL “templates”, so you can build your own XML, and being able to access ALL order data.

Example:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<
xsl:template match="/">

<!-- 
Put tags in herewhich should wrap around each order -->
<
orders>

<!-- 
Process order XML -->
<
xsl:for-each select="orders/order">
    <!-- 
ExWrap <orderaround each order -->
    <
order>
    <!-- 
ExThen access values from export xml and put them into your own tags -->
    <
id><xsl:value-of select="ID"/></id>
    <
created><xsl:value-of select="created_at"/></created>
    <
email><xsl:value-of select="customer_email"/></email>
    <!-- 
ExNow go to the billing section -->
    <!-- 
ExWrap <billingaround billing section -->
    <
billing>
    <
xsl:for-each select="billing">
        <!-- 
Exget values and wrap them into your own tags from billing section -->
        <
prefix><xsl:value-of select="prefix"/></prefix>
        <
name><xsl:value-of select="lastname"/></name>
    </
xsl:for-each>
    <!-- 
ExWrap </billingaround billing section -->
    </
billing>
    <!-- 
ExWrap </orderaround each order -->
    </
order>
</
xsl:for-each>

<!-- 
Put end tags in herewhich should wrap around each order -->
</
orders>

</
xsl:template>
</
xsl:stylesheet>

I am going to implement CSV now.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Nexus Rex
Sr. Member
 
Avatar
Total Posts:  139
Joined:  2008-07-10
Utah, USA
 

Sebastian,

I would like to be a beta tester. I can help with development if you need as well, but it looks like you have it all under control.

Travis Cable

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top
Page 2 of 7