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

Paul69 - We've deployed a fix for the import issue. Thanks again for letting us know about this.

And, of course, thanks for your kind words. We're delighted that you like the product.

Regards,
Apsona

Do I need to download it or will it update it self? Not sure....

Paul69:

Do I need to download it or will it update it self? Not sure....

You don't have to do anything special. The bug fix will take effect the next time you refresh your ShopAdmin window.

Regards.
Apsona

Great! Thanks for your help!!! :D

Hello

First i have to say that this is realy a great module, this one saves me alot of time, since i have 100000+ products to add to my zen-cart shop, but there is one problem i cant figure out, i have a split list with 3181 product lines in it, and when i import it (with enabled to yes) it does not show the first 100 products, in zen-cart admin main page it says there is 3181 products total but when i go to the categories it only says 3081.

And the first 100 products its not in the shop or even apsona says it has imported all records.

Any ideas what i can do or have done wrong?

I use a fresh instal version 1.3.9h

harlyman:

Hello

First i have to say that this is realy a great module, this one saves me alot of time, since i have 100000+ products to add to my zen-cart shop, but there is one problem i cant figure out, i have a split list with 3181 product lines in it, and when i import it (with enabled to yes) it does not show the first 100 products, in zen-cart admin main page it says there is 3181 products total but when i go to the categories it only says 3081.

And the first 100 products its not in the shop or even apsona says it has imported all records.

Any ideas what i can do or have done wrong?

I use a fresh instal version 1.3.9h

