Anyone know how to import orders into Zencart?

[totalsam]

Hi,

I'm looking to import orders into ZC and was wondering if anyone knew of an add on or mod that can do this?

There seems to be alot of people who have created mods to export in various format has no one tried reversing this to import orders?

(specifically I wish to manually import amazon orders from their downloads)

Thanks

[kuroi]

I know of no add on or mod to do this. Theoretically, this import could be done, it's just a matter of populating the relevant tables with the data needed (though it would be difficult to generalise it into a mod). The difficult bit is making sure that the data in these tables is linked together correctly and makes use of the correct order statii.

The complexity is sufficient that, although we've converted a lot of client sites from other carts into Zen Cart, always convert the products, and usually convert the customers, we've yet to have a client who felt the cost of converting the orders would justify the return. And that's for a one-off conversion, a regular import would need to be more robust and therefore more complex.

[totalsam]

Would it be possible to manually import csv files straight into the database on the php my admin?

If so which tables would I need data for?

I would be prepared to have all the customers as simply "Amazon Customer" but would obviously need all the shipping addresses independant.

[schoolboy]

Er...

I think Kuroi just answered your initial question...

This is COMPLEX and DIFFICULT and EXPENSIVE and will require CUSTOM development...

Post for help in the Commercial Help Wanted section...

[totalsam]

Er...

I don't think you read my question. (tone noted)

It is very simple to upload things into the database manually - I know this. I just want to know how many and which tables I would have to upload things into to figure if it is worth bothering with or not.

[jackie.taferner]

totalsam,

It's not that simple, especially if you're importing from a non-zencart site. All the names of the database tables will not match, the structure of the tables is different, and will need to be manually changed before uploading into the new db. It's like fitting a square peg into a round hole.

On top of that you're going to need detailed customer data brought over, becuase without that, who made the orders, and for what shipping address? One customer cannot have thousands of names or addresses associated with them. You'll need these separated as different customers.

To answer your original question, there is no mod for this, because it would be impossible to make one. This needs to be done manually. It's not a simple process, you'll need a skilled zencart/mysql developer to do this for you.