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

That is so sweet of you! Make a donation to the zen cart core team please - though I could use the dough, I haven't been able to support the project as I wanted this past year so gift them! And thanks for your support.

I typically do make a donation to the core team after new updates and to ajeh and others after significant work. I will do so this time also.

By the way, many years ago the developer created a new dropdown on the tools menu to export a customer data as an iif file to allow the customer data to be input into Quickbooks. Do you know if that might still be around somewhere? I am just a small business and the cost for some of the third-party zen/quickbooks integration packages is just a bit out of my reach.

there are still mods in the free list - if you google it, you will find the guy. He's got a free and a paid solution as well. Can't remember his name right off hand.

Thanks. I have checked over all of those, but they only work on 1.3.9 or so. I may email them to see if they have a version that works on 1.5.4

the package I uploaded is the only thing available and they are no longer supporting it at all. That is supposed to be only the changes for 1.5.3 and 1.5.4 https://www.zen-cart.com/downloads.php?do=file&id=1985

After all this time, I finally ran across a hosting company where importing products does not work. They determined it was a mod security error due to the way the server is managed. You can have your company write an exception to it if they will oblige. This problem was on westhost.com and they were very nice about it. This is when you get a message that the network connection has been lost while importing.

Hi,

A couple of questions regarding ShopAdmin:
1. What are the field names needed for adding new products? If it doesn't require product id to import, is it based on product model?
2. Does shopadmin handle large store (say 60,000 products) well?

No, it doesn't need model number. I suggest experimenting because none of that is documented.

I would think any limits on products may well be due to server limitations rather than this code. I would assume it would just run until it either finishes or the server kills the process - if at all.

I read on apsona website that when importing new products, it does need the model field and it has to be unique.

How do we bulk import a list of manufacturers using this module?

In general your best info is going to be on the apsona site. I've never tried importing manufacturers but you can always add one and then export manufacturers (I assume this is possible) and follow that outline for import.

I just installed Apsona Shop admin on fresh 1.5.5 but its not working.

Any idea?Attachment 16163

Did you just use the package you downloaded from Apsona? Did you use the fixes in the mods section? Does not work right out of the box.

I used this.

https://www.zen-cart.com/downloads.php?do=file&id=1985

Also made the changes in config file as you mention earlier.

I tried same in fresh 1.5.4 and its working there.

I'm not understanding you. You say you used in fresh install and it worked? But it's not working somewhere else?

Its not working on Fresh Zencart 1.5.5 install.

And its working on Fresh Zencart 1.5.4 install.

hasn't been testing with 1.5.5 and if it's not working then probably the functions need altering. That is not my expertise. I'll see if I can get something done but can't promise it.

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

PHP Code:

---

require ('includes/application_top.php'); // Use application_top so that unauthorized users can't hit this page 


---

to

PHP Code:

---

require ('includes/application_top.php'); // Use application_top so that unauthorized users can't hit this page

if (!defined('DIR_WS_HTTPS_ADMIN')) define('DIR_WS_HTTPS_ADMIN', DIR_WS_ADMIN);//from Zen Cart 1.55 https://www.zen-cart.com/showthread.php?219753-DIR_WS_HTTPS_ADMIN-Constant-appears-to-be-removed-but-is-still-used-referenced&p=1307089#post1307089 


---

2) ADMIN/apsona_svc.php

change

PHP Code:

---

require (DIR_FS_CATALOG . DIR_WS_INCLUDES . 'database_tables.php'); 


---

to

PHP Code:

---

if (!defined('DIR_FS_CATALOG')) include ('includes/defined_paths.php');//from Zen Cart 1.55
require (DIR_FS_CATALOG . DIR_WS_INCLUDES . 'database_tables.php'); 


---

Thanks for help. Its working fine now.

I'll add that in the package I created. Thanks, Torvista!

Torvista, the changes for the config files would be different now as well.

The line in configure now reads

PHP Code:

---

/**
 * Note about DIR_WS_ADMIN
 * The DIR_WS_ADMIN value is now auto-detected.
 * In the rare case where it cannot be detected properly, you can add your own DIR_WS_ADMIN definition below.
 */
define('DIR_WS_ADMIN', '/store_admin/');//steve apsona 


---

So I added the fixed path there. But the https admin is now done differently. What did you do in the configure file?

I'm fixing someone's aborted apsona installation but I think I've got the right files in place with the added 1.5.5 lines. Still getting that can't connect message though. I believe this is simply a new installation on a server where they were running apsona in another directory with success on an earlier version of zen cart.

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

