If this is your first visit, check our documentation. To post, register or login.
Forums / Addon Admin Tools / Easy Populate 1.2.5.4 support

Easy Populate 1.2.5.4 support

Started by langer on 9 May 2006, 9:44 PM · Views: 1,303,113

Results 701 to 720 of 3,834
15 May 2007, 5:34 AM
#701
misty avatar

misty

Inactive

Join Date:
Apr 2004
Location:
UK
Posts:
5,752
Plugin Contributions:
1

Easy Populate 1.2.5.4 support

shopyoungway:

can someone please help. I am using EP Basic and need to add category_description into EP has anyone had any luck with this and can you tell me how to do it. PLEASE any help would be apreciated thanks
Hvae you added products with a category description, and then downloaded sample file produced using Easy Populate?
It should give you a template from which to proceed further.

Dezina ZenCart Templates
Please do not PM for support queries..Post in forums..help others

15 May 2007, 3:35 PM
#702
mafiasam avatar

mafiasam

Zen Follower

Join Date:
Jan 2006
Location:
Portland, Oregon
Posts:
256
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

okay I have been trying to find a quick way to update inventory quantities for a while.

I get an updated xml feed from the supplier whose inventory is most crucial. I know how to convert the xml feed to an sql or excel file or at least I hope it is right.

what do I need to do in easy populate to update the inventory quantities?
I want this to be relatively simple and quick so I can do an inventory update and backup daily. will the standard easy populate work for this or do I need easy populate advanced?

OldWestPokerSupplies.com – Custom Poker Chips and Other Professional Poker Supplies
Zen Cart 1.3.9.h with Google Base Feeder, Share Bookmarking Widget, Ultimate SEO URL, A Black Pure Template, Quick Updates, Sitemap XML and reCAPTCHA.

15 May 2007, 3:38 PM
#703
gxjenkins avatar

gxjenkins

Zen Follower

Join Date:
Apr 2007
Location:
Tampa, Florida
Posts:
180
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Just an update. I have gotten Open Office to upload items. Most times the upload will time out, and it comes back with just a blank page, but the items are being uploaded. Another problem is that it will not split large files. That I have to do manually. So, it comes down to it's not as quick as using Excel, but I do get the full description, but I have to check to make sure it uploads the entire file.

I was able to get the files that would not upload to upload by making sure the Row Height was set to the default height. During the copy operation from one sheet to another some of the row heights were changed. Making sure the Roe Height hasn't changed, and splitting the myself seems to have this working.

I'm using Excel 2000, and Open Office 2.2

Gary Jenkins
Your Neighborhood Store
It Ain't Over Until You Quit, So Don't!

16 May 2007, 8:03 AM
#704
vampke avatar

vampke

New Zenner

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

Re: Easy Populate 1.2.5.4 support

Hi guys,

I have installed the latest version of the mod (v1.2.5.4) on the latest version of zencart (1.3.7) and it seems to be working more or less
however i am hesitant to run the script, since my shop is live and i REALLY don't want to mess things up.

I have downloaded the "Complete tab-delimited .txt file to edit" and want to add data to it.

2 questions:

  1. do I leave the data that is already in the txt file? Or can I remove it.
  2. where in this file can I add the category where the items should be under?

I have these fields in the downloaded file: v_products_model v_products_image v_products_name_2 v_products_description_2 v_products_url_2 v_specials_price v_specials_date_avail v_specials_expires_date v_products_price v_products_weight v_date_avail v_date_added v_products_quantity v_manufacturers_name v_tax_class_title v_status EOREOR

category does not seem to be here

thanks in advance!

16 May 2007, 8:15 AM
#705
misty avatar

misty

Inactive

Join Date:
Apr 2004
Location:
UK
Posts:
5,752
Plugin Contributions:
1

Re: Easy Populate 1.2.5.4 support

