Project Detail

Description

This job is for someone who knows osCommerce very well. Version used: osCommerce 2.2-MS2

I need to create or modify quick update script.
This one i already installed http://addons.oscommerce.com/info/3798 But i have price breaks too and i want to update all groups and price breaks at the same time. So i want all the features of 3798 plus to add add all below:

I need to add there options for the Featured Products, Minimum per order, Maximum per order that i have already installed.

Plus i need to make it work for price breaks too and i also would like to have an option to see all the groups on one page. Also i want to add there landing cost and to update the prices by percentage automatically. A sample of what i mean is made in the excel document. Everything is explained in the
excel document attached. Please read the notes to the first product in retail group. I hope i made it clear enough so you know what i man. If not than just let me know.

Here some more questions you might ask:

Do you have a featured products module on your site? if so where is it?
Yes. In Catalog/Categories/Products and in product edit


What groups you want to see at once? The customer groups? If so what else
you need to see alongside with the customer groups?
Yes, i want to see all the customers groups on one page, because i want to be able to update all the prices in all customers groups at the same time. The same as the excel document, I just enter the "Landing cost" and all the other prices in all customers groups will be automatically updated according to the percentage entered. Actually there already is that kind of option called "commercial margin"

(+/-) Value or rate : Modify by commercial margin, if you check this box, your products will be stroked at the rates given. To stroke to 25%, means that the price is marked up of 33%.

But i want to be able to update all the groups at the same time. In the excel document you can see how it could look.

I also want to see there "Quantity Blocks", "Qty Price break level" "Minimum order", "Maximum order".

The other thing for the quick update is to add the price breaks next to the price field for each row isn't it?
Yes, and to be able to update all the groups at the same time.

Simply put, I want to be able to update automatically all the customers groups an price brakes at the same time using the "Landing Cost (My cost)" and adding to this cost commercial margin by percentage.

Like in the excel document you only enter the price in the red box ("Landing Cost") and all other prices are automatically updated. This would save me a lot of time(Days of work) I have bad supplier. He changes prices every time the shipment arrives.

If you want me to make an image document of how it could look i can do it.


Thank you very much

I am looking for a coder i can count on also for other projects in the near future. So if i am satisfied with this job you will get more. All other jobs will be mostly just integrations of osCommerce contributions.


Additional information submitted:

10/27/2009 at 12:34 EDT:
I am not interested in bids over 200

Additional files submitted:
quantity_updates.xls