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

Lenpilot - we don't (yet) support automatic data feeds or XML. At the moment, ShopAdmin is a purely interactive browser-based system.

Regards.

No problem,

I actually spent the last two days writing a script to do this and I finally have it done. I am grabbing the csv version of their feed parsing it to the Zencart table format and running a "while loop" to throw the results to a preview page. (not needed but it makes the customer feel good) then when he has that warm fuzzy feeling that everything is going to be fine, he clicks the update link. and then: where product model =XXX update Quantity happens. Ultimately spitting out Success for each line updated! Or a whole bunch of nasty fail dialog, (which hasn't happened yet).

I would have liked to put this in cron but it won't let me grab the external feed... Maybe I will put it in as "include quantityupdate.php" (not the real name btw) in the front of the cart. I haven't decided yet.

But thanks for your response.

Len Farneth

I have a fresh copy of Zencart 1.5 installed and tried to install this app

1. nothing shows up under tools that says apsona
2. when i run http://localhost/surplus/apsona_index.php i get a blank screen with a blue header at the top with this in it " ShopAdmin for wils tv " where ever that comes from i have no idea.
3. trying to run any other php file is fruitless.
4. I have e-mailed Apsona and haven't as of yet had a response, guess they are to busy to support their product.

I am figuring this utility doesn't work in V 1.5 or has somebody been able to get this to work ?
Thank you

If it hasn't been upgraded to use the new v1.5 admin menu system then it won't show in the menu.
There are several support threads discussing the change, which developers can use for updating their mods.

Thanks DrByte
There is such a massive amount of topics, pages to go through it's almost impossible to find, would actually be nice if the forum was broken up into smaller chunks with more specific topics. I'm not complaining because there is a lot of information here, just a thought
:)
P.S
Would be nice if Apsona were that fast to respond LOL

LOL - the forum was separated into about 80 different sections at one point, and everyone complained that they had no idea where to look for something let alone where to post, so it was consolidated into fewer broader categories. :)

If you're not into developing mods, then the programming instructions for that probably won't be all that useful to you.

Hello all,

I have read all the Topics and I can't find information about:

• I would like to import and export products in two languages but I can't find how to do it.

Can anyone help me?

Congratulations to Apsona for this beautifull program ;)

Regards
João Raposo

I assume you have already added the second language to your shop.

In Apsona, choose english, export the products with the fields you want.
In Apsona, change to the second language, export the products with the fields you want to a second csv.

Open the first csv with Openoffice to ensure you use the correct character set.
Save it in the Openoffice format. Save the file, now that's your working copy.
Open the second csv and copy the columns into this OO file..

Now you can arrange everything as you like using the common ID, model number as reference but with the language-dependent columns for name, description, meta tags etc.
You can rename the columns as you like as you can map them to the correct database fields during the import.

When you are ready to import, save the file as csv again.
In Apsona, choose english, import the csv. It will probably map the columns correctly but you can check them.
In Apsona, choose the second language, import the csv. You will probably have to map the fields manually for the id and the second language columns.

No doubt you will get errors flagged on the way but they are self-explanatory and anyway you wont be doing this on a live database will you!!!
regards
Steve

P.S. They are looking at 1.5 compatibility at the moment.

windsurfer:

I have a fresh copy of Zencart 1.5 installed and tried to install this app

1. nothing shows up under tools that says apsona
2. when i run http://localhost/surplus/apsona_index.php i get a blank screen with a blue header at the top with this in it " ShopAdmin for wils tv " where ever that comes from i have no idea.
3. trying to run any other php file is fruitless.
4. I have e-mailed Apsona and haven't as of yet had a response, guess they are to busy to support their product.

I am figuring this utility doesn't work in V 1.5 or has somebody been able to get this to work ?
Thank you

I emailed the developer, and he said that he is working on updating the software. Hopes to have it up in the next couple of days.

