Easy Populate 1.2.5.4 support

mary4c:

Keep in mind that I am really new to this program. Can you explain the config section? I checked on the Configuration>Images, but all it tells me is the height and width size.

I have already uploaded all my pictures and this one in particular was 924K.

Thanks for helping me!

:censored:Sorry, I got dpi and pixels interchanged there.

:cry: 924K is suitable for framing, not for much for anything else.

In config/images, the max IH Large image width & height is set (mine is 500x750), so anything larger than that is resized by IH. If you resize your images within those constraints (before uploading), then IH does not need to do anything to them (except apply any compression factors (quality setting) that you also set there.

As I said, anything larger than the max displayed (ie 500x750) is not needed and is therefore a waste of space and upload time.

The dpi comes into play only if you scan your own images (it is a compression ratio) and effects the file size (ie 75k) and the quality of the image.

If you need help resizing your images, just PM me and I will try to help, as this is not the place for a tutorial.

awhfy99:

If you need help resizing your images, just PM me and I will try to help, as this is not the place for a tutorial.

I created a basic tutorial that may help someone with this. It is very basic and does not go into imaging software usage.

http://www.stampdays.com/catalog/index.php?main_page=page&id=33chapter=0

This thread is about EZ Populate not photos.

Pick up photosizer or other shareware to automate the sizing process. Unless you have one image the prior stated methods are not well thought out as they will take forever.

Back on topic please

I tried to upload a batch throught the /temp/ area of EP. I uploaded the file via FTP. Then went to Admin and tried to upload the file name into the database. I used it as below:

file_name.txt (the result was an Error)

file_name (the result said upload complete)

But the products are not showing up on the store front. The products are also not showing up when i go into catalog/categories/products.

Any thoughts?

but the products are not showing up on the store front.
If you installed EZ Pop correctly then you should have an easypop tab on your menu bar in admin. you go down to that tab and export a file of your current inventory.

THEN you can add to your hearts delight using identical format for any additions you make.

You can then import it using the import link also on same page. Once complete you will get a list of successful imported datafields.

If you uploaded a file and then imported with no joy and it screwed up your inventory then it is highly likely your import was not formatted correctly and you messed the whole thing up. Hopefully you have a backup or you can also manually repair the data by doing another download and fixing the fields accordingly.

JimmyV:

If you installed EZ Pop correctly then you should have an easypop tab on your menu bar in admin. you go down to that tab and export a file of your current inventory.

THEN you can add to your hearts delight using identical format for any additions you make.

You can then import it using the import link also on same page. Once complete you will get a list of successful imported datafields.

If you uploaded a file and then imported with no joy and it screwed up your inventory then it is highly likely your import was not formatted correctly and you messed the whole thing up. Hopefully you have a backup or you can also manually repair the data by doing another download and fixing the fields accordingly.

The only 2 Easy Pop tabs I have are under admin/tools and admin/config. Didn't think there were any others. All my sites have it that way.

I have got the dataset on the correct format. I used the same spreadsheet (and all data unchanged) to my other Zen Cart Website. The difference is I did my other one by saving my spreadsheet 300 items at a time and uploaded it that way. That takes forever. I know that you can do it by uploading it into the temp/ file via FTP which I did but I don't know why it's not working. I have the pictures in the correct file and everything but still I don't know why it's not working.

My thoughts are now that i have it uploaded to the temp file and then went to admin/tools/EasyPop and uploaded it that there is another step after that... but I'm not sure having never done this before.

For all of you out there having trouble getting your products into froogle, I have created another option for you. It takes a little time, but I got it to work. Here is more information. http://www.whowont.com/froogle

Still can't get it to work.... Anyone... any help... SchoolBoy??? Doc?? Cobra???

Hello - this is a general question about EP - wasn't sure of the proper place to ask, and apologies if this has been asked and answered, but I couldn't find anything like it and the thread is 3000+ posts long!

I've gathered that Easy Populate can be used to import/export inventory info, but can it be set up to automatically import/export changes in inventory (i.e. Sales)? Here's my scenario:

I'm trying to set up an eCommerce book store for a client. He uses an online service called Art of Books which maintains his inventory and automatically updates the info across a large number of venues (Amazon, Biblio, eBay, Half.com, etc) so that **when a book sells in one place, the inventory is updated everywhere. **It also allows for custom venues, and will send regular interval tab-delimited files (or a number of other formats) to whatever FTP you specify about every 30 minutes to maintain proper inventory. **

Can EP be used to set ZenCart up like the other venues mentioned where inventory is automatically changed without any manual interaction? **

Or, if not with EP, can ZC even be easily set up to do this (without significant coding)?

Keep in mind I'm a designer, not a programmer/coder in any way. I have set up a few ZenCart sites, but my expertise is limited, and I don't want to spend hours (weeks!) working on this if it's not even possible.Thanks in advance for any help...

Is ther also a way with Zen Cart to have the MSRP price come up so that they can see how much they are saving over retail?

Where is everyone these days..> This is the longest I have ever seen this forum go without a Help reply!

Hi. I uploaded by FTP my test cart developed on my WAMP server for Zen Cart version 1.3.9f. Easy Populate 1.2.5.4 was in the cart, and some test products were in the cart. However, the products disappeared, and when I first tried to use Easy Populate to import products, it prompted me to install. I pressed the install link it offered and a message stated it installed successfully.

I tried to import products but was unsuccessful. However, after a period of time, the product categories showed up in my Zen Cart online, but with no products. At time of the failed install, Easy Populate had stated:

New Product Failed. SQL error. Check Easy Populate error log in uploads directory.

First, after checking for hours for the location of the uploads directory and what it actually meant to check that directory, I found that under Admin>Configuration>Easy Populate, there is a menu that names the Uploads Directory as "temp"; the admin screen gave the option to edit the name of the uploads directory.

I went to my online temp directory by going by FTP to my www/temp directory, and downloading the file called "ep_debug_log.txt" to my computer and opening the file in my wordprocessing program.

Now, I have the following error message repeated for days and days of uploads:

[QUOTE]
MySQL error 1054: Unknown column 'p.products_UPS' in 'field list'
When executing:
SELECT
p.products_id as v_products_id,
p.products_model as v_products_model,
p.products_image as v_products_image,
p.products_price as v_products_price,
p.products_UPS as v_products_UPC,
p.products_ISBN as v_products_ISBN,
p.products_weight as v_products_weight,
p.products_date_added as v_date_added,
p.products_date_available as v_date_avail,
p.products_tax_class_id as v_tax_class_id,
p.products_quantity as v_products_quantity,
p.manufacturers_id as v_manufacturers_id,
subc.categories_id as v_categories_id
FROM
products as p,
categories as subc,
products_to_categories as ptoc
WHERE
p.products_id = ptoc.products_id AND
p.products_model = 'CDASK101' AND
ptoc.categories_id = subc.categories_id
</QUOTE>

There is one of these messages for each of the 6 products in my test upload, with the second to last line changing for the product number for each product.

The heading on my spreadsheet correctly states v_products_UPC, not UPS.

1. Where could this "UPS" be coming from?

2. In trying to make Easy Populate work, I installed the .sql patch for Easy Populate, and it created a duplicate "Easy Populate" in my Admin>Configuration>list, although it then recognized it would be a duplicate entry and stopped itself from installing.

How may I remove the empty Easy Populate listing in Configuration? I find no extra line in the configuration table in PHPMyAdmin to delete.

3. Thank you to Dr. Byte who pointed out to someone in this forum the $ in the price column, which keeps reappearing in my tables. Also, thanks to Dr. Byte for pointing out that the numerals 0, 1, and 9 are used for inactive, active, and delete status. I find my product source uses the word Active, and am changing that as a precaution for making Easy Populate work, although it worked in my test server.

Notageek

notageek,

Try this:

Go back and delete all the files you installed for EP and reinstall this version 1.2.5.4 from here.

http://www.zen-cart.com/archived_contributions/admin-tools/

Make sure it's 1.2.5.4 you use. It's more stable.

Thanks, elkbow. I'll give that a try. I am using 1.2.5.4, and it does work fine on my WAMP test server.

I just have no clue how it could suddenly seem to mistake UPC for UPS in the error message:

MySQL error 1054: Unknown column 'p.products_UPS' in 'field list'
When executing:
SELECT
. . . .
p.products_UPS as v_products_UPC,
. . . .

That seems such a wild deviation that it seems correct to uninstall and reinstall. I will let you know what happens.

Notageek

Hi. I tried to reinstall easy populate 1.2.5.4 but have been unsuccessful.

I initially removed each easy populate file from my site. I then went into PHPMyAdmin and removed the easy populate file from the configuration_group and configuration tables.

I reinstalled by FTP. I checked Configuration, and it still showed a duplicate entry for easypopulate, one of which gave the admin screen and the other of which had no admin screen.

I checked my PHPMyAdmin tables and there was no easypopulate file in either the configuration_group or configuration table, so I went ahead and installed the sql patch, via the upload method. That apparently worked, but gave me the following error:

1062 Duplicate entry 'EASYPOPULATE_CONFIG_TEMP_DIR' for key 2
in:
[INSERT INTO zc_configuration VALUES ('', 'Uploads Directory', 'EASYPOPULATE_CONFIG_TEMP_DIR', 'temp/', 'Name of directory for your uploads (default: temp/).', last_insert_id(), '0', NULL, now(), NULL, NULL), ('', 'Upload File Date Format', 'EASYPOPULATE_CONFIG_FILE_DATE_FORMAT', 'm-d-y', 'Choose order of date values that corresponds to your uploads file, usually generated by MS Excel. Raw dates in your uploads file (Eg 2005-09-26 09:00:00) are not affected, and will upload as they are.', last_insert_id(), '1', NULL, now(), NULL, 'zen_cfg_select_option(array("m-d-y", "d-m-y", "y-m-d"),'), ('', 'Default Raw Time', 'EASYPOPULATE_CONFIG_DEFAULT_RAW_TIME', '09:00:00', 'If no time value stipulated in upload file, use this value. Useful for ensuring specials begin after a specific time of the day (default: 09:00:00)', last_insert_id(), '2', NULL, now(), NULL, NULL), ('', 'Split File On # Records', 'EASYPOPULATE_CONFIG_SPLIT_MAX', '300', 'Default number of records for split-file uploads. Used to avoid timeouts on large uploads (default: 300).', last_insert_id(), '3', NULL, now(), NULL, NULL), ('', 'Maximum Category Depth', 'EASYPOPULATE_CONFIG_MAX_CATEGORY_LEVELS', '7', 'Maximum depth of categories required for your store. Is the number of category columns in downloaded file (default: 7).', last_insert_id(), '4', NULL, now(), NULL, NULL), ('', 'Upload/Download Prices Include Tax', 'EASYPOPULATE_CONFIG_PRICE_INC_TAX', 'false', 'Choose to include or exclude tax, depending on how you manage prices outside of Zen Cart.', last_insert_id(), '5', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'), ('', 'Make Zero Qty Products Inactive', 'EASYPOPULATE_CONFIG_ZERO_QTY_INACTIVE', 'false', 'When uploading, make the status Inactive for products with zero qty (default: false).', last_insert_id(), '6', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'), ('', 'Smart Tags Replacement of Newlines', 'EASYPOPULATE_CONFIG_SMART_TAGS', 'true', 'Allows your description fields in your uploads file to have carriage returns and/or new-lines converted to HTML line-breaks on uploading, thus preserving some rudimentary formatting (default: true).', last_insert_id(), '7', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'), ('', 'Advanced Smart Tags', 'EASYPOPULATE_CONFIG_ADV_SMART_TAGS', 'false', 'Allow the use of complex regular expressions to format descriptions, making headings bold, add bullets, etc. Configuration is in ADMIN/easypopulate.php (default: false).', last_insert_id(), '8', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'), ('', 'Debug Logging', 'EASYPOPULATE_CONFIG_DEBUG_LOGGING', 'true', 'Allow Easy Populate to generate an error log on errors only (default: true)', last_insert_id(), '9', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Consequently, there are no easypopulate tables in my SQL database, but I have the duplicate "easypopulate" listing in my configuration menu, and can go to the uploads directory.

Is there a way to remove the second appearance of easypopulate in my configuration listing? Of course, easy populate is correctly listed separately under tools, but this is just an empty title under the top configuration list in admin. Maybe this is what is causing the "duplicate entry."

Thanks for any comments.

Notageek

notageek,

I need to ask you where you are getting that SQL statement?

When EP is uploaded to your server, you will get a note at the top of the page under your administration/tools/Easy Populate.
It will ask you to install EP.

As per install instructions NOTE #5:

5. Go to Admin -> Tools -> Easy Populate. If prompted to install Easy Populate, click on the
   link provided. Otherwise, type in your browser address bar ?langer=install after /easypopulate.php
   (eg. YOUR_ADMIN/easypopulate.php?langer=install). If you wish to remove and re-install the default
   config settings, type ?langer=remove after /easypopulate.php
   (eg. YOUR_ADMIN/easypopulate.php?langer=remove) and begin this step again.

There should not be any reason to install a SQL. Also I only have Easy Populate in the database at "configuration_group".

There is no EP in the configuration table on my systems.

Let me know

elkbow:

notageek,

I need to ask you where you are getting that SQL statement?

When EP is uploaded to your server, you will get a note at the top of the page under your administration/tools/Easy Populate.
It will ask you to install EP.

As per install instructions NOTE #5:

5. Go to Admin -> Tools -> Easy Populate. If prompted to install Easy Populate, click on the
   link provided. Otherwise, type in your browser address bar ?langer=install after /easypopulate.php
   (eg. YOUR_ADMIN/easypopulate.php?langer=install). If you wish to remove and re-install the default
   config settings, type ?langer=remove after /easypopulate.php
   (eg. YOUR_ADMIN/easypopulate.php?langer=remove) and begin this step again.

There should not be any reason to install a SQL. Also I only have Easy Populate in the database at "configuration_group".

There is no EP in the configuration table on my systems.

Let me know

Elkbow & Notageek,

From what I can tell that is not correct. You may need to install the SQL patch (and I belive it says to copy and paste the text instead of doing a search and upload). It is easier for the system.

'** If for some reason the config install fails, you can upload the SQL file provided using Admin -> Tools -> Install SQL Patches' (This is under the Important section on the instructions, the last point)

As for where EP is located. EP should apear in 2 sections if correctly installed, admin/configure and admin/tools. Well I should put it that on all of my stores this is where it shows up.

Admin/configure is where you will be able to change any settings you need.
Admin/tools is where you go to do your uploading and changes when using a txt file.

Hope that helps.

Elkbow,

Where did the SQL statement occur?

The 1062 error message occurred after I uploaded the install.sql this second time on its own blank screen.

Previously when I was receiving the failed upload message I uploaded the install.sql. That is when I first received the 1062 error and also the second title "easy populate" appeared under admin/configuration, but did not have a menu page, whereas the first one had the admin menu that states you can edit and change the name of the uploads directory, etc.

Was there an install message?

I looked for an install message, but found none or must have missed it. I completely missed trying the browser approach to install. I also missed trying to "remove the default configuration settings" by typing the remove message into the browser. I guess I should have tried that as well.

What was in my PHPMyAdmin tables?

In my WAMP setup, my configuration_group table has a group number for Easy Populate of 31; when I enter that value as the group number in a search on the configuration table, it lists the following entries:

configuration_key configuration_value
EASYPOPULATE_CONFIG_TEMP_DIR temp/
EASYPOPULATE_CONFIG_FILE_DATE_FORMAT m-d-y
EASYPOPULATE_CONFIG_DEFAULT_RAW_TIME 09:00:00
EASYPOPULATE_CONFIG_SPLIT_MAX 300
EASYPOPULATE_CONFIG_MAX_CATEGORY_LEVELS 7
EASYPOPULATE_CONFIG_PRICE_INC_TAX false
EASYPOPULATE_CONFIG_ZERO_QTY_INACTIVE false
EASYPOPULATE_CONFIG_SMART_TAGS true
EASYPOPULATE_CONFIG_ADV_SMART_TAGS false
EASYPOPULATE_CONFIG_DEBUG_LOGGING true

It was my understanding that putting these in the configuration table is what makes a menu available in the admin>configuration menu. That's what was accomplished with my define_main_page_lower module being placed there.

It looks like I should remove everything and try to reinstall again. I must have forgotten to check to see if the removal of everything removed the double entry in the config>admin menu, and then put it back when I performed the install.sql upload.

Thanks for your comments and for looking at this.

Notageek

Elkbow,

You will be pleased to hear that my Easy Populate successfully imported my 6 test products after the last fix.

However, I now have 3 easy populate titles listed under admin>configuration. I would dearly love to eliminate the two extra appearances, but am afraid to try the langer remove command in the browser.

I suppose I could just ignore them. Apparently the second one didn't disappear when I uninstalled, and the third one appeared the second time I ran the install.sql. I hope to understand this some day.

No tables have appeared in my PHPMyAdmin for Easy Populate. Somehow, I miss those tables. Were they completely non-functional?

Notageek

p.products_UPS as v_products_UPC,

Notageek you have a typo in the original file causing the problem the above statement should read on or other not combo

p.products_UPC as v_products_UPC

or

p.products_UPS as v_products_UPS

That is why you are getting conflicts those tables don't go together