Community Add-Ons
Add file to this packageEasy Populate & Products Attributes
for osCommerce Online Merchant v2.2
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.
Download 
Report
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('""',"""
to
str_replace('""',"""
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
虠" Ŕ" ŗ"
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.