We currently have 1,000's of products that are required to be sold in multiple pack quantities and not single packs. We need the single unit price to be displayed to the customer and in google products and then when the customer adds the item to the cart a pop-up appears and displays that it must be purchased in multiple quantities.
If you go to this website and add the item to the cart you will see exactly what we want to achieve. http://www.createforless.com/Blue+Moon+Findings+Keyring+Lobster+Style+Silver+5+pc/[url removed, login to view]
Our website currently displays the total number of items that needs to be purchased. [url removed, login to view]
We populated a field in our database (prod_catagory5) with the minimum quantity that an item must be purchased in (1, 2, 3, 4, etc) and need the price that is displayed on the site and in google products to be divided by the number in that field . If the field says it is sold in a quantity of 1 then the price does not change, if there is a value of 3 in that field, then the price displayed is divided by 3 and when it is added to the cart the user is informed that it must be purchased in lots of 3. (3, 6, 9, 12 etc.)
The script that generates our google products feed would also need to be modified to show the single unit price.
We are looking for an expert in php, mysql. If you are available to speak with via phone or instant messenger that would be appreciated.