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 861 to 880 of 3,834
30 Jul 2007, 10:14 AM
#861
awev avatar

awev

New Zenner

Join Date:
Mar 2007
Posts:
42
Plugin Contributions:
0

Easy Populate 1.2.5.4 support

Just a quick reply, as I am headed out the door to work, and the land of restricted intranet, not internet.

As to why leave out the add products ability in the paid version I do not know, as I am not the developer, yet I have a feeling it has something to do with GPL, so he most likely had to rewrite the code for the program if he is to compile it into a binary form for copyright protection.

As to the wiki, I'll take a look in the next couple days.

The file to be edited would be /Your Store/admin/easypopulate.php and it is mainly a matter of adding definitions and pairing up v.___ = p.___ Careful, there is more to it than just that, yet that is how you get started.

30 Jul 2007, 5:31 PM
#862
admcompa avatar

admcompa

New Zenner

Join Date:
Mar 2007
Posts:
44
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Hi,

If somebody can come up with a way of making EP work with the MAP Price contribution that would be great. I am will to pay somebody if the price is right to make My ep so I can upload my MAP Prices required by my manufacturers. Thanks

Doug

30 Jul 2007, 10:07 PM
#863
jaden avatar

jaden

New Zenner

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

Re: Easy Populate 1.2.5.4 support

Hi,

I bought Easy Populate Pro a month ago and I have found that the documentation falls short of going all the way. The latest version (4) has a readme file that stops befor telling you how to upload your files, that is organise all your data into the correct columns. Also you have to search to find these templates.

Now I am very keen to use this software as it looks like a great tool to compliment Zen Cart, and I don't want to affend anyone, but the support is very lacking. If I could get the final procedures I would write them up myself and post them here for others to get over that last hurdle!

A lot of others have been able to go all the way with the software so it must be possible for those of us with a little bit of web savy?

So anyone who can go explain the final stages I would very much appreciate it.

Thanks

30 Jul 2007, 10:36 PM
#864
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

and I don't want to affend anyone, but the support is very lacking.
Official support for this is at the place you purchased this and not on this forum.

This forum is for those to share their experiences which you are doing but do not confuse this and trash this forum for lack of support.

Zen-Venom Get Bitten

31 Jul 2007, 9:07 AM
#865
jaden avatar

jaden

New Zenner

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

Re: Easy Populate 1.2.5.4 support

OK fair enough, I suppose I was just fishing for a solution. As I said I do believe it to be very good software and I am very keen to use it! I apologise as I have a lot of respect for the Zen Cart forum people as they take a lot of time out to help people like myself.

Whe I find a solution I will post it if others want.

Thanks

1 Aug 2007, 10:14 PM
#866
eddie_irvine avatar

eddie_irvine

New Zenner

Join Date:
Jul 2007
Posts:
9
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Hi,

I am really struggling to get my online shop to function correctly and would appreciate it if anyone could help.

Firstly when I upload product and I go into the category to check them I get the first layer i.e Suspension Technology then Spax then lowering springs then make of car then model then when i click on the last level instead of getting the product details i get a drop down menu with a,b,c,d etc

I am also unable to view my products in the admin section Catalogue>catagories/products. I just get a blank page.

Also when I uploaded my last products I got the following message

Warning: explode() [function.explode]: Empty delimiter. in /home/jiperfor/public_html/store/admin/includes/functions/extra_functions/easypopulate_functions.php on line 241

and aswell as uploading the products correctly it also uploaded some of them as a seperate catagory.

if you go on the site you will see what I mean

https://www.JI-Performance.com
The product I uploaded was in Suspension Technology>Spax>Lowering Springs>etc

It also, however loaded up a top lever of Spax>Suspension Technology>spax>Lowering Springs> then the listing for one manufacturer but when you try to select and of the products you get the drop down menu as described previously.

If anyone could have a look at the site for me I would greatly appreciate it as its getting to the point where I just cant do anything with it

2 Aug 2007, 3:26 AM
#867
awev avatar

awev

New Zenner

Join Date:
Mar 2007
Posts:
42
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

The explode error means that when it read the file in it did so as a big blob, and now it is trying to separate the different parts. It is finding something wrong, maybe you used something like ""Q's" gadgets" in the file, and it is seeing double quotes, and strips of the first pair of them, leaving something that looks like Q's" gadget (only one quote mark, not paired up with anything). In any case, it is not able to break the file up into its individual components.

