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

Thank you Delia. I thought I had done all of the things in the Readme file, but the password didn't seem to have changed. Perhaps I forgot to ftp that file over. The files work better when they are on the site rather than on my computer!!

I really appreciate the fact that you are supporting this mod. I have over 10k SKUs on my site that vary with the price of gold and silver. I would really struggle without this type of mod.

Can I buy you a "cup of coffee". I would be happy to make a donation, just let me know how.

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?

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

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

to

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

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

to

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!