Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Easy Populate & Products Attributes


VJ

Recommended Posts

Mine has 2 errors, I would like to get resolved.

 

Heres my .txt file rows

 

v_products_model	v_products_image	v_products_name_1	v_products_description_1	v_products_url_1	v_products_price	v_products_weight	v_date_avail	v_date_added	v_products_quantity	v_attribute_options_id_1	v_attribute_options_name_1_1	v_attribute_options_id_2	v_attribute_options_name_2_1	v_attribute_options_id_3	v_attribute_options_name_3_1	v_attribute_values_id_3_1	v_attribute_values_price_3_1	v_attribute_values_name_3_1_1	v_attribute_values_id_3_2	v_attribute_values_price_3_2	v_attribute_values_name_3_2_1	v_attribute_values_id_3_3	v_attribute_values_price_3_3	v_attribute_values_name_3_3_1	v_attribute_values_id_3_4	v_attribute_values_price_3_4	v_attribute_values_name_3_4_1	v_attribute_values_id_3_5	v_attribute_values_price_3_5	v_attribute_values_name_3_5_1	v_attribute_options_id_4	v_attribute_options_name_4_1	v_attribute_values_id_4_1	v_attribute_values_price_4_1	v_attribute_values_name_4_1_1	v_attribute_values_id_4_2	v_attribute_values_price_4_2	v_attribute_values_name_4_2_1	v_attribute_values_id_4_3	v_attribute_values_price_4_3	v_attribute_values_name_4_3_1	v_attribute_values_id_4_4	v_attribute_values_price_4_4	v_attribute_values_name_4_4_1	v_attribute_options_id_5	v_attribute_options_name_5_1	v_attribute_values_id_5_1	v_attribute_values_price_5_1	v_attribute_values_name_5_1_1	v_attribute_values_id_5_2	v_attribute_values_price_5_2	v_attribute_values_name_5_2_1	v_manufacturers_name	v_categories_name_1	v_categories_name_2	v_categories_name_3	v_tax_class_title	v_status	EOREOR

 

Here's 2 of my products in the .txt file -

 

00-69032-000	00-69032-000.jpg	SporTrak? Canvas Carry Case	"<li>Holds GPS receiver and spare batteries<li>Zipper opening, large belt loop<li>Padded and durable canvas"		19.95	0.16																																															Magellan	"2 Way Radios, Scanners, & GPS"	GPS	GPS		Active	Eoreor
000-40803-0BI	000-40803-0BI.jpg	3-Port QuickPort Flush Mount Wall Plate	<li>Compatible with QuickPort inserts<li>Includes color-matched mounting screws		49.95	0.7																																															Leviton	Custom Installation	Structured Wiring	Wall Plates & Inserts		Active	Eoreor

Like I posted before -

 

Hi,

 

I am getting these errors at the bottom of my easypopulate.php file -

 

Filename: /home/********/public_html/shop/temp/

 

