Community Add-Ons

This is a complete package.

*****************************************************************************
** Exports from versions previous to EP v2.76g will not work correctly **
** since the category header names have changed in this version !! **
*****************************************************************************

+ Fixed an instruction typo.
+ Added support for Product Specials
+ Fixed problem where decimals were being dropped from the attributes pricing.
+ Integrated Product Specials support with SPPC specials
+ Added extra checks to make sure attribute data is not being used before deleting a product.
+ Added support for UltraPics 2.05 contributed by josequituc - 28 May 2009
http://www.oscommerce.com/community/contributions,1642
+ Added support for PDF File Upload and Display V2.01 contributed by josequituc - 28 May 2009
http://addons.oscommerce.com/info/2807
+ Added support for Multi Vendor System (MVS) 1.2
http://addons.oscommerce.com/info/4129
+ Added Support for Additional Images 2.1.1
http://addons.oscommerce.com/info/1032
+ Added Support for Cross Sell 2.6
http://addons.oscommerce.com/info/1415

PLEASE SEE THE DOCS ON HOW TO ASK FOR HELP
(not kidding, you may not get an answer if you ignore this plea)
http://forums.oscommerce.com/index.php?showtopic=162244

file easypopulate 2.76h with contribution PDF File Upload and Display
http://addons.oscommerce.com/info/2807

and UltraPics - MS2 Image Addon Pack!
http://www.oscommerce.com/community/contributions,1642

To install just unzip easypopulate.zip and rewrite the orginal. BACKUP the original file

thank you

The instructions are wrong - I wonder why no one noticed this for many months.

Instructions talk of editing a file at location.

/catalog/admin/boxes/catalog.php

the correct location is
/catalog/admin/includes/boxes/catalog.php


Frank
test site at www.kalron.com

This is a complete package.

*****************************************************************************
** Exports from versions previous to EP v2.76g will not work correctly **
** since the category header names have changed in this version !! **
*****************************************************************************
+ Added HTML Docs organized and edited by Stuart Newton (stu2000) on 05 Jan 2009
+ Fixed Available Date unset value to NULL instead of a zero date.
+ Fixed Category Images being cleared when the column was not included in the import.
+ Fixed file extension changing when EP splits files.
+ Fixed issue where txt file types were excluded in file list in the import from temp folder.
+ Added feature to keep old Date Added date when column is included, but field is empty.
+ Fixed issue where Extra Fields was not finding the correct product ID for the model number for an update.
+ Fixed issue reported by anisrehan, 24 Jan 2009 where the custom download form setup correctly.

PLEASE SEE THE DOCS ON HOW TO ASK FOR HELP
(not kidding, you may not get an answer if you ignore this plea)
http://forums.oscommerce.com/index.php?showtopic=162244

I have found a little bit confusing error at line 1338.
the line is

-------------
<?php echo tep_draw_form('custom', 'easypopulate.php', 'id="custom"' . ((defined('SID') && tep_not_null(SID)) ? '&'.tep_session_name().'='.tep_session_id() : ''), 'get'); ?><?php if (defined('SID') && tep_not_null(SID)) { echo tep_draw_hidden_field(tep_session_name(), tep_session_id()); } ?>
-------------

and I have changed it to:
-------------
<?php echo tep_draw_form('custom', 'easypopulate.php', ((defined('SID') && tep_not_null(SID)) ? '&'.tep_session_name().'='.tep_session_id() : ''), 'get','id="custom"'); ?><?php if (defined('SID') && tep_not_null(SID)) { echo tep_draw_hidden_field(tep_session_name(), tep_session_id()); } ?>
-------------

Also uploading the file.
Hope the next package includes the corrected one.

I had some problems with the previous file download-contrib. I might have worked something out here. Haven't tried it too much but it seems to be working. I have oscommerce rc2a and super download shop but i'm not sure if you need the sds, will try this tomorrow. Observe that this is working for me. Might not work for you so don't replace it on a live shop. Only easypopulate.php in this file.

NOTE: If you have trouble opening the zip, rename it to a .rar file and try again.

I worked in the last updates and fixes.
Found errors myself and fixed them too.

Complete Package.

Added Product Extra Fields section to the documentation and hopefully enhanced the section on how to resolve problems.

Also emphasised EP does not upload image files and expanded on permissions.

Contains installation and EP manual only.

The Manual explains all the settings and how to get the most from this contribution.

** Exports from previous versions of EP will not work correctly since the **
** category header names have changed in this version !! **

This fix support exports from previous versions of EP
by renameming to correct category header names

The recent file format includes the export time, but the format is a bit strange, it displays the hour twice instead of hour-minute.

If you want to fix this, change the code around line532
from
$EXPORT_TIME = strftime('%Y%b%d-%H%I');
to
$EXPORT_TIME = strftime('%Y%b%d-%H%M');

NO files uploaded

This contains the easypopulate.php file only. It has been fixed to work with php5. If you have been getting a blank screen when uploading a file with php5/mysql5, this should fix it for you.

1. array_walks fixed
2. auto_increment ids removed from inserts
3. file variables (name, size, etc) that were empty in php5 now initialized using $_FILES values

This is a small modification to surfalot march 18 2008 update

i have add products cost field in the easy populate import export.

This works only if margin report (Margin_report_v3.00) contribution is installed.

Use at own risk, its working with mine :)
only easypopulate.php is added,
you may overwrite your file.

i made this coz the extra field setting didn't working with my OsCommerce

Cheerz

This is a complete package.

+ Added easy method to define custom fields to the "products" & "products_description" tables.
+ Added multi-language category support.
*****************************************************************************
** Exports from previous versions of EP will not work correctly since the **
** category header names have changed in this version !! **
*****************************************************************************
+ Added import selector to specify to only add new products from the import file, or
to only update products from the import file, or normal operation which does both.
Thanks to Paul H. for contributing this!
+ Fixed issues with RC1 & RC2 bouncing to login screen.
+ Fixed manufacturer not inserting when it contained quotes.
+ Fixed category not inserting when it contained quotes.
+ Fixed attributes not inserting when it contained quotes.
+ Fixed manufacturer not inserting with an error about:
1364 - Field 'manufacturers_url' doesn't have a default value
+ Adjusted flawed logic that checked for a quote at the end of an input field but not
the beginning, then removed first and last chars. Now checks the first and last chars
before trimming the field.
+ Added an alternate field parcer to the fgetcsv() PHP function which has had issues. Routine based
on posted code offered by Maynard. (slightly modified)
+ Some W3C issues reported by mauriziomagnino. Some not for backward compatibility with EP.
+ Added instructions for dealing with non-Roman character sets, such as cyrillic. (thanks to Richard!)
+ Changed Extra fields contribution support to use Model Number instead of product ID. (thanks to geoffreywalton!)

