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 661 to 680 of 3,834
22 Apr 2007, 7:46 PM
#661
dshealy avatar

dshealy

New Zenner

Join Date:
Apr 2007
Posts:
1
Plugin Contributions:
0

Easy Populate 1.2.5.4 support

When I click on the **Easy Populate Standard** link in the first post under Easy Populate Support, it tries to go to
http://www.modhole.com/modhole/index.php And the page gives the message: We're sorry, but you are using an unapproved downloader for this site.

Any help would be appreciated. Wonderful tool!

Thanks,
David

22 Apr 2007, 9:18 PM
#663
scrat avatar

scrat

Zen Follower

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

Re: Easy Populate 1.2.5.4 support

Standard EP

You want version EP_v1.2.5.4.zip

Edit:- didnot see the above reply when I logged on :yuck:

23 Apr 2007, 3:44 PM
#664
greybeard avatar

greybeard

New Zenner

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

Re: Easy Populate 1.2.5.4 support

Hello,

I have around 7000 items coming out of Quick Books directly into an excel spreedsheet that is all setup and can be imported into Zen carts with no real problems using easy populate.

The only problem i reall yhave at the moment is the live status of products...

On the spreadsheet, this field is blank unless we have updated the QB custom field setup for this. Basically we dont want to have to go thrgohu every single item and add the 0 to make it not live.

I dont want to directly edit the spreadsheet because this we get updated from quickbooks.

So, is there a way to make the default value 0 when no value is added, this is what it does for the tax feild...

Any ideas

Thanks

Rob

25 Apr 2007, 4:51 PM
#665
scrat avatar

scrat

Zen Follower

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

Re: Easy Populate 1.2.5.4 support

Greybeard - Don't really understand your issue, surely the easiest way is just to insert the column in your spreadsheet with '0'.
Other than that you would need to code a script to do this :unsure: for you.
Do you mean to up date your QB program ? or Easypopulate file, because each time you do a export from QB as a guess it will overwrite the txt file anyway, not a open and update the txt file.(might be wrong with that comment )
I use Python a lot to do csv and txt file stuff and it is very easy to learn this would be one angle to work at :bigups:

26 Apr 2007, 10:59 AM
#666
beto_pu avatar

beto_pu

New Zenner

Join Date:
Apr 2007
Posts:
14
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I just wanted to say thanks to Langer!!!! I spent a few days struggling to make osc EP work... A total waste of time so I decided to move to Zen Cart, I installed EP and it worked!!! 1st try.

Thanks man you're great

Regards from spain

26 Apr 2007, 5:55 PM
#667
hound avatar

hound

New Zenner

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

Re: Easy Populate 1.2.5.4 support

I am getting this error using Easy Populate

**No model field in record. This line was not imported

**If I am understanding this correctly, the model field is only used if you choose attribute pricing. I do not use any attribute pricing. The Product_Model field is blank for all products when I downloaded the file from the admin Easy Populate module.

If you do not use attribute pricing are you forced to put something in the field to get EP to work? I tried deleting the column and uploading the file and it gave me the same error.

Thanks for the help.

26 Apr 2007, 7:39 PM
#668
scrat avatar

scrat

Zen Follower

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

Re: Easy Populate 1.2.5.4 support

You need a unique product value for each product in the "v_products_model" field whether you use attribute pricing or not,other wise EP will not import.

26 Apr 2007, 11:28 PM
#669
greybeard avatar

greybeard

New Zenner

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

Re: Easy Populate 1.2.5.4 support

Scrat:

Greybeard - Don't really understand your issue, surely the easiest way is just to insert the column in your spreadsheet with '0'.
Other than that you would need to code a script to do this :unsure: for you.
Do you mean to up date your QB program ? or Easypopulate file, because each time you do a export from QB as a guess it will overwrite the txt file anyway, not a open and update the txt file.(might be wrong with that comment )
I use Python a lot to do csv and txt file stuff and it is very easy to learn this would be one angle to work at :bigups:

The problem is that if i just make the row in the spreedsheet all 0's, then when the data is refreshed in excel from QB it will no overwrite the info because the cells have ben manuall entered, and we are going to be slowly adding the item as and when the text and pictures are ready.