Is it possible that the first 100 records don't have categories associated with them? ShopAdmin will show all records in your product table, regardless of whether they are associated with categories, but (as far as I know) Zen Admin looks for products by category, so it won't show products without categories. (If I'm mistaken on that one, please correct me.)

Apsona

Just uploaded Apsona ShopAdmin, very easy to load and follow. In fact could not believe how good it seems to be. Just one question, can anyone recommend a easy way to enter the description of item. At present I have to use a text editor.

apsona:

Is it possible that the first 100 records don't have categories associated with them? ShopAdmin will show all records in your product table, regardless of whether they are associated with categories, but (as far as I know) Zen Admin looks for products by category, so it won't show products without categories. (If I'm mistaken on that one, please correct me.)

Apsona

They have all categories set, i have even checkd them to see if there is any dobble spaces or anything else that might make this error, but no:(

I have soon another list of 26000 products i will upload, so hope it don't give me the same problem on this list, alot of product to add by hand hehe

harlyman:

They have all categories set, i have even checkd them to see if there is any dobble spaces or anything else that might make this error, but no:(

I have soon another list of 26000 products i will upload, so hope it don't give me the same problem on this list, alot of product to add by hand hehe

We haven't been able to reproduce this problem. Does this happen if you upload just one batch with those offending 100 product records? Can you send us some sample data that illustrates this, either via e-mail or through this forum?

Thanks.
Apsona

apsona:

We haven't been able to reproduce this problem. Does this happen if you upload just one batch with those offending 100 product records? Can you send us some sample data that illustrates this, either via e-mail or through this forum?

Thanks.
Apsona

Have just uploaded 2 more sets of products, and same happend with them, apsona says it has imported all products, and zen-cart admin also says there is the same amount of products in db, but when i go to the categories its 100 less products in each category.

can't figure out why it does that, since there is no problems in the csv files, and its allways the first 100 products that do not show up in the store..............

Another thing i wounder about, is if you have the same model number in different categories, when you do a price update, will this update only one product or all products that match that model nr?

harlyman - we haven't had any similar bug reports concerning the product import errors you mention, but we'll gladly investigate the issue. Please send us email at support (at) apsona.com with any sample data you can provide us.

As for the other question about price updates: if you're talking about the editing or "update all" features in ShopAdmin, they are performed via product id, so they will only affect the record(s) you have selected for editing.

Hope this helps.
Apsona

apsona:

harlyman - we haven't had any similar bug reports concerning the product import errors you mention, but we'll gladly investigate the issue. Please send us email at support (at) apsona.com with any sample data you can provide us.

As for the other question about price updates: if you're talking about the editing or "update all" features in ShopAdmin, they are performed via product id, so they will only affect the record(s) you have selected for editing.

Hope this helps.
Apsona

Hello

I solved the product problem, but regarding the price update, if i have a price list with products that i need to update my shop with, if i choose to do this by model number it only update prices on 1 product with that model number, but since one model is in several categories, apsona only updates the first model it locates in the shops db, and not all of them, is there a way to do this?

The products are not linked btw.

Hi,

I downloaded the Apsona mod but I have had very little success. When trying to upload a csv product file it fails 95% of the time. The two errors that are returned are:

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

or

2. System progress bar unavailable: Maybe Maybe some other component is using it?

I had emailed Apsona direct yesterday but I have had no reply. Can anyone help?

Simmons - this is likely to be a server misconfiguration. It happens because the server is taking too long to respond to requests from ShopAdmin. We've had a few cases where the user's server had a firewall configuration set incorrectly, causing this issue. Perhaps you should ask your hosting company about this.

Hope this helps.

harlyman:

Hello

I solved the product problem, but regarding the price update, if i have a price list with products that i need to update my shop with, if i choose to do this by model number it only update prices on 1 product with that model number, but since one model is in several categories, apsona only updates the first model it locates in the shops db, and not all of them, is there a way to do this?

The products are not linked btw.
This sounds like you are trying an update via the import process. For this to work correctly, the model number field must be unique (i.e., every product record must have a different model number). But it doesn't sound like that's the case in your database, since you say you have the same model number in several categories as distinct product records. In this situation, you will have to update by product id rather than model number. One way to do this is to export the product ids of the products you want to update, change the prices, and then use the product ids for the update.

apsona:

This sounds like you are trying an update via the import process. For this to work correctly, the model number field must be unique (i.e., every product record must have a different model number). But it doesn't sound like that's the case in your database, since you say you have the same model number in several categories as distinct product records. In this situation, you will have to update by product id rather than model number. One way to do this is to export the product ids of the products you want to update, change the prices, and then use the product ids for the update.

Ok that makes it harder and alot more work to do, need to figure a way to be able to update all products with same model number in the zen db, might be an idea for next release or update to add a select all or update all based on model numbers not just one uniqe model.

apsona:

Simmons - this is likely to be a server misconfiguration. It happens because the server is taking too long to respond to requests from ShopAdmin. We've had a few cases where the user's server had a firewall configuration set incorrectly, causing this issue. Perhaps you should ask your hosting company about this.

Hope this helps.

Hi, I have had a reply from my hosts who say there has been no changes to the server configuration or the firewall. I have only just started to use/play/learn your Apsona add-on since the 26th of Dec. Everything was working fine until the 29th of Dec.

I have reinstalled the files in case there was a problem. Used Win-merge to compare the files before and after this problem and there is no difference. I have even installed the files on another test zen cart website on a different domain but it still returns the same errors messages.

Any ideas?

harlyman:

Ok that makes it harder and alot more work to do, need to figure a way to be able to update all products with same model number in the zen db, might be an idea for next release or update to add a select all or update all based on model numbers not just one uniqe model.
It would help greatly if I can understand this use case better. I had the impression that requiring model numbers to be distinct is appropriate, but your use case contradicts that.

What is it about the product-id-based update requirement that makes it a lot harder? Is it that you're getting your prices in a price book from an external source? Can you describe the process you follow, and the data source you get the data from? We can then accommodate such uses within ShopAdmin.

Thanks in advance for your inputs.

Regards.

Can anyone help? Apsona worked fine until the 29th where everything worked except uploading products by a CSV file.

I can export, I can update existing product records but I cannot create new products by CSV file????? I get no validation errors and the new categories are created but not the new products within that newly created category.

My hosts have tried too and they say it is defiantly not a server / firewall problem.

I can change, delete and add new products and categories manually one by one via both the Zen Cart Admin and the Apson Tab, but completely unable to upload new products via CSV.

I have this installed and tested Apsona on three new clean Zen Cart installs on two separate servers and both have the same error. 'unable to connect' then after that every error message reads “System progress bar unavailable: Maybe some other component is using it?” until I close down aspona and restart it.