Joined: 25 Jul 2007
|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:
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:
|<?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">
<!-- Import core functions from Common -->
<xsl:import href="System\Common" />
<xsl:output method="html" encoding="utf-8" indent="yes" />
<!-- Start of processing -->
Party Life 365 Pick List
<!-- Output all the CSS required for this template -->
<xsl:call-template name="outputStandardCss" />
<h1> <xsl:value-of select="//Store/StoreName" /> -- <xsl:value-of select="sw:ToShortDate(//Generated)" /></h1>
<table id="orderdetails" cellspacing="0" cellpadding="0">
<!-- Group by item Warehouse Location-->
<xsl:sort select="Location" />
<xsl:variable name="order" select="//Order" />
<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>
Joined: 14 Nov 2005
|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:
|<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.
Joined: 28 Sep 2006
|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.
Shoebox Savings Inc