Jump to content
VJ

Easy Populate & Products Attributes

Recommended Posts

Sorry Todd, it's been awhile since I looked into OSC code.

 

I'm not sure what the problem is with my shop using Easy Populate

 

When I had it at http://www.makepeace.org.au/shop/ - EP worked fine.

 

My test store at http://www.makepeace.org.au/shop_dev/ - still works fine.

 

Now that I've moved the live store to the root I can't upload my excel files to the shop (same file works fine in test store though)

 

I changed the temp directory in admin/easypopulate.php to what it should be ('/temp/')

 

But when I try and import the database Oscommerce is still looking for the temp files at /shop/temp/

 

How do I get it to see the new temp file?

 

Here is a screenshot of my EP screen:

 

Those bits should just say temp not shop/temp/

 

I'm not familiar with v2.75.

 

what does your temp directory setting show in your easypopulate.php ?

Edited by surfalot

Share this post


Link to post
Share on other sites
thans for your reply surfalot, although it still doesnt work :blink:

 

I realised that i actually have the structure 'public_html/' and then everything is in there. It says it is looking for 'home/discoun/public_html/' maybe this si why it is not working? is there a way to change this? i know nothing about programming, this is just something i spotted, what do you think?

 

check with your host for the complete path to your web docs. Then set it to what they tell you in your configure.php.

if that doesn't help set it to this in your admin/includes/configure.php:

  define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT);

beyond that, I need some versions to help further. EP vers? PHP vers? MySQL vers? PHP globals on/off ??

Share this post


Link to post
Share on other sites
what country are you in?

 

the problem is your excel is not using the comma for your CSV separator.

go to your windows control panel. open regional and language options. click on customize. find list separator.

this is what excel will use. you need to use that same character in your easypopulate.php.

 

find this:

if ($excel_safe_output == true) { $separator = ","; }

change the $separator = "," to reflect what your windows is expecting for the separator.

 

post 4939 for more info on this.

 

I am in the US.

 

Via control panel/language options/customize...The seperator was already set to ","....

 

easypopulate.php looks like this, as you can see I implemented the "fix" from the more info thread you recommended:

 

EP-problem2.gif

 

This problem only happens when I insert that html into the product description column.

 

Every time I save before upload I get:

 

EP-problem3.gif

 

Ideas?

 

-Dano

Share this post


Link to post
Share on other sites
I am in the US.

 

Via control panel/language options/customize...The seperator was already set to ","....

 

easypopulate.php looks like this, as you can see I implemented the "fix" from the more info thread you recommended:

 

This problem only happens when I insert that html into the product description column.

 

Ideas?

 

-Dano

 

if you are in the US, you don't need that fix and it would be better if you didn't use it.

please post or pm me a link to the export file. I would like to see the export with your html in it.

Share this post


Link to post
Share on other sites
I'm not familiar with v2.75.

 

what does your temp directory setting show in your easypopulate.php ?

 

$tempdir = "/temp/";

$tempdir2 = "/temp/";


For my contribution (to society) see my profile link.

--

my new charity store features: STSv4.5.2 and HTCv2.6.3 Bundle, Australian Post Shipping, Paymate, Category Trees Minimum Order Quantity, Enable/Disable Categories, Super Download Store, Paypal IPN, Free Dowloads, Anti-Robot Registration 2.6, Master Products, Lightbox for STS ... the rebuild continues...

Share this post


Link to post
Share on other sites
$tempdir = "/temp/";

$tempdir2 = "/temp/";

 

and admin/includes/config

 

// Define the webserver and path parameters

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

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

define('HTTP_SERVER', 'http://www.makepeace.org.au'); // eg, http://localhost - should not be empty for productive servers

define('HTTP_CATALOG_SERVER', 'http://www.makepeace.org.au');

define('HTTPS_CATALOG_SERVER', '');

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

define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT); // where the pages are located on the server

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

define('DIR_FS_ADMIN', '/xxxxxxxxxxpublic_html/admin/'); // absolute pate required

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

define('DIR_FS_CATALOG', '/xxxxxx/xxxxxxx/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/');