vampke.. you have some missing options..should come after
v_manufacturers_name
i.e
v_categories_name_1 v_categories_name_2 v_categories_name_3 v_categories_name_4 v_categories_name_5 v_categories_name_6 v_categories_name_7 v_tax_class_title v_status EOREOR

Dezina ZenCart Templates
Please do not PM for support queries..Post in forums..help others

16 May 2007, 9:55 AM
#706
vampke avatar

vampke

New Zenner

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

Re: Easy Populate 1.2.5.4 support

misty:

vampke.. you have some missing options..should come after
v_manufacturers_name
i.e
v_categories_name_1 v_categories_name_2 v_categories_name_3 v_categories_name_4 v_categories_name_5 v_categories_name_6 v_categories_name_7 v_tax_class_title v_status EOREOR

okay thanks, apparently while trying to redownload the file, they were there!
not sure what happened there...
:wacko:

16 May 2007, 11:15 PM
#707
gxjenkins avatar

gxjenkins

Zen Follower

Join Date:
Apr 2007
Location:
Tampa, Florida
Posts:
180
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Is there any way to use EP to change "Always Free Shipping" from no, to yes?

If not, do you know of any other way to update that setting for 4000 items?

Thanks.

Gary Jenkins
Your Neighborhood Store
It Ain't Over Until You Quit, So Don't!

17 May 2007, 4:24 AM
#708
rikko101 avatar

rikko101

New Zenner

Join Date:
Mar 2007
Location:
Hope Mills, North Carolina, United States
Posts:
14
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

When I upload my tab delimited file to the database, I seem to be losing some of my product names and desciptions. Of the 9000 products that I upload, I'm missing about 2000 name and desciptions. All the rest of the information is there. BOTH the name and description is missing from each product with missing data, not some descriptions here and some names there. Any ideas?

17 May 2007, 5:08 AM
#709
chadderuski avatar

chadderuski

Totally Zenned

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

Re: Easy Populate 1.2.5.4 support

Rikko:

