How-To add Custom field in WordPress wp-ecommerce Categories?
Can you clarify that a bit? It already allows for uploading of an image to be used as the category image. Are you looking to attach another image to the category for some other reason?
plugin-wp-e-commerce
wp_reset_query equivalent for WP Ecommerce
You can use (according to docu over @wp-ecommerce) global $wpsc_query; to modify your query. Resetting the loop can be done with wpsc_rewind_products(); right before the second call to while (wpsc_have_products()) : wpsc_the_product(); For the final solution, pls read the comments below.
WP e-commerce: How to select the shipping costs calculation method according to delivery location
Things may be slightly different depending on whether you are using the most recent version of wp e-commerce (I think its 3.8 something) – but it’s similar in 3.7 In the shipping settings you can choose Flat Rate and then hit edit and set the shipping rates for continental US as well as other continents. … Read more
style being attatched to tag from outside of style sheets
This is almost surely your problem WordPress Admin Bar ..
Bulk Custom Menu and Wp-Ecommerce
Goto Appearance -> Menus You can see all categories listed here including wp-ecommerce categories. Just create a new menu for your wp-ecommerce categories. Lets call it “ecomcategories”. You can call this menu in your theme using this code. <?php wp_nav_menu( array(‘menu’ => ‘ecomcategories’ )); ?> You can just drag and drop for sub menus. You … Read more
How to change the layout of a product page
As it turns out, all I needed to do was add the following to the function.php of my genesis child-theme. add_action(‘init’ , ‘wpec_genesis_add_layout_support’); function wpec_genesis_add_layout_support(){ add_post_type_support( ‘wpsc-product’, ‘genesis-layouts’ ); }
How can I find out what items a user has purchased? [closed]
Query the table wp_wpsc_purchase_logs, it contains all information about previous purchases. add this to your themes functions.php: /********************************************************* Get purchased articles by user_id or for the current user *********************************************************/ function haet_recently_bought_articles($user_id=0){ if($user_id==0) $user_id=get_current_user_id(); //only if there is an active user, otherwise we would get all purchased items from unregistered users if($user_id>0) { global $wpdb; $sql … Read more
Send email on Job Dispatched from WP e-commerce [closed]
I’d suggest you start by looking at action ‘wpsc_purchase_log_update’, which is triggered in wpsc-includes/purchase-log.class.php and passes the wpsc_purchase_log object. Test the $previous_status member of that object, and the new status value (might be in data member as $data[‘statusno’]) == WPSC_Purchase_Log::JOB_DISPATCHED. Something like this (untested): add_action(‘wpsc_purchase_log_update’, ‘wpse_73707_wpscPurchaseLogUpdate’); /** * trigger event or option to the “Job … Read more
Custom MySQL Query with logic
Thank’s everyone for your attention. If anybody will need to query database with two postmeta, here is the code SELECT p.* , CASE WHEN m1.meta_value=0 OR m1.meta_value IS NULL THEN m2.meta_value ELSE m1.meta_value END meta_value FROM aka_v_posts p LEFT JOIN aka_v_postmeta m1 ON p.id=m1.post_id AND m1.meta_key=’_wpsc_special_price’ LEFT JOIN aka_v_postmeta m2 ON p.id=m2.post_id AND m2.meta_key=’_wpsc_price’ WHERE … Read more
Code not looping over all products of a given category
The default number of posts for WP_Query is ten posts per page. Try adding ‘posts_per_page’ => -1 to your $wpec_args: $wpec_args = array( ‘post_status’ => ‘publish’, ‘post_type’ => ‘wpsc-product’, ‘posts_per_page’ => -1, ‘wpsc_product_category’ => $wpec_term_slug );