Devam Ediyor

OSCommerce - depreciating prices

I have MySQL ver [url removed, login to view] (Client/Server), and a heavily modified OSCommerce running on a linux-hosted server.

I MUST have examples of previous work on OSCommerce with details of what modifications you carried out.

All "Let's start this" messages will be ignored.

I think this boils down to a series of counters, and a separate database table... should hopefully be quite simple to do.

--

Aim:

We sometimes overstock on specific products (e.g. all ending in products_model 'R'), and we will need to lower prices incrementally to make customers buy the items.

There will be some 'normal' price they are sold at, and a minimum limit we will want to sell them for at the end of a reduction period.

I need a script which allows for a products_model regex to be matched, which finds all products with a products_quantity above a certain number. We will want to then be able to set the lowest prices that each of these products will reduce to.

Details:

On a daily basis, the price of all of these items will be reduced by say, [url removed, login to view] until it reaches the minimum prices each has been set.

There will be two conditions which will reset the price back to 'normal':

1) After the price reaches the minimum price set - the day after, it will revert back to the normal price.

2) If the quantity of items drops below a set minimum, then the iteration after, this will cause it to revert back to the normal price also.

Example:

productA is [url removed, login to view], there are 25 of these (products model: prAR)

productB is [url removed, login to view], there are 8 of these (pm: prBR)

productC is [url removed, login to view], there are 7 of these (pm: prCR)

I match all products with products_model pr%R.

I set minimum prices for: productA at [url removed, login to view], min quantity = 20, productB at [url removed, login to view] - min quantity at 2, productC at [url removed, login to view] - min quantity at 0

After 1 day, productA is [url removed, login to view], B is [url removed, login to view], C is 4.90.

Customer comes along and buys 6 of A

Another customer comes and buys 3 of A

On the second day, productA is put back up to normal price ([url removed, login to view]) because the quantity is now below the min. level. ProductB is now [url removed, login to view], productC is 4.80. No one buys anything.

On the third day, productB is [url removed, login to view], productC is set back to normal price ([url removed, login to view])

etc.

--

Admin:

I'll need a page where I can modify / add to the list of reduced prices based on products_model / quantity / price.

This will allow me to reset products to normal price, change current price / quantity of currently reducing items, add to the list of reducing items.

--

Extra:

I will want a way to include code on the home page which lists the names, quantities and current prices of all reducing products.

Beceriler: PHP

Daha fazlasını görün: you ver, ver 5, table customer, regex match list, regex is, regex examples, regex example, regex c, match list, match anything regex, buy pr, linux price list, ver , regex, php regex, modify previous script, lower third, counters, c regex, add pr, reduce page, sell overstock, current basis, match products, regex php

İşveren Hakkında:
( 33 değerlendirme ) London, United Kingdom

Proje NO: #73312

Seçilen:

hi2viv

we are interested in taking up the project, pls see pm for details of the projects in oscomm as per the project document request. thanks, viv

3 gün içinde 90$ USD
(69 Değerlendirme)
8.7

3 freelancer bu iş için ortalamada 97$ teklif veriyor

wildCat

see pmb, please

in 4 gün içinde100$ USD
(283 Değerlendirme)
8.3
rajeshrakyan

Solution in pmb

in 7 gün içinde100$ USD
(5 Değerlendirme)
3.8