WP e-Commerce 3.7 Beta 2

please make: show_cats_brands.php like that:

prefix.”product_categories` WHERE `active`=’1′ AND `category_parent` = ‘”.$id.”‘ ORDER BY `id`”;
$subcategories = $wpdb->get_results($subcategory_sql,ARRAY_A);

if($subcategories != null) {
$output .= “”;
foreach($subcategories as $subcategory) {

// ################## ADDED TO HIGHLIGHT THE CATEGORY VIEWED ###################################
if(!$wp_query->query_vars['product_name'] && $wp_query->query_vars['product_category'] == $subcategory['id']) {$highlight = ‘ class=”current_page_item”‘;} else {$highlight = “”;}

// ################## ADDED THE FOLLOWING TO IDENTIFY PARENT OF CALLED SUBCATS ###################################
$subparent = “”;
$par = $wp_query->query_vars['product_category'];
if ($par == $subcategory['id']) {
$subparent = “yes”;
} else {
$i = 1;
while ($par >= 1 || $i prefix.”product_categories` WHERE `id`=’”.$par.”‘”;
$par = $wpdb->get_var($parcategory3_sql);
if ($par == $subcategory['id']) {$subparent = “yes”;}
$i++;
}
}

// ################## ADDED TO SHOW OR HIDE SUB-SUB-CATS ###################################
if ($subparent == “yes”) {$morecats = display_subcategories($subcategory['id']);} else {$morecats = “”;}

// ################## EDITED TO HIGHLIGHT THE CATEGORY VIEWED ###################################
$output .= ““.stripslashes($subcategory['name']).”“.$morecats.”\n”;

// ################## ADDED TO SHOW PRODUCTS IN SUB-CATEGORY ###################################
$output .= show_products($subcategory['id']);
}
$output .= “”;
} else {
return ”;
}
return $output;
}

// ################## TOOK PRODUCT DISPLAY FROM IF/ELSE AND MADE SEPARATE FUNCTION ###################################
function show_products($catid) {
global $wpdb, $wp_query;
// Adrian – check if the user wants categories only or sliding categories
if (get_option(’catsprods_display_type’) == 1 && $wp_query->query_vars['product_category'] == $catid){
// Adrian – display all products for that category
$product_sql = “SELECT product_id FROM `”.$wpdb->prefix.”item_category_associations` WHERE `category_id` = ‘”.$catid.”‘”;
$productIDs = $wpdb->get_results($product_sql,ARRAY_A);
if($productIDs != null){
$output .= “”;
foreach($productIDs as $productID){
$ID = $productID['product_id'];
$productName_sql = “SELECT name FROM `”.$wpdb->prefix.”product_list` WHERE `id` = ‘”.$ID.”‘”;
$productName = $wpdb->get_var($productName_sql);

// ################## HIGHLIGHT A PRODUCT ###################################
$productMeta_sql = “SELECT meta_value FROM `”.$wpdb->prefix.”wpsc_productmeta` WHERE `product_id` = ‘”.$ID.”‘ AND `meta_key` = ‘url_name’”;
$prurl_name = $wpdb->get_var($productMeta_sql);
if($wp_query->query_vars['product_name'] && $wp_query->query_vars['product_name'] == $prurl_name) {$highlight = ‘ class=”current_page_item”‘;} else {$highlight = “”;}
// ################## HIGHLIGHT A PRODUCT ###################################

// *************** Here are the product links in menu!!!!!!!!!!!!!!!!!!!!!!!!!!! **********************************************************************************************************
$output .= ““.$productName.”\n”;
}//end foreach
$output .= “”;
}//end if productsIDs
}//end if get_option
return $output;
}