Quote:

---

if (!defined('DIR_FS_CATALOG')) include ('includes/defined_paths.php');//from Zen Cart 1.55

---

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 loaded and so the Apsona page will not work.

So something needs to be tested for, that existed in configure 154 and not 155, such as DIR_WS_ADMIN:

PHP Code:

---

if (!defined('DIR_WS_ADMIN')) include ('includes/defined_paths.php');//from Zen Cart 1.55 


---

So to recap, in apsona_svc.php I have:

PHP Code:

---

if (file_exists('includes/local/configure.php')) {    
include ('includes/local/configure.php');} 
else {
include ('includes/configure.php');}

if (!defined('DIR_WS_ADMIN')) include ('includes/defined_paths.php');//from Zen Cart 1.55

require (DIR_FS_CATALOG . DIR_WS_INCLUDES . 'database_tables.php');
require ('apsona_config.php');
require ('apsona_functions.php'); 


---

I also do not agree with putting the DIR_WS_ADMIN in configure.php.
This seems to be as sticking plaster approach as this will allow other mods that rely on this to continue to work, instead of updating them to work with the ZC155 vanilla code.
I think mod code should be self contained and not need bits added to core code to make them work wherever possible.

okay, now I got it. And it's working now! And now I'll create a new package for download.

Thanks for these code patches! I was worried that I wouldn't be able to continue using Shopadmin after updating to 1.5.5, but now it is up and running. I really appreciate the contributions in this thread.

Has someone put together a .zip package with all the 1.5.5 patches applied so that others can have a simpler fix? I would upload it but I don't want to claim credit for any of the code changes.

The instructions need to be added for 1.5.5. If you can add that as well, and put it together right, let me know. I don't mind retrieving and vetting and reuploading if necessary. Haven't had time or energy to do it - 2 surgeries this year....

Quote:

---

Originally Posted by delia

The instructions need to be added for 1.5.5. If you can add that as well, and put it together right, let me know. I don't mind retrieving and vetting and reuploading if necessary. Haven't had time or energy to do it - 2 surgeries this year....

---

Where would i find this addon to work for 1.5.5 i was not able to get it to work? is there a zip file yet?

Thanks,

Robert

I got all the pieces - I'll get it packaged up as soon as I can.

Quote:

---

Originally Posted by delia

I got all the pieces - I'll get it packaged up as soon as I can.

---

Sounds Great too me I just started trying to use it I add around 500 shoulder patches at a time to my site was hoping for an easy idiot way to do it :) Still learning zen cart

Robert
patchesrus.net

All worked after I added this piece to apsona_svc.php


if (file_exists('includes/local/configure.php')) {
include ('includes/local/configure.php');}
else {
include ('includes/configure.php');}

if (!defined('DIR_WS_ADMIN')) include ('includes/defined_paths.php');//from Zen Cart 1.55

require (DIR_FS_CATALOG . DIR_WS_INCLUDES . 'database_tables.php');
require ('apsona_config.php');
require ('apsona_functions.php');

now it works great!

Does someone have experience using Apsona to export customers from 1 store and import them to another? Whenever i do it matched adresses with Name, lastname, e-mailadres, postalcode etc.. with a slight difference and with an export that export for every adress (up til 5 are allowed in the adressbook) a new customer/line in the CSV i have now x times the amount of customers then i had; lol.

Best would be that apsona check ONLY on emailadres and just don't do an import when it exist in the database.

Hi I really need some help with this mod if possible. I have everything installed but all I get is the apsona header and nothing else. Ive checked the troubleshooter on apsona website and change the files to execuable and the aalow_url_fopen is set to on. My PHP is 5.5.26. The version of zen cart is 1.5.4. MY SQL Version is 5.5.52

Thanks

Is your ZC admin in a different language then English? If yes copy the files in the right language folder and if not try to check the language files from the apsona install folder

Quote:

---

Originally Posted by importprijs.nl

Is your ZC admin in a different language then English? If yes copy the files in the right language folder and if not try to check the language files from the apsona install folder

---

Hi,

It is English. I've just re-uploaded the apsonaShopAdmin file from the original download and still the same.:no:

Thanks :smile:

Quote:

---

I have everything installed ...

---

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

Quote:

---

Originally Posted by torvista

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

---

Yes, I have used the new files in the plugins


Thanks

Quote:

---

Originally Posted by lindsey80

Hi,

It is English. I've just re-uploaded the apsonaShopAdmin file from the original download and still the same.:no:

