That's always been my biggest complaint about SBA was the scrolling. I have to say that search box at the top has helped tremendously.
I'm going to leave it for the time being and see how the 'jump to' works, but did want to ask about the ability to remove it. One cart we have has over 2000 items and the new one I'm working on now will have in the hundreds minimum. All of the titles will be somewhat similar since they are all motorcycle helmets.
In a perfect world (my opinion), all the items wouldn't display on the page automatically or refresh back to the top every time you click submit. It would just have the search box or a dropdown list of model numbers and stay on the selected item until you click save.
BUT since I am not a coder and can't do it myself, I am extremely grateful for those of you who do create these mods and happily use them however they are set up.
I've been using it in Opera and IE8/9 and only have one product listed right now during my testing. Once I get more listed I'll let you know how it displays and if it needs tweaking.
I'll finish that project tomorrow, I've made enough mistakes today!
If it is a long line of buttons and that's why you don't like it, you could change one line of code and have links without the fancy buttons...
admin/includes/classes/products_with_attributes_stock.php
Change line 142 to not use the CSS buttons:
$html .= '<a href="#'.$row['products_name'].'"><span class="cssButton" onmouseover="this.className=\'cssButtonHover\'" onmouseout="this.className=\'cssButton\'">'.$row['products_name'].'</span></a>';
to:
$html .= '<b>[ </b><a href="#'.$row['products_name'].'">'.$row['products_name'].'</a><b> ] </b>';
Ron Huseby
[email protected]
I know this isn't what you were talking about, but when you mentioned a drop down list it made me think that could be yet another version. This would make the jump menu a drop down instead of buttons or plain links...
admin/includes/classes/products_with_attributes_stock.php
Add as lines:
- 131 $html .= '<form>';
- 132 $html .= '<select onChange="location=this.options[this.selectedIndex].value;" style="font-family:\'Arial\';color:#000000;background-color:#d9e1e5;font-size:10pt;">';
Change line 142 to: (144 after adding previous 2 lines)
- $html .= '<option value="#'.$row['products_name'].'">'.$row['products_name'].'</option>';
Change line 144 to: (146 after adding 2 lines)
- $html .= '</select></form></td></tr>';
Ron Huseby
[email protected]
I'm back. Are you sick of me yet?
PROBLEM: I have Fast and Easy Checkout installed. Now when I try to checkout it gets to the 'confirm order' page and I get this:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.product_attribute_is_free, pa.attributes_discounted ' at line 11
in:
[select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix, pa.product_attribute_is_free, pa.products_attributes_weight, pa.products_attributes_weight_prefix, pa.attributes_discounted, pa.attributes_price_base_included, pa.attributes_price_onetime, pa.attributes_price_factor, pa.attributes_price_factor_offset, pa.attributes_price_factor_onetime, pa.attributes_price_factor_onetime_offset, pa.attributes_qty_prices, pa.attributes_qty_prices_onetime, pa.attributes_price_words, pa.attributes_price_words_free, pa.attributes_price_letters, pa.attributes_price_letters_free, pa.products_attributes_maxdays, pa.products_attributes_maxcount, pa.products_attributes_filename pa.product_attribute_is_free, pa.attributes_discounted from products_options popt, products_options_values poval, products_attributes pa left join products_attributes_download pad on pa.products_attributes_id=pad.products_attributes_id where pa.products_id = '150:d589ee96db65a5fd30e81707a211f4a4' and pa.options_id = '1' and pa.options_id = popt.products_options_id and pa.options_values_id = '6' and pa.options_values_id = poval.products_options_values_id and popt.language_id = '1' and poval.language_id = '1']
I have turned off FEC and the problem still happens, so I don't think it's a conflict with that mod.
Any ideas what I did wrong or what needs to be fixed? I originally posted this in the regular SBA thread with no response(different cart I was building - SBA 1.4.14). Other people tested that cart and checkout went through fine for them, so I assumed it was just me.
Same thing just now happened on this new site with the SBA+Model numbers mod. Had others test and they are getting the same error too.
I'll finish that project tomorrow, I've made enough mistakes today!
Another update....
If I change Configuration > Check Stock level to false I can't add anything to the cart. I get a blank white page that says:
1065 Query was empty
in:
[]
If I turn it back to true, I can add to the cart, but get the same 1064 SQL syntax error I asked about above.
I'm assuming it's all part of the same issue. If someone could just point me in a direction to look, I'd greatly appreciate it.
I'll finish that project tomorrow, I've made enough mistakes today!
I'm not sure about the Fast Easy Checkout problem, but this empty query has to do with my MOD... Here is the fix.
File: /includes/modules/pages/shopping_cart/header_php.php
Insert this routine at line #132 right above // stock by attributes.
Code:if ( STOCK_CHECK == 'false' ) { // Added for my_stock_id to work with stock check off unset($attributes); if(is_array($products[$i]['attributes'])){ $attributes = $products[$i]['attributes']; } else { $attributes = ''; } // rhuseby: (my_stock_id MOD) $my_stock_id = zen_get_my_stock_id($products[$i]['id'], $attributes); // rhuseby: end (my_stock_id MOD) }
Ron Huseby
[email protected]
Thank you, Ron! That did fix the empty query issue.
The SQL syntax error has something to do with the attributes but I'm not sure what. Same issue with or without FEC.
I added a product with NO attributes whatsoever and I can check out fine. It only happens with products that have attributes - whether their variants have been set up in SBA or not.
I'll finish that project tomorrow, I've made enough mistakes today!
Bookmarks