Product Code in orders.dbf file

[apponline]

Hey,

I would like to know if its possible to get the products purchased on an order included in the orders.dbf file. This file has all imformation about each order but not the product code or name that was purchased.

Is it possible to have this included in the file or is there another file that has this information?

Thanks for your time.

[Vic - WolfPaw Computers]

Ordopts.dbf contains that info.

Is there a reason you dont use a batch report for this info?

Truxoft's UltraBatch (http://tinyurl.com/p5t22) gives a great batch report with customizable exported fields.

[apponline]

Thanks for the answers.

I have had a look at that batch report module, but I am unsure if this creates a dbf file that you can download via ftp (much like orders.dbf)

Also, i checked out ordopts.dbf however this does not list the product code, it lists other fields like the price, attr and optcode fields, but not the product code. Also, i cant see a order number or anything else to match it up to the orders in orders.dbf.

Thanks.

[Vic - WolfPaw Computers]

Ultrabatch creates either a .dat, .txt, .csv, or .xls file that can be downloaded or emailed.

You can customize which fields are included.