Guest Posted February 25, 2007 Share Posted February 25, 2007 Is there anyway to have every product have an SKU and different product attributes with different SKU's. For example: Short T-shirt, in blue sku=001 in red sku=002 Has anybody successfully implemented this? If so, how? which contribution did you use? Link to comment Share on other sites More sharing options...
Guest Posted February 25, 2007 Share Posted February 25, 2007 Is there anyway to have every product have an SKU and different product attributes with different SKU's. For example: Short T-shirt, in blue sku=001 in red sku=002 Has anybody successfully implemented this? If so, how? which contribution did you use? Still hoping someone can help ;-) Link to comment Share on other sites More sharing options...
Guest Posted February 25, 2007 Share Posted February 25, 2007 Still hoping someone can help ;-) I AM LOOKING FOR THE SAME THING.. SOMETHING ALONG THE LINES OF A DROP DOWN MENU IN THE PRODUCT DESCRIPTION AREA/ADD TO CART Link to comment Share on other sites More sharing options...
Guest Posted February 25, 2007 Share Posted February 25, 2007 the closest I can think of is the master products. The sku for a product is not a problem you could use the model field or if you also need the model you create an extra column for the sku. (by duplicating the model). The attributes options/attribute values however do not directly related with the products_id. So to get to that level you may want to use something similar to the products_attributes_download table. So you could create an extra table to store the skus there. Then you could retrieve those when displaying the product info. This can bind your products_attributes table to your skus table (whatever the name will be). Link to comment Share on other sites More sharing options...
Guest Posted February 25, 2007 Share Posted February 25, 2007 the closest I can think of is the master products. The sku for a product is not a problem you could use the model field or if you also need the model you create an extra column for the sku. (by duplicating the model). The attributes options/attribute values however do not directly related with the products_id. So to get to that level you may want to use something similar to the products_attributes_download table. So you could create an extra table to store the skus there. Then you could retrieve those when displaying the product info. This can bind your products_attributes table to your skus table (whatever the name will be). That sounds like a lot of work, i mean I could probably figure out how to create a table but the SKU's need to be passed to invoicing along with all product details. I'm presuming that entails serious modification, way beyond anything I would be capable of doing. Can't somebody recommend a mod? Link to comment Share on other sites More sharing options...
Guest Posted February 27, 2007 Share Posted February 27, 2007 That sounds like a lot of work, i mean I could probably figure out how to create a table but the SKU's need to be passed to invoicing along with all product details. I'm presuming that entails serious modification, way beyond anything I would be capable of doing. Can't somebody recommend a mod? top Link to comment Share on other sites More sharing options...
jonquil Posted February 28, 2007 Share Posted February 28, 2007 There is a mod. For the life of me I can't remember who's done it. For each attribute chosen by the customer, there is a letter appended to the model # so that if the attributes didn't make through the checkout process, the appended products_model would. I'll try to find it. jon It's all just ones and zeros.... Link to comment Share on other sites More sharing options...
Guest Posted March 1, 2007 Share Posted March 1, 2007 There is a mod. For the life of me I can't remember who's done it. For each attribute chosen by the customer, there is a letter appended to the model # so that if the attributes didn't make through the checkout process, the appended products_model would. I'll try to find it. jon If you could help jon I would be so gratefull :-) thanks! Link to comment Share on other sites More sharing options...
jonquil Posted March 1, 2007 Share Posted March 1, 2007 Jeez Louis... Finally found it :) http://www.oscommerce.com/forums/index.php?showtopic=251032 " Contribution can be found at http://www.oscommerce.com/community/contributions,4888 " jon It's all just ones and zeros.... Link to comment Share on other sites More sharing options...
Guest Posted March 13, 2007 Share Posted March 13, 2007 .................... Link to comment Share on other sites More sharing options...
Guest Posted March 13, 2007 Share Posted March 13, 2007 Jeez Louis... Finally found it :) http://www.oscommerce.com/forums/index.php?showtopic=251032 " Contribution can be found at http://www.oscommerce.com/community/contributions,4888 " jon Hi there, unfortunatly this is not what I want. It doesn't support true multiple SKU's it only appends one letter to an existing sku blue Tshit = sku001/b Red Tshirt = sku001/r This is not what I want. I want this. blue Tshit = sku001 Red Tshirt = sku002 The reason being is we already have set SKU's in this format so cannot change them. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.