Create script (powershell, python, etc.) to sync AuctionWizard2000 database and OpenCart Database -- 2
Paid on delivery
I need a skilled developer to create a set of scripts that will synchronize data between my AuctionWizard2000 database and my Opencart (cubecart, oscommerce) database.
My specific requirements are as follows:
1) Learn the structure of AW 2000 database (old Paradox format, but work fine via Windows ODBC) - download here [login to view URL] setup exe file, install it, run trial, restore inventory database from the attached file [login to view URL] (restore in AW interface) and use this data for the export-import. Paradox DB files are in \database folder.
2) Learn the structure of DB of opencart (or cubecart, or oscommerse) and ensure you understand it
3) map the data fields between source and target databases.
4) Make script which will update products on the server from source database on my desktop. Main tables for the import: inventory, invimages, invcategory. I need the data about the products in "inventory" and related tables imported to the online shop, including names, parsed descriptions, pictures, etc.
5) Script must parse item description in RTF format, split it to two part using tegs in the text, one for English description in the shop, another - for different language, delimiters --en-- and --ru--
6) Script must do initial upload first, and then be able to update target database - add new, change existing, delete removed items, update quantities. I will run script on my desktop with AW2000 installed periodically to update online store.
You can use OSCommerce or CubeCart as an alternative target system if OpenCart is too difficult. I have them all installed on the target server.
p.s. the budget is final, thank you for understanding.
Project ID: #36651743
About the project
20 freelancers are bidding on average $239 for this job
Hi, i have more than 4 years of experience working with powershell scripting and integration with SQL and APIs. Let me know if i can help you with the work
Sir me ap ki company me emandari se kam karu ga sir i am hard warking parsimonious sir please ? kam ho sake to muche dena sir hm hard working kr sakta hu