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

**delia** · 22 Apr 2010, 05:38 PM

The website is at apsona.com. Seems to be a store manager mod. Curious to know who might have experience with it.

**apsona** · 23 Apr 2010, 04:24 AM

Apsona now offers Apsona ShopAdmin for Zen Cart. ShopAdmin is a free tool for importing, exporting, updates, reports and business analysis for your e-commerce site.

If you have not yet signed up to use Apsona ShopAdmin for your Zen Cart application, please visit http://apsona.com and click the on “Sign up” link.

Best regards.
The Apsona team
http://apsona.com

**htm2112** · 1 May 2010, 02:36 AM

I am having a hell of a time trying to install Apsona, a database management program (which looks amazing, if only it would work). To install it, you are instructed to upload several files, none of which overwrite zencart code. That's about as basic an install as it gets. Then you log into your admin console and under tools, a new box appears: Apsona ShopAdmin. Click on it and page opens. Nothing happens.

Using Chrome and Firefox, I have found 3 errors reported

"Apsona is not defined" on admin/apsona_dashboard.js
"Apsona is not defined" on admin/apsona_index.php
"$ is not defined" on admin/apsona_index.php

Has anyone had this problem? I transfered the domain from GoDaddy to Camelot Hosting because they told me that it works well on Camelot. Still the same problem. I installed zencart with no mods on another domain, same error. I am totally stuck. I am running version 1.3.8a. My next plan is to upgrade to the latest version.

**pdxdoug** · 1 May 2010, 04:20 AM

A brief read of the 'How it works' indicates that two tables are added to the database.

Additionally, it will create two database tables with names apsona_report and apsona_filter in your database.

Just checking. You didn't mention that you did that part.

**Merlinpa1969** · 1 May 2010, 05:38 AM

We are going to be talking to the developer since they have said that they have it working on our servers,

Need to see what they are doing different.

**htm2112** · 1 May 2010, 05:40 AM

The installer is quite smart. The first time you access Apsona ShopAdmin, it creates those two tables. That was the first place I looked, using phpmysql. So, I know it can access my database. I think the problem is that it needs to connect somewhere else and can't or can't define the connection. I have this error:

$(function () {
Uncaught ReferenceError: $ is not defined
if (!jQuery.browser.msie) {
Apsona.ZenCart.init ("http://*********.apsona.com", "*******", "apsona_svc.php", "zen_");
};

I don't know enough about php to understand how $ is defined, but I think that is the biggest clue. I spoke to some guy at the company who told me that the code works perfectly. I have not made any changes to it.

**htm2112** · 1 May 2010, 06:11 AM

So, I have not gotten it to work on 1.3.8a and figured I would install it again on a brand new install of Zen Cart 1.3.9a and I get the exact same error. Man, this is frustrating...

**DrByte** · 1 May 2010, 06:35 AM

I'm guessing that if your server doesn't respond with the $_SERVER['PATH_INFO'] and $_SERVER['REQUEST_URI'] values, then the script will not be able to properly read the various .js and other resources needed, including the jQuery loader that the "$" function refers to. Or worse, if your server's PHP isn't being allowed to talk to the apsona servers, then it won't work either.
Just some things to look at.