Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Easy Populate & Products Attributes


VJ

Recommended Posts

Hi everyone,

 

I finally got over 7000 products imported, the admin section is fine but I am receiving a Internal Server Error for the rest of the site (anything in the catalog/ directory).

 

I'm not sure why. Anyone have a clue?

 

The error log shows: Premature end of script headers: index.php

 

Settings & Info

 

EP vers: 2.76g-MS2

osCommerce Online Merchant v2.2 RC2a

OS: FreeBSD 7.0-STABLE

HTTP: Apache/2.2.9

DB: MySQL 5.1.17-beta

PHP: 5.2.6 (Zend: 2.2.0)

 

Temp Directory:

/web/canadiancartridge.com/httpdocs/shop/catalog/temp/

Temp Dir is Writable

Magic Quotes is: off

register_globals is: off

Split files on: 300 records

Model Num Size: 12

Price with tax: false

Calc Precision: 2

Replace quotes: false

Field seperator: comma

Excel safe output: true

Preserve tab/cr/lf: false

Category depth: 7

Enable attributes: true

SEF Froogle URLS: false

More Pics: false

Unknown Pics: false

HTC: false

SPPC: false

Extra Fields: false

Edited by erikajune
Link to comment
Share on other sites

ive been using easy populate v2.76g (with product attributes) by surfalot to upload files...all my product infomation shows up perfect, but my images never show up when i upload files using easy populate...it makes no sense what so ever.....

 

My images will show up if i upload my images after i upload my .cvs files, but if upload my .cvs after the images are already there they do not show up... and if i update my .cvs files then the images dissapear and u have to reupload the images again...i dont understand whats going on here, but im to the point of giving up that is how much ive messed with this

 

Ived talked to my hosting site netfirms, and they have basically given as well that can't find out whats going on

 

I know my images are in the right directory mystore/catalog/images......

 

What is even wierder is if u manually go into oscommerce and upload the image from there instead of ftp them to mystore/catalog/images it show's up then.

 

I know that my .cvs file is set up right too

 

My main images are under v_procuct image....which i know is the right column and i know for a fact that my image names are identical to the ones listed under v_product image

because all my information was sent to me from my distributor so i know the info is right.....

 

 

Also Ive already used the offline .cvs splitter from this forum to split the file because it would time out at 300 items...i have split each file into 200 lines....i have like 85 pieces.....since i have like 15000 files

 

 

Everything else on my site works correctly when i use v.2.76g easypopulate just not my images

 

 

i talked to support from netfirms my webhost and they said they have no idea why its doing this because my stuff looked set up right....ive yet to find a answer of why its not finding the images

 

I do have SSL enabled ...and i read that, that can cause problems with images....but i tried changing the code as i saw on this site for that problem and it didnt fix it...

 

do i need to edit something in my configure.php file?

 

Im fairly new at php...but i know that i have my files set up right ive read all the manuals and everything i can find....and i cannot find a answer to this problem

 

"Vger" gave me the suggestion also to switch versions...but i didnt have any luck going that route either.......

 

Im at my wits end and its driving me crazy nobody knows how to fix this.....not my webhost ....not any of the members suggestions.....and nobody is really answering me....im really begging someone to help me figure this out...or i will have to pay for a professional cart which i do not want to have to do

 

 

 

anymore information that yall need to help figure out this problem let me know what u need...like my configure.php or which ever file....thanks

Edited by rickiesdiscountelectronics
Link to comment
Share on other sites

EP does not upload the images, it just updates the table with the location.

 

1. What is the column title of the column you are using?

 

Should be v_products_image, your post has v_procuct image, which I would think is a typo but you never know, stranger things happen at sea.

 

2. For a specific part, please post this no, what are you putting in that column?

 

3. Does this update actually update the product table?

 

4. When you right click on the "broken" image link for that part what is the complete path to the image?

 

5. What is your site url?

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 ======>>>>>.

Link to comment
Share on other sites

EP does not upload the images, it just updates the table with the location.

 

1. What is the column title of the column you are using?

 

Should be v_products_image, your post has v_procuct image, which I would think is a typo but you never know, stranger things happen at sea.

 

2. For a specific part, please post this no, what are you putting in that column?

 

3. Does this update actually update the product table?

 

4. When you right click on the "broken" image link for that part what is the complete path to the image?

 

5. What is your site url?

 

 

yeah it is v_products_image it was just a typo....

 

 

 

 

Here is my easy populate settings:

Settings & Info

 

EP vers: 2.76g-MS2

osCommerce 2.2-MS2

OS:

HTTP: Apache/2.2.6 (Unix) mod_ssl/2.2.6 OpenSSL/0.9.8g

DB: MySQL 5.0.24a-log

PHP: 4.4.7 (Zend: 1.3.0)

 

Temp Directory:

