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

Just to check, as you are using ZC1.54 it is ESSENTIAL that you make the changes mentioned in the readme to hard-code the admin paths.
Have you done that?
Any errors in the (F12) browser console when you start Apsona?

Note that trial-and-erroring is a bit hit and miss with Apsona as sometimes effects of changes are not immediate.
On first run Apsona stores a db report which if successfully created, will get used in the future and allow all to work even if you have made subsequent code changes that have broken it.
So you find that next time you open the browser, it doesn't work and you are left confused as you haven't changed anything since it last worked. But maybe a change you made did not break it immediately. A real debugging headache!

the links on the header also don't work, the Account Info, and contact us?!
The code has to contact with the Apsona server to download the application code each time (and any customisations Apsona have done for you).
There a problem with your communication with the Apsona server (https://service.apsona.com) or more likely, you have entered your ID details incorrectly in apsona_config.php.

Hi, I am bulk uploading attribute options, but am finding although it says it has imported over 1000 attribute, I've found that only 200 will upload the pasting way and 300 if I upload the file. Can anyone help? As you can see I have quite a few, all text so would rather not manually enter them!

Thanks

I take it then, you have it working....perhaps you could mention what the problem was...to help other people and improve the plugin.

I got a server not responding, however I was wondering if they still have their old server up and running ...
I'm talking about the apsona_config.php >>>> This is the old service URL

http://shopadmin-svc.apsona.com

testing it now ...

BTW for those with thousands of products, that want virtual inventory automation, we have a service that automates the process of daily updates, it connects to your manufacturer or distributor and automatically uploads all products prices and images into your shop, descriptions, out of stock, deletions etc, every single day, and gives you stats. The prices are also auto calculated based on your own rules. I'm not advertising the service yet, we have our ZC store plugged in for years.

icecold:

I got a server not responding, however I was wondering if they still have their old server up and running ...
I'm talking about the apsona_config.php >>>> This is the old service URL

http://shopadmin-svc.apsona.com

> 
> testing it now ...

BTW I just tried it and it's not responding, the usual spinning circle ... but when I went directly(browsing) to the url above I got a login form, when I attempted to enter my old credentials it rejected my email, so it's either this is no longer maintained as I tried to sign up again using that email and got a message saying it was already registered ... or there is a conflict between this site and the new one ...

torvista:

I take it then, you have it working....perhaps you could mention what the problem was...to help other people and improve the plugin.

Hi,

Yes it is all working now with the files you provided me with. Not sure if you got my mail.

Thank you!

Since I upgraded to ZenCart 1.5.5a I am unable to access Apsona. I use Firefox and before it always made me go in and accept permissions in order to access. I believe it had an orange symbol. It now has a green icon that is a closed lock. When I hover over it with the mouse it says "Verified by Comodo CA Limited" When I click on the green lock it now shows my website name in green with an arrow across from it and then “secure connection below”. Under that, a new line says "Permissions, Install Adins" with a box directly across that says "Allow" and an option of block.

If you click on the arrow across from my website name, it opens a box that has my website name in Green and Verified by Comodo under that, At the bottom it has "more information" which opens the Security settings. The most important info here are 3 lines
1, Website; my website name
2. Owner: This website does not supply ownership information
3. Verified" Comodo CA Limited

I opened Apsona in Chrome and got the same error. I used Inspect element and it shows the two errors below

https://shopadmin-svc.apsona.com/ec/zencart/apsona.min.js Failed to load resource: net::ERR_INSECURE_RESPONSE
https://shopadmin-svc.apsona.com/img/loading.gif Failed to load resource: net::ERR_INSECURE_RESPONSE

Does anyone know how I can fix this?
Thanks, Chuck

For the benefit of all

https://shopadmin-svc.apsona.com/ec/.../apsona.min.js Failed to load resource: net::ERR_INSECURE_RESPONSE
https://shopadmin-svc.apsona.com/img/loading.gif Failed to load resource: net::ERR_INSECURE_RESPONSE

This is a perfectly correct error message due to the incorrect urls being used in apsona_config.

Copied from my Github fileset:

//$APSONA_BASE_URL = 'http://shopadmin-svc.apsona.com';//original Apsona default server. Ok to use if your admin is http, which it should not be.
$APSONA_BASE_URL = 'https://service.apsona.com';//secure https server - best to always use this, then it doesn't matter if the admin is http/https.

Also, this particular shop was ZC155 but the hard-coded defines required in ZC154 had not been removed from the admin configure.php.
This prevented the code added by me to use the new defined_paths file in ZC155 from not working.

Once these two items were corrected, the connection was ok.

lindsey80:

Hi, I am bulk uploading attribute options, but am finding although it says it has imported over 1000 attribute, I've found that only 200 will upload the pasting way and 300 if I upload the file. Can anyone help? As you can see I have quite a few, all text so would rather not manually enter them!

Thanks

I know that this is quite old, but I don't normally come here and I just saw it. Lindsey80, did you resolve the issue? I have also had the same issue. For your benefit, or the benefit of others reading this thread, the work-around is to load in batches. I use ShopAdmin to update prices on my site. I have 10k SKUs! I can upload about 2K at a time, so I do it in 5 batches. I have checked with my internet provider and they say that they do not throttle my uploads, but I do see that I have more problems around 3pm-4pm when all of the local kids are getting home from school.

I recently had a new template installed on my site, and I believe the individual upgraded me to 1.5.5d. Now ShopAdmin will not work. When I launch it into a new tab,I get the header only with nothing below. I made the updated suggested in Posting #726, but it still does not work. I get another error that it cannot parse something. I downloaded a fresh set of files from the Apsona site (the ones for 1.5.5) and installed them. I also have a folder of apsona-shopadmin-admin-1.5.1.5.ssl which has some files and a readme.txt file. I read the Readme file, but am not sure which file I am supposed to update. Which file is meant b: yourShopAdmin/includes/configure.php. I think I now have myself so confused I am not sure what to do.

I downloaded a fresh set of files from the Apsona site
The files from the Apsona site are most definitely stale and not for use these days.
Use the ones from my Github, READ THE INSTRUCTIONS, and then report back good or bad.

torvista:

The files from the Apsona site are most definitely stale and not for use these days.
Use the ones from my Github, READ THE INSTRUCTIONS, and then report back good or bad.

PERFECT - Thank you. an I buy you a "cup of coffee"

I have tried following every single tip and example in this thread to get my Apsona to work, but it just won't, including everything in the latest files from Steve's github. Blank page with Apsona header, and a cannot connect to server error. I've included a screenshot below.

what version of zen cart are you using?

The latest and greatest - 1.5.5e

Have you double checked your user ID is correct and no extra spaces? I just created a new ID for my test store, uploaded Steve's files to a new 1.5.5e (after copying the ID from the apsona files I got from their site) and it is working properly, so I can confirm it is not a version issue. Did you use only Steve's version or did you upload the files from apsona first then overwrite with Steve's?

Finally got it to work. Your questions made me go back and delete all the files, then re-upload and install from Steve's again. Did the trick. Sometimes, you just need a nudge in the right direction, Thanks.

I'm using: v1.5.5e I'm able to export the Product attribute records then edit the file. Only issue is when I go to import I do not have the options in my drop down for Option value ID and Option value: Name

Ran into a new error message - {"error": "/get/data/product.csv: No query given."}

Have no idea why unless it's a server issue. I recently upgraded the database version and I run a cPanel server that auto updates. Anyone seen anything like this?