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

kennad:

Same issue. I have updated to the new files recommened by Apsona and still a blank screen when trying to run this GREAT add-on. Good thing I am trying to migrate to the new version of ZenCart for all my sites and not having to run live, YET.

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.

I am trying to do a mass update using Apsona of a category > product in 1.5.1.
I want to change the below field from "y" to "n" for all my products:

Products Quantity Box Shows: o Yes, Show Quantity Box o No, Do not show Quantity Box

But when I go to Apsona and select "All Products" and look in the "Product Details" screen, this exact field is not available.
Any ideas?

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.

Yes understood torvista, but my problem is different - simply that I can't "select the field" because this particular field does not seem to appear in the choice of available fields..

this particular field does not seem to appear in the choice of available fields..

You don't have this?

Hello Everyone,

I've been using Apsona since 2011 without issues until now, I'm now getting the spinning circle. The odd thing is we have a dev version on the same server in a sub folder which is essentially an exact clone(cloned two weeks ago) of the live site and Apsona works perfectly. I've reinstalled all of the Apsona files from scratch but still no luck! I'm really puzzled by this!!

Can you only have have one instance of Apsona running on a domain?

Any input would be appreciated. Thanks!

I'm now getting the spinning circle.
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 something is being blocked.

torvista:

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 something is being blocked.

Thanks Torvista.

A Winmerge of my admin configure.php file turned up an inconsistency @ line 18 in the define('HTTP_SERVER', etc... once I matched this up with the working dev version it worked as it always has.

.

torvista:

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 something is being blocked.

Thanks for that- fixed the problem for me.. had never noticed that little icon before.

I have zen cart 1.5.1. I installed Apsona and it seemed to go ok but when I try to use it I get this error message "The server is not responding. Please check your network connection.
Status: error"

I have tried it in Firefox and Safari with the same result.

I have Apsona installed on another site running ZC 1.3.9 which works with no problem. Any ideas?

I have been using Apsona ShopAdmin for 3 years and have not had any problems until now.

When I try to import new products into a new category, they do not show up in zencart. They appear in Apsona, and everything looks right about them, but they are nowhere to be found in zencart.
However, If I import that product into an existing category it will appear.
Also, Apsona DID create the new categories.

I did not change any preferences or do any updates. This is just out of the blue.

Did anyone else have this problem or can anyone help me out?

Thanks

Torvista.......I haven't seen the "Update Records" box you showed above, how to I get to it? I also need to add a couple of fields.

Thanks
Jim

RiverCity:

Torvista.......I haven't seen the "Update Records" box you showed above, how to I get to it? I also need to add a couple of fields.

Thanks
Jim

Is anyone else able to bring up the window that Torvista showed above where you can update record titles?

Thanks

RiverCity:

Is anyone else able to bring up the window that Torvista showed above where you can update record titles?

Thanks

Ok, I found the box indicated above in Torvista's post but it turned out not to be what I was looking for after all. I was looking for a place where you could add product fields that weren't included with ZenCart install. I have a couple of datafeeds that need different fields than what is showing as options.

Anyone have any ideas if this is possible or not?

Thanks,

Jim

kelvyn:

Yeah, we started getting this too. Here's what we do - first of all, of course, BACKUP your database!

Then, go to "Store Manager" and then...

• Update All Products' Attribute Sort Orders
• Update ALL Products Price Sorter
• Reset ALL Products Master Categories ID

Thanks for your reply Kelvyn.
I did the first 2 steps but I am unsure of "Reset ALL Products Master Categories ID".
What exactly does this do?
I have a lot of products and they are all linked to multiple categories.
Will this cause any problems?

Thanks!

Anyone have any ideas on this or might be able to point me in the right direction? Thanks

RiverCity:

Ok, I found the box indicated above in Torvista's post but it turned out not to be what I was looking for after all. I was looking for a place where you could add product fields that weren't included with ZenCart install. I have a couple of datafeeds that need different fields than what is showing as options.

Anyone have any ideas if this is possible or not?

Thanks,

Jim

I have about 10,600 SKUs on the site. I calculate the prices based on the current cost of gold and silver. The prices are calculated in an elaborate Excel spreadsheet. I save the file as a csv file for uploading. The file consists of the model # and the current price. The file also contains the current date and 2 more bits of data that are not uploaded. In the past I have been able to update all of the prices in one pass.

After extensive testing, I have determined that I can only upload 2500 SKUs at a time. This means that I have to upload 5 files, but at least it works.

When I exceed the 2500 limit, the upload process will pause partway through. Sometimes for as much as a minute. It always does restart at some point. In those situations, when I check a price on my website, I search for the model and I receive the following error:

"The connection to the server was reset while the page was loading"

I then have to shut down my browser. Sometimes I have to wait before my website will relaunch. When I finally get to my site, the last price in the file was not uploaded. I have not checked to see of some are uploaded and some not, as that would be very tedious.

Does anyone have any ideas of where I can go from here.

Does anyone have any ideas of where I can go from here.
Check your php errors and hosting error and access logs (server, mysql) to look for some clue about what is timing out.

SPembleton:

I have about 10,600 SKUs on the site. I calculate the prices based on the current cost of gold and silver. The prices are calculated in an elaborate Excel spreadsheet. I save the file as a csv file for uploading. The file consists of the model # and the current price. The file also contains the current date and 2 more bits of data that are not uploaded. In the past I have been able to update all of the prices in one pass.

After extensive testing, I have determined that I can only upload 2500 SKUs at a time. This means that I have to upload 5 files, but at least it works.

When I exceed the 2500 limit, the upload process will pause partway through. Sometimes for as much as a minute. It always does restart at some point. In those situations, when I check a price on my website, I search for the model and I receive the following error:

"The connection to the server was reset while the page was loading"

I then have to shut down my browser. Sometimes I have to wait before my website will relaunch. When I finally get to my site, the last price in the file was not uploaded. I have not checked to see of some are uploaded and some not, as that would be very tedious.

Does anyone have any ideas of where I can go from here.

I had this problem when my store was hosted on Hostgator. There timeout is set to 30 sec. and they won't change it. In cpanel you should be able to check your server settings, or ask support what is the server timeout set to.

Ok, quick and probably an easy question but before I do it and mess things up...with my luck, I thought I'd ask to be sure. I have my products uploaded ok, when I need to update the inventory count, just what fields do I need have in the csv file that I upload other than the 'Quantity in Stock' field?

Thanks,
Jim