Re: SKU

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 11615
interpreted = N
texte = >The webcatalog suppose to sort a products in a catalog by SKU. >The SKU of my product goes 1,2,3,..etc, and I have only one category. > In the results they appear at some messed order and I can't find >any logical explanation to this order. I tried to change the sku >number in different ways - make it like 1001, 2001 etc... but it >does not make any difference at all. Does someone have any idea >why it happens?WebCatalog does not sort unless you tell it to. If you do not explicitly tell it what to sort by, it will 'rank' the search results by 'best match', similar to Lycos, where the most matching fields get listed at the top.Add SKUsort=1&SKUsdir=as&SKUtype=num to your search criteria to force it to sort by SKU in ascending order, with SKUs being interpreted as numbers instead of text.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Subtotal of SKU's that begin with ... (Ki Song 2009)
  2. Re: [WebDNA] Subtotal of SKU's that begin with ... (Govinda 2009)
  3. [WebDNA] Subtotal of SKU's that begin with ... (Ki Song 2009)
  4. Re: need to add a sku field to an existing db ( Dale Lists 2005)
  5. Re: need to add a sku field to an existing db ( devaulw@onebox.com 2005)
  6. Re: need to add a sku field to an existing db ( Dale Lists 2005)
  7. Re: need to add a sku field to an existing db ( Brian Wachter 2005)
  8. need to add a sku field to an existing db ( Dale Lists 2005)
  9. Re: StoreBuilder Easily change a SKU ( Joe D'Andrea 2004)
  10. StoreBuilder Easily change a SKU ( "Sal" 2004)
  11. Re: change sku in lineitem? ( Terry Wilson 2004)
  12. Re: change sku in lineitem? ( "WebDna @ Inkblot Media" 2004)
  13. change sku in lineitem? ( Terry Wilson 2004)
  14. Re: multiple replace sku data (Tim Robinson 2003)
  15. Re: multiple replace sku data (kmac 2003)
  16. Re: multiple replace sku data (Matthew Bohne 2003)
  17. multiple replace sku data (kmac 2003)
  18. Re: Finding unused SKU's in a database (Gary Krockover 2002)
  19. Re: Finding unused SKU's in a database (Rob Marquardt 2002)
  20. Re: Finding unused SKU's in a database (Gyuri 2002)
  21. Re: Finding unused SKU's in a database (Gary Krockover 2002)
  22. Finding unused SKU's in a database (Gary Krockover 2002)
  23. Re: Counter for SKUs viewed (charles kline 2002)
  24. Re: Counter for SKUs viewed (Andrew Simpson 2002)
  25. Counter for SKUs viewed (Paul 2002)
  26. Re: Addlineitems SKU parameter (Clint Davis 2002)
  27. Re: Addlineitems SKU peramiter (Clayton Randall 2002)
  28. Re: Addlineitems SKU peramiter (John Hill 2002)
  29. Re: Addlineitems SKU peramiter (Clint Davis 2002)
  30. Re: Addlineitems SKU peramiter (Donovan 2002)
  31. Re: Addlineitems SKU peramiter (Nitai @ ComputerOil 2002)
  32. Addlineitems SKU peramiter (Donovan 2002)
  33. Re: REPOST: Overwiting SKU in Cart (NovaDerm Skincare Science 2002)
  34. Re: REPOST: Overwiting SKU in Cart (NovaDerm Skincare Science 2002)
  35. Re: REPOST: Overwiting SKU in Cart (Stuart Tremain 2002)
  36. Re: REPOST: Overwiting SKU in Cart (NovaDerm Skincare Science 2002)
  37. REPOST: Overwiting SKU in Cart (Stuart Tremain 2002)
  38. Re: Overwiting SKU in Cart (Auto Krafters 2002)
  39. Overwiting SKU in Cart (Stuart Tremain 2002)
  40. Re: Overiding the sku (John Peacock 2001)
  41. Overiding the sku (Craig Forest 2001)
  42. Re: Sorting by sku (Glenn Busbin 2001)
  43. Sorting by sku (Craig Forest 2001)
  44. Re: Multiple Unique SKUs (Clint Davis 2000)
  45. Re: Multiple Unique SKUs (John Peacock 2000)
  46. Re: Multiple Unique SKUs (Kim Ingram 2000)
  47. Multiple Unique SKUs (Clint Davis 2000)
  48. Re: multiple skus (Arturo Vargas 2000)
  49. Re: multiple skus (Clint Davis 2000)
  50. multiple skus (Arturo Vargas 2000)
  51. Re: Auto SKU's (Kenneth Grome 2000)
  52. Re: Auto SKU's (Paul Willis 2000)
  53. Re: Auto SKU's (Jason Tyler 2000)
  54. Re: Auto SKU's (Marty Schmid 2000)
  55. Re: Auto SKU's (WebDNA Support 2000)
  56. Re: Auto SKU's (Jeff Logan 2000)
  57. Re: Auto SKU's (Jason Tyler 2000)
  58. Re: Auto SKU's (Jeff Logan 2000)
  59. Re: Auto SKU's (Jason Tyler 2000)
  60. Auto SKU's (Jeff Logan 2000)
  61. Re: adding second sku (Kenneth Grome 2000)
  62. Re: adding second sku (Art Vargas 2000)
  63. Re: adding second sku (Art Vargas 2000)
  64. Re: adding second sku (Kenneth Grome 2000)
  65. adding second sku (Art Vargas 2000)
  66. Re: SKU's (Vincent Medina 2000)
  67. Re: SKU's (John Butler 2000)
  68. SKU's (Bo Hess 2000)
  69. Re: Unique SKUs (Joseph D'Andrea 2000)
  70. Re: Unique SKUs (WebDNA Support 2000)
  71. Re: Unique SKUs (Clint Davis 2000)
  72. Re: Unique SKUs (Robert Wade 2000)
  73. Re: Unique SKUs (Sally Reidy 2000)
  74. Unique SKUs (Christopher Mackay 2000)
  75. Re: HideIf and SKU (Brian Boegershausen 2000)
  76. HideIf and SKU (Tim Robinson 2000)
  77. Re: Unique SKU Numbers (Joseph D'Andrea 2000)
  78. Re: Unique SKU Numbers (Kenneth Grome 2000)
  79. Re: Unique SKU Numbers (Glenn Busbin 2000)
  80. Re: Unique SKU Numbers (Glenn Busbin 2000)
  81. Re: Unique SKU Numbers (Aaron Chute 2000)
  82. Re: Unique SKU Numbers (Joseph D'Andrea 2000)
  83. Re: Unique SKU Numbers (Joseph D'Andrea 2000)
  84. Re: Unique SKU Numbers (Glenn Busbin 2000)
  85. Re: Unique SKU Numbers (Peter Ostry 2000)
  86. Re: Unique SKU Numbers (Joseph D'Andrea 2000)
  87. Re: Unique SKU Numbers (Clint Davis 2000)
  88. Re: Unique SKU Numbers (Derrick Puckett 2000)
  89. Re: Unique SKU Numbers (Joseph D'Andrea 2000)
  90. Re: Unique SKU Numbers (Glenn Busbin 2000)
  91. Re: Unique SKU Numbers (Nicolay Ramm 2000)
  92. Re: Unique SKU Numbers (Peter Ostry 2000)
  93. Re: Unique SKU Numbers (Joseph D'Andrea 2000)
  94. Unique SKU Numbers (Aaron Chute 2000)
  95. Re[2]: SKU number. (jpeacock@univpress.com 2000)
  96. Re: SKU number. (Christopher Feyrer 2000)
  97. Re: SKU number. (jpeacock@univpress.com 2000)
  98. SKU number. (Christopher Feyrer 2000)
  99. Multiple prices, one sku (Corky Kane 1999)
  100. [setlineitem] unable to set sku? (Rob Marquardt 1999)
  101. Re: SKU Question (Aaron Lynch 1999)
  102. Re: SKU Question (Jesse Williams Proudman 1999)
  103. Re: SKU Question (J. A. Hill 1999)
  104. Re: SKU Question (Rodolfo de la Garza 1999)
  105. Re: SKU Question (Aaron Lynch 1999)
  106. Re: SKU Question (Rodolfo de la Garza 1999)
  107. Re: SKU Question (Kenneth Grome 1999)
  108. Re: SKU Question (Howard Wolosky 1999)
  109. Re: SKU Question (Jesse Williams Proudman 1999)
  110. SKU Question (Rodolfo de la Garza 1999)
  111. Re: Dubble Sku's in a Database (Joseph Pugh 1999)
  112. Re: Dubble Sku's in a Database (Joseph Pugh 1999)
  113. Re: Dubble Sku's in a Database (Joseph Pugh 1999)
  114. Re: Dubble Sku's in a Database (Kenneth Grome 1999)
  115. Re: Dubble Sku's in a Database (Grant Hulbert 1999)
  116. Re: Dubble Sku's in a Database (Donovan Rittenbach 1999)
  117. Re: Dubble Sku's in a Database (Kenneth Grome 1999)
  118. Re: Dubble Sku's in a Database (Kenneth Grome 1999)
  119. Re: Dubble Sku's in a Database (Kenneth Grome 1999)
  120. Re: Dubble Sku's in a Database (Peter Ostry 1999)
  121. Re: Dubble Sku's in a Database (PCS Technical Support 1999)
  122. Re: Dubble Sku's in a Database (The Mooseman 1999)
  123. Re: Dubble Sku's in a Database (Joseph Pugh 1999)
  124. Re: Adding muliple sku + quantities (Tim Taylor 1999)
  125. Re: forming a SKU (Larry Hewitt 1999)
  126. Re: Dubble Sku's in a Database (Joseph Pugh 1999)
  127. Re: Dubble Sku's in a Database (Kenneth Grome 1999)
  128. Re: Dubble Sku's in a Database (PCS Technical Support 1999)
  129. Re: Dubble Sku's in a Database (Joseph Pugh 1999)
  130. Re: Dubble Sku's in a Database (PCS Technical Support 1999)
  131. Re: Dubble Sku's in a Database (Kenneth Grome 1999)
  132. Re: Dubble Sku's in a Database (Joseph Pugh 1999)
  133. Re: Dubble Sku's in a Database (Kenneth Grome 1999)
  134. Dubble Sku's in a Database (Joseph Pugh 1999)
  135. Re: forming a SKU (Kenneth Grome 1999)
  136. Re: forming a SKU (Martin Bech 1999)
  137. Re: forming a SKU (Peter Ostry 1999)
  138. Re: forming a SKU (Joseph Pugh 1999)
  139. Re: forming a SKU (Martin Bech 1999)
  140. Re: forming a SKU (Kenneth Grome 1999)
  141. Re: forming a SKU (Kenneth Grome 1999)
  142. Re: forming a SKU (Jan Kinzler 1999)
  143. Re: forming a SKU (Joseph Pugh 1999)
  144. Re: forming a SKU (Martin Bech 1999)
  145. Re: forming a SKU (Joseph Pugh 1999)
  146. Re: forming a SKU (Peter Ostry 1999)
  147. Re: forming a SKU (Martin Bech 1999)
  148. Re: forming a SKU (Joseph Pugh 1999)
  149. Re: forming a SKU (Peter Ostry 1999)
  150. Re: forming a SKU (Joseph Pugh 1999)
  151. forming a SKU (Jan Kinzler 1999)
  152. Re: Adding muliple sku + quantities (PCS Technical Support 1999)
  153. Adding muliple sku + quantities (Tim Taylor 1999)
  154. sorting problem for sku=0? (Olin Lagon 1998)
  155. Re: Sorting by SKU Not Working (Martin Gertz Bech 1998)
  156. Re: Sorting by SKU Not Working (charles kline 1998)
  157. Re: Sorting by SKU Not Working (PCS Technical Support 1998)
  158. Sorting by SKU Not Working (charles kline 1998)
  159. Re: incrementing sku (Peter Ostry 1998)
  160. Re: sku, title, price not showing up (Robert Ruth 1998)
  161. Re: sku, title, price not showing up (John Hill 1998)
  162. sku, title, price not showing up (Robert Ruth 1998)
  163. Thanks Grant (was: disappearing SKU (etc.) fields) (Dale Stokdyk 1998)
  164. Re: disappearing SKU (etc.) fields (Dale Stokdyk 1998)
  165. Re: disappearing SKU (etc.) fields (Grant Hulbert 1998)
  166. disappearing SKU (etc.) fields (Dale Stokdyk 1998)
  167. Re: disappearing SKU (etc.) fields (Bob Minor 1998)
  168. Checkboxes and neSKUdata=[blank] (Chris W. 1998)
  169. Solution:' add to cart ' or ' sku ' problem (John Bennett 1998)
  170. Re: ' add to cart ' or ' sku ' problem (John Bennett 1998)
  171. Re: ' add to cart ' or ' sku ' problem (PCS Technical Support 1998)
  172. ' add to cart ' or ' sku ' problem (John Bennett 1998)
  173. Re: ' add to cart ' or ' sku ' problem (PCS Technical Support 1998)
  174. Re: SKU generator? (Peter Ostry 1998)
  175. SKU generator? (charles kline 1998)
  176. Re: SKU generator? (Larry Hewitt 1998)
  177. Re: Generate a SKU (Trevor Crist 1998)
  178. Generate a SKU (Jim V 1998)
  179. Re: Generating and appending SKU to a db automatically (Joshuwa Jenkins 1998)
  180. Re: Generating and appending SKU to a db automatically (larryh 1998)
  181. Generating and appending SKU to a db automatically (Jose A. Gordo 1998)
  182. Re: Generating and appending SKU to a db automatically (Dave MacLeay 1998)
  183. Re: auto adding SKUs w/DB helper (Sue Ann Sanders 1998)
  184. Re: auto adding SKUs w/DB helper (John Hill 1998)
  185. Re: auto adding SKUs w/DB helper (Sue Ann Sanders 1998)
  186. Re: auto adding SKUs w/DB helper (John Hill 1998)
  187. auto adding SKUs w/DB helper (Sue Ann Sanders 1998)
  188. Re: Letters as SKU (Kenneth Grome 1998)
  189. Letters as SKU (Kevin Furuta 1998)
  190. Re: [SEARCH] Context for SKU prices not working... (Michael Winston 1998)
  191. Re: [SEARCH] Context for SKU prices not working... (Kenneth Grome 1998)
  192. Re: [SEARCH] Context for SKU prices not working... (Michael Winston 1998)
  193. [SEARCH] Context for SKU prices not working... (Dale Stokdyk 1998)
  194. Re:Adding non-SKUs to cart (Jay Van Vark 1998)
  195. Adding non-SKUs to cart (Brian B. Burton 1998)
  196. sku not found (Raymond Hatch 1997)
  197. Re: How Many SKU's is enough? (Bob Minor 1997)
  198. How Many SKU's is enough? (Larry Lowe 1997)
  199. Re: SKU lookup (Damien Joldersma 1997)
  200. Re: SKU lookup (Kenneth Grome 1997)
  201. Re: SKU lookup (Olin 1997)
  202. Re: SKU lookup (Kenneth Grome 1997)
  203. Re: SKU lookup (Daniel Cameron 1997)
  204. Re: SKU lookup (Damien Joldersma 1997)
  205. Re: SKU lookup (Kenneth Grome 1997)
  206. SKU lookup (Damien Joldersma 1997)
  207. RE: is sku a REQUIRED field on NT (Olin 1997)
  208. RE: is sku a REQUIRED field on NT (Marc Eagle 1997)
  209. Re: is sku a REQUIRED field on NT (Olin 1997)
  210. Re: is sku a REQUIRED field on NT (John Hill 1997)
  211. is sku a REQUIRED field on NT (Olin 1997)
  212. Re: Sku numbers (Kenneth Grome 1997)
  213. Re: Sku numbers (Marty Schmid 1997)
  214. Re: Sku numbers (Kenneth Grome 1997)
  215. Re: Sku numbers (Grant Hulbert 1997)
  216. Re: Sku numbers (Kenneth Grome 1997)
  217. Re: Sku numbers (Kenneth Grome 1997)
  218. Re: Sku numbers (Marty Schmid 1997)
  219. Re: Sku numbers (Kenneth Grome 1997)
  220. Re: SKU (natasha 1997)
  221. Re: Sku numbers (Marty Schmid 1997)
  222. Re: SKU (Grant Hulbert 1997)
  223. Sku numbers (Grant Hulbert 1997)
  224. Re: SKU (grichter@panavise.com (Gary Richter) 1997)
  225. SKU (natasha 1997)
  226. Re: Generating unique SKU from [cart] - FIXED! (marty@artwerks.com 1997)
  227. Re: Generating unique SKU from [cart] - Still Stumped... (Christer Olsson 1997)
  228. Generating unique SKU from [cart] - Still Stumped... (Marty Schmid 1997)
  229. Re: Generating unique SKU from [cart] (Kenneth Grome 1997)
  230. Generating unique SKU from [cart] (Marty Schmid 1997)
  231. Re: Simple way to create unique SKU (Grant Hulbert 1997)
  232. Re: Simple way to create unique SKU (Kenneth Grome 1997)
  233. Simple way to create unique SKU (Ed Trefzger 1997)
  234. Re: Problems passing [SKU] with $Replace in 2.0 (Trevor Crist 1997)
  235. Re: Problems passing [SKU] with $Replace in 2.0 (Grant Hulbert 1997)
  236. Re: Problems passing [SKU] with $Replace in 2.0 (Kenneth Grome 1997)
  237. Problems passing [SKU] with $Replace in 2.0 (Trevor Crist 1997)
>The webcatalog suppose to sort a products in a catalog by SKU. >The SKU of my product goes 1,2,3,..etc, and I have only one category. > In the results they appear at some messed order and I can't find >any logical explanation to this order. I tried to change the sku >number in different ways - make it like 1001, 2001 etc... but it >does not make any difference at all. Does someone have any idea >why it happens?WebCatalog does not sort unless you tell it to. If you do not explicitly tell it what to sort by, it will 'rank' the search results by 'best match', similar to Lycos, where the most matching fields get listed at the top.Add SKUsort=1&SKUsdir=as&SKUtype=num to your search criteria to force it to sort by SKU in ascending order, with SKUs being interpreted as numbers instead of text.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com Grant Hulbert

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

[math] variable question (1997) [username][password] not showing up! HELP! (1999) PROBLEM (1997) [WriteFile] problems (1997) WebCatb15 Mac CGI -- [purchase] (1997) searchable list archive (1997) Navigator 4.01 (1997) WebCatalog on LinuxPPC (2000) E-mail formating question (1999) Me know logical no need (2002) WebCatalog and directory indexing (1998) [WebDNA] WebDNA crash and now emailer not working (2009) Interfacing WebMerchant to www.fedex.com (1997) RE: New WebCatalog Version !!! (1997) RE: Webcat 2.0.1b1 bug with IE 3.01/4.0p1 (1997) Safari cookies (2006) WebCatalog 4.0 has been released! (2000) Emailer port change (1997) WC2b15 File Corruption (1997) Off-Topic: Optimal WebSTAR settings for WebDNA plugin v4.5 (2002)