disko Posted August 11, 2006 Share Posted August 11, 2006 I want to be able to sell made-to-measure fabric with different price bands. The fabric is sold by the centimetre. Width price per centimetre up to 36" = ?0.07 37" - 40" = ?0.07 41" - 45" = ?0.08 46" - 48" = ?0.08 49" - 54" = ?0.09 55" - 60" = ?0.09 61" - 63" = ?0.10 64" - 72" = ?0.11 73" - 81" = ?0.12 82" - 90" = ?0.13 91" - 108" = ?0.14 so if i want some fabric measuring 47" by 180 cm... i look down the chart to see 46"- 48" width = ?0.08 and multiply this by the number of centimetres (x 180) = ?14.40 i want the user to be able to enter two measurements (width & lenght) and have it calculate the price. the width measurement ranges are consistant for all products. i'm basically looking at doing this: http://www.web-blinds.com/ourProducts/prod...?product_id=120 Link to comment Share on other sites More sharing options...
♥Monika in Germany Posted August 11, 2006 Share Posted August 11, 2006 I want to be able to sell made-to-measure fabric with different price bands. The fabric is sold by the centimetre. Width price per centimetre up to 36" = ?0.07 37" - 40" = ?0.07 41" - 45" = ?0.08 46" - 48" = ?0.08 49" - 54" = ?0.09 55" - 60" = ?0.09 61" - 63" = ?0.10 64" - 72" = ?0.11 73" - 81" = ?0.12 82" - 90" = ?0.13 91" - 108" = ?0.14 so if i want some fabric measuring 47" by 180 cm... i look down the chart to see 46"- 48" width = ?0.08 and multiply this by the number of centimetres (x 180) = ?14.40 i want the user to be able to enter two measurements (width & lenght) and have it calculate the price. the width measurement ranges are consistant for all products. i'm basically looking at doing this: http://www.web-blinds.com/ourProducts/prod...?product_id=120 use the following setup: - add attribute sorting (contrib), so order is kept straight - use attributes for your table of width, using the lowerst value (0.07) as the base price and enetring price differences (default osC) - use show actual price for attribute for the dropdown (contrib) - add a quantity box right below your attribute dropdown (contrib quantity on product info), keep it nicely aligned and name it length :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ... Link to comment Share on other sites More sharing options...
disko Posted August 11, 2006 Author Share Posted August 11, 2006 or... is this over complicating what should be a simple process... should we be trying to find out the cost of 1cm square of fabric then doing a simpler 'X' x 'Y' x '1cm-square-price' ?? Link to comment Share on other sites More sharing options...
disko Posted August 11, 2006 Author Share Posted August 11, 2006 use the following setup:- add attribute sorting (contrib), so order is kept straight - use attributes for your table of width, using the lowerst value (0.07) as the base price and enetring price differences (default osC) - use show actual price for attribute for the dropdown (contrib) - add a quantity box right below your attribute dropdown (contrib quantity on product info), keep it nicely aligned and name it length sorry - i'm new to this.... half of this makes sense.... what does contrib mean? i'm looking in admin > Products Attributes and see how to add some things, but can see how to change the quantity box to name length? Link to comment Share on other sites More sharing options...
♥Monika in Germany Posted August 11, 2006 Share Posted August 11, 2006 contrib = contribution if you are totally new, it will take you some time to read and learn about these contributions, then install ... no inbuilt function here, sorry. You cannot change the name of the quantity box that you have not installed from a contribution ... :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ... Link to comment Share on other sites More sharing options...
disko Posted August 11, 2006 Author Share Posted August 11, 2006 contrib = contribution if you are totally new, it will take you some time to read and learn about these contributions, then install ... no inbuilt function here, sorry. You cannot change the name of the quantity box that you have not installed from a contribution ... ok.. i'm learning.. fast... is show actual price for attribute for the dropdown this.. Actual Attribute Price V1.0 ? (it looks like it) these contribution are making sense.... thanks for the pointer monika ;) Link to comment Share on other sites More sharing options...
♥Monika in Germany Posted August 11, 2006 Share Posted August 11, 2006 ok.. i'm learning.. fast... is this.. Actual Attribute Price V1.0 ? (it looks like it) these contribution are making sense.... thanks for the pointer monika ;) yes, that's the perfect one add that, one of the attribute sorters (there is a few), and then the quantity box. :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ... Link to comment Share on other sites More sharing options...
jpweber Posted August 12, 2006 Share Posted August 12, 2006 Or, just get the right UPS shipping module and that's fine to. Monika is great, but maybe this is too complicating .... Jason Simple 1-2-3 Intructions on how to get, install and configure SSL The Google Sandbox explained Simple to follow instructions on how to change the look of your OSC How To Make A Horrible OSC Website my toolbox: All things WordPress-related - All things Adobe-related - PHP Designer 2007 - Codecanyon Junkie - Crimson Editor - Winmerge - phpMyAdmin - WS_FTP my installed contributions: Category Banners, File Upload feature-.77, Header Tags, Sort_Product_Attributes_1, XSellv2.3, Price Break 1.11.2, wishlist 3.5, rollover_category_images_v1.2, Short_Description_v2.1, UPSXML_v1_2_3, quickbooks qbi_v2_10, allprods v4.4, Mouseover-effect for image-buttons 1.0, Ultimate_SEO, AAP 1.41, Auto Select State Value, Fast Easy Checkout, Dynamic SiteMap v2.0, Image Magic, Links Manager 1.14, Featured Products, Customer Testimonials, Article Manager, FAQ System, and I'm sure more ... Link to comment Share on other sites More sharing options...
jpweber Posted August 12, 2006 Share Posted August 12, 2006 *too Jason Simple 1-2-3 Intructions on how to get, install and configure SSL The Google Sandbox explained Simple to follow instructions on how to change the look of your OSC How To Make A Horrible OSC Website my toolbox: All things WordPress-related - All things Adobe-related - PHP Designer 2007 - Codecanyon Junkie - Crimson Editor - Winmerge - phpMyAdmin - WS_FTP my installed contributions: Category Banners, File Upload feature-.77, Header Tags, Sort_Product_Attributes_1, XSellv2.3, Price Break 1.11.2, wishlist 3.5, rollover_category_images_v1.2, Short_Description_v2.1, UPSXML_v1_2_3, quickbooks qbi_v2_10, allprods v4.4, Mouseover-effect for image-buttons 1.0, Ultimate_SEO, AAP 1.41, Auto Select State Value, Fast Easy Checkout, Dynamic SiteMap v2.0, Image Magic, Links Manager 1.14, Featured Products, Customer Testimonials, Article Manager, FAQ System, and I'm sure more ... Link to comment Share on other sites More sharing options...
disko Posted August 12, 2006 Author Share Posted August 12, 2006 Or, just get the right UPS shipping module and that's fine to. Monika is great, but maybe this is too complicating .... # how the hell can a shipping module help with what i need ?? Link to comment Share on other sites More sharing options...
♥Monika in Germany Posted August 12, 2006 Share Posted August 12, 2006 well doris, I would not know ... just glad about the compliments! I strongly believe with a steep learning curve and posting a few times you can do it! :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ... Link to comment Share on other sites More sharing options...
disko Posted August 13, 2006 Author Share Posted August 13, 2006 use the following setup: use attributes for your table of width, using the lowerst value (0.07) as the base price and enetring price differences (default osC) add a quantity box right below your attribute dropdown (contrib quantity on product info), keep it nicely aligned and name it length ok... so i'm thinking out aloud here (and expecting a nod of confirmation ;))... so the user can select the exact measurement for the width i need to enter an attribute for each measurement, for example; 36", 37", 38", 40", 41", etc... there would be no way of having a width field (like the length field) that looks up the table of width for the price range right ? (not without hard coding anyway - which would be above me!?) thanks for your help monika Link to comment Share on other sites More sharing options...
♥Monika in Germany Posted August 13, 2006 Share Posted August 13, 2006 ok... so i'm thinking out aloud here (and expecting a nod of confirmation ;))... so the user can select the exact measurement for the width i need to enter an attribute for each measurement, for example; 36", 37", 38", 40", 41", etc... there would be no way of having a width field (like the length field) that looks up the table of width for the price range right ? (not without hard coding anyway - which would be above me!?) thanks for your help monika nod for width (long list though ... I was hoping you could just keep that range, but obviously you need every entry, right?) no nod for height .... the quantity bo can OF COURSE be set up like a dropdown. Look for the code in the master products contrib, the modules file (only one that comes to my mind fast, sorry). Basically, you define the start and the end of the quantities offered and it loops and created all entries. ahh wait ...the osC default authorize net module creates a similar dynamic dropdown for the CC expiration year. Find it in the authorizenet.php line 149 :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ... Link to comment Share on other sites More sharing options...
disko Posted August 13, 2006 Author Share Posted August 13, 2006 would it be possible of doing it a simpler way in that we find out the cost of 1cm square of fabric then doing a simpler 'X' x 'Y' x '1cm-square-price' ?? is there any known way with any contribs you know of ? i'm just thinking of the long term and my client having to enter all these prices for each product. Link to comment Share on other sites More sharing options...
disko Posted August 15, 2006 Author Share Posted August 15, 2006 would it be possible of doing it a simpler way in that we find out the cost of 1cm square of fabric then doing a simpler 'X' x 'Y' x '1cm-square-price' ?? is there any known way with any contribs you know of ? i'm just thinking of the long term and my client having to enter all these prices for each product. (bump) anyone ?? Link to comment Share on other sites More sharing options...
bernarde Posted February 28, 2007 Share Posted February 28, 2007 would it be possible of doing it a simpler way in that we find out the cost of 1cm square of fabric then doing a simpler 'X' x 'Y' x '1cm-square-price' ?? is there any known way with any contribs you know of ? i'm just thinking of the long term and my client having to enter all these prices for each product. I'm also looking for this. Is this available for osCommerce? 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.