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

[johnlewisdesign]

Just a quick update - I fixed it - and its a Zen Cart issue, not an Apsera issue, sorry guys!

What I did, for the record:

• Log in to PHPMyAdmin
• Locate the Products table and click the structure view
• Change products_image field from VARCHAR(64) to VARCHAR(128)

Simple!

[ellivir]

WE have all the product prices including taxes. Can we set apsona to understand that the price has already taxes in it and it would count the tax free net amount based on the tax % given? This is how it works with the EP module, so probably there is a solution for the Apsona as well but hasn't seen how to set it up.

[katrobb]

I have imported products using Apsona and it works great except for one thing. All of the imported products included the Metatags price status as 1 (yes), but it shows as "It's Free!" on the Meta Title and there is a price for each product. I can Edit/Preview/Update to fix this for each product, but that defeats the purpose of importing a list of products. Does anyone have a quick way to fix this issue?

[abcisme]

I have quantity order discounts installed. In the reports, the tax is wrong. Is there a way to display the tax from the zen_orders order_tax table instead of having Apsona calculate it?

Also, is it possible to display shipping cost in the report?

[johnlewisdesign]

Does anyone know how to add CUSTOM fields to the product import columns of Apsona?

I have added 2 new fields (products_condition and products_origin) but they do not show when importing so I cannot populate them via Apsona. They work front and backend perfectly, but Apsona doesn't see it.

I desperately need to import all fields from my clients database...what do I need to modify?

Thanks.

[johnlewisdesign]

Does anyone know how to add CUSTOM fields to the product import columns of Apsona?

I have added 2 new fields (products_condition and products_origin) but they do not show when importing so I cannot populate them via Apsona.

SOLVED!

These fields were created in a new table, products_extra_stuff - the trick is to dupe the columns over to the table 'products', if only for import purposes, then move the columns manually after import for minimal fuss.

I should have known - Apsona AUTOMAGICALLY adds ANY new column created in 'products' to the import options with no extra work.

WOW. Pukka.

[igi2011]

Apologies if this has been answered elsewhere but I can't seem to find it...

I want to download all current (pending) orders in csv format, so I can pull them into a spreadsheet which we're currently using for our other selling platforms (ebay, amazon etc) to generate packing lists, daily order reports, address labels etc.

I've set up a filter in the "orders" menu to do this, but when I download the one thing it doesn't export is details of the products ordered (product name and product model) - I have to do this separately via the "ordered products" menu.

Is there any way of including the product name and product model in the "orders" download?

Many thanks
Lee

[ellivir]

WE have all the product prices including taxes. Can we set apsona to understand that the price has already taxes in it and it would count the tax free net amount based on the tax % given? This is how it works with the EP module, so probably there is a solution for the Apsona as well but hasn't seen how to set it up.

I have written to Apsona, but they seem not to answer to emails, neither visit this forum thread anymore. Has anybody got a solution for this tax issue or should we just use some other system for ourselves? The pity is that the shopkeeper already studied how to use this system, and thus it is not fun to change it just like that. Anyway, they have their prices listed ready with taxes, so we should really input the prices straight like that.

[torvista]

they seem not to answer to emails, neither visit this forum thread anymore.

Unusual, I have always had excellent support from them.

Product prices are natively stored in the database as without tax, to four decimal places.
So a direct import of prices would logically be tax-free also.

Why don't you just create an extra column in your spreadsheet with the calculated price-tax and call it price?

[ellivir]

I'm not sure I fully understand the way admin profiles works, but the SQL is definitely incorrect. The admin profiles add-on should be checking for the page named apsona_index.php, but instead it is page named this:

#" title="Apsona ShopAdmin - opens in new window" onclick="apsona_showPopup('apsona_index');

To me this seems like an error in the way the admin profiles add-on was configured. I am aware of some other folks on this forum that have used admin profiles in conjunction with ShopAdmin, so I hope one of them can help.

Regards.

It works, if you change the file apsona_app_tools_dhtml.php under extra boxes like this:

<?php
$za_contents[] = array('text' => "Apsona ShopAdmin", 'link' => zen_href_link(FILENAME_APSONA_SHOPADMIN, '', 'NONSSL'));
?>

Note:
the whole file have only this text, nothing else and the Apsona will open straight without a pop up function but you can handle that with your short cut keys when clicking the link that you get it open in another tab or window if you wish.
You need to also set up the permissions in Admin profiles to allow the link to be visible.