Zen Cart Logo
Forums / Addon Admin Tools / Easy Populate 1.2.5.4 support

Easy Populate 1.2.5.4 support

Views: 1,300,978

Results 1,461 to 1,480 of 3,834
7 Apr 2008, 4:20 PM
#1461
chadderuski avatar

chadderuski

Totally Zenned

Join Date:
Apr 2006
Location:
Dark Side of the Moon
Posts:
986
Plugin Contributions:
0

Easy Populate 1.2.5.4 support

madelina:

p.s if anyone wanted to see their Excel file as an example I could provide that if it helps :)

Madelina:

Did you add a category & product manually first? If you load even 1 manually first, then download the full-export. This will give you your road map.

NOTE: EVERY line needs EOREOR or things go bad!

Also: HTML formating is OKAY in descriptions.

When you name your file, use the same name and just change the last 4 numbers.

I suggest breaking your data into smaller chunks until you get the hand of things. EP doesn't like smart quotes either ... they come out as funny characters.

Also be careful the use consistent category names... Smallwares and SmallWares are TWO DIFFERENT CATEGORIES and you'll get duplicate linked products.

You may also need to select "Reset ALL Products Master Categories ID" in the admin ->tools -> store manager ... and "Update ALL Products Price Sorter" doesn't hurt either.

8 Apr 2008, 12:39 AM
#1462
kbalona avatar

kbalona

Zen Follower

Join Date:
Oct 2006
Posts:
213
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Ok I could probably find this by looking through the whole thread, but can someone tell me if there is a "paid" version of EZ Populate that works better/more functions than the free version, and if so where to get it?

EDIT: I found the modhole.com website, with EZ Populate Advanced. I'm willing to pay the $65 for it, but does anyone know if it's significantly better than the free version?
Thanks a lot

8 Apr 2008, 1:06 AM
#1463
madelina avatar

madelina

New Zenner

Join Date:
Mar 2008
Posts:
12
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

chadderuski:

Madelina:

Did you add a category & product manually first? If you load even 1 manually first, then download the full-export. This will give you your road map.

NOTE: EVERY line needs EOREOR or things go bad!

Also: HTML formating is OKAY in descriptions.

When you name your file, use the same name and just change the last 4 numbers.

I suggest breaking your data into smaller chunks until you get the hand of things. EP doesn't like smart quotes either ... they come out as funny characters.

Also be careful the use consistent category names... Smallwares and SmallWares are TWO DIFFERENT CATEGORIES and you'll get duplicate linked products.

You may also need to select "Reset ALL Products Master Categories ID" in the admin ->tools -> store manager ... and "Update ALL Products Price Sorter" doesn't hurt either.

useful stuff, thank you :) i'm having a problem with the database my supplier gave me which contains characters that excel struggled with, but i think i may have a solution now. thank you so much for replying and i'll heed your advice! :clap:

8 Apr 2008, 3:30 AM
#1464
realizingthedream avatar

realizingthedream

New Zenner

Join Date:
Jan 2008
Posts:
24
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Question: I download my products using easy populate however they are not shoewing up in my store. the category has the number behind it as if my products are there but they are not showing up...any suggestions. Do I need to purchsae the newer version....I'm really frustrated...help please!!!!! Thanks

9 Apr 2008, 9:02 PM
#1465
hduk avatar

hduk

New Zenner

Join Date:
Jan 2008
Posts:
30
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Hey All,

What should the format of the text be in the v_products_description_1 field? Will it accept plain text or does it have to be a specific format?

Ideally i would like to be able to control the format, have separate lines, selected font and size etc etc.

Thanks in advance

10 Apr 2008, 12:14 AM
#1466
kbmets7 avatar

kbmets7

Zen Follower

Join Date:
Jan 2008
Posts:
89
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

hduk:

Hey All,

What should the format of the text be in the v_products_description_1 field? Will it accept plain text or does it have to be a specific format?

Ideally i would like to be able to control the format, have separate lines, selected font and size etc etc.

Thanks in advance

I think you would control this by using HTML, but I have to aks, what is v_products_description_1? I only use v_products_description (no "1").

10 Apr 2008, 3:40 AM
#1467
cellz4less avatar

cellz4less

New Zenner

Join Date:
Mar 2008
Posts:
16
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Which Easy Populate Software will work for Zen Version Zen Cart 1.3.8a
Database Patch Level: 1.3.8 - please let me know and if possible where I can download it. Any tips for a beginner on importing products? I will be reading through the whole forum file - my site is mycellz4less.com

