WP Ecommerce: Display the “Order Notes” as column in the Sales Log [closed]

You can use a small SQL statement to retrieve the notes:

global $wpdb;
$sql = $wpdb->prepare('
    SELECT notes
    FROM '.WPSC_TABLE_PURCHASE_LOGS.'
    WHERE id=%d
    ',$item->id);
echo $wpdb->get_var($sql);

Read more in this post

Related Posts:

  1. Allowed memory size of 268435456 bytes exhausted (tried to allocate 7146491840906359738 bytes)
  2. How do I make my function add variables/values to the $post object?
  3. How do I get the author’s page url from their ID?
  4. Calculate percentage of post by category
  5. Change comments form title on a page by page basis
  6. Remove class that has been added by parent theme
  7. How to check from which page the user is coming to the current page?
  8. Get the title before comma
  9. Execute only on a certain page
  10. How do I know what variables are passed in a filter/action and what their meaning is?
  11. “Can’t use function return value in write context” error
  12. Display 4 chronological posts starting with a random post
  13. Wrap each shortcode in array to div
  14. Warning: array_pop() expects parameter 1 to be array, boolean given
  15. Replace comment avatars and links at the same time
  16. Check if Product is in a Specific Category in Functions.php
  17. Adding ads code between comments
  18. Create Logout Link WordPress Admin Menu
  19. How to Display Image Meta underneath EVERY image in EVERY post
  20. Limiting woocommerce line_total decimal length
  21. Run a filter when a walker runs
  22. Shortcode content filter?
  23. Swapping wp_dropdown_categories function with wp_category_checklist
  24. Display fields as values in array from external SQL DB
  25. only show container with next/prev links if they exist?
  26. Populate dropdown with Child Pages based on Parent Page chosen
  27. How can I remove a function that has been added to wordpress with add_filter?
  28. Get value from shortcode to do something
  29. JS file work only in index page
  30. Error in custom php function doesn’t exist
  31. Custom shortcode outputs plain text instead of HTML at top of post
  32. how can i use $_COOKIE[] + PostID to execute the below code?
  33. What’s the uses of wp_cache_set() or wp_cache_add()?
  34. Create Page To Count Comments For Each Post In WordPress Site
  35. Can anyone offer any help with this function?
  36. Shortcode with PHP issue “Undefined index”
  37. height should be set to auto to avoid pixelation in the post thumbnail function
  38. Can i put my shortcode inside a variable in php files?
  39. Moving code from theme header to functions.php
  40. Override a function defined in wp-includes/comment-template.php
  41. Show meta box only for default page template
  42. Can’t access site after making changes to the functions.php [closed]
  43. Best way to use a large array in function
  44. Setting user nickname and displayname to shortened email
  45. Download PDF after CF7 form submission
  46. Is it possible to define variables in a wordpress shortcode, and then call the shortcode using a specific variable?
  47. Creating a mobile site by adding a new class to the body tag from functions.php
  48. Custom meta box values are not getting saved for my custom post type
  49. Simple AJAX notification when the new post is added to the database
  50. Upload multiple files in randomly generated folder using wp_upload_bits
  51. Export Form Data to a CSV then send it as an attachment – contact form 7
  52. Personalize checkout text
  53. How do I create a function that modifies a message in the wp-login.php file?
  54. Cant display an image via PHP in wordpress
  55. Template Loop – add switch case php
  56. get post id from wp_insert_post for get_template_part
  57. Adding an interior ‘hero’ area with some added php title customization
  58. Call to undefined function error in plugin
  59. How do I correct the code in php? [closed]
  60. Image rotation issue (horizontal picture uploading as vertical) — Exif issue?
  61. How to add author’s posts link (HTML + PHP) inside a function to output it
  62. Creating customized php files in theme folder
  63. Unable to Call More than One Meta Box Output
  64. Menu not styling. New menus functionality giving me a headache
  65. How to set value selected using select2 jquery plugin
  66. Workaround for og:image unsupported webp image type, Yoast SEO?
  67. Disclaimer that will show every refresh of the page
  68. Dynamically switch file in get_template_directory_uri() | Function [closed]
  69. Providin exception to WordPress wp_nav_menu Custom CSS Classes
  70. Woocommerce My acount page
  71. Dropdown category field inside repeatable metabox
  72. Retrieve alt text by referencing the img src
  73. Ajax filter with loadmore button
  74. How can i avoid duplicate same post in wp?
  75. Child theme overirde template-tags in a theme built on underscores in inc/template-tags
  76. Delete post meta by serialized meta value
  77. Custom meta box is not displaying value showing tag as empty
  78. Menu not updating for logged in users after redirect
  79. Create a temporal post
  80. PHP/CSS: Shortcode won’t display correctly, and only displays in the head (before content)
  81. Add parent menu item in sub-menu in custom nav_walker
  82. Add class for the_post_thumbnail_caption()
  83. Getting page / post URL on publish and / or update
  84. Weird Behaviour: Not all WordPress Posts appearing
  85. Save the outputted image into the Media Library, with a different filename and extension
  86. Custom Taxonomy as Link
  87. How to fix blank pagination links?
  88. main menu page redirects to user ID
  89. How to have Function of a plugin using global vars into a shortcode?
  90. Adding ID to a Listing but not inside WP_Query while
  91. adsense code showing on random post thumb
  92. WordPress causing all code to be displayed on line 1. Receiving multiple errors after cleaning cookies and cache
  93. Where are Sessions are being started? [closed]
  94. Replace TinyMCE with Custom Built Editor
  95. WP Fatal error: Call to undefined function get_template_directory_uri()
  96. Remove default Image Sizes
  97. A better way to write this php function
  98. Generate and upload screenshot as featured image for user-submitted post
  99. a problem in class in class-wp-hook.php
  100. change title of page dynamically