Post by PeeWee » Sun Jan 15, 2012 1:04 am

Thanks in advance, I don't usually start off with a first post question but I'm stumped.

I'm running version 1.5.1.3 I would like to add the location field to admin invoice. I have it added to the invoice tpl template but can't get it called properly on the order.php page. I tried to modify another solution to call the sku to the invoice but it didn't work for location.

Anyone help with the verbage to call the location column on the order page?

I was a good and searched and searched for a solution or extension.
Last edited by PeeWee on Sun Jan 15, 2012 3:17 am, edited 2 times in total.

Newbie

Posts

Joined
Sun Jan 15, 2012 12:32 am

Post by straightlight » Sun Jan 15, 2012 1:12 am

Would it be possible to clarify what you mean by location ? Is it the address, city, state, country etc ?

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by PeeWee » Sun Jan 15, 2012 1:18 am

Thanks for the reply, on the product pages there is a location field by the sku and upc . My customer has decided he want to use it so he knows what vendor to order from and want it on the invoice.

Newbie

Posts

Joined
Sun Jan 15, 2012 12:32 am

Post by straightlight » Sun Jan 15, 2012 1:41 am

Right. Download this XML file from the attachment and by using VQMod, this feature under the admin order invoice should load smoothly.

Note: Tested on v1.5.1.3 release of OpenCart.

Attachments

Last edited by straightlight on Sun Jan 15, 2012 2:53 am, edited 1 time in total.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by PeeWee » Sun Jan 15, 2012 2:01 am

Thats works great with one minor hicup, the last location is echoed down the rest of the table. ie subtotal/shipping/tax/total. I appreciate the help.
Thanks

Newbie

Posts

Joined
Sun Jan 15, 2012 12:32 am

Post by straightlight » Sun Jan 15, 2012 2:09 am

Could you post a screenshot of the output you see as an attachment of the invoice version you have ? I can't seem to reproduce this from my end.

Note: Either highlight in black all customers entries or simply capture the part from the screenshot where you specifically mean on the invoice before posting. ;)

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by PeeWee » Sun Jan 15, 2012 2:19 am

Product Model Quantity Location Unit Price Total
EARPRO SONIC DFNDR LG CLR 1 PAIR ear plug - 3RSR 19 RSR $12.95 $12.95
5 Person Tent 5 Person Tent - 3mayday 0 mayday $99.95 $99.95
mayday Sub-Total: $112.90
mayday Free Shipping: $0.00
mayday Washington: $9.71
mayday Total: $122.61

I'm at my regular job so don't have home computer. So can't do the screens. If it works fine on your end it's golden I'm sure, I was messing with the files so I'll have to put the original files back. make sure it's not my inept coding. I'll let you know if it's still like it after I put it back.

You rock for sure.

Newbie

Posts

Joined
Sun Jan 15, 2012 12:32 am

Post by PeeWee » Sun Jan 15, 2012 2:34 am

Still echo after originals uploaded.

Product Model Quantity Location Unit Price Total
MAG5-60 SUF MAG5-60 48 TGD $129.00 $129.00
TGD Sub-Total: $129.00
TGD Pickup From Store: $0.00
TGD Coupon(kc2012): $-12.90
TGD Washington: $9.98
TGD Total: $126.08

Thanks

Newbie

Posts

Joined
Sun Jan 15, 2012 12:32 am

Post by straightlight » Sun Jan 15, 2012 2:39 am

This is the result I have from the invoice regarding the location alignment.

If you don't see the alignment as such, it means you played straight into the admin invoice's template core file to integrate this while there's no need to. Simply from VQMod took me a couple of mins only to code this. ;)

Note: The different language you see is because I'm testing many languages right now.

Attachments

opencart_admin_invoice_location.PNG

opencart_admin_invoice_location.PNG (4.68 KiB) Viewed 3033 times


Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by PeeWee » Sun Jan 15, 2012 2:46 am

That is what it looks like if no location is entered, On your pic you see on the left the extra column under product. it's not the same column as product. If you enter a location it will fill the fields on the left under product. Wish I had screen shot. lol

Newbie

Posts

Joined
Sun Jan 15, 2012 12:32 am

Post by straightlight » Sun Jan 15, 2012 2:49 am

You're right, I didn't noticed that. I will see how this can be fixed from the template.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by PeeWee » Sun Jan 15, 2012 2:53 am

When I was messing with it before I had resigned to adding a "-" to the model cell and putting the location there Never got it to call right but couldn't get the table to cooperate. :crazy:

Newbie

Posts

Joined
Sun Jan 15, 2012 12:32 am

Post by straightlight » Sun Jan 15, 2012 2:54 am

XML file modified on the above.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by PeeWee » Sun Jan 15, 2012 3:07 am

Works like a charms! They should add a reputation to the forum cause you deserve a point or 5 ! I've been beating my head for about a week on this. Guess I should look into vqmod. You have a program for that or you that fast naturally?

:good:

Thanks Alot.

Newbie

Posts

Joined
Sun Jan 15, 2012 12:32 am

Post by straightlight » Sun Jan 15, 2012 3:22 am

Actually VQMod can also be done from a generated page now but I always do it manually for safety reasons before I provide. ;)

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by PeeWee » Sun Jan 15, 2012 3:30 am

Your help is much appreciated.

Newbie

Posts

Joined
Sun Jan 15, 2012 12:32 am

Post by suzukishoes » Wed May 30, 2012 6:05 pm

I might be a little late to the party for help, but I found this topic after a search & installed the XML but what I am finding is the location is showing perfectly but the "Quantity" column is now showing the quantity remaining in stock, rather than the quantity ordered?

Any help would be greatly appreciated!

Lee

New member

Posts

Joined
Tue May 01, 2012 4:45 pm

Post by suzukishoes » Tue Jun 05, 2012 3:21 pm

Can anyone help me with this? Its something I really need to sort out, but don't have the skills!

New member

Posts

Joined
Tue May 01, 2012 4:45 pm

Post by straightlight » Wed Jun 20, 2012 6:38 pm


Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Who is online

Users browsing this forum: Semrush [Bot] and 60 guests