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

Anthony H - We're definitely supporting Apsona ShopAdmin. We've just been a bit quiet lately because of lots of other work. I'm not sure why you did not get an e-mail, though - did you try sending e-mail to us through the contact-us page on our website?

Thanks.

Quote:

---

Originally Posted by kelvyn

Still loving Apsona, but would like a little more info on how to make a sales report, a bit like the "Sales Report" mods shows.

I can see there are loads of charting and graphing options, but I'm simply after making a weekly or monthly total sales bar chart.

Should be easy, I'm sure it can be done, but the solution is evading me!

---

Can you perhaps spell out a bit more detail about what you want? I realize that our documentation is a bit sparse, but we'll try and put together a tutorial on our website.

Anyone know if the thread subscription feature is broken, perhaps? I subscribed to this thread, but I see a lot of posts that I never got notified about.

Thanks.

Quote:

---

Originally Posted by RiverCity

Category Question:

I am using Apsona and have used it to download a current copy of the websites database to use as a template for adding several hundred new products to the site.

If I enter the new categories:sub-categories in the same format as in the downloaded template (Main:Sub1:Sub2) into the new database file and upload it, will it create the new categories/subs that are needed or do I need to go into ZenCart admin and add the new categories first before I upload the new database?

Thanks

---

Make sure you have the space after each colon. If you don't have one, Apsona will treat the entire string as one category name.

Hope this helps.

Quote:

---

Originally Posted by apsona

Can you perhaps spell out a bit more detail about what you want? I realize that our documentation is a bit sparse, but we'll try and put together a tutorial on our website.

---

Oops! I didn't see your reply until I'd figured it out myself.

Finally, I think I have the hang of making reports in Apsona, and it's very powerful and very easy to visual stuff. Really good.

If anyone has a report they want to make but don't know how, just ask on this thread. As there are no instructions, it took me a good half a day to figure it out, but trust me, it rocks once you know how!

Is there any way of making the div which displays the data much higher?
I want to be able to print a tall page of horizontal barchart. Or implementing the print function?

I can override it manually by using the developer toolbar to untick the style

PHP Code:

---

.sf-report-run .sf-tabcontent {
height: 470px; < untick this
overflow: auto;
padding: 0;
} 


---

in apsona.1103152126.min.css but the option of a tall display would be nice too :)

Apart from that, all good, and I can even workaround that one so no rush.

I’m having a problem with Apsona I’ve never seen before. I’ve been using Apsona since Jan. 2011 and its been working great.

When I started using Apsona I was on a shared hosting account and Apsona ran great.

I just moved to a VPS setup and re-installed ZenCart and Apsona. I had to changed the rights on a couple of files after the install but since then it has worked just fine.

I used Apsona to create 19 new categories in the store and there were no problem with that.

The problem starts when it goes to import the products. It just sits there with the timer running, but nothing is being put into the DB.

I’ve checked the Server error logs and there are no errors. Checking phpmyadmin there is nothing going into the DB.

My host doesn’t know anything about Apsona and since its hosted on Apsona’s servers they don’t have a clue what to look for, and neither do I so does anyone have and idea what might be causing this?

Here is a bit more info.

I know for sure that Apsona is adding the new categories to the DB during the import.
Apsona is checking the DB to see if the import is a new add, or an update. After that it should add the new products, but that is where it stops.

My Host has completely reloaded my VPS system. I did a fresh install with one template, Product Fields, and Apsona.

Same results when I tried to import new products. Apsona created the categories, but would not add products to DB.

Now that I'm sure this isn't a conflict between Apsona and another addon it has to be a Server setting.

Does anyone know what the Server Requirements are?

All Fixed! Apsona support figured it out.

They had modified their code to allow me to use an extra field (product fields). When the code was modified I was on the old Hosting account and the "zen" prefix was used.

The prefix wasn't used with this new install. So, the code was hanging when it got to the modified code that was expecting the "zen" prefix.

The fix was to rename the tables with the prefix and all is working.