10 Apr 2008, 4:40 AM
#1468
elkbow avatar

elkbow

Zen Follower

Join Date:
Jul 2007
Location:
Trinity Alps
Posts:
131
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

cellz4less:

Which Easy Populate Software will work for Zen Version Zen Cart 1.3.8a
Database Patch Level: 1.3.8 - please let me know and if possible where I can download it. Any tips for a beginner on importing products? I will be reading through the whole forum file - my site is mycellz4less.com

Check this out.
http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_41&products_id=395

10 Apr 2008, 4:46 AM
#1469
elkbow avatar

elkbow

Zen Follower

Join Date:
Jul 2007
Location:
Trinity Alps
Posts:
131
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

cellz4less:

Which Easy Populate Software will work for Zen Version Zen Cart 1.3.8a
Database Patch Level: 1.3.8 - please let me know and if possible where I can download it. Any tips for a beginner on importing products? I will be reading through the whole forum file - my site is mycellz4less.com

elkbow:

Check this out.
http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_41&products_id=395

Has anyone used version 1.2.5.5 yet?

10 Apr 2008, 7:54 PM
#1470
marksu avatar

marksu

Zen Follower

Join Date:
Nov 2007
Posts:
260
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Does anyone have a fix for the multi language category?

Yes I know the advanced commercial version have fixed it, but I look how to fix it on the GNU version. Has any code here been released by users?


Still weard that Advanced version allowed to be commercial as it uses Zen Cart internal functions??

marksu

10 Apr 2008, 10:39 PM
#1471
elkbow avatar

elkbow

Zen Follower

Join Date:
Jul 2007
Location:
Trinity Alps
Posts:
131
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

marksu:

Does anyone have a fix for the multi language category?

Yes I know the advanced commercial version have fixed it, but I look how to fix it on the GNU version. Has any code here been released by users?


Still weard that Advanced version allowed to be commercial as it uses Zen Cart internal functions??

marksu

marksu,
Did you look here?
http://www.zen-cart.com/forum/showthread.php?t=35883&highlight=multi+language+category

11 Apr 2008, 8:20 AM
#1472
marksu avatar

marksu

Zen Follower

Join Date:
Nov 2007
Posts:
260
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

elkbow:

marksu,
Did you look here?
http://www.zen-cart.com/forum/showthread.php?t=35883&highlight=multi+language+category

EDIT:
Well I ment multi languge support for the Easy Populate.

That is about some multilanguge for EZ-Pages.
That is totaly different module for different purpose.
But yes I do have that installed as well.

Problem is that Easy Polupate is not compatible with multi languge for category category ... etc.

marksu

12 Apr 2008, 1:45 PM
#1473
ariejester avatar

ariejester

New Zenner

Join Date:
May 2007
Posts:
12
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Hi, Ive installed easy populate but when uploading the .txt file I got:

No model field in record. This line was not imported

So I created all the categories via zencarts admin for my products which match those in the .csv and the tab text file.
But whenever I upload the .txt file I still get the same problem. Also when I check the actual site it has created lots more categories with no products in them, the categories are all numbers such as:

0.01
0.02
0.03
0.04
0.05

etc. etc.

Can someone tell me where I'm going wrong. As when I upload the dvd example spreadsheet thats in the temp file that works. I have double and triple checked the headings for each column and the model one which is the first one is titled

v_products_model

which seems to be correct as it matches the one in the dvd file that works. I have downscaled my list to 200 products to see if that works, as there are approx 3000 products in total.

The headers Im using are (in actual spreadsheet order):

v_products_model
v_products_image
v_products_name_1
v_products_description_1
v_products_description_2
v_products_description_3
v_products_description_4
v_products_price
v_products_weight
v_manufacturers_name
v_categories_name_1
v_categories_name_2
v_categories_name_3
EOREOR (what is this by the way? - Ive kept it in for now - can I delete this column)

Any help would be appreciated as I'm completely stuck and cannot see what I've done wrong!

13 Apr 2008, 1:23 PM
#1474
kyates avatar

kyates

New Zenner

Join Date:
May 2005
Posts:
23
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I'm having loads of hassle with Easy Populate. Any help appreciated!

I've installed it, and can even use it to upload a product, but it won't upload more than one product at a time.

