Sort order for purchase orders for footwear and apparel

Posted by Kris on February 2, 2006, 1:00 am

Please log in for more thread options

I have a problem with RMS Purchase Orders sorting by the ILC. When I
imported my data from Quicksell, RMS used each item's UPC code to populate
the ILC. In many cases the UPC numbers do not follow a logical order (i.e.
successive sizes do not necessarily have successive UPC codes - a majority of
our items are Matrix type). As such, the items aren't sorted in a logical
fashion. Can I run a querry that will take the UPC out of the ILC and move
it to Alias? Then I would need to have the ILC become something more
meaningful (i.e. the Matrix Parent ILC with the size appended)?

The final challenge is then, if I can get this to happen, how do I make
numbers and sizes sort in a logical fashion - here's the problem...
My vendors want to see my orders in size order (i.e. 9, 9.5, 10, 10.5 or XS,
S, M, L, XL). RMS defaults to sorting these same numbers as 10, 10.5, 9, 9.5
and L, M, S, XL, XS (it sorts numbers using the first digit, not the values
and the apparel sizes are sorted alphabetically). If I could run a querry to
add a zero in front all number that are less than 10, then things sort
correctly. Any idea on that querry? What about the apparel sizes? Do I
need to do something like add a number in front of each size (i.e. 1XS, 2S,
3L, 4XL, 5XXL?

I would appreciate any feedback.
--
Kris

Posted by Rob on February 3, 2006, 12:55 pm

Please log in for more thread options

For your footwear and other number dimensions, what we tell our client is to
use a 3 digit code.
i.e.
060 Size 6
065 Size 6.5
070 Size 7
075... Size 7.5
100 Size 10
105 Size 10.5
110 Size 11
115 Size 11.5

For your S, M, L I don't have an answer.

Rob

"Kris" wrote:

> I have a problem with RMS Purchase Orders sorting by the ILC. When I

> imported my data from Quicksell, RMS used each item's UPC code to populate

> the ILC. In many cases the UPC numbers do not follow a logical order (i.e.

> successive sizes do not necessarily have successive UPC codes - a majority of

> our items are Matrix type). As such, the items aren't sorted in a logical

> fashion. Can I run a querry that will take the UPC out of the ILC and move

> it to Alias? Then I would need to have the ILC become something more

> meaningful (i.e. the Matrix Parent ILC with the size appended)?

> The final challenge is then, if I can get this to happen, how do I make

> numbers and sizes sort in a logical fashion - here's the problem...

> My vendors want to see my orders in size order (i.e. 9, 9.5, 10, 10.5 or XS,

> S, M, L, XL). RMS defaults to sorting these same numbers as 10, 10.5, 9, 9.5

> and L, M, S, XL, XS (it sorts numbers using the first digit, not the values

> and the apparel sizes are sorted alphabetically). If I could run a querry to

> add a zero in front all number that are less than 10, then things sort

> correctly. Any idea on that querry? What about the apparel sizes? Do I

> need to do something like add a number in front of each size (i.e. 1XS, 2S,

> 3L, 4XL, 5XXL?

> I would appreciate any feedback.

> --

> Kris