--
OC Version: 2.3.0.2
--
I'm trying to make a new table to put in other info for products.
here's the database structure:
Code: Select all
CREATE TABLE `oceo_product_custom` (
`product_id` int(11) NOT NULL,
`article_nr` int(255) NOT NULL,
`description` varchar(255) NOT NULL,
`inner` varchar(255) NOT NULL,
`master` varchar(255) NOT NULL,
`location1` varchar(255) NOT NULL,
`aantal1` varchar(255) NOT NULL,
`location2` varchar(255) NOT NULL,
`aantal2` varchar(255) NOT NULL,
`location3` varchar(255) NOT NULL,
`aantal3` varchar(255) NOT NULL,
`location4` varchar(255) NOT NULL,
`aantal4` varchar(255) NOT NULL,
`total_quantity` int(255) NOT NULL,
`price` int(255) NOT NULL,
`fob_price` int(255) NOT NULL,
`ean` int(255) NOT NULL,
`grp_code` varchar(255) NOT NULL,
`category` varchar(255) NOT NULL,
`sub_category` varchar(255) NOT NULL,
`seasons` varchar(255) NOT NULL,
`color` varchar(255) NOT NULL,
`finish` varchar(255) NOT NULL,
`unit` varchar(255) NOT NULL,
`net_wt_gram` varchar(255) NOT NULL,
`buy_price` int(255) NOT NULL,
`min_qty` int(255) NOT NULL,
`itm_brdth` int(255) NOT NULL,
`itm_height` int(255) NOT NULL,
`cbms` int(255) NOT NULL,
`smallest_size` int(255) NOT NULL,
`pict_path` varchar(255) NOT NULL,
`size_unit` varchar(255) NOT NULL,
`currency` varchar(255) NOT NULL,
`comments` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Indexen voor geëxporteerde tabellen
--
--
-- Indexen voor tabel `oceo_product_custom`
--
ALTER TABLE `oceo_product_custom`
ADD PRIMARY KEY (`product_id`);
COMMIT;
Now, I want to be able to show every column in the product info field, on the category.tpl, product.tpl and featured products.
I need to know where OC gets the product data, change the query so it adds these values and add them to the language file.
If this is done, I can simply use the following code:
Code: Select all
<?php echo $location1
Does anyone know how I can achieve this?
If you need any more info, don't hesitate to ask me.
Kind Regards