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

ellivir:

I'm wondering if the silence means that Apsona people are not able to make the DISCOUNTS working at all. I'm also wondering how it was working with EasyPopulate then. There is no problem with that one. It is just that if you use Apsona to load the products, you should be putting the discounts at the same time since those are in the same spreadsheet.

Done a bit searching a solution for this Specials / Discount price problem:

1. specials_id: a check which id number is going and reserving a next one
2. products_id: Special prices are based on the products_id, so it can be saved based on that or recommended is to search what is the products_id for a certain model number
3. finally just giving the specials_new_products_price and put the status on (1)

This requires of course some coding but this should be easily done anyhow.
The problem with Apsona is that the crucial code is hosted elsewhere and community can't participate on this. Above my 20 cents as contibution for the development.

There are shops that are based on the fact that the products have a good specials / discounts and that renders the whole Apsona useless if these can't be input functionally.

I tested Apsona a year or so ago, didn't figure it out but intend to take another look.

Anyway, even if Apsona lacks in some areas, can't you do discounts via Easy Populate, that is, upload specials prices with Easy Populate? Can't Apsona and Easy Populate work together where one is a little better at something? That and the regular Zencart admin.

Apsona is not a hosted solution.. ALL of the code is run locally on your site..> ellivir:

Done a bit searching a solution for this Specials / Discount price problem:

1. specials_id: a check which id number is going and reserving a next one
2. products_id: Special prices are based on the products_id, so it can be saved based on that or recommended is to search what is the products_id for a certain model number
3. finally just giving the specials_new_products_price and put the status on (1)

This requires of course some coding but this should be easily done anyhow.
The problem with Apsona is that the crucial code is hosted elsewhere and community can't participate on this. Above my 20 cents as contibution for the development.

There are shops that are based on the fact that the products have a good specials / discounts and that renders the whole Apsona useless if these can't be input functionally.

Can't Apsona and Easy Populate work together where one is a little better at something?
Of course..they are only different transfer methods to manipulate data.

I understand also that despite the Apsona core code being downloaded from their servers on each use, it can be customised per account/client.
I am surprised that they have not responded, I had a lot of contact with them in their early days resolving language-dependent issues and found them very keen to resolve any problems.

Steve - Sorry that our responses have been spotty lately. We have been completely swamped with work. We took on another project outside the shopping-cart domain, thinking that it would broaden our reach, and it has ended up consuming all our resources and stretching us very thin. We hope to get back to a more active role here soon!

Regards.

apsona:

Apsona now offers Apsona ShopAdmin for Zen Cart. ShopAdmin is a free tool for importing, exporting, updates, reports and business analysis for your e-commerce site.

If you have not yet signed up to use Apsona ShopAdmin for your Zen Cart application, please visit http://apsona.com and click the on “Sign up” link.

Best regards.
The Apsona team
http://apsona.com

Hello, I am having issues using Aspona. It will upload everything fine onto the Aspona dashboard, but the products do not upload to zencart or onto my website. What is going on? I can see that everthing is fine on the Aspona side, but nothing on zencart. Help!

WWRepair:

Hello, I am having issues using Aspona. It will upload everything fine onto the Aspona dashboard, but the products do not upload to zencart or onto my website. What is going on? I can see that everthing is fine on the Aspona side, but nothing on zencart. Help!
The most common reasons for this are that the products have not been uploaded as enabled, or that they don't have an associated category.

Just to repeat the same thing, when you are adding a new product, it needs a master category and a category column defined in the csv.
The master category has to exist in the category column for each language you upload (in that language).

It would be a good idea to add an error check for this condition on new product uploads.

Hi,
Love my Apsona ! Been using it for several years.
But, I am having an issue today I've never experienced before.
Using my usual, properly formatted spreadsheet, I am uploading New Products.
All the column headers are correct, but for some reason the Model numbers will not upload. The Model number for these new products will not show in Apsona, nor Zen-Cart. I even deleted the products I had uploaded and re-uploaded them, double checking that the Model column was showing and correct.
I have images of the process if you would like to see them, step 1 - 3.
Could you check into this for me?
Thanks!
Kathleen

Scratch my previous post/question. Along with having Apsona issues, I was having a template issue, but ONLY in Chrome.
I just got a Chrome update from 19.0.1084.56 m to 21.0.1180.60 m and all is well again.
So sorry for the confusion !
Kathleen

apsona:

The most common reasons for this are that the products have not been uploaded as enabled, or that they don't have an associated category.

Okay, I do verify that I have a Master Category listed as DRYER, then my sub categories are listed like this DRYER: Thermostats. How do I ensure they are uploaded as enabled - is that a seperate step I am missing?