As to the items being hidden in the admin's catalog I seem to recall that it involves something being set, or not set, in the database. It may be something as simple that the quantity is set to 0 (zero) if you didn't include a quantity in the upload. Sorry, I last had that problem near the first part of the year, and can't recall what I did to correct it, other than use a database tool to reset the value. It may also be the date, and how it is formatted.

2 Aug 2007, 3:54 AM
#868
awev avatar

awev

New Zenner

Join Date:
Mar 2007
Posts:
42
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Just found out about the explode thing in the old forums (available for reading/review only). It seems as the date is not formated correctly. Have a look at this post: http://www.zen-cart.com/forum/showthread.php?t=22180&page=65 This is in response to the prior page (page 64) of the old forums, encountering the same problem.

In Admin > Configuration > Easy Populate -> Make Zero Products Inactive, is that showing as true or false?

2 Aug 2007, 9:25 AM
#869
peekay avatar

peekay

Zen Follower

Join Date:
Jun 2006
Location:
U.K.
Posts:
103
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I have been using EP with success to upload products in batches of around 400 at a time. Best tips I can give are:

  1. Product must have a model number.
  2. Model number must be unique.
  3. Category name must match existing ZC category name EXACTLY.
  4. NO line breaks in product description +
  5. EOREOR must be at end of every record.
  6. Export as plain text file (.txt).
  7. Export settings should be:
  • TAB delimited.
  • Text qualifier = NONE.
  • Include field headings as first row.

If you view the exported file in Notepad there should be no visible delimit between records. I find I can use quotes, commas and slashes in product titles.

  1. If you don't have a 'temp' folder in ZC root, create one and CHMOD 777.
  2. In Configuration/Easy Populate:
  • Make sure temp folder path is correct
  • Set date format to d-m-y for UK, or as appropriate.
  • Although EP should handle line breaks in the product description, I had a problem with this. I don't know why. If you have issues, might be something to check.

I confess I haven't downloaded, edited and re-uploaded any data yet. :wink:

2 Aug 2007, 12:01 PM
#870
eddie_irvine avatar

eddie_irvine

New Zenner

Join Date:
Jul 2007
Posts:
9
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Thanks for the replys. I really appreciate it. I'll give it a go today. There are a few of the points which I dont fully understand being new to this as it wasnt myself who designed and built the site.

2 Aug 2007, 1:12 PM
#871
eddie_irvine avatar

eddie_irvine

New Zenner

Join Date:
Jul 2007
Posts:
9
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

awev:

Just found out about the explode thing in the old forums (available for reading/review only). It seems as the date is not formated correctly. Have a look at this post: http://www.zen-cart.com/forum/showthread.php?t=22180&page=65 This is in response to the prior page (page 64) of the old forums, encountering the same problem.

In Admin > Configuration > Easy Populate -> Make Zero Products Inactive, is that showing as true or false?

The makes zero products inactive is showing false. The all products are set to 0 quantity

2 Aug 2007, 1:22 PM
#872
eddie_irvine avatar

eddie_irvine

New Zenner

Join Date:
Jul 2007
Posts:
9
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Could it be anything to do with the fact that I have / in some of my product catagories?

i.e

http://www.jiperformance.com/store/index.php?main_page=index&cPath=21_21448_22185_22390_22399

apart from that im not sure what is meant by

you are using an illegal date separator in your dates, or they are not raw dates. You can only use "." (period), "/" (slash) or "-" (hyphen).

2 Aug 2007, 6:26 PM
#873
phil020782 avatar

phil020782

Zen Follower

Join Date:
Jul 2007
Posts:
158
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Hi,
I installed easy populate standard a few days ago and I just have a few quick question if anyone could answer them for me please.

  1. if I enter a catagory in the excel spreadsheet that does not exist in my store will that catagory be automatically created when the file is uploaded?

  2. Is there anything to stop me from adding attribute columns to the main spreadsheet so that I can insert products and the relevant attributes all from the same file?

  3. Regarding the attributes, is there anyway to set the attribute flags from the spreadsheet so if its a required text attribute for example I can set it in the spreadsheet rather than having to go into attribute controller and change them?

Thanks
Phil

2 Aug 2007, 11:27 PM
#874
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

Phil,

EP is not an extensible tool but does what it does well, Follow these steps and if you have created and set the permissions correctly for the itmes in the install instructions you will get a file downloaded that contains what it is that you can use this for.

alexClarke:

