Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Custom Easy Populate Download


Guest

Recommended Posts

Posted

Hi hope someone out there can give us some support or point me to the right thread, have spent hours trawling through the easy populate threads to find this.

 

 

I want to modify the custom download to include more fields thatn just the product id and End of line data, having looked at the easy populate file I am not sure what I am supposed to put where.

 

I have a list of the headers I need, some will be filled in as blanks, the others I have cross referenced with froogle and easpopulate complete downloads.

 

headers to be as

##

Your product ref

Short Description

Long Description

Product Variation 1

Product Variation 2

Product Variation 3

Product Variation 4

Review Title

Review Text

Manufacturer

Model

Classification

MainGraphicfilename

ThumbnailGraphicfilename

Additional Graphic 1 filename

Additional Graphic 2 filename

Gift Tag

Gift wrap price excl. VAT

KeyWords

Vat Code

Price

Special Price

Special Price Start Date

Special price End Date

Availability

Quantity in stock

Stock Control

Exportable

Shipping weight

UK Shipping charge

EU Shipping charge

ROW Shipping charge

Webshop category 1 ID No

Webshop category 2 ID No

Webshop category 3 ID No

Webshop category 4 ID No

Webshop category 5 ID No

Lead Time

Date Available

WAP Short Description

WAP Long Description

##

 

Cross referenced easy populate (v_blah_blah easy pop complete, category and image_link (image_url) from froogle easy pop download, all others are auto fill with same value)

##

v_products_model

v_products_name_1

v_products_description_1

blank for now

blank for now

blank for now

blank for now

blank for now

blank for now

v_manufacturers_name

blank for now

blank for now

image_link

blank for now

blank for now

blank for now

0

0

category

G

v_products_price

0

0

0

0

0

0

1

v_products_weight

blank for now

blank for now

blank for now

blank for now

blank for now

blank for now

blank for now

blank for now

blank for now

blank for now

blank for now

blank for now

##

 

If I can get this setup, then I can look at downloading the different attributes, and the extra prices involved if any, but one setp at a time, and having this download will save me time.

 

If you require more information please let me know by e-mail to [email protected]

 

Thanks

 

Wayne

Posted
I want to modify the custom download to include more fields thatn just the product id and End of line data,

 

Did you tick the option fields to get them on the file?

 

These are the standard fields you can have.

 

name

 

description

 

url

 

image

 

attributes

 

categories

 

manufacturer

price

 

quantity

 

weight

 

tax class

 

available

 

date added

 

status

 

Any others and you would need to amend easypopulate.php to get the data and output it.

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Posted

Hi,

 

Have not done anything with the custom download, just changed a few things in the froogle one to make it compatible with the new base and to stop me from having messing around so much. things can be improved but this isnt so important. there was nothing to select?

 

I need to create a download for edirectory, having gone through the easypopulate.php file, I have managed to create the drop down lists etc for edirectory.

 

So Now I can click on edirectory, but nothing will happen because I have not set anything in the easy populate to download for edirectory

 

I just need to know how to setup things up to download each record in my database with the correct headings in place for Edirectory, as shown in first post, already have a list of fields that would give me the right information its knowing how to code it up to download in the correct format.

 

Thanks

Posted

You could see how it does it for another file such as product extra fields and "dulicate" the code.

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Posted

Hi,

 

looking at code but it does not make much sense to me at the moment.

 

 

Whilst on the easypopulate subject.

 

I currently have a full category problem within my froogle download, the problem is I get Main cat > Sub cat in categories column, but then subsequent sub categories get put into the next column and move all the subsequent data on one per extra sub category:-

 

the code thats responsible as far as I can tell is:-

// for the categories, we need to keep looping until we find the root category


	// start with v_categories_id
	// Get the category description
	// set the appropriate variable name
	// if parent_id is not null, then follow it up.
	// we'll populate an aray first, then decide where it goes in the
	$thecategory_id = $row['v_categories_id'];
	$fullcategory = ''; // this will have the entire category stack for froogle
	for( $categorylevel=1; $categorylevel<$max_categories+1; $categorylevel++){
		if ($thecategory_id){
			$sql2 = "SELECT categories_name
				FROM ".TABLE_CATEGORIES_DESCRIPTION."
				WHERE	
					categories_id = " . $thecategory_id . " AND
					language_id = " . $epdlanguage_id;

			$result2 = tep_db_query($sql2);
			$row2 =  tep_db_fetch_array($result2);
			// only set it if we found something
			$temprow['v_categories_name_' . $categorylevel] = $row2['categories_name'];
			// now get the parent ID if there was one
			$sql3 = "SELECT parent_id
				FROM ".TABLE_CATEGORIES."
				WHERE
					categories_id = " . $thecategory_id;
			$result3 = tep_db_query($sql3);
			$row3 =  tep_db_fetch_array($result3);
			$theparent_id = $row3['parent_id'];
			if ($theparent_id != ''){
				// there was a parent ID, lets set thecategoryid to get the next level
				$thecategory_id = $theparent_id;
			} else {
				// we have found the top level category for this item,
				$thecategory_id = false;
			}
			//$fullcategory .= " > " . $row2['categories_name'];
			$fullcategory = $row2['categories_name'] . " > " . $fullcategory;
		} else {
			$temprow['v_categories_name_' . $categorylevel] = '';
		}
	}
	// now trim off the last ">" from the category stack
	$row['v_category_fullpath'] = substr($fullcategory,0,strlen($fullcategory)-3);

 

so need to work out how to get all the main and sub categories for each product to sit in the one colun so we get main cat >subcat1 > sub cat2 >subcat3 etc etc

 

can anyone advise?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...