Easy Populate & Products Attributes

[Jack_mcs]

Ok people...I'm starting to think I'm really out of my league here...or dumb  :rolleyes:

 

I'm having trouble uploading images via EP. If the image I'm trying to upload is located at mydomain.com/magazine/images/magazines/1234.jpg, what is the path I use for the EP .txt file?

 

Thank you all very much  :thumbsup:

 

Rob

<{POST_SNAPBACK}>

You should use magazines/1234.jpg,.

 

Jack

[MagazineMonkey]

Thank you Jack_mcs and Mibble :D It's finally working.

 

:thumbsup:

 

Rob

[XIME]

I don't quite know how to work with EP, I have a few questions:

When I save the modified file in my local pc, I can save it with any_name.txt? Where do I have to save this new file? This file is added to what I have already in my database?

It only modifies an existing product if I upload it with any changes, right?

 

I got this error when I was testing my EP skills...

 

 

Actualizaci?n en masa 2.71-MS2 es : espanol(5)

 

Warning: move_uploaded_file(/home/sl000265/public_html/etienda/temp/EP2005may24-1010.txt): failed to open stream: Permission denied in /home/sl000265/public_html/etienda/admin/easypopulate_functions.php on line 32

 

Warning: move_uploaded_file(): Unable to move '/tmp/php2d8Ao2' to '/home/sl000265/public_html/etienda/temp/EP2005may24-1010.txt' in /home/sl000265/public_html/etienda/admin/easypopulate_functions.php on line 32

 

 

Archivo subido al servidor.

Archivo temporal: /tmp/php2d8Ao2

Nombre de usuario: EP2005may24-1010.txt

Tama?o: 16255

 

Warning: file(/home/sl000265/public_html/etienda/temp/EP2005may24-1010.txt): failed to open stream: No such file or directory in /home/sl000265/public_html/etienda/admin/easypopulate.php on line 644

 

Warning: Invalid argument supplied for foreach() in /home/sl000265/public_html/etienda/admin/easypopulate.php on line 667

 

Hope you can help me!!!!

Thanks a lot!

XIME! :D

[celiaak]

most likely the document root setting in the admin/includes/configure.php needs to be set to $DOCUMENT_ROOT

 

I cannot import to he database, althought I get no error mesage.

Wich part sould I alter? cant see a Document root here.....

 

<?php

