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

[gazag]

Has anyone tried this with the multi site mod??

[Miku]

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.

[torvista]

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".

[robin339]

Great MOD !!

I am having difficulty impoting options from a csv file. Here is what I have in the CSV

v_products_model
v_products_options_type
v_products_options_name_1
v_products_options_values_name_1

1601
0
Color
Black,White

1606
0
Color
Black,White

1710
0
Color
Black,Red

1733
0
Color
Yellow, Orange

1739
0
Color
Black,Red,White

1742
0
Color
Black,Red,White

1757
0
Color
Red,White,Baby Pink

8549
0
Size
One Size

And I am get this following Error

1
4
Black,White does not match any existing value in the products_options_values table.

2
4
Black,White does not match any existing value in the products_options_values table.

3
4
Black,Red does not match any existing value in the products_options_values table.

4
4
Yellow,Orange does not match any existing value in the products_options_values table.

5
4
Black,Red,White does not match any existing value in the products_options_values table.

6
4
Black,Red,White does not match any existing value in the products_options_values table.

7
4
Red,White,Baby Pink does not match any existing value in the products_options_values table.

13
4
Black,Red,White does not match any existing value in the products_options_values table.

16
4
Black,Red,Purple does not match any existing value in the products_options_values table.

17
4
Black,Red does not match any existing value in the products_options_values table.

18
4
Black,Red,White does not match any existing value in the products_options_values table.

19
4
Black,Red does not match any existing value in the products_options_values table.

20
4
Black,Red does not match any existing value in the products_options_values table.

23
4
Black,Neon Pink does not match any existing value in the products_options_values table.

24
4
Black/Pink,White/Red does not match any existing value in the products_options_values table.

27
4
BLK/BLK does not match any existing value in the products_options_values table.

28
4
Black,Pink,White does not match any existing value in the products_options_values table.

29
4
Black,Red does not match any existing value in the products_options_values table.

30
4
Black,White does not match any existing value in the products_options_values 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

[kcb410]

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.

[robin339]

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

[kcb410]

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.

[kezan98]

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?

[kezan98]

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

[kcb410]

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.