Easy Populate 1.2.5.4 support

[chadderuski]

No luck though, either I do apertiate the help though. the "Update ALL Products Price Sorter"
always locks up with the "Internet Explorer cannot display the webpage" error I get when I upload files. Maybe I am doing somthing wrong with the form sheet. Do I leave the special priceing sections in or remove them, or put in a field to show they are not used?

I reload my original inventory file and all the priceing comes right back.

1) Download and use FireFox and throw IE in the trash

2) Could you either link your problematic model/price/qty file or PM it to me? I seem to remember an issue in EP with this when I was making model/price/breaks work.

Are you specifying dates or data for the v_specials_price, v_specials_date_avail, and v_specials_expires_date? IF NOT, delete these columns. AND

Are you ending EVERY line with EOREOR? AND

Have you made sure you have NO data in any column after the EOREOR column? Hilight a dozen or so columns after EOREOR and delete them for good measure.

-cj

[Rob-adrenalfuel]

Update on my issue, hopefully someone can help.

Whenever I attempt to download a file from the easy populate console the admin prompts me to log in, and won't actually allow me to log in until I clear my zen cart cookies. I wonder if this is something to do with my store using .htaccess files?

Similar things occur when I tried to uninstall easy populate using the YOUR_ADMIN/easypopulate.php?langer=remove address in my browser

Really am stuck with whats causing this

[motobuddy]

1) Download and use FireFox and throw IE in the trash

2) Could you either link your problematic model/price/qty file or PM it to me? I seem to remember an issue in EP with this when I was making model/price/breaks work.

Are you specifying dates or data for the v_specials_price, v_specials_date_avail, and v_specials_expires_date? IF NOT, delete these columns. AND

Are you ending EVERY line with EOREOR? AND

Have you made sure you have NO data in any column after the EOREOR column? Hilight a dozen or so columns after EOREOR and delete them for good measure.

-cj

I apertiate your time, after I deleted the two rows after and started using firefox it started working.
Everything is looking good.

[fmckinnon]

Hey Gang,

I'm using the newer Easy Populate CSV 1.2.5.6.csv.2 version, so I hope there is help here, I didn't see thread for that specific version.

When I upload my file, it seems to be accepted fine, but the products that I upload aren't showing up anywhere - not as active or inactive, and then when I export from EasyPopulate, it's not there.

I'm uploading the .csv and after hitting "insert into db" I get the following response:

File uploaded.
Temporary filename: /tmp/phppIRoVJ
User filename: gsn-epfile.csv
Size: 1652

Upload Complete

This is a link to my file I'm uploading - can anyone give me any idea why this isn't showing up? Even the category I put in there (ie. MacBook 13", etc) doesn't show up ... the manufacturer "Abbi" is a brand new one for our store, and it doesn't show up ... basically, even though the response above suggests the file uploaded properly, it doesn't seem to be going into the database.

Link to my file:
http://www.getskinsnow.com/gsn-epfile.csv

I'm running the latest, updated version of ZenCart, 1.3.8 A

[Renz]

I would like to put in for two requests for a new version, and for now, some advice on how to get done what I want to do (Hacking EP to make it work like I want)

First off, reading the code, it looks like it would be fairly easy to add a feature where users can customize a "map" so they can upload a spreadsheet from a supplier's inventory list (without it needing to be zencart compatible) and the headings from that .csv would be "mapped" to the correct fields (I.E. ProdImage => v_products_image )

That way in admin user can set up their own mapping for the data files they wish to upload (or even better a simple point and click interface)

for example, have an area (probably in config) that users can upload a truncated spreadsheet (headings plus 1 row of data) and the code would parse it and display it in a couple of rows, with the required rows for easypopulate below or above , and take the number value from easypopulate fields and enter it to the new spreadsheet rows , indicating which column matches which (it's easier to visualize than to explain) and when everything is set, save the values, with a name they choose - and use that map to parse data from the user's uploads, and they could select the "format name" from a drop down list , default easypopulate .. and easypopulate could simply use that "map info" to parse the given spreadsheet and match it up with what's required.

it would save a massive amount of time. (I'm currently digging around in the code to figure out how to make this happen to direct upload a Doba spreadsheet without altering it)

and Secondly, add a couple of fields to easypopulate for "cost" and "markup" so the user could also include their cost price of the item and customize the markup % , rather than having to figure it for each item, or use the list price. - even better, make it so that markups can be calculated based on a formula set in config (I.E. < $10, markup 40% , $10.01 - $100 markup 30%, $100.01+ , markup 20%) - (I actually have a script that I run commandline right now to parse a "updates" file from supplier with quantity,price,available date, minimum advertised price, and list price, on which I do that sort of operation - but it would be nice to be able to simply upload a fresh spreadsheet with updated data and letting easypopulate calculate the price according to formula)



Now, as for the above two features, I am going to be developing this for myself and a client as well (and probably others that will also want this feature, once they find out about it) an I would like some advice from developers on where the important stuff of the code is- namely - which file and where is the parsing done that reads in the easypopulate csv file and pushes it into the database - and also where is the actual updates to database being done.

It'd help immensely in reading unfamiliar code..

WOW sounds like a God Send....has this happened or any part there of.....I know it would certainly make my life a lot easier.

[Renz]

This Zenner Could Really Use Some Help Please!!!

I have read every single one of these 254 pages of posts, but I am in somewhat of a confused state about which one of the EP modules to install and from where to download it.

I have Zen 138a..On PHP 5.2.1
My supplier sends me some sort of Jumbled up CSV file daily which has a heap of products most I sell some I dont.
My cart has already loaded by hand around 500 products only about 25 with attributes....
This appears the hot favourite Version 1.2.5.4 namely Langer's version from Modhole....

Also someone mentioned the following a few pages back..............Does anyone know anything about this? I am a little nervous about getting it.....at $ 149.00 and dont know what the benefits are vs the free versions.

Any help and opions would be really appreciated.

Thanks
Renz


------------------------------------------------------------------------

Store Manager for Zen Cart is a Windows application

[schoolboy]

Store Manager for Zen Cart

That is a client-side management interface from MagneticOne. I have "test-driven" it and I liked it very much. This does not constitute an endorsement for the product, but is just my opinion of their software.

[ckosloff]

Store manager is a commercial product, and I have seen some disguised advertising in this forum for it.
I am not saying this last post is, but certainly others were.
I don't think that they offer trial periods.
Unable to say if it handles complex attribute structures properly.

[Renz]

Hi again....

schoolboy, many thanks I'll let you know the outcome.

ckosloff, no sir no plugging here, but I see you are in the same boat as me for attributes (from another post in this forum) from my weeks worth of reading on all EP vs, I am confused about them and merely poking and hoping to end in the right direction even if I have to trial that comm vs.

My needs as previously are to try and decipher what my supplier sends me as some sort of Jumbled up CSV daily file which has a heap of products most I sell some I don't.
My cart has already loaded by hand around 500 products only about 25 with attributes....

What vs do you have currently? Have yo had any luck with Attributes?
Thanks R

[chadderuski]

Renz, take a look at this as it may help with your attribute issue if they are straight forward. I only came across this, and have not tested it:

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

EP Advanced does do attributes to some degree but I have not test it much. I have begun picking at a solution for attributes, but this may take some time (paid work prevails). I do not think the logic in even Langer's advance version is "correct". Needing 100+ columns to do attributes? I exaggerate only a little. I think my solution may work much better, but time will tell.

-cj