Easy Populate 1.2.5.4 support

[schoolboy]

In what TABLE did you add these fields? They may need to go into the products table.

Then, look at the post by LANKEEYANKEE that shows how to ADD FIELDS TO EASY POPULATE (search for that thread.)

If, after following his method, you still get errors... ask your vicar to seek help from a higher authority...

[DaMixa]

Problem solved...(I think) I didnt follow this:

http://www.zen-cart.com/forum/showthread.php?t=57924

[DaMixa]

Sorry Schoolboy didnt see your response.
Ive added all fields in product table, I have them all working now apart from one thing.
One of the fields is wholesale price, one is a % field. The price field is populated by a formulae between these fields , basically giving a , say, 25% markup on my wholesale price. now THATS the bit I cant get to work yet.

I have all field showing on admin so I can add one test product in Admin with all the fields, then I download an ep file with the one product in. When I add another product in the EP txt file and try to upload it it gives the SQL error and suggests I look to see if I have any spaces in my cells (or something like that)...

Sorry if that makes no sense at all, Ill post the solution when I find it!

Thanks Again

[chadderuski]

Thank you. At least i'm not super crazy in thinking them putting 4 different files is dumb. Nonetheless, I did attempt changing the column headings on the product description file and imported and it did work. However, it appears it is going to be quite a challenge as I will have to compile my own category columns as theirs is BS, which means a lot of work figuring out categories for 400 plus products that can go into multiple categories (for example one product can go into wedding favors, baby showers, bridal shower category etc.). This is just too time consuming.

Then there is the matter of products having multiple pricing tier. For example, one product can be purchased in different quantities. If they buy 1-11 products each price is XXX. If they purchase 11-20 the price is XXX. How would that work? The quantity with respective pricing is in the excel sheet, but how would I label the columns to have EP import that information?

It is just too much. Is there anyone out there willing to do this and I will pay? lol Seriously.

Hiya OhSoNew!

I think that I can help you with your multiple issues, but you would need to use my EP4 beta version. I call it beta, but it's very stable. I have several avid users doing 100K item imports/updates with it... but they probably are on either a VPS or running a full server. I can help with the tier pricing (which I wrote myself), categories in one field, and I have a "way" to do linked products that seems to work okay ... as long as you work within restrictions.

Also, there is a cool little Excel script that I use for doing things like sorted matched merges on multiple tables provided you have a common column to key on.

Please send me a PM. Your issue is too complicated to solve in this forum and I'll need to see your data. You can install EP4 along with 1.2.5.4. They are completely independent, so you won't break anything doing so.

https://github.com/chaddro/EasyPopulate-4.0

LOL! Schoolboy! My day job just made the move to SAP! The stories I could tell about the cluster-fudge this move has been!

-cj

[autumnlights]

Okay I think this is the right place to post my question. I have the files in the /temp/ folder of my site but I can't import them using EP. i just keep getting reverted to the login screen. I have tried switching browsers AND refreshing my cache, I look and I don't see any errors in the error log. I am not sure what to do. I am on a linux server and both my admin and temp folders have 755 permissions.

[schoolboy]

I have the files in the /temp/ folder of my site but I can't import them using EP.

What files are you talking about and how did they get there?

Does temp have 777 permissions?

[autumnlights]

yes temp has 777 permissions and its the .txt product files the sample ones and the one that I uploaded using FTP from my vendor. I can't get either to load on a linux server.

[chadderuski]

yes temp has 777 permissions and its the .txt product files the sample ones and the one that I uploaded using FTP from my vendor. I can't get either to load on a linux server.

Are you using https for all your admin access?

I believe ep 1.2.5.4 has problems when you set your admin to https and results in kicking you back out to login.

try changing your config.php for your admin and remove https.

let us know how that works.

[autumnlights]

i uninstalled and reinstalled everything. I ran it on my other server that's powered by Debian (I have two hosting sites) and it was able to upload the files but nothing populated to the tables. I manually broke the files up and got the same problem. I think there is a functionality issue with running on Linux with Hostgator but iPage I had no problem's uploading on Debian.

[nmcentire]

In regards to my previous question, I have crafted a solution together. For those of you who are trying to use easy populate with products with attributes - it seems that EP operates like this when uploading:


Step 1: Delete all items (and their attributes) from the database.
Step 2: Insert all items into the now 'empty' database, and set them active by default.


The issues with this are that:

(A) All inactive items are set active - and status isn't included in the attributes download - therefore items you have inactive (say for records/bookkeeping purposes) are set active and there's no check to set them as inactive.

(B) If you have products priced by attribute, you will have to turn around and manually set each item's default attribute or you will end up with order for items that total $0.00


How I fixed this:

Search for:

if ($products_with_attributes == true) {
//include attributes in full download if config is true
// VJ product attribs begin 

And change "true" to "false"

(In my file it was around line 400)

What this has done, is force the attributes to be included in the full download (The one that says "Attributes Not Included"), so you can update their status, their attributes, etc. without having to download/upload two files.

Search for

    $attributes_clean_query = "delete from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . (int)$v_products_id . "' and options_id = '" . (int)$$v_attribute_options_id_var . "'";
    ep_query($attributes_clean_query); 

And comment out those two lines of code.

(In my file it's around line 2180)

What this does is it kills the whole "Let's delete all the data and start fresh, even though we're not going to update the default_attribs value" process.

While there is most likely a multitude of ways to do this...this is the way I was able to finally get it to work. I have minimal amount of PHP knowledge to still be able to say "Yeah...I know some PHP", and the file I have to work with was already heavily customized. (There are entire BLOCKS of code that have been commented out, as well as what seems to be a running conversation in parts of the file via comments as well.) So this has been one frustrating experience. I hope to relieve some of the frustration others might experience.