[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [ic] Relational options question


On Tue, 14 Feb 2006, Sandy Thomson wrote:

Would it not make more sense to have something like:

options table
--
sku-optionA sku
sku-optionB sku

option contents table
--
sku-optionA label1 price1
sku-optionA label2 price2
sku-optionA label3 price3
sku-optionB label4 price4

The reason I am asking this is that we want to vary the price of a product depending on a combination of options being selected, and the price increment is not linear. Its not even quite as simple as that but i am trying to explain it so you can understand - it would be using custom CommonAdjust functions and a relational database would really help. Before I go off and rewrite the interchange core options functionality has this been done already? Any suggestions about how I might begin to tackle this task?

Sandy,

I may not fully understand what you're asking for, but it sounds a lot like the standard Matrix options module that has been in Interchange for the past couple of versions, where you have a separate variants table (like your "option contents table"). See lib/Vend/Options/Matrix.pm in your Interchange directory. Perhaps that's what you need?

Jon


--
Jon Jensen
End Point Corporation
http://www.endpoint.com/

_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users


Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.