Ask your WordPress questions! Pay money and get answers fast! Comodo Trusted Site Seal
Official PayPal Seal

GetShopped (wp-ecommerce): how to manually set the product order? WordPress

  • SOLVED

I'm facing a rather tight deadline. I need to get this WP-eCommerce site up tonight. I'm no longer interested in doing things the "correct" way, at this point I'm simply aiming to get it working under any conditions.

Here is one problem: on our main products page, the products are appearing in the reverse chronological order (that is the normal default order). WP-eCommerce has a drag-n-drop interface for re-arranging the order the products appear in, however, sadly, this feature is broken for us. So, I'd like to simply go into the database and re-arrange the order manually. However, I'm having trouble finding which database table controls this.

These are the database tables I have right now:

wp_blc_filters
wp_blc_instances
wp_blc_links
wp_blc_synch
wp_commentmeta
wp_comments
wp_links
wp_ngg_album
wp_ngg_gallery
wp_ngg_pictures
wp_options
wp_postmeta
wp_posts
wp_term_relationships
wp_term_taxonomy
wp_terms
wp_twtstats
wp_usermeta
wp_users
wp_wp_email_capture_registered_members
wp_wp_email_capture_temp_members
wp_wpsc_also_bought
wp_wpsc_cart_contents
wp_wpsc_cart_item_variations
wp_wpsc_categorisation_groups
wp_wpsc_category_tm
wp_wpsc_checkout_forms
wp_wpsc_claimed_stock
wp_wpsc_coupon_codes
wp_wpsc_currency_list
wp_wpsc_download_status
wp_wpsc_item_category_assoc
wp_wpsc_logged_subscriptions
wp_wpsc_meta
wp_wpsc_product_categories
wp_wpsc_product_files
wp_wpsc_product_images
wp_wpsc_product_list
wp_wpsc_product_order
wp_wpsc_product_rating
wp_wpsc_product_variations
wp_wpsc_productmeta
wp_wpsc_purchase_logs
wp_wpsc_purchase_statuses
wp_wpsc_region_tax
wp_wpsc_submited_form_data
wp_wpsc_variation_assoc
wp_wpsc_variation_combinations
wp_wpsc_variation_properties
wp_wpsc_variation_values
wp_wpsc_variation_values_assoc
wpsd_trends


If I want a product to be listed at the top of our product page, or at the bottom, which of these tables do I go into to change the value?

Answers (1)

2011-04-01

yves vu answers:

Hi,
please go to table: "wp_wpsc_product_order" to re-arrange the order manually of Products.

OR try this (a issue fixed of GetShopped):

BACK UP EVERYTHING!!!!
Ftp to and open {{install-folder}}/wp-content/plugins/wp-e-commerce/wpsc-admin/display-items.page.php
Alternatively, in the Wordpress Admin Center, you can go to Plugins >> Editor and select WP Shopping Cart. Locate the aformentioned file along the sidebar and give 'er a click.
<strong>On line 348-350 change the code:</strong>
if(get_option('wpsc_sort_by') == 'dragndrop')){
$product['id'] = $product['product_id'];
}

to this:
if(get_option('wpsc_sort_by') == 'dragndrop' && !empty( $product['product_id'])){
$product['id'] = $product['product_id'];
}


<strong>Save and upload.</strong>

Cheers.