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,111

Results 581 to 600 of 3,834
23 Feb 2007, 10:54 AM
#581
langer avatar

langer

Totally Zenned

Join Date:
Aug 2004
Location:
Sydney, Australia
Posts:
1,258
Plugin Contributions:
1

Easy Populate 1.2.5.4 support

omfgsignmeup:

I've been forwarded to this thread because I asked how to populate a ZenCart site using a .tsv (tab separated values) file. Now, I don't believe this is compatible with Easy Populate but I could be wrong? If not, is it at all possible to import the stocklist.tsv file into Microsoft Excel then export it as a .txt file ready to import with Easy Populate?

Easy Populate uses tab separated files - the file extension is irrelevant, and is used by applications to easily identify their accepted files - it has no bearing on the actual file format.

You will need to format any file you use to conform to the column headings and the explicit end of row marker (EOREOR) expected by Easy Populate.

23 Feb 2007, 11:01 AM
#582
rsprinkel avatar

rsprinkel

New Zenner

Join Date:
Feb 2007
Posts:
73
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Ryk,

In reply to yours, I am not sure as to why it didnt show the EOREOR in the ZenCart Admin section, but trust me all 87 lines have it. Here is a line direct from my excel file

1:64 SCale/items/Jim 028.jpg1999 W.C. #3 Car, Stats and Standings Book1999 Winners Circle. #3 Dale Earnhardt Sr Chevrolet w/Stats and Standings Book150001-01-010001-01-01162/22/20072/22/2007 11:461Winners CircleNascarEarnhardt Sr1:64 Scale--none--1EOREOR

Scrat,

Well the first 87 lines I entered are all in the same categories/Sub categories as the ones that were already in the database, nothing different, nothing added.

I am wondering if one of the tables that was filled in should be blank when added and thats the columnh for date added. AS that has a Time in it as well. Alot of the columns that was going to have the same data in I just dragged and then Filled/Down to avoid alot of typing and possibly making mistakes.

omfgsignmeup,

Wish I could help ya, LOL. I know nothing of the .tsv you speak of. Good Luck

Thanks for your replies and I hope someone can help me out on this one. As I only have about 3000 sq ft of Store of Items to add :wacko:

RSPrinkel

RSprinkel

23 Feb 2007, 12:33 PM
#583
scrat avatar

scrat

Zen Follower

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

Re: Easy Populate 1.2.5.4 support

RSprinkel - you might have got one or more tabs in the file open it up again in excel and see if you have extra columns?

23 Feb 2007, 12:41 PM
#584
rsprinkel avatar

rsprinkel

New Zenner

Join Date:
Feb 2007
Posts:
73
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Hi Scrat,

Ok would these extra columns have column names? I have several columns labeled as :v_categories_name_4and so on up to _name_10 with nothing in there.

Also I am supposed to have columns for each category? Reason I ask is I created a Category in ZenCart and it showed in the Cat ID as 9 and there was no v_categories_name_9 in the excel sheet.

Just trying to get info here. Like I said I have a 3000 SF store without exaggeration to add and this is the MOST EASIEST way of doing such.

Thanks Scrat

RSprinkel

23 Feb 2007, 2:17 PM
#585
scrat avatar

scrat

Zen Follower

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

Re: Easy Populate 1.2.5.4 support

Post/PM your file and lets have a look at it?

23 Feb 2007, 2:26 PM
#586
rsprinkel avatar

rsprinkel

New Zenner

Join Date:
Feb 2007
Posts:
73
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Scrat,

Thanks much for all the help.

PM sent. I added you to my Buddy List so you could reply back that way if needed.

Again Thanks.

Ron

RSprinkel

23 Feb 2007, 3:57 PM
#587
rsprinkel avatar

rsprinkel

New Zenner

Join Date:
Feb 2007
Posts:
73
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Scrat,

Thanks much for the help. GREATLY Appreciated.

Now if I can get my other issue resolved :wacko: I WILL be making the switch to ZenCart :yes: :yes: :yes:

Didn't know I had to modify the product model column.

Again Thanks. Worked like a charm

Ron

RSprinkel

23 Feb 2007, 5:55 PM
#588
grayceworks avatar

grayceworks

New Zenner

Join Date:
Jan 2007
Location:
Atlanta, GA
Posts:
71
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

could you please post what you had to do to make it work? what did you have to modify on the column?

Thanks!

give me feedback on my home decor store

sleep is a symptom of caffeine deprivation

COFFEE.SYS Not Found: User startup disabled.

~~ if(pot.coffee=EMPTY) {programmer->;brain=OFF}; ~~

23 Feb 2007, 7:01 PM
#589
rsprinkel avatar

rsprinkel

New Zenner

Join Date:
Feb 2007
Posts:
73
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

The first column is v_products_model

The model number has to be different ie.

product1
product2
product3

and so on.

Thats pretty much what I had to change as mine was all the same. Once changed it worked like a charm.

Hope that helps.

Ron

RSprinkel

23 Feb 2007, 10:38 PM
#590
lextechs avatar

lextechs

Zen Follower

Join Date:
Mar 2005
Location:
Tempe, AZ
Posts:
316
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

When i upload products i get this message. But it seems to go through normal expect not all of the products from the file is upload. anyone know what that message is and a fix for it?

Empty delimiter. in /home/keepnitr/public_html/lextechs/admin/includes/functions/extra_functions/easypopulate_functions.php on line 241

Lextechs.com Powered By ZenCart

25 Feb 2007, 3:30 AM
#591
nhradeuce avatar

nhradeuce

New Zenner

Join Date:
Sep 2006
Posts:
64
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

lextechs:

When i upload products i get this message. But it seems to go through normal expect not all of the products from the file is upload. anyone know what that message is and a fix for it?

Empty delimiter. in /home/keepnitr/public_html/lextechs/admin/includes/functions/extra_functions/easypopulate_functions.php on line 241The easiest fix for this problem is to add a column called v_date_added and populate the column with =NOW() for each item.

25 Feb 2007, 9:16 PM
#592
ctcentralinfo avatar

ctcentralinfo

Totally Zenned

Join Date:
Apr 2005
Posts:
853
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Will easy populate work with the books type mod?

Rich People scream, Wealthy people whisper

https://www.cooltechcentral.com

27 Feb 2007, 3:49 PM
#593
divaboutiques avatar

divaboutiques

Zen Follower

Join Date:
Feb 2007
Location:
Worldwide Web
Posts:
191
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I have uploaded all the files for the eas populate but I notice I am getting an error when i try to log into my admin area:
Fatal error: Call to a member function on a non-object in /home/divabou/public_html/Catalog/admin/includes/languages/english/extra_definitions/easypopulate.php on line 202. How do I clear this error I have went already to the file to check it out but I am still getting the error. Please help someone!!!:shocking:

Diva Boutiques
www.divaboutiques.com

27 Feb 2007, 4:21 PM
#594
scrat avatar

scrat

Zen Follower

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

Re: Easy Populate 1.2.5.4 support

Fatal error: Call to a member function on a non-object in /home/divabou/public_html/Catalog/admin/includes/languages/english/extra_definitions/easypopulate.php on line 202.

Check you have uploaded this file!

27 Feb 2007, 10:03 PM
#595
cartdiscounts avatar

cartdiscounts

New Zenner

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

Re: Easy Populate 1.2.5.4 support

Is it possible to use easy populate to bulk upload other product information?

I installed a module that allows me to add a separate price that only appears when the product is added to the cart.

I can only add this price manually where you add/edit products in zen admin.

here is a link to a product I enabled the module - I am looking to add the price that shows up in the cart to the easy populate feed so I can upload a separate price for several products at once.

http://cartdiscounts.com/index.php?main_page=product_info&cPath=1_2_3_5&products_id=27418

Any help would be greatfull!

28 Feb 2007, 11:16 PM
#596
yellowdaises avatar

yellowdaises

New Zenner

Join Date:
Nov 2006
Location:
Los Angeles
Posts:
91
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

is it possible to upload v_product_description_1 without having to use the full txt file?

28 Feb 2007, 11:17 PM
#597
yellowdaises avatar

yellowdaises

New Zenner

Join Date:
Nov 2006
Location:
Los Angeles
Posts:
91
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

RSprinkel:

Ok I am NOT a happy camper, LOL.

I just spent every bit of 3 hours adding 87 items to excel, saved the file as text file required. I then went into the admin section and hit browse for upload. Went to the file and then clicked "Insert into Db". It showed the files as being uploaded and once completed I went to the test site and NOTHING is showing.

I had 3 items already in the db prior to doing this and they are the only 3 showing.

At the bottom of the upload I got this message and I am NOT sure if it is the reason why nothing is showing.

Next to last line reads:

Last Line reads:

Any help on this WOULD be much appreciated.

Thanks in Advance.

RSprinkel

it is probably b/c you have an extra blank field at the bottom of your file...

1 Mar 2007, 10:28 AM
#598
scrat avatar

scrat

Zen Follower

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

Re: Easy Populate 1.2.5.4 support

yellowdaises :- You need the whole product information, meaning:

v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_specials_price v_specials_date_avail v_specials_expires_date v_products_price v_products_wholesale_price v_products_weight v_date_avail v_date_added v_products_quantity v_manufacturers_name 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

so if you upload a edited product with just 'v_product_description_1' and all the rest of the columns empty it will not import as it does not have a 'v_products_model' to assign the product too. If you just upload with 'v_products_model' & 'v_product_description_1' again it will error as it needs price, category,eoreor etc.

You do need to give all the fields to update the product because if you leave any others out it will overwrite the information in the database. Its is updates all the fields.
So just download the complete file open in excel delete the products that you do not want to update, alter the product field and re upload. ( remember to keep the header ).

Re RSprinkel's problem this was happening as he did not have a separate v_products_model for each product:-

product
product
product

should be :-

product1
product2
product3
etc

:yes:

3 Mar 2007, 12:43 AM
#599
pivey avatar

pivey

Zen Follower

Join Date:
Mar 2006
Posts:
192
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Hello Nicolas,

finally found some time to participate to your tiny little support thread:D
Fine tool, I use it for months now...

BUUUUUUUUT!! Please try to fix the stupid issue regarding the master category.
I am using v1.2.5.4 (have the advanced but don't use it yet)
The master cat is not updated (inserted) in new data import, so I have to do manual work to have this correct.
It is an issue which does not allow other mod's to work properly.

IIIIIIIIF there is already a fix, I appologize :blush: ..could you point me there?

Take care

7 Mar 2007, 1:12 AM
#600
michellewardley avatar

michellewardley

Zen Follower

Join Date:
Nov 2004
Location:
Port Neil South Australia
Posts:
295
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Scrat:

Date and time format should be :-

yyyy-mm-dd h:m:s

You should be able to import the file again and it will re - import all the dates and times etc.

Are there any other settings in the easypopulate tools in the configuration menu that effect this? I still can get it to work. Can you please confirm the column header for me too? cheers

Michelle Wardley
Fine Artist & Musician