It is so weird because I uploaded the file and I could see all the products on the Aspona side - correct Master Category, sub and they were checked as enabled - but nothing on the zencart or website., so i uploaded the exact same file again and then I could see it in the zencart side and on my website. It so weird that it works sometimes and not others. It has happed a few times to me. I am using the import new products with the option to update any duplicate files it comes across

By the way, I apsolutely love your program and I hope I can figure out what I need to do to use it correctly everytime. Thank you!

Master Category listed as DRYER, then my sub categories are listed like this DRYER: Thermostats.

Create a product manually through the admin, then export the csv.
Look at the contents of these columns.

If the product is listed in DRYER: Thermostats and its the only category it is in, its master category will also be DRYER: Thermostats.
If its listed in multiple categories, one of those will be duplicated in master category.

torvista:

Create a product manually through the admin, then export the csv.
Look at the contents of these columns.

If the product is listed in DRYER: Thermostats and its the only category it is in, its master category will also be DRYER: Thermostats.
If its listed in multiple categories, one of those will be duplicated in master category.

I guess I didnt explain that very well. My master category is DRYER, and the sub category inside that is Thermostats. So when I upload I have master category listed as DRYER and the category listed as DRYER: Thermostats so the parts will go into the sub category. I did fix the 'enabled' issue. Turns out I just have add a row called enabled and have them all '1' and that makes enabled yes. Thank you very much for your excellent and fast support. I think my problem was that for new products I was telling it to enable and thats why it didnt' always work. Thanks!

Hi, we're using Apsona on 1.3.9h. We'd like to be able export the subtotal and shipping cost data with the rest of the ORDER data but it isn't a selectable option in the export tool. When viewing an individual order, you can find those amounts in a tab called "order totals" - displayed as ot_subtotal and ot_shipping.

Anyone know if there's anyway to get those totals to be a selectable check box when you select tools>>export?

Thanks,
Andy

(I do see that "add +" button that says" add total order to this order". Clicking opens an addition form which I don't really understand. I haven't been able to find any documentation on it.)

Very happy with the module, the 1.3.8a works like a charm and saved me hours! The only problem I had was doing a full search as you need a dedicated server, to perform it in thousands of products, but if you just filter data, it works like a cinch! Is fast and reliable. Now I am looking to get a new version for my new store, which is using zc 1.5, but so far I was not able to find it under admin tools ... was it moved somewhere else?

You'll have to install the original version of Apsona that you have, first.
This page on their website explains how to install the update for 1.5 on top of the original Apsona install, along with a link to download the update: Apsona 1.5 update.
Also, with the update to 1.5 there isn't a link in the admin section of your store to access Apsona anymore. You'll have to create a bookmark to the page & save it to access it.
Your bookmark will be the following: http:// YOURWEBSITE.com /YOUR ADMIN FOLDER/apsona_index.php#home/dashboard
(If you're not already logged in to your admin area, the sign-in page will pop up & you'll have to log in to access Apsona.)
Hope this helps you out :)

icecold:

Very happy with the module, the 1.3.8a works like a charm and saved me hours! The only problem I had was doing a full search as you need a dedicated server, to perform it in thousands of products, but if you just filter data, it works like a cinch! Is fast and reliable. Now I am looking to get a new version for my new store, which is using zc 1.5, but so far I was not able to find it under admin tools ... was it moved somewhere else?

I love Apsona Shop Admin. Great reporting tools and easy category management!

I wish there was a link/button to return to the normal Zen Cart admin though. Maybe this could be implemented fairly easily?

I wish there was a link/button to return to the normal Zen Cart admin

I did this to get Apsona to open in a new browser window:

in admin/includes/header_navigation.php

change

      <ul>
        <?php foreach ($pages as $page) { ?>
        <li><a href="<?php echo zen_href_link($page['file'], $page['params']) ?>"><?php echo $page['name'] ?></a></li>
        <?php } ?>
      </ul>

to

      <ul>
        <?php foreach ($pages as $page) { ?>
        <?php if ($page['file']=='apsona_index') { //hack to open Apsona in a new browser window?>
        	<li><a href="<?php echo zen_href_link($page['file'], $page['params']) ?>" target="_blank"><?php echo $page['name'] ?></a></li>
<?php } else { ?>
            <li><a href="<?php echo zen_href_link($page['file'], $page['params']) ?>"><?php echo $page['name'] ?></a></li> 
        <?php } } ?>
      </ul>

Hi, Sorry for hijacking this thread, But Apsona will not open. The last time i used it to add some new product to my shop was about 6 weeks ago. i am still using 1.38, has anything changed in Apsona?

many thanks in advance for your assistance.

Soul39

has anything changed in Apsona?
Not for me..still working fine.