Forums / Customization from the Admin / Duplicate Products Manufacturer

Duplicate Products Manufacturer

Views: 1,312

Results 1 to 10 of 10
6 Jul 2012, 12:18 PM
#1
lukeengland12 avatar

lukeengland12

New Zenner

Join Date:
Dec 2008
Posts:
44
Plugin Contributions:
0

Duplicate Products Manufacturer

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

A 21 year old Messing around with e-commerce.

https://www.frome-model-centre.com

6 Jul 2012, 12:34 PM
#2
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,119
Plugin Contributions:
56

Re: Duplicate Products Manufacturer

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

zen cart add product fields

6 Jul 2012, 1:47 PM
#3
lukeengland12 avatar

lukeengland12

New Zenner

Join Date:
Dec 2008
Posts:
44
Plugin Contributions:
0

Re: Duplicate Products Manufacturer

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

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 'fp_sie.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.

A 21 year old Messing around with e-commerce.

https://www.frome-model-centre.com

6 Jul 2012, 2:27 PM
#4
lukeengland12 avatar

lukeengland12

New Zenner

Join Date:
Dec 2008
Posts:
44
Plugin Contributions:
0

Re: Duplicate Products Manufacturer

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

A 21 year old Messing around with e-commerce.

https://www.frome-model-centre.com

6 Jul 2012, 2:35 PM
#5
rstevenson avatar

rstevenson

Totally Zenned

Join Date:
Nov 2006
Location:
Dartmouth, NS Canada
Posts:
2,400
Plugin Contributions:
0

Re: Duplicate Products Manufacturer

Did you actually add a new table to the database?

Rob

Breakfast: the most important donut of the day.

6 Jul 2012, 2:37 PM
#6
lukeengland12 avatar

lukeengland12

New Zenner

Join Date:
Dec 2008
Posts:
44
Plugin Contributions:
0

Re: Duplicate Products Manufacturer

a new table has being add with the name of fmcsuppliers

A 21 year old Messing around with e-commerce.

https://www.frome-model-centre.com

6 Jul 2012, 2:39 PM
#7
rstevenson avatar

rstevenson

Totally Zenned

Join Date:
Nov 2006
Location:
Dartmouth, NS Canada
Posts:
2,400
Plugin Contributions:
0

Re: Duplicate Products Manufacturer

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

Rob

Breakfast: the most important donut of the day.

6 Jul 2012, 2:42 PM
#8
lukeengland12 avatar

lukeengland12

New Zenner

Join Date:
Dec 2008
Posts:
44
Plugin Contributions:
0

Re: Duplicate Products Manufacturer

rstevenson:

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

Rob

Cheers is there a file that lists database tables ?

A 21 year old Messing around with e-commerce.

https://www.frome-model-centre.com

6 Jul 2012, 2:53 PM
#9
rstevenson avatar

rstevenson

Totally Zenned

Join Date:
Nov 2006
Location:
Dartmouth, NS Canada
Posts:
2,400
Plugin Contributions:
0

Re: Duplicate Products Manufacturer

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

Breakfast: the most important donut of the day.

10 Jul 2012, 11:37 AM
#10
lukeengland12 avatar

lukeengland12

New Zenner

Join Date:
Dec 2008
Posts:
44
Plugin Contributions:
0

Re: Duplicate Products Manufacturer

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).

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

A 21 year old Messing around with e-commerce.

https://www.frome-model-centre.com