[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [ic] adding field to products?


At 10:00 PM 4/26/2006, you wrote:
Im using interchange-5.4 how do I add fields to the products using mysql?


Hello Tom,

There are various ways, but I like phpmyadmin
http://www.phpmyadmin.net/home_page/index.php


Not sure if this is the same for version 5.4 but in previous versions after adding the new column in MySQL:

Edit the associated table structure file and add the new column/field:
/catalogs/storename/dbconf/mysql/products.mysql

Then edit the /catalogs/storename/products/products.txt file - add a TAB at the end of the first row and then the new field name.

Then delete /catalogs/storename/products/products.sql

and restart interchange. Deleting the products.sql file tells interchange that there are new database parameters to read in for that particular table.

The new field should now appear in the items area of the admin UI.
Click the little icon at the end of the row and customise the new field.






_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users


Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.