Hello,
Here is the deal, enclosed you'll find my tab delimited file. Also at this link you can download Prestashop's cart.
I need a script that will:
1/ pull all data from the tab delimited file
2/ compare it to the database (based on product number not id)
3/ if the product is there then overwrite all the details to make sure they're synced
4/ any products that are in the database and not in the file will be removed
5/ if the product is not in the database then you need to add it and match existing categories subcategories or create categories and attributes...
You need to create or match any categories by name and add attributes. Prestashop has a limited import tool you can use as an example but I want mine to be somewhat more advanced.
Please let me know how soon you can have it done and what's your price.
Thanks,
Andrea
Edit: To answer a few of your questions the database is MySQL and the script would preferably be PHP. Please find enclosed the database structure.
## Deliverables
Please see sample feed and database enclosed.