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

delia:

To recap all the issues I've run into and their solutions:

all zen cart versions
secure admin: if you are running admin in secure mode two changes must be made to the files provided by apsona
apsona_config.php - change url to https://service.apsona.com
apsona_index.php - about line 42 change the url to https://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js (adding in the s for https)

1.5.3
Use the apsona_functions.php file posted twice in this thread most recently in post 601

Change the admin configure file to hard code in the admin path as it used to be done. This is not difficult simply comment out this line in yourShopAdmin/includes/configure.php:

define('DIR_WS_ADMIN', preg_replace('#^' . str_replace('-', '-', zen_parse_url(HTTP_SERVER, '/path')) . '#', '', dirname($_SERVER['SCRIPT_NAME'])) . '/');

> and replace it with this 
> ```php
define('DIR_WS_ADMIN', '/your shop admin folder/');//steve apsona 

Then replace this line

define('DIR_WS_ADMIN', preg_replace('#^' . str_replace('-', '-', zen_parse_url(HTTP_SERVER, '/path')) . '#', '', dirname($_SERVER['SCRIPT_NAME'])) . '/');

> with this line 
> ```php
define('DIR_WS_HTTPS_ADMIN', DIR_WS_ADMIN);//steve apsona  

(Commenting out means placing // with a following space before the line.)

If you have done both of these for 1.5.3 and still get an error, try using an entirely new browser to check again. If nothing works your hosting company may be the problem. I've tested this on three different servers including my own which is highly secure with many closed ports etc. Apsona does not require anything special in the way of a hosting environment but there was mention earlier in this thread of possible mysql problems with a hosting company. This should work on every server.

wtashby, I was not getting anywhere until I made those changes to the admin configure and was getting both loading with that error message and a load of a non-working apsona page where no data was displayed between the three servers. Let me know if this works for you.

This worked PERFECTLY!!!! Thank you so much for your help. I hope everyone that has this issue finds this solution.

Ok, after using the above fix, I was able to access Apsona, and get as far as importing (a portion) of my product file. Of 2500+, after "Importing" only 900 (always 900), I get > The server is not responding. Please check your network connection.

Status: error. Then, if I cancel the upload, and try again, I get > System progress bar unavailable: Maybe some other component is using it?

I've tried reading through the thread but haven't found (not yet at least) a reason or solution for this.

Delia, do you know anything about why this may be happening, or a possible fix?

There are previous posts along this line. As I said, I think that you have to start looking at server issues. I've never ever had any problem with Apsona and I have installed in it many carts.

delia:

There are previous posts along this line. As I said, I think that you have to start looking at server issues. I've never ever had any problem with Apsona and I have installed in it many carts.

What server are you using. I'm using Namecheap, and until Apsona, I've never had an issue with them either. This is the first plugin that's ever caused any "server based" issues for me.

I work with clients all over the world on many different servers. Don't know that I've ever worked on their servers before. I have two servers of my own as well.

Here is a screen shot of the import page and the error I keep getting. As you can see, the import stops at 900, and then the error pops up. Every single time.

There is at least one post in this thread about this and I believe he solved it by moving to a new host.

Hi guys,

I am hoping that Apsona is monitoring this thread. I have now mailed them twice to resend me the installation files as I upgraded to Zencart 1.5.3 and need to reinstall this addon. Unfortunately I have not had any replies from them.

If they are not responding to this post, is anyone willing to share their copy of the installation files with me? You can send me a PM.

Louis, did you read any of the posts before now? Please go back and read post 608 and pick up the file in post 601. Once you make those changes, you should be good to go.

I'm not seeing this work with 1.5.4. Don't see why there would need to be changes but it has to be in the functions torvista. Have you checked it out yet?

Works for me in 1.54 locally, and I have not done anything extra.
Is this local, with a local configure?
Exactly what happens?

argh, tried a different browser and success. dummy.....

I too am having the problem with the blank page and the "loading" circle thingy'. I have Zen 1.51, godaddy servers and have my admin section set to secure in my configure file. My ShopAdmin used to work, and at some time in the past months it quit working. (I don't know if it's related or not, but my Authorize.net AIM module quit working also, but I was able to fix that by uploading the current v1.54 updated Authorize.net AIM files). I uploaded the apsona_functions.php from post #601. After I do that, the 'loading circle thingy' disappears, but page is still blank. Then, I believe that I tried every combination of the other recommended changes, including the changes at the top portion of the quote below. Actually, I don't know if I tried 'not' doing the changes at the top, and only doing the changes at the bottom (I assume there is a typo in that bottom code on post #608, but not post #592?). I see the changes are for v1.53, but I tried them all anyway. I also tried different browsers. I have looked through many pages of these posts, and I can't seem to find a fix. I could be missing something. Heck, I don't even know what version of mysql is being used. I know very little about the tech part of all of this. If anyone can give me some help, I would really appreciate it. If I missed something I will apologize in advance; I don't want to waste anyone's time because I didn't read something. I have 2000 products, and it's almost impossible to update products without spending a few days. Any help or advice would be greatly appreciated. Thanks!!

delia:

To recap all the issues I've run into and their solutions:

all zen cart versions
secure admin: if you are running admin in secure mode two changes must be made to the files provided by apsona
apsona_config.php - change url to https://service.apsona.com
apsona_index.php - about line 42 change the url to https://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js (adding in the s for https)

1.5.3
Use the apsona_functions.php file posted twice in this thread most recently in post 601

Change the admin configure file to hard code in the admin path as it used to be done. This is not difficult simply comment out this line in yourShopAdmin/includes/configure.php:

define('DIR_WS_ADMIN', preg_replace('#^' . str_replace('-', '-', zen_parse_url(HTTP_SERVER, '/path')) . '#', '', dirname($_SERVER['SCRIPT_NAME'])) . '/');

> and replace it with this 
> ```php
define('DIR_WS_ADMIN', '/your shop admin folder/');//steve apsona 

Then replace this line

define('DIR_WS_ADMIN', preg_replace('#^' . str_replace('-', '-', zen_parse_url(HTTP_SERVER, '/path')) . '#', '', dirname($_SERVER['SCRIPT_NAME'])) . '/');

> with this line 
> ```php
define('DIR_WS_HTTPS_ADMIN', DIR_WS_ADMIN);//steve apsona  

(Commenting out means placing // with a following space before the line.)

If you have done both of these for 1.5.3 and still get an error, try using an entirely new browser to check again. If nothing works your hosting company may be the problem. I've tested this on three different servers including my own which is highly secure with many closed ports etc. Apsona does not require anything special in the way of a hosting environment but there was mention earlier in this thread of possible mysql problems with a hosting company. This should work on every server.

wtashby, I was not getting anywhere until I made those changes to the admin configure and was getting both loading with that error message and a load of a non-working apsona page where no data was displayed between the three servers. Let me know if this works for you.

I use Apsona a lot and have not had that problem now. I was having a similar problem a while ago, and what was happening is that my login to my Zencart Admin site had timed out, and Apsona could no longer access it. I am not a programmer, so I really don't understand how all of this works, but try to login to your ZenCart Admin site and then immediately go to Apsona to do what you need to do. If you get the swirly thing again, log out of your admin site and relog in and try it again.

Additionally, I have 10,000 SKUs, and the admin site times out before I can update all of them, so I have to create 4 seperate batches. While I very much appreciate all of the work that the Zencart team is doing, sometimes the "improvements" that zencart makes to improve security can actually be detrimental to some of us.

Hope that works.

Thanks SPembletonk, but that didn't work. Still get the swirly thing. Anyone else with suggestions would be greatly appreciated. Is there another plugin that will allow me to edit my price, qty, etc via a spreadsheet on my computer and then upload?

I am updating and redesigning my ZenCart to 1.5.4 from 1.5.1 and I want to use Apsona Shop Admin on it. I don't use it often but I find it extremely effective/time saving when I do. I found that I need to recover my welcome packet and my password (normally I keep things like that religiously but for some reason I didn't or it might have been that someone was helping me out and they didn't keep it when they put on the Apsona). I have used their form and written to them three times and called them once and left a message (I don't think that anyone answers that phone but they do have an answering machine). Is there some other way to contact them, or are they impossible to get hold of and I would be better off registering as another e-mail address and just make sure to keep all of the information myself this time? Or would that just cause more problems than it solves and I would be better off doing something else? Thank you.

Please refer back to post 608 for instructions. Apsona does not provide support.

Delia, I believe you. Perhaps my problem was that I believed this on their site:

Get Apsona ShopAdmin to work for you today!

• ShopAdmin is offered free of charge for as long as you want to use it.
• Free e-mail support

...their words, not mine. I will go back and read your post #608 carefully. If anyone else knows how to contact them, please say so. Thanks.

I have tried contacting apsona, with no luck. I have also followed all instructions that I can in this post, but nothing I have tried has worked. I believe our best bet is to start a new thread about this specific problem. ZenCart Forum folks will eventually get to the bottom of this, I'm sure. They always do. Not that they're not helping here, but perhaps with another thread, specific to this problem, more people will see it. This is the best Forum I have ever been a part of, so I'm positive we will get this fixed. If anyone reading this starts a new thread or finds a solution, please IM me and let me know where the thread is located. Thanks!

They have not updated their site I think since it went up. They aren't supporting it. period . the . end.