In Progress

SQL Data from old site to new site.

I am moving domains and need someone to help with uploading product data, in particular accurate stock levels to the new database.

I will provide the winning bidder with the Excel files of the old database.

The new database uses the pre-defined structure of the PrestaShop eCommerce package, where the product data is split into various tables...

I will upload all the product data myself, as most of them have already been done, what is important about the products and something that is very important is uploading all the correct stock attributes for the products so they don't need to be done one by one. Again, all the products will be already on the site, the only thing that is missing are the accurate stock levels, which I have problems doing myself as there are various attributes that define the stock levels. Product stock consists of how many total items we have available in different sizes (e.g. Product XYZ is available in Size 8, Size 10 and Size 12, where each size has it's own stock level which the customer can choose before adding it to the cart).

I do not require someone to upload the data for me, I require someone to use the data provided and create appropriate CSV files for the new database as well as the SQL query needed for me to upload the data via PHPMyAdmin. Or just to hand over the CSV file which is structured to match PrestaShop's database structure where I just Import the CSV. I have been successful in uploading customers and products on my own, but my limits are inserting the stock levels.

This task is not very hard for someone with a moderate amount of SQL experience. If interested, please let me know in your message that you understand the table structure of PrestaShop and that you can have this project done within 48 hours of receiving the data from the old website in Excel/CSV format and will deliver to me appropriate CSV files for the new site as well as the SQL query needed to insert this data in PHPMyAdmin so I get an understanding of what was done for future references.

Please READ what needs to be done, I posted another project recently and got tons of bids that seemed like no one read before bidding and the offers were way too high for such an easy project. I managed to actually finish the tasks myself in 36 hours and I am by far no programmer, yet others offered to do it in 7 days or more with the lowest bid being $500.

I would like to have this done before February 1st. Please include in your message what I mentioned above.

Skills: Excel, MySQL, Prestashop, SQL

See more: your message from, which site do i create my own site, where do i get a programmer, what is package in sql, what is data structure in c, what is data structure, what is data in data structure, what is a data structure in c, what is a data structure, what i need to create site, what do you need to do a programmer, what data structure, what are data structure, uses of data structure, use of data structure, to do site, tables in data structure, table data structure, sql database programmer, programmer sql, problems with match, prestashop problems, old programmer, old database, new data structure

About the Employer:
( 4 reviews ) Burleigh BC, Australia

Project ID: #597095

Awarded to:

mirod

please, check PMB

$100 USD in 1 day
(8 Reviews)
4.1

15 freelancers are bidding on average $119 for this job

anonymou5

Hi. I have a lot of experience working with databases, especially writing queries. And yes, I did actually read your description. I do not have experience working with PrestaShop's database schema specifically. But it More

$125 USD in 2 days
(4 Reviews)
4.0
borayeris

Please check your inbox.

$150 USD in 2 days
(3 Reviews)
3.5
asaikiran1979

Hi, Ready here....!

$199 USD in 2 days
(7 Reviews)
2.2
makistudios

Ready to start now.

$50 USD in 0 days
(0 Reviews)
0.0
Mirunalini

I have already worked on same kind of project

$150 USD in 2 days
(0 Reviews)
0.0
ccbanditi

Have just completed similar work. Lets do this right away.

$45 USD in 0 days
(0 Reviews)
0.0
joomlawork1

Hey, i am ready to work you right now. looking forward from you soon. Please see PMB Thanks

$30 USD in 0 days
(0 Reviews)
0.0
nyrten

Hi, i can do you job as required withing the 48 hours timefrime. Im an SQL Administrator, and have been working in SQL Server for over 3 years. In my previos job as SQL Data Migration Specialist i did just what you req More

$100 USD in 2 days
(0 Reviews)
0.0
DISolutions

Please check your inbox for my Proposal

$100 USD in 2 days
(0 Reviews)
0.0
imedve

Hi, I can help you to create appropriate CSV. Regards, imedve

$40 USD in 2 days
(0 Reviews)
0.0
Marindoti

I've read and understand what you want, I can do it and deliver between [url removed, login to view]

$100 USD in 2 days
(0 Reviews)
0.0
neelambhatt

I can complete this work by 31st January 2010. My bid is $200. Will like to have a short conf call to understand the requirements.

$200 USD in 5 days
(0 Reviews)
0.0
pkosanovic

Dear, I have lot of experience with data transformation between different database system and especially with systems based on "dictionary" based system like PrestaShop. I can prepare csv files for import in new data More

$200 USD in 1 day
(0 Reviews)
0.0
gouse1984

Working in the Research and development in IT sector since 3 [url removed, login to view] several .Net Application related to database, Have already dumped the tables data to .CSV File and also imported back in another database in More

$200 USD in 3 days
(0 Reviews)
0.0