randy35kc Posted March 6, 2008 Share Posted March 6, 2008 I have read through this support thread plus support for Option Type Feature. I am looking for anyone who has combined the two add-ons (Attribute Sets + Option Type) Both seem to work perfectly but just prior to completing the check-out process the option type (text field info) disappears from the order. The session seems to retain it but it looks like it fails to write to the database. I tested Option Type Feature WITHOUT the attribute set and it works to that point. any ideas? anyone??? Quote Link to comment Share on other sites More sharing options...
toasty Posted March 17, 2008 Author Share Posted March 17, 2008 I have read through this support thread plus support for Option Type Feature. I am looking for anyone who has combined the two add-ons (Attribute Sets + Option Type) Both seem to work perfectly but just prior to completing the check-out process the option type (text field info) disappears from the order. The session seems to retain it but it looks like it fails to write to the database. I tested Option Type Feature WITHOUT the attribute set and it works to that point. any ideas? anyone??? Hi Sorry for delay - I don't keep up with this as much as I used too (as most issues are coverred now!). I have option type feature working with ASP (it's great by the way - recommend to everyone!); however I seem to remember (this is going back 2 or 3 years!) I did have some issues similar to your description and had to jig the code a little. I cannot see how ASP would effect OTF though, as ASP does not change any standard code in the catalog at all (apart from a little display work that is optional anyway and effects nothing else) and certainly changes nothing in the checkout process. If you let me know which file is giving you the issue (provide url) maybe I can provide something for you to compare if that helps - but my code may have custom changes (although normally commented). cheers Chris. Quote Link to comment Share on other sites More sharing options...
xswiftyx Posted March 18, 2008 Share Posted March 18, 2008 I have installed up to v2.0 and works fine. The only problem is that there is no option to upload image anymore..... all images are there from pre installtion but what if I want to add a new product? Anyone know why? Quote Link to comment Share on other sites More sharing options...
Guest Posted March 29, 2008 Share Posted March 29, 2008 Hi Everyone i've just installed this excellent contrib which works fine, until I go to the online gallery, select a product and I get the folloing under the description with no drop down selection box 1146 - Table 'grdigitalartworld_gall1.TABLE_PRODUCTS_ATTRIBUTES_SETS_TO_PRODUCTS' doesn't exist SELECT pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix , pase.sort_order FROM products_attributes pa, TABLE_PRODUCTS_ATTRIBUTES_SETS_TO_PRODUCTS pas2pa, TABLE_PRODUCTS_ATTRIBUTES_SETS pas, TABLE_PRODUCTS_ATTRIBUTES_SETS_ELEMENTS pase, products_options_values pov WHERE pa.products_id = '32' AND pa.options_id = '6' AND pas2pa.products_id = pa.products_id AND pas.products_attributes_sets_id = pas2pa.products_attributes_sets_id AND pas.products_options_id = pa.options_id AND pase.products_attributes_sets_id = pas.products_attributes_sets_id AND pase.options_values_id = pa.options_values_id AND pov.products_options_values_id = pa.options_values_id AND pov.language_id = '1' ORDER BY pase.sort_order, pa.options_values_id [TEP STOP] Available Options: Running the database query and checking the tables existed was the first thing I did as per the instructions. I've double checked the table is in the database and it definately is. So would anyone else be able to throw some light on whaat is happening here/ Cheers Gill Quote Link to comment Share on other sites More sharing options...
Guest Posted March 29, 2008 Share Posted March 29, 2008 Hi Everyone i've just installed this excellent contrib which works fine, until I go to the online gallery, select a product and I get the folloing under the description with no drop down selection box 1146 - Table 'grdigitalartworld_gall1.TABLE_PRODUCTS_ATTRIBUTES_SETS_TO_PRODUCTS' doesn't exist SELECT pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix , pase.sort_order FROM products_attributes pa, TABLE_PRODUCTS_ATTRIBUTES_SETS_TO_PRODUCTS pas2pa, TABLE_PRODUCTS_ATTRIBUTES_SETS pas, TABLE_PRODUCTS_ATTRIBUTES_SETS_ELEMENTS pase, products_options_values pov WHERE pa.products_id = '32' AND pa.options_id = '6' AND pas2pa.products_id = pa.products_id AND pas.products_attributes_sets_id = pas2pa.products_attributes_sets_id AND pas.products_options_id = pa.options_id AND pase.products_attributes_sets_id = pas.products_attributes_sets_id AND pase.options_values_id = pa.options_values_id AND pov.products_options_values_id = pa.options_values_id AND pov.language_id = '1' ORDER BY pase.sort_order, pa.options_values_id [TEP STOP] Available Options: Running the database query and checking the tables existed was the first thing I did as per the instructions. I've double checked the table is in the database and it definately is. So would anyone else be able to throw some light on whaat is happening here/ Cheers Gill SOLVED! I forgot to upload the second database_tables.php file as in Step 5.2 :'( Quote Link to comment Share on other sites More sharing options...
Guest Posted March 29, 2008 Share Posted March 29, 2008 Oh heellp - what do I do now? http://grdigitalartworld.110mb.com/product...?products_id=32 If you could take a look at the above link please? My product has 3 differant Attribute Sets with something like 6-9 values in each set. I want the customer to be able to choose 1 option only from the 3 sets which goes into the basket. I would also prefer not to have have a price show in the topright hand corner. I have put in a script to stop that from happening if the price is set to 0 but if I leave it at zero I loose the add to cart button. So my question is how do I get around all of that and how do i write it?- I havent a clue! Something tells me Im definately not going to solve this one on my own. Cheers Gill Quote Link to comment Share on other sites More sharing options...
toasty Posted April 2, 2008 Author Share Posted April 2, 2008 Attributes Sets Plus Support Announcement It is two and a half years since I launched ASP and I believe all issues that will arise have already arisen and been dealt with somewhere in this thread. It is now time for me to back off and withdraw from supporting this contribution. I will still be available for contact and I may pop in now and again but it will be on the back burner. Enjoy ASP and if anyone would like offer their ongoing support for this contribution please go ahead. my best to all Chris. :thumbsup: Quote Link to comment Share on other sites More sharing options...
VibeX Posted April 8, 2008 Share Posted April 8, 2008 Thanks for the additional set contrib, Toasty! The first time I ran it, I got this error; but, was unable to reproduce. Just thought I would put it out there for future reference. 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 '.98, price_prefix = '+', sort_order = 7 WH UPDATE products_attributes_sets_elements SET options_values_id = 33, options_values_price = 0.000025.98, price_prefix = '+', sort_order = 7 WHERE products_attributes_sets_elements_id = 44 1. I can add more atributes to a SET, if i have to do it, i DO have to create a new set, :( Please see this page for supplemental support information about this issue: http://portallink.linkmatics.com/aspscreenshots Quote Rob ---------- working on a way to make Price Groups, any ideas? Link to comment Share on other sites More sharing options...
VibeX Posted April 8, 2008 Share Posted April 8, 2008 Hi Toasty, has the status changed since your post? Has someone come up with a mod to allow this function? i have a slight problem, in that once i assign a set to a product, i cannot remove it by un selecting the box in products_attributes_sets_edit.php. I can ad sets by using that screen but not remove them. The only way i can remove a set from a product is by actually unselecting it in the on the same page used to edit the product details in categories.php This is a documented issue. You must remove sets using the product edit as you have described. Quote Rob ---------- working on a way to make Price Groups, any ideas? Link to comment Share on other sites More sharing options...
Guest Posted April 13, 2008 Share Posted April 13, 2008 darn, 4 years solving problems and I miss him by 10 days. Maybe some1 else might know: I'm running a custom template store with as+ as the only contribution atm. I'm haven't noticed any problems with functionality, however I am getting an extra column on my product preview pages. It contains 5 sections: product categories, a manufacturer drop down, a "featured item" box (it doesn't actually say that, but has an item), a search field, and a final box with policy links (shipping, privacy statement, yadayada). I believe the mistake I made was simply copying and pasting the contributions files during install, which were probably written for a "vanilla" osc store. (I did this cuz, hey, it's first contribution I want to start with) can anyone recomend what file is the likely culprit and/or any other clues. Perhaps I could just delete these out if I know where to find them? Thanks. Quote Link to comment Share on other sites More sharing options...
Guest Posted April 13, 2008 Share Posted April 13, 2008 follow up: yea, the catalog/product_info.php needed to have the codes manually edited, rather than just copying and pasting the whole file as I did. I'm no expert at oscommerce by any means, but I'm noticing that 75% of my problems with contribution installs come from differences in writting between the template store and the default store... and 90% of those are related the the catalog/product_info.php file. Just a mention to those like myself whom are starting out and using a custom template....so don't blame the contribution until you've totally ruled out manual error! :D Quote Link to comment Share on other sites More sharing options...
@llen Posted May 6, 2008 Share Posted May 6, 2008 Hi, this contri works great. I just have a problem with VAT. All products in my store are showed excluding VAT. VAT will be added during checkout procedure. When I choose a product where I have used attribute sets, the VAT will not be added at all, for other products it works correctly. Does anyone know how I can solve this problem? Thanks a lot! Ellen Quote Link to comment Share on other sites More sharing options...
toasty Posted June 3, 2008 Author Share Posted June 3, 2008 Hi, this contri works great. I just have a problem with VAT. All products in my store are showed excluding VAT. VAT will be added during checkout procedure. When I choose a product where I have used attribute sets, the VAT will not be added at all, for other products it works correctly. Does anyone know how I can solve this problem? Thanks a lot! Ellen Well this is a new one. I have a hunch it is to do with your process for adding the products - it is highly unlikely that it is anything to do with ASP. Is the tax class set up correctly on the product? The only pricing involvement from ASP is to include the 'attributes' price (if required) - the core product information (ie Tax) is not effected by ASP. regards Chris. Quote Link to comment Share on other sites More sharing options...
@llen Posted June 3, 2008 Share Posted June 3, 2008 Hi Chris, I reinstalled ship2pay and everthing is ok now. probably just a setting somewhere........ Thanks for yr reply Quote Link to comment Share on other sites More sharing options...
mrtickle Posted June 13, 2008 Share Posted June 13, 2008 Hi, I have an issue where I have color swatches on some of my product options and the attribute sets module is over writting them on every product update. Basically I would like it to not do that if the product hasn't been updated. I have played around with this for hours and no luck I know this code does all the deleting and updating I am hoping someone can help me change it so it doesnt update all the attribute sets of the product when you are just editing the name etc. // BOF Linkmatics attributes sets plus function jjg_db_attributeSets($arr_attributeSetID, $productID, $action, $arr_remove_sets = array(), $link = 'db_link'){ if( $action == 'update_product' || 'delete_product_confirm' ){ for($j=0; $j<count($arr_attributeSetID); $j++){ if( empty($arr_attributeSetID[$j]) ){ continue; } $options_query = "SELECT pas.products_options_id FROM ".TABLE_PRODUCTS_ATTRIBUTES_SETS ." pas WHERE pas.products_attributes_sets_id = " . (int)$arr_attributeSetID[$j]; $products_attributes_options_query = tep_db_query($options_query, $link); // Changed delete to only delete those options from product attributes that are currently in Attributes Sets - leaves existing options on product // This could be done in single delete query but split with above select for now while ($products_attributes_delete_options = tep_db_fetch_array($products_attributes_options_query)){ $delete_query = " DELETE FROM ". TABLE_PRODUCTS_ATTRIBUTES . " WHERE products_id=" . $productID . " AND options_id=" . $products_attributes_delete_options['products_options_id'] . " "; tep_db_query($delete_query, $link); } $delete_query = " DELETE FROM " . TABLE_PRODUCTS_ATTRIBUTES_SETS_TO_PRODUCTS . " WHERE products_attributes_sets_id = " . $arr_attributeSetID[$j] . " AND products_id = " . $productID; tep_db_query($delete_query, $link); } } //if you remove the product, then our work is done if( $action == 'delete_product_confirm' ){ return; } reset($arr_attributeSetID); for($j=0; $j<count($arr_attributeSetID); $j++){ if( empty($arr_attributeSetID[$j]) ){ continue; } if( in_array($arr_attributeSetID[$j], $arr_remove_sets) ){ continue; } $select_query = "select pas.products_options_id, pase.options_values_id, pase.options_values_price, pase.price_prefix, pase.sort_order FROM " . TABLE_PRODUCTS_ATTRIBUTES_SETS . " pas, " . TABLE_PRODUCTS_ATTRIBUTES_SETS_ELEMENTS . " pase WHERE pas.products_attributes_sets_id = " . $arr_attributeSetID[$j] . " AND pase.products_attributes_sets_id = " . $arr_attributeSetID[$j] . " "; $products_attributes_sets_query = tep_db_query($select_query, $link); while ($products_attributes_sets_values = tep_db_fetch_array($products_attributes_sets_query)){ $valOptions_id = $products_attributes_sets_values['products_options_id']; $valOptions_values_id = $products_attributes_sets_values['options_values_id']; $valOptions_values_price = $products_attributes_sets_values['options_values_price']; $valPrice_prefix = $products_attributes_sets_values['price_prefix']; $insert_query = "insert into " . TABLE_PRODUCTS_ATTRIBUTES . " (products_id, options_id, options_values_id, options_values_price, price_prefix) values ". " (".$productID.",".$valOptions_id.",".$valOptions_values_id.",".$valOptions_values_price.",'".$valPrice_prefix."')"; tep_db_query($insert_query, $link); } //END OF FETCH WHILE LOOP $insert_query = "insert into ".TABLE_PRODUCTS_ATTRIBUTES_SETS_TO_PRODUCTS . " (products_attributes_sets_id, products_id) values (".$arr_attributeSetID[$j].",".$productID.")"; tep_db_query($insert_query, $link); } } Quote Link to comment Share on other sites More sharing options...
patrick.bernardi Posted June 20, 2008 Share Posted June 20, 2008 Hey everyone, I am a bit knew to OSCommerce but i used this contrib and installed with success, at least i thought. I am able to creat attribute sets and assign them to a product i do not see the sizes i created when i shop. no drop down or check box appears when i view a product. could anybody help? Thanks PB Quote Link to comment Share on other sites More sharing options...
Guest Posted June 24, 2008 Share Posted June 24, 2008 Is there a way to make the order of items alphabetical? I put the items in alphabetical but osCommerce arranged them in a different order. Quote Link to comment Share on other sites More sharing options...
ChantalC Posted August 8, 2008 Share Posted August 8, 2008 Is this Contri (Version 1.2b) compatible with QTpro 4.51? I have osC 2.2rc2a installed. Thanks in advance. Quote Link to comment Share on other sites More sharing options...
ChantalC Posted August 8, 2008 Share Posted August 8, 2008 Is this Contri (Version 1.2b) compatible with QTpro 4.51? I have osC 2.2rc2a installed. Thanks in advance. Quote Link to comment Share on other sites More sharing options...
cg180659 Posted August 24, 2008 Share Posted August 24, 2008 Hiya! Added this contrib. But now I'm stuck. I don't see the "Attributes Set" Link under "Product Attributes" Where am I going wrong please? Quote SPACE FOR RENT! Link to comment Share on other sites More sharing options...
ronrrico Posted August 29, 2008 Share Posted August 29, 2008 Hi guys, I'm getting this error when I try to add a Attrubute set to a product: If I do not select a set and click save then I get ""Product Update Successful"" Can someone help me please...... I had the old jj attribute set installed that I never got to work, I uninstalled it and installed attribute set plus. When I tryed to upload the new sql it was denied beacause Duplicate; # drop table products_attributes_sets; # drop table products_attributes_sets_to_products; so I was just able to upload; drop table products_attributes_sets_elements; 1054 - Unknown column 'pas.products_options_id' in 'field list' SELECT pas.products_options_id FROM products_attributes_sets pas WHERE pas.products_attributes_sets_id = 2 [TEP STOP] Please Help! Quote Link to comment Share on other sites More sharing options...
trophy Posted August 29, 2008 Share Posted August 29, 2008 Where can I see a site with this contribution running? Quote Link to comment Share on other sites More sharing options...
Guest Posted September 3, 2008 Share Posted September 3, 2008 Can I just stop by and say that I have successfully installed this contribution this morning and I am so very very pleased. I thought it was written up with clear instructions and well commented edits for adding to a pre existing store. Oh how I wish they were all written like this. I failed to be able to install QT Pro which I really needed for customer options and stock control on my range of similar products but no matter what I did I failed, even on a fresh install, go figure!! This goes halfway to fulfilling my needs and I am extremely grateful. I will have to manually watch the stock but at least the customers (If I open on time and actually have any LOL) can make the choices required. I am no expert guys but if you go through this contribution instructions really carefully and miss nothing out it will and does work like a charm. Takes a little figuring out how to set up the Attribute sets to match your personal shop requirements but I have managed it all and it took 1 1/2 hours which for me must be a record haha! I may be back with egg on my face but for now its FAB FAB FAB... Grateful thanks to all contributors. Heather (No link to live store yet sorry as I am not open, 3 weeks to go....) Quote Link to comment Share on other sites More sharing options...
textbook Posted September 25, 2008 Share Posted September 25, 2008 (edited) good contribution Edited September 25, 2008 by textbook Quote Link to comment Share on other sites More sharing options...
lindsayanng Posted September 25, 2008 Share Posted September 25, 2008 Hi guys, I'm getting this error when I try to add a Attrubute set to a product:If I do not select a set and click save then I get ""Product Update Successful"" Can someone help me please...... I had the old jj attribute set installed that I never got to work, I uninstalled it and installed attribute set plus. When I tryed to upload the new sql it was denied beacause Duplicate; # drop table products_attributes_sets; # drop table products_attributes_sets_to_products; so I was just able to upload; drop table products_attributes_sets_elements; 1054 - Unknown column 'pas.products_options_id' in 'field list' SELECT pas.products_options_id FROM products_attributes_sets pas WHERE pas.products_attributes_sets_id = 2 [TEP STOP] Please Help! Well, sounds liek you only uninstalled the php code from that old contribution and not the mysql code that it installled.. Quote A great place for newbies to start Road Map to oscommerce File Structure DO NOT PM ME FOR HELP. My time is valuable, unless i ask you to PM me, please dont. You will get better help if you post publicly. I am not as good at this as you think anyways! HOWEVER, you can visit my blog (go to my profile to see it) and post a question there, i will find time to get back and answer you Proud Memeber of the CODE BREAKERS CLUB!! Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.