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

Hoping someone can point me to the post or posts that will tell me how to mass delete products using Apsona. I'm pretty sure it's in here as I've used it before but I can't seem to find it now. I put a prefix on all the products from this one supplier that I need to delete and I've created a filter for everything with that prefix but when I click on Delete, the box tells me to choose an item from the list. Im pretty sure there is a way to mass delete these items.

Thanks

Jim

Nevermind, found what I needed, thanks anyway.

Jim

Jim - Did it work? You asked about this a while ago, and I responded in #566. If this did not work for you, let me know and I can walk you through the process.

SPembleton:

Jim - Did it work? You asked about this a while ago, and I responded in #566. If this did not work for you, let me know and I can walk you through the process.

Yes, it worked great, I knew I had done this before but couldn't find the post with the instructions but I finally found it. I hadn't had to do it since asking before. Worked like a charm, thanks.

I just installed Zen Cart 1.5.3. I also signed up with Apsona and installed ShopAdmin starting with the files that they had me download after signing up and then I installed the update for Zen Cart 1.5. When I try to open ShopAdmin, I get a blank page with only the ShopAdmin Logo, banner, my name, account link, and feedback link.
The questions I have are:

Does Apsona for Zen Cart 1.5 work with Zen Cart 1.5.3?
If not is there another program that I can use to do bulk product imports and updates that also supports custom product fields? I have 9,000+ products to upload to my store and there are 13 custom product information for each record.
Will the most current version of Easy Populate do what I need? Or is there another module?

Anyone having an issue that when the new window opens for apsona the circle loading icon just continues to spin and does not load? Have tried with both IE and Chrome.

"the circle loading icon just continues to spin and does not load"

• that's the symptom for the issue described in post #525.

torvista:

"the circle loading icon just continues to spin and does not load"

• that's the symptom for the issue described in post #525.

Thank you -- that completely fixed it! :D

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

I learned that that's the main problem with Asona ShopAdmin at least with Zen Cart 1.5.3. I was told that 1.5.3 now uses MySQLi and Apsona was coded in MySQL. After calling Apsona and sending them an email and not getting a return call or email, I decided to look for another solution. I decided to install Easy Populate 4.0 (EP 4.0). I am not techie. But I got it to install. Yesterday I uploaded 1,697 product records to Zen Cart. The upload was 100% free of errors and took 16 seconds. From reading Apsona's Blog, it is apparent (I am tempted to use the word evident) that their work with SalesForce related solutions and other consulting work has left them with virtually no time to support or re-code ShopAdmin for MySQLi.

It would however be helpful if they would clearly and definitively state whether or not they plan to re-code it or allow someone else to do so.

FoodSourceDirect:

I learned that that's the main problem with Asona ShopAdmin at least with Zen Cart 1.5.3. I was told that 1.5.3 now uses MySQLi and Apsona was coded in MySQL. After calling Apsona and sending them an email and not getting a return call or email, I decided to look for another solution. I decided to install Easy Populate 4.0 (EP 4.0). I am not techie. But I got it to install. Yesterday I uploaded 1,697 product records to Zen Cart. The upload was 100% free of errors and took 16 seconds. From reading Apsona's Blog, it is apparent (I am tempted to use the word evident) that their work with SalesForce related solutions and other consulting work has left them with virtually no time to support or re-code ShopAdmin for MySQLi.

It would however be helpful if they would clearly and definitively state whether or not they plan to re-code it or allow someone else to do so.

It's open-source.. So unless there's some dependence on some external resource, anyone who has the time and willingness could re-code this..

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 functions in apsona_functions.php.
I spent about 10 minutes on it about a year ago without success (early adopter that I used to be...) so I was just wondering if someone had fixed it yet so I can bin the older Xampp install.

Hi Torvista:

I am interested in knowing the same thing as well.

Hi.Diva,

I have a little time but no technical skills. Let me know if some capable person does the re-coding.

BTW are you the current developer of TPP?

AJ

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. import/update these products with second language information from same csv. Flags errors as it cannot find the model number, (nor product id if added to the csv prior to the update).

The process works ok with Firefox and IE.

Just a FYI that there is a problem using Chrome as the browser with Apsona.
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 the cache does not renew with changing language, nor with reloading the Shopadmin page nor with closing and reopening it from the admin: you have to manually delete it.

This caused me a problem as I do multiple test-drives of importing large, complex .csvs locally to get them note-perfect before importing them to the real shop.
By not clearing the cache after completing local testing, Shopadmin was error-checking the csv against the wrong database info.

So, the moral is, use one browser for local work and another for remote work when using Apsona Shopadmin.

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 if it is working in all instances.
Attachment #14459

I have it working on php 5.5.15.

torvista:

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 if it is working in all instances.
Attachment #14459

I have it working on php 5.5.15.

This is great news. Are you running zc 1.5.3?

Are you running zc 1.5.3?
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 figured out yet which means you need to hard-code the admin path in the defines that use that function otherwise the shopadmin index page does not load.

torvista:

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 figured out yet which means you need to hard-code the admin path in the defines that use that function otherwise the shopadmin index page does not load.

Hi Torvista:

I noticed the same thing.

Fatal error: Call to undefined function zen_parse_url() in /home3/xxxx/pubic_html/admin/includes/configure.php on line 29