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

Hi, I have not talked to my hosting provider about it. I really think that it is strange. All I want to do is only to update my prices. I never thought that it would be a big issue like this.

Hello, I have a ZenCart site hosted on Hostgator using a dedicated IP address for now. I have a live site elsewhere so I can't transfer the domain over until I get this site ready to go live.

I have the latest version of ZenCart and have installed Apsona and unzipped it to the 'manage' folder which replaced the 'admin' folder on Hostgator. The new Apsona link is showing under my 'Tools' menu in the admin site but when I click on it I get the following error message. I have the link that Apsona sent me regarding the installation but this error message isn't mentioned in it. I don't know if using the IP address instead of the domain name might be messing it up or not.

Does anyone have any idea where I need to look to correct this? Thanks for any help.

Here is the error message:

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Apache/2.2.17 (Unix) mod_ssl/2.2.17 OpenSSL/0.9.8r DAV/2 mod_fcgid/2.3.5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at missyscollectibles.com Port 80

RiverCity - I would guess that this is either a permissions issue (you need to set the file permissions to executable), or a security configuration issue with your hosting company. I would suggest that you try changing the permissions of all the ShopAdmin files so that they are executable, and please let us know what the results are.

Hope this helps.

RiverCity:

Apache/2.2.17 (Unix) mod_ssl/2.2.17 OpenSSL/0.9.8r DAV/2 mod_fcgid/2.3.5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at missyscollectibles.com Port 80

Had a similar issue (although no 404) where "check connection" error would pop up then "progress bar being used somewhere else"

First things first. CHECK LOGS. Should see more specific errors.

My issue was with mod_fcgid (RiverCity is running this) and the MaxRequestLen directive. But if your not running your own servers, your web host will need to investigate. This fixed my issue.

If you have access to your logs, please post them and I'll take a look. Apsona is FANTASTIC!!!!

joegalui:

When I start Apsona ShopAddmin from the tools menu it presents the login box for my admin id in a new window.When I login it goes back to my admin page and I try it again but it keeps going to the login. Help

Im experiencing the same problem.
I've changed all permissions for the files and have
checked that everything is as it should be server
side as per instructions on the Apsona website,
yet the problem remains.
Its not a browser issue, since the problem is the
same in IE as well as firefox.

How to resolve this redirect issue?

Whats the server log say? Most likely not an issue with apsona. Please post the most recent errors

Is it possible to export each product link? for example: https://www.example.com/productlink

I am trying to upload products to a web site and I keep getting the following error:

**The server is not responding. Please check your network connection.
Status: error

There are no errors in my log, the host does not see any issues on their end either.....I am stumped.

I tried copying a few lines to the copy and paste option and when I did like 5 lines it went through fine....so I did the spreadsheet and got the error...then I tried again by copying and pasting 50 lines...and still got the error....

If I click OK on the popup error message..then the progress bar will still come on and show the time it takes to download things, but the blue bar does not move and it does seem the items make it into the database, but do not appear in the Zencart Admin....

I am just baffled here....any thoughts?

THANK YOU!!!!!
**

jill8026 - I assume you've been using ShopAdmin without this problem in the past? We haven't made any major updates in a few weeks now, so it's unlikely to be an issue with ShopAdmin. Is it possible that your hosting service has added some security controls that might be causing this? Perhaps you can ask them about it?

Regards.

I have been using Apsona for a while, but honestly never uploaded products before! :-) I know how odd! I use it as my main admin area and so do a couple of my clients...but this is the first time I really needed to upload things....

I did talk to my host and they are not seeing anything at all....typically we have mod security issues that we run into on occasion - but they do not see any errors at all......just wanted to run it past you...

I will call the hosting company again to see if I get a different answer! from someone else!

Hello

i have been doing updates on products to the website im setting up, and i got the server not responding error, now the complete site is down, im only able to load none mysql dependent pages, but since the orther webshop running on the same server is all good, what could then be wrong here?

mysql is working all good, but do apsona lock tables under update or anything else that can be the reason why im not able to load this site when the other one is working without any problems?

harlyman - Apsona doesn't do any table locking. To me this sounds like a server issue, I'm afraid. Have you checked with the hosting company?

Anyone using “numinix_product_fields”

I’ve got that plug-in installed and it has an optional piece that adds a second Description field called “products_description2” to the products_description table.

My problem is that Apsona doesn’t see that new field. It does see the other new fields added by “numinix_product_fields”.

Is anyone else using numinix_product_fields, and have you seen this problem?

Thanks

apsona:

harlyman - Apsona doesn't do any table locking. To me this sounds like a server issue, I'm afraid. Have you checked with the hosting company?

yes i did, but they could not locate anything, the problem solved itself after some time, so its working now.

harlyman:

yes i did, but they could not locate anything, the problem solved itself after some time, so its working now.

Again today i was going to do an update to 4 products and i triad to use apsona for this job, but again my site is down, and apsona gives me an error that server not responding, this is second time in a row that i get a problem with my site if i use apsona to do any updateds, since the last time i have only used zen-cart admin, and it all works well, now its all down again just by trying to do anything in apsona.

since my other site still is up and working, tells me that it has to be something with the db tables for this site, since its not able to load anything from them, are you sure there is nothing in apsona that can block or lock down any of the tables? so my webserver and mysql is able to ready from it?

harlyman - Can you share the server log files, so that we can investigate?

Thanks.

apsona:

harlyman - Can you share the server log files, so that we can investigate?

Thanks.

if i was able to, i would, but i dont have access to them:(

i will try to request a copy of them, what do you need? apache and mysql?

harlyman:

if i was able to, i would, but i dont have access to them:(

i will try to request a copy of them, what do you need? apache and mysql?

Yes, those two would be a good start. The Apache error logs in particular might help.

Hi,

I have exported products, customers and manufacturers from one source db and they imported correctly into a target db which is the same tabale setup as the source.

I exported order and they also imported correctly however the $ amount is missing.

I figured that I had to also import ordered_products which looked like it had the $ amount in it. It exported fine but when I came to import it, there was no 'import' option just one where I had to use a Filetr system.

I'm sorry but I am so lost at this point.

Summary is.. how can I export complete order ionformation and import it completely?

Many thanks for a fine script..

star

starlite - sorry for the delayed response. We'll enable imports of ordered products in an upcoming version.

Regards.