I am trying to see if there is a way to set up a default value in a custom field within QB, if tis works then it will be fine. I just want to avoid having to manually go through 7000 items makring them as inactive...

Rob

29 Apr 2007, 7:03 AM
#670
cartdiscounts avatar

cartdiscounts

New Zenner

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

Re: Easy Populate 1.2.5.4 support

I'm getting something new here.

I upload my files to the temp/ like I am supposed to, then I go to the easy populate page in admin - After a few minutes it just returns a blank page.

happens when I use the:
**Import from Temp Dir (temp/) & ****Upload EP File

** Zen Cart 1.3.7

**Easy Populate 1.2.5.4

Any Ideas?
**

Also getting the following when I try create file in temp/

Warning: fopen(public_html/temp/Category-EP2007Apr29-0303.txt) [function.fopen]: failed to open stream: Permission denied in public_html/admin/easypopulate.php on line 1089

Warning: fwrite(): supplied argument is not a valid stream resource in public_html/admin/easypopulate.php on line 1090

Warning: fclose(): supplied argument is not a valid stream resource in public_html/admin/easypopulate.php on line 1091

30 Apr 2007, 4:12 PM
#671
doodlebee avatar

doodlebee

Inactive

Join Date:
Jan 2006
Posts:
228
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Hey all. I was wondering if I could get a little hand here.

I needed to add 2 extra "description" fields to my products page. I did that, no problem - works like a charm.

I needed to edit the Easy Populate contribution to recognize and import/export these two new database fields.

Exporting? Check - no problem.

Importing is another issue.

I've tried several different ways of adding in the two new fields to the Easy Populate fields, but my syntax is all wrong, because either nothing happens at all, or I get a"foreach" error. I've narrowed the code I need to edit down to these areas...

Lines 335-339:

        $sql2 = 'SELECT * FROM (' . TABLE_PRODUCTS_DESCRIPTION . ') WHERE products_id = ' . (int)$row['v_products_id'] . ' AND language_id = ' . (int)$lang['id'];
        $result2  =& ep_query($sql2);
        $row2 = $result2->getRow(0, ECLIPSE_DB_ASSOC);
        $row['v_products_name_' . $lang['code']] = $row2['products_name'];
        $row['v_products_description_' . $lang['code']] = $row2['products_description'];
        $row['v_products_description2_' . $lang['code']] = $row2['products_description2'];
        $row['v_products_description3_' . $lang['code']] = $row2['products_description3'];

Lines 774-796

      $epLayout['products_description'] = array('products_name', 'products_description', 'products_description2', 'products_description3', 'products_url');
      $epControl['smart_tags'] = array('products_name' => false, 'products_description' => true, 'products_description2' => true, 'products_description3' => true, 'products_url' => false, 'products_short_desc' => true);
      if (isset($ep_supported_mods['psd']))
      {
        $epLayout['products_description'][] = 'products_short_desc';
      }
      $sql_array = array();
      foreach ($ep_languages as $lang)
      {
        if ($product_is_new)
        {
          $sql_array[$lang['id']]['language_id'] = $lang['id'];
          $sql_array[$lang['id']]['products_id'] = $v_products_id;
          $sql_array[$lang['id']]['products_name'] = 'new product';
        }
        foreach ($epLayout['products_description'] as $field_name)
        {
          if (isset($filelayout['v_' . $field_name . '_' . $lang['code']]))
          {
            $sql_array[$lang['id']][$field_name] = ep_smart_tags($items[$filelayout['v_' . $field_name . '_' . $lang['code']]], $epControl['smart_tags'][$field_name]);
          }
        }
      }

Now, the 774-796 seems to look right - to me anyway. But this section - as you see it - doesn't import the data. I've tried other variations on the theme, and get "foreach" errors 9on the line numbers I try my code on - they aren't in this example).

Would anyone happen to know what I'm missing/proper syntax to get those two extra fields to import the information properly? (Yes, "products_description2" and "products_description3" are the correct field names that are in my database table - and where you see that in the above code is where I've added it myself. As I said, I can get them to export fine 'n' dandy. I just need a little nudge for the import!)

I'd appreciate any help anyone can offer. Thanks!

30 Apr 2007, 8:17 PM
#672
doodlebee avatar

doodlebee

Inactive

Join Date:
Jan 2006
Posts:
228
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Oh my God, I am such an idiot.

