Category Archives: WP Ecommerce

Add the following CSS rules to make WP-Ecommerce plugin more responsive to mobile devices:

 CSS | 
 copy code |
?
 
01
#content .product_grid_display .item_image a {
02
   display: inline;
03
}
04
#primary #content #grid_view_products_page_container, #primary #content #grid_view_products_page_container, #primary #content #list_view_products_page_container {
05
  line-height: 1.2em;
06
  min-width: 300px;
07
  position: relative;
08
  width: 100%;
09
}
10
#default_products_page_container .imagecol img, #list_view_products_page_container img, #grid_view_products_page_container img {
11
   height: auto !important;
12
 }
13
#checkout_page_container {
14
  clear: both;
15
  position: relative;
16
  width: 100%;
17
}

The aim is to only hide the calculator from the checkout page not remove it as it still must send its values to the next page. It is then removed from the layout by setting its position as absolute so it does not push the forms down the page.

Also need to remove the H2 heading.

In the theme stylesheet add the following:

 CSS | 
 copy code |
?
 
1
#content #checkout_page_container table.productcart {
2
visibility: hidden;
3
position: absolute;
4
}
5
 
6
#wpsc_shopping_cart_container h2:first-child {
7
display: none;
8
}

To retrieve the purchase log data to extract customer email for example use this within the function:

 PHP | 
 copy code |
?
 
01
global $wpdb;
02
 
03
    //This grabs the purchase log id from the database that refers to the $sessionid
04
 
05
    $purchase_log = $wpdb->get_row(
06
    "SELECT * FROM `".WPSC_TABLE_PURCHASE_LOGS."` WHERE `sessionid`= ".$sessionid." LIMIT 1" ,ARRAY_A) ;
07
//This grabs the users info using the $purchase_log from the previous SQL query
08
    $usersql = "SELECT `".WPSC_TABLE_SUBMITED_FORM_DATA."`.value,
09
    `".WPSC_TABLE_CHECKOUT_FORMS."`.`name`,
10
    `".WPSC_TABLE_CHECKOUT_FORMS."`.`unique_name` FROM
11
    `".WPSC_TABLE_CHECKOUT_FORMS."` LEFT JOIN
12
    `".WPSC_TABLE_SUBMITED_FORM_DATA."` ON
13
    `".WPSC_TABLE_CHECKOUT_FORMS."`.id =
14
    `".WPSC_TABLE_SUBMITED_FORM_DATA."`.`form_id` WHERE
15
    `".WPSC_TABLE_SUBMITED_FORM_DATA."`.`log_id`=".$purchase_log['id']."";
16
 
17
 
18
    $userinfo = $wpdb->get_results($usersql, ARRAY_A);
19
 
20
 
21
    //get for example, customer email address
22
    foreach((array)$userinfo as $key => $value){
23
 
24
         if(($value['unique_name']=='billingemail') && $value['value'] != ''){
25
                $customer_email = $value['value'];
26
                }
27
     }

Keys correspond to the checkout fields unique names

 PHP | 
 copy code |
?
 
01
[purchase_id]
02
[cart_item]
03
--[id]
04
--[prodid]
05
--[name]
06
--[purchaseid]
07
--[price]
08
--[pnp]
09
--[tax_charged]
10
--[gst]
11
--[quantity]
12
--[donation]
13
--[no_shipping]
14
--[custom_message]
15
--[files]
16
--[meta]
17
[purchase_log]
18
--[id]
19
--[totalprice]
20
--[statusno]
21
--[sessionid]
22
--[transactid]
23
--[authcode]
24
--[processed]
25
--[user_ID]
26
--[date]
27
--[gateway]
28
--[billing_country]
29
--[shipping_country]
30
--[base_shipping]
31
--[email_sent]
32
--[stock_adjusted]
33
--[discount_value]
34
--[discount_data]
35
--[track_id]
36
--[billing_region]
37
--[shipping_region]
38
--[find_us]
39
--[engravetext]
40
--[shipping_method]
41
--[shipping_option]
42
--[affiliate_id]
43
--[plugin_version]
44
--[notes]
45
--[wpec_taxes_total]
46
--[wpec_taxes_rate] 

By default only Admin can view logs. This is hard coded.

In wp-e-commerce/wpsc-admin/admin.php edit line 147 replace “administrator”  with ’7′

 PHP | 
 copy code |
?
 
1
$purchase_logs_cap = apply_filters( 'wpsc_purchase_logs_cap', 'administrator' );

10 is admin access, 7 is editor access

Go to http://www.yourdomain.com/wp-admin/options.php and edit the fields for:

• product_list_url
• shopping_cart_url
• transact_url
• user_account_url