/mnt/w0901/d18/s35/b02de28c/www/rickiesdiscountelectronics.com//rickiesdiscountelectronics/mystore//catalog/temp/

Temp Dir is Writable

Magic Quotes is: off

register_globals is: on

Split files on: 200 records

Model Num Size: 30

Price with tax: false

Calc Precision: 2

Replace quotes: false

Field seperator: comma

Excel safe output: true

Preserve tab/cr/lf: false

Category depth: 7

Enable attributes: true

SEF Froogle URLS: false

More Pics: false

Unknown Pics: false

HTC: false

SPPC: false

Extra Fields: false

 

 

 

 

 

 

yeah it updates everything when i reupload...but pictures dissapear

 

 

well right now giving u my site url will not work becasue i dont have the store moved over to live yet ...so u will not be able to view it.

 

but here it is right now

 

http://rickiesdiscountelectronics.com/rick...store//catalog/

 

 

when i right click on my images here is where it says its taking one of the images from

http://rickiesdiscountelectronics.com/rick...es/007-0002.jpg

 

which is the right place and that is where the images are located

 

 

Here is my code for easypopulate.php:

 

<?php

/*

$Id: easypopulate.php,v 2.76g 2007/01/20 22:50:52 surfalot Exp $

 

Designed for osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2007 Todd Holforty mtholforty(at)surfalot(dot)com

 

Released under the GNU General Public License

*/

 

// Current EP Version

define ('EP_CURRENT_VERSION', '2.76g-MS2');

 

require('includes/application_top.php');

require_once('includes/database_tables.php');

require('easypopulate_functions.php');

 

$system = tep_get_system_information();

 

//

//*******************************

//*******************************

// C O N F I G U R A T I O N

// V A R I A B L E S

//*******************************

//*******************************

 

 

//////////////////////////////////////////////////////

// *** Show all these settings on EP main page ***

// use this to debug your settings. Copy the settings

// to your post on the forum if you need help.

//////////////////////////////////////////////////////

define ('EP_SHOW_EP_SETTINGS', true); // default is: false

 

 

// **** Temp directory ****

/* ////////////////////////////////////////////////////////////////////////

//

// *IF* you changed your directory structure from stock and do not

// have /catalog/temp/, then you'll need to change this accordingly.

//

// *IF* your shop is in the default /catalog/ installation directory

// on your website, skip this Temp Directory settings info.

//

///////////////////////////////////////////////////////////////////////////

 

CREATING THE TEMP DIRECTORY

 

If your shop is in the root of your public site ( /home/myaccount/public_html/index.php ),

you should create a folder called temp from the root of your web space so that the

full path looks like this: /home/myaccount/public_html/temp/

 

Then you must set the permissions to 777. If you don't know how, ask your host.

 

 

THE DIR_FS_DOCUMENT_ROOT SETTING

 

DIR_FS_DOCUMENT_ROOT is set in your /catalog/admin/includes/configure.php

You should look at the setting DIR_FS_DOCUMENT_ROOT setting.

if it looks like this (recommended, but doesn't always work):

 

define ('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT);

 

then leave it alone. If it looks like this:

 

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

 

ask your host if the "/home/myaccount/public_html" portion points to your public

web space and is correct. Whether you add the trailing slash on the

path or not doesn't matter to this contrib, as long as you make the

right choice on the following setting. The best thing is to leave it

alone as long as your host can confirm it is correct and everything else

is working fine. Having said that, NO trailing slash is technically correct.

 

 

 

THE DIR_WS_CATALOG & DIR_FS_CATALOG SETTINGS

 

DIR_WS_CATALOG & DIR_FS_CATALOG are set in your /catalog/admin/includes/configure.php

They may look like this if your shop is in the root of your web space.

If you have something different, don't just change it to this.

There is probably a good reason. I'm providing this as a reference

to you-all. The DIR_FS_DOCUMENT_ROOT, the DIR_WS_CATALOG, and the

DIR_FS_CATALOG settings all combine to create the temp location below.

 

define('DIR_WS_CATALOG', '/');

define('DIR_FS_CATALOG', DIR_FS_DOCUMENT_ROOT . DIR_WS_CATALOG);

 

 

 

THIS EP_TEMP_DIRECTORY SETTING

 

Next, the following setting should set so that the DIR_FS_CATALOG setting

plus this following setting makes a correct full path to your temporary

location, like this: /home/myaccount/public_html/temp/

 

if /home/myaccount/public_html/temp/ is the correct full path to your temp

location, then:

 

define ('EP_TEMP_DIRECTORY', DIR_FS_CATALOG . 'temp/');

 

is the correct setting here. Wow, I really hope this stops the forum traffic about this !!

 

////////////////////////////////////////////////////////////////////////// */

// **** Temp directory ****