Nevermind - the stuff above is right.

It would help if I actually put text into the excel file that I want to appear in the new fields. No wonder nothing was passing - I didn't put anything in the file to pass.

I'm sorry for being an idiot. Been trying to figure this out for three days, and there it is - I'm just dumber than a rock.

Thanks anyway!

1 May 2007, 5:06 PM
#673
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

Currently Using Easy Populate Standard. Everything work well on first upload and try and is proving very useful.

Am curious about two things:

  1. would be nice to have a pre-flight type tool to check for problem areas like duplicate model names, and anything else that may cause update issues.

  2. i see you plan on supporting quantity price breaks in a future update of the advanced version. How close are you to posting this? 90% of our 4000+ products have multiple price breaks based on quantity. Would definitely buy the advance version this feature alone.

Thanks

2 May 2007, 10:21 PM
#674
accurateoptics avatar

accurateoptics

New Zenner

Join Date:
Aug 2006
Location:
scottsdale
Posts:
15
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

i love easy populate. i have thousands of items to deal with. i've been using EP for over a year i think and then all of a sudden it just stopped working but i'm not sure how to trouble-shoot it. i tried uploading my new inventory txt file from the browser and also loading it from the temp file and no dice. i tried uninstalling EP in order to reinstall it and following the instructions here:

http://www.modhole.com/modhole/index.php?module=wiki&page=EpRemove

it claims to have 'installed' EP! no matter how i try to cram the new inventory into the cart, the browser just times out. the file size is only 137k and is less than half of what it usually was. :lamo: any ideas?

3 May 2007, 7:21 AM
#675
beto_pu avatar

beto_pu

New Zenner

Join Date:
Apr 2007
Posts:
14
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I'm having the same problem since yesterday, and no idea how to fix it... I will appreciate some help in this as my php skills suck.

Thanks on advance.

3 May 2007, 1:59 PM
#676
scrat avatar

scrat

Zen Follower

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

Re: Easy Populate 1.2.5.4 support

I had a similar problem a couple of weeks or so ago, I could not download the attributes file, and it would not download to the temp folder.
I also had an issue at the same time that my page 3 of 3 payment page was hanging if I used Cheque/Cash payment way.

If you have not changed any files to do with EP I would contact your hosting company as my problem was a hosting issue, it took some sorting as the hosting company said they had not changed anything in the period of time I was experiencing the problem. But after badgering them, I stressed I had not changed any files and I had reinstalled the files not working so they could not be corrupted files , that it had to be a hosting issue, they did some more testing and it all started to work again without problems.:clap:

3 May 2007, 3:25 PM
#677
accurateoptics avatar

accurateoptics

New Zenner

Join Date:
Aug 2006
Location:
scottsdale
Posts:
15
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Care to share who your host is? the site i'm running that has problems is on sashbox

3 May 2007, 3:28 PM
#678
accurateoptics avatar

accurateoptics

New Zenner

Join Date:
Aug 2006
Location:
scottsdale
Posts:
15
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

oh my gosh, i just tried it again this morning without making any changes and now it works! must be the host!

4 May 2007, 3:14 PM
#679
beto_pu avatar

beto_pu

New Zenner

Join Date:
Apr 2007
Posts:
14
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

You are luckier tan me... Still not working... It's starting to :censored: :censored: :censored: me the whole thing if it's my hosting company's fault, they are going to have an awful weekend I SWEAR!!!!

Thank you so much for your time :smile:

6 May 2007, 10:44 AM
#680
ilonka avatar

ilonka

New Zenner

Join Date:
Nov 2005
Posts:
51
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Hi
I have a question about the Complete tab-delimited .txt
What should i fill out and were? ( i am building the new shop in 1.3.7 )
In my current shop (1.2.6 ) i use the following fields ( not using easy populate ):

Product name
Taxable goods
price netto
priice bruto
Description
In stock
Product model
product image
sort order

But for some of the items i use the attribute controler cause i have 1 item with different quantity pricing.

Were and how can i use this in the txt file.
I have also downloaded the discount contribute. Which i thought could be better /easier than the Attribute controler…

Is it possible to use this in the txt file.
If so how and were.

Or is there an other way to add more prices for different quantities for 1 product in the txt file?

Thanks
Ilonka