RE: Specify product quantity for an attribute

This message was sent from: Features
http://forums.oscommerce.com/viewtopic.php?p=178994#178994
----------------------------------------------------------------

Paul

Thanks for getting back - the only downside with using the existing product_info.php is that you don't get any stock control - it shows everything in the attribute array whether in or out of stock, whereas the radio button version checks stock before displaying.

[quote]Any idea on how to easily update multiple attributes product. i am thinking using the excel contributions. Any idea? How about the Quick Product Update contributions. Has anyone tried on multiple attributes?? 
[/quote]

Yes, I've just uploaded 900 products with 414 various attribute options and 14,000 existing users to a new OSC system on MySQL from a Cold Fusion based MSSQL system with different table layouts.

First off I used a piece of software called MySQL2Excel to dump the whole OSC database structure into an Excel Spreadsheet.  It creates a different worksheet for each table and names the head of each column as the database row name.

I then filled the spreadsheet with the data from the old database adding attributes, stock levels, descriptions etc etc.  I got the old database contents from Enterprise Manager.

Then I used a Excel2MySQL to reverse the process and create a full MySQL dump of all the tables/worksheets I had updated.  Edited to the .sql file to remove any "drop" statements leaving only "inserts" and pushed the sql file back to the database via phpmyadmin.

It worked perfectly.

The conversion software is only $25 and well worth it!!  You get it from http://www.convert-in.com

Let me know if you know how to do the stock control element in the old product_info.php

Cheers

Del