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

[nadsab]

Does Aspona work with ZC 1.5?

[nadsab]

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

I can't find it...

[torvista]

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.

[nadsab]

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

[nadsab]

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

[nadsab]

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.

[jetx]

Why not upgrade the old database through zc_install?

[nadsab]

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.

[nadsab]

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?

[time111]

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