Thanks :smile:

---

I don't know your level of expertise so maybe i come up with things you already tried.
Do you use FileZilla? Are you sure all files are in the right directories and PHP files are uploaded in ASCII mode and images in Binary mode (FileZilla autodetect it)?
You tried the files from http://apsona.com/pages/ec/downloads.html and also from zen-cart.com (compare them?)
Is the SQL code inserted, check it in the database.

If this does not help i would make a ticket at Apsona (https://apsona.com/pages/ec/signup.html).

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 suggested and recheck all the files, then go through this thread from the beginning to read about the various instances of your problem, which has been seen several times.
Apsona DOES work, I use it regularly and as far as I know, all patches created in this thread have been applied to the Plugins code.

Have you used ShopAdmin on a previous installation? Do you have a an Appsona ID ($APSONA_APP_ID)?

importprijs.nl

I have used Apsona before on an old site of mine and it was a simple install so don't know how this is going so wrong! grr
I used filezilla to upload all the files, although I don't know what you mean in ASCII mode? The databases look as though they have been created. I will try and compare the files.

LightBrown

Yes I have a Apsona ID and have applied.

I don't know if this is an indicator of what might be missing, but the links on the header also don't work, the Account Info, and contact us?!

Thanks for your help everyone! I don't like to be beaten and know how helpful this addon is so I will keep searching for the answer!

So i've now spoken with my hosting company and they believe it is a version conflict? Can anyone shed any light??

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!

Quote:

---

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

Code:

---

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.

Quote:

---

Originally Posted by 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

Code:

---

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

Quote:

---

Originally Posted by 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/.../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

Quote:

---

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:

Quote:

---

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

Quote:

---

Originally Posted by 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.

Quote:

---

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.

Quote:

---

Originally Posted by 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.

Attachment 17120

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?

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

Good, he just informed me that it is only one site - he has multiples that are essentially identical on the same hosting so shall look further.

starting to use zencart again after several years (v1.5.5f)
Adding Apsona SHop Admin - I thought this was free???? But when I go to the site to get ID it is now chargeable?

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 server. The code still works/is still on their server but evidently they are not interested in new users.

If you have your old Apsona id, you can set it up using my files on Github, but really you should invest your time in DBIO for imports/exports:
https://www.zen-cart.com/showthread....Support-Thread

Thanks Torvista - I really dislike EP so this might be a good alternative.

For apsona you only need an id, any id - whatever records they kept it was the id that kept things working. At some point we found the mod to be totally not working if you tried to import. If apsona is still working completely I will be glad to give up id numbers but I need reassurances that it does work first. Since they have backed off the signups, I assume it will quit working though. Time to switch! I hate it cause I did like apsona the best.

Quote:

---

Originally Posted by delia

Thanks Torvista - I really dislike EP so this might be a good alternative.

---

Might want to clarify why as DBIO claims that it is based on the principles of EP.

Definitely don't know if Torvista's is any better. I downloaded it and am looking into it. Apsona was just the best thing for my clients - unfortunately the code that made it work was never accessible; otherwise, we would have picked it up and gone forward. Partly the interface though and the control it gave the site owner - which could be disastrous as well if not used correctly. Sorry, have always hated EP. Most clients never had the patience to use it correctly and make it work for them. This is something that needs to be built into zen cart in the future.

Quote:

---

Definitely don't know if Torvista's is any better.

---

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 only been modified so it can continue to work with php7 and current Zen Cart.

Quote:

---

unfortunately the code that made it work was never accessible

---

Not true. Since the browser downloads it, it can be saved and unminified.
With a few modifications here and there it CAN work entirely with all code as local files, but I decided that it was flogging a dead horse and it was time to move on.

DBIO and EP are based on the same concept of using a csv to import data.
EP has a long and checkered history of development and "developers", but now is well-supported I believe. I don't use it.
DBIO is a relatively recent plugin, written by a top developer here from the ground up using modern methods. I use this.

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 language-content settings, spanish was set as the first content language, the problem occurred.

I think it is something to do with the handling of locales in the Apsona javascript that decides the decimal point is actually a thousands delimiter and so ignores/removes it.
Since this bit of the code is in the always-downloaded javascript, it cannot really be investigated/fixed without doing a few hacks to make it all work locally.

Although in truth Apsona has been so long unsupported, no-one should really be using it anymore.

In my opinion, if Apsona still offers anything that cannot be done in a supported plugin like DBIO
https://www.zen-cart.com/showthread....Support-Thread,
you should ask nicely for it!