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

apsona,
In an earlier post in January someone was asking about trying to add or update Category Descriptions in a bulk format. You mentioned that this wasn't available yet.

Can you tell me the current status pleae?
Thanks

RedSpinnaker:

apsona,
In an earlier post in January someone was asking about trying to add or update Category Descriptions in a bulk format. You mentioned that this wasn't available yet.

Can you tell me the current status pleae?
Thanks

Not sure I understand. Categories can be imported and updated via ShopAdmin, and have been for a while now. Perhaps you're alluding to something else?

Regards.

1.3.9h
IH3
Zen Magic Thumb
Missing Images
Custom Template

Hello. Love this mod, but having problem importing product descriptions that begin with a quotation mark. Easy fix?

I don't want to go thru all my descriptions and have to begin each one with something other than a quotation mark.

Elleka - I'm surprised that there is such an issue. Can you please send an email to support at apsona.com? We'll follow up with you.

Thanks.

Sorry to be unclear Apsona. It's not Categories I want to bulk update, but Categories Description. Is this possoble?

RedSpinnaker - I'm afraid I still don't understand. The name and description fields of the category are both stored in the categories_description table, and of course ShopAdmin supports that because it lets you import data into categories.

So please clarify. Thanks.

Apsona - I was referring to the post here titled Bulk Upload Category Description,

http://www.zen-cart.com/forum/showthread.php?t=154704

and your reply,
"You could try Apsona ShopAdmin. It lets you add/update meta tag information for products. It doesn't yet support updating categories, however."

RedSpinnaker:

Apsona - I was referring to the post here titled Bulk Upload Category Description,

http://www.zen-cart.com/forum/showthread.php?t=154704

and your reply,
"You could try Apsona ShopAdmin. It lets you add/update meta tag information for products. It doesn't yet support updating categories, however."

Ah I see. That post is rather out of date - over a year old now. ShopAdmin has come a long way since then. It certainly supports imports and bulk updates of categories now.

Hope this helps.

Yes, many thanks :)

Oh my god! This is fan flippin tastic!! Why didn't I know about this sooner!!! Makes keyword updating so much easier, now I might like that job
:clap:

Thanks Guys!!!:hug:

Hello

Are you able to add comments to order reports? all comments on orders are stored in order_total_history table, and it would be great if you was able to add this to the report selection.

harlyman:

Hello

Are you able to add comments to order reports? all comments on orders are stored in order_total_history table, and it would be great if you was able to add this to the report selection.

also im not able to get the attribute price included in the report i have made, there is only option for priced by attributes, but not able to get the acctual attribute price spesifided, any help?

I can' tell you how much of a time saver this is and so easy to use.
I was lazy in doing my metatags so decided it was time to clean up shop
Let's say you had the same metatags description on all your products it would take ....mmmm 5 seconds to get all your products populated. I'm doing mine by category, with a different metatag description for those. I'm switching my sizes from the description area to the model areas. Easy...place 0 for the description and it empties it and then add the size to the model area and pouff...it's done.
Every one should have this that runs Zen Cart...:clap:

And the support....GREAT. ...as it is on here too...just a little slower:blush:

harlyman - The order_total_history item is on our todo list. We're hoping to roll out some new features and bug fixes in the next few weeks, and it should be included there.

As for the attribute prices: I wonder if you're using the stock-by-attribute add-on? Unfortunately that add-on is rather difficult to support, because of the non-standard way in which it stores table keys in the database. It will take a good bit of work on our part, so it hasn't been prioritized very high.

Thanks for all the inputs, we really appreciate it.

Regards.

apsona:

harlyman - The order_total_history item is on our todo list. We're hoping to roll out some new features and bug fixes in the next few weeks, and it should be included there.

As for the attribute prices: I wonder if you're using the stock-by-attribute add-on? Unfortunately that add-on is rather difficult to support, because of the non-standard way in which it stores table keys in the database. It will take a good bit of work on our part, so it hasn't been prioritized very high.

Thanks for all the inputs, we really appreciate it.

Regards.

Hi

No i only use the built in attribute system, no addons here

harlyman:

Hi

No i only use the built in attribute system, no addons here

Oh? Then I am missing something. Can you possibly post a screen shot of what you're alluding to, so that I can understand what's missing?

apsona:

Oh? Then I am missing something. Can you possibly post a screen shot of what you're alluding to, so that I can understand what's missing?

i will try to get some screen shots for you

btw is there a way to change from comma based to tab based csv file when exporting reports etc?

I'm using zen v1.3.9h and when i click on the apsona link i get this

Apache/2.2.17 (Unix) mod_ssl/2.2.17 OpenSSL/0.9.8e-fips-rhel5 mod_bwlimited/1.4 Server at motorcycleparts.ie Port 443

can somebody translate this into english and let me know what i need to do?

Thanks in advance

I installed the admin-profiles-1.1.1 addon to my database and after discovered I now get the following error an time I try to do something in admin:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'apsona_index');'' at line 1
in:

        [SELECT id FROM admin_files WHERE page = '#" title="Apsona ShopAdmin - opens in new window" onclick="apsona_showPopup('apsona_index');']
        If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Looking at the install sql I noticed that it drops the 'admin_files' table and then re-creates the 'admin_files' table using hard coded (assumed) data rather than using the data that was originally in the table - bad sql.

Since I was a silly boy and only backed up the files rather than the database, please could someone check their 'admin_files' table and let me know what 'Apsona ShopAdmin' data I am missing and need to put back in place.

Thanks in advance.

Paul

Zen Ver 1.3.9d

I wonder if you're using the stock-by-attribute add-on?

I am guessing then that the above means there is no way to update inventory for the stock by attribute module via Apsona?

This would be a dream come true if there was a way to make this happen....

On the flip side...the client would love to be able to pull a report by manufacturer of each product and its options quantities...so I guess that is out of the question too?

Thanks for such an awesome product!!!!!! I have used your program on several sites and the clients LOVE it!

Jill