For my contribution (to society) see my profile link.

--

my new charity store features: STSv4.5.2 and HTCv2.6.3 Bundle, Australian Post Shipping, Paymate, Category Trees Minimum Order Quantity, Enable/Disable Categories, Super Download Store, Paypal IPN, Free Dowloads, Anti-Robot Registration 2.6, Master Products, Lightbox for STS ... the rebuild continues...

Share this post


Link to post
Share on other sites

further: this is my error:

 

Warning: move_uploaded_file(/xxxxx/xxxx/xxxxxx/shop/temp/october2005faces.txt.xls) [function.move-uploaded-file]: failed to open stream: No such file or directory in //xxxxx/xxxx/xxxxxx/admin/easypopulate_functions.php on line 32

 

Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to move '/tmp/phpqHhN4a' to '/xxxxx/xxxx/xxxxxx/shop/temp/october2005faces.txt.xls' in /xxxxx/xxxx/xxxxxx/admin/easypopulate_functions.php on line 32

 

File uploaded.

Temporary filename: /tmp/phpqHhN4a

User filename: october2005faces.txt.xls

Size: 90773

 

Warning: file(/xxxxx/xxxx/xxxxxx/shop/temp/october2005faces.txt.xls) [function.file]: failed to open stream: No such file or directory in /xxxxx/xxxx/xxxxxx/admin/easypopulate.php on line 656

 

Warning: Invalid argument supplied for foreach() in /xxxxx/xxxx/xxxxxx/admin/easypopulate.php on line 679


For my contribution (to society) see my profile link.

--

my new charity store features: STSv4.5.2 and HTCv2.6.3 Bundle, Australian Post Shipping, Paymate, Category Trees Minimum Order Quantity, Enable/Disable Categories, Super Download Store, Paypal IPN, Free Dowloads, Anti-Robot Registration 2.6, Master Products, Lightbox for STS ... the rebuild continues...

Share this post


Link to post
Share on other sites

Sorry to waste your time - looks like an issue with my server or my FTP program. Fixed now.


For my contribution (to society) see my profile link.

--

my new charity store features: STSv4.5.2 and HTCv2.6.3 Bundle, Australian Post Shipping, Paymate, Category Trees Minimum Order Quantity, Enable/Disable Categories, Super Download Store, Paypal IPN, Free Dowloads, Anti-Robot Registration 2.6, Master Products, Lightbox for STS ... the rebuild continues...

Share this post


Link to post
Share on other sites
I just found another issue:

 

When I try to "Upload and Import EP File", the screen refreshes, but I don't get anything. No error or success message. There is nothing in the database.

 

Per the manual, I tried downloading a complete EP file and without even opening it, I tried to upload. Same results.

 

It can't be a size issue, as there are only three products in the store right now.

 

Any ideas?

 

Hi,

 

I got the same problem with Easy Populate 2.76 MS2.

I switched from PHP 4 and MySQL 4 to PHP 5 and MySQL 5.

Under previous configuation RasyPopulate worked fine. Now I can not import anything.

 

I think it is related to PHP5.

 

Did anybody solved this problem ?

Share this post


Link to post
Share on other sites
Hi,

 

I got the same problem with Easy Populate 2.76 MS2.

I switched from PHP 4 and MySQL 4 to PHP 5 and MySQL 5.

Under previous configuation RasyPopulate worked fine. Now I can not import anything.

 

I think it is related to PHP5.

 

Did anybody solved this problem ?

more importantly is your PHP globals on/off?

Is the php error reporting turned on? (ask your host)

then look at this post about php 5. but that problem will still insert the first line, then quit.

post 5554 might have more info for you to look at.

Share this post


Link to post
Share on other sites

Hello!

I use EP for add new products in my store.

Now i need second manufacturer, i make it - work fine, but what need to add it in EP?

 

How i make (easypopulate.php)

        'v_instock',
        'v_tax_class_title',
        'v_manufacturers_name',
        'v_manufacturers_id',