define ('EP_TEMP_DIRECTORY', DIR_FS_CATALOG . 'temp/');

 

 

//**** File Splitting Configuration ****

// we attempt to set the timeout limit longer for this script to avoid having to split the files

// NOTE: If your server is running in safe mode, this setting cannot override the timeout set in php.ini

// uncomment this if you are not on a safe mode server and you are getting timeouts

// set_time_limit(330);

 

// if you are splitting files, this will set the maximum number of records to put in each file.

// if you set your php.ini to a long time, you can make this number bigger

define ('EP_SPLIT_MAX_RECORDS', 200); // default, seems to work for most people. Reduce if you hit timeouts

//define ('EP_SPLIT_MAX_RECORDS', 4); // for testing

 

 

//**** Image Defaulting ****

// set them to your own default "We don't have any picture" gif

//define ('EP_DEFAULT_IMAGE_MANUFACTURER', 'no_image_manufacturer.gif');

//define ('EP_DEFAULT_IMAGE_PRODUCT', 'no_image_product.gif');

//define ('EP_DEFAULT_IMAGE_CATEGORY', 'no_image_category.gif');

 

// or let them get set to nothing

define ('EP_DEFAULT_IMAGE_MANUFACTURER', '');

define ('EP_DEFAULT_IMAGE_PRODUCT', '');

define ('EP_DEFAULT_IMAGE_CATEGORY', '');

 

 

//**** Status Field Setting ****

// Set the v_status field to "Inactive" if you want the status=0 in the system

define ('EP_TEXT_ACTIVE', 'Active');

define ('EP_TEXT_INACTIVE', 'Inactive');

 

// Set the v_status field to "Delete" if you want to remove the item from the system

define ('EP_DELETE_IT', 'Delete');

 

 

// If zero_qty_inactive is true, then items with zero qty will automatically be inactive in the store.

define ('EP_INACTIVATE_ZERO_QUANTITIES', false); // default is false

 

 

//**** Size of products_model in products table ****

// set this to the size of your model number field in the db. We check to make

// sure all models are no longer than this value. this prevents the database from

// getting fubared. Just making this number bigger won't help your database! They must match!

// If you increase the Model Number size, you must increase the size of the field

// in the database. Use a SQL tool like phpMyAdmin (see your host) and change the

// "products_model" field of the "products" table in your osCommerce Database.

define ('EP_MODEL_NUMBER_SIZE', 30); // default is 12

 

 

//**** Price includes tax? ****

// Set the EP_PRICE_WITH_TAX to

// false if you want the price that is exported to be the same value as stored in the database (no tax added).

// true if you want the tax to be added to the export price and subtracted from the import price.

define ('EP_PRICE_WITH_TAX', false); // default is false

 

 

//**** Price calculation precision ****

// NOTE: when entering into the database all prices will be converted to 4 decimal places.

define ('EP_PRECISION', 2); // default is 2

 

 

// **** Quote -> Escape character conversion ****

// If you have extensive html in your descriptions and it's getting mangled on upload, turn this off

// set to true = replace quotes with escape characters

// set to false = no quote replacement

define ('EP_REPLACE_QUOTES', false); // default is false

 

 

// **** Field Separator ****

// change this if you can't use the default of tabs

// Tab is the default, comma and semicolon are commonly supported by various progs

// Remember, if your descriptions contain this character, you will confuse EP!

// if EP_EXCEL_SAFE_OUTPUT if false (below) you must make EP_PRESERVE_TABS_CR_LF false also.

$ep_separator = "\t"; // tab is default

//$ep_separator = ','; // comma

//$ep_separator = ';'; // semi-colon

//$ep_separator = '~'; // tilde

//$ep_separator = '*'; // splat

 

 

// *** Excel safe output ***

// this setting will supersede the previous $ep_separator setting and create a file

// that excel will import without spanning cells from embedded commas or tabs in your products.

// if EP_EXCEL_SAFE_OUTPUT if false (below) you must make EP_PRESERVE_TABS_CR_LF false also.

define ('EP_EXCEL_SAFE_OUTPUT', true); // default is: true

 

if (EP_EXCEL_SAFE_OUTPUT == true) {

if ($language == 'english') {

$ep_separator = ','; // comma

} elseif ($language == 'german') {

$ep_separator = ';'; // semi-colon

} else {

$ep_separator = ','; // comma // default for all others.

}

}

 

// if EP_EXCEL_SAFE_OUTPUT if true (above) there is an alternative line parsing routine

// provided by Maynard that will use a manual php approach. There is a bug in some

// PHP versions that may require you to use this routine. This should also provide proper

// parsing when quotes are used within a string. I suspect this should also resolve an issue

// recently reported in which characters with a german "Umlaute" like ÄäÖöÜü at the Beginning