1 - From admin click on tools>easy populate.
2 - Click on Download Complete tab-delimited .txt file to edit (Attributes Not Included).
3 - Import this file into Excel and make changes to various records.
4 - Export the file from Excel (making sure it's still in Tab Delimited format.
5 - Back to easy populate... On Upload EP File click on Browse and select my file (the one I exported from Excel).
6 - Click on Insert into db.

Zen-Venom Get Bitten

3 Aug 2007, 12:36 PM
#875
phil020782 avatar

phil020782

Zen Follower

Join Date:
Jul 2007
Posts:
158
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Hi kobra,

I have EP working perfectly as described above my main concern was to see if its possible to set attribute flags, such as required text and display only etc, from within the tab delimited text file. I realise this would have to be done in the attribute file rather than the complete but can you tell me what columns would need adding to the file to set the flags?

Thanks

3 Aug 2007, 4:09 PM
#876
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

EP does not do attributes.... and one can not add or extend it for reasons that I am not sure of having not disected the code.

Attributes have many many cross entries and are best handled via admin

Zen-Venom Get Bitten

3 Aug 2007, 5:49 PM
#877
phil020782 avatar

phil020782

Zen Follower

Join Date:
Jul 2007
Posts:
158
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

kobra:

EP does not do attributes.... and one can not add or extend it for reasons that I am not sure of having not disected the code.

Attributes have many many cross entries and are best handled via admin

It does do attributes, I've already done it but it doesn't set the attribute flags just the name and values

4 Aug 2007, 4:40 AM
#878
admcompa avatar

admcompa

New Zenner

Join Date:
Mar 2007
Posts:
44
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Anybody working on easy populate. I need it to be able to upload my map prices to my products. If someone can make this work I would be willing to pay some for it. Thanks

Doug

4 Aug 2007, 11:23 PM
#879
awev avatar

awev

New Zenner

Join Date:
Mar 2007
Posts:
42
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Hello Admcompa,
First, you have to know what table in the database MAP is using, and also what fields you would need to update.

Next, open the easypopulate.php file that is in the admin directory, into a text editor, you don't want to use a word processer if you can help it, they like to add stuff for formatting of the text, etc. If you have anything like HotDog or Crimson Editor you should not have a problem editing things, nor seeing the differant parts of the code (color coding of code is nice ;) ).

If there is a goto command you may want to use that, and tell it to go to line 1280 or so for staters. In the text editor press <ctrl>+F for find. Enter v_ as the string to search for, and you will begin finding a lot of it. You realy don't need the find command if you jump to (goto) line 1280. If you want to set a MAP price of 0 (zero) as a default value, then you would add it to the end of the "$default_these = array( " array as something like 'v_map'. This is where the info you gathered at the start, such as database table and fields come in handy.

Now we use the find command to find '$sql = "SELECT' without the single quotes ('). In the unmodified version it should be around line 1429. Under the line ' subc.catergories_id as v_categories_id' you will want to add ' m.map as v_map', then in the table section add a comma to ' ".TABLE_PRODUCTS_TO_CATEGORIES." as ptoc'. Now add an entry for the table you are using, something like ' ".MAP." as m' This section checks to see if it is a new item, or if you need to update some information.

Press <F3> for the find again command, or whatever your text editor has assigned to the find again/repeat find command. You will be able to search for $sql = "UPDATE and $sql = "INSERT as well. The main thing is to add pairs of values, being left = right, such as database_table_value_1 = file_value_1, and telling it what tables in the database to use. The file has a fair amount of comments, a lot of it is notes from langer to himself, what he probley used to re-write the code for EPA 3.x - the commercial version.

Sorry, without spending a day or two creating a DIY or howto, and figuring out everything (maybe rewriting it myself, just not very likely at this point in time), I am limited in what I can provide insctrution wise here. Since we are mainly concerned about uploading product info in batches, enmass, we are looking at the upload section. The download area is probley best left alone for now, and the froogle section is dated, and handled by other modules now days.

For all of those interested, line 1806 of the unmodified code, version 1.2.5.4, is the start of adding categories to the store :D

5 Aug 2007, 12:02 AM
#880
johnd avatar

johnd

Zen Follower

Join Date:
Oct 2006
Location:
New Jersey, USA
Posts:
119
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Images not displaying after upload of EP.

I uploaded about 50 items today and most of the images didn't display on the site.

Here is my process:

  • uploaded all images to store/images
  • created my EP spreadsheet using filenames that I uploaded
  • uploaded my EP spreadsheet
  • admin message indicated all items uploaded successfully
  • opened store to view the products that were uploaded
  • less than half had images
  • I checked to make sure that the case was correct on filenames
  • went to admin-->catalog-->cat/prod-->product; all products had correct image filenames
  • so, I had to use admin to load images to products individually Is this EP shortcoming?

Thanks