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

apsona:

It seems as if you haven't set up the products_options_values table - you will need that before you can import product attributes. One possibility is to export the product options and product option values tables using ShopAdmin and import them into your new cart. After doing this, you should be able to import your product attributes into your new cart.

Hope this helps.
Apsona

Hi

Thanks for this but there are already attributes set up and applied to products in the new store.

I was hoping Apsona would create the new options name and options values as it imported.

Is this possible?

DVDTitan - we don't yet have a way to create product options and values while importing attributes, so at the moment, ShopAdmin only supports importing (or setting up) options and values ahead of the attribute imports. We will look into what it takes to support this feature.

Thanks for the feedback, and best regards.

Apsona

I followed the instruction to install the addon and after clicking the apsona shopadmin under the tools tab, there is a page shows up with error message on it.

"Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

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

my zen cart version is 1.3.8 and php version is 5.2.14.

Please help.

thank you.

I figured out . After installation the addon , most of those files' permission is 664 which is wrong. I don't know why but had to manually change them to 644 to work! My hosting company is justhost.com. My zen cart version is 1.3.8 and my php version is 5.2.14.

I have apsona installed but I am having a problem with importing files. I am using the Zencart product finder addon and I am having trouble trying to match the file structure.

I have a master category (ID used for it is *) with three **sub **categories, Make Model and Year.

Off of the sub categories I have sub-sub categories that represent the make, ie ford ,chev, model, ie taurus, ranger, year, ie 1990, 1991 etc.

How do I create a table structure to match the above.?

jerr

PS. See the image/diagram I have posted at the following thread
http://www.zen-cart.com/forum/showthread.php?t=161143&page=6

They're still just categories with sub-categories. So, treat them as you would any other parent category or sub-category or sub-sub category.

Jerr:

I have apsona installed but I am having a problem with importing files. I am using the Zencart product finder addon and I am having trouble trying to match the file structure.

I have a master category (ID used for it is *) with three **sub **categories, Make Model and Year.

Off of the sub categories I have sub-sub categories that represent the make, ie ford ,chev, model, ie taurus, ranger, year, ie 1990, 1991 etc.

How do I create a table structure to match the above.?

jerr

PS. See the image/diagram I have posted at the following thread
http://www.zen-cart.com/forum/showthread.php?t=161143&page=6

If your question is asking how to set up the CSV file for importing products and categories via ShopAdmin, I would suggest looking in the support area of the Apsona website. There are several pages and videos that address this very issue.

If I have misunderstood your question, though, please clarify.

Regards.
Apsona

I'm having a problem all of a sudden in Firefox. When I start Apsona from the tools menu it presents the login box for my admin id in a new window. It does this in Firefox and Chrome. Safari takes me directly to the Apsona window without additional login. When I login on Firefox it just keeps giving me the login window. On Chrome after the second login it presents the Apsona window. I am unable to use Apsona in Firefox. Any idea what's going on? I've cleared cookies, cache, restarted firefox, and rebooted the PC.

Hello Apsona,

I am looking at your product and all the positive comments "Well Done and Thank You" for with your add on for ZC.
From a security aspect, we ask why does Apsona need to communicate with your server when the connection and operation is between a PC and a ZC site.
We used a number of commercial add on's and have completely removed them except for one due the commercial add on's constantly communicating with the software developers servers. I realize they do this from a commercial aspect of ensuring their software is protected and being used correctly.
With the level of security issues and liabilities circulating your reply would be appreciated.

Regards
Dave

ozprodrivers:

Hello Apsona,

I am looking at your product and all the positive comments "Well Done and Thank You" for with your add on for ZC.
From a security aspect, we ask why does Apsona need to communicate with your server when the connection and operation is between a PC and a ZC site.
We used a number of commercial add on's and have completely removed them except for one due the commercial add on's constantly communicating with the software developers servers. I realize they do this from a commercial aspect of ensuring their software is protected and being used correctly.
With the level of security issues and liabilities circulating your reply would be appreciated.

Regards
Dave
I had the same concern, and am satisfied that it's fine.

