Duplicate Products Manufacturer

[lukeengland12]

How Easy is it to duplicate products manufacturer as i want to add out supplier details to each product ? and keep Products Manufacturer if someone can tell me what files need modifying i will give this a crack.

Luke

[lat9]

The products_manufacturer is a database field associated with the products table. Try searching these forums (or Google) for

zen cart add product fields

[lukeengland12]

The products_manufacturer is a database field associated with the products table. Try searching these forums (or Google) for

zen cart add product fields

thank you for your reply

i have manged to duplicate both manufacturer database tables n also duplicate the manufacturers.php now called suppliers.php which works apart frome i now get this error

1146 Table 'f***p_s***ie.TABLE_SUPPLIERS' doesn't exist
in:
[select count(*) as total from TABLE_SUPPLIERS]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

[lukeengland12]

IF I CHANGED line 177 back to

<?php
$manufacturers_query_raw = "select manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified from " . TABLE_MANUFACTURERS . " order by manufacturers_name";

from this

<?php
$suppliers_query_raw = "select suppliers_id, suppliers_name, suppliers_image, date_added, last_modified from " . TABLE_SUPPLIER . " order by suppliers_name";

it connect to the manufacturers table wen i change it back to supplier it dosnt work am i missing a edit somewhere

[rstevenson]

Did you actually add a new table to the database?

Rob

[lukeengland12]

a new table has being add with the name of fmcsuppliers

[rstevenson]

Oaky. I thought I'd better ask, as it's sometimes the trees that get in the way of the forest.

Rob

[lukeengland12]

Oaky. I thought I'd better ask, as it's sometimes the trees that get in the way of the forest.

Rob

Cheers is there a file that lists database tables ?

[rstevenson]

When I want to see such things, I just go to phpMyAdmin (or whatever such tool your server people offer in their control panel).

[lukeengland12]

When I want to see such things, I just go to phpMyAdmin (or whatever such tool your server people offer in their control panel).

thank you for your reply

i found the php file i was after which was database_tables.php

ill hopefully in the next few weeks package this up n realise it as and add on