Apsona ShopAdmin - a free tool for import/mass update/reporting

dw if you dont have anything constructive to add to this conversation will you just lay off

I’ve just installed the Apsona ShopAdmin module on a test site on a local server using WAMP 2.0

I’m using ZC 1.3.8a and I have patched my database to use PHP 5.3

I am getting the following errors when navigating to Admin>Tools>Apsona ShopAdmin

When I click on that link, a second browser opens and the following is all that is on the page.

*Deprecated: Function ereg() is deprecated in C:\wamp\www\ZenCart\includes\classes\db\mysql\query_factory.php on line 177

Deprecated: Function ereg() is deprecated in C:\wamp\www\ZenCart\includes\classes\db\mysql\query_factory.php on line 177*

I checked the db and the two additional files were written to it..

Would it be that the addon is not yet PHP 5.3 compliant, or is there another issue/easy fix..

Mike_Dean - I doubt that this is a ShopAdmin issue. This looks like the issue that has been discussed in this thread: http://www.zen-cart.com/forum/showthread.php?t=147583

Please let me know if you find out otherwise, however.

Regards,
Apsona
http://apsona.com

htm2112 - To make doubly sure, I tested ShopAdmin on a GoDaddy installation, and it seems to work. I appreciate your choice of going with another hosting company, but I'm saying this simply because I don't want to leave people with the impression that GoDaddy is to blame entirely for this problem. I'm guessing that it was some sort of transient issue that you ran into, and I'm very glad it is resolved.

Regards,
Apsona
http://apsona.com

Can I just say that we have installed Apsona on our website, and apart from a few teething troubles, I think it is a really good program.
The people at Apsona have been very good in helping us overcome some problems. Requests for support have been answered quickly and efficiently.

I see nothing suspicious about this program.

Shaunus:

Can I just say that we have installed Apsona on our website, and apart from a few teething troubles, I think it is a really good program.
The people at Apsona have been very good in helping us overcome some problems. Requests for support have been answered quickly and efficiently.

I see nothing suspicious about this program.

I looked around as well. And nothing took me by surprise. I didn't find anything in their terms and restrictions that was out of the ordinary although I guess as an open source hacker I would like to have a little more control over the source code but that's their prerogative.

It actually seems like a cool program that is working as well if not a lot better then the mess easy populate is. As soon as we hire someone to keep all of our products updated I'm going to look into it so they can utilize it.

Not sure what dw08gm's problem is.. and I'm certainly not going to pay to find out ;)

Mike_Dean:

I’ve just installed the Apsona ShopAdmin module on a test site on a local server using WAMP 2.0

I’m using ZC 1.3.8a and I have patched my database to use PHP 5.3

I am getting the following errors when navigating to Admin>Tools>Apsona ShopAdmin

When I click on that link, a second browser opens and the following is all that is on the page.

*Deprecated: Function ereg() is deprecated in C:\wamp\www\ZenCart\includes\classes\db\mysql\query_factory.php on line 177

Deprecated: Function ereg() is deprecated in C:\wamp\www\ZenCart\includes\classes\db\mysql\query_factory.php on line 177*

I checked the db and the two additional files were written to it..

Would it be that the addon is not yet PHP 5.3 compliant, or is there another issue/easy fix..

