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.

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.

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.

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.

In admin-> a list of products you can choose the displayed sort order via a pulldown on the top right.

Mine works apart from sorting by product price+ or -.

In the products table I find that all the products I have created/imported via Apsona do not have a value in the field for products_price_sorter.

Just downloaded and installed on a test site. I seem to be having trouble exporting data. When clicking EXPORT, and automatically opening in Excel, it bunches all the data together into one row. Is there any limitations on what type of data can be included in a Product? Maybe QUOTES in the title or description? Or other character limitations?

I've also tried saving and importing the CSV into Excel using Delimited with Tab and Comma, but still have issues.

Anyone point me in the right direction?

RFree190:

Just downloaded and installed on a test site. I seem to be having trouble exporting data. When clicking EXPORT, and automatically opening in Excel, it bunches all the data together into one row. Is there any limitations on what type of data can be included in a Product? Maybe QUOTES in the title or description? Or other character limitations?

I've also tried saving and importing the CSV into Excel using Delimited with Tab and Comma, but still have issues.

Anyone point me in the right direction?

Nevermind... Figured it out. I had my "Region and Language" setting for List Separator set to something other than comma. Put it back and I was back in business...

To repair the empty price sorting field in the products table after importing new products:

1. check that all the products in the table have a master category id.
2. Go to Admin->Store manager and run Update ALL Products Price Sorter

gxjenkins:

Anyone using “numinix_product_fields”

I’ve got that plug-in installed and it has an optional piece that adds a second Description field called “products_description2” to the products_description table.

My problem is that Apsona doesn’t see that new field. It does see the other new fields added by “numinix_product_fields”.

Is anyone else using numinix_product_fields, and have you seen this problem?

Thanks

Hi Jenkins,
I have the same issue here with products_description2 how did you get this fix?

Thanks,
BBC
https://www.llbtechs.com

Hi,
when adding an order for an existing customer, there is a need to fill again all the info. Can I somehow get all this info pre-filled? I was testing this via Customer tab, going to orders and ADD an order. The form is empty without any name or contact info data.

labcomputer:

Hi Jenkins,
I have the same issue here with products_description2 how did you get this fix?

Thanks,
BBC
https://www.llbtechs.com

Can anyone else help me with this. I really need this done.

Thx

Hi -
in loading up attributes, Zen first needs Option names then the Option values.
Is there a way to enter these in bulk via Apsona Shopadmin?
PS simply cannot do without this program for entering, changing items, prices etc
Rufusclc
Del Mar, Ca USA

Hi all,
Ok I have this installed on a Zen 1.3.9h and everything seems to be working well except when I try to export the products and really starting to get aggravated. I am setting up a store to where I am selling products at Retail priced and setting up a store for wholesale (same products, categories, description, etc. when I try to export the products from the Retail store and it asks if I want to open or Save I have tried both and this is what is showing in the products.csv file -
{"error": "/get/data/product.csv: No query given."}

Now I have tried to select various different Filters when I am looking at the Export Selected Records box and keep getting the same thing.

Help would be greatly appreciated as I NEED this feature as the Retail store will have over 1,000+ Products that I will need to import into the wholesale site.

Thanks much in advance.

{"error": "/get/data/product.csv: No query given."}
I've never seen that problem.
In the top right of the Apsona window is a feedback link you should use.
Apsona support is very good.

KeystoneAirsoft:

Hi all,
Ok I have this installed on a Zen 1.3.9h and everything seems to be working well except when I try to export the products and really starting to get aggravated. I am setting up a store to where I am selling products at Retail priced and setting up a store for wholesale (same products, categories, description, etc. when I try to export the products from the Retail store and it asks if I want to open or Save I have tried both and this is what is showing in the products.csv file -
{"error": "/get/data/product.csv: No query given."}

Now I have tried to select various different Filters when I am looking at the Export Selected Records box and keep getting the same thing.

Help would be greatly appreciated as I NEED this feature as the Retail store will have over 1,000+ Products that I will need to import into the wholesale site.

Thanks much in advance.
Are you still having this problem? I know that some hosting services have unusual rules about parameter transmission, and I'm wondering if that might be the issue. Please do drop us a note via our website if we can help.

Hello,

I have a customer who wants the available quantity on his 11,600 products updated regularly from a data feed supplied by the supplier. At first glance I thought this would do that. In looking at the documentation and watching the videos I am not sure this is a part of what Apsona does. The feed is constructed as a url that returns an xml file that looks something like this depending on the query.

And goes on for (in this case about 1000 records)

The contents of this file are url dependent as to what gets returned.

He wants to pull the update several times a day automatically.

Is this something Apsona does? or should I be looking at some other thing?