// of some text, they will disappear when importing some csv-file, reported by TurboTB.

define ('EP_EXCEL_SAFE_OUTPUT_ALT_PARCE', false); // default is: false

 

 

// *** Preserve Tabs, Carriage returns and Line feeds ***

// this setting will preserve the special chars that can cause problems in

// a text based output. When used with EP_EXCEL_SAFE_OUTPUT, it will safely

// preserve these elements in the export and import.

define ('EP_PRESERVE_TABS_CR_LF', false); // default is: false

 

 

// **** Max Category Levels ****

// change this if you need more or fewer categories.

// set this to the maximum depth of your categories.

define ('EP_MAX_CATEGORIES', 7); // default is 7

 

 

// VJ product attributes begin

// **** Product Attributes ****

// change this to false, if do not want to download product attributes

define ('EP_PRODUCTS_WITH_ATTRIBUTES', true); // default is true

 

// change this to true, if you use QTYpro and want to set attributes stock with EP.

define ('EP_PRODUCTS_ATTRIBUTES_STOCK', false); // default is false

 

// change this if you want to download only selected product options (attributes).

// If you have a lot of product options, and your output file exceeds 256 columns,

// which is the max. limit MS Excel is able to handle, then load-up this array with

// attributes to skip when generating the export.

$attribute_options_select = '';

// $attribute_options_select = array('Size', 'Model'); // uncomment and fill with product options name you wish to download // comment this line, if you wish to download all product options

// VJ product attributes end

 

 

// ******************************************************************

// BEGIN Define Custom Fields for your products database

// ******************************************************************

// the following line is always left as is.

$custom_fields = array();

//

// The following setup will allow you to define any additional

// field into the "products" and "products_description" tables

// in your shop. If you have installed a custom contribution

// that adds fields to these tables you may simply and easily add

// them to the EasyPopulate system.

//

// ********************

// ** products table **

// Lets say you have added a field to your "products" table called

// "products_upc". The header name in your import file will be

// called "v_products_upc". Then below you will change the line

// that looks like this (without the comment double-slash at the beginning):

// $custom_fields[TABLE_PRODUCTS] = array(); // this line is used if you have no custom fields to import/export

//

// TO:

// $custom_fields[TABLE_PRODUCTS] = array( 'products_upc' => 'UPC' );

//

// If you have multiple fields this is what it would look like:

// $custom_fields[TABLE_PRODUCTS] = array( 'products_upc' => 'UPC', 'products_restock_quantity' => 'Restock' );

//

// ********************************

// ** products_description table **

// Lets say you have added a field to your "products_description" table called

// "products_short_description". The header name in your import file will be

// called "v_products_short_description_1" for English, "v_products_short_description_2" for German,

// "v_products_short_description_3" for Spanish. Other languages will vary. Be sure to use the

// langugage ID of the custom language you installed if it is other then the original

// 3 installed languages of osCommerce. If you are unsure what language ID you need to

// use, do a complete export and examine the file headers EasyPopulate produces.

//

// Then below you will change the line that looks like this (without the comment double-slash at the beginning):

// $custom_fields[TABLE_PRODUCTS_DESCRIPTION] = array(); // this line is used if you have no custom fields to import/export

//

// TO:

// $custom_fields[TABLE_PRODUCTS_DESCRIPTION] = array( 'products_short_description' => 'short' );

//

// If you have multiple fields this is what it would look like:

// $custom_fields[TABLE_PRODUCTS_DESCRIPTION] = array( 'products_short_description' => 'short', 'products_viewed' => 'Viewed' );

//

// the array format is: array( 'table_field_name' => 'Familiar Name' )

// the array key ('table_field_name') is always the exact name of the

// field in the table. The array value ('Familiar Name') is any text

// name that will be used in the custom EP export download checkbox.

//

// I believe this will only work for text/varchar and numeric field

// types. If your custom field is a date/time or any other type, you

// may need to incorporate custom code to correctly import your data.

//

 

$custom_fields[TABLE_PRODUCTS] = array(); // this line is used if you have no custom fields to import/export

$custom_fields[TABLE_PRODUCTS_DESCRIPTION] = array(); // this line is used if you have no custom fields to import/export

 

//

// FINAL NOTE: this currently only works with the "products" & "products_description" table.

// If it works well and I don't get a plethora of problems reported,

// I may expand it to more tables. Feel free to make requests, but

// as always, only as me free time allows.

//

// ******************************************************************

// END Define Custom Fields for your products database

// ******************************************************************

 

 

 

// ****************************************

// Froogle configuration variables

// Here are some links regarding Bulk uploads

// http://www.google.com/base/attributes.html

// http://www.google.com/base/help/custom-attributes.html

// ****************************************

 

// **** Froogle product info page path ****

// We can't use the tep functions to create the link, because the links will point to the

