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

[Bewitching]

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

[Bewitching]

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

[WWRepair]

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!

[torvista]

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.

[WWRepair]

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!

[BrooklynArtist]

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.)

[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?

[Bewitching]

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 :)

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?

[maz2390]

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?

[torvista]

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>