Create Database Frm Feed Files
One of our suppliers has provided us with feed files (see attached). I require EXPERT PROGRAMMER to create a MS Access database containing the following fields:
1. ItemID (AutoNumber)
2. SupplierCode (product_id from the feed file)
3. OurPrice (standard_dealer_price_ex from feed file)
4. ShortDescription (from feed file)
5. LongDescription (from feed file)
6. ActiveProduct (see below)
7. Category (from feed file)
8. SubCategory (from feed file)
9. Brand (from feed file)
10. Model (from feed file)
11. ImageLink (from feed file)
12. BrochureLink (from feed file)
In addition I need a feed script created that will accept input as feed files (see attached).
All products in the DB will initially be marked as Inactive (ActiveProduct = False).
The script will cycle through the products in the feed file updating all prices and marking each product as active. If a product in the DB is not found in the feed file then it is left as Inactive.
If a new product is found in the feed file (not in the DB) then the script will create a new record in the DB for that file.
PLEASE NOTE: The script must be completed using Classic ASP (not .NET) and SQL connecting to an MS Access database (not SQL server or MySQL).
Essential Requirements:
1. Fully commented code is required.
2. Use of VB Functions wherever possible rather than inline code
3. Must be completed using Classic ASP (not .NET)
