Search:

Symptom: for a price update of 1.234, Apsona was inserting 1234, ignoring the decimal point.

I found that the issue was with Chrome (windows). Firefox and Edge were ok.

If in the Chrome...

The functionality of Apsona is based on the javascript that is downloaded from their server every time you start the Apsona page.
My code is the supporting php that you need on your server, it has...

Looks like they have finally taken down the page for the sign-up.
Apsona stopped supporting/developing Shop Admin a long time ago to concentrate on Salesforce, but left the Shopadmin code on their...

I'm using on php 7.1.9 no problems (with my code).

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.

For the benefit of all


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

Copied from my Github fileset:


Also, this particular shop was...

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

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...

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...

Don't bother Apsona, you wont get an answer. They stopped supporting it a long time ago and decided to do something profitable instead. So any support is here only.
I'm afraid you will have to do as...

Just to clarify, you used the updated code in the Plugins to overwrite what Apsona provides?

I don't get this edit (which I had not seen).


DIR_FS_CATALOG is defined in configure.php so is ALWAYS defined at this point irrespective of the Zen Cart version: defined_paths will never get...

Apsona compatibility with Zen Cart 1.55.

Since some constants related to paths have been moved, I found I needed to make these changes to get Apsona to load.

1) ADMIN/apsona_index.php

change...

You mean a product export to create a csv does not work?

Just tried mine, it's ok (on php 5.4.45 and 5.6.8).

You have an encoding issue.
Use Libre/Openoffice to ensure you save it as utf-8 encoded, assuming you have an utf-8 database...or as whatever you want. I found Excel lacking in this aspect for both...

When you import, you can choose what csv columns to map to which database fields so yes it accomodates non-standard zen fields that you have added.

Is anyone using Apsona in a non-english language and seeing accented characters in the Shopadmin menus as "??" where they were ok previously?
I am, in spanish. It's not an encoding issue.

Great...and did you need to do anything that is not already detailed in this thread?

I have been in contact with them, and the page is back up now.

They do intend to keep it running albeit with no support.
No, they cannot release it to the community as it has a great deal of...

Just to re-iterate, Shop Admin DOES work in Zen Cart 1.54, but not out of the box.
1) Sign up and get the base files
2) Go to the support page and get the update
3) and the 1dot5 update.
4) go to...

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

Yes, I've attached it.

From 1.51 the admin configure.php figured out where it was all by itself, eg in 1.53 we have:


define('DIR_WS_ADMIN', preg_replace('#^' . str_replace('-', '\-', zen_parse_url(HTTP_SERVER,...

Yes...and I was about to say that's irrelevant but there is a problem with the self-determination of the admin path in the admin configure.php using the new function zen_parse_url that I haven't...

I have modified the apsona_functions.php file to use mysqli.
I only use Apsona for exports and imports so it would be prudent for all and sundry to try this out on their DEVELOPMENT servers and see...

No there isn't...:blush:

Be aware that when Shopadmin first loads it creates a snapshot of the database. It uses this for error-checking in the browser prior to doing imports.
It is cached and...

Just a FYI that there is a problem using Chrome as the browser with Apsona.
Scenario:
1) load in english.
2) import/insert some new products from a csv. ok.
3) change to secondary language.
4)...

My hosting is php 5.4.28 and Apsona works fine.

Locally Xampp is on 183-4 (php 5.5.11) which doesn't work: I have to use 182 (php 5.4.27) when I need Apsona.

The "re-coding" is fixing a few...

Has anyone modified the Apsona database access to use mysqli?
I am finding it not working locally on the later Xampps due to this.

"the circle loading icon just continues to spin and does not load"
- that's the symptom for the issue described in post #525.

Since I work with a spanish site and accented characters, I long gave up on the vagaries of excel and only use Libreoffice, as you can tell it what encoding to use when both opening and saving your...

Check your php errors and hosting error and access logs (server, mysql) to look for some clue about what is timing out.

thats the symptom I got when the javascript was being blocked by firefox, it may not be related to your issue but check post #525.
Look for an icon appearing in front of the address that tells you...

You don't have this?
12885

If you want to do them all:
Products->Tools->Update All and select your field.

If you want to choose which products, use a filter first or export to csv,change,import.

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.

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:


Despite putting @ in front of it (as...

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...

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


Custom work, I think.


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

...

I don't have this import problem...resetting the master categories on my shop would be a self-destruct button!
I do Update ALL Products Price Sorter but thats just because I can't be bothered to...

When importing, is Apsona mapping all the field names to the CVS column titles correctly?
Do all the categories pre-exist or are you creating them at the same time?

So you have imported=created products with no master category? I didn't think the Apsona import allowed that.
Look at the database, products tables to check this.


What do you mean? You...

When you imported the new set of products, your csv included columns for master_category and category with the same data in each?
You only use one language?

I had a problem with Apsona not loading on a local installation due to the php.ini error_reporting options.
As the "problem" may be a Zen Cart one, its posted elsewhere but here's the reference if...

Hi,
Products->choose a filter->Then from the the right menu dropdown choose "Update all..."
I've tried various options but nothing happens after clicking Update.
This is the first time I've used...

@Seajay
For a product to show up in the shop it needs to have a master category assigned to it and also belong to least one category...which should be the master category too.
So an import of a new...

Yes. It should update only the fields you are importing. If it is removing them, it must be either changing the enabled field to 0 or changing the category and/or master category.


I don't...

Hi,
using Apsona on a local Xampp install I have found that
it works on xamp 1.80 using php 5.4.4
it does not load completely on xampp 1.81 using php 5.4.7.

No error log messages of use.

Is...

Off-Topic
For people using Openoffice Calc to work with the Apsona CSVs, with multi-language stores where the decimal delimiter varies between the languages, this post may be of interest....

Not for me..still working fine.