Warning: file(/home/********/public_html/temp//home/********/public_html/shop/temp/): failed to open stream: No such file or directory in /home/********/public_html/admin/easypopulate.php on line 753

 

Warning: Invalid argument supplied for foreach() in /home/********/public_html/admin/easypopulate.php on line 758

 

Help.

 

Thank you,

Michael

 

Please help.

 

Thank you,

Michael

Edited by mrgtec

Michael

Link to comment
Share on other sites

most likely you are using php 5, there is a fix a few pages back

 

so i broke it right down to as easy as it can get

 

this is the file i uploded

 

v_products_model	v_categories_name_1	v_status	EOREOR
a								  Test							active			EOREOR
b								  Test							active			EOREOR

 

and this iswhat i get in return

File uploaded.
Temporary filename: /tmp/phpr5lWI7
User filename: test2.txt
Size: 98
| a | Test | active !New Product!
| b Test a |

 

the easypopulate stuff is all as it came from the download

HELP!

Link to comment
Share on other sites

post your configure.php file here.

 

Mine has 2 errors, I would like to get resolved.

 

Heres my .txt file rows

 

v_products_model	v_products_image	v_products_name_1	v_products_description_1	v_products_url_1	v_products_price	v_products_weight	v_date_avail	v_date_added	v_products_quantity	v_attribute_options_id_1	v_attribute_options_name_1_1	v_attribute_options_id_2	v_attribute_options_name_2_1	v_attribute_options_id_3	v_attribute_options_name_3_1	v_attribute_values_id_3_1	v_attribute_values_price_3_1	v_attribute_values_name_3_1_1	v_attribute_values_id_3_2	v_attribute_values_price_3_2	v_attribute_values_name_3_2_1	v_attribute_values_id_3_3	v_attribute_values_price_3_3	v_attribute_values_name_3_3_1	v_attribute_values_id_3_4	v_attribute_values_price_3_4	v_attribute_values_name_3_4_1	v_attribute_values_id_3_5	v_attribute_values_price_3_5	v_attribute_values_name_3_5_1	v_attribute_options_id_4	v_attribute_options_name_4_1	v_attribute_values_id_4_1	v_attribute_values_price_4_1	v_attribute_values_name_4_1_1	v_attribute_values_id_4_2	v_attribute_values_price_4_2	v_attribute_values_name_4_2_1	v_attribute_values_id_4_3	v_attribute_values_price_4_3	v_attribute_values_name_4_3_1	v_attribute_values_id_4_4	v_attribute_values_price_4_4	v_attribute_values_name_4_4_1	v_attribute_options_id_5	v_attribute_options_name_5_1	v_attribute_values_id_5_1	v_attribute_values_price_5_1	v_attribute_values_name_5_1_1	v_attribute_values_id_5_2	v_attribute_values_price_5_2	v_attribute_values_name_5_2_1	v_manufacturers_name	v_categories_name_1	v_categories_name_2	v_categories_name_3	v_tax_class_title	v_status	EOREOR

 

Here's 2 of my products in the .txt file -

 

00-69032-000	00-69032-000.jpg	SporTrak? Canvas Carry Case	"<li>Holds GPS receiver and spare batteries<li>Zipper opening, large belt loop<li>Padded and durable canvas"		19.95	0.16																																															Magellan	"2 Way Radios, Scanners, & GPS"	GPS	GPS		Active	Eoreor
000-40803-0BI	000-40803-0BI.jpg	3-Port QuickPort Flush Mount Wall Plate	<li>Compatible with QuickPort inserts<li>Includes color-matched mounting screws		49.95	0.7																																															Leviton	Custom Installation	Structured Wiring	Wall Plates & Inserts		Active	Eoreor

Like I posted before -

Please help.

 

Thank you,

Michael

Link to comment
Share on other sites

Hi, Mibble,

 

Here my config file is -

 

<?php
/*
 osCommerce, Open Source E-Commerce Solutions
 [url=http://www.oscommerce.com]http://www.oscommerce.com[/url]

 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://************************.com'); // eg, [url=http://localhost]http://localhost[/url] - should not be empty for productive servers
 define('HTTP_CATALOG_SERVER', 'http://************************.com');
 define('HTTPS_CATALOG_SERVER', 'http://************************.com');
 define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module
 define('DIR_FS_DOCUMENT_ROOT', '/home/********/public_html/'); // where the pages are located on the server
 define('DIR_WS_ADMIN', '/admin/'); // absolute path required
 define('DIR_FS_ADMIN', '/home/********/public_html/admin/'); // absolute pate required
 define('DIR_WS_CATALOG', '/'); // absolute path required
 define('DIR_FS_CATALOG', '/home/********/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', '********_osc1');
 define('DB_SERVER_PASSWORD', '********');
 define('DB_DATABASE', '********_osc1');
 define('USE_PCONNECT', 'false'); // use persisstent connections?
 define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'
?>

Thank you,

Michael

Edited by mrgtec

Michael

Link to comment
Share on other sites

If you figure it out let me know. Unfortunately I can't dig into the code right now. I was hoping for an easy answer. I also just uploaded the new 2.78-ms2.

 

 

 

There is not a problem. The sppc headers and data are only included if you choose to download model/price/qty not if you download the full file. It can be changed, but whoever slipped it into the code only included it for that section.

Link to comment
Share on other sites

use this:

define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT);

 