Maybe I am misunderstanding you, but your problem is right there if you are running PHP 5.3x. ereg is a deprecated function in 5.3x which means it is no longer supported in php. The query_factory.php is a core Zen-Cart file. Change the !ereg to ```
!preg_match

Better yet, if you're using PHP 5.3, then it's time for you to upgrade to ZC v1.3.9 which has already been written to be compatible with PHP 5.3.
Don't bother messing with core files ... it's a much better investment of your time to upgrade to code that's already been fixed for you.

DrByte:

Better yet, if you're using PHP 5.3, then it's time for you to upgrade to ZC v1.3.9 which has already been written to be compatible with PHP 5.3.
Don't bother messing with core files ... it's a much better investment of your time to upgrade to code that's already been fixed for you.

Thanks,

I have done that, tried the add-on on a completely clean 1.3.9b and PHP5.3 but it still did not work.

If I used PHP 5.2.11 on ZC 1.3.9b, the add-on worked.

So I can only conclude (probably wrong tho..!) that whilst the mod will work on ZC 1.3.9b, it will not work on PHP 5.3.

What errors did you get in 139?

DrByte:

What errors did you get in 139?

In admin, click on Tools>Apsona ShopAdmin

It opens a new browser as it should, but I get a blank page with a image of a circular timer, going round and around..!

I don’t get any errors on the screen, just the blank page as described above.

Nothing else happens, it just sits there with the timer going round and round....

Mike_Dean - I am unable to reproduce this problem. With a clean brand new install of EasyPHP 5.3.2i (the latest) on my Windows 7 box, and a clean fresh install of ZenCart 1.3.9b on top, I see ShopAdmin working fine.

In any case, I will send you a PM with some alternatives to try.

Thanks.

Apsona
http://apsona.com

All I needed to see to know this is worth my time investigating is here:

Customer testimonials

"All in all an excellent offering. I really like it, and I think it could be quite useful to Zen Cart vendors." – Scott Wilson, That Software Guy

"I am very impressed with ShopAdmin. As a developer, I wish it came with Zen Cart because it would make my job so much easier! Comparing it to Easypopulate? No contest, this wins hands down. I will be glad to recommend it to customers."
— Delia Lunsford, Web Consultant, Delia Wilson Design

That plus the constructive comments (vague unsupported comments do not help the community) I've seen posted in this thread are good enough for me to investigate and test this app out for myself.. I only have one question for the community:
Is any one using this with one of the working SEO mods (Ceon's URI or SSU)

it can be used with anything I think as it doesn't touch the core files at all.

I don't know about using it with mods that change the default database tables like products, etc.

I had a chance to work with apsona myself this past week and it's definitely easier to use than easy populate as it looked at my first glance.

One of the best things is that the Apsona team is interested in improving it - so any suggestions one makes to them is listened to. They are eager to please and have the facility to do it. They didn't just do something for free and throw it out there like most modules. (I speak from personal experience - it's really difficult for me to make changes to mods I've done unless someone volunteers for the development time.)

And this is what I need to know.. I asked not from the perspective of it (Apsona) touching core files but the fact that it updates product tables, etc. It is my understanding that EZ Populate messes up (removes) the stored URIs generated by the Ceon URI module. (This is and other issues with EP is why I've stayed FAR away from EP)

I'm happy to test this myself (and I will do just that). I just wanted to know if the community had any experience with this app and SEO mods..

delia:

it can be used with anything I think as it doesn't touch the core files at all.

I don't know about using it with mods that change the default database tables like products, etc.

I had a chance to work with apsona myself this past week and it's definitely easier to use than easy populate as it looked at my first glance.

One of the best things is that the Apsona team is interested in improving it - so any suggestions one makes to them is listened to. They are eager to please and have the facility to do it. They didn't just do something for free and throw it out there like most modules. (I speak from personal experience - it's really difficult for me to make changes to mods I've done unless someone volunteers for the development time.)

I just used the ceon mod recently - does it store the uri's in the product tables? I dont' recall.....

A further update...

We've had Apsona installed for a couple of weeks now.

It's been great for updating existing products, but we've still not got it to import new products properly.

Main issues:

There seems to be a number of required fields for a new product, which I can't really see the relevance of. These aren't required when updating existing products.

I can't upload a a new product unless I leave the Product Type field blank. Entering 'Product - General' will not work.

The 'date available' needs to be set to yesterday's date else any products added only appear in the 'Products Expected' area.

The supporting documentation is a bit vague. For example in the sample csv file it shows the 'Enabled' column as having data values of either '1' or '0'. I found out that it won't work unless you enter 'yes' or 'no'.

Any products uploaded using Apsona cannot be edited or deleted in Zen Admin. This has stopped us for the time being because we use FCK Editor for our tabbed product descriptions, but anything new cannot be edited!

All in all, there's the bones of a really good programme here, but it still needs refinement, it kinda 80% does what we need it to.

My suggestions:

From the fields currently setup in Apsona, allow users a setting to customise what the required fields are for new uploads and updates. That way each business can use Apsona how they want to and not have to bother with fields irrelevant to them. For example, we only want to upload Model, Name, Manufacturer Name, Price, Quantity, Enabled, Date available, as this is what we get on our supplier sheets.

Possibly include some kind of CK Editor within Apsona, making it a true one-stop interface for product uploading and editing...this would really speed things up!

Lastly, allow Apsona to recognise Manufacturer Name for new products. Having to type in the manufacturer ID makes it difficult because it means more manual input onto a supplier sheet. The supplier will always provide the manufacturer name, so Apsona really should recognise it in an upload, without the user having to add a column to their csv file then lookup all the manufacturer IDs.

Apsona have responded well to my e-mail queries, and they have received feedback well. I just hope they can develop Apsona some more and make it a 100% useful program.

delia:

I just used the ceon mod recently - does it store the uri's in the product tables? I dont' recall.....I believe it does.. From what I understand EZ Populate doesn't play nice with this.. As I said, i will test all this myself this weekend.. Just wanted to get some feedback from the community.. :smile:

good points and good information!

Hello folks,

Just a couple of points to add to Shaunus:

• For the "required" fields, generally we have tried to conform to the "non-null" field specifications in the Zen Cart database. We will re-examine these and fix as needed.
• If you don't specify a product type when importing, or leave it blank, it will leave the product type field empty in the database. So there will not be a type handler PHP page within Zen Cart for that product. Net effect, the product cannot be edited nor deleted from within Zen Admin. I do believe that ShopAdmin checks that any value specified matches an existing picklist value for product type, but I will verify that.
• The manufacturer name lookup is to be done. The problem is that the manufacturer name does not uniquely identify the manufacturer, so ShopAdmin insists on the manufacturer id instead. And that is perhaps not the best thing from a usability perspective. ShopAdmin definitely needs work here.
• The 'Enabled' column should allow either '1' or 'yes' or 'y'. But again I will verify that.

Having said all that: Apsona ShopAdmin is still a work in progress, and we're delighted to get the amount of positive feedback we have been getting. Please continue to let us know any issues you find, and we will gladly fix them.

Thanks for letting us be a part of this wonderful community.

Apsona
http://apsona.com