| View previous topic :: View next topic |
| Author |
Message |
shopallure
Joined: 25 Jul 2007
Posts: 81
|
 Posted: Fri May 09, 2008 12:21 pm Post subject: how to sort my picklist by... |
 |
|
my current picklist sorts by warehouse location, but the problem is for an order with multiple items on there, it doesn't keep the order together. for example,
order 1 has locations: 54G and 12A
order 2 has location: 33b
order 3 has locations: 39 and 59
the picklist will have this order:
12A
33b
39
54G
59
the items within the orders aren't sorted together. but at the same time i don't want to sort by order number because the only purpose of sorting by warehouse location is to provide smooth picking order for my pickers.
so how can i sort the picklist in the same fashion as they appear on the shipworks panel when you sort by warehouse location? i just need multiples to not be separated from their orders.
if this cannot be accomplished, how can i sort like an excel spreadsheet file where i can sort by first priority: shipping method and then 2nd priority warehouse location?
here's my picklist template:
| Code: | <?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:sw="http://www.interapptive.com/shipworks" extension-element-prefixes="sw">
<sw:settings>
<sw:page-setup>
<sw:height>8.5</sw:height>
<sw:width>11</sw:width>
</sw:page-setup>
<sw:preview>
<sw:filter></sw:filter>
<sw:count>3</sw:count>
</sw:preview>
<sw:general>
<sw:type>report</sw:type>
</sw:general>
</sw:settings>
<!-- Import core functions from Common -->
<xsl:import href="System\Common" />
<xsl:output method="html" encoding="utf-8" indent="yes" />
<!-- -->
<!-- Start of processing -->
<!-- -->
<xsl:template match="/">
<html>
<head>
<title>
Party Life 365 Pick List
</title>
<!-- Output all the CSS required for this template -->
<xsl:call-template name="outputStandardCss" />
<style>
h1
{
font-size: 14pt;
}
</style>
</head>
<body>
<h1> <xsl:value-of select="//Store/StoreName" /> -- <xsl:value-of select="sw:ToShortDate(//Generated)" /></h1>
<table id="orderdetails" cellspacing="0" cellpadding="0">
<tr class="header">
<td>Order</td>
<td>Date</td>
<td>Item Description</td>
<td>Location</td>
<td>SKU Number</td>
<td>Quantity</td>
<td>Status:</td>
</tr>
<!-- Group by item Warehouse Location-->
<xsl:for-each select="//Order/Item">
<xsl:sort select="Location" />
<xsl:variable name="order" select="//Order[1]" />
<tr class="orderitem">
<td><xsl:value-of select="../Number" /></td>
<td><xsl:value-of select="sw:ToShortDate(../Date)" /></td>
<td><xsl:value-of select="Name" /></td>
<td><xsl:value-of select="Location" /></td>
<td><xsl:value-of select="Code" /></td>
<td><xsl:value-of select="Quantity" /></td>
<td><xsl:value-of select="$order/Status" /></td>
</tr>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet> |
|
|
| Back to top |
|
Brandon
Joined: 14 Nov 2005
Posts: 1122
|
| Posted: Fri May 09, 2008 2:30 pm Post subject: |
|
|
I'm not quite clear on how you want to sort, but you just need to change the line that says: | Code: | | <xsl:sort select="Location" /> |
You can read more about the xsl:sort element in ShipWorks' help files or online: http://www.w3schools.com/xsl/el_sort.asp
I don't think you can sort on multiple nodes (shipping method and warehouse location), but you can always try concatenating the strings of the nodes. That should give you the same result. |
|
| Back to top |
|
shoeboxsavings
Joined: 28 Sep 2006
Posts: 13
|
| Posted: Tue Mar 27, 2012 10:57 am Post subject: |
|
|
I am having the same problem you are. Did you ever find a solution to your pick list?
If so can you post your solution.
Thank you so much.
Gina
_________________
Shoebox Savings Inc |
|
| Back to top |
|
|