It reads the up-to-date app from their server, but does ALL the processing on your PC and your server.
None of your store data is transferred back to them. Their server is only involved insomuch as delivering the ajax application to your browser. That's it.

Their privacy policy is on their website, as well as FAQ articles explaining their SAAS model and addressing your security concerns.

Thank You Dr Byte.

After a couple of days of fighting Easy Populate Advanced and ZC 1.3.9h I finally gave up and started searching for someone to pay to try to install it for me. I had done it before but for some reason was having trouble with this version of ZC.

While searching, I came across Apsona ShopAdmin and decided to take a look at it. WOW it was so simple to install, everything goes into one folder and your done. It worked great first time, no problems and looks like it'll be terrific especially for the number of products I will need to upload and take care of. Very simple interface and although I haven't had the chance to try everything in it, I'm very pleased with what it does and the ease of using it.

Thank you, Apsona, for something so easy to use and install.

Jerr:

I have apsona installed but I am having a problem with importing files. I am using the Zencart product finder addon and I am having trouble trying to match the file structure.

I have a master category (ID used for it is *) with three **sub **categories, Make Model and Year.

Off of the sub categories I have sub-sub categories that represent the make, ie ford ,chev, model, ie taurus, ranger, year, ie 1990, 1991 etc.

How do I create a table structure to match the above.?

jerr

PS. See the image/diagram I have posted at the following thread
http://www.zen-cart.com/forum/showthread.php?t=161143&page=6

I'm not sure if you will see this but I did something similar on my site. I used the categories flyout add on and also a mod to kill the links to the sub cats that aren't holding anything. Seems to work but I'd be better off paying someone for this as the original intent isn't quite there. I did upload about 400 categories and subcategories with success and also the products in them. If you'd like more info I may be able to help.

I would like to extend a big thank you to Apsona for fixing an issue that was reported with mass deleting records. The delete process appeared to "hang" at times and caused high CPU usage on the server. I reported this to Apsona and they had it fixed and included in an update the very next day - the process now completes almost instantaneously and the issue is completely resolved!

Your service is stellar, as is your product! THANK YOU, APSONA!

anyone any ideas?

installing this plugin ir ftping files as instructed,

when i click on it in TOOLS I just goto ADMIN logon screen!

Anyone ideas?

juxx:

anyone any ideas?

installing this plugin ir ftping files as instructed,

when i click on it in TOOLS I just goto ADMIN logon screen!

Anyone ideas?
juxx, if you're going to splatter your problems all over multiple discussion threads, at least have the courtesy to come back and post the resolution so others know how you fixed it.
ie: http://www.zen-cart.com/forum/showthread.php?p=966137#post966137

I have to say that Apsona was VERY easy to install and operate. We're not heavy users of all of its features, but it immediately did all of what we needed it to do.

Just a pro-Apsona post...

Zen 1.3.9H
Apsona V1.07

Anybody have any problems importing products with a bug that is taking the product code and substituting it as the product ID? I finally was able to duplicate it so I'm positive that is what is happening...

So my products table has product_ID 3959 and the product model number I'm importing is 3959. It continues to say the products are already in the table when it clearly is not. I enabled the "Update The Database" for duplicates to track it down and successfully altered product ID 3959 now showing 3959 for the model number when none existed and it should have added the product not modified and also should not see a duplicate when the 3959 number is listed in the "Model" column.

Yes the header was NOT prod_ID so this should have never have happened. Can anyone help? I've got over 6K products ready to load and this is causing major problems. The only thing I can think to do (which does work) is renumber the products with letters but that will cause mismatch problems for me.

Paul69 - Thanks for your note. I am able to reproduce the problem. We will have a fix deployed for it within the next day or so.

Sorry for the inconvenience this has caused.

Regards.
Apsona

Well I didn't expect that but let me say, the product is great! There are things I can do that EP could not and I have the pro version which I've used up to this point. This is a nice add on and actually more than just an add on as it really functions virtually all by it self.

I am glad you could reproduce because I've been fighting with it for over a week trying to determine what was causing it and finally figured out what it was doing.

You guys are doing great and I do appreciate it!!! :clap: