panhfwgc Posted October 4, 2005 Share Posted October 4, 2005 The logic is as follows: - create your option - create your attributes set(s) create your product THEN edit your product Currently you cannot add sets to a product that does not yet exist. You must create it then edit to add the sets. This is true with Attributes Sets Plus as well. regards Chris Hi,Chris Thank you for your help! The logic that you said is right , but I can add sets when I creat a new product in Attributes Sets 4.0 , I think the 4.0 is more convenience then 5.5 in this function, Can you tell me the pivotal difference between 4.0 and 5.5 . Thanks Best regards Caleb Quote Link to comment Share on other sites More sharing options...
ScrltOTara Posted October 21, 2005 Share Posted October 21, 2005 My problem is that the attributes are sorting backwards. I put them from 1-20 in the order I want, but in the order form, they sort from 20-1. Am I missing something? Quote Tara Lang Link to comment Share on other sites More sharing options...
jeffy777 Posted October 21, 2005 Share Posted October 21, 2005 yes, its a known issue with this contrib. As far as I can tell, Attribute Sets Plus fixes this problem: http://www.oscommerce.com/community/contributions,3610 Quote Link to comment Share on other sites More sharing options...
ScrltOTara Posted October 21, 2005 Share Posted October 21, 2005 Ok, so I removed Attribute Sets, installed the Plus version, and now there is NO sorting whatsoever to my attribute sets. Quote Tara Lang Link to comment Share on other sites More sharing options...
Brian-Bear Posted October 28, 2005 Share Posted October 28, 2005 Two great contibutions I use are the Attribute sets and Mass Move. The only problem is mass move will move or copy the products really well but unfortunatly it will not move the attribute sets, has anyone fixed this problem. I know this might not be the correct thread but I cannot find a mass move thread in the forum cheers Brian Quote Link to comment Share on other sites More sharing options...
toasty Posted October 28, 2005 Share Posted October 28, 2005 Ok, so I removed Attribute Sets, installed the Plus version, and now there is NO sorting whatsoever to my attribute sets. Hi - just spotted this - if you are using attributes sets plus this is the wrong thread - but to answer your issue just check you have correctly installed the scripts - it does worK! chris Two great contibutions I use are the Attribute sets and Mass Move. The only problem is mass move will move or copy the products really well but unfortunatly it will not move the attribute sets, has anyone fixed this problem. I know this might not be the correct thread but I cannot find a mass move thread in the forum cheers Brian I am not familiar with Mass Move but if it moves between categories I do not see why it should affect the attributes sets - Speaking specifically for Attributes Sets Plus, once allocated to a product the product attributes are standard osC - its only the sets storage that is custom whcih is in its own custom tables, so it has no impact on your other contribution. regards Chris. Quote Link to comment Share on other sites More sharing options...
Kyle22 Posted October 29, 2005 Share Posted October 29, 2005 when i go to look at a product, i get this error: 1146 - Table 'photogra_osCommerce.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 = '28' AND pa.options_id = '1' 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 however, there is a table called "products_attributes_sets_to_products" in the database called "photogra_osCommerce"... and that table has col's called " products_attributes_sets_to_products", "products_attributes_sets_id" and "products_id" any ideas why this is happening? Quote Link to comment Share on other sites More sharing options...
toasty Posted October 29, 2005 Share Posted October 29, 2005 (edited) when i go to look at a product, i get this error: 1146 - Table 'photogra_osCommerce.TABLE_PRODUCTS_ATTRIBUTES_SETS_TO_PRODUCTS' doesn't exist any ideas why this is happening? Because you are missing a statement like : define('TABLE_PRODUCTS_ATTRIBUTES_SETS_TO_PRODUCTS', 'products_attributes_sets_to_products'); for the file: catalog/includes/database_tables.php Check your install instructions (or better yet install Attributes Sets Plus that supercedes this contribution). Edited October 29, 2005 by toasty Quote Link to comment Share on other sites More sharing options...
Kyle22 Posted October 29, 2005 Share Posted October 29, 2005 toasty: i checked and redid both database_table.php files with no success. edit: oh, i didnt even realize it but i am using Linkmatics_AttributeSetsPlus_v1 Quote Link to comment Share on other sites More sharing options...
Kyle22 Posted October 30, 2005 Share Posted October 30, 2005 full files and error msg's at this link: http://www.oscommerce.com/forums/index.php?sho...&gopid=731621 Quote Link to comment Share on other sites More sharing options...
Guest Posted November 3, 2005 Share Posted November 3, 2005 Hi, Thanks this Attribute Sets works great. I do have a question that has probably been asked atleast a dozen times, my search skills seem to be lacking, as I was unable to find the answer. Several of the products in my store have up to 6 different options. (Thanks to this contribution, were very simple to add to the store) Is there any way to set the order the options appear? Say I have a style and and a size. I want the style option to appear on the product page before the size, can this be done? I used attribute sets 5.5 with the bug fix. I did not try the plus contrib as this works well the way it is. I would like to be able to set the order though. Thanks :) Quote Link to comment Share on other sites More sharing options...
janetgot Posted November 9, 2005 Share Posted November 9, 2005 I hope somebody can point me in the right direction. In one of my stores under development, I have products that have different size options and different prices. In this instance it is candles of different sizes. Small candle is one price, medium is a little more, etc. We show a table of prices on the product page. My client doesn't like that the attributes drop down menu shows the Option Value Price. Is there a way to hide it in the drop down but still calculate the correct price? Thanks for any hints. Janet Quote Link to comment Share on other sites More sharing options...
Shuey Posted November 14, 2005 Share Posted November 14, 2005 I am receiving the following error when I press save to add a set to a product: 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 '0,'+',1)' at line 1 insert into products_attributes (products_id, options_id, options_values_id, options_values_price, price_prefix, sort_order) values (77,17,,0,'+',1) Any ideas? Much appreciated. This looks like it's going to be very very helpful and save countless hours! Thanks! Dale Quote Link to comment Share on other sites More sharing options...
WEB11 Posted November 18, 2005 Share Posted November 18, 2005 Hi, Can someone tell me what are the changes needed if any, to make this contribution work on a shop installed in the root folder? I had attribute sets plus installed on my shop and after I moved it to root the contrib stoped working, so before I attempt to install this one I would like to know if it will work. Thanks Quote Link to comment Share on other sites More sharing options...
WEB11 Posted November 18, 2005 Share Posted November 18, 2005 Disregard my question above, it works fine. When testing, I forgot to create new attributes and was trying to use the default ones to create sets. Quote Link to comment Share on other sites More sharing options...
webunite Posted December 9, 2005 Share Posted December 9, 2005 Hey, I noticed that you only use English - I wanted to do the same - how do I delete the other 2 default languages? Please help. THanks! Quote Link to comment Share on other sites More sharing options...
owl666 Posted December 19, 2005 Share Posted December 19, 2005 Hi, could someone please help me with the following problem? I am getting this error: Attribute Sets changes were saved.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 '' at line 1 select products_attributes_sets_id from products_attributes_sets_to_products where products_id = [TEP STOP] after editing an existing attribute-set. Is there a fix somewhere, which i might overseen? Another Problem: is it possible with AS (not AS PLUS, because i need multi-language) to do a correct sorting? (like in A->B->C and not C->B->A) Greets, Sandra Quote Link to comment Share on other sites More sharing options...
toasty Posted December 20, 2005 Share Posted December 20, 2005 Hi, could someone please help me with the following problem? I am getting this error: Attribute Sets changes were saved.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 '' at line 1 select products_attributes_sets_id from products_attributes_sets_to_products where products_id = [TEP STOP] after editing an existing attribute-set. Is there a fix somewhere, which i might overseen? Another Problem: is it possible with AS (not AS PLUS, because i need multi-language) to do a correct sorting? (like in A->B->C and not C->B->A) Greets, Sandra Quote Link to comment Share on other sites More sharing options...
toasty Posted December 20, 2005 Share Posted December 20, 2005 Hi, could someone please help me with the following problem? I am getting this error: Attribute Sets changes were saved.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 '' at line 1 select products_attributes_sets_id from products_attributes_sets_to_products where products_id = [TEP STOP] after editing an existing attribute-set. Is there a fix somewhere, which i might overseen? Another Problem: is it possible with AS (not AS PLUS, because i need multi-language) to do a correct sorting? (like in A->B->C and not C->B->A) Greets, Sandra Hello again Sandra I'm afraid it looks like you have fallen foul of the register_globals issue (read this thread and you'll find lots about it) (Assuming you have your php settings set to register_globals off ). This was one of the reasons for moving to ASP. I'm sorry I can't help you more at the moment (I am feeling your pain), but other priorities (with fees !!) keeping me busy - regards Chris Quote Link to comment Share on other sites More sharing options...
owl666 Posted December 20, 2005 Share Posted December 20, 2005 Hi Chris, well - register globals are switched on... (regarding to my .htaccess) <IfModule mod_php4.c> php_value session.use_trans_sid 0 php_value register_globals 1 </IfModule> I (or better: my customer) have two problems with ASP: 1) no multi-lang-support, 2) no integration of existent attribute sets as it seems? ... :/ Greets, Sandra Quote Link to comment Share on other sites More sharing options...
owl666 Posted December 20, 2005 Share Posted December 20, 2005 (edited) Hi again, well - inserting options to new products works, but not to old products. With old (like "existing" products) you have to do the following things: 1) edit product. 2) open "Add AS". 3) save (unmodified - either you really want to change something) AS 4) click on "edit this product" 5) click on "preview" 6) save the not-modified, but re-sorted (!) product, clicking finally on "refresh this product".... SIGH. Greets, Sandra Edited December 20, 2005 by owl666 Quote Link to comment Share on other sites More sharing options...
toasty Posted December 20, 2005 Share Posted December 20, 2005 Hi again, well - inserting options to new products works, but not to old products. With old (like "existing" products) you have to do the following things: 1) edit product. 2) open "Add AS". 3) save (unmodified - either you really want to change something) AS 4) click on "edit this product" 5) click on "preview" 6) save the not-modified, but re-sorted (!) product, clicking finally on "refresh this product".... SIGH. Greets, Sandra Are we talking ASP or AS here? C. Quote Link to comment Share on other sites More sharing options...
owl666 Posted December 20, 2005 Share Posted December 20, 2005 Are we talking ASP or AS here? C. AS Quote Link to comment Share on other sites More sharing options...
toasty Posted December 20, 2005 Share Posted December 20, 2005 AS Well, the reason I rewrote it is these types of issues cropping up all the time - sorry I can't help. If I could throw you an olive branch it would be to say that I will be looking at languages in the near future for ASP - it should not be to difficult because the design will easily accomodate it. C. Quote Link to comment Share on other sites More sharing options...
crainey Posted December 26, 2005 Share Posted December 26, 2005 I ran into a problem with the attributes not getting saved when I would use the Attributes Set Edit to assign sets to my products. I had to edit the products_attributes_sets_edit.php file and change: $asRowCount to $_POST['asRowCount'] Hope this helps someone out!!! Chad Quote 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.