News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

File to edit for inserting custom Order History Field to database

Started by Fariida, October 18, 2013, 18:56:57 PM

Previous topic - Next topic

Fariida

Hi,

I am trying to create a new field for the "virtuemart_order_histories" table in my database. I have already edited the Order view files which is fine to add the new text fields. I am just having trouble locating which file I need to edit to insert the new field values to the database. Such as what I've hacked to add tracking numbers to VM 1.1 here http://forum.virtuemart.net/index.php?topic=75373.msg296899#msg296899

Thanks!

Fariida

Also to clarify I am trying to create a new field in my orders section in the backend. So when you update the order status or insert comments this is where I would like to add tracking numbers etc...

Milbo

Be aware that this fields maybe deleted, if someone updates vm.

I think you should think about to use a userfield plugin, which is just hidden for the users. Hmm does not work for multiple orders, or? the user data is stored plain, that means without reference. there should be a trigger.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Fariida

Thank you. Would you be able to point me to a plugin that can do this function?

Milbo

I just took a short look on your code for vm1.1.

I think what you want should be done either native in the core (u r invited), or via shipment plugin.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Fariida

Ok I see. I wanted to do something a little differently though. I wan to a new field for serial numbers and have successfully been able to save the values to the database but only when I have the notify user check box check it goes blank instead of redirecting. When I have time I'll post code.

Milbo

Hmm for serial numbers,... I would use a customfield plugin.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Fariida

ah Thanks! I figured as much and that it would take me less time trying to do it myself than searching, lol. Do you have any suggestion?

Fariida

One thing more. I am looking but it seems its only for customers to input information. How could I get this on the order view in the backend?

Fariida

Ok, I've found that there is something going on with my notify button in general. I've replaced all my administrator com_virtuemart files to the original ones and found the same problem of my page going blank and not redirecting. :-/ So this is entirely a separate issue.