Page 1 of 1

Quick nVelocity question regarding purchase orders

Posted: Thu Sep 30, 2010 5:50 pm
by mmackrell
My company does a lot of work with customers on terms, I need to determine what the "proper" verbiage is for pulling the purchase order information from a customers order for use in an email.

I am currently trying: $order.PurchaseOrder, but that is not working. I assume that everything after the . is the name of the field, and I don't have a copy of the schema to know what this field really is.

Thanks,
Margie

Re: Quick nVelocity question regarding purchase orders

Posted: Mon Oct 04, 2010 5:08 am
by mazhar
You need to check this information upon each payment.

Code: Select all

#foreach ($payment in $order.Payments)
#if ($payment.PaymentMethod.PaymentInstrument== "PurchaseOrder")
                //DO YOUR STUFF HERE
#end
#end

Re: Quick nVelocity question regarding purchase orders

Posted: Tue Oct 05, 2010 9:34 pm
by Thistle3408
mm,


Regarding your comment about not having the DB Schema...
You will want to look at this http://wiki.ablecommerce.com/index.php/Database

The AC schema is specifically at http://wiki.ablecommerce.com/images/3/3 ... Schema.pdf
but looking at the DataPort Utility is helpful, too.

Re: Quick nVelocity question regarding purchase orders

Posted: Wed Oct 06, 2010 4:44 am
by mazhar
Actually I think Margie was not asking about Database schema but about the structure of our API. NVelocity simply provides you access on different API variables those in turn provide you access on different information. We have a document about our API at following location ftp://ftp.ablecommerce.com/evals/Commer ... 7_Help.zip

I am just not sure whether its updated or not. Even in case its old I think most of things will work.

Re: Quick nVelocity question regarding purchase orders

Posted: Wed Oct 06, 2010 6:10 pm
by mmackrell
I'll check all of it out and see what I can find. Thanks both of you :)