// admin, since that's where we're at. So put the entire path to your product_info.php page here

define ('EP_FROOGLE_PRODUCT_INFO_PATH', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . "product_info.php");

 

// **** Froogle product image path ****

// Set this to the path to your images directory

define ('EP_FROOGLE_IMAGE_PATH', HTTP_CATALOG_SERVER . DIR_WS_CATALOG_IMAGES);

 

// **** Froogle - search engine friendly setting

// if your store has SEARCH ENGINE FRIENDLY URLS set, then turn this to true

// I did it this way because I'm having trouble with the code seeing the constants

// that are defined in other places.

define ('EP_FROOGLE_SEF_URLS', false); // default is false

 

// **** Froogle Currency Setting

define ('EP_FROOGLE_CURRENCY', 'USD'); // default is 'USD'

 

// ****************************************

// End: Froogle configuration variables

//

 

 

// ***********************************

// *** Other Contributions Support ***

// ***********************************

 

// More Pics 6 v1.3

define ('EP_MORE_PICS_6_SUPPORT', false); // default is false

//

// Header Tags Controller Support v2.0

define ('EP_HTC_SUPPORT', false); // default is false

//

// Separate Pricing Per Customer (SPPC)

define ('EP_SPPC_SUPPORT', false); // default is false

 

// ///////////////////////////////////////////////////////////////////////////////

// The following items are not complete and untested. Experiment at your own risk.

// ///////////////////////////////////////////////////////////////////////////////

 

//

// Extra Fields Contribution (***UNTESTED AND MAY NOT BE FUNCTIONAL***)

define ('EP_EXTRA_FIELDS_SUPPORT', false); // default is false

//

// Unknown Image Contrib (***UNTESTED AND MAY NOT BE FUNCTIONAL***)

define ('EP_UNKNOWN_ADD_IMAGES_SUPPORT', false); // default is false

 

 

//*******************************

//*******************************

// E N D

// C O N F I G U R A T I O N

// V A R I A B L E S

//*******************************

//*******************************

 

 

Please tell me if there is anything wrong with this....noobody can seem to figure this out...thanks

Link to comment
Share on other sites

Hi everyone,

 

I finally got over 7000 products imported, the admin section is fine but I am receiving a Internal Server Error for the rest of the site (anything in the catalog/ directory).

 

I'm not sure why. Anyone have a clue?

 

The error log shows: Premature end of script headers: index.php

 

I would back-track any changes to the catalog side. Remove any recent changes or restore files from any recent changes. The errors are far too vague to arrive at any conclusions.

Link to comment
Share on other sites

yeah it is v_products_image it was just a typo....

 

 

 

 

Here is my easy populate settings:

Settings & Info

 

EP vers: 2.76g-MS2

osCommerce 2.2-MS2

OS:

HTTP: Apache/2.2.6 (Unix) mod_ssl/2.2.6 OpenSSL/0.9.8g

DB: MySQL 5.0.24a-log

PHP: 4.4.7 (Zend: 1.3.0)

 

Temp Directory:

/mnt/w0901/d18/s35/b02de28c/www/rickiesdiscountelectronics.com//rickiesdiscountelectronics/mystore//catalog/temp/

Temp Dir is Writable

Magic Quotes is: off

register_globals is: on

Split files on: 200 records

Model Num Size: 30

Price with tax: false

Calc Precision: 2

Replace quotes: false

Field seperator: comma

Excel safe output: true

Preserve tab/cr/lf: false

Category depth: 7

Enable attributes: true

SEF Froogle URLS: false

More Pics: false

Unknown Pics: false

HTC: false

SPPC: false

Extra Fields: false

 

 

 

 

 

 

yeah it updates everything when i reupload...but pictures dissapear

 

 

well right now giving u my site url will not work becasue i dont have the store moved over to live yet ...so u will not be able to view it.

 

but here it is right now

 

http://rickiesdiscountelectronics.com/rick...store//catalog/

 

 

when i right click on my images here is where it says its taking one of the images from

http://rickiesdiscountelectronics.com/rick...es/007-0002.jpg

 

which is the right place and that is where the images are located

 

I'm only hoping you have read the manual. If not, please do, all of it, whether it pertains to your issue or not. Its prerequisite reading for my help. When you reach the bottom, there is a little section on how to ask for help and where.

 

I see your posted the EP settings, good. What I don't see is the sample of the file you are uploading that was asked for in the how to ask for help section of the manual. geoffreywalton even asked for a sample of what you put in the image column. I know its frustrating, but you need to stay calm, cool, collected, and read carefully to resolve these issues.

 

[stepping down from soap box]

 

let take a look at what you have posted...

 