//after it i add
		'v_manufacturers2_name',
        'v_manufacturers2_id',

                $row['v_froogle_color']                        = '';
                $row['v_froogle_size']                        = '';
                $row['v_froogle_quantitylevel']                = '';
                $row['v_froogle_manufacturer_id']        = '';
//after
	    $row['v_froogle_manufacturer2_id']        = '';

                // if the filelayout says we need a manufacturers name, get it
                if (isset($filelayout['v_manufacturers_name'])){
                        if ($row['v_manufacturers_id'] != ''){
                                $sql2 = "SELECT manufacturers_name
                                        FROM ".TABLE_MANUFACTURERS."
                                        WHERE
                                        manufacturers_id = " . $row['v_manufacturers_id']
                                        ;
                                $result2 = tep_db_query($sql2);
                                $row2 =  tep_db_fetch_array($result2);
                                $row['v_manufacturers_name'] = $row2['manufacturers_name'];
                        }
                }
//after
				                // if the filelayout says we need a manufacturers name, get it
                if (isset($filelayout['v_manufacturers2_name'])){
                        if ($row['v_manufacturers2_id'] != ''){
                                $sql2 = "SELECT manufacturers2_name
                                        FROM ".TABLE_MANUFACTURERS2."
                                        WHERE
                                        manufacturers2_id = " . $row['v_manufacturers2_id']
                                        ;
                                $result2 = tep_db_query($sql2);
                                $row2 =  tep_db_fetch_array($result2);
                                $row['v_manufacturers2_name'] = $row2['manufacturers2_name'];
                        }
                }

    $header_array['v_manufacturers_name'] = $iii++;
//after
    $header_array['v_manufacturers2_name'] = $iii++;

                        p.products_tax_class_id as v_tax_class_id,
                        p.products_quantity as v_products_quantity,
                        p.manufacturers_id as v_manufacturers_id,
//after
						p.manufacturers2_id as v_manufacturers2_id,

                        'v_froogle_instock'                => $iii++,
                        'v_froogle_ shipping'                => $iii++,
                        'v_manufacturers_name'                => $iii++,
//after
						'v_manufacturers2_name'                => $iii++,

                        'v_froogle_manufacturer_id'        => $iii++,
//after
                        'v_froogle_manufacturer_id'        => $iii++,

                        'size'                        => $iii++,
                        'quantity'                => $iii++,
                        'product_id'                => $iii++,
                        'manufacturer_id'        => $iii++,
//after 
						'manufacturer2_id'        => $iii++,

                        p.products_tax_class_id as v_tax_class_id,
                        p.products_quantity as v_products_quantity,
                        p.manufacturers_id as v_manufacturers_id,
//after
						p.manufacturers2_id as v_manufacturers2_id,

                p.products_tax_class_id as v_tax_class_id,
                p.products_quantity as v_products_quantity,
                p.manufacturers_id as v_manufacturers_id,
//after
                p.manufacturers2_id as v_manufacturers2_id,

               // temprow has the old style low to high level categories.
                $newlevel = 1;
                // let's turn them into high to low level categories
                for( $categorylevel=EP_MAX_CAT+1; $categorylevel>0; $categorylevel--){
                        if ($temprow['v_categories_name_' . $categorylevel] != ''){
                                $row['v_categories_name_' . $newlevel++] = $temprow['v_categories_name_' . $categorylevel];
                        }
                }

                if ($row['v_manufacturers_id'] != ''){
                        $sql2 = "SELECT manufacturers_name
                                FROM ".TABLE_MANUFACTURERS."
                                WHERE
                                manufacturers_id = " . $row['v_manufacturers_id']
                                ;
                        $result2 = tep_db_query($sql2);
                        $row2 =  tep_db_fetch_array($result2);
                        $row['v_manufacturers_name'] = $row2['manufacturers_name'];
                }
