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

[torvista]

1. Are Apsona still alive and supporting this product?
I emailed them yesterday but have received no replies.

Yes, I think so...but they are always very busy with paying customers.

2. Can anyone explain their business model? How do they make money with free service and free support?

Custom work, I think.

3. Can I import/alter product attributes with SA? (ie the tables: products_attributes, products_options_values and products_options)
I price all of my products via Catalog -> Attributes Controller.

Yes - although I don't use it for that.

4. Can anyone tell me how much of my shop data would be passed through Apsona's server? I see that they effectively control the service but, as my shop is confidential (sales, finances, and especially customer data), I would need to know what data gets sent where and what control I have over that.

http://www.zen-cart.com/showthread.p...053#post878053

None is sent to their servers. The code is downloaded from their site each time you start it up and that's it.

I've been using it for ages and if one day they start to charge, I'll still use it. It works.

[jetx]

I've been using it for ages and if one day they start to charge, I'll still use it. It works.

Same, works for me.. easy and quick.

[barendfaber]

Hi,

I am using version 1.5.1, www.fossilandrock.co.uk. I have just added the Product Cost Display add on (http://www.zen-cart.com/downloads.php?do=file&id=1444). It created a new table in my database and the site works fine. I have just tried to do an update with Apsona, changing Manufacturers and adding the cost. It hangs during updating, and I closed it. I then noticed in my site that the Manufacturers were updated, not the cost price.

Does this mean Apsona is not compatible with the module, what can I do to get it to work? When I download my products from the Apsona Panel from the Tools - Export option, it does show the option to select Cost to be included. Can someone help with this?

B

[propster]

Hi I have just installed apsona shop admin to my zencart 1.51 on a local host machine for testing. It does not appear to have created the table in the database and when I try to run it from the admin menu it just goes to a blank page with the header showing. Any help on this would be fantastic. I have installed on zencart 1.39h on same localhost machine and that one works ok.

[DrByte]

Blank page means an error is occurring. Read the logs for the error, and fix the error: http://www.zen-cart.com/content.php?124-blank-page

[torvista]

Firefox 23 blocks mixed content with no popup warning, just an easily-missed (by me anyway) icon in the address bar.
There is also no whitelist for this: on every page reload you have to manually permit it.
https://blog.mozilla.org/tanvi/2013/...in-firefox-23/

If your admin pages use ssl, when you use apsona this will attempt to load via https too which results in the apsona page not loading as the jquery and apsona code is blocked.

Solution, change the sources of the unencrypted content.

In apsona_config.php

change
$APSONA_BASE_URL = 'http://shopadmin-svc.apsona.com';
to
$APSONA_BASE_URL = 'https://service.apsona.com';

In apsona_index.php

change
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>
to
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>

[torvista]

For early adopters using php5.5 already, i.e. Xampp 1.83, mysql_connect is deprecated and the attendant error message triggering stops Apsona from loading:

Deprecated: mysql_connect(): The
mysql extension is deprecated and will be removed in the future: use mysqli
or PDO instead in D:\My Documents\....\apsona_functions.php on line
176

Despite putting @ in front of it (as in Zen Carts query_factory which also uses mysql_connect) to supress the error, I still could not get it to work despite trying to turn off all error reporting.

Apsona is aware of the issue.

[kennad]

Same issue. I have updated to the new files recommened by Apsona and still a blank screen when trying to run this GREAT add-on. Good thing I am trying to migrate to the new version of ZenCart for all my sites and not having to run live, YET.

[torvista]

Same issue. I have updated to the new files recommened by Apsona and still a blank screen when trying to run this GREAT add-on. Good thing I am trying to migrate to the new version of ZenCart for all my sites and not having to run live, YET.

I would forget it for now and use php5.4/Xampp 1.82 for local development as your hosting won't be using 5.5 for a long time yet.

[RedSpinnaker]

I am trying to do a mass update using Apsona of a category > product in 1.5.1.
I want to change the below field from "y" to "n" for all my products:

Products Quantity Box Shows: o Yes, Show Quantity Box o No, Do not show Quantity Box

But when I go to Apsona and select "All Products" and look in the "Product Details" screen, this exact field is not available.
Any ideas?