Find Jobs
Hire Freelancers

importing and managing mySQL database imports

$30-100 USD

Cancelled
Posted over 17 years ago

$30-100 USD

Paid on delivery
I have 2 CSV files containing products that I sell on my website. I need to be able to upload these files via PHPMyAdmin to 2 tables. I then need the ability to import this data into 3 different tables. I need to ensure that no duplicate products are inputted and no products that do not contain certain data such as product descriptions. I also need to check daily that I have no products listed on my site that are not listed in either of these csv files. if there are products listed that are not on either csv files I would like them removed from the databse. Anyone familiar with oscommerce will know that there is a table called porducts_to_categories which contains an autonumber generated when products are added. then a category ID is inputted which then links the product to a specific category. I see no easy way of doing this other than manually adding the relevant category numbers. I would like a query to allow me to do this in bulk. such as if product type is cable add 36. Then I will do category by category. Finally in some of my unique products IDs in my csv files have an * in the end of the text which is causing me issues. I need this removed along with the spaces. here is an example "ID1034 *" - wrong "ID1034" - correct I hope this meakes sense. I can provide more information when required. I am on a very tight budget so am unsure if anyone will be able to do this
Project ID: 111638

About the project

5 proposals
Remote project
Active 17 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of UNITED KINGDOM
Wimborne, United Kingdom
5.0
7
Payment method verified
Member since Nov 19, 2006

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.