A couple things come to mind:

  1. you have a strange character in the text file like and escape character or sequence

  2. your do not have the eofrec (i don't remember what the right name it off hand) field filled-in in every record. This is a MUST or the program doesn't konw it should move to the next record and will try to stuff everything into one record.

  3. possibly an empty field that is not gettig tab delimitted

I made errors myself that related to all three of these. You should make sure your file is of type txt and NOT rtf. You want a plain ascii file.

I have not used the product much yet, but this is my experience to date. Hope this is helpful

17 May 2007, 8:45 AM
#710
scrat avatar

scrat

Zen Follower

Join Date:
Dec 2005
Posts:
451
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

rikko101 - I would think you are trying to upload too many products at once and you are experiencing a time out, as qouted from the Readme.txt in EP...

TIMEOUTS: You may experience timeouts when adding/updating large numbers of products. If you have a large file that times out, you can use the "Split EP File" option. This will create multiple files containing a maximum of 300 records (default - you can change this in Admin). Thus, 1000 products will produce 4 files. These files are created in your /temp/ folder, from where you can upload each in turn after they have been split. If 300 is too many or too few for your circumstances, adjust it in Admin -> Configuration -> "Easy Populate".

gxjenkins - No EP standard will not change "Always Free Shipping" from no, to yes? you could use a SQL statement.

mafiasam - If you upload the Full-EP file with your stock qty in the v_products_quantity field this should update your stock qty.

17 May 2007, 3:41 PM
#711
gxjenkins avatar

gxjenkins

Zen Follower

Join Date:
Apr 2007
Location:
Tampa, Florida
Posts:
180
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Thanks, I'll look into constructing a statement to change that setting.

Gary Jenkins
Your Neighborhood Store
It Ain't Over Until You Quit, So Don't!

17 May 2007, 6:22 PM
#712
sirbuck avatar

sirbuck

Zen Follower

Join Date:
Jan 2007
Location:
Carlsbad, CA
Posts:
161
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Here's my problem..

I have used EP to upload about 3500 products.
When I look in the admin-> Catalog-> Catagories/Products... Its show the correct number of active products. However, when I go in to view them, they aren't there.. They are also not showing up from the user side in the store.

Has anyone run in to this problem before?

:frusty: thanks,

-Buck

17 May 2007, 6:35 PM
#713
scrat avatar

scrat

Zen Follower

Join Date:
Dec 2005
Posts:
451
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

SirBuck - Again it may be a time out issue you are trying to upload too many products at once, make your upload file smaller (Splitting them as suggested in the readme.txt)and try uploading them !!!

17 May 2007, 6:50 PM
#714
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Easy Populate 1.2.5.4 support

Echoing scrat - Sirbuck,

Try doing this with only one product first to insure that you are using this tool correctly - get this procedure down before attempting a larger upload

i.e. one product added and available both in the front and back end
(of course, you have a DB backup prior to attempting this?)

Zen-Venom Get Bitten

17 May 2007, 8:42 PM
#715
sirbuck avatar

sirbuck

Zen Follower

Join Date:
Jan 2007
Location:
Carlsbad, CA
Posts:
161
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Scrat & Kobra

Thanks for the replies. Smaller file is a good idea. After trying one product, I realized that my problem was No Product Name.
Since that was left blank, the database wasn't populated with the rest...since "product_name" is indexed.

Added that and everything works fine.

thanks again guys, had I not broken down the file and tried the single upload, I wouldn't have caught it for a while.

You guys rock

-Buck

18 May 2007, 12:51 AM
#716
fakedecoy avatar

fakedecoy

Zen Follower

Join Date:
Jul 2006
Posts:
309
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I'm downloading the Google Products feed from EP, and the prices shown for all products are the base price, not the sale price as created by salemaker. Is there anything I can do? I'll manually edit it the feed file before uploading to Google Products if I have to, but it would take a while, and I'm hoping for a way to avoid doing it on a continuous basis.

Adamant Barbell - Home & commercial gym equipment - Since 2007
www.adamantbarbell.com

18 May 2007, 1:13 AM
#717
fakedecoy avatar

fakedecoy

Zen Follower

Join Date:
Jul 2006
Posts:
309
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I figured out the salemaker price thing in my previous post - In easypopulate.php I did a replace-all on "p.products_price" to "p.products_price_sorter".

Adamant Barbell - Home & commercial gym equipment - Since 2007
www.adamantbarbell.com

18 May 2007, 1:49 AM
#718
rikko101 avatar

rikko101

New Zenner

Join Date:
Mar 2007
Location:
Hope Mills, North Carolina, United States
Posts:
14
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Thanks for your help, Chadderuski
I'll check the strand character thing again. I thought it might be extra tabs but no.
And the "eofrec" Heheh, the EOREOR is at the end of every row. It would skip the whole row anyway. Got to get this fixed.

18 May 2007, 1:53 AM
#719
rikko101 avatar

rikko101

New Zenner

Join Date:
Mar 2007
Location:
Hope Mills, North Carolina, United States
Posts:
14
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Scrat:

rikko101 - I would think you are trying to upload too many products at once and you are experiencing a time out, as qouted from the Readme.txt in EP...

gxjenkins - No EP standard will not change "Always Free Shipping" from no, to yes? you could use a SQL statement.

mafiasam - If you upload the Full-EP file with your stock qty in the v_products_quantity field this should update your stock qty.

Thanks Scrat
I'm only uploading 1500 product at a time and it completes the upload.
I've tried 20 products and still get the same results. Maybe a bad character somewhere.
Any other suggestions?

18 May 2007, 5:49 AM
#720
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Easy Populate 1.2.5.4 support

rikko101,

Read the earlier posts and suggestions to sirbuck....same for you - get a single item to work correctly and then use this as your template for the large upload

Zen-Venom Get Bitten