IMPORT DATA FROM EXEL IN OSCOMMERCE Hello, we need import and add this data in our database please look at file in attachment, here a explanation of every colon in the spreadsheet 01) COD ART ISP (colomn in exel file) This is the client's id for every product - We need add a field to the database named "cod_art_isp" in table product and there import the data - Reference for pictures must be updated with this value for every product example: product "25007" is pictures is "pictures [url removed, login to view]" 02) PICTURES (colomn in exel file) All the pictures for the products must stay in a folder "prodotti_per_ufficio" in the root of the website nota: we will update late all the pictures in this folder 03) DESCRIZIONE (colomn in exel file) This is the name of the product please import in the right field in the current database 04) MIN (colomn in exel file) This means number minimum of product for purchase Add this value to product database this field must be numeric Values are numbers 05) LISTINO1 (colomn in exel file) This is the PRICE (in euro) of the product IMPORT this data in the right field in the database for product Values are numbers The price are net (without tax) 06) LISTINO2 (colomn in exel file) This is the PRICE of the product if you buy a big amount of it ADD this field data in the right database product Values are numbers 07) SIAE This is a special tax (in euro) ADD this field data in the right databse product Values are numbers 08) MARCA This is the brand name for the product ADD this field data in the right database product and category list for brand We would find this product with a search for brand too. 09) CATEGORIA MERCEOLOGICA This is the category of the product IMPORT this data in the right field for product and for category table 10) TEST - please provide us a report weekly of the status of the job - test osCommerce with new imported data for full ready delivery of the project - advice in case of problem in importing data best regards
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
Os commerce, microsoft exel, mysql