Get a Freelance Job

Greetings.

I need some work done on my active Oscommerce Webshop.

The shop is an older build (Fully secured) with _many_ installations and patches.

Thus an absolute expertise and knowledge in working with Oscommerce is required.

Work description:

*Speed optimization.

*Add a duplicate Flat shipping Module – Very Easy

*Small fixes and updates to installed Header Tags SEO module – High Priority.

*Add a second “model” field to select products (Must be hidable on the rest).

*Script to duplicate and multiply certain products with some new additions.
Possibly using the build in products_attributes however done in bulk with several thousand products.

*Field showing other active orders from that customer in orders.php – Very easy

*Resizing and rearranging of some boxes in orders.php

*Link to each bought product (to the catalogue) on click in orders.php.

*An Empty Basket button in the shopping basket.

*Adding 1 or 2 new Manufacturers drop down boxes on the front page and installing a mod for me to control in which box categories goes.

*Adding a new price field, must be selectable, This field will show the SRP – crossed over (as with specials) with our price showing instead. In theory this will work exactly as the specials.php except for the products not showing up in specials.php unless a price has been set in the specials field.

*Improving Reviews.php so reviews of the same product shows up on one screen – Low priority can be skipped of troublesome.

*Improvements to the Easy Populate script allowing me to see and edit specials prices.

>> More to come so keep checking the project <<

Additional details:
My shop is running version: osCommerce 2.2-MS2

Many of these modules are made for newer versions so some modification of the modules are to be expected,

Also, the shop is heavily modified with other addons, these all need to coexist with this addon.

Be fluent in English

Michael Keller.

I need a site that have the functionality to advertise daily specials on. Preferably Joomla otherwise other php scripts can be used also

Basically all the functionality that groupon have except we will only advertise specials on the site, there will be no buy options
K2 for joomla is a perfect way to go for the content but need the following functionality aswell.

Automatically publish listings (specials) for the specific day Monday publish Mondays specials, Tuesday publish Tuesdays listings..
Listings will be categorized by day, province, city
Listings will be image and text
User registration that will require province, city information
When user logs on he will get the specials for the day for his area (and he can go and view other days and areas)
Specials will be mailed to registered users daily with the specials specials of the day automatically

The look & feel will be modern like groupon

I need a site that have the functionality to advertise daily specials on. Preferably Joomla otherwise other php scripts can be used also

Basically all the functionality that groupon have except we will only advertise specials on the site, there will be no buy options
K2 for joomla is a perfect way to go for the content but need the following functionality aswell.

Automatically publish listings (specials) for the specific day Monday publish Mondays specials, Tuesday publish Tuesdays listings..
Listings will be categorized by day, province, city
Listings will be image and text
User registration that will require province, city information
When user logs on he will get the specials for the day for his area (and he can go and view other days and areas)
Specials will be mailed to registered users daily with the specials specials of the day automatically

The look & feel will be modern like groupon

Easy Populate with Special Project Requirements
Easy Populate 2.76-MS2

Requirement
Our existing Easy Populate 2.76 implementation must be modified to add support for Specials (products being sold at a discounted price)
The following two columns must be added to all existing Easy Populate output files:
 v_products_specials_price
o Any number greater than zero and less than the current price of the product
 v_products_specials_expiry
o Any future date in the format of mm/dd/yyyy (ie. 1/31/2011)

Adding, removing and updating Specials must behave in the following ways:
Adding a Special price

1) Review of the design of the website to give it a bit more appeal, including background, menus and banner

2) add ability to add promotions and specials to the website

Website generates too many slow MySQL queries. Here are some of them:

Executed 2 min ago for 15 sec on Database –> cardboar_db1.
select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.products_id where p.products_status = ’1′ and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = ’1′ and p2c.categories_id = ’1034′ order by pd.products_name limit 0, 15
Executed 2 min ago for 13 sec on Database –> cardboar_db1.
select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.products_id where p.products_status = ’1′ and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = ’1′ and p2c.categories_id = ’119′ order by pd.products_name limit 0, 15
Executed 2 min ago for 14 sec on Database –> cardboar_db1.
select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.products_id where p.products_status = ’1′ and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = ’1′ and p2c.categories_id = ’1222′ order by pd.products_name limit 0, 15
Executed 2 min ago for 11 sec on Database –> cardboar_db1.
select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.products_id where p.products_status = ’1′ and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = ’1′ and p2c.categories_id = ’1236′ order by pd.products_name limit 0, 15
Executed 1 min ago for 12 sec on Database –> cardboar_db1.
select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.products_id where p.products_status = ’1′ and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = ’1′ and p2c.categories_id = ’1116′ order by pd.products_name limit 0, 15
Executed 1 min ago for 12 sec on Database –> cardboar_db1.
select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.products_id where p.products_status = ’1′ and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = ’1′ and p2c.categories_id = ’1236′ order by pd.products_name limit 0, 15
Executed 1 min ago for 11 sec on Database –> cardboar_db1.
select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.products_id where p.products_status = ’1′ and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = ’1′ and p2c.categories_id = ’1940′ order by pd.products_name limit 0, 15
Executed 0 min ago for 11 sec on Database –> cardboar_db1.
select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.products_id where p.products_status = ’1′ and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = ’1′ and p2c.categories_id = ’132′ order by pd.products_name limit 0, 15

