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.