I just got another email from the developer. He said he should have the updates done in a week. I am encouraging him to turn it around quicker. We will see.

Great News!

Folks,

Thanks for bearing with us, and for all the support. We have been extremely busy the last several weeks, but things seem to be settling down now. We'll have an update on the Zen Cart 1.5 support as soon as we can.

Thanks again!

Hi, I was wondering if this capability has been added to Apsona... basically, have a report like this:

Product Name | Order Date | Customer Name | Attribute 1 name/selection | Attribute 2 name/selection | Attribute 3 name/selection

(with the attribute name/selection concatenated)

...or something like this:

Product Name | Order Date | Customer Name | Attribute 1 selection | Attribute 2 selection | Attribute 3 selection

So that each order with attributes is in a single column.

If that functionality is not yet supported, what is the likelihood of it being added anytime soon?

[[[
In my current version of Apsona, the (Ordered Products) report creates a new line item for each attribute of an ordered product, like this:

Product Name 1 | Order Date | Customer Name | Attribute 1 selection
Product Name 1 | Order Date | Customer Name | Attribute 2 selection
Product Name 1 | Order Date | Customer Name | Attribute 3 selection
]]]

Thanks!

hockey2112 - this is not a feature currently supported within ShopAdmin. We're working through some features, however, so we'll let you know when done.

Thanks!

apsona:

Folks,

Thanks for bearing with us, and for all the support. We have been extremely busy the last several weeks, but things seem to be settling down now. We'll have an update on the Zen Cart 1.5 support as soon as we can.

Thanks again!

Any clue how long we'll have to wait for that new update that will work on ZenCart 1.5?

Thanks for any answer.

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'm new in Zen Cart and installed the Version 1.5 as the first Zen Cart install.
So I'm not sure I could help. Anyway, if I could, just let me know and I'll do my best.

DrByte:

If it hasn't been upgraded to use the new v1.5 admin menu system then it won't show in the menu.
There are several support threads discussing the change, which developers can use for updating their mods.

I would also like to know where the post that explains how to install ShopAdmin on ZC 1.5 I have been all over this forum and cant find anything that describes how to install ShopAdmin on ZC 1.5:( GoDaddy only will install 1.5 and now I am stuck trying to import data to said cart. If you could provide a link the sure would be handy after reading all about ShopAdmin I dont think that I wand to use anything else.

Thanks:smile:
-Dog

DivenDog:

I would also like to know where the post that explains how to install ShopAdmin on ZC 1.5 I have been all over this forum and cant find anything that describes how to install ShopAdmin on ZC 1.5:( GoDaddy only will install 1.5 and now I am stuck trying to import data to said cart. If you could provide a link the sure would be handy after reading all about ShopAdmin I dont think that I wand to use anything else.

Thanks:smile:
-Dog

They have not yet released it. I am running their test version and it works well. If you look above they are looking for 1 more person to test it before they release it. (jan 22 12:11pm post) The old version will not work on 1.5 because Zencart made a change in how menus are displayed.

Btw - I also use GoDaddy, and they will allow you to install any version. They only distribute 1.5, but you can get older versions in the Zencart archives, and install it yourself.

SPembleton:

They have not yet released it. I am running their test version and it works well. If you look above they are looking for 1 more person to test it before they release it. (jan 22 12:11pm post) The old version will not work on 1.5 because Zencart made a change in how menus are displayed.

Btw - I also use GoDaddy, and they will allow you to install any version. They only distribute 1.5, but you can get older versions in the Zencart archives, and install it yourself.

I did request to be added at their website this morning and yet to get e response from them. Thanks for the heads up on the older versions but I would like to keep it simple with the current version the GoDaddy is installing. I am sure that it wont be long.
its Just that the good Dr references that you can do it now based on older posts and that is misleading and time consuming. I don't mean any disrespect just that info like that makes peeps start searching with no results and that is a bummer.

Thanks
-Dog