Lukket

Modify osCommerce Contrib - Adjust prices

This modification automatically adjusts prices for products given changes in exchange rates. The idea is to automatically calculate the current estimated cost (based on vendor/manufacturer pricing and discounts) and add the appropriate margin to get a current (US Dollar in our case) price.

[Our osCommerce version uses the extra products contribution, and through that includes a field for the list (i.e., manufacturer suggested) price in the home currency.]

The basic calculation is as follows:

(home list price) // (field defined in Product

Extra Fields

times

(1 - discount) // (new field we need to add to

manufacturer table)

times

(exchange rate) // (from currencies table --

based on the currency

specified in "home currency")

The above gives an estimated cost. We then use the commercial margin to get an updated price. Here's an example of how the calculation should work, based on current information in our database:

Harry Potter e a Câmera Secreta (Harry Potter and the Chamber of Secrets)

Cover Price (in Brazilian Reais - BRL) $[url removed, login to view]

Discount from Brazilian Publisher (Rocco) 40%

Current Exchange Rate (BRL $[url removed, login to view])

Calculated Buy price ([url removed, login to view] x (1-40%) x [url removed, login to view]) $[url removed, login to view]

Margin for Brazilian Publisher (Rocco) 110%

Calculated Sell price ($[url removed, login to view] x (1+110%)) [url removed, login to view]

Round up to nearest quarter $[url removed, login to view]

Here's the details of what we need:

This could be done as a mod of the Quick Updates contribution but I'm open to getting a similar result in another way.

1. Add following fields to database:

* to manufacturers table: discount

* to manufacturers table: margin

2. Modify Quick Updates (or get this another way) to show/modify home list price (from Product Extra Fields), home currency (from Product Extra Fields), discount (new field from Manufacturers table), estimated cost (calculated), margin (new field from Manufacturers table), suggested price (auto-fill into editable price field, and show separately), and the difference (net and percent) between current sell price and calculated price. Ideally should be able to sort list based on most fields.

Please allow user to limit the titles displayed/included in reports to:

* all titles

* those of a particular manufacturer

* those in a particular category

With nearly 12,000 products, I need both a way to update prices universally and a way to update selected products. Limiting listings by manufacturer and category will be very helpful.

3. Modify Quick Updates admin fields to manage the above fields added to the report. Each of the above fields should be something user can choose to not display, display, or display and allow edit.

4. Modify manufacturer's admin page ([url removed, login to view]) to display and allow edits to new manufacturer's fields.

5. Modify product edit page ([url removed, login to view]) to show the discount, estimated cost, margin and suggested price -- suggested price should be like the current Products Price (Gross): field -- something that is recalculated when the user changes the home list price or home currency fields.

Ideally, I need to update the prices monthly -- and certainly whenever the exchange rate changes by more than a minimum percentage (say 5%). It is also possible that the Buy price could change because the manufacturer/publisher changes the discount given. Of course, changes to the list (i.e., manufacturer's suggested price) would also lead to a recalcuation. But while it is certainly possible to have changes in these items kick off an update, I'd prefer to have it be a manual process -- so that I can verify what happens.

Since I believe this can be done principally as a modification to the Quick Updates contribution, I've put a modest budget for the project. If you disagree about the amount of work that this will take, please tell me!! You can simply bid what you think, and post a note to me on the board telling me why this should take more money.

Færdigheder: PHP

Se mere: adjust price categories oscommerce, x rates, use case includes, work pricing, sell reports, sell report, report cover example, project report cover page, products manufacturers, process x, new product manufacturers, money table, manufacturers products, manufacturers listings, manufacturer prices, includes use case, get manufacturer, exchange currency rates table, example cover page, currency table rate, currency table list, currency rate table, currency rates table, cover page project report, commercial rate

Om arbejdsgiveren:
( 0 bedømmelser ) New York, United States

Projekt-ID: #63110

10 freelancere byder i gennemsnit $254 for dette job

websoftinfo

Our bid is for really very high quality work for your Modify osCommerce Contrib - Adjust prices that will be made to be upgradable in case you need some upgrades in future. We will always be available for upgrades. Our Mere

$300 USD in 10 dage
(66 bedømmelser)
6.4
gedelstein

This is not the real bid! Please read PM for details. Thanks.

$100 USD in 15 dage
(11 bedømmelser)
5.5
oscsupports

Hi, i did lot of works with QUick Update modifucation for QUick categories update, OSC Rss feeds,.. let me comlete the project quickly with my skills

$200 USD in 5 dage
(11 bedømmelser)
5.2
varshyltech

We at VarshylTech - an ITES company provide Internet Marketing services with primary focus on Website Design and Development, Graphic designs, Animations, 3D Max, Web Copywriting and Web marketing consulting to Clients Mere

$300 USD in 20 dage
(2 bedømmelser)
3.3
emBee

please check PMB.

$250 USD in 7 dage
(1 bedømmelse)
2.3
instance

GOOD QUALITY WORK WITH INTIME DELIVERY OF THE PRODUCT . 100% GUARANTEED OF HIGH QUALITY PROFESSIONAL WORK, AS WE ARE THE EXPERTISE IN JAVA/J2EE , JSP , EJB, ASP,PHP, STRUTS FRAME WORK RELATED PROJECTS. OUR COMPANY HAS Mere

$200 USD in 10 dage
(1 bedømmelse)
3.0
dani1333

In 2 weeks we can delivery your site working as you wish. We garantee our job, and only received any payment after our customers are satisfied. Looking forward to hear from you. Thanks.

$300 USD in 14 dage
(0 bedømmelser)
2.0
srishtiinfo

Hi, I am interested to work on this project. we believe in customer satisfaction. we are organisation with experts in various areas. we can simply provide u the solution on your requirements which will help u to freque Mere

$300 USD in 15 dage
(2 bedømmelser)
0.0
eopes

Settled in the heart of New Jersey City, EOPES has been providing low cost solutions to its growing number of clients since 2005. Our expertise is in web designing and software development services and our focus is on Mere

$285 USD in 7 dage
(0 bedømmelser)
3.5
spiders

Hello, Thank you for your description. We have reviewed and understood the description completely. We are confident that we are able to meet your entire requirement. Our designs are 100% original. We will surely ab Mere

$300 USD in 17 dage
(0 bedømmelser)
5.0