We're just about to begin our spring shipping season and I need a "pull sheet" to retrieve orders for packing. Using the packing slips is a bad idea since the orders are pulled in batches from a greenhouse and will get messy.
Before switching to Zen, we used a modified version of Orderlist on our osC store. It would print a gridded table with name, address, etc along with the products ordered. It left room for check marks and notes. We'd get 10-15 orders per page, which is much better than simply double printing the packing slips. That's a waste of paper and ink.
Do any admin modifications or report generators have the ability to print orders in a quick sheet in an organized fashion like I mention above?
Ideally, it would be a pdf that makes a clean break if an order doesn't fit at the bottom of the page.
Thread: Shipping Dept "Pull Sheet"
Results 1 to 5 of 5
-
23 Feb 2009, 06:43 PM #1
Zen Follower
- Join Date
- Dec 2006
- Posts
- 199
- Plugin Contributions
- 0
Shipping Dept "Pull Sheet"
-
23 Feb 2009, 09:40 PM #2
Zen Follower
- Join Date
- Dec 2006
- Posts
- 199
- Plugin Contributions
- 0
Re: Shipping Dept "Pull Sheet"
OK, here's the main chunk of code from orderlist.php, which is written for osCommerce. Can anyone give a go at Zenning it for me?
I'm pretty sure it's just a few lines. Thanks!
PHP Code:ob_start();
require('includes/application_top.php');
require(DIR_WS_CLASSES . 'currencies.php');
$currencies = new currencies();
include(DIR_WS_CLASSES . 'order.php');
$order_status = $select_order_status;
$display_order_status = $order_status;
if ($order_status == "")
{
$order_status = 1;
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title><?php echo TITLE . ' - ' . OL_TITLE ?></title>
<link rel="stylesheet" type="text/css" href="orderlist-styles.css" media="all" >
</head>
<body>
<h1><?php echo OL_HEAD; ?></h1><br>
<script language="javascript">
<!--
document.write(Date());
-->
</script>
<h2>
<?php
$query_status = "SELECT * FROM `orders_status` where `orders_status_id` = $order_status AND language_id = $languages_id";
$status_result = tep_db_query($query_status);
while ($row4 = tep_db_fetch_array($status_result))
{
echo "(";
$orders_status_name = $row4['orders_status_name'];
echo $orders_status_name;
echo ")";
}
// FORM THAT LETS YOU SELECT WHICH ORDER STATUS TO DISPLAY
?>
</h2>
<form name="orderstatus" method="post" action="<?php echo $PHP_SELF?>">
<?php
$query_status = "SELECT * FROM `orders_status` WHERE language_id = $languages_id";
$status_result = tep_db_query($query_status);
echo OL_SELECT_STATUS . " ";
echo "<select name=\"select_order_status\">";
echo "<option value=></option>";
while ($row3 = tep_db_fetch_array($status_result))
{
echo "<option value=";
echo $row3['orders_status_id'];
echo ">";
echo $row3['orders_status_name'];
echo "</option><br>";
}
echo "</select>";
?>
<input type="submit" name="Submit" value="<?php echo OL_SUBMIT; ?>"> <input type="button" value="<?php echo OL_PRINT; ?>" onClick="window.print()" />
</form>
<TABLE width="100%" align=center cellSpacing=1 cellPadding=1 border=1>
<TBODY>
<TR class="headers">
<TD align="center" width="5%">
<?php echo OL_ORDERNR; ?>
</TD>
<TD align="center" width="10%">
<?php echo OL_DATE; ?>
</TD>
<TD width="15%">
<?php echo OL_NAME; ?>
</TD>
<td width="25%">Products</td>
<TD width="45%">
<?php echo OL_DETAILS; ?>
</TD>
</TR>
<?php
$query1 = "SELECT * FROM `orders` WHERE orders_status = $order_status ORDER BY orders_id ";
$result = tep_db_query($query1);
while ($row = tep_db_fetch_array($result)) {
$ordernummer = $row['orders_id'];
?>
<TR><span font size="6">
<TD align="center" width="5%">
<?php echo $ordernummer; ?>
</TD>
<TD width="10%"> </TD>
<TD width="15%">
<?php echo $row{'delivery_name'}; ?><br>
<?php echo $row{'delivery_street_address'}; ?>
<br>
<?php echo $row{'delivery_city'}; ?>
 
<?php echo $row{'delivery_state'}; ?>
 
<?php echo $row{'delivery_postcode'}; ?>
<br>
<?php echo $row{'customers_email_address'}; ?>
</TD>
<TD width="25%">
<?php
$order = new order($ordernummer);
for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) {
?>
<br>
O <?php echo $order->products[$i]['qty'] . ' x ' . $order->products[$i]['name']; ?>
<?php
}
?>
</TD>
</span></TR>
<?php
}
?>
</table>
</body>
</html>
<?php
ob_end_flush();
?>
-
6 Mar 2009, 07:23 PM #3
Zen Follower
- Join Date
- Dec 2006
- Posts
- 199
- Plugin Contributions
- 0
Re: Shipping Dept "Pull Sheet"
Anybody?
-
8 Mar 2009, 06:49 AM #4
New Zenner
- Join Date
- Dec 2008
- Posts
- 25
- Plugin Contributions
- 1
Re: Shipping Dept "Pull Sheet"
An ad-hoc SQL statement perhaps ...
-
8 Mar 2009, 11:50 AM #5
Zen Follower
- Join Date
- Dec 2006
- Posts
- 199
- Plugin Contributions
- 0
Re: Shipping Dept "Pull Sheet"
Greg,
Thanks for replying. I don't know the right language to make the request into something Zen will understand. The information and layout are exactly as I want them (it doesn't generate a full admin page, just a simple list of orders in a clean format). I just need a translation to zen.
Similar Threads
-
Why "No, Normal Shipping Rules" option for a "Product - Free Shipping" type?
By ilikemike in forum Built-in Shipping and Payment ModulesReplies: 3Last Post: 31 Dec 2011, 12:34 AM -
remove "width: 150px;" from <div id="categories" class="rightBoxContainer" style="wid
By jamesdavid in forum General QuestionsReplies: 3Last Post: 3 Jun 2008, 11:41 AM -
"Sales Message Goes Here" where in style sheet??
By taguchi_isara in forum Templates, Stylesheets, Page LayoutReplies: 3Last Post: 10 Dec 2007, 11:21 AM -
"Please select a state from the States pull down menu."
By multichild in forum Templates, Stylesheets, Page LayoutReplies: 7Last Post: 14 Nov 2007, 02:40 PM -
No states "pull down menu" when JS disabled
By user2037 in forum General QuestionsReplies: 2Last Post: 9 Aug 2007, 12:33 PM
