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

I downloaded this last week And Had an email From Aspon to say that it has not been fully tested with ver 1.5:clap::clap:

apsona:

Hello,

We're looking for some help with testing a ShopAdmin update for Zen Cart 1.5. If you're willing to help test and give us feedback, please send us an email through our website.

Thanks in advance.

I had send an e-mail through your website already but get an answer yet. I really would like to help while testing so please hurry up.

Thanks.

Hello folks,

We've made available an update for the ShopAdmin add-on from our website. Please visit the downloads area of the website and download the update.

Please email us if you encounter any issues with it. Thanks to all the folks who helped us with testing.

Regards.

apsona:

Hello folks,

We've made available an update for the ShopAdmin add-on from our website. Please visit the downloads area of the website and download the update.

Please email us if you encounter any issues with it. Thanks to all the folks who helped us with testing.

Regards.

Installed it and so far so good:D

Thanks so much for your help:clap:

-Dog

Question for me is now: Need I install the first the "old" version and after that use the Update for ZenCart 1.5? Or could I directly use that Update for install at ZenCart 1.5?

I asked at Apsona via e-mail but didn't get an answer yet. And I would like to my new shop ready in short time.

Thanks for any answer.

Ok, I got it already.

Was need to upload the initial package first and the update after that. Work Ok now, AFAIK.

Now I could start to setup the shop compeletly.

Thanks for any help I got.

Cheers.

I just downloaded the apsona shopadmin and i don't see any instructions on how to install this at all or am i stupid and not seeing something ?

Note that if you are using this locally (Xampp for example), and are using an additional /local/configure.php with local settings, the ShopAdmin page may not load.
In apsona_svc.php

include ('includes/configure.php');
if  (file_exists('includes/local/configure.php')) {
    include ('includes/local/configure.php');
}
```loads the standard and then local constants. This only partially works with not all the local defined constants replacing the normal ones.

I made this change to choose one or the other, which avoids the problem:
```php
if (file_exists('includes/local/configure.php')) {
    include ('includes/local/configure.php');
} else {
include ('includes/configure.php');}
```And for those confused about getting ShopAdmin in the first place:
1) Register at Apsona
2) Get the files
3) Get the 1.5 update files

If you already have an existing Apsona installation in your cart, tied to an Apsona account, you should only need to download and install the update from our downloads area. If you don't have one, though, you can sign up for one, in which case you should get a package containing all the files you need, including the ones for Zen Cart 1.5.

If you are seeing any anomalies, please let us know and we'll fix it.

Thanks!

I have signed up and downloaded the package but there is no read me file or any instructions as to where these files are supposed to go, which if i may say so, you didn't really answer my question ........... Where do they go ?

Thank you

I did try to run the sql statements in PHP admin and in admin upload, withoput much success i might add both tell me that the table doesn't exist LOL

With upload
Failed: 1
ERROR: Cannot execute because table apsona_filter does not exist. CHECK PREFIXES!
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

Failed: 1
ERROR: Cannot execute because table apsona_report does not exist. CHECK PREFIXES!
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

PHP admin
#1146 - Table apsona_filter' doesn't exist
INSERT INTO apsona_filter VALUES (1,'At least two products',NULL,'order','[{"op":"ge","aggrFn":"count","joinChain":{"tableName":"order_product","thatSide":"orders_id"},"tableName":"order_product","fieldId":"orders_products_id","fieldSpecStr":"count___order_product.orders_id__order_product__orders_products_id___","value":"2"}]','2010-03-10 20:34:42','0000-00-00 00:00:00'),(2,'Worth $500 or more',NULL,'order','[{"op":"ge","tableName":"order","fieldId":"order_total","fieldSpecStr":"order__order_total","value":"500"}]','2010-03-10 20:35:19','0000-00-00 00:00:00'),(3,'New customers (last 30 days)',NULL,'customer','[{"op":"eq","tableName":"customer","fieldId":"ci_date_account_created","fieldSpecStr":"customer__ci_date_account_created","value":"Last 30 days"}]','2010-03-10 20:36:16','0000-00-00 00:00:00'),(4,'Free products',NULL,'product','[{"op":"eq","tableName":"product","fieldId":"product_is_free","fie[...]

#1146 - Table apsona_report' doesn't exist
INSERT INTO apsona_report VALUES (1,'Returning customers (2 or more orders)','','customer','{"outputs":[{"tableName":"customer","fieldId":"c_lastname","columnLabel":"Last name","fieldSpecStr":"customer__c_lastname"}, {"tableName":"customer","fieldId":"c_email_address","columnLabel":"Email address","fieldSpecStr":"customer__c_email_address"}, {"joinChain":{"tableName":"order","thatSide":"customers_id"},"tableName":"order","fieldId":"orders_id","columnLabel":"\u0023 Orders","aggrFn":"count","fieldSpecStr":"order.customers_id__order__orders_id"}, {"joinChain":{"tableName":"order","thatSide":"customers_id"},"tableName":"order","fieldId":"date_purchased","columnLabel":"Last order date","aggrFn":"max","fieldSpecStr":"order.customers_id__order__date_purchased"} ],"tabularLayout":{"widthPx":[120, 120, 57, 100, 120 ]},"name":"Returning customers (2 or more orders)","description":"","rec[...]

I must have been a bad boy LMAO

You don't need to run the SQL. Please visit our website's support area and you'll see the documentation you need.

Okay i installed the add on and the update and when i select the tools/apsona shopadmin i get a blank screen with a blue bar at the top that says ShopAdmin for wils tv ( i have no idea where the wilstv comes from) also when i select the account info or feedback link nothing happens. I have attached a screen shot. I have also installed the mod from torvista and that didn't change anything. This is on a local host. Any suggestions besides going live ?
Thank you

:clap:Aspona have just released a new update for Zen cart 1.5 I have it installed but have to use Firefox as it isn't compatible with IE8, also if you ruin a customer report it screws up the addresses.:clap:

I am having issues getting OPTIONS VALUES to import correctly into a 1.5 store from a 1.3.9 store

I have imported OPTION NAMES and PRODUCTS and even PRODUCTS ATTRIBUTES

The end result is that the OPTIONS VALUES seems to import properly, and even seem to be attached to the products, and I can see them(Values) in the apsona tab, BUT in the Zencart admin options_values_manager.php shows no values, I cant edit or use them via the admin pages at all, It seems broken......

Should I toss this whole idea?

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

gxjenkins:

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 have not heard back from Apsona yet, but I didn't contact them until today. Since this was dealt with already I expected someone to point out the solution, but not.

Anyway here is another wrinkle to add to this. I was able to get around the error today by only updating 1000 products at a time. I don't know if that will work the next time I have to update, but it worked today.
Also, for every product I updated another De-Activated product was created.
So, I started out with 6000 products, and after updating 1000 of them I ended up with 6000 active products, and 1000 de-activated products.
This is getting stranger by the minute.

Any ideas?

Thanks,
Gary

gxjenkins:

I was able to get around the error today by only updating 1000 products at a time. I don't know if that will work the next time I have to update, but it worked today.
Also, for every product I updated another De-Activated product was created.
So, I started out with 6000 products, and after updating 1000 of them I ended up with 6000 active products, and 1000 de-activated products.
This is getting stranger by the minute.

Any ideas?

Thanks,
Gary

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?

SPembleton:

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

gxjenkins:

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?