//after
				                // temprow has the old style low to high level categories.
                // let's turn them into high to low level categories
                for( $categorylevel=EP_MAX_CAT+1; $categorylevel>0; $categorylevel--){
                        if ($temprow['v_categories_name_' . $categorylevel] != ''){
                                $row['v_categories_name_' . $newlevel++] = $temprow['v_categories_name_' . $categorylevel];
                        }
                }

                if ($row['v_manufacturers2_id'] != ''){
                        $sql2 = "SELECT manufacturers2_name
                                FROM ".TABLE_MANUFACTURERS2."
                                WHERE
                                manufacturers2_id = " . $row['v_manufacturers2_id']
                                ;
                        $result2 = tep_db_query($sql2);
                        $row2 =  tep_db_fetch_array($result2);
                        $row['v_manufacturers2_name'] = $row2['manufacturers2_name'];
                }

       if ($v_manufacturer_id==''){
                $v_manufacturer_id="NULL";
        }
//after
		        if ($v_manufacturer2_id==''){
                $v_manufacturer2_id="NULL";
        }

        // OK, we need to convert the manufacturer's name into id's for the database
        if ( isset($v_manufacturers_name) && $v_manufacturers_name != '' ){
                $sql = "SELECT man.manufacturers_id
                        FROM ".TABLE_MANUFACTURERS." as man
                        WHERE
                                man.manufacturers_name = '" . $v_manufacturers_name . "'";
                $result = tep_db_query($sql);
                $row =  tep_db_fetch_array($result);
                if ( $row != '' ){
                        foreach( $row as $item ){
                                $v_manufacturer_id = $item;
                        }
                } else {
                        // to add, we need to put stuff in categories and categories_description
                        $sql = "SELECT MAX( manufacturers_id) max FROM ".TABLE_MANUFACTURERS;
                        $result = tep_db_query($sql);
                        $row =  tep_db_fetch_array($result);
                        $max_mfg_id = $row['max']+1;
                        // default the id if there are no manufacturers yet
                        if (!is_numeric($max_mfg_id) ){
                                $max_mfg_id=1;
                        }

                        // Uncomment this query if you have an older 2.2 codebase
                        /*
                        $sql = "INSERT INTO ".TABLE_MANUFACTURERS."(manufacturers_id, manufacturers_name, manufacturers_image) VALUES ('".$max_mfg_id."','".$v_manufacturers_name."','".EP_MANF_IMAGE."')";
                        */

                        // Comment this query out if you have an older 2.2 codebase
                        $sql = "INSERT INTO ".TABLE_MANUFACTURERS."(manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified) VALUES ('" . $max_mfg_id . "', '" . $v_manufacturers_name . "','" . EP_MANF_IMAGE . "', " . CURRENT_TIMESTAMP . "," . CURRENT_TIMESTAMP . ")";
                        $result = tep_db_query($sql);
                        $v_manufacturer_id = $max_mfg_id;
                }
        }
//after
		        // OK, we need to convert the manufacturer's name into id's for the database
        if ( isset($v_manufacturers2_name) && $v_manufacturers2_name != '' ){
                $sql = "SELECT man.manufacturers2_id
                        FROM ".TABLE_MANUFACTURERS2." as man
                        WHERE
                                man.manufacturers2_name = '" . $v_manufacturers2_name . "'";
                $result = tep_db_query($sql);
                $row =  tep_db_fetch_array($result);
                if ( $row != '' ){
                        foreach( $row as $item ){
                                $v_manufacturer2_id = $item;
                        }
                } else {
                        // to add, we need to put stuff in categories and categories_description
                        $sql = "SELECT MAX( manufacturers2_id) max FROM ".TABLE_MANUFACTURERS2;
                        $result = tep_db_query($sql);
                        $row =  tep_db_fetch_array($result);
                        $max_mfg_id = $row['max']+1;
                        // default the id if there are no manufacturers yet
                        if (!is_numeric($max_mfg_id) ){
                                $max_mfg_id=1;
                        }

                        // Uncomment this query if you have an older 2.2 codebase
                        /*
                        $sql = "INSERT INTO ".TABLE_MANUFACTURERS."(manufacturers_id, manufacturers_name, manufacturers_image) VALUES ('".$max_mfg_id."','".$v_manufacturers_name."','".EP_MANF_IMAGE."')";
                        */

                        // Comment this query out if you have an older 2.2 codebase
                        $sql = "INSERT INTO ".TABLE_MANUFACTURERS2."(manufacturers2_id, manufacturers2_name, manufacturers2_image, date_added, last_modified) VALUES ('" . $max_mfg_id . "', '" . $v_manufacturers2_name . "','" . EP_MANF_IMAGE . "', " . CURRENT_TIMESTAMP . "," . CURRENT_TIMESTAMP . ")";
                        $result = tep_db_query($sql);
                        $v_manufacturer2_id = $max_mfg_id;
                }
        }

 

 

                                        products_weight,
                                       products_quantity,
                                       manufacturers_id,
