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

[gxjenkins]

I typically update over 9000 product prices at a time, in under 2 minutes. When you are updating, are you sure that you have the accurate data in the column that you have selected as "lookup by:". If this is inaccurate, you may be creating new files instead of updating the old ones.

Regarding the inactive products, are you including the "enabled" field in the update file? Check the headings of the file to ensure that it is not updating the enable file with a "0". This would deactivate the product

Finally - Is Apsona showing you any errors in the popup box?

In the Lookup by: window I'm using "Model". I understood that when in the Update Mode Apsona won't validate a product if it doesn't find an existing product to update. If that's not right let me know.
All the inactive products are products that were updated. Its just like it de-activated the original product and created a new one. That's new and it wasn't doing that before. The total active number of products stay the same, but the de-activated total increases by the number of products I update.
I'm thinking Apsona maybe timing out when I do the updates but its hard to pin down. Sometimes I can update 2500 records, and it's fine. The next update maybe 300 and I'll get the Server Not Responding error.
This is beginning to look allot like its both Apsona, and my Hosting company. I'm in the middle.
If you've got any ideas I'm all ears.

Thanks,
Gary

[SPembleton]

In the Lookup by: window I'm using "Model". I understood that when in the Update Mode Apsona won't validate a product if it doesn't find an existing product to update. If that's not right let me know.
All the inactive products are products that were updated....
If you've got any ideas I'm all ears.

Thanks,
Gary

It sounds like you are doing the same thing that I am doing. When you upload the file, and go to the next screen(2. Set up Fields), does Apsona think it is updating the "Enabled" column? In other words, Apsona identify any of the columns listed as Enabled?Which fields are you trying to update?

[gxjenkins]

It sounds like you are doing the same thing that I am doing. When you upload the file, and go to the next screen(2. Set up Fields), does Apsona think it is updating the "Enabled" column? In other words, Apsona identify any of the columns listed as Enabled?Which fields are you trying to update?

I'm not sure what you mean by "enabled". I have to match each input field with one that is already in the DB.



I hope the image shows up, never tried this before.
The next page it Validates each field. The next page after that shows how many are ready to be inputted and how many are rejected.



All that is left is to import them into the DB. Today I was able to import 2200 new items without a problem.
This is just too weird.

[Valentine88]

Originally Posted by harlyman
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?
I wondering what was the resolution to this issue. I can't seem to find it. I can update 1000 products and turn around and update just 4 and get this error.

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

I've had my host check that the sql server is up and running and they report everything is fine.

How was this fixed?

Thanks,
Gary

I am having the exact same issues! It is very frustrating!!
My host reports everything is fine as well. Has anyone figured this out yet?

[SPembleton]

I started out by exporting my existing database out from Apsona as a csv file, which I then make into an Excel file. I then make all of my edits for my database from that file, convert it back to csv and upload it via Apsona. That way all of the column headings match the field titles in Apsona and in my database. Most of my updates are prices (I sell items made of silver which have volitle pricing.) Since most of my updates only involve price, I just update the columns that need updating.

When I add a product, I use the same Excel file, fill in the info in all of the columns, export just those new items to a csv file and import them into my database via Apsona.

One of the fields in your database is "enabled?" If this is set to 1, it is enabled. If it is set to 0 is is not enabled. Something has to be changing that parameter. I would look to see if you have a column in the file that Apsona thinks is the enabled field. Your screen shot above does not show all of the field headings, so I am not sure.

In the example you have above, I am not sure why you have so many columns the say "Do Not Import". I think if you do what I suggest above, have your update file only include the fields that you want to update (plus the identified field , such as model or product), and use the same titles in the update file that you have in the file, it will work smoother.

Try this, if you are still having trouble, post again. I will continue to work with you both if needed.

[gxjenkins]

I started out by exporting my existing database out from Apsona as a csv file, which I then make into an Excel file. I then make all of my edits for my database from that file, convert it back to csv and upload it via Apsona. That way all of the column headings match the field titles in Apsona and in my database. Most of my updates are prices (I sell items made of silver which have volitle pricing.) Since most of my updates only involve price, I just update the columns that need updating.

When I add a product, I use the same Excel file, fill in the info in all of the columns, export just those new items to a csv file and import them into my database via Apsona.

One of the fields in your database is "enabled?" If this is set to 1, it is enabled. If it is set to 0 is is not enabled. Something has to be changing that parameter. I would look to see if you have a column in the file that Apsona thinks is the enabled field. Your screen shot above does not show all of the field headings, so I am not sure.

