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

Hey kman55,
I'm not seeing doubles. I did only look at a few categories, and I didn't blush LOL
If you could tell me which ocategories you are having a problem with, I'll look again.
My store has over 7,000 products & I don't run into too many issues with Apsona ShopAdmin
The first upload of your products is always the one that will cause you a headache.

I can take a guess at what the issue may be:
Are you listing some of your products in two or more categories?
Like product A, a "25w light-bulb" is in Category B "lighting" and Category C "light-bulbs" ?
That will cause a HUGE headache if your spreadsheet doesn't have the categories properly formatted.
Here is how it has to be on your spreadsheet:
Master category is the MAIN category for your product. A product can have only ONE Master category.
Category is where you'll again list the Master category, but also list any other categories you want that product to be in.
I attached a photo example from my spread sheet so you can see what I am talking about. (Visuals help greatly! LOL )
( I run a Pagan store, so I hope YOU aren't offended :D )
Do you see how my first product has 2 categories listed, and ONE Master Category?
The two "categories" listed must be within the same cell, but on different lines.
And you must use the following format for categories:
Top category, colon, space, sub-category.
Categories and sub categories must be separated by a colon, then space.
Like this:
Jewelry: Pendants & Charms
Jewelry: Pentagrams/Pentacles

Hope this is what you were looking for & I didn't confuse you more than you already were.
If you need more answers, I'll do my best to help.
Good Luck,
Kathleen

Hi everyone,

I've been having issues importing products through Apsona. Some days I can import 1000 products, other days I can't import any. I receive these error messages:

The server is not responding..

System progress bar is not responding, see if other component is using it..

I use Google chrome. I have tried in Firefox with no luck either. I have contacted Apsona and haven't heard back. Some people say it is a server issue on my host's side, some say it's a timeout issue. I currently have about 6000 products on my site. I have imported products correctly. I use a shared hosting plan. I have contacted my web host but they don't see anything wrong. Do you think it's because I have a shared plan and require more processor usage? Do you think it's my ISP? Does my web host just suck with Apsona? Would Apsona work better with a dedicated server? or even semi-dedicated? I just don't want to dump a bunch of money on a dedicated server and then find out Apsona still won't work.

Does anyone know a good web hosting company who works well with Apsona?

Many thanks,

Carrie

Valentine88:

Does anyone know a good web hosting company who works well with Apsona?

I have over 10,000 skus on my site and have not had that problem. I don't import many products any more, but I do update pricing on all of my products weekly.

I use GoDaddy and have been pleased. I know that there are cheaper sites, but their customer service is excellent. You can even find people there who know zencart.

SPembleton:

I have over 10,000 skus on my site and have not had that problem. I don't import many products any more, but I do update pricing on all of my products weekly.

I use GoDaddy and have been pleased. I know that there are cheaper sites, but their customer service is excellent. You can even find people there who know zencart.

Thanks for replying so quickly!
Would spending the extra money and buying a dedicated or semi-dedicated solve my Apsona problems? Or can I go with the regular web hosting Ultimate package and have no issues using Apsona?

Suggest you test your site on a faster host. A real test would give you more accurate information than hundreds of varying opinions.

DrByte:

Suggest you test your site on a faster host. A real test would give you more accurate information than hundreds of varying opinions.

Who in your opinion is a "faster host".........? :p

I see your point, but I would much rather hear other people's opinions before spending more money (guaranteed or not) and time "testing" on numerous sites. I have switched hosts before and would like some input or direction before I switch again.

I'm sure there is someone out there who has had similar experiences and can point me in a good direction.

If not more opinions on a web hosting company in particular, how about opinions on what I should look for in a host..? Such as CPU access, bandwith, disk space, limits, and pretty much the minimum on anything that would affect Apsona. My host has said that Apsona may be timing out because the process is taking too long. So what should I look for in a new host so that this does not happen?

I'm sorry if I'm annoying, I'm new to web hosting and all that... I just don't want to dump more money and get screwed :/

Hi,
I would need to upload in a bulk way some credit for the customers using gift cards. We're doing that straight to the database now but would be great to use Apsona for that. We would need only a csv with the table "coupon_gv_customer" with the fields "customer id" and "amount".
Thanks for replying!

rufusclc:

Thanx Apsona for the answer to part 2 of my questions,
any chance of in the near future doing something with the products_discount_quantity file?
RufusCLC

What is the situation of this one? Price Sorter information gets exported and imported but doesn't show the special prices in the shop (unless manually imposed from the admin).
With the Easy Populate you can do this very easily though, so is there a problem with this here or...?

Has anyone tried this with the multi site mod??:lookaroun

I love Apsona ShopAdmin! It is really handy for importing. I am having one problem though and I hope someone can help out. From what I have tested so far, it seems that I can't change my product name and if I do it will create a new entry instead of updating?

Let's say, the original product is called "A"
I want to call it "A small" and since I have to take out "Product ID" (or else it won't import) it will create a new entry called "A small" instead of updating my "A"

So my conclusion from this is that I can probably update descriptions/prices and such as long as the Name is the same right? If I change the name, then it adds new item instead of updating it.

since I have to take out "Product ID" (or else it won't import)

eh? Thats not right. You can change absolutely everything about a product and import it but it has to reference something on the import to identify the record. That can be ID, name or model.

Sounds like you are choosing "import new records" instead of "update existing records".

Great MOD !!

I am having difficulty impoting options from a csv file. Here is what I have in the CSV```
[TABLE="width: 549"]
[TR]
[TD]v_products_model[/TD]
[TD]v_products_options_type[/TD]
[TD]v_products_options_name_1[/TD]
[TD]v_products_options_values_name_1[/TD]
[/TR]
[TR]
[TD="align: right"]1601[/TD]
[TD="align: right"]0[/TD]
[TD]Color[/TD]
[TD]Black,White
[/TD]
[/TR]
[TR]
[TD="align: right"]1606[/TD]
[TD="align: right"]0[/TD]
[TD]Color[/TD]
[TD]Black,White
[/TD]
[/TR]
[TR]
[TD="align: right"]1710[/TD]
[TD="align: right"]0[/TD]
[TD]Color[/TD]
[TD]Black,Red[/TD]
[/TR]
[TR]
[TD="align: right"]1733[/TD]
[TD="align: right"]0[/TD]
[TD]Color[/TD]
[TD]Yellow, Orange
[/TD]
[/TR]
[TR]
[TD="align: right"]1739[/TD]
[TD="align: right"]0[/TD]
[TD]Color[/TD]
[TD]Black,Red,White[/TD]
[/TR]
[TR]
[TD="align: right"]1742[/TD]
[TD="align: right"]0[/TD]
[TD]Color[/TD]
[TD]Black,Red,White[/TD]
[/TR]
[TR]
[TD="align: right"]1757[/TD]
[TD="align: right"]0[/TD]
[TD]Color[/TD]
[TD]Red,White,Baby Pink[/TD]
[/TR]
[TR]
[TD="align: right"]8549[/TD]
[TD="align: right"]0[/TD]
[TD]Size[/TD]
[TD]One Size[/TD]
[/TR]
[/TABLE]

And I am get this following Error ```
[TABLE="class: sf-import-step2-errors-table"]
[TR]
[TD="class: sf-pseudolink number, align: right"]1[/TD]
[TD="class: sf-pseudolink number, align: right"]4[/TD]
[TD="class: sf-import-step2-ermsg sf-pseudolink"]Black,White does not match any existing value in the products_options_values table.
[/TD]
[/TR]
[TR]
[TD="class: sf-pseudolink number, align: right"]2[/TD]
[TD="class: sf-pseudolink number, align: right"]4[/TD]
[TD="class: sf-import-step2-ermsg sf-pseudolink"]Black,White does not match any existing value in the products_options_values table.
[/TD]
[/TR]
[TR]
[TD="class: sf-pseudolink number, align: right"]3[/TD]
[TD="class: sf-pseudolink number, align: right"]4[/TD]
[TD="class: sf-import-step2-ermsg sf-pseudolink"]Black,Red does not match any existing value in the products_options_values table.[/TD]
[/TR]
[TR]
[TD="class: sf-pseudolink number, align: right"]4
[/TD]
[TD="class: sf-pseudolink number, align: right"]4[/TD]
[TD="class: sf-import-step2-ermsg sf-pseudolink"]Yellow,Orange does not match any existing value in the products_options_values table.
[/TD]
[/TR]
[TR]
[TD="class: sf-pseudolink number, align: right"]5[/TD]
[TD="class: sf-pseudolink number, align: right"]4[/TD]
[TD="class: sf-import-step2-ermsg sf-pseudolink"]Black,Red,White does not match any existing value in the products_options_values table.[/TD]
[/TR]
[TR]
[TD="class: sf-pseudolink number, align: right"]6[/TD]
[TD="class: sf-pseudolink number, align: right"]4[/TD]
[TD="class: sf-import-step2-ermsg sf-pseudolink"]Black,Red,White does not match any existing value in the products_options_values table.[/TD]
[/TR]
[TR]
[TD="class: sf-pseudolink number, align: right"]7[/TD]
[TD="class: sf-pseudolink number, align: right"]4[/TD]
[TD="class: sf-import-step2-ermsg sf-pseudolink"]Red,White,Baby Pink does not match any existing value in the products_options_values table.[/TD]
[/TR]
[TR]
[TD="class: sf-pseudolink number, align: right"]13[/TD]
[TD="class: sf-pseudolink number, align: right"]4[/TD]
[TD="class: sf-import-step2-ermsg sf-pseudolink"]Black,Red,White does not match any existing value in the products_options_values table.[/TD]
[/TR]
[TR]
[TD="class: sf-pseudolink number, align: right"]16[/TD]
[TD="class: sf-pseudolink number, align: right"]4[/TD]
[TD="class: sf-import-step2-ermsg sf-pseudolink"]Black,Red,Purple does not match any existing value in the products_options_values table.[/TD]
[/TR]
[TR]
[TD="class: sf-pseudolink number, align: right"]17[/TD]
[TD="class: sf-pseudolink number, align: right"]4[/TD]
[TD="class: sf-import-step2-ermsg sf-pseudolink"]Black,Red does not match any existing value in the products_options_values table.[/TD]
[/TR]
[TR]
[TD="class: sf-pseudolink number, align: right"]18[/TD]
[TD="class: sf-pseudolink number, align: right"]4[/TD]
[TD="class: sf-import-step2-ermsg sf-pseudolink"]Black,Red,White does not match any existing value in the products_options_values table.[/TD]
[/TR]
[TR]
[TD="class: sf-pseudolink number, align: right"]19[/TD]
[TD="class: sf-pseudolink number, align: right"]4[/TD]
[TD="class: sf-import-step2-ermsg sf-pseudolink"]Black,Red does not match any existing value in the products_options_values table.[/TD]
[/TR]
[TR]
[TD="class: sf-pseudolink number, align: right"]20[/TD]
[TD="class: sf-pseudolink number, align: right"]4[/TD]
[TD="class: sf-import-step2-ermsg sf-pseudolink"]Black,Red does not match any existing value in the products_options_values table.[/TD]
[/TR]
[TR]
[TD="class: sf-pseudolink number, align: right"]23[/TD]
[TD="class: sf-pseudolink number, align: right"]4[/TD]
[TD="class: sf-import-step2-ermsg sf-pseudolink"]Black,Neon Pink does not match any existing value in the products_options_values table.[/TD]
[/TR]
[TR]
[TD="class: sf-pseudolink number, align: right"]24[/TD]
[TD="class: sf-pseudolink number, align: right"]4[/TD]
[TD="class: sf-import-step2-ermsg sf-pseudolink"]Black/Pink,White/Red does not match any existing value in the products_options_values table.[/TD]
[/TR]
[TR]
[TD="class: sf-pseudolink number, align: right"]27[/TD]
[TD="class: sf-pseudolink number, align: right"]4[/TD]
[TD="class: sf-import-step2-ermsg sf-pseudolink"]BLK/BLK does not match any existing value in the products_options_values table.
[/TD]
[/TR]
[TR]
[TD="class: sf-pseudolink number, align: right"]28[/TD]
[TD="class: sf-pseudolink number, align: right"]4[/TD]
[TD="class: sf-import-step2-ermsg sf-pseudolink"]Black,Pink,White does not match any existing value in the products_options_values table.[/TD]
[/TR]
[TR]
[TD="class: sf-pseudolink number, align: right"]29[/TD]
[TD="class: sf-pseudolink number, align: right"]4[/TD]
[TD="class: sf-import-step2-ermsg sf-pseudolink"]Black,Red does not match any existing value in the products_options_values table.[/TD]
[/TR]
[TR]
[TD="class: sf-pseudolink number, align: right"]30[/TD]
[TD="class: sf-pseudolink number, align: right"]4[/TD]
[TD="class: sf-import-step2-ermsg sf-pseudolink"]Black,White does not match any existing value in the products_options_values table.[/TD]
[/TR]
[/TABLE]

When Importing, I am going to Product Attributes>Import

I imported "v_products_model = Product: Model", "v_products_options_type= Do Not Import", "v_products_options_name_1=Option", and "v_products_options_values_name_1= Option: Value"

What am I doing wrong?

Thanks
Robin

robin339:

Great MOD !!

I am having difficulty impoting options from a csv file. Here is what I have in the CSV[CODE][TABLE="width: 549"]

When Importing, I am going to Product Attributes>Import

I imported "v_products_model = Product: Model", "v_products_options_type= Do Not Import", "v_products_options_name_1=Option", and "v_products_options_values_name_1= Option: Value"

What am I doing wrong?

Thanks
Robin

Hi Robin,

You may have already solved this by now!!

I believe the error is telling you that you haven't created these products_options_values in Zen Cart yet. You need to create these colour combinations in Zen first and then you can import your file to apply them to your specific products_models.

kcb410:

Hi Robin,

You may have already solved this by now!!

I believe the error is telling you that you haven't created these products_options_values in Zen Cart yet. You need to create these colour combinations in Zen first and then you can import your file to apply them to your specific products_models.

Actually, I have not solved it yet.
I do have these options created in Zen Cart already.
Do I need to use the option ID # instead of the names?
Thanks

robin339:

Actually, I have not solved it yet.
I do have these options created in Zen Cart already.
Do I need to use the option ID # instead of the names?
Thanks

Are some of your option values being accepted and others are not or are they all being rejected?

Are you typing these values in your spreadsheet or are you exporting them from Apsona and then adapting them for your products?

You'll want to compare the option values in your spreadsheet to your Zen Cart option values. If they're not identical they won't be found during validation. Even an extra space in the value would mean it wouldn't be recognized.

I've just tried to install this on v1.5 with the original files and the update for 1.5 but when I try to access my Apsona ShopAdmin through my zencart admin it just takes me to the 404 page.

I'm not sure what I've done wrong but all the files seem to be in the right place. I also get the link under tools to the Apsona ShopAdmin page.

The configure.php in the admin doesn't have any trailing slashes where there should be and I tried setting up a new admin profile with privileges for this but it doesn't make a difference.

Any ideas?

Don't worry, I deleted all the files and installed them again, seems to be working now

Hello Everyone,

I started using Apsona recently (Great mod guys!) and have noticed that sometimes when attempting to import changes to the database via Apsona it gets stuck on 'working' or is extremely slow to process anything. Is this a common problem with the interaction with the Apsona server or would it be something on my end? I was wondering if there are peak periods on their server I should avoid.

Side question......What is Apsona's business model? They don't seem to sell anything. We all sell something don't we?

Any comments are appreciated thank you.

I was wondering if there are peak periods on their server I should avoid
It doesn't work like that. When you first load up, the latest version of their code, or rather your version of the code if they have done any customisations for you, is downloaded to your machine.
Thereafter any problems you are having are on your side, your transactions don't pass through their servers.

Business model...good question, I think they do custom work.

ellivir:

What is the situation of this one? Price Sorter information gets exported and imported but doesn't show the special prices in the shop (unless manually imposed from the admin).
With the Easy Populate you can do this very easily though, so is there a problem with this here or...?

I'm wondering if the silence means that Apsona people are not able to make the DISCOUNTS working at all. I'm also wondering how it was working with EasyPopulate then. There is no problem with that one. It is just that if you use Apsona to load the products, you should be putting the discounts at the same time since those are in the same spreadsheet.