//after
manufacturers2_id

                                                            '$v_products_weight',
                                                           '$v_products_quantity',
                                                           '$v_manufacturer_id',
//after
'$v_manufacturer2_id'

                                        ', products_last_modified=CURRENT_TIMESTAMP
                                       , products_quantity="' . $v_products_quantity .  
                                       '" ,manufacturers_id=' . $v_manufacturer_id . 
//after
									'" ,manufacturers2_id=' . $v_manufacturer2_id .

 

in export xls i see new column - v_manufacturers2_name and i see allright manufacturers2 in his products, but if i change manufacturer2 and make upload and insert this file i have error -

File uploaded.
Temporary filename: /home/u50422/aquast.ru/tmp/php3qTlTD
User filename: EP2007Apr03-140255.xls
Size: 40064
| ванна MIAN | editorPics | | ванна MIAN | Описание т | | | | 2320 | 8.00 | | 0000-00-00 | 421 | 1 | Цвет | 14 | | Хром | 15 | | Серебро | 16 | | Золото | 17 | | хром/золот | 2 | | | 55 | Ванны | Прямоуголь | | | | | | --нет-- | Active Updated
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 '" ,manufacturers2_id=13 , products_status=1 ' at line 4

UPDATE products SET products_price="2320" ,products_image="editorPics/img42ca6b6ced90d.jpg" ,products_subimage1="" ,products_subimage2="" ,products_subimage3="" ,products_subimage4="" ,products_subimage5="" ,products_subimage6="", products_weight="8.00", products_tax_class_id="", products_date_available= NULL, products_date_added= "0000-00-00 00:00:00", products_last_modified=CURRENT_TIMESTAMP , products_quantity="421" ,manufacturers_id=NULL" ,manufacturers2_id=13 , products_status=1 WHERE (products_id = "282")

[TEP STOP]

PLEASE HELP!

Edited by Orik

Share this post


Link to post
Share on other sites

thankyou surfalot, everything is almost working now.

 

i changed

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

 

to

define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT );

 

and I added a '/' before 'temp/' in easypopulate.php

 

I can now download files and edit them fine although i tried to upload a file and insert it into the db and i got this:

 

File uploaded.

Temporary filename: /tmp/phpSaBan1

User filename: EP2007Apr03-1705.txt

Size: 531343

| capcom_cla | Capcom Cla | Brand new, | | 26.99 | 0.00 | | 2006-11-22 | 0 | Sony | Gaming | PSP Games | | --none-- | Inactive | !New Product!

| burnout_le | Burnout Le | Brand new, | | 19.99 | 0.00 | | 2006-11-22 | 0 | Sony | Gaming | PSP Games | | --none-- | Inactive | !New Product!

| sudoku.gif | Go Sudoku | Brand new, | | 15.99 | 0.00 | | 2006-11-22 | 0 | Sony | Gaming | PSP Games | | --none-- | Inactive | !New Product!

| gradius.gi | Gradius Co | Brand new, | | 26.99 | 0.00 | | 2006-11-22 | 0 | Sony | Gaming | PSP Games | | --none-- | Inactive | !New Product!

| gripshift. | Gripshift | GripShift | | 16.99 | 0.00 | | 2006-11-22 | 0 | Sony | Gaming | PSP Games | | --none-- | Inactive | !New Product!