function show_cats_brands($display_method = null) {
// ################## ADDED $wp_query TO GLOBAL ###################################
global $wpdb, $wp_query;

// Show cats & brands list if displaying on every page or if on a shop page (bit hacky but out of time).
if (get_option(’cat_brand_loc’) != 3 && !function_exists(”nzshpcrt_display_categories_groups”) && ($display_method != ’sidebar’)) {
return;
}

if(get_option(’permalink_structure’) != ”) {
$seperator =”?”;
} else {
$seperator =”&”;
}

$output = “”;
// ################## COMMENTED OUT THIS SECTION FOR WIDGET ###################################
// switch(get_option(’show_categorybrands’)) {
// case 1:
// $output .= ““.TXT_WPSC_CATEGORIES.” | “.TXT_WPSC_BRANDS.”“;
// break;

// case 2:
//$output .= ““.TXT_WPSC_CATEGORIES.”“;
// break;

// case 3:
//$output .= ““.TXT_WPSC_BRANDS.”“;
// break;
// }
$output .= “”;

$output .= “”;

if((get_option(’show_categorybrands’) == 1 ) || (get_option(’show_categorybrands’) == 2))
{
$output .= “”;
$categories = $wpdb->get_results(”SELECT * FROM `”.$wpdb->prefix.”product_categories` WHERE `active`=’1′ AND `category_parent` = ‘0′ ORDER BY `order` ASC”,ARRAY_A);
if($categories != null)
{
$output .= “”;
foreach($categories as $option)
{
// Adrian – check option for category count
if (get_option(’show_category_count’) == 1){
//show product count for each category
$count_sql = “SELECT count(*) FROM `”.$wpdb->prefix.”item_category_associations` WHERE `category_id` = ‘”.$option['id'].”‘”;
$count = $wpdb->get_var($count_sql);
$addCount = ” [".$count."]“;
} //end get_option

// ################## HIGHLIGHT A CATEGORY ###################################
if(!$wp_query->query_vars['product_name'] && $wp_query->query_vars['product_category'] == $option['id']) {$highlight = ” current_page_item”;} else {$highlight = “”;}
// ################## HIGHLIGHT A CATEGORY ###################################

// ################## ADDED THE FOLLOWING TO IDENTIFY PARENT OF CALLED SUBCATS ###################################
$thispar = “”;
$par = $wp_query->query_vars['product_category'];
if ($par == $option['id']) {
$thispar = “yes”;
} else {
$i = 1;
while ($par >= 1 || $i prefix.”product_categories` WHERE `id`=’”.$par.”‘”;
$par = $wpdb->get_var($parcategory2_sql);
if ($par == $option['id']) {$thispar = “yes”;}
$i++;
}
}

// Adrian – if sliding category type selected, NO link for category text, mootools.js creates the linkable sliders onDomReady.
if (get_option(’catsprods_display_type’) == 1){
// ################## ADDED $highlight VAR ###################################
$output .= ““.stripslashes($option['name']).$addCount.”“;
}else{
// Adrian – otherwise create normal category text with or without product count
// ################## ADDED $highlight VAR ###################################
$output .= ““.stripslashes($option['name']).$addCount.”“;
}//end get_option
$subcategory_sql = “SELECT * FROM `”.$wpdb->prefix.”product_categories` WHERE `active`=’1′ AND `category_parent` = ‘”.$option['id'].”‘ ORDER BY `id`”;
$subcategories = $wpdb->get_results($subcategory_sql,ARRAY_A);

// ################## ————– THIS if() DETERMINES IF SUBCATS FUNCTION RUNS ————– ##################
// ################## ADDED && $thispar == “yes” ###################################
if($subcategories != null && $thispar == “yes”)
{
// ################## ADDED CALL TO NEW show_products() FUNCTION ###################################
// $output .= show_products($option['id']);
$output .= display_subcategories($option['id']);
$output .= show_products($option['id']);
} else {
// ################## REMOVED PRODUCT CODE FROM ELSE STATEMENT TO ITS OWN show_products() FUNCTION ABOVE AND REPLACED WITH FUNCTION CALL ###################################
$output .= show_products($option['id']);
}//end else
$output .= “\n”;
}
$output .= “”;
}
$output .= “”;
}

if((get_option(’show_categorybrands’) == 1 ) || (get_option(’show_categorybrands’) == 3))
{
if(get_option(’show_categorybrands’) == 1)
{
$output .= “”;
}
else
{
$output .= “”;
}
//$output =”;
$brands = $wpdb->get_results(”SELECT * FROM `”.$wpdb->prefix.”product_brands` WHERE `active`=’1′ ORDER BY `order` ASC”,ARRAY_A);
if($brands != null)
{
foreach($brands as $option)
{
$output .= ““.stripslashes($option['name']).”\n”;
}
}
//$output .= $output;
$output .= “”;
}

$output .= “”;
echo $output;
}

function show_cats_brands_page($display_method = null) {
global $wpdb;

// Show cats & brands list if displaying on every page or if on a shop page (bit hacky but out of time).
if (get_option(’cat_brand_loc’) != 3 && !function_exists(”nzshpcrt_display_categories_groups”) && ($display_method != ’sidebar’)) {
return;
}

if(get_option(’permalink_structure’) != ”) {
$seperator =”?”;
} else {
$seperator =”&”;
}

$output = “”;

switch(get_option(’show_categorybrands’)) {
case 1:
$output .= ““.TXT_WPSC_CATEGORIES.” | “.TXT_WPSC_BRANDS.”“;
break;

case 2:
$output .= ““.TXT_WPSC_CATEGORIES.”“;
break;

case 3:
$output .= ““.TXT_WPSC_BRANDS.”“;
break;
}
$output .= “”;

$output .= “”;

if((get_option(’show_categorybrands’) == 1 ) || (get_option(’show_categorybrands’) == 2))
{
$output .= “”;
$categories = $wpdb->get_results(”SELECT * FROM `”.$wpdb->prefix.”product_categories` WHERE `active`=’1′ AND `category_parent` = ‘0′ ORDER BY `order` ASC”,ARRAY_A);
if($categories != null)
{
$output .= “”;
foreach($categories as $option)
{
// Adrian – check option for category count
if (get_option(’show_category_count’) == 1){
//show product count for each category
$count_sql = “SELECT count(*) FROM `”.$wpdb->prefix.”item_category_associations` WHERE `category_id` = ‘”.$option['id'].”‘”;
$count = $wpdb->get_var($count_sql);
$addCount = ” [".$count."]“;
} //end get_option
// Adrian – if sliding category type selected, NO link for category text, mootools.js creates the linkable sliders onDomReady.
if (get_option(’catsprods_display_type’) == 1){
// $output .= ““.stripslashes($option['name']).$addCount.”“;
$output .= ““.stripslashes($option['name']).$addCount.”“;
}else{
// Adrian – otherwise create normal category text with or without product count
$output .= ““.stripslashes($option['name']).$addCount.”“;
}//end get_option
$subcategory_sql = “SELECT * FROM `”.$wpdb->prefix.”product_categories` WHERE `active`=’1′ AND `category_parent` = ‘”.$option['id'].”‘ ORDER BY `id`”;
$subcategories = $wpdb->get_results($subcategory_sql,ARRAY_A);
if($subcategories != null)
{
$output .= display_subcategories($option['id']);
} else {
// Adrian – check if the user wants categories only or sliding categories
if (get_option(’catsprods_display_type’) == 1){
// Adrian – display all products for that category
$product_sql = “SELECT product_id FROM `”.$wpdb->prefix.”item_category_associations` WHERE `category_id` = ‘”.$option['id'].”‘”;
$productIDs = $wpdb->get_results($product_sql,ARRAY_A);
if($productIDs != null){
$output .= “”;
foreach($productIDs as $productID){
$ID = $productID['product_id'];
$productName_sql = “SELECT name FROM `”.$wpdb->prefix.”product_list` WHERE `id` = ‘”.$ID.”‘”;
$productName = $wpdb->get_var($productName_sql);
$output .= ““.$productName.”\n”;
}//end foreach
$output .= “”;
}//end if productsIDs
}//end if get_option
}//end else
$output .= “\n”;
}
$output .= “”;
}
$output .= “”;
}

if((get_option(’show_categorybrands’) == 1 ) || (get_option(’show_categorybrands’) == 3))
{
if(get_option(’show_categorybrands’) == 1)
{
$output .= “”;
}
else
{
$output .= “”;
}
//$output =”;
$brands = $wpdb->get_results(”SELECT * FROM `”.$wpdb->prefix.”product_brands` WHERE `active`=’1′ ORDER BY `order` ASC”,ARRAY_A);
if($brands != null)
{
foreach($brands as $option)
{
$output .= ““.stripslashes($option['name']).”\n”;
}
}
//$output .= $output;
$output .= “”;
}

$output .= “”;
echo $output;
}

function wpsc_category_url($category_id) {
global $wpdb, $wp_rewrite;
$category_data = $wpdb->get_row(”SELECT `nice-name`,`category_parent` FROM `”.$wpdb->prefix.”product_categories` WHERE `id` IN (’”.(int)$category_id.”‘) AND `active` IN(’1′) LIMIT 1″, ARRAY_A);
$category_name[] = $category_data['nice-name'];
if($category_data['category_parent'] > 0) {
$num = 0;
while($category_data['category_parent'] > 0) {
$category_data = $wpdb->get_row(”SELECT `nice-name`,`category_parent` FROM `”.$wpdb->prefix.”product_categories` WHERE `id` IN (’”.(int)$category_data['category_parent'].”‘) AND `active` IN(’1′) LIMIT 1″, ARRAY_A);
$category_name[] = $category_data['nice-name'];
if($num > 10) { break; }
$num++;
}
}
$category_name = array_reverse($category_name);
if($wp_rewrite->rules != null) {
$url_name = get_product_meta($product_id, ‘url_name’, true);
if(!empty($category_name)) {
if(substr(get_option(’product_list_url’), -1, 1) == ‘/’) {
$category_url = get_option(’product_list_url’).implode($category_name,”/”).”/”;
} else {
$category_url = get_option(’product_list_url’).”/”.implode($category_name,”/”).”/”;
}
} else {
$category_url = get_option(’product_list_url’);
}
} else {
$category_url = get_option(’product_list_url’).”&category=”.$category_id;
}
return $category_url;
}

function wpsc_category_description($category_id = null) {
global $wpdb, $wp_query;
/* */
if($category_id == null) {
if($wp_query->query_vars['product_category'] != null) {
$category_id = $wp_query->query_vars['product_category'];
} else if(is_numeric($_GET['category'])) {
$category_id = $_GET['category'];
}
}

$category_description = “”;
$category_description .= $wpdb->get_var(”SELECT `description` FROM `”.$wpdb->prefix.”product_categories` WHERE `id` IN (’”.(int)$category_id.”‘) AND `active` IN(’1′) LIMIT 1″);
$category_description .= “”;
return $category_description;
}
?>

Guys, this is a great release, fixes the bugs that we were having and is really quick! Excellent stuff. 1 thing that isn’t a bug, but is perhaps worth pointing out is that VAT in the UK is 15% now, not 17.5% … so your default is incorrect. Hell, if the only thing wrong with this beta is that, then we’re all onto a winner :)

Thanks again, Rich

Hi there, the gold cart files do not seem to work with 3.7 beta 2 and you can’t edit the products!

Found a couple of small problems when adding a product…
When the page loads, the inline editor doesn’t seem to load properly – i.e. neither the HTML or Visual bar display. However, once you select one, the editor buttons load fine. This happen upon everyload of this page (i.e. when you’ve just added a product, too)

After filling in all of the input boxes and selecting “add product” I’m told that the product was updated, but on the LHS, where the product list is, there is an error displayed underneath the name of the newly added product:

Warning: array_search() [function.array-search]: Wrong datatype for second argument in /the/path/to/the/sandbox/wp-content/plugins/wp-e-commerce/processing_functions.php on line 927

The product seems to be added just fine, and if you “view” the product, that is fine also.

EDIT: Rather randomly, after I’ve attempted to make a purchase (see below), this error has now gone…odd!

If I’m in the front-end and add a product to my basket, the window pops up and says “WPSC_UPDATE_TEXT” so that variable needs to display the contents of it, rather than it’s name :)

However, the main problem arises upon checkout. If I’ve added a couple of products and go to the checkout, both products are there as expected. However, regardless of what shipping I have selected in the admin, I have “Weight Rate” and £40.00 – that’s it, no other options. That option is selected, but I still have to manually click on (the already checked) button to add the shipping to the total.

If I now fill in all the boxes and press “make purchase” – regardless of what payment gateway I have chosen (I tried Google Checkout, PayPal and Manual Payment) nothing happens. The page just seems to reload, resets the shipping back to 0. I’n not given any errors or warnings, just seems to reload the page.

Guys, this is an amazing plugin and this next step to 3.7 is going to make it even more amazing. I’m sure it’s just a few niggles that need ironing out. I know I for one will be purchasing Gold Cart and I imagine many others will, when they see what this plugin can do. Great effort and keep up the hard work! Thank you,

Rich

I bought gold cart and product slider. I do not see gold cart tab and http://siqurestream.com/?page_id=63 has product slider but no product on it. Please help.

Hi, let me give you cheers for this great work over time, i’m really new in the field of Shop’s in Wordpress and i already tried all the shops available around and yours is the best one, i have to say since yesterday at 12:35 Beta 1 was a shame for me, but today i tried Beta 2 and Whoaaaaaaa it was a bit hard but i already make it work, i have troubles with language but i translate again in spanish because the language you had is old and not working anymore, but what i have to say is when i add a product i get this error “[function.array-search]:Wrong datatype for second argument xxxxxxx /processing_funcions.php on line 927″ so i went and try to understand what happen and i found this in line 927 ” if((array_search(’ups’, $custom_shipping) !== false) && ($product['no_shipping'] != 1)) {” a line before that is “// only do anything if UPS is on and shipping is used” but i enabled and disable and try to use some weight on it and i have the same error so maybe this help you in your way to get Beta 3, sorry for my bad english and thanks again for this great software.

Last thing, I logged out and still no multiple image. Next thing, clicked on thumbnail image from visitor view and all it does is spin its wheels saying loading and nothing happens beyond that, but you can click anywhere and it just stops and goes back to the normal page.

http://www.bryankite.com/wordpress2.8/?page_id=3

On the display products page each shows an error:
Warning: array_search(): Wrong datatype for second argument in /home/content/l/m/a/lmackney/html/store/wp-content/plugins/wp-e-commerce/processing_functions.php on line 927

Also.. lightbox just shows continual “loading”.

Thanks for your help!

In addition to the lightbox, delete products and variations aren’t working either.

Thank you.

Still getting the same error I was getting with Beta 1. Below “Incoming Links” in the dashboard I get the following error, along with the rest of the page not being rendered:

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 79 bytes) in /home3/renewalm/public_html/wp-includes/class-simplepie.php on line 11213

Hi

I tryed Beta 2 on my 2.8 and couldn’t install. I just get this error, any ideas?

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 491520 bytes) in /site/public_html/wp-content/plugins/wp-e-commerce/merchants/library/googlecart.php on line 778

Regards
.m

OK, I’ve worked out some of the smaller issues I was having (installed it on top of the old Beta1), but I’ve just completely reinstalled Beta2 on a vanilla WP install on a brand new database and I’m still having the issue whereby I can’t ‘purchase’ anything – i.e. When I add things to the basket, fill in the details in the form and press “make purchase” I’m just returned to the same page – no error warning or anything like that.

Everything else as far as I can tell seems to work smooth as silk!

Thanks again for all your hard work guys!

Rich

Hi, i just had to try the new update :D
so i did it, and now my dashboard gives me this error:

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 122880 bytes) in /home/blogtvdr/public_html/winterspringpro/wp-includes/class-simplepie.php on line 13579

any help ? thanks alot in adv

Things are looking great on the plugin. I just had a concern on one thing that I found on the dashboard. Don’t know if it’s been address yet or not. So here goes.

This is the window for the E-commerce sales on the dashboard:

Warning: Division by zero in /nfs/c04/h01/mnt/60442/domains/shop.projek23.com/html/wp-content/plugins/wp-e-commerce/wp-shopping-cart.old.php on line 2001

—-so any help would be great. Either just a bug needing to be fixed or something on my end i need to do.

Thanks.

3.7 Beta-2 doesn’t work for me.

i’ve had 3.6.xxxxx installed before, working moderately OKish, but the Beta now gives me this message:

When upgrading the Wp-E-Commerce Plugin from 3.6.* to 3.7 it is required that you associate your checkout form fields with the new Purchase Logs system. To do so please Click Here

When I then do this, I get told that I do not have sufficient permissions to access this page. Is there anything higher than an administrator?

So I deleted all WPSC tables, deleted all WP e-commerce folders under /plugins/, and started again… same thing.

Any ideas?

Random request…. Could you set it up so either we can customize the packing slip or have an option to print a customer receipt to include with the shipment? Perhaps this could be a gold cart option or something – I’d pay for it. Also, when we enter a tracking number, I’m not sure if it is sent to the customer but if it does, it would be nice to be able to include the shipper and a link to track it. For example, UPS in the United States or Fedex.

This would really help when it comes time to ship our products. You guys are doing a great job and we really appreciate your aggressive updates!

Default state / Province cannot be updated properly

and

When selecting a country and state on the order form, tax isnt applied. Also an error is generated.

Message: Exception thrown and not caught
Line: 19
Char: 2424
Code: 0
URI: http://foundonline.net/wp-includes/js/jquery/jquery.js?ver=1.3.2

Message: Object doesn’t support this property or method
Line: 175
Char: 3
Code: 0
URI: http://foundonline.net/wp-content/plugins/wp-e-commerce/js/wp-e-commerce.js?ver=3.720

Thanks!

i keep getting : Cannot load wp-e-commerce/display-items.php. anyone know what my problem is ?

some very buggy jscript issues with firefox. don’t you cross browser test?

Estoy desarroyando una tienda online con WP e-Commerce y tengo alguna duda con el plugin.
Pero mi problema es que nadie habla en español y yo no me defiendo muy bien en ingles.
Si alguien me puede hechar una mano.
mi correo es info@nemodigital.net.
un saludo.