Lukket

OSCommerce MYSQL Data Import Routine

OSCommerce MYSQL Data Import Routine

We need a programmer to build the following import routine.

Application

Data import and manipulation routine form excel or csv, tld file for use with MySQL Oscommerce database for output to OSCommerce web. There are around 28,000 line items contained in the data file

Overview

The application is primarily to automate Products data population of the web site. As there is a large amount of Product and Pricing changes daily we simply don’t have time to manually deal with data. Ultimately we want to be able to upload a csv/excel/tld file provided to us by our wholesaler, manipulate the data, and insert the data into our online OSCommerce database. The data file will be uploaded every day. This could also be automated if possible

The application is to have PHP administration console or alternatively it could be a desktop application - if that is more suitable.

User Admin

1. Group the associated Product data into the relevant category and sub category structure

2. Provide a user interface so as the user can select which categories to include for use

3. Provide a user interface so as the user can apply pricing rules to each category and or sub category

4. Add a pre-determined image file name for all products (eg [url removed, login to view])

5. Add a pre-determined tax code to each Product item (eg GST)

6. Save the rules so as they can be applied to all subsequent imports

7. Update existing database with revised and or new Products/Categories etc

Pricing rules example (XX is the user input)

Select a category or sub category

Define a price rule and call it (xx)

Price Rule XX

Buy price is in the range from xx $ to xx<$ then add xx% to cost ex

Buy price is above xx$ then add xx% to cost ex

Or Use RRP

Ensure all products have a profit no less than xx$

Ensure prices do not exceed RRP. – (use RRP if exceeded)

Once these price rules are initially set the application will calculate prices according to the rules on all subsequent imports

Additionally we will require the programmer to alter the Category Listings Page to a line style listing as we are using a non standard template design.

We would also like to be able to link images for selected products using the standard admin OSCommerce console.

We hope we have provided enough information. I am happy to supply the original datafile and listen suggestions on an alternative system.

Programmer should be experienced with OSCommerce MYSQL PHP data base tables and should be able to provide a savvy solution. Payment on completion of project .

Færdigheder: Dataindførsel, Databehandling, PHP, Web Design

Se mere: import routine mysql, web template oscommerce, web site template buy, website buy programmer, web programmer cost, web design overview template, web design buy template, use data structure, template web listen online, tables data structure, standard website pricing, standard programmer, solution design group, set data structure, set data, programmer mysql, programmer cost, price structure template, price user interface, php programmer prices, online daily code, new data structure, need programmer cost, need data structure programmer, need data structure

Om arbejdsgiveren:
( 0 bedømmelser ) NSW, Australia

Projekt-ID: #61866

19 freelancere byder i gennemsnit $236 for dette job

hautu

I can do it for you. escrow is needed. regards.

$300 USD in 7 dage
(254 bedømmelser)
7.6
cstl

Chandusoft is a customer-specific service oriented company has got an Professional and creative team with 6 years experience in Web design and development. We have expertise and experience in ecommerce site development Mere

$240 USD in 10 dage
(23 bedømmelser)
7.0
jeevanarun

We are really interested to work with this project. We have extremely experieenced Developers in oscommerce ready to start this project immediately. We have understood your requirements. Please check our pm for more de Mere

$300 USD in 7 dage
(26 bedømmelser)
7.1
leoe

I have did it. Please see PMB

$150 USD på 1 dag
(105 bedømmelser)
6.6
gedelstein

Hi! I would like to see the CSV file to be imported. Thanks.

$300 USD in 7 dage
(11 bedømmelser)
5.5
montir

Please see my 2 review Past Project, Its OsCommerce data extraction too :). Ready to work.

$150 USD in 2 dage
(8 bedømmelser)
4.6
ocherk

Hi, I have made recently Windows Utility for uploading CSV files to CubeCart-based site. Regards.

$300 USD in 3 dage
(3 bedømmelser)
3.6
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 15 dage
(2 bedømmelser)
3.3
Cybecore

demo screenshots in pmb. could be done. thanks and best regards from germany

$300 USD in 30 dage
(5 bedømmelser)
3.1
GDInfotech

We are team of professional’s expertise in developing web based application using PHP/ASP/.NET and in web designing using Photoshop, Dreamweaver MX, Flash MX.After reading your project description, we are highly intere Mere

$300 USD in 10 dage
(2 bedømmelser)
4.0
espriy

PLEASE CHECK PM...

$100 USD in 0 dage
(3 bedømmelser)
2.4
WEBGLOW

WebGlow is a customer-specific service oriented company has got an Professional and creative team.We are the Professional Web Development Company having 3 years experience in Web design and development. We are solut Mere

$230 USD in 12 dage
(0 bedømmelser)
0.0
eopes

Riding the wave of the Internet explosion, EOPES was launched in 2005, nestled in the heart of New Jersey City. Since then we developed advanced level of projects for leading companies around the world. for your refere Mere

$295 USD in 6 dage
(0 bedømmelser)
3.5
anoob1983

We are intersted in doing this job for you. we would execute the job with 100% accuracy and within the stipulated time frame. Our bid for the project would be US Dollar 100

$100 USD in 5 dage
(0 bedømmelser)
0.0
riaz33bd

I have a lot of experience in this type of work . I guarantee you the work within the stipulated time and budget.Please feel free to contact me through PMB for any clarification required

$150 USD in 10 dage
(0 bedømmelser)
0.0
rajiv9

we offers website design and web application development services with international standards at an affordable price. Our strength in Web Designing, Professional Web Development and Ecommerce Web Site Development is Mere

$300 USD in 15 dage
(0 bedømmelser)
1.6
gtanmoy

Hi, greate job! we already did this type of project for our prestigious client Govt. of West Bengal. Hope we hear from u soon. Thanks

$100 USD in 5 dage
(0 bedømmelser)
0.0
nirmalask

300 is the lowest bid actually.

$300 USD in 30 dage
(0 bedømmelser)
0.0
software2003

Dear Sir I am very interested regarding your project. I have a 7-year experience in IT field. I am from India, the number one country in the software field. My typing speed is 80wpm If you accept my bid I wi Mere

$275 USD in 10 dage
(0 bedømmelser)
0.0