| goblet.gif | Harry Pott | Brand new, | | 17.99 | 0.00 | | 2006-11-22 | 0 | Sony | Gaming | PSP Games | | --none-- | Inactive | !New Product!

| king_kong. | Peter Jack | Brand new, | | 19.99 | 0.00 | | 2006-11-22 | 0 | Sony | Gaming | PSP Games | | --none-- | Inactive | !New Product!

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 's King Kong PSP', 'king_kong.gif', '0', '1', CURRE' at line 14

 

INSERT INTO products ( products_image, products_model, products_price, products_status, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, manufacturers_id) VALUES ( 'Peter Jackson's King Kong PSP', 'king_kong.gif', '0', '1', CURRENT_TIMESTAMP, "0", "2006-11-22 22:33:01", '', '', 'Sony', '454')

 

What is wrong with the SQL syntax?

 

also, just a general question: If I upload a EP file containing products that are already in my store would they be added twice, or just ignored?

 

And, when I upload an EP file do I need to include products that are already active in my store or can I just upload a spreadsheet with all the products i want to add to my store?

Share this post


Link to post
Share on other sites
thankyou surfalot, everything is almost working now.

 

i changed

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

 

to

define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT );

 

and I added a '/' before 'temp/' in easypopulate.php

 

I can now download files and edit them fine although i tried to upload a file and insert it into the db and i got this:

 

What is wrong with the SQL syntax?

 

also, just a general question: If I upload a EP file containing products that are already in my store would they be added twice, or just ignored?

 

And, when I upload an EP file do I need to include products that are already active in my store or can I just upload a spreadsheet with all the products i want to add to my store?

the problem is the single qoute in your data. you should try the excel safe option.

 

the download will then be comma separated (for the US (maybe all english countries)), and quoted values and the file extension will change to .CSV. You can open in excel and save back to the same CSV to import (or save as... DOS CSV file type).

 

Looks like your first column is an image. EP requires all products have a unique model number (per the directions). That is how imported products are matched with existing products for an update. If no matching model number is found, a new product is created.

 

you can import any portion of your inventory, new products or updated products.

Share this post


Link to post
Share on other sites

okay, ive turned the excel safe option on.

 

When i download a .csv file to edit like you say none of my products have unique model numbers. Im worried that if i now download a .csv file and give each product a unique number and then re-upload the file it will create doubles of every product because it will see each product as different to the ones already in my store (without a unique num.)

 

sorry if that didnt make sense :/ do you understand what im saying?

Share this post


Link to post
Share on other sites
okay, ive turned the excel safe option on.

 

When i download a .csv file to edit like you say none of my products have unique model numbers. Im worried that if i now download a .csv file and give each product a unique number and then re-upload the file it will create doubles of every product because it will see each product as different to the ones already in my store (without a unique num.)

 

sorry if that didnt make sense :/ do you understand what im saying?

 

yes, if you have all the product entered in the shop now without model numbers, then upload all of them with new model numbers, you will have duplicate products.

 

if you have the complete product list downloaded with easy populate, you can try this.

*****************************************

First, backup your database using something like phpMyAdmin or the osC backup just in case.

*****************************************

then you can clear all your products by running the following script in phpMyAdmin.

then you can import your products with model numbers using easy populate.

 

DELETE FROM `products`;
DELETE FROM `products_attributes`;
DELETE FROM `products_attributes_download`;
DELETE FROM `products_description`;
DELETE FROM `products_notifications`;
DELETE FROM `products_options`;
DELETE FROM `products_options_values`;
DELETE FROM `products_options_values_to_products_options`;
DELETE FROM `products_to_categories`;
ALTER TABLE `products` AUTO_INCREMENT = 1;
ALTER TABLE `products_attributes` AUTO_INCREMENT = 1;
ALTER TABLE `products_description` AUTO_INCREMENT = 1;
ALTER TABLE `products_options_values_to_products_options` AUTO_INCREMENT = 1;

 

there is a more complete script available if you need orders, manufacturer, customers, etc. cleaned up.

 

if you have any problems with this you can restore the backup and try something else.

