Easy Populate Queries

[tsvenkat]

Hi all,

 

I have an OSC SHop with EP 2.74 installed. EP works fine and there is no dount on that.

 

But the problem I face is :

 

I have TWO EXTRA fields on the DB - Market Price, Delivery Time

 

and also my categories level (depth) goes upto 7 levels

 

eg..

 

office > essentials > paper > envelope > f4 > Color >

 

something like that.

 

the thing with EP is - the TAB LIMITED file that is downloaded only has the default format and it does not have the additional FIELDS that are in the DB and also category level is only THREE.

 

Please help me to sort out this.

 

Awaiting reply

 

Thanks

 

Venkat

[kempi]

and also my categories level (depth) goes upto 7 levels

 

eg..

 

office > essentials > paper > envelope > f4 > Color >

 

something like that.

 

the thing with EP is - the TAB LIMITED file that is downloaded only has the default format and it does not have the additional FIELDS that are in the DB and also category level is only THREE.

 

<{POST_SNAPBACK}>

 

 

in easypopulate.php

 

// **** Max Category Levels ****

// change this if you need more or fewer categories

global $max_categories;

$max_categories = 3; // 7 is default

[s97446]

Well ... the following are th einstructions I had for adding new fields. Check this steps ... maybe it'd be helpful to solve your problem ... B)

 

(Remember: products_artist is the new field)

 

Find the line, approx 991: $filelayout ?= array_merge($filelayout , array(
? ?	'v_tax_class_title' ?=> $iii++,
? ?	'v_status' ? ?=> $iii++,

Below it add:

'v_products_artist' ?=> $iii++,
---------------------------------------------------------------------------------------------

Find the line, approx 997: $filelayout_sql = "SELECT

Below it add:

p.products_artist as v_products_artist,

---------------------------------------------------------------------------------------------

Find the line, approx 1295: ?	$sql = "SELECT

Below it add:

p.products_artist as v_products_artist,

---------------------------------------------------------------------------------------------

Find the line, approx 1678: $query = "INSERT INTO " . TABLE_PRODUCTS . " (

Below it add:

products_artist,

---------------------------------------------------------------------------------------------

Find the line, approx 1678: $query .="'$v_products_model',

Find the line a couple lines down, '$v_products_quantity',

Below that line add: '$v_products_artist'

---------------------------------------------------------------------------------------------

Find the line, approx 1744: $query .= '", products_weight="'.$v_products_weight .
Find the line a couple lines down, , products_quantity="' . $v_products_quantity .

Below it add:

'", products_artist="' . $v_products_artist .

Edited March 10, 2005 by s97446