This project is for experienced osCommerce programmers only, cut and paste bids will be ignored.
The products I sell are Vinyl Cut Decals. I am using a modified version of osCommerce MS2.
What I need is a automated system that will dynamically display (Without page refreshing) and update the Price, Size and Discounts on the Product Info page from the Options that the customers has selected. These Options will be Size, Quantity and Discounts.
This will be automatically inserted to every Product Info page on a per category basis. As the majority of our products are vinyl cut decals and I will eventually have around 5000 - 7000 designs, I need a automated system that will allow me to easily add new designs without working out the sizes and prices for each product. The only thing I want to do manually is add the colour choices, which I can currently can copy for one product to an entire category. I would eventually like to change this system as well, but this will be another project.
The size will be calculated and dynamically displayed using one of the following options that would work best:
a) The pixel size of the image, for example, if the pixel size of an image is 200W x 100H then the size would be based on this and the price would be displayed for a particular size.
b) I can supply the Height and Width as a percentage of each design. For example The width is 20% of the Height.
This would display sizes from a minimum that I specify for each design to a maximum that would fit into an overall maximum size that I can make (The overall maximum I can make is 250cm x 56cm). I would like to use EasyPopulate to specify the minimum size for each design as some designs are harder to make smaller than others.
The customer can select between the pre determined sizes and custom size by entering the Width into a input box, which would display the correct Height and Price.
The customer would be able to switch between Centimeters and Inches
If the design is over a certain size, then it will add a certain amount (example: Over 70cm + $10, Over 80cm + $20, etc)
Shipping weight: Once the size was over 34cm x 24cm, then the shipping weight would go up.
Discount for more than a quantity of 1 (example: 2=10% discount, 5=20% Discount, etc)
This would be displayed dynamically, for example if the customer selected a certain size, then the discounts will display in a table for pre-defined quantities.
It would display for example: Buy 2 -4 and Save $[url removed, login to view], Buy 5 - 9 and Save $[url removed, login to view] etc
Things to consider:
I do not want to use the osCommerce Options and attributes system for this if possible, as I currently have over 2500 products with over 40,000 rows of attributes in the products_attributes (Sizes and Colours) table, which considerably slows down the site as far as I can tell and I have many more designs to add.
I don't have a good understanding of PHP and MySQL, so my guess is that these parameters would be inserted directly into the Customers Basket table and then into the Customers Orders table on checkout.
I need to offer colours, so I can use the standard osCommerce Options system.
I have a formula in Excel that will work out the price, for example, when a certain size is selected, it will calculate the Width or Height based on the Product Number and return a price based on the square area of the selected size, this will be the basis of the calculations.
I need the ability to edit the prices and discount specifications, I don't care if I have to do this in the database or code.
I can supply my current source code to install on your server or set up a test site on the server I am using.
We use the currency feature that is built onto osCommerce, so prices must correspond with the currency selected.