Exporting orders from Zencart

Hi. We are considering using Zencart for our website, but we want to be able to export order information into one of our databases. I can't seem to find any information about exporting orders in FAQ's or on the wiki site. Does anybody know if this is possible using Zencart, and if so, how easy it is?

Thanks so much!

Larkin

You can use one of several bolt-on modules:

Superorders or sales report. They will export data as CSV or TXT files, that can then be imported into other databases / spreadsheets

You can also build your own php script to export data from the database, or even do a query from your MS Excel or MS Access programs.

Thank you for replying- I'm just starting to wonder- is Zencart easily compatible with Macs and a Mac database? We are a Mac based company.

Thanks

creativenonfiction:

Thank you for replying- I'm just starting to wonder- is Zencart easily compatible with Macs and a Mac database? We are a Mac based company.

Thanks

No reason why it shouldn't zen-cart runs on a mysql DB , you can extract the data from this in any format you like, usually csv can be read by most applications.

I have several scripts / mods that export
orders for reporting,
e-mail address's fopr moving into bulk e-amil applications,
and accounting info into sage accounts .

you can use adobe dreamweaver, Photoshop for your editing , and host it on a linux server , and you have not given a penny / cent to Mr Gates at Microsoft !

crazycucumber:

I have several scripts / mods that export
orders for reporting,
e-mail address's fopr moving into bulk e-amil applications,
and accounting info into sage accounts .

crazycucumber

Can you elaborate on how you export your info so that sage accounts can use the data?

Thanks

Craig

CES:

crazycucumber

Can you elaborate on how you export your info so that sage accounts can use the data?

Thanks

Craig

There is some connector software that we had to pay for , as I dont have enough programming knowledge to know how to import into sage . but PM sent to you giving details of Mods used.

crazycucumber:

There is some connector software that we had to pay for , as I dont have enough programming knowledge to know how to import into sage . but PM sent to you giving details of Mods used.

Thanks for your help.

Craig

Thought I would provide an update.

I used this contrib:
Export invoice totals to .csv file for Excel use
http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_47&products_id=170

as a base and altered it for my needs.

I now export the orders in the correct format for sage instant accounts to import via file>import.

Works great.

Craig

Does Superorders export all customer/shipping/order information to .csv/xml? I am trying to avoid writing my own php scripts or manual export of mySQL db table information.:blink:

CES:

Thought I would provide an update.

I used this contrib:
Export invoice totals to .csv file for Excel use
http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_47&products_id=170

as a base and altered it for my needs.

I now export the orders in the correct format for sage instant accounts to import via file>import.

Works great.

Craig

Hi Craig,

I'm trying to do exactly this, with Sage Instant Accounts. I don't suppose there's any chance of nicking a copy of your modded scripts is there please?

Many thanks

Simon

Send me your email address and I'll send it to you.

Don't want to upload it for everyone as I have 'hard coded' my own account names, tax codes and nominal codes into it.

Have not touched it for yonks. If I did it again fresh now I'd set the variables at the top of the file to be called lower down.

Remember I did not create this script, just amended it to suit my needs.

Anyone else want it, pop me a PM.