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

Does Apsona work with ZC 1.5?

yes

Isn't there a link in Apsona admin which takes one back to the ZC interface?

No.

It used to open a new window for the interface but that's not possible in 1.5, so you have to duplicate the admin tab before opening the Apsona link.

Hi,

I am having a problem importing customer records into a ZC 1.5 store. The data I obtained, was from the customers table from my zc 1.38 store which I am migrating.

The problem apparently is that apsona will not let me import because in this table I do not have the customer country, street address and city in the table. It appears that the address, country and city is in the separate address_book table in the ZC 1.38 database.

I don't mind copying that data over the import table, the problem is that the address_book table seems to contain both shipping and billind addresses, and the rows would be out of sequence with the import table - twice as many rows.

Any suggestions as to how I should proceed?

Thanks

Sorry, I mis spelled, it's "...contain both shipping and billing addresses,..." in the above, not "...contain both shipping and billind addresses,..."

Oh, one more question...

When importing customer data, I noticed that in the customer table from the database, that the customer's password is encrypted in the customers_password column.

Will the customer still be able to log in? In other words, does the new installation of Zen Cart know how to read their password, once the table is imported?

Thanks.

Why not upgrade the old database through zc_install?

Because the old store is live, and on a different server. I am migrating it to a new server, and wanted it to get new store ready before DNS changes to avoid interruption.

Plus the new server has latest version of PHP and MySQL. My current setup is outdated server software, did not want anything to break in the upgrade.

OK maybe I should ask the question I posted in this thread on 14 Mar 09:48 AM (above) another way, since no one seemed to have an answer to the above......

For Zen Cart 1.3.8, the address_book table has multiple customer address entries.

Am I correct in assuming that the first address showing in this table for a specific customer, is the billing address for that customer? And any addresses following that first entry for that same customer in the table, is a shipping address for that customer?

Is this correct?

Hi,

Gift Certificate option required.

Can any one guide me for one following modification.

When you go to Customers > All Customers, there under Customer Details tab I want one more option i.e. Gift Certificate.

I not only need to view that details but also edit so that I can directly add/edit the gift value instantly to any customer.

Thanking you in advance.

~ Time
Zencart Ver: 1.3.8a
Apsona version v1.07

Hi guys and THANK YOU for Aspona, it ROCKS!

One problem though - a BIG one - truncated image URLs. I'm stuck with Google Base as my only import, as there's no DB access from my clients old shop, but it deals with it well overall.

My main problem
**http://www.globalkids.co.uk//assets/img/products/product-1118-0-0-tn.jpg
**
This is being truncated on import to

http://www.globalkids.co.uk//assets/img/products/product-1118-0-

Even when manually updated, it is still truncated, breaking all image importing. Any ideas whats going on here?

**On the plus
**I've just got 1200 users in with a bit of patience...mainly down to bad address entry from previous cart. Also - I couldn't see 'address line 2' in import options either which hurt, but no biggie.

Wish
it would be nice to autofill gender, as this took the most time - but not as long as it would have taken without Aspona's help! Some sort of column fill would be good. Also the shop is primarily female, and the default option is male! Typical. 1200 clicks to 3600 :frusty:

Also merging columns would have helped, ie allowing 2 columns to be named the same. This would have dealt with my address problems. Just observations mainly - amazing product!!

(Zen Cart v1.3.9h / PHP 5.2)

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!

:clap:

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

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?

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.

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.

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?

apsona:

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.

Hello

I've been searching for an answer and have not been able to find it so I'm posting it with the hopes of getting pointed in the right direction:

I used Apsona to create categories, manufacturers etc. which was easy and very intuitive. The trouble started when I uploaded the first import. I tried a few products and it worked fine. Then I used a CSV for 7000 products. Apsona only imported about 6300 products and also created double categories for a few top level categories. I'm not sure what I did wrong - but if anyone else had a problem with Apsona creating two records of the same categories and sub categories, please share how you solved it. the test site can be seen at kinkykupid.com / zencart. Please note: this is a adult novelty site/test site and may offend some folks.

The test site is on ZC 1.5