Hi, Mibble,

 

Here my config file is -

 

<?php
/*
 osCommerce, Open Source E-Commerce Solutions
 [url=http://www.oscommerce.com]http://www.oscommerce.com[/url]

 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://************************.com'); // eg, [url=http://localhost]http://localhost[/url] - should not be empty for productive servers
 define('HTTP_CATALOG_SERVER', 'http://************************.com');
 define('HTTPS_CATALOG_SERVER', 'http://************************.com');
 define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module
 define('DIR_FS_DOCUMENT_ROOT', '/home/********/public_html/'); // where the pages are located on the server
 define('DIR_WS_ADMIN', '/admin/'); // absolute path required
 define('DIR_FS_ADMIN', '/home/********/public_html/admin/'); // absolute pate required
 define('DIR_WS_CATALOG', '/'); // absolute path required
 define('DIR_FS_CATALOG', '/home/********/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', '********_osc1');
 define('DB_SERVER_PASSWORD', '********');
 define('DB_DATABASE', '********_osc1');
 define('USE_PCONNECT', 'false'); // use persisstent connections?
 define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'
?>

Thank you,

Michael

Link to comment
Share on other sites

OK so I downloaded this contribution, extracted the files and read through both the EasyPopulate_Manual.txt and the 1ReadMeFirst.txt file.

 

2. Copy file easypopulate.php and easypopulate_functions into admin/. - DONE

 

3. For adding link to the Admin, edit file admin/includes/boxes/catalog.php by adding this line:

 

'<a href="' . tep_href_link('easypopulate.php', '', 'NONSSL') . '" class="menuBoxContentLink">Easy Populate</a><br>'.

 

After:

'<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, '', 'NONSSL') . '"

class="menuBoxContentLink">' . BOX_CATALOG_CATEGORIES_PRODUCTS_ATTRIBUTES .

'</a><br>' . - DONE

 

4. Make sure that you have a directory called catalog/temp, and that it's permissions are set to allow writes to that directory (while you're in the catalog directory, execute "chmod 777 temp") - FOLDER DIDNT EXIST, SO I CREATED IT. DONE

 

 

 

So, now this is done, I go to the next part.

 

1. Go to Admin -> Catalog -> Easy Populate - ??? I'm assuming this means on my site, but there is no catalogue folder below the Admin folder. I am stumped as to what Im doing wrong. Any ideas please?

 

Thanks

Hand made jewellery and tiaras on our website

 

Please bear with me. Im an osC noobie!

Link to comment
Share on other sites

Hi All,

 

Im in the process of installing easy populate onto my offline dev store(first timer for offline work), everything seems fine no error messages, but when i click to download the text file to edit nothing happens.

 

I've checked the temp directory and nothing is appearing. I have changed the temp folder location in easypopulate.php from its default temp/ (as this didnt appear to work) to localhost/temp/ which still doesnt appear to work. I have only added a single test product to the catalog, before i use this mod to upload the remainder of the products.

 

Does anyone have any idea's? I tried searching for a solution but there are so many posts for this mod i was snowed under.

 

Any pointers would be most appreciated.

 

Thanks in advance

Donna :thumbsup:

Link to comment
Share on other sites

Playing with the code, I seen these 2 lines werent rooted, & I changed them & it worked for me.

 

I found the prob. in the easypopulate.php file.

 

Change these 2 line of the code

 

& the lines of code are the following line #'s

 

21 & 22

 

$tempdir = "temp/";
$tempdir2 = "temp/";

 

to

 

$tempdir = "/temp/";
$tempdir2 = "/temp/";

 

Michael

Michael

Link to comment
Share on other sites

It says that it uploaded all 300 but I have 1 product in mine now, but I am suppost to have about 20,000 products? Whats wrong with thing? Why would this be?

 

Please help.

 

Michael

Edited by mrgtec

Michael

Link to comment
Share on other sites

Easy populate is duplicating category and product entries. Any advice?

 

 

I solved the problem. Easy Populate apparently didn't like the fact my categories included apostrophies.

Removed the apostrophies from the shop categories and VOILA! works like a charm. :)