Share this post


Link to post
Share on other sites

okay then, it looks like i will go ahead with what you are suggesting (and I do want to keep orders, customers etc.) I just want to make sure of a few things first:

 

EP can handle HTML descriptions ok without any problems right?

 

How do I enable product attributes with EP? they are currently set to 'false' so when i download a file they are not included, obviously deleting them would loose them as they are not in my EP file.

 

How do I reduce the Category depth to 2 instead of 3?

 

and when I go to EP in the Admin section of my site even though Excel Safe Output is set to true it says 'Field seperator: comma' will my descriptions interfer with this? or does Excel safe output stop that from happening?

 

 

thankyou, youve been ssoooooooooo helpful so far, I thought I would never get Ep to work :)

Share this post


Link to post
Share on other sites

Hi,

 

I've a problem downloading all the attributes, for example if I've the following attributes:

 

- size

- color

- type

- extra

- other

 

In the $attributes_options_select I've filled in all the above attributes: size, color, type, extra, other

 

But for some reason I can only download the 'size' attribute and all other attributes doesn't download.. I want to download this so I can make a default file, which I can easily update.. Is there something I'm doing wrong or forgot to do.. because I really can't get it working.. Hope someone could help me out..

 

BTW I'm using Easy Populate 2.76d

Share this post


Link to post
Share on other sites
EP can handle HTML descriptions ok without any problems right?

yes. there has been a bug reported for php vers 4.3.4+ and early versions of php 5. if the your data field starts with a double quote, it's not handled correctly. there is a fix for that.

 

How do I enable product attributes with EP? they are currently set to 'false' so when i download a file they are not included, obviously deleting them would loose them as they are not in my EP file.

set that to true and it should work.

How do I reduce the Category depth to 2 instead of 3?

check the settings in easypopulate.php.

 

and when I go to EP in the Admin section of my site even though Excel Safe Output is set to true it says 'Field seperator: comma' will my descriptions interfer with this? or does Excel safe output stop that from happening?

that's OK. true CSV format (which is what I was trying to accomplish) quotes all the fields so commas in the field should not hurt anything. Asside from the issue mentioned above, all special characters should be handled correctly.

Share this post


Link to post
Share on other sites
Hi,

 

I've a problem downloading all the attributes, for example if I've the following attributes:

 

- size

- color

- type

- extra

- other

 

In the $attributes_options_select I've filled in all the above attributes: size, color, type, extra, other

 

But for some reason I can only download the 'size' attribute and all other attributes doesn't download.. I want to download this so I can make a default file, which I can easily update.. Is there something I'm doing wrong or forgot to do.. because I really can't get it working.. Hope someone could help me out..

 

BTW I'm using Easy Populate 2.76d

so you've set this:

$attribute_options_select = array('size', 'color','type','extra','other');

and those are exactly the same names as in the database (case sensitive)

I just looked at the code and ran a test with 2.76d and all seems to be OK. I don't see any php or mysql versions issues in that code.

Share this post


Link to post
Share on other sites

Hi Todd,

 

I've put the exact names in the configuration admin interface (created with the files of Tone).. or do you think I need to hard code it, like in your example above.. ? I will try that.. maybe that would work better..

Share this post


Link to post
Share on other sites
Just tried to do it hard code.. but also doesn't work.. really don't know what to do.. or what I'm doing wrong..

if you don't have php globals problems, you may consider trying the version I uploaded. There is some confusion about what v2.76d is since the other uploaders didn't give their work a unique version number. all the settings are in the easypopulate file not the admin.

Share this post


Link to post
Share on other sites
yes. there has been a bug reported for php vers 4.3.4+ and early versions of php 5. if the your data field starts with a double quote, it's not handled correctly. there is a fix for that.

set that to true and it should work.

 

check the settings in easypopulate.php.

that's OK. true CSV format (which is what I was trying to accomplish) quotes all the fields so commas in the field should not hurt anything. Asside from the issue mentioned above, all special characters should be handled correctly.

 

thankyou surfalot, it worked great ! :D

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

×