Your temp directory [/mnt/w0901/d18/s35/b02de28c/www/rickiesdiscountelectronics.com//rickiesdiscountelectronics/mystore//catalog/temp/]

 

There are 2 problems here, most likely pertaining to bad settings in your configure.php file. At the top of easypopulate.php there are detail instructions on how the items in the configure.php are setup and how they work together. You should go over that one more time and make adjustments until you have no double slashes in your paths and URLs. It occurred twice in your path, that would be 2 problems. This can affect other functions in your shop, but doesn't appear to be your primary issue with the images. There should also be lots and lots of help posts in the forums on how to get the config correct.

 

Next...

 

Your header image seems to be working fine, so there shouldn't be a permissions problem (even though there is a double slash in the URL):

http://rickiesdiscountelectronics.com/rickiesdiscountelectronics/mystore//catalog/images/rickiesimage.jpg

 

Next...

 

you posted a link to an image. The link is "not found" on your server. That tells me the image is not where you think it is, or the name is not correct.

http://rickiesdiscountelectronics.com/rickiesdiscountelectronics/mystore//catalog/images/007-0002.jpg

The first thing you need to do is correct the URL until you can see the image in your browser. If this URL is correct (which is isn't), you should be able to FTP to your site, go to that directory and find BOTH your header image (above) and this file name. My guess is you will not find this image there, but maybe in a sub-directory.

 

Find this image, and post a working URL to this image, and I will tell you what goes in your image column for the EP CSV upload.

Link to comment
Share on other sites

I would back-track any changes to the catalog side. Remove any recent changes or restore files from any recent changes. The errors are far too vague to arrive at any conclusions.

My hosting company said the following:

 

"It looks like there might be some incompatibilities between the version of OSCommerce you're using and the new version of PHP. We recommend that you try updating to the latest version of OSCommerce."

 

I'm using version oscommerce-2.2rc2a.

 

I believe this host uses PHP 5.2. Could that be the problem?

 

The only thing I've done recently is upload the product list for EP.

Link to comment
Share on other sites

My hosting company said the following:

 

"It looks like there might be some incompatibilities between the version of OSCommerce you're using and the new version of PHP. We recommend that you try updating to the latest version of OSCommerce."

 

I'm using version oscommerce-2.2rc2a.

 

I believe this host uses PHP 5.2. Could that be the problem?

 

The only thing I've done recently is upload the product list for EP.

unfortunately this issue would be off-topic here. This topic is for easypopulate issues only. But I would add that RC2a is suppose to be compatible with PHP and MySQL 5. If you have not added any contributions that would be incompatible with php5, I would doubt that to be the issue.

 

I would start by looking for recently posted similar issues in the general support area. Maybe try reuploading the customer side of the shop.

Link to comment
Share on other sites

I just downloaded this and another called add weight to options, but this doesn't seem to pick up on the weight. Is there something I can do to make it work?

 

probably surfalot can tell you more, but what I think is that Easy Populate works fine with standard weight field, not with some weight option you added. I don't know what additional weight mode you installed, but EP just don't work fith thesse new fields.

I use weight field which come with standard RC2 installation and don't have any problem with importing or exporting weight. Probably you should change some code in order EP to pick up new field.

EP actually has an instruction how to make it work with additional fields, so probably it applies to your case also.

Computers777dotcom

Link to comment
Share on other sites

unfortunately this issue would be off-topic here. This topic is for easypopulate issues only. But I would add that RC2a is suppose to be compatible with PHP and MySQL 5. If you have not added any contributions that would be incompatible with php5, I would doubt that to be the issue.

 

I would start by looking for recently posted similar issues in the general support area. Maybe try reuploading the customer side of the shop.

 

Okay, but I think it is related to EP. I just went to phpmyadmin and emptied the category & product table and then the rest of the site worked.

 

Any thoughts as to why after I use EP the rest of the site won't work? Would the problem lie in my excel doc? I save it as a txt file and upload.

 

I'm stumped.

Link to comment
Share on other sites

Okay, but I think it is related to EP. I just went to phpmyadmin and emptied the category & product table and then the rest of the site worked.

 

Any thoughts as to why after I use EP the rest of the site won't work? Would the problem lie in my excel doc? I save it as a txt file and upload.

 

I'm stumped.

Hmm, it seems if I do less products at a time everything is fine.

Edited by erikajune
Link to comment
Share on other sites

Okay, but I think it is related to EP. I just went to phpmyadmin and emptied the category & product table and then the rest of the site worked.

 

Any thoughts as to why after I use EP the rest of the site won't work? Would the problem lie in my excel doc? I save it as a txt file and upload.

 

I'm stumped.

 

easypopulate can't add to the shop's database anything more then the osCommerce admin can do. If your shop malfunctions due to data added to the products, it still wouldn't be an easypopulate issue, it would be a problem in the shop's front end code not being able to display the products.

 

You should pay close attention to your shop as you import the data so, at least, you can narrow down which product(s) you think have caused the issue.

 

Having said that, I would certainly be most interested in knowing what data caused that.

Link to comment
Share on other sites

Hi I tried to upload my products from one store to another using Easy Populate but only the Category names are added to my new store, there are no products uploaded under each Category(empty-0 products) even though I have about 10 products under each Categories in my first store. Please let me know what I'm doing wrong.

Link to comment
Share on other sites

Hi I tried to upload my products from one store to another using Easy Populate but only the Category names are added to my new store, there are no products uploaded under each Category(empty-0 products) even though I have about 10 products under each Categories in my first store. Please let me know what I'm doing wrong.

 

Check if your file has categories fields like v_categories_name_1_1 (for parent category), v_categories_name_2_1 (for subcategory), v_categories_name_2_1 .....(empty if doesn't exist).

Computers777dotcom

Link to comment
Share on other sites

I have gotten most of this figured out but when I get to this section below I am so confused where do I put all this?

 

THE DIR_WS_CATALOG & DIR_FS_CATALOG SETTINGS

 

DIR_WS_CATALOG & DIR_FS_CATALOG are set in your /catalog/admin/includes/configure.php

They may look like this if your shop is in the root of your web space.

If you have something different, don't just change it to this.

There is probably a good reason. I'm providing this as a reference

to you-all. The DIR_FS_DOCUMENT_ROOT, the DIR_WS_CATALOG, and the

DIR_FS_CATALOG settings all combine to create the temp location below.

 

define('DIR_WS_CATALOG', '/');

define('DIR_FS_CATALOG', DIR_FS_DOCUMENT_ROOT . DIR_WS_CATALOG);

 

 

 

THIS EP_TEMP_DIRECTORY SETTING

 

Next, the following setting should set so that the DIR_FS_CATALOG setting

plus this following setting makes a correct full path to your temporary

location, like this: /home/myaccount/public_html/temp/

 

if /home/myaccount/public_html/temp/ is the correct full path to your temp

location, then:

 

define ('EP_TEMP_DIRECTORY', DIR_FS_CATALOG . 'temp/');

 

is the correct setting here. Wow, I really hope this stops the forum traffic about this !!

 

////////////////////////////////////////////////////////////////////////// */

// **** Temp directory ****

define ('EP_TEMP_DIRECTORY', DIR_FS_CATALOG . 'temp/');

 

 

//**** File Splitting Configuration ****

// we attempt to set the timeout limit longer for this script to avoid having to split the files

// NOTE: If your server is running in safe mode, this setting cannot override the timeout set in php.ini

// uncomment this if you are not on a safe mode server and you are getting timeouts

// set_time_limit(330);

 

// if you are splitting files, this will set the maximum number of records to put in each file.

// if you set your php.ini to a long time, you can make this number bigger

define ('EP_SPLIT_MAX_RECORDS', 300); // default, seems to work for most people. Reduce if you hit timeouts

//define ('EP_SPLIT_MAX_RECORDS', 4); // for testing

 

 

//**** Image Defaulting ****

// set them to your own default "We don't have any picture" gif

//define ('EP_DEFAULT_IMAGE_MANUFACTURER', 'no_image_manufacturer.gif');

//define ('EP_DEFAULT_IMAGE_PRODUCT', 'no_image_product.gif');

//define ('EP_DEFAULT_IMAGE_CATEGORY', 'no_image_category.gif');

 

// or let them get set to nothing

define ('EP_DEFAULT_IMAGE_MANUFACTURER', '');

define ('EP_DEFAULT_IMAGE_PRODUCT', '');

define ('EP_DEFAULT_IMAGE_CATEGORY', '');

 

 

//**** Status Field Setting ****

// Set the v_status field to "Inactive" if you want the status=0 in the system

define ('EP_TEXT_ACTIVE', 'Active');

define ('EP_TEXT_INACTIVE', 'Inactive');

 

// Set the v_status field to "Delete" if you want to remove the item from the system

define ('EP_DELETE_IT', 'Delete');

Link to comment
Share on other sites

In fact, my database needs an update every night, is that possible with easy populate? How can we set that in?

 

Anybody can give some ideas?

 

regards

Link to comment
Share on other sites

I have gotten most of this figured out but when I get to this section below I am so confused where do I put all this?

 

THE DIR_WS_CATALOG & DIR_FS_CATALOG SETTINGS

If your first read through the settings in the easypopulate.php file don't make sense, just leave it as it is. It all should work fine for most people's need without changes.

 

The most important thing is that EP needs a temp directory to work with your upload files.

 

the temp directory needs to be created (and verified) as a location in your site's web storage. The information (top of th eEP file) about how the location is derived was suppose to help you understand where to look and what to look for, IF the default location is not suitable to you.

 

Assuming (at first) that your shop is already setup correctly, login to your admin and open the easypopulate page. If you are using the latest version of mine (v2.76g), you should see the settings on the right of the page. The Temp Directory setting is what all that is about. Below that setting will be a statement as to whether the the directory is writable or not. This is important.

 

If that directory (path) is already correct, and the statement under it says "Temp Dir is Writable", then you are all set. If not, you will only need to create it, and make sure the permissions are 644 or 777 depending on your host environment. If you are not sure how to create the directory and set the permissions to writable from PHP, talk with your host.

 

By default the location will be a "temp" directory under your catalog directory. something like this:

Temp Directory:

/home/surfalot/public_html/catalog/temp/

or maybe:

/home/surfalot/public_html/temp/

if you still aren't sure what to do, post your list of settings from the EP mainpage.

Link to comment
Share on other sites

Hi I tried to upload my products from one store to another using Easy Populate but only the Category names are added to my new store, there are no products uploaded under each Category(empty-0 products) even though I have about 10 products under each Categories in my first store. Please let me know what I'm doing wrong.

make sure you are using the same version of EP in both locations. if you are using my latest version, see the how to ask for help section of the manual and follow those steps to provide the info necessary to provide further assistance.

Link to comment
Share on other sites

In fact, my database needs an update every night, is that possible with easy populate? How can we set that in?

 

Anybody can give some ideas?

 

regards

 

is this a continuation of a previous question? (In fact) ?

not sure what you are asking other then, yes, EP can be used as often as you require.

Link to comment
Share on other sites

is this a continuation of a previous question? (In fact) ?

not sure what you are asking other then, yes, EP can be used as often as you require.

 

Can that be set autmaticlly? So that i don't have to look at it?

 

Regards

Link to comment
Share on other sites

If your first read through the settings in the easypopulate.php file don't make sense, just leave it as it is. It all should work fine for most people's need without changes.

 

The most important thing is that EP needs a temp directory to work with your upload files.

 

the temp directory needs to be created (and verified) as a location in your site's web storage. The information (top of th eEP file) about how the location is derived was suppose to help you understand where to look and what to look for, IF the default location is not suitable to you.

 

Assuming (at first) that your shop is already setup correctly, login to your admin and open the easypopulate page. If you are using the latest version of mine (v2.76g), you should see the settings on the right of the page. The Temp Directory setting is what all that is about. Below that setting will be a statement as to whether the the directory is writable or not. This is important.

 

If that directory (path) is already correct, and the statement under it says "Temp Dir is Writable", then you are all set. If not, you will only need to create it, and make sure the permissions are 644 or 777 depending on your host environment. If you are not sure how to create the directory and set the permissions to writable from PHP, talk with your host.

 

By default the location will be a "temp" directory under your catalog directory. something like this:

Temp Directory:

/home/surfalot/public_html/catalog/temp/

or maybe:

/home/surfalot/public_html/temp/

if you still aren't sure what to do, post your list of settings from the EP mainpage.

WooHoo I fnally got all my items in my store!!!! ::::doing the happy dance:::: now new issue popped up none of the images or prices show what did I do wrong ?

Link to comment
Share on other sites

Hi, I am trying to set up a new store with downloadable products. I have set up both osCommerce and osCMax as "test beds", and loved the idea of using EP to compile the database info. I duly downloaded a file with test items, and was surprised when I opened the file to discover that the attributes products_attributes_filename, products_attributes_maxdays, and products_attributes_maxcount, do not appear in it.

 

I assumed it was something I was doing wrong (or failing to do) however having spent several days reading threads and doing searches, and reading hundreds of posts ranging from 2003 to date including a lot saying the same as this one, I have failed to find any that have a definitive reply/solution, and it seems to me that maybe EP still doesn't support this.

 

Could someone please tell me whether this is so, or if I am wrong point me straight to a working version, or a post/contribution/hack/workaround... in short anything that will "do the trick".

 

Thanks in advance for any help.

Link to comment
Share on other sites

Check if your file has categories fields like v_categories_name_1_1 (for parent category), v_categories_name_2_1 (for subcategory), v_categories_name_2_1 .....(empty if doesn't exist).

Exactly my question, why doesn't it (v_categories_name_1_1') exist when i download on the spread sheet? Do I have to edit the easypopulate code to insert this?

Link to comment
Share on other sites

Exactly my question, why doesn't it (v_categories_name_1_1') exist when i download on the spread sheet? Do I have to edit the easypopulate code to insert this?

 

Figured it out, I had too many Product Attributes. Excel was truncating v_categories_name_1_1 section. Categories are working fine now the only problem I'm having now is the admin section seems to have the products in the right category folder but when i visit my website everything seems to be messed up; wrong products and model numbers under the categories... Please let me know how to fix this.

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...