Link to comment
Share on other sites

hey, here are some features that i am interested about easy populate:

 

01.

how can i make that category and product name only need one column? my product name and category are the same on both languages so i really need only one column :-)

 

02.

order of the excell column in downloaded file aren't same as i had in file which i've uploaded. how can i fix it?

 

thanx

Link to comment
Share on other sites

My apologies. I missed a line in one of the files and as such missed part of the install out which was preventing it working.

 

All now up and running :)

 

Many thanks

Hand made jewellery and tiaras on our website

 

Please bear with me. Im an osC noobie!

Link to comment
Share on other sites

My apologies. I missed a line in one of the files and as such missed part of the install out which was preventing it working.

 

All now up and running :)

 

Many thanks

 

guess I spoke too soon O.o

 

I got everything set up and downloaded the csv file with my current database info. I added in a list of products, saved the resulting file as a new cs. Log in to my osCommerce, navigate to the products area, select the file to upload, click on the button to load the database and get the following message(s)

 

"File uploaded.

Temporary filename: C:\WINDOWS\TEMP\php52DB.tmp

User filename: current stock Top Tiara.xls

SIZE_EP7927"

 

This appears directly below the loading info, so to start with I thought it had worked, but when I checked my tables they are empty. So I tried it again, and this time I noticed there was more text right at the bottom of the page :

 

"PHP Warning: move_uploaded_file(../temp/current stock Top Tiara.xls): failed to open stream: No such file or directory in C:\hshome\toptiara\toptiara.com\admin\easypopulate_functions.php on line 32 PHP Warning: move_uploaded_file(): Unable to move 'C:\WINDOWS\TEMP\php52DB.tmp' to '../temp/current stock Top Tiara.xls' in C:\hshome\toptiara\toptiara.com\admin\easypopulate_functions.php on line 32 PHP Warning: file(../temp/current stock Top Tiara.xls): failed to open stream: No such file or directory in C:\hshome\toptiara\toptiara.com\admin\easypopulate.php on line 735 PHP Warning: Invalid argument supplied for foreach() in C:\hshome\toptiara\toptiara.com\admin\easypopulate.php on line 758 "

 

I FTP'd to my site to check the permissions on both the Catalog/Temp folder (777) and the loading file (also 777), but this doesnt appear to be the problem.

 

Anyone have any ideas/suggestions please?

 

Thanks

Hand made jewellery and tiaras on our website

 

Please bear with me. Im an osC noobie!

Link to comment
Share on other sites

Hi All,

 

Another question here, apologies if it has already been posted just point me in the right direction for the solution...

 

Now i already ave 1800 products in my store, yet wish to use this mod to manage them. Now as far as i am aware i cannot download this many products in one go, and can't figure out any other way to split the file as this navigates to a windows explorer window...

 

Any ideas?

 

Best Regards

 

Donna

Link to comment
Share on other sites

Hi Guys

 

I am having a problem with Easy Populate in displaying descriptions

 

v_products_model v_categories_name_1 v_products_name_1

AO15020 AOpen Fax/Modem AOPEN FM56 SVV INT. PCI 56K/14.4K MODEM/FAX/SUPPORTS LP

 

v_prodicts_description_1

<br><br><img src=http://www.bluechipit.com.au/content/_images/AO15020_lg.jpg><br>Aopen FM56-SVV - Modem/Fax (Kbps): 56K / 14.4K / V.92 Conexant CX11252-11 single chip HSFi V.92 TAM PnP PCI 2.2 Bus supports Low Profile. 56Kbps download speed from Internet ITU-V.92 and K56Flex Dual Standards Quick Connect Modem-on-Hold Upstream up to 48Kbps Telephone Answering Machine (TAM) and Voice Mail Operations 16550/A Compatible Enhanced UART for Sustained DTE Speed of 115 200bps. 1 Year RTB Warranty.

 

 

v_products_price v_tax_class_title v_products_image

23.1 taxable_goods www.bluechipit.com.au/content/_images/AO15020_hg.jpg

EOREOR

EOREOR

 

 

I don't get any description listed under ANY of my products.

 

Please Please Help....

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...