I've downloaded my original file from Easy Populate, and i'm using Excel to edit it. The file is then saved as Tab Delimited format from Excel and uploaded. Everytime I add a new product, it just replaces the last one.

I've tried to upload the Tab Delimited file with about 300 products, but it just doesn't do it. The Easy Populate page displays that the product has been updated, but it just replaces the last one in the database and none of the others are there.

Has anyone experienced this?

Could it be something to do with formatting in Excel such as bullet points?

Heeeeeellllllllp Meeeeeeeeee

Ky

13 Apr 2008, 3:57 PM
#1475
kbmets7 avatar

kbmets7

Zen Follower

Join Date:
Jan 2008
Posts:
89
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

kyates:

I'm having loads of hassle with Easy Populate. Any help appreciated!

I've installed it, and can even use it to upload a product, but it won't upload more than one product at a time.

I've downloaded my original file from Easy Populate, and i'm using Excel to edit it. The file is then saved as Tab Delimited format from Excel and uploaded. Everytime I add a new product, it just replaces the last one.

I've tried to upload the Tab Delimited file with about 300 products, but it just doesn't do it. The Easy Populate page displays that the product has been updated, but it just replaces the last one in the database and none of the others are there.

Has anyone experienced this?

Could it be something to do with formatting in Excel such as bullet points?

Heeeeeellllllllp Meeeeeeeeee

Ky

Do you have this field at the top, and at the end of every row: EOREOR?

it tells the program that it is the end of one product, and another product is on the next line. If you don't it will only read the first product.

13 Apr 2008, 7:22 PM
#1476
newbird avatar

newbird

New Zenner

Join Date:
Apr 2008
Posts:
2
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Hi,

I'm trying to install Easy Populate 1.2.5.5 for Zen Cart 1.3.8a. My system is running MySQL 5.

I received the following message after clicking on install:
"Easy Populate Configuration Missing. Please install your configuration by clicking here".

So I clicked "here" and received the following.

"Success Installation Successfull! A full download of your store has been done and is available in your uploads (temp) directory. You can use this as your 1st template for uploading/updating products."

Why is it that I don't have to run install.sql as mentioned below? I'm worried that I have messed up something.

Regards.

Scrat:

If anyone is needing this the install.sql file for the database for MySql 5

MySql 5 Config

Install Easy Populate Configuration v1.2.5.4

INSERT INTO configuration_group VALUES (NULL, 'Easy Populate', 'Config options for Easy Populate', '1', '1');

UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

INSERT INTO configuration VALUES (NULL, 'Uploads Directory', 'EASYPOPULATE_CONFIG_TEMP_DIR', 'temp/', 'Name of directory for your uploads (default: temp/).', last_insert_id(), '0', NULL, now(), NULL, 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"),'),
(NULL, '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),
(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),
(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),
(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"),'),
(NULL, '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"),'),
(NULL, '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"),'),
(NULL, '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"),'),
(NULL, '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"),');

> 
> Enjoy !
13 Apr 2008, 9:58 PM
#1477
kbalona avatar

kbalona

Zen Follower

Join Date:
Oct 2006
Posts:
213
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I bought EP Advanced and just finished uploading over 12,000 products to my store. After a few tests (because I didn't know what I was doing) I uploaded without a hitch and all the products display fine. Well worth the $65.

14 Apr 2008, 4:06 AM
#1478
newbird avatar

newbird

New Zenner

Join Date:
Apr 2008
Posts:
2
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Anyway, just for the record, I did manage to upload my products (tried 50 items at one go) successfully. Really convenient, saved me quite a bit of time. :smile:

15 Apr 2008, 2:40 AM
#1479
jaskarn avatar

jaskarn

New Zenner

Join Date:
Nov 2007
Location:
Auckland, New Zealand
Posts:
59
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

hi,
is there any limit on how many products can be uploaded at one time. my supplier gives me a file with over 37000 products and every time i upload or download to zencart it takes ages.

16 Apr 2008, 3:52 PM
#1480
erika_311 avatar

erika_311

New Zenner

Join Date:
Mar 2008
Posts:
14
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I downloaded my .txt file through EZ popluate. I then edited my products (I didn't origianlly have a model number with some of them so I added a model number). I uploaded the .txt file through EZ popluate, added it to the database.

It created duplicate products instead of overwriting the original product. :oops: Am I doing something wrong?
Thank you for your time. I love this contribution, I am just confused I think.:lookaroun