batch orders?

[99darkgreenGT]

i am looking for a way to take my daily orders and get them all into one file (some type of tab deliminated file would work). we currently email all our orders to our supplier where they dropship for us. it is very time consuming to go through each order and copy and paste the necessary info into an email for our supplier.

 

i am hoping someone can help me out with getting something done that will work. basically i need the following things from the invoice:

 

invoice number

customer name

customer shipping address

products purchased

quantity

product attributes

customer comments

shipping method

 

i have the "orderlist contrib" - http://www.oscommerce.com/community/contributions,1836 installed but it does not provide all the info i need. all it gives me is the order number, item purchased (no attributes), quantity, and price.

 

hopefully there is a way to hack this code to get the info i need. i am not php proficient, so i don't know where to begin. any and all help will be appreciated :D

 

btw, i was looking at the "batch order center contrib - http://www.oscommerce.com/community/contributions,1836 " but looks like it is for ms1? i am using ms2 <_< i don't really need pdf files, but no complaints if it can work with ms2, although i am not sure how to make it work.

 

thanks in advance for any help!

[99darkgreenGT]

anyone? :unsure:

[mutter]

Just play with the code, if you want that the orderlist contribution show the customer delivery address, etc, you can add this:

 

<?php

 

echo "".$row{'delivery_name'};

echo "<br>".$row{'delivery_street_address'};

echo "<br>".$row{'delivery_suburb'};

echo "<br>".$row{'delivery_postcode'};

echo "<br>".$row{'delivery_city'} . ", " . $row{'delivery_state'};

?>

</FONT></TD>

 

Send me a PM if you want my file...

[Guest]

Is there anyway to have it exported into a text or .xls document ?

[Guest]

see http://www.oscommerce.com/forums/index.php?showtopic=78230 for how to make the batch order center work for MS2.

 

-jared