/*

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

 

// Define the webserver and path parameters

// * DIR_FS_* = Filesystem directories (local/physical)

// * DIR_WS_* = Webserver directories (virtual/URL)

define('HTTP_SERVER', 'http://serv01.clev12.com/~crossedc'); // eg, http://localhost - should not be empty for productive

 

servers

define('HTTPS_SERVER', 'https://64.246.15.53/~crossedc'); // eg, https://localhost - should not be empty for productive

 

servers

define('ENABLE_SSL', true); // secure webserver for checkout procedure?

define('HTTP_COOKIE_DOMAIN', 'https://serv01.clev12.com/~crossedc');

define('HTTPS_COOKIE_DOMAIN', 'https://64.246.15.53/~crossedc');

define('HTTP_COOKIE_PATH', '/');

define('HTTPS_COOKIE_PATH', '/');

define('DIR_WS_HTTP_CATALOG', '/');

define('DIR_WS_HTTPS_CATALOG', '/');

define('DIR_WS_IMAGES', 'images/');

define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');

define('DIR_WS_INCLUDES', 'includes/');

define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');

define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');

define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');

define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');

define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');

 

define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');

define('DIR_FS_CATALOG', '/home/crossedc/public_html/');

define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');

define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

 

// define our database connection

define('DB_SERVER', 'localhost'); // eg, localhost - should not be NULL for productive servers

define('DB_SERVER_USERNAME', 'crossedc_osc1');

define('DB_SERVER_PASSWORD', 'KDuuN2F1ONik');

define('DB_DATABASE', 'crossedc_osc1');

define('USE_PCONNECT', 'false'); // use persistent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

?>

 

 

When I upload I get :

Easy Populate 2.76-MS2 - Default Language : English(1)

 

File uploaded.

Temporary filename: /tmp/php7m1MTS

User filename: EP2005Jul12-0808.txt

Size: 20108

 

 

My store has not catalog, it is instaled in root.

Thank yo for helping.

[Sierrab]

Apologies for this double posting, I had ended up in the wrong thread after a search.

 

My Question

 

I have been unable to figure out how to get EP to read from and write to the "Product_Attributes_Download" table.

 

When I download, edit and reload, the db has a fit (A Big Thumbs up for Back Ups) and loses the download file names for the products. In attributes the files are missing after reload.

 

A pointer to the solution if I have missed it, or a suggested solution, if one hasn't been discussed before

 

Steve

[TeQTrent]

I have a quick question about Easy Populate 2.6. As far as option value's go,. like....size 2,. etc; Are they applied to each product you apply them to in the EP file,. or are the sizes or what-have-you simply put into the OSCom system, and you must manually add them to each product?

 

So far, none of my options are showing up. I can only assume:

 

1. You must manually add sizes, etc, to the products.

2. I have too MANY size options.

3. For some reason,. It doesn't work with STS template, which is another contribution i'm currently using.

 

Any idea's or solultions?

[razorsite]

Having an issue with model #, from what I gather & have tested, v_products_model doesn't like "/" "\" or "-", these characters can easily be changed with the replace function in excel, but one of my products is simply "72500SZ" & it won't update properly, here's the test file...

 

v_products_model v_products_quantity v_products_cost v_products_price EOREOR

72500SZ 93 40.2 48.2 EOREOR

 

If I change 72500SZ to 7250 it will work, leave it as is (correct model #) it doesn't?!

 

v_products_cost is a new field I added if you were wondering, works fine.

 

Is there a list of suitable characters you can use with v_products_model? I download a tab delimited list from my supplier, add the v_products_cost field, replace the forementioned non-working characters & most of the update works, just a few don't.

 

Please help, TIA.

Edited July 12, 2005 by razorsite

[kunal247]

Hi There,

Need some help. I have been using easy populate and all has been working just fine till today.

I have added more products as I am a new shop. Currently I have 3850 products in the shop.

 

When I try and Download or Create a Froogle feed the server times out getting a 500 error.

 

Can some one please help in resolving the situation.

I am sure there are people who have a bigger product portfolio than mine and are able to download a feed.

 

I have the attributes part turned off when downloading the feed.

 

Kunal

[celiaak]

The correct configure file:

 

<?php

/*

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

 

// Define the webserver and path parameters

// * DIR_FS_* = Filesystem directories (local/physical)

// * DIR_WS_* = Webserver directories (virtual/URL)

define('HTTP_SERVER', 'http://crossedcrafts.com'); // eg, http://localhost - should not be empty for productive servers

define('HTTP_CATALOG_SERVER', 'http://crossedcrafts.com');

define('HTTPS_CATALOG_SERVER', 'https://64.246.15.53/~crossedc/');

define('ENABLE_SSL_CATALOG', 'true'); // secure webserver for catalog module

define('DIR_FS_DOCUMENT_ROOT', '/home/crossedc/public_html/'); // where the pages are located on the server

define('DIR_WS_ADMIN', '/admin/'); // absolute path required

define('DIR_FS_ADMIN', '/home/crossedc/public_html/admin/'); // absolute pate required

define('DIR_WS_CATALOG', '/'); // absolute path required

define('DIR_FS_CATALOG', '/home/crossedc/public_html/'); // absolute path required

define('DIR_WS_IMAGES', 'images/');

define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');

define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');

define('DIR_WS_INCLUDES', 'includes/');

define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');

define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');

define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');

define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');

define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');

define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');

define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');

define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');

 

// define our database connection

define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'crossedc_osc1');

define('DB_SERVER_PASSWORD', 'KDuuN2F1ONik');

define('DB_DATABASE', 'crossedc_osc1');

define('USE_PCONNECT', 'false'); // use persisstent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

?>

 

 

It seems correct to use with easy populate, I dont know what to do more.....

Still cant upload new products....

 

C?lia

[Guest]

this is wrong:

define('DIR_FS_DOCUMENT_ROOT', '/home/crossedc/public_html/');

take a look at admin/tools/server info and search for document_root

this has been discussed many times in this support thread

set it to $DOCUMENT_ROOT and then you dont have to worry about it.

then set your temp path to what you have for your catalog setting along with temp/

[Guest]

this is a server time out issue

 

Hi There,

Need some help. I have been using easy populate and all has been working just fine till today.

I have added more products as I am a new shop. Currently I have 3850 products in the shop.

 

When I try and Download or Create a Froogle feed the server times out getting a 500 error.

 

Can some one please help in resolving the situation.

I am sure there are people who have a bigger product portfolio than mine and are able to download a feed.

 

I have the attributes part turned off when downloading the feed.

 

Kunal

<{POST_SNAPBACK}>

[Guest]

no apostrophes, the \ or / seem to be special characters, not that i know of do any manufacturers use those for their #s

 

Having an issue with model #, from what I gather & have tested, v_products_model doesn't like "/" "\" or "-", these characters can easily be changed with the replace function in excel, but one of my products is simply "72500SZ" & it won't update properly, here's the test file...

 

v_products_model v_products_quantity v_products_cost v_products_price EOREOR

72500SZ 93 40.2 48.2 EOREOR

 

If I change 72500SZ to 7250 it will work, leave it as is (correct model #) it doesn't?!

 

v_products_cost is a new field I added if you were wondering, works fine.

 

Is there a list of suitable characters you can use with v_products_model? I download a tab delimited list from my supplier, add the v_products_cost field, replace the forementioned non-working characters & most of the update works, just a few don't.

 

Please help, TIA.

<{POST_SNAPBACK}>

[celiaak]

I have seen it many times here but still dont understand where do I put the $DOCUMENT_ROOT.

Anyway, I downloaded a new file, edited it on notepad instead of excel and it worked fine.

When I iimport to excel, I have to choose separate by tabs and also by commas, if i dont, it wont separate text.

When I save it, I choose to save *.txt (tabs). That way it wont work.

 

I'm using excel professional 2003.

 

do you know of another editor i can use?

 

Thank you!

C?lia

 

this is wrong:

define('DIR_FS_DOCUMENT_ROOT', '/home/crossedc/public_html/');

take a look at admin/tools/server info and search for document_root

this has been discussed many times in this support thread

set it to $DOCUMENT_ROOT and then you dont have to worry about it.

then set your temp path to what you have for your catalog setting along with temp/

<{POST_SNAPBACK}>

[Guest]

openoffice, also quattropro12, (goes out over 18000 columns)

[razorsite]

no apostrophes, the \ or / seem to be special characters, not that i know of do any manufacturers use those for their #s

<{POST_SNAPBACK}>

 

Thanks, still didn't explain why my simple 7250 record didn't update. Now I figured out why, there was a duplicate in the database, so it was updating the dupe that doesn't show.

 

Is there a way to change EP to not add products, I want to only update exsisting products on the site, but not add. As of now I need to delete about 9500 product records from my database, after that I want to use EP again but worried this will happen again. The tab delimited file i'm working with has around 5000 products, of those my site lists about 500-700 of them, so...

 

Any help with the code? thanks.

Edited July 13, 2005 by razorsite

[Guest]

to update the products, just put the data you want updated into a spreadsheet and go from there. make sure no apostrophes in the category names

[razorsite]

Updating is fine, I want to NOT add new products from the spreadsheet, want to do a daily update & the fastest way is from my suppliers file, not one of my own :).

[Guest]

only way to not add new products is make sure the only products you are working with are the ones on the site and the data file.

kind of tough to not add products if they are in the sheet. you would have to do data checking to see if the model # is there, if it is then update, if it isnt, dont add.

[alark]

My easy populate module was installed by the original owner of my site. I don't seem to be able to download a txt file to see what order to put my new updated csv file in. Can someone please help me? I either need to fix the module or just have a list of what order to put the fields in. Any help would be greatly appreciated.

 

Thanks,

Stephen

[Guest]

what is the error you are getting when trying to download?

[kunal247]

this is a server time out issue

<{POST_SNAPBACK}>

Thanks Mibble.

I know it is a time out issue, is there a solution how to fix it?

It was working fine when I had 2,800 products but since adding the new products now I have 3,850 products and I am getting server time out.

 

How to fix this? I am sure there is a way as this cant be the upperlimit of having no. of products on a site. surely!!

 

Please help!!

Kunal

[Guest]

try editing your ep file to download by category, etc

[razorsite]

I've been looking around the easypopulate.php code & can't seem to figure out how to not add new products, what i'm looking to change is this...

 

if ($v_products_model != "") {

// products_model exists!

array_walk($items, 'print_el');

 

// First we check to see if this is a product in the current db.

$result = tep_db_query("SELECT products_id FROM ".TABLE_PRODUCTS." WHERE (products_model = '". $v_products_model . "')");

 

if (tep_db_num_rows($result) == 0) {

// insert into products

 

$sql = "SHOW TABLE STATUS LIKE '".TABLE_PRODUCTS."'";

$result = tep_db_query($sql);

$row = tep_db_fetch_array($result);

$max_product_id = $row['Auto_increment'];

if (!is_numeric($max_product_id) ){

$max_product_id=1;

}

$v_products_id = $max_product_id;

echo "<font color='green'> !New Product!</font><br>";

 

$query = "INSERT INTO ".TABLE_PRODUCTS." (

products_image,

products_model,

products_price,

products_cost,

products_status,

products_last_modified,

products_date_added,

products_date_available,

products_tax_class_id,

products_weight,

products_quantity,

manufacturers_id)

VALUES (

 

I want to change the INSERT INTO to UPDATE, tried commenting the lines, deleting them, changing to update from insert, still no go, gives me an error.

 

I really don't want to update manually every day, there must be a way to tell EP to NOT add new v_products_model, just update if the model exists.

 

Have a 5000 product listing from my supplier, out of those 5000 I carry 1000 of those products, is there another way of going about this? For it to work with EP now i'd need to manually delete 4000 of those records (or cut & paste 1000 of them), too much work! That's why i'd like to just use the 5000 list & have EP ignore the non-existing in my database 4000 records <_<.

 

If anyone knows how to do this please let me know, been playing with code for days now without much luck.

[razorsite]

AHA! Figured it out, it isn't pretty but it works...

 

All I did was create another PRODUCTS table in my SQL database & called it PRODUCTSD (or products delete), code points to it like this,

 

// products_model exists!

array_walk($items, 'print_el');

 

// First we check to see if this is a product in the current db.

$result = tep_db_query("SELECT products_id FROM ".TABLE_PRODUCTS." WHERE (products_model = '". $v_products_model . "')");

 

if (tep_db_num_rows($result) == 0) {

// insert into products

 

$sql = "SHOW TABLE STATUS LIKE '".TABLE_PRODUCTS."'";

$result = tep_db_query($sql);

$row = tep_db_fetch_array($result);

$max_product_id = $row['Auto_increment'];

if (!is_numeric($max_product_id) ){

$max_product_id=1;

}

$v_products_id = $max_product_id;

echo "<font color='green'> !New Product!</font><br>";

 

$query = "INSERT INTO ".PRODUCTSD." (

products_image,

products_model,

products_price,

products_cost,

products_status,

products_last_modified,

products_date_added,

products_date_available,

products_tax_class_id,

products_weight,

products_quantity,

manufacturers_id)

VALUES (

 

So, if there's a new product it inserts it into a unused table, if it's current it'll go into the proper TABLE.PRODUCTS :thumbsup:.

[kunal247]

try editing your ep file to download by category, etc

<{POST_SNAPBACK}>

 

Dear mibble,

Can you please guide me as to how to download by category - Please?

 

Kunal