[HACK] Export Orders and Batch update of Status

[wadeo]

I was able to get it to work, I had a permissions error on my end.

Thanks for a great tool ...

***I was wondering if anyone has had any luck with export 1.1-0.4 ?
I have downloaded it and uploaded it a couple of times with no luck.

All files upload,no errors and I see no changes in VirtueMart(Simple or Extended views).
I'm using the following,
Joomla 1.5.8
VirtueMart 1.1.3

Do I have to run any additional files? Has something been left out from version export -1.1.0.3?

Any help would be grand..****

Fixed... If your having the same issue, check to see if your user account is the same one as your Joomla install, I was using a different account so my install failed.

[wadeo]

I have another question about the sales export feature, If I wanted to add another field to the export how hard is that to do.

For instance I would like to export credit card information. We sometimes have to process sales offline.

Any thoughts on how this can be accomplished?

This is a awesome app, real time saver..

Thanks

[chris.t.uk]

To export credit card details you will need to modify the query in get_query() in ps_orders_export.php (I think you'll need to join in table jos_vm_order_payment)

Then just find the function that relates to the type of export you want and add in the fields, also in ps_orders_export.php

If you can do the SQL then it is very easy.

Chris.

[purestore]

Hi,

I installed this report by uploading the administrator and components folders via ftp. Installation worked fine however, I get the following error message when using Excel (.xls) as export of choice.

Fatal error: Call to undefined method ps_orders_export::getVendor() in /home/mysite/public_html/administrator/components/com_virtuemart/classes/ps_orders_export.php on line 472

Using Joomla 1.5.10 and vm 1.1.3

[chris.t.uk]

export-1.1-0.5 fixes this.

Chris.

[DaisyEE8]

Great work! Exactly what I was looking for.
There ist only one little thing.

Can I export the data in UTF-8?
My umlauts are not shown correctly in Excel.

[wadeo]

To export credit card details you will need to modify the query in get_query() in ps_orders_export.php (I think you'll need to join in table jos_vm_order_payment)

Then just find the function that relates to the type of export you want and add in the fields, also in ps_orders_export.php

If you can do the SQL then it is very easy.

Chris.

I took a look and it looks like I will need to define other sections of the ps_orders_export.php to out put the CC info.

I was wondering is it possible to include an option to output the CC info or to have a custom ps_orders_export.php that can be downloaded.

Thanks,
wadeo

[Landrovergek]

I installed it the ftp way.

But I can only get the csv and txt export working. the excel export is not working coorectly for me. Do i do something wrong?

VM 1.1.2, Joomla 1.5.9

[chris.t.uk]

Hi all,

Sorry for the delay.

Daisy, export-1.1-0.6.zip supports UTF-8, please let me know how you get on. You only need to upload the ps_export_orders.php file.

Wadeo, an option for CC details would need a bit of work, please PM me if you would like a custom file.

Landrovergek, what error messages do you get? Have all the PEAR support files been uploaded correctly?

Regards,

Chris.

[wadeo]

Great we now have the ability to export the orders. Now for something a bit more tricky....

I was wondering if it is possible to make changes and now import that data?

If not is there a way that I can make mas updates to the status of a range of orders?

[wadeo]

chris.t.uk ...PM sent...

[chris.t.uk]

Hi wadeo,

There is the functionality to update a range of orders in the hack, as is, it's in the pink.

OK, you can't select individual orders but my idea is really to export all completed orders and then set the status to shipped so I know what is dealt with, dealing with cancellations/unfulfillables ad hoc.

I can see that people would like to see this on the Order List page, so that they can select the orders to update.  This is not on the horizon at the moment.

To be honest I am working on VM1.2 at the moment and this is taking most of the free time that I have for development. Once VM1.2 is out and depending on how other things pan out then the exporting of credit cards details and importing orders (this would be good for migration from other systems) and selecting individual orders to mass update will move up the agenda.

Regards,

Chris.

[DaisyEE8]

The umlauts are working now - thanks.

But there are some problems.
Everytime I export to excel I get an error message. "File error - Some Numberdata could be lost"
(Dateifehler - Einige Zahlendaten sind möglicherweise verloren gegangen)

I use german language J!1.5.9 with VM 1.1.2


p.s.
The & is shown as &

[chris.t.uk]

Hi daisy,

Could you check that there are actually orders in the state selected, or even retry with all states selected.   I have noticed this when there are not any orders to export.

Chris.
I will look into the &

[DaisyEE8]

We have 150 orders per month (round about) with a total of 500 oders in several states.
No order state is empty.

Do you need more information about our system?
If you wish I can give you one of those excel sheets.