Jump to content
Sign in to follow this  

EasyPopulate 2.4, now with Froogle support!

Recommended Posts

brando, do you have properties set properly on the folders?

zzfritz, what mods did you do to ep, any? make sure your spreadsheet is actually saving in text mode and you have the field formatted as a straight text file.

highgrade get rid of the parenthese after your header.jpg, put it as a comma header.jpg') should be header.jpg',

John Oligario


Knowledge Base Contributions

Share this post

Link to post
Share on other sites

How does easy populate correctly handle products that were linked or even copied. In my case I have about 229 products, but when I look through the list from that of EP's I have about 290. It has created a double instance of every product that is linked. When I upload the file back to the database, is it going to try to create a new product (even though its only 1 product with several different linkings)???

Share this post

Link to post
Share on other sites

I am using the enhanced vendors contribution along with this, and I have been stuck on trying to get the tab delimited file that EP generates to contain the correct information from the vendors tables. I would like the last field in my EP txt file to have the corresponding vendor number (Ex 1, 2, or 3.) Currently this is where I am but I receiving a SQL syntax error after the WHERE clause...



$filelayout_sql = "SELECT

p.products_id as v_products_id,

p.products_model as v_products_model,

p.products_image as v_products_image,

p.products_bimage as v_products_bimage,

p.products_price as v_products_price,

p.products_weight as v_products_weight,

p.products_tax_class_id as v_tax_class_id,

p.products_quantity as v_products_quantity,

p.manufacturers_id as v_manufacturers_id,

subc.categories_id as v_categories_id,

p.products_status as v_status,

p.products_cost as v_products_cost,

ven.vendors_id as v_vendors_id





p.products_id = ptoc.products_id AND

ptoc.categories_id = subc.categories_id



".TABLE_VENDORS." as ven


p.products_id = ptov.products_id AND

ptov.vendors_id = ven.vendors_id


Share this post

Link to post
Share on other sites

I have Linda's Secv2. I managed to get it to stop the parse error after uncommenting the items instructed to, but now it won't pick up the fields or images in admin. This is what I am getting, but nothing for the bimage or subimages. Does anyone know what the problem could be?



















Share this post

Link to post
Share on other sites

I need to export some data from OSC to a logistics / purchasing system.

To avoid to double type all prices and information we definately need to do an automatic export from OSC on a regular basis.

Easypopulate seems like a very suitable contrib for that.

We will use EP to get products info into OSC since all vendors supply Excel price lists.

We need to modify EP so that it gives out theese fields as a tab, comma or semicolon separated list :


Description Field no. Length Comments


Identification 3 Always: XYZ


Type of information 1 Always: P - for Products

Version 2 Always: 15

#Data starts here :

Product no. 1 25 Text

Description/name 2 60 Text

Entity name 3 20 Text

Weight 4 10 Numeric

Volume 5 10 Numeric

Cost price 6 10 Numeric

Sales price 7 10 Numeric

VAT code 8 1 Numeric

Product group 9 4 Numeric

Sub Group 10 4 Numeric

Purchase price 11 4 Numeric

Supplier connection 12 25 Text

Stock 13 12 Numeric

Default warehouse 14 4 Numeric


I know some of those fields do not match the database structure of OSC, but those

fields could just be hardcoded so the output is set to a fixed value.


Summarized : Standard OSC import functionality.

Custom output with only some fields in the export. Export

format separated by tabs, commas or semicolons.


Can somebody give some hints on how to achieve this ?




Share this post

Link to post
Share on other sites

I've added two new fields to my products, and have altered EP to use those fields. when I download a TAB database from the site the fields are there, but when I fill that database with products and try to upload them using EP I get the following error


1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '", products_size= " ,manufacturers_id=NULL , products_status=1 

UPDATE xoops_shop_products SET products_price="1731" ,products_image="no_image.jpg", products_weight="", products_tax_class_id="1", products_date_available= "2004-07-30 13:22:04", products_date_added= CURRENT_TIMESTAMP, products_last_modified=CURRENT_TIMESTAMP , products_quantity="0", catalogue_page= 4", products_size= " ,manufacturers_id=NULL , products_status=1 WHERE (products_id = "44")



Anyone know what the problem might be? I've set the file to use only 300 products at a time and it fills in around 40 products before generating that error.

Share this post

Link to post
Share on other sites

Did you get this to work


I am also looking the get easy populate to run as a cronjob




Hey all..

This might not be the place to ask, but nevertheless I'll post it:

I wondered if I could use Easy Populate to be run with a cronjob? I got the normal version working (Great Tool! :D ), but now I'm trying ot run the script directly through the url. So I call it like:


Which returns the regular Easypopulate screen, without any actions been taken? Anyone got any idea on how to do this?

Share this post

Link to post
Share on other sites

Does this contribution also upload images for products, along with all the other product information?




product name

product number


product image

Share this post

Link to post
Share on other sites

I have a problem when trying to install EP 2.78


In the install notes it says to edit the file \admin\modules\filenames.php but I don't have an admin\modules folder and this is on a vanilla installation.


I have filenames.php in catalog\admin\includes and catalog\includes


Could someone please let me know which file it is I'm supposed to be updating?





Edited by c-sargent

Share this post

Link to post
Share on other sites

I have installed the EP 2.74, but I can't download TXT file when I click below link,,/admin/easypopulate.php?download=stream&dltype=full:


Download EP and Froogle Files


Download Complete tab-delimited .txt file to edit

Download Model/Price/Qty tab-delimited .txt file to edit

Download Model/Category tab-delimited .txt file to edit

Download Froogle tab-delimited .txt file

Download Model/Attributes tab-delimited .txt file


Create EP and Froogle Files in Temp Dir (/catalog/temp/)


Create Complete tab-delimited .txt file in temp dir

Create Model/Price/Qty tab-delimited .txt file in temp dir

Create Model/Category tab-delimited .txt file in temp dir

Create Froogle tab-delimited .txt file in temp dir

Create Model/Attributes tab-delimited .txt file in temp dir


and there is no any error information, what's problem? who can help me? tks

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this