Em Andamento

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.

Habilidades: Excel, MySQL, Prestashop, SQL

Ver mais: package sql, need create site, uses data structure, use data structure, tables data structure, table data structure, sql database programmer, programmer sql, problems match, prestashop problems, old programmer, old database, new data structure, need sql help, need someone excel project, need data structure programmer, need data structure, sql create database, match problems, get products ecommerce, high match, get help programmer, ecommerce website 500, define structure, define data structure

Acerca do Empregador:
( 4 comentários ) Burleigh BC, Australia

ID do Projeto: #597095

Premiar a:

mirod

please, check PMB

$100 USD em 1 dia
(8 Avaliações)
4.1

15 freelancers estão ofertando em média $119 para este trabalho

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 Mais

$125 USD in 2 dias
(4 Comentários)
4.0
borayeris

Please check your inbox.

$150 USD in 2 dias
(3 Comentários)
3.5
asaikiran1979

Hi, Ready here....!

$199 USD in 2 dias
(7 Comentários)
2.2
makistudios

Ready to start now.

$50 USD in 0 dias
(0 Comentários)
0.0
Mirunalini

I have already worked on same kind of project

$150 USD in 2 dias
(0 Comentários)
0.0
ccbanditi

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

$45 USD in 0 dias
(0 Comentários)
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 dias
(0 Comentários)
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 Mais

$100 USD in 2 dias
(0 Comentários)
0.0
DISolutions

Please check your inbox for my Proposal

$100 USD in 2 dias
(0 Comentários)
0.0
imedve

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

$40 USD in 2 dias
(0 Comentários)
0.0
Marindoti

I've read and understand what you want, I can do it and deliver between 48hrs.thanks

$100 USD in 2 dias
(0 Comentários)
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 dias
(0 Comentários)
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 Mais

$200 USD em 1 dia
(0 Comentários)
0.0
gouse1984

Working in the Research and development in IT sector since 3 years.Developed several .Net Application related to database, Have already dumped the tables data to .CSV File and also imported back in another database in Mais

$200 USD in 3 dias
(0 Comentários)
0.0