Galeenet Posted September 26, 2008 Share Posted September 26, 2008 Context : integrate 300 statues in an existing oscommerce install (stock%attributes already installed) attribute size : around 50 values attribute color : around 10 values Each statue is available in at least one color and at least ten sizes. Example : __natural color ____6 cm 6EUR ____12cm 12 EUR ____20cm 20 EUR ____30 cm 45 EUR __stained color ____6cm 10 EUR ____12cm 20 EUR ____20cm 30 EUR ____30cm 45 EUR ____40cm 60 EUR Prices are fakes, the idea being that each size/color combination has its price. I tried several ways : - one ID/product per statue, attribute color + attribute size. ie product 'FooStatue' att 6cm att stained. the problem is 'each size/color combination has its price'. The 6cm stained may be 4 eur more than 6cm naturel, but the 12cm stained is 8 EUR more than 12 cm, so I found no way to display the correct price to the customer. - one ID/product per statue-color, attribute size. ie product 'FooStatue-natural' att (x)cm , product 'FooStatue-stained' att (x)cm, etc. That makes a lot of products (around 1000 references). Besides images are not available for all statue-color combination (there is a fallback image). - another possibility could be : one ID/product per statue, attribute (size+color). ie attribute 'variation', values ('natura-20cm','natural-30cm', etc.). That would make an awful lot of attributes values (I'm guessing around 3000 to cover each color-size combination). Besides, we don't intend to sell all references, but mostly the bigger (size) ones, which will be difficult to sort with a composite attribute. Any ideas or magical contributions ? Link to comment Share on other sites More sharing options...
Galeenet Posted September 27, 2008 Author Share Posted September 27, 2008 Am I the first ever to encounter such attribute pricing ? Even examples of osco websites running with these kind of pricing would help me ! thanks Link to comment Share on other sites More sharing options...
lindsayanng Posted September 27, 2008 Share Posted September 27, 2008 can i just clarify for a section.. You are saying that a 2ft. Tall Stained Statue is a different price than a 2 Foot tall Painted statue.. It is also a different price from a 3Ft tall stained statue... I DO believe that there was some kind of way around this, but I can not rememeber.. Right now my brain is fried.. i logged another 13 hours of web design and its 4 am. I need to sleep.. p[lus i have a fun day with the inlaws ahead of me.. SO yea.. I will sleep on this and see if i can think up anything... 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...
Galeenet Posted September 27, 2008 Author Share Posted September 27, 2008 what would be simple : 2ft painted : 10 eur 2ft stained : 15 eur (+5) 3ft painted : 20 eur (x2 % 2ft) 3ft stained: 25 eur (+5) (or 3ft stained: 30 eur (+50% % painted) ... or any systemic price) what is : 2ft painted : 10 eur 2ft stained : 15 eur 3ft painted : 18 eur 3ft stained: 24 eur see the problem ? there is no system in the prices, they're all custom :( Link to comment Share on other sites More sharing options...
Galeenet Posted September 27, 2008 Author Share Posted September 27, 2008 in fact, I'm not the only one trying to do that : http://www.oscommerce.com/forums/index.php?showtopic=315646 http://www.oscommerce.com/forums/index.php?showtopic=273904 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.