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

and if you might include an escape for double quotes and for an accent mark.

I wish this was as easy to use as the old EZ populate.

You have an encoding issue.
Use Libre/Openoffice to ensure you save it as utf-8 encoded, assuming you have an utf-8 database...or as whatever you want. I found Excel lacking in this aspect for both opening and saving csv files.

torvista:

You have an encoding issue.
Use Libre/Openoffice to ensure you save it as utf-8 encoded, assuming you have an utf-8 database...or as whatever you want. I found Excel lacking in this aspect for both opening and saving csv files.

Thanks for the reply. The bad characters are sporadic and not present for every instance of apostrophe, double quote, or accent. Only some.

But that's why I made the comment about EZ. I used to use Excel freely with EZ Pop and as long as I saved as a CSV things were always ok.

Great fix for Apsona for ZenCart 1.5++, Thanks Now I can stay married for a bit longer.

Weird question for anyone who may be listening:

In Shop Admin, I can click on any of the searchable items until I hit about 20 clicks. After that, my site spits out a "No Data Records" warning. After that I hit refresh in my browser and it returns with "No Data Received" - ERR_EMPTY_RESPONSE.

Using 1.5.1 as my ZenCart version. Anyone else seeing this error?

Another issue with Apsona CSV import.

The products are importing into Apsona, getting assigned Product ID's. Great! Everything looks fine inside Apsona. No errors, nothing done differently from other new product imports.

What's not so great is that they are missing from regular Zencart admin where I need to edit their descriptions then make them enabled.

Tried exporting the CSV after the intial new product import and updating existing products but no joy.

Is there a secret key to get the Apsona to agree with regular Zencart? Now I've got several dozen products in my database and they do not show up within Zencart admin. I'm baffled as to what I need to do other then start fiddling with phpmyadmin.

Attachment is my initial import file.

Anyone have any help?

Without looking I suspect you didn't do the categories correctly. category and master category id?

Hi Delia,

I "seeded" a test listing in the category and downloaded the CSV for that. Then created my dozen or so listings using that as my template. I only added Master Category and did not include Category.

Is that the trick? Meaning Apsona has to have both Master Category *and *Category fields specified even tho' they are the same?

That seems to be the case - had a client who went thru this and that's what worked for him in the end.

I re-ran the csv with the added Product ID's and Category filled in and I was able to see the products show up. What a pain! Really wish Easy Populate worked; it was so forgiving and unfussy.

Thank you for the tip!

Hi, I installed all the files into my admin as instructed. I do have the Apsona tool showing up in my zen cart tools. However, when I go to my Apsona in tools, I get a blank page as indicated in my photo snapshot here. What needs to be done? http://www.yazzaorganics.com/KEEP/apsona.png

blank page usually means a php error. Have you checked your error logs folder?

Is anybody having trouble with Apsona the last few days? I've been running it successfully on ZenCart 1.5.4 (I do have the patch installed) until yesterday. Now, for some reason, every time I try to mass delete products, or mass update records, I receive the message "The server is not responding." I can successfully export products but not delete or update. I can't even delete a product by selecting it individually. I have not changed anything locally and have tried it both on Firefox and Chrome.

Also, when I try to import records, the "manufacturer" field is not being recognized. It will not match the manufacturer in my .csv file to an existing manufacturer in the database.

Any insight any of you might have would be greatly appreciated.

I've not had any one of my clients mention it but most folks don't use it on a regular basis. I did check one to make sure it's showing up and looking correct and it is.

I have been getting:

413 Request Entity Too Large
The requested resource
/XXXXXXXXX/apsona_svc.php
does not allow request data with GET requests, or the amount of data provided in the request exceeds the capacity limit.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Zen Cart 1.5.4 PHP Version 5.4.40 --

Was working great a couple of weeks ago and we made no changes to the server. Anybody else seen this?

Uploads just fine - just does not download

Uploads just fine - just does not download
You mean a product export to create a csv does not work?

Just tried mine, it's ok (on php 5.4.45 and 5.6.8).

I am having trouble reinstalling Apsona after a complete site rebuild. I have read through the thread and cannot find a solution.

I have been using Apsona for many years. My site reecently got hosed by me trying to uninstall TaxCloud and I decided to literally start over. I installed 1.5.4, updated the database, and restored the old database into the new site. Everything is working fine. The last step was to reinstall Apsona ShopAdmin. I installed the basic files from the Apsona website, then installed the 1.5.x specific files. The menu listing shows up fine, but when I select it, it opens a new tab, but it is blank with a swirly-thing going around. I let it go for about 2 hours and nothing changed. I looked at the database and the 2 columns for Apsona are there. They were probably there from when I originally installed in in 1.3x. No error logs were created. I also did not install any sql patches like I did in the older version. Should I remove all of the files, including the 2 apsona columns in the database and start over? Any other ideas?

did you get the functions file for 1.5.4? I packaged up what is needed - https://www.zen-cart.com/downloads.php?do=file&id=1985

Thanks for your quick response! I installed all of the files and now I have the ShopAdmin Tab with the header and the footer on it. It does not show any of my site data. Do need to sign in or anything? Sorry to be "High Maintenance"!

did you make the changes to your admin config file?