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.