[ic] adding field to products?
Gert van der Spoel
ic at 3edge.com
Fri Apr 28 02:11:44 EDT 2006
Music writes:
>
>> 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.
And make sure that all your products are in products.txt, because it will
take the content of that file to fill your table with .. So if you manually
had added stuff to your database and did not export it to products.txt you
lose that data.
CU,
Gert
More information about the interchange-users
mailing list