PLEASE SEE THE DOCS ON HOW TO ASK FOR HELP
(not kidding, you may not get an answer if you ignore this plea)
http://forums.oscommerce.com/index.php?showtopic=162244

Easy Populate 2.76f-MS2 r1

This enhancement allows you to update extra fields created with contribution 2022, Product Extra Field
using the Model no as the key rather than extra field key fields.

Allows update and insert, but does assume the model no supplied is valid.

Geoffrey Walton

Um mit Easypopulate auch über die Importdatei Löschen zu können mache man folgendes.

In der Datei easypopulate.php
Suche nach

$deleteit

alles darunter muss so aussehen.
//
global $active, $inactive, $zero_qty_inactive, $deleteit;
$active = 'Active';
$inactive = 'Inactive';
$deleteit = 'Delete'; // jetzt funktioniert es
$zero_qty_inactive = true;
//

Dann suche nach

$row['v_status'] = $inactive;

und ersetze es mit

$row['v_status'] = $inactive;
$row['v_status'] = $deleteit;

suche

function walk( $item1 ) {
global $filelayout, $filelayout_count, $modelsize;
global $active, $inactive, $langcode, $default_these, $deleteit, $zero_qty_inactive;
global $epdlanguage_id, $price_with_tax, $replace_quotes;
global $default_images, $default_image_manufacturer, $default_image_product, $default_image_category;
global $separator, $max_categories;
// first we clean up the row of data

ersetzte mit

//
function walk( $item1 ) {
global $filelayout, $filelayout_count, $modelsize;
global $active, $inactive, $langcode, $default_these, $zero_qty_inactive, $deleteit;
global $epdlanguage_id, $price_with_tax, $replace_quotes;
global $default_images, $default_image_manufacturer, $default_image_product, $default_image_category;
global $separator, $max_categories;
// first we clean up the row of data

//

dann suche nach

if ($zero_qty_inactive && $v_products_quantity == 0) {
// if they said that zero qty products should be deactivated, let's deactivate if the qty is zero
$v_db_status = '0';
}

und darunter dieses einfügen

// setzt den status nach der Angabe unter $deleteit in der Importdatei.
if ($v_status == $deleteit){
// they told us to deactivate this item
$v_db_status = '99'; //status 99 zum löschen
}


suche

array_walk($items, 'print_el');
echo "<p class=smallText>No products_model field in record. This line was not imported <br>";
echo "<br>";

und setzte darunter

mysql_query("DELETE products, products_to_categories, products_description FROM products, products_to_categories, products_description WHERE products.products_id = products_to_categories.products_id AND products.products_id = products_description.products_id AND products.products_status = 99");
echo "<br>";

Fertig!!
!!!!!!!!!!!!!!Achtung!!!!Achtung!!!!Achtung!!!!Achtung!!!!Achtung!!!!Achtung!!!!

Es werden keine Kategorien gelöscht. Dies muss man weiterhin per Hand tätigen.

/////////////////////////////////////////////////////////////////////////////////////////////////
Was ich noch nicht hinbekommen habe ist das auch der Status Delete Angezeigt wird.

Mann kann den Status Delet aber auch mit Update angeben.
dazu mache folgendes

Suche

echo "<font color='black'> Updated</font><br>";

und ersetzte mit

echo "<font color='blue'>".$deleteit."</font> OR";
echo "<font color='black'> Updated</font><br>";


Es wird jetzt immer auch nur beo Update Delete mit Angezeigt.

Wem das nichts aus macht ansonsten muß man diesn Schritt nicht machen.

Ende

When using german "Umlaute" like ÄäÖöÜü at the Beginning of some text, they will disappear when importing some csv-file.

Download-File just includes this description-text.

To fix this problem, open easypopulate.php an find
while($line = fgetcsv($fp,32768,$ep_separator)) at row 997

Replace the whole while-Block with the following:

while($lineRead = fgets($fp)) // read new line (max 32K bytes) // Torben
{
$line=explode($ep_separator,$lineRead); // Torben
unset($line[(sizeof($line)-1)]); // remove EOREOR at the end of the array
$readed[] = $line; // add to array we will process later
}

Hope this was helpfull.

Regards,
Torben

The contrib below (by kthawat on 6 May 2007) does not work with "Price Break" alone. If you don't have the SPPC contrib installed it crashes.

I think the SPPC fields and tables are throwing everything off. Here is the error:

"1146 - Table 'bdadmin_install_1185327443.TABLE_PRODUCTS_GROUPS' doesn't exist

SELECT customers_group_price, customers_group_id, products_price1, products_price2, products_price3, products_price4, products_price5, products_price6, products_price7, products_price8, products_price1_qty, products_price2_qty, products_price3_qty, products_price4_qty, products_price5_qty, products_price6_qty, products_price7_qty, products_price8_qty, products_qty_blocks FROM TABLE_PRODUCTS_GROUPS WHERE products_id = 46 ORDER BY customers_group_id

[TEP STOP]"

I checked my SQL database and found that I do not have "TABLE_PRODUCTS_GROUPS", "customers_group_proce", or "customers_group_id". My guess is that these are the SPPC tables and fields. Am I right?

Is there any way to get around this?

fix minor bug :
<br> to <br />
line 1164
tep_draw_form('custom', 'easypopulate.php', 'id="custom"', 'get');
to
tep_draw_form('custom', 'easypopulate.php', 'id=custom', 'get');
line 18xx
fix valid W3C code :
str_replace('""',"&#34"
to
str_replace('""',"&#34;"
etc. etc.
error to Case Sensitive
<INPUT
to
<input
not implementation
easypopulate_functions.php
moved to functions directory

PLEASE SEE THE DOCS ON HOW TO ASK FOR HELP
http://forums.oscommerce.com/index.php?showtopic=162244

This contribution combines Easy Populate 2.76 and QTPro by allowing the user to populate all fields in the products_stock table.



It will insert:

Product ID
Quantity
Attributes
Item Weight
Item Number
Item Code

You’ll have to edit the second spreadsheet manually.

Please Note: The column headers for the original spreadsheet of EP have been altered.

MUST HAVE QTPro and Easy Populate already installed in order to work.

This is based on the easy populate 2.76f-MS2 for file downloads to work
I did not do this work but hired some one to make the modifications for
me.

I haven't done a compare on the EP_v2_76f_r1_MS2 for the differnces

My shop I use download products with super download shop
I was upgradeing an older version of MS2 to the latest and
needed a way for the downloads to work instead of having to
add them all in by hand.

Super Download Shop can be found here
http://www.oscommerce.com/community/contributions,4868/

This is a complete package.

In this revision:
+ Removed EVEN more globals use.

SUPPORT
I will be watching this thread for support. I will be supporting this version only.
Due to time constraints I will help find problems with this version as I uploaded it and
I will not be helping integrate other contributions, sorry.
PLEASE SEE THE DOCS ON HOW TO ASK FOR HELP
http://forums.oscommerce.com/index.php?showtopic=162244

This is a complete package.

+ Fixed issue with the product status. it wasn't respecting the value of a product already in the db.
+ removed some unneeded defaulted values.
+ Fixed SQL error in revised SPPC contribution support and moved it to tested status.
+ Fixed an issue where Date available could not be NULL
+ Removed more globals use in the importing routine.
+ fixed issue with New Categories not inserting due to wrong language variable.

SUPPORT
I will be watching this thread for support. I will be supporting this version only.
Due to time constraints I will help find problems with this version as I uploaded it and
I will not be helping integrate other contributions, sorry.
PLEASE SEE THE DOCS ON HOW TO ASK FOR HELP
http://forums.oscommerce.com/index.php?showtopic=162244

Sorry folks, sample_output_file.txt was corrupt and I left a setting non-default. The rest all the same.

This is a complete package.

Most modifications were made because of problems reported in the forum. Thanks to all that helped debug.

I'll bet y'all thought I wasn't keeping track....

+ cleaned up some redundant code.
+ cleaned up the docs for readability.
+ Removed various excess files.
+ fixed a problem where the currency precision was being ignored.
+ Added a currency precision configuration item.
+ Added code to pick the Excel list separator based on the language choice in your web browser.
see post 4939: http://forums.oscommerce.com/index.php?showtopic=162244&st=4920
+ Removed all global use for those with global registration restricted servers.
see post: (almost every post) :)
+ Set default Products Model to 12 since orginal osC database size is 12 chars - thanks HallMarc
+ Set Froogle's URLs to osC standard constants eliminating user configuration - thanks HallMarc
+ Fixed Froogle's outdated code - thanks HallMarc
see post: 4854 http://forums.oscommerce.com/index.php?showtopic=162244&st=4840&p=984338&#entry984338
+ Fixed an issue where Product Descriptions and URLs were being blanked when only the
Product Name was uploaded.
+ Fixed problem with PHP 5 and array_walk() function reported in forum.
See post: 4827 http://forums.oscommerce.com/index.php?showtopic=162244&st=4820&p=982309&#entry982309
(note: function name has changed to avoid confusion)
+ cleared-up an issue with the Date Added being assigned to the Date Available & other date issues.
+ Fixed issue with CURRENT_TIMESTAMP failing to set the Date Added date to a product import.
See post: 5036 http://forums.oscommerce.com/index.php?showtopic=162244&st=5020
(Note: I changed this fix since CURRENT_TIMESTAMP didn't work with all servers)
+ Fixed issue with products status not keeping original value.
See Post: 5315 http://forums.oscommerce.com/index.php?showtopic=162244&st=5300&p=1030113&#entry1030113
+ Fixed a problem where category insertions where not handled correctly in multi-language shops.
This does not yet offer multi-language category support. :( But will at least setup the
first imported language and other languages so that the admin works correctly.
See post: 5671 http://forums.oscommerce.com/index.php?showtopic=162244&st=5660&p=1059786&#entry1059786
+ Changed the working (current) language to be the current admin language instead of the
hidden osC default language setting. This should allow those with multiple Category languages
to work with them by changing the current language from the admin main page when importing that
specific language. OK, this and the last fix makes it possible to work with multi-language cats.
But its still not an ideal solution.
See post: 5503 http://forums.oscommerce.com/index.php?s=&showtopic=162244&view=findpost&p=1042183
+ Fixed a bug where negative product attributes where being imported with a double negative.
See Post 5517: http://forums.oscommerce.com/index.php?showtopic=162244&st=5500
+ fixed a problem with inclusion of the easypopulate functions file. function_exists syntax was wrong.
+ Added support for category images. (v_categories_image_1, v_categories_image_2, etc.)
+ Included pui30576's fix for SPPC (9 Apr 2007)
+ Included OPTIONAL Extra Field Contribution support offered by minhmaster DEVSOFTVN
+ Included support for product deletes thanks to bruyndoncx
see http://forums.oscommerce.com/index.php?showtopic=235945&hl=
+ Included a contribution by PerlSOL to populate a dropdown list from your temp directory
for easy picking uploaded files for import.
see post: 5908 http://forums.oscommerce.com/index.php?showtopic=162244&st=5900&p=1101458&#entry1101458

SUPPORT
I will be watching this thread for support. I will be supporting this version only.
Due to time constraints I will help find problems with this version as I uploaded it and
I will not be helping integrate other contributions, sorry.
PLEASE SEE THE DOCS ON HOW TO ASK FOR HELP
http://forums.oscommerce.com/index.php?showtopic=162244

This is a complete package.

Most modifications were made because of problems reported in the forum. Thanks to all that helped debug.

I'll bet y'all thought I wasn't keeping track....

+ cleaned up some redundant code.
+ cleaned up the docs for readability.
+ Removed various excess files.
+ fixed a problem where the currency precision was being ignored.
+ Added a currency precision configuration item.
+ Added code to pick the Excel list separator based on the language choice in your web browser.
see post 4939: http://forums.oscommerce.com/index.php?showtopic=162244&st=4920
+ Removed all global use for those with global registration restricted servers.
see post: (almost every post) :)
+ Set default Products Model to 12 since orginal osC database size is 12 chars - thanks HallMarc
+ Set Froogle's URLs to osC standard constants eliminating user configuration - thanks HallMarc
+ Fixed Froogle's outdated code - thanks HallMarc
see post: 4854 http://forums.oscommerce.com/index.php?showtopic=162244&st=4840&p=984338&#entry984338
+ Fixed an issue where Product Descriptions and URLs were being blanked when only the
Product Name was uploaded.
+ Fixed problem with PHP 5 and array_walk() function reported in forum.
See post: 4827 http://forums.oscommerce.com/index.php?showtopic=162244&st=4820&p=982309&#entry982309
(note: function name has changed to avoid confusion)
+ cleared-up an issue with the Date Added being assigned to the Date Available & other date issues.
+ Fixed issue with CURRENT_TIMESTAMP failing to set the Date Added date to a product import.
See post: 5036 http://forums.oscommerce.com/index.php?showtopic=162244&st=5020
(Note: I changed this fix since CURRENT_TIMESTAMP didn't work with all servers)
+ Fixed issue with products status not keeping original value.
See Post: 5315 http://forums.oscommerce.com/index.php?showtopic=162244&st=5300&p=1030113&#entry1030113
+ Fixed a problem where category insertions where not handled correctly in multi-language shops.
This does not yet offer multi-language category support. :( But will at least setup the
first imported language and other languages so that the admin works correctly.
See post: 5671 http://forums.oscommerce.com/index.php?showtopic=162244&st=5660&p=1059786&#entry1059786
+ Changed the working (current) language to be the current admin language instead of the
hidden osC default language setting. This should allow those with multiple Category languages
to work with them by changing the current language from the admin main page when importing that
specific language. OK, this and the last fix makes it possible to work with multi-language cats.
But its still not an ideal solution.
See post: 5503 http://forums.oscommerce.com/index.php?s=&showtopic=162244&view=findpost&p=1042183
+ Fixed a bug where negative product attributes where being imported with a double negative.
See Post 5517: http://forums.oscommerce.com/index.php?showtopic=162244&st=5500
+ fixed a problem with inclusion of the easypopulate functions file. function_exists syntax was wrong.
+ Added support for category images. (v_categories_image_1, v_categories_image_2, etc.)
+ Included pui30576's fix for SPPC (9 Apr 2007)
+ Included OPTIONAL Extra Field Contribution support offered by minhmaster DEVSOFTVN
+ Included support for product deletes thanks to bruyndoncx
see http://forums.oscommerce.com/index.php?showtopic=235945&hl=
+ Included a contribution by PerlSOL to populate a dropdown list from your temp directory
for easy picking uploaded files for import.
see post: 5908 http://forums.oscommerce.com/index.php?showtopic=162244&st=5900&p=1101458&#entry1101458

SUPPORT
I will be watching this thread for support. I will be supporting this version only.
Due to time constraints I will help find problems with this version as I uploaded it and
I will not be helping integrate other contributions, sorry.
PLEASE SEE THE DOCS ON HOW TO ASK FOR HELP
http://forums.oscommerce.com/index.php?showtopic=162244

Not a complete Package.

The full package is Easy populate 2.78-Ms2
Easy populate + Extra filed - Separate price per customer 4.11 + English + Italian
By davide.duca

This contribution allow you to use EP with SPPC and Price break quantity up to 8 levels

I have tried install Easy Populate 2.76d-MS2 (with attributes) with SPPC v414 but seems that it doesn't work. (keep prompt me about extra column when activiated SPPC with EP) After some time, I discovered an extra field will be inserted into database if SPPC module activiated.(at least in my version.)

To let whole thing works, it should have following changes in easypopulate.php:

around line 2302-2341,
REPLACE
------------------------
INSERT INTO '.TABLE_PRODUCTS_GROUPS.'
VALUES
(
' . $v_customer_group_id_1 . ',
' . $v_customer_price_1 . ',
' . $v_products_id . ',
' . $v_products_price .'
)'
);
------------------
WITH
------------------

INSERT INTO '.TABLE_PRODUCTS_GROUPS.'
VALUES
(
' . $v_customer_group_id_1 . ',
' . $v_customer_price_1 . ',
' . $v_products_id . '
)'
);
--------------------------------

if you have X group, then delete all $v_products_price in X group within the SPPC module of EP.

p.s. not a complete package, download file include these text.

Mystic

Easy Populate 2.76d-MS2 (with attributes) - register globals off

habe EP für die Module Prod-Tabs und Artikelgrösse erweitert. hoffe es funkt so hablwegs - einfach austauschen

einige korrekturen

Easy Populate 2.76d-MS2 (with attributes) - register globals off

habe EP für die Module Prod-Tabs und Artikelgrösse erweitert. hoffe es funkt so hablwegs - einfach austauschen

Hi this is my FIRST time uploading anything to this site - so Please Backup and Test this properly, for I am just a newbie.

This is not a complete package - just the easypopulate.php file for Comparison use.

I previously installed the Short Description Mod - http://www.oscommerce.com/community/contributions,3123
And installed Easypopulate afterward.

This is just so that EP will also catch your Short Description field in the uploading and downloading proces.
Just do a search for "products_info" in my file and compare and add to yours.

Once again - this is if you've already installed the Short Descr Mod and want it to integrate with EasyPopulate.
I went through a lot of trial n error for this to work - so hopefully I'll save some ppl this head-ache (I'm still a newb)

This is a wonderful mod - Thanks a lot! Great time-saver!

Not complete package. Replacement easypopulate.php and an SQL file.

Run the SQL queries on your database using phpMyAdmin or similar. Replace your exisiting admin easypopulate.php 2.76d-MS2 file with this one.

Easypopulate variables are now set through the Configuration Admin interface. In addition, this contribution is register_globals off ready. Plus slight cosmetic change to message output to use the messageStack in keeping with osCommerce.

Tone.

Small modification of the easypopulate.php file submitted by surfalot (2.76d -MS2 package) to allow use on servers with register globals off.

Not a full package - zip file contains single php file.

Tone

This is a complete package.

I made these modifications primarily for compatibility with large product databases and easy use with MS excel.

+ unlike many other versions, this is still compatible with unmodified shops.
+ Added missing end php ?> tag to easypopulate_functions.php
+ Added Custom File Builder. Adds checkbox menu to select needed export fields.
Helps those with extremely large databases to select product sub-sets for export.
Allows sub-set selection by category, manufacturer, and status. (maybe should
add by language in the future).
+ Added on-the-fly downloads. Along with the Custom File Builder this helps those
with extremely large databases to actively stream the export and avoid time-outs.
All other types of export and temp dir file generators in this contribution builds
the entire download in server memory before sending to the export location.
On-the-fly downloads output the file as it is created saving server memory.
8000 products = over 50 meg file. As in previous versions, this still pulls
the entire product catalog in one SQL query for a complete download. Maybe
look for a more conservative approach to this in the future.
+ Added excel safe export/import option which will actually export and import the
osCommerce test database without problems. This also permits preserving and proper
handling of double and single quotes, tabs, and carriage returns in CSV files.
Export file can be directly opened with Excel, saved and reimported with ease.
+ moved files for other contributions to separate directory to avoid confusion.
+ Added visible settings display so when we export, we know what we're getting.
+ moved hardcoded DIR_FS_DOCUMENT_ROOT through-out script to the temp directory
setting at the page top so that it may be set to a location below the doc root
so non-public temp directories may be used.

+ These new features were only added to base v2.76c files and not carried over to
additional contribution files that existed in the v2.76c package.

SUPPORT
I will be watching this thread for support. I will be supporting this version only.
Due to time constraints I will help find problems with this version as I uploaded it and
I will not be helping integrate other contributions, sorry.
http://forums.oscommerce.com/index.php?showtopic=162244

contribution saisie produits dans excel

This is a fairly simple mod to Easy Populate (EP). It makes use of the “global $attribute_options_select;” option and creates an easy interface to select which options you wish to export. It add a second page that allows you to select what info you need. Your selection is stored in the database so you don’t have to set it every time you come back to EP, if you are always needing the same data. It also adds at the bottom of the main page the list of selected options.
Package is for modifications not new install. EP 2.76

There is a small bug in Davide Ducas contribution 2.90b:

if ($v_customer_price_4 != ''){
$result = tep_db_query('
INSERT INTO
'.TABLE_PRODUCTS_GROUPS.'
VALUES
an - ( - missing from here throws sql error while importing.

Deutsche Übersetzung für die Version 2.90
Basiert auf der deutschen Übersetzung von Dennis Lowery, Formulierungen etwas verändert und an
v2.9 angepaßt.

In the version 2.90b I have fixed a problem of import file.

For to use this version you need to install this contribs:

- Quantity Price Breaks for Separate Pricing Per Customer 1.02
- Separate Pricing Per Customer 4.11
- Extra fileds.

if you don't have installed e checked this easy polulate don't work!!!

I am surprised how many people are reporting this error and that it seems many people asking the same question aren't answered.

This is a problem in the easypopulate.php page trying to grab fields in the database that aren't there. It took me many hours myself to find the answer.
This problem in my case wasn't handled by running the update.sql file.

This is an easy way around it. Don't send me email if you can't figure this out.

I hope this helps

There is mass confusion below. Some versions have mods for other contributions hardcoded in and it's not clear to a new user which version will be appropriate for their needs.

Please consider before choosing a version of EP if you have particular needs for extra fields and functions, and read the descriptions of each EP contribution to pick one that will work for YOU.

=======================

The zip file attached is a repost of Mibble's EP 2.76, with just one very small change. I deleted an extra quotation mark on line 847 (after priceqty, as below).

<a href="easypopulate.php?download=tempfile&dltype=priceqty"">

This is the full package, with (optional) price break, master products and vendor email files which can be merged with the original file ***if you need them***.

Fixed problem of import file in 2.90 version

This language pack is an add on to the existing languages included with Easy populate. This pack supports

~ French
~ German
~ Spanish
~ Portuguese

This is just translations, you must first download Easy Populate.

First of all, many thank to Tim Wasson and dynamok for their work in creating one of the most useful osCommerce contributions around!

Unfortunately, it looks as though this contribution has been around for years with a huge flaw (okay, maybe "flaw" is too harsh, but if you had as many items in your database as I do you'd certainly see it that way). Easy Populate relies on the products_model database field, which is not indexed. While this may not be a problem if you don't have many products, using this contribution to add a large number of products to your web site may take hours or even days to finish. Run a single SQL command on your osCommerce database and you'll probably wonder, like I did, why nobody brought this up before.

ALTER TABLE `products` ADD INDEX `idx_products_model` ( `products_model` );

Before adding this index to my database, importing my huge list of products took twelve hours. Indexing the products_model column reduced that time to 30 SECONDS!

The attached text file includes some tips for automating Easy Populate.

As the person who uploads EP version 3.0, I suggest you to wait for the next version by dAbserver. If you would like to install EP, please use any other version other than version 3.0. Thank you! Sorry for any inconvenience caused.

This version will work with the 6 subimages and Randelia metatags (a variation of Linda's, easy to adapt by just cahnging file names)

This is just the admin/easypopulate.php file, not the entire 3.0 package

This is the new file for Easy Populate 3.00 1readmeFIRST.txt. In the old file it seems step 4 is missing but it's actually a typo in the numbering.

No steps are missing. Just a typo. The new file here fixed that.

Missed one note - Version 3.00 also incorporated Specials Pricing as well. You can update the pricing for Specials in .txt file.

Download the zip file in my previous post.

That's it!

This 3.00 version is based on versions 2.78, 2.80 and 2.81b. Some points to note before you use this full package:

1. This version is heavily based on version 2.78, where SQL statements are NOT needed to run Easy Populate. Just follow the documents in the zip file to upload and revise files and it should be okay. There is no need to touch any part of MySQL.

2. I have incorporated Seperate Pricing per Customer, Product Attributes, Easypopulate Attributes Optimization, Hide Product Pricing from (certain) Customer Groups, Adding Extra Field in this zip file. The only thing I wanted to do, but did not know how, is incorporating QTPro. I checked and compared previous versions but still I could not figure it out.

3. Added "Customized" tab-delimited .txt file for download. You can play around with it - adding some fields, or deleting some fields. I personally like to play things around here since it would be "cleaner" to play around here.

4. Finally, if you download the .txt file and import it to Excel for edits and have troubles:
Try going to "Control Panel" in Windows ->
Under "Regional and Language Options" ->
Under the first tab "Regional Options", look for "Customize" and click on it ->
Under "List Separator", change "," to ";" ->
You should not have problems with importing to Excel anymore.
**If you use Excel a lot:
Please note that this change can impact your use of Excel, e.g. when you write formula, e.g. =RIGHT(A12; 10), notice after cell A12, instead of comma, you need to use semi-colon now.

That should be it. This zip file is a full package.

Add the support for contrib Quantity Price Breaks for Separate Pricing Per Customer 1.02:

http://www.oscommerce.com/community/contributions,3039

+ italian Language

Minor bug fix to category depth limitation.

Removes false "6" and replace with MAX_CAT_REC to reflect user selected depth.

Not fully tested but works on my site.

Only modified two lines of code in the easypopulate.php file.

Only the modified file is included.

This contains the Easypopulate.php file for use with UltraPics extra Picture fields.....

It's usefull to me i hope it will be usefull to you :-)

Thanks to all making these PHP programs....
I'm not a programmer but i have the logic to alter the files so it will fit my OSC.....

Walter

Easy Populate & Products Attributes
is not so easy. I had to whipe is from my system as it was like looking for a needle in a hey stack trying to find the working pices of code from all the addons below.

This version of Ep can inactivate all current product's status. Should only use if you dont have discontinued product list, and have update files for all suppliers ready.
This version is developed from ver 2.8.
2 files are updated: easypopulate.php & the one in includeslanguagesenglish

By Tommy Vo @ www.ITSS.com.au

Testing demo might be run at :
www.itss.com.au/demo/red/admin

If anyone has problem: strange character replaced the quotes " or ' in the product name or description. EX:
"400" "0" "3"
would become
&#34400;" &#340;" &#343;"
Should use this file to replace thefile easypopulate.php in the package of Easy Populate 2.8
The attach zip only contain 1 file easypopulate.php
TommyVo - admin@mail.ITSS.com.au
<a href="www.ITSS.com.au">www.ITSS.com.au </a>

If you are using Product Short Desc contribution
http://www.oscommerce.com/community/contributions,3123

Then use this file

This version of Ep can add product special price into table specials. Special price column should have the header: "v_specials_price", and optional column "v_specials_expires_date" for expires date of each special.
Testing demo might be run at :
www.itss.com.au/demo/red/admin
This version is developed from ver 2.79b. Only 1 file is updated: easypopulate.php

2.79, 2.79a, 2.79b-MS2 totals:
Pulled configuration into Admin panel, added missed options in 2.79, tested with all false values of next added options:
Attributes Optimization (not tested with true value, but must works)
Prevent EP from duplicate products in different subcategories (tested with false and with true - it's works!)
separate prices per customer (not tested with true value, but must works)
QTpro (not tested with true value, but must works)
added russian and finish languages (total 5 langs - english, german, italian, finish, russian)
Updated all languages files with missed options
One sql file for new install and/or update (note - update will set to default all sittings!)
Sql file for update to 2.79b from 2.79 or 2.79a
+Added CIP (Contribution installer) installation file (i just taked it from CI packages archive and updated it with new options, not tested)
p.s. OLD style install and update still works! read 1readmeFIRST.txt in docs folder.

The manual in the 2.79 misses a lot of steps. Instead, the 1readmefirst contains everything you need to do. When you use the update.sql file, replace the 3rd line with this

INSERT INTO configuration VALUES ('', 'Temp Directory', 'EP_TEMP_DIR', 'temp/', 'If you changed your directory structure from stock and do not have /catalog/temp/, then you will need to change this accordingly.', 17, 1, now(), now(), NULL, NULL);

Did you see I change "you'll" to "you will", because that's another problem I found in version 2.79

update line 1545 in /catalog/admin/easypopulate.php

$sql = "INSERT INTO ".TABLE_CATEGORIES."(categories_id,categories_image,parent_id,sort_order,date_added,last_modified) VALUES ($max_category_id,'".EP_CAT_IMAGE."',$theparent_id,0,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP)";

This Version inludes german language.
(translated easypopulate.php for german folder and sql-file for german language in Configuration Part of Admin)
--> complete package

Pulled configuration into Admin panel

Easy populate + Extra filed - Separate price per customer 4.11 + English + Italian

This mod allows you to use the

Easy Populate Products & Attributes Mod
(http://www.oscommerce.com/community/contributions,500)

with the

Quantity Price Breaks Per Product Mod
(http://www.oscommerce.com/community/contributions,1242)

Hi:

I don't know if you have this problem but i do, I need to have correct stock and price for each of the attributes, not only the "main product", and because i have lots of products I came up with this.
You need to add a column called products_model to the table products_attributes.
What this contrib does is going thru a list of product models in a text file, it first compares with products, if its not found, search in products_attributes and updates price and stock for the said attribute, after this goes to the "main product" and updates price , finally after all the products are done, the code sums up all attribute stock and puts this number in the Master Product stock count.
The code is horribly laid out, but works I am submitting it because I m sure there is a lot of people that need this but they have to do it manually or by aproximation.
emails: jodiepool@hotmail.com I ll do my best to help out.

description

Easy Populate is a phenomonal program, but there are some things in the instructions that aren't covered that almost everyone will have to deal with. Use this great 2 page document to prep your files before importing and you'll go from loathing the product to loving it. This document not only covers file prepping, but also the most common errors you'll get during the importing process and how to fix them before you pull your hair out of your scalp. A must read for everyone who plans on importing a large product database into osCommerce.

Only change, is that reference making a change to your /catalog/admin/includes/configure.php file DOCUMENT_ROOT setting to $DOCUMENT_ROOT and on line 54 uncomment $separator = "t"; and comment out line 55 for the semicolon.

NOTES
-------------------
This is NOT a complete package, just the instructions on how to make the quick optimize.

I had a database of 1600 products with over 250,000 different attributes,
and originally it would take up to 18 minutes (if the script didnt timeout first)

Now it takes about 20 seconds. ---sweet
(Times may vary for you based on your server)

All this optimization does is first load the entire attributes and options tables
into an arrays. Then while its going product by product, it no longer makes
a seperate mysql query calls, it just grabs the data from the existing array.

Will work on EP v2.4+

change code :
$filestring = substr($filestring, 0, strlen($filestring)-1);

to :
$filestring = substr($filestring, 0, strlen($filestring)-strlen($separator));

This corrects a syntax error with expecting ")" on line 226 which is so small that it took a while to find.

Updated EP to include UPC bars by defining path for the UPC.

helpful to keep upc bar of inventory on hand at warehouse locations.

Enjoy.. Use if you use UPC bars...

Funtimes..

Added support for products attributes stock , for QTYpro users .

to enable it just change

$products_attributes_stock = false;
to
$products_attributes_stock = true;

in configuration variables.

Full packages.

Forgot to make the Froogle change in the alternate version files. Now they all have the update.

All files included.

Minor change deletes the #parameters that were added to the top of the Froogle file. Froogle no longer supports or reads these settings and they generate non-fatal errors on Froogle. Make sure to go into your Froogle Merchant Center and set Quoted to Yes. The file now begins with the field headings as required by Froogle.

I changed the version number to 2.75 as there were so many "2.74" versions it was looking very confusing.

Includes all files.

This is the full package, with price break, master products and vendor email which can be merged with the original file.

Full Package. You may have been confused by having to install other modules becausee others didnt just place a file inside the original EasyPopulate contribution.

Just download this and extract to its' own directory. Inside please read the documents! This is very easy to install.

Also there is a file for pricebreaks, master products and vendor email which can be extracted and used, if you are using those contributions.

Support for Master Products!

I just applied Erik Chumley's mod to the new version. Thanks, Erik!

Just install as catalog/admin/easypopulate.php

ONLY USE THIS IF YOU HAVE VENDORS_AUTO_EMAIL installed!!!
This package includes the entire easypopulate install, with docs. The modified easypopulate.php file is saved seperately.

This package contains the unmodified Easy Populate code, and documentation.

Also included is a revised edition of the price break modification (the other had references to a local hard disk drive, thus they were replaced with the proper paths)

When making changes to Easy Populate, Please, include two files, one with the original Easy Populate file with coding updates for errors and the other one if you added fields, for working with other contributions. Adding fields does not constitute a new easy populate file. Please just include it with the name easypopulate_nameofchanges.php.

It is too hard for other people to use the basic package if this is heavily modified. Just adding fields to the application does not make it where it needs to be changed from the original.

This just a smal update to EP 2.74 to be compatible with Quantity Price Breaks Per Product Price. I've added support for 4 breaks, if you need more just search for price1_, and add the rest price5, price6, price7 and price8. It will take just about 5-10 minutes. Also this update adds support for big_images 1.25 contribution, as implemented support for images mods didn't work for me. So the code for these image mods was removed. The rest of the code wasn't touched.

To install just unzip easypopulate.zip and rewrite the orginal. BACKUP the original file

Minor modification to v2.73 31 Dec 2003 (i.e. *not* including MASTER PRODUCT SUPPORT)

- Fixed rounding issues with when using prices with tax.
- Fixed price with tax in Model/Price/Quantity download
- Modified Date Available code to set Null if left empty (instead of setting current timestamp)

Contains 1file only (easypopulate.php) please download the previous versionfor the full install & read me.

Easypopulate v2.73-MS2/MASTER PRODUCT SUPPORT allows you to set all your master product variables using easypopulate MUST HAVE MASTER PRODUCTS INSTALLED

Simply replace easypopulate.php with this one. BACK UP YOURFILES

Fixed the problem of using 'max(product_id)' in easypopulate.php. This Has been replaced by 'SHOW TABLE STATUS LIKE tablename' and fetching 'Auto_increment'.

The usage of 'max(product_id)' was producing problems while emptying and populating products to catalog. When the catalog is empty it was taking max_product_id as 1(Since the product_id is an auto_increment field it might not be '1' as the next product_id).

This release includes ability to turn off product attribute data when downloading the tab-delimited file.

This release includes ability to handle product attributes. This should theoretically work for any number of product attribute options and values, as well as languages.

Fixed Easypopulate to work with the s/m/l mod installed. If you don't have it installed, you'll probably be better off with the previous revision of Easypopulate (but not necessarilly - to use this one you just need to comment out the s/m/l changes marked with 'Adam')

Good luck! Write on the forums if you're having trouble or PM me (Pharkie)

I replaced ALL direct database-table calls with the appropriate calls to "TABLE_" and required the database_tables.php in the admin directory;
If you have the "separate price"-mod running, and there is an article with NO seperate price, then the import won't die by now. (but will die if it's not a pair of price and customer_group)

ADD this

3.2 For adding link to the Admin, edit file admin/includes/aplication_top by include this line:

define('FILENAME_EASYPOPULATE', 'easypopulate.php');

3.3 For adding link to the Admin, edit file admin/includes/boxes/tools.php by after this line:

tep_admin_files_boxes(FILENAME_SERVER_INFO, BOX_TOOLS_SERVER_INFO) .

include this line:
tep_admin_files_boxes(FILENAME_EASYPOPULATE, BOX_TOOLS_EASYPOPULATE) .

at the manua.txt

Bug fix for SQL UPDATE problem.

1064 - You have an error in your SQL syntax near...

Ditto MS2 file info below, but for MS1.

In the previous files were added product fields that are not stock osc. A previous version must have contained the customization. Please do NOT use the EasyPopulate_v2.61-MS2.zip and/or the EasyPopulate_v2.61.zip. If there is a way to remove them, that would be awesome!

Bug fixes and changes to bring current with MS2. Added a readme file separate from the EP Manuals with answers to questions most frequently asked on the forums.

Bug fixes and changes to easpopulatefunctions.php for post May snapshots of MS1. Added a readme file separate from the EP Manuals with answers to questions most frequently asked on the forums.

EasyPopulate v2.60 includes the following enhancements:
1. Allows uploading a file via FTP to the temp directory and importing it there.
2. Allows changing the separator character from a tab to anything else you want
3. Includes the Special price in the Froogle download if a special price exists, is active, and is applicable to today.
4. Allows unlimited subcategory levels

Bug fixes include:
Re-commented out the code for images contrib. This had been left active in 2.53 and caused people headaches.
Froogle downloads were giving the categories in reversed (bottom to top) order instead of top to bottom.

This has a bugfix for the time so that IE users can download the text file.

OK, This is *really* 2.52. I uploaded the wrong file before.

Sorry.

Tim

Fixed a stupid parse error in the file. Gotta stop these last minute edits!!

No code changes, but edited the docs to reflect another important change in 2.5: The order of the categories is now from highest to lowest. It used to be from lowest to highest, causing no end of confusion.

So by popular demand, it's been fixed!

Fixed a bug where product URL's get blanked out, as well as the "times viewed' when uploading a file.

Added support for the multi-image mods.

This is one more bugfix release beta cycle. This fixes 3 bugs:
1. Default image names not working right.
2. Added set_time_limit call to prevent timeouts on non-safe-mode servers to reduce need to split files
3. Fixed a hardcoded reference to catalog/temp in an output string.

Bugfix - inserting new items would fail with sql errors due to missing quote in sql statement.

This is a bugfix/tweak release:

Fixed the Active/Inactive status - it wasn't setting the status correctly in the db.

Made the "if zero qty, make product inactive" functionality really work. You can turn this on and off with a config variable.

Added the "date_added" field to the download and upload. Thanks to reemo for sponsoring this development.

This is yet another bugfix release:
1. Items with no manufacturer specified were being assigned a manufacturer of '' (empty string).

2. Trying to upload a file thru EP would result in messages like "Deleteing product", but nothing was actually happening. Nothing was being deleted or altered at all.

This is a bugfix - trying to download a Model/Category type file would give SQL errors.

This is a bugfix release for the Froogle download support. 2.4 had some errors in the output file that would cause Froogle to reject the feed.

This release of EP includes support for:

Froogle: Download a file from EP, and push it into Froogle. Requires you to contact google, plus some minor configuration in easypopulate.php

Older Codebases: EP should be able to support nearly any 2.2 snapshot now. Read inside easypopulate for more info.

Enjoy!

This is a bugfix release for non-english stores where the product name and description were being left blank in the downloaded file.

If 2.3 is working fine for you, no need to upgrade.

EP now supports multiple file layouts, the Header Controller contrib, and the Multiple Price Per Product contrib.

This release also removed some hardcoding around the multi-language support and fixed bugs with non-english only stores.

Restructured the code so it is easier to understand.

EasyPopulate version 2.2

Populate your store from Excel, Access, Filemaker, or any other tab-delimited text file!

EasyPopulate makes it simple to add and update 1000's of items in your store. This release fixes a file splitting bug, and adds much better multi-language support, thanks to Elari. Also, the documentation has been rewritten.

NOW TRANSPARENTLY SUPPORTS PRE-NOV 01 SNAPSHOTS!

Quickly upload 100's or 1000's of items to your store from Excel!

Download, edit, and upload your products to update your store!

This version fixes a bug which cause the "large file split" feature to not split the file at all.

This version also tries to be smarter about memory usage while uploading large files.

EasyPopulate lets you easily create and maintain your store.

Start by uploading an excel file of your products, then maintain your store by downloading a text file, updating it in excel, and then upload to update your products, add new categories, etc.

2.0 brings 2 major enhancements:
1. Up to 6 levels of categories are supported.
2. Magic-quotes support should eliminated import problems for many people.

Let me know how this works for you.

Tim

Populate and update your store from Excel!

Easypopulate has been used to upload over 15000 items into OSC.

This is a small bugfix release that cures a problem with database errors when trying to create a new manufacturer.

Sorry guys, I haven't gotten to the magicquotes fixes yet.

Script normally opened in new windows when downloading or uploading and this will give problems sometimes in secure directories.

Populate and update your store from excel/csv file.

This fixes some serious bugs in the code that would cause new products to not show up, and manufacturers to not get set for a product.

Populate your store with 1000's of products via excel or a tab-delimited file.

Download, edit in excel, and upload your data to update your site.

This has all the rich goodness of version 1.4, plus better usability with excel because the end-of-row marker has been changed from --EOR-- to EOREOR, and it doesn't matter if excel puts quotes around the EOREOR.

Also fixed a bug where if old product descriptions still existed and you tried to upload new products, you would get sql errors because of key violations.

Thanks to Joshua for reporting these problems and suggesting fixes.

OK, 1.4 is out.

EasyPopulate lets you take an Excel sheet of products and categories and populate your store without having to use the web interface.

It also allows easy updating by letting you download a csv file with the current data, you can edit it in excel, then import it again to update your store.

Also, if you have many items to upload, EasyPopulate can now split those big files into appropriately sized small files, which you can import in the normal manner.

CSV FILES CREATED WITH OLDER VERSIONS CANNOT BE IMPORTED WITH THIS VERSION!

Changes this version include:
1. Switch from semicolons to tabs for the field delimiter.
2. Much better handling of things like quotes, commas, etc in the descriptions.
3. Ability to split an uploaded file into many smaller files that can be imported to get around the 30 second time limit for php.
4. No database changes are required anymore on a stock installation.
Enjoy!

EasyPopulate lets you upload all your products to your store at one time, creating categories and subcategories on the fly!

Also allows for easy updating of your store. Simply use EasyPopulate to create a csv file, open it in excel, edit as required, then upload and it will update your store!

This release adds the ability to put the csv file into the temp directory of your oscommerce site, where it can be accessed via ftp or via the Filemanager tool in OSC.

This was added because some windows machines would give errors when trying to download the csv as a streamed file from the php page.

Thanks to Vincent at www.trendsandgadgets.com for his help in troubleshooting this.

This will let you download your products, edit them in Excel, and upload them again to update your product listings.

Or it can be used to set up your store the first time - just put all your products into a spreadsheet with their categories and manufacturers, then upload it, and your entire category and product system is created with no manual labor.

This release fixes two bugs:
1. The product image was not being changed when doing updates. Initial upload was OK, tho.
2. If you had a product_model that was too long, it would try to insert it into the database, causing data screwups. The code now checks to see if the length of the product_model is too long, if it is it complains. If you have modified OSC to have longer product_models (like I have!), then you will need to change the variable $modelsize in the source code near the top of easypopulate.php.

This will let you populate a store with products without needing to use the web interface.

You create a csv type file in Excel, and upload it. Categories, subcategories, manufacturers and products are all created on the fly.

It also has a download feature where it generates a csv type file, you can edit that file in excel, and then upload it again to update your products.

This version adds notes in the installation instructions covering cases where you already have installed Excel Upload, and fixes a really dumb bug in the code where links were pointing to excel.php instead of easypopulate.php

This file is derived from the Excel Upload 1.51 contrib, and is compatible with it - i.e. they can both be used at the same time.

Thanks to franco@tusciana.biz and Gary Burton for finding these problems and reporting them. (i've really got to stop putting these in at 4 AM.... )

Easy Populate makes it simple to populate your OSC store with products without using the web interface at all.

Easy Populate lets you download all your products into a csv file, edit them in the spreadsheet of your choice, and the reupload them to update your products, changing prices, categories, quantities, etc.

If new manufacturers, categories, or subcategories are found in the data, they are created for you on the fly.

This is based on the Excel Upload 1.51 from dynamok.