In the example you have above, I am not sure why you have so many columns the say "Do Not Import". I think if you do what I suggest above, have your update file only include the fields that you want to update (plus the identified field , such as model or product), and use the same titles in the update file that you have in the file, it will work smoother.

Try this, if you are still having trouble, post again. I will continue to work with you both if needed.

One of my issues seems to have cleared itself up.
Yesterday and today I’ve been able to update existing products and it did not produce de-activated products. I don’t know what has changed, only that it has been working the last two days.

That only leaves the problem “Server Not Responding”.
I’ll be adding about 3000 new products to the store this afternoon and I’ll update everyone on how that turns out.

One possible reason for the Server Not Responding error is that Apsona is time sensitive, and if the Server does not respond in a certain amount of time it will throw up an error.

Gary

[SPembleton]

One possible reason for the Server Not Responding error is that Apsona is time sensitive, and if the Server does not respond in a certain amount of time it will throw up an error.

Gary

I have noticed that Apsona seems to stop if I navigate away from it to another tab (I use Firefox).

I also wonder if it has anything to do with the timeout settings for the admin cart in v1.5. Before you start the upload, navigate back to the admin page, do something to reset the timeout clock on the admin page, then navigate back to Apsona and initiate the process. The other way to get around the timeout on the admin page is to go to "Who's online" and set it to refresh every minute. That will reset the clock.

[gxjenkins]

I have noticed that Apsona seems to stop if I navigate away from it to another tab (I use Firefox).

I also wonder if it has anything to do with the timeout settings for the admin cart in v1.5. Before you start the upload, navigate back to the admin page, do something to reset the timeout clock on the admin page, then navigate back to Apsona and initiate the process. The other way to get around the timeout on the admin page is to go to "Who's online" and set it to refresh every minute. That will reset the clock.

I think you maybe on to something there. At least for most people getting that error. Increasing that time out setting could fix most of the time out error.
For me I think its because my host has setup an Abuse Monitor so we can track down what is taking too long.
I'm sure it is the way Apsona accesses the DB. I opened Apsona and it opened normally. Clicked on Products and it showed all the products on the left hand side of the screen. All normal. Then I searched for a test product and Apsona started its search. The search gave me the Server Not Responding error. At the same time I started the search in the store Admin area I started a search for the same test product. It was stuck on searching until after I closed Apsona. Apsona did not return a results for the search instead I got an error. In Admin the search did return a results, but not until I closed Apsona, and the search took more than 275 seconds.
To get around that I stopped doing searches in Apsona.
I was able to update 2715 products with out an error, or de-activating any products.

But on a test update I updated just 2 products and it was successful, but now they can't be found in the store.
They were showing in the store before the update and now after the update you can't find them. I found the problem by finding them in the DB. They don't have a Category associated with them. The update deleted the Category information.

The updated information was just Model, Name, and Number of items in stock. The two items are:
Melon Shell
Large Murex Shell
They are both in the DB and enabled but have no Category listed.
I have tried to recreate this and so far have not been able to. I updated 2700 products since then and it looks like all are still there. So, maybe it was just a hiccup.

I'll let you know more later. I still plan to add 3000 new products. I just hoping there are no issues with that.

Gary

[SPembleton]

But on a test update I updated just 2 products and it was successful, but now they can't be found in the store.
They were showing in the store before the update and now after the update you can't find them. I found the problem by finding them in the DB. They don't have a Category associated with them. The update deleted the Category information.Gary

You may want to insure that those two are the only 2 that do not have category info. If you create a filter in Apsona to find all of the products where category is empty, you can then use Apsona to add the category info.

One additional thought. Are you running on a linux server? If so, make sure that all of the names have the correct case. Linux is funny that way - lots of things seem to be case sensitive.

Is there any possibility that the file that you are uploading includes a column labeled category or master category and has a blank or a space in that field?

Good luck. It seems that you are getting closer

[gxjenkins]

Just to update everyone on how this is going I’ve found that Apsona is importing the new records and updating existing records. At least until it shows the error message, and then it stops.

The problem is in the Category field. It is not being updated or set with new records. All the other fields are being set or updated.

It appears that Apsona must be waiting for some kind of acknowledgment from the write, or update process and it never comes so it throws an error that the Server Is Not Responding because the process has not completed.

I’ve decided, for now at least to move the store. Although the speed of the site is outstanding, I believe this problem is connected to the Server.
In any event I’ll know once the site is moved.