This simple project has to be relisted because the previous bid-winner does not have much experience in osCommerce. Pls only bid if you are very familiar with the database structure of osCommerce. You will need your own MS2.2 testing site for testing the script as I will not give you access to my server.
We sell our products via several marketplaces. We download the order list every day and insert these orders into osCommerce. These lists are *.csv files, the script will need to do the following:
1. Check if the order has already been inserted before by checking if the order number already exists , if yes the order will be omitted and echo a bold message. The order number (from Marketplace, different from the oID in osCommerce) was normally saved as "company" of the customer's default address.
2. Check if the customer was already in osCommerce or not by checking the email address , if yes the new order will be inserted under that cID (in osCommerce), and a new address entry (with the order number of Market place as "Company") so this order can not be re-inserted as per Rule #1
3. When insert the order, the ordered product will be mapped to the existing osCommerce products to get the product title, deduct the quantity, and increase the sold quantity accordingly
4. If there is several lines in the CSV file with the same order number, these lines should be inserted as one order.
5. Convert the currency to the default currency at the default exchange rate
6. Calculate VAT (tax) according to the geo_zone, some zones are not subject VAT, but the price in the CSV file is always the final price. If the country (of the shipping address) has only one zone or even no zone, then you can get the "geo_zone_id" from table `zones_to_geo_zones` , if the country has multiple zones, you will have to check table “zones” then table `zones_to_geo_zones`
Hello, I did many oscommerce project and very familiar with its data structure, i am very confident i can do a good job for you and you never need list it again ;) thank you!