Export orders to Spreadsheet / Excel to email to suppliers

[econcepts]

Hi,

I hope someone can help me. I used to use the addon some time ago on 1.3.7 and was working great. An excellent module.
I have now created a new site and using 1.3.8a.
I have tried using all the options but no information is downloaded. I get all the information showing on the left hand side. All I get are the field names and no orders data. I always use test mode so they can be re-expored if required.
I dont know if there is a problem with this in 1.3.8a?
I have updated with the SQL statement. So cant see where I am going wrong, some help would be really appreciated if possible.

Many Thanks
Samantha

This mod had been tested and works on all versions of zen (including 1.3.8a).

When you upgraded could you possibly have altered the way the "state" field displays on the "create an account" form?

Older versions had a bug in them when the state was selected from a drop down (instead of entered by hand into a text field.)

My new version (1.2.7) soon to be released should correct this issue.

How do you have customers enter their "state" on that form currently?

[apsona]

Hi,

I hope someone can help me. I used to use the addon some time ago on 1.3.7 and was working great. An excellent module.
I have now created a new site and using 1.3.8a.
I have tried using all the options but no information is downloaded. I get all the information showing on the left hand side. All I get are the field names and no orders data. I always use test mode so they can be re-expored if required.
I dont know if there is a problem with this in 1.3.8a?
I have updated with the SQL statement. So cant see where I am going wrong, some help would be really appreciated if possible.

Many Thanks
Samantha

You might also try the add-on we've contributed: http://www.zen-cart.com/index.php?ma...oducts_id=1500
Please let me know if you see problems with it.

Hope this helps.
Apsona
http://apsona.com

[Sam_uk]

Hi Guys,

The install is a fresh 1.3.8a no upgrades, no alterations made to the state field from what I know.
Apsona thank you for the alternative, will do the job for now

Thanks for all your help guys

Samantha

[econcepts]

Hi Guys,

The install is a fresh 1.3.8a no upgrades, no alterations made to the state field from what I know.
Apsona thank you for the alternative, will do the job for now

Thanks for all your help guys

Samantha

Sam,

What version of the mod are you running?

1.2.7 is being BETA tested by my members currently and is just about ready for release (a few minor bugs we ran across). This corrects a number of bugs that were introduced in versions 1.2.5 and 1.2.6.

Also, did anything change on your server (PHP version, MySQL Version, etc...)

[riolas]

I would like to export:

products

total sale price

delivery method

name/company address


into .doc file. Is this possible?

[apsona]

Some suggestions, though I'm not sure I fully understand your requirement. If you want to simply export all fields from your order records, you could use our add-on available here: http://www.zen-cart.com/index.php?ma...oducts_id=1500

If you want to export fields from multiple records, e.g., some fields from orders, some from the related products, and some from the related customer, you can use our free ShopAdmin tool to create a custom report containing the fields you want, and then export the results of running it.

Hope this helps.
Apsona
http://apsona.com

[riolas]

i want to export to .doc file and then just print all orders out.

[split63]

What ever became of v1.2.7?

Did the focus shift to Apsona CSV data exporter?

[riolas]

i need a way to export the order info into word so it is easy to print out for the packaging...

[econcepts]

What ever became of v1.2.7?

Did the focus shift to Apsona CSV data exporter?

Nope. No focus on that at the moment.

I just completed the newest version and that is being uploaded now. It is 1.3.0 (moved from 1.2.6 to 1.3.0 due to some new functionality add-ons.)

I just submitted to the zen cart upload section and will post a direct link to it here (with more info) in a minute (in case you can't wait for it to activate on the zen cart downloads side.)