Haggis:
You're probably right
Everything is easy when you know how. However for me, I've already spent too much of my life learning new things & not enough experiencing life. It's why I now earn less than a 10th of what I used to but I actually have a life outside of work.
You did & I appreciated it but put it this way, I've never used php/mysql before so you probably won't be surprised it took me over 30mins just to find where to change the page title. So the thought of adding in something to what is totally new to me ZenCart wasn't my first option. My fault of course because I just assumed the function would be in there somewhere, just thought I was too blind to see it.
Well, I would think (hope?) that the other tool is self-standing and does not require merging with other code, considering what functionality it adds though it could also be such that it is added to various files on the admin, merging, yes that will require at least seeing the code, following, directions, and as necessary posting a question at the applicable form thread. EP4 (and perhaps a few others), doesn't overwrite any code of the ZC system, it doesn't require any knowledge of SQL and works from a CSV. Yes there are some base "requirements", like dates in the CSV need to be formatted in a YYYY-MM-DD sequence so if you use something like Excel, you'll have to do a little rearranging of default/column settings. The text as read by EP4 should be quoted with the double quote "" with a comma separating each field in a row of data. The program now supports the ability to use straight products_id's but it is still suggested to use a unique model# instead for each product (even if that model# is the products_id), anyways, no code nor sql knowledge necessary. Does help to understand database operations like that a primary key represents a unique entry, each table that is supported for import and is accessed/used by EP4 uses/provides a piece of information associated with the primary key and the primary key itself. If the same primary key is listed more than once in the file, then the data from the row furthest to the bottom will populate all of the fields associated with that primary key with the "newest" data and if an identified category doesn't yet have that product related to it will be linked (which is part of what you are trying to eliminate). Currently unlinking product with EP4 requires a little careful planning as there is no "remove link" action yet identified.
Anyways, sorry got into a bunch of techno speak... Point is, yes have to use one's noodle a little to understand, but the instructions provide the basic requirements, and the rest pretty much is like using the admin screen. Other plugins, they were built to meet the requirements posed and possibly to take the ability further into being more of a central part of the program rather than just a menu option. But regardless, run into issues, post to the applicable location, more than likely someone will be by to help out. Just ask that whenever trying to identify an issue, address the items of the posting tips. Gives a good, no great, starting point to identify how to reproduce the issue.