You need to optimize the MySQL database. You can check this tutorial for more details how to do this:

http://www.developer.com/db/article.php/3667831/Four-Ways-to-Optimize-Your-MySQL-Database.htm

Hi there have urgent osc minor job looking to get done in the next 10 minutes

will send url via pmb

products that have been placed on special in admin are appearing fine on the specials page

but in the category page, manufacturer page, product detail page they are appearing as full price

id like someone to fix this if the product is on special it displays its discounted price throughout the site

important this gets done quickly

have a range of other fixes also like this for the right experiencec coder at right price

thanks

I need errors fixed in my coding my host is saying. please bid if you have experience in field and can fix all errors im running into. maby a diagnostics can be ran so all errors are resolved in code….i do not want anyone that wants to get payed before errors are fixed. i had a programmer who said can do it and after he got in said everything looks fine. after errors resolved i will gladly pay… below is wut host said and under are 2 main error messages i am receiving on 2 different sites

This error is caused by the query you are running in the screenshot not completing in time when writing to the MySQL database which in turn is using too many resources which is then terminated before it continues to cause a high load on the server.

http://www.cheapjordans23.com/productsnew.php

1053 – Server shutdown in progress

select distinct p.products_id, p.products_date_available, p.products_date_added, p.products_image, p.products_tax_class_id, pd.products_description, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd, products_to_categories p2c, categories c where p.products_status = ’1′ and p.products_id = pd.products_id and pd.language_id = ’1′ order by p.products_date_added desc limit 40

[TEP STOP]

—————

http://www.jordansnyc.com/productsnew.php

1053 – Server shutdown in progress

select distinct p.products_id, p.products_date_available, p.products_date_added, p.products_image, p.products_tax_class_id, pd.products_description, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd, products_to_categories p2c, categories c where p.products_status = ’1′ and p.products_id = pd.products_id and pd.language_id = ’1′ order by p.products_date_added desc limit 9

[TEP STOP]

2013 – Lost connection to MySQL server during query

select count(*) as total from sessions where sesskey = ’5ce9e931df00fd34478995d50783f3cd’

[TEP STOP]

This will be a website where restaurant owners visit and sign up giving them access the admin to create their daily specials as coupons they will then press submit, the website will then collect all specials for member restaurants and send these coupons specials out to the list of customers cell phones daily, at set times of the day

My site lists local bars through a community builder setup with eventlist as my event calendar. I currently have weekly drink specials listed in CB fields for each day of the week (Mon, Tue, Wed, etc). What I would like is to incorporate these into Eventlist daily views; for example:

When someone clicks on September 18 to see the eventlist events on that day, I want them to see the different event categories with headings, such as “Live Music,” “Festivals,” etc. What I want to add is a “Drink Specials” category from my CB fields. I need the page to recognize that Sept 18 is a Friday, which will give a list of Friday drink specials.

We currently receive bookings through a .php form on our website, which are being sent to an e-mailaddress where they are being processed.

We are currently looking into automating this proces even further.

What we want:

Step 1: User fills in form on website just like now

Step 2: When submitting, the user is put into a database with their name, address, phonenumber and extra information about their kid.

Step 3: An inventory check is being done. When unsuccesful, an e-mail is sent to us telling there is a problem with the booking.
When succesful (there is inventory/space for this person), the user automatically receives a

I need a programmer to add a page to website that allows the user to

buy five traks and receieve five additional traks….the user should receive a box with all traks on my page and a box that he can check to select ten traks…he will then be directed to paypal, pay fifty dollars, and proceed to downlod his selected traks….

also the same box, except for ten traks…so he buys ten for a hundred and he receives ten, for a box that allows twenty dowloads

also need some database, mSQL, HELP

I need to make a directory of food restaurants online, by cities, categories, restaurants names, menu tags. Something like a mywebspace homepage instead of each user’s page, its each restaurants. That’s all it is. See info below and give me a quote. I want a clean, simple homepage, about us page, and the restaurant page. Search function has to work and an admin panel to upload menu/change menu/pic.
First go to www.restaurants.com and see what I mean, and then go to myspacepage or facebook or any social site, and instead of a user’s page, I want a restaurant page. Time estimating project is important. Payment is to be made when project is tested and completed free of bugs. I will give you password and URL to do the testing and work.

Please estimate time to complete, you must be available to communicate, if you are out of office or a few days or on vacation do not bid. I want something simple, professional, and affordable amount. Budget is $500.

Home page

There is a lot to this project, so I will be very detailed; I need the Enter Event process changed as well as some specialty calendar views. I don’t care what calendar component is used, JCal, Eventlist, ect – whatever you think will work best. Please contact me with any questions:

Event Details

1) Title = short text description with character limit (40 characters)
2) Category = Choose from Live Music, Special Events, Dining Specials, and Weekly Events
3) Date/Day:
a. If Category = Live Music, Special Event or Dining Special, use regular date format with clickable mini calendar Start and End date
b. If Category = Weekly Specials, choose Day of Week checkboxes (Mon, Tues, Wed, etc)