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 561 to 580 of 3,834
18 Feb 2007, 12:25 AM
#561
verdon avatar

verdon

Zen Follower

Join Date:
May 2004
Location:
Northern Ontario, Canada
Posts:
373
Plugin Contributions:
0

Easy Populate 1.2.5.4 support

Sounds like a mod_security or similar sort of thing. I'd talk to your host / system admin.

BTW... 777 is never a good idea, and should only be last resort.

18 Feb 2007, 5:49 PM
#562
mbheald avatar

mbheald

New Zenner

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

Re: Easy Populate 1.2.5.4 support

Ok, non of the chmod settings worked other than 644. Setting the file to anything higher caused an internal database error. I talked to my system admin and he doesn't know how to fix the problem. any other ideas?

Matthew Heald
All Hot N' Bottled - Retail
http://hotnbottled.com

Hot Shots Hot Sauce - Wholesale
http://hotshotshotsauce.com

18 Feb 2007, 6:42 PM
#563
verdon avatar

verdon

Zen Follower

Join Date:
May 2004
Location:
Northern Ontario, Canada
Posts:
373
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

mbheald:

Ok, non of the chmod settings worked other than 644. Setting the file to anything higher caused an internal database error. I talked to my system admin and he doesn't know how to fix the problem. any other ideas?A quick google shows that this is not something specific to zen-cart or EP, but is a server issue. Try there and skim a few results.

http://www.google.com/search?q=%22%22Not+Acceptable:+An+appropriate+representation+of+the+requested+resource%22

19 Feb 2007, 1:15 AM
#564
steverf avatar

steverf

New Zenner

Join Date:
Feb 2007
Location:
Perdido Beach, Alabama
Posts:
34
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Well, I am attempting my second "stock" install of ZC. Hopefully the new setup will give me more speed. The next BIG issue will be Easy Populate... I have looked at the thread here and everyone seems to be having trouble with EP... It is essential that a program like EP work each and everytime... There is NO WAY to use ZC if we cannot import a store products listing after a minimal setup of a few of the catagories, products and attributes. Getting EP to work without screwing up the database is imperitive.... So bottom line here...
What is the MOST Current Version ? Where do we get it ?
Does it really work ? Safely ?

Hope the EXPERTS will jump in and tell us all the truthful gory details !

SteveRF

SteveRF

19 Feb 2007, 9:15 AM
#565
ryk avatar

ryk

Totally Zenned

Join Date:
Oct 2004
Location:
Southport, UK
Posts:
3,644
Plugin Contributions:
6

Re: Easy Populate 1.2.5.4 support

steverf:

There is NO WAY to use ZC if we cannot import a store products listing after a minimal setup of a few of the catagories, products and attributes.

Absolute bull! There's always the old-fashioned method of manually entering your products! OK, I accept there may be no way for YOU to use it - I'm only pointing this out for the benefit of the noob who might just see that comment and thinks that s/he needs EP to add a handful of products or they must abandon ZC.

Think about it - the only people who post here on the EP support thread are those for whom things HAVE gone wrong; the hundreds (thousands?) who have no problem with it don't keep posting to say "I have no problem" :wink2:

So, the most recent version is available from http://www.zencartbuilder.com . This is the pro, paid for, and you get support from the author. However, unless there's been some major changes since I last looked, you MUST HAVE your complete category structure in place; EP does NOT create categories for you.

Development Manager @ JSWeb Ltd - suppliers of Applepay/Googlepay for Zencart
20 years with Zencart !

19 Feb 2007, 6:21 PM
#566
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

Hi! Happy Presidents' Day! :)

I was working just fine w/ easy populate and then all of a sudden i'm getting this message:

Warning: Invalid argument supplied for foreach() in /home/.../public_html/admin/easypopulate.php on line **1996

**I have not changed a thing in my .php file since it was working fine earlier this morning.

If anyone could point me in the right direction that'd be WONDERFUL. Thanks

19 Feb 2007, 7:33 PM
#567
nomadrip avatar

nomadrip

Zen Follower

Join Date:
Feb 2007
Location:
Calabasas, CA & St. Pete, FL
Posts:
87
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Ryk:

So, the most recent version is available from http://www.zencartbuilder.com . This is the pro, paid for, and you get support from the author. However, unless there's been some major changes since I last looked, you MUST HAVE your complete category structure in place; EP does NOT create categories for you. If you are talking about the Pro version, this may be true, but the version I got here DOES create categories if you import a product(s) and type in category and sub-cat names in the txt file...saved me some major setup time, once I figured out how I wanted each item categorized.

-James

-James Starting from scratch!
Started out w/ZenCart 1.3.7 (No upgrades)
http://www.nomadicmoto.com/
Review my site here: http://www.zen-cart.com/forum/showthread.php?t=63630

19 Feb 2007, 9:38 PM
#568
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

yellowdaises:

Hi! Happy Presidents' Day! :)

I was working just fine w/ easy populate and then all of a sudden i'm getting this message:

Warning: Invalid argument supplied for foreach() in /home/.../public_html/admin/easypopulate.php on line **1996

**I have not changed a thing in my .php file since it was working fine earlier this morning.

If anyone could point me in the right direction that'd be WONDERFUL. Thanks

I really would appreciate any help/suggestions...

BUMP

19 Feb 2007, 11:36 PM
#569
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

ok somehow this went away but now...

MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '11.4900" ,manufacturers_id=1 , products_status=1
WHERE
(products_id' at line 3
When executing:
UPDATE zen_products
SET
products_price="19.95" ,products_image="../catalogartwork/VP-DCM10B2VP.jpg", products_weight="0", products_tax_class_id="", products_date_available= NULL, products_date_added= "2007-02-01 08:53:29", products_last_modified=CURRENT_TIMESTAMP, products_quantity="20, products_price_w="11.4900" ,manufacturers_id=1 , products_status=1

i'd really appreciate any help b/c i'm at the point where i want to pull my hair out... THANKS

20 Feb 2007, 10:10 PM
#570
hugslife avatar

hugslife

New Zenner

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

Re: Easy Populate 1.2.5.4 support

it looks like the query is missing an end quote
the query reads
**products_quantity="20, products_price_w="11.4900"
**where it ought to be
**products_quantity="20", products_price_w="11.4900"
**
hope that helps you out!

ps---has anyone come up with a solution for incorporating product types into easypopulate?

yellowdaises:

ok somehow this went away but now...

MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '11.4900" ,manufacturers_id=1 , products_status=1
WHERE
(products_id' at line 3
When executing:
UPDATE zen_products
SET
products_price="19.95" ,products_image="../catalogartwork/VP-DCM10B2VP.jpg", products_weight="0", products_tax_class_id="", products_date_available= NULL, products_date_added= "2007-02-01 08:53:29", products_last_modified=CURRENT_TIMESTAMP, products_quantity="20, products_price_w="11.4900" ,manufacturers_id=1 , products_status=1

i'd really appreciate any help b/c i'm at the point where i want to pull my hair out... THANKS

21 Feb 2007, 1:28 AM
#571
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

Hi there. Having some problems with the date format on the new easy populate. Its making my products expected in 2008 etc. Can someon please clafify the correct date format for excel I have tried yyyy-mm-dd h:m:s yyyy-mm-dd h:m
dd-mm-yyyy & yyyy-mm-dd

HELP!

Once the products are added to the database can I adjust these values or do I need to delete them & add them again?? (that will stuff up any favourites & saved cart references though)

Michelle Wardley
Fine Artist & Musician

21 Feb 2007, 8:39 AM
#572
scrat avatar

scrat

Zen Follower

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

Re: Easy Populate 1.2.5.4 support

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.

21 Feb 2007, 1:45 PM
#573
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

I may be misunderstanding what I'm reading in the instructions, but will removing items from the downloaded product file remove them from my database?

I have this installed, but have been afraid to try it because it took forever to get my database fixed last time I tried to upload products.

Basically I need to know if I'm understanding the functions correctly.

I downloaded a "complete" file.

I made changes in excel, and saved as the same type of txt file as I downloaded.

If I upload the changed file, does it overwrite existing products with the changed items of the same model number? or does it upload everything in the file as new items? I don't want duplicates.

By the same token, if I upload a file that only contains new items, and does not have existing store items in it, will it delete items that are not in the new file?

I just don't want to mess stuff up... lol

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}; ~~

21 Feb 2007, 2:34 PM
#574
scrat avatar

scrat

Zen Follower

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

Re: Easy Populate 1.2.5.4 support

The model number is unique to that product, so if you download a 'Complete' download and then alter one or more products in excel and upload the new file it will update all the records in the file whether they are changed or not. Thus it will give you a 'update' against the imported product. If you just upload a new product this will not remove any products from your database it will just import the new product.

Too delete a product from the database in column marked 'v_status' change from 1 to 9 and this will delete the product using the upload file.
But alwasys back your database up first before uploading new products.

21 Feb 2007, 3:40 PM
#575
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

Thanks... That's what I was trying to figure out.

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}; ~~

21 Feb 2007, 4:12 PM
#576
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

hugslife:

it looks like the query is missing an end quote
the query reads
**products_quantity="20, products_price_w="11.4900"
**where it ought to be
**products_quantity="20", products_price_w="11.4900"
**
hope that helps you out!

That's awesome. I'm going to check that out right now... Great eyes !!! :)

23 Feb 2007, 2:35 AM
#577
rsprinkel avatar

rsprinkel

New Zenner

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

Re: Easy Populate 1.2.5.4 support

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:

UPDATED! - Model: 1:64 SCale | /items/Sr | 1999 Revel | 1999 Revel | | 19 | 0001-01-01 | 0001-01-01 | 30 | 0 | | 2/22/2007 | 3 | Revell | Nascar | Earnhardt | 1:64 Scale | | | | | --none-- | 1 |

Last Line reads:

SKIPPED! - Model: - No category provided for this product | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |

Any help on this WOULD be much appreciated.

Thanks in Advance.

RSprinkel

RSprinkel

23 Feb 2007, 9:07 AM
#578
ryk avatar

ryk

Totally Zenned

Join Date:
Oct 2004
Location:
Southport, UK
Posts:
3,644
Plugin Contributions:
6

Re: Easy Populate 1.2.5.4 support

The only obvious thing to me is that you don't have the EOREOR column

Development Manager @ JSWeb Ltd - suppliers of Applepay/Googlepay for Zencart
20 years with Zencart !

23 Feb 2007, 9:18 AM
#579
scrat avatar

scrat

Zen Follower

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

Re: Easy Populate 1.2.5.4 support

Check your txt file that it had categories for the new products as the error is telling you that this line had no category for that product/model

23 Feb 2007, 10:27 AM
#580
omfgsignmeup avatar

omfgsignmeup

New Zenner

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

Re: Easy Populate 1.2.5.4 support

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?

I really need to know this and soon!

I have a client looking for answers. I want to use ZenCart because I'm familiar with it and it’s easy to edit!

Thanks!