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

Most of the time when I update inventory I have MODEL, PRODUCT NAME, and QUANTITY.

Thanks Gary

Torvist and Gary

Thanks. I will check with GoDaddy to see if this is the problem.

Still having some issues trying to get descriptions to show up. I went into my admin/configurations and set the maximum number of characters to 400 which should cover almost everytihng.

When I download my .csv file from my supplier, the description column is good, I deleted the columns they had on there that I didn't need and copied it into Apsona to upload it. I'm still getting shorten descriptions, is there a setting within Apsona that might be cutting them off?

Think I've got the cutoff descriptions figured out, I hope.

Now I've got a problem with Apsona. When I go in and export a file with only the name, model number, quatity in stock, and the description, I save it to the desktop. Then I open it with excel (have tried several ways of opening it) and when it opens, all that is in the description column are # signs and each line appears to have the same number of # signs in it. I click on any of the description cells and they look up in the formula bar where the contents would normally show up, nothing but # signs in there either.

Anyone have any ideas on this?

Thanks for any help,

Jim

RiverCity:

Think I've got the cutoff descriptions figured out, I hope.

Now I've got a problem with Apsona. When I go in and export a file with only the name, model number, quatity in stock, and the description, I save it to the desktop. Then I open it with excel (have tried several ways of opening it) and when it opens, all that is in the description column are # signs and each line appears to have the same number of # signs in it. I click on any of the description cells and they look up in the formula bar where the contents would normally show up, nothing but # signs in there either.

Anyone have any ideas on this?

Thanks for any help,

Jim

Well, I had to do a restore on my database but I got rid of the # symbols in the description column when downloading using Apsona, now that has been corrected. Now to go back and try again to upload full descriptions and hope they work this time and try to get rid of whatever is keeping Google Merchant feed from hanging up. This is getting frustrating but hopefully I'll eventually get it figured out.

Is this a problem with Apsona, possibly a bad install?

I have a clean csv file (checked it line by line), I used Apsona and copied/pasted it into Apsona, checked to update database and uploaded it.

When I check some products, the description showing on the site for several also include numerous other item numbers and their descriptions all in one. The extra item numbers if brought up on their own, do not have a description showing.

I went back to my clean csv that I copied from and those item numbers are showing a correct description. I'm thinking there is a problem or glitch in the way Apsona is uploading them. Has anyone else had this problem or does anyone think it could be a bad Apsona install maybe?

Any help is appreciated, I've written to Apsona but haven't heard back yet so thought I'd also check on here.

Thanks
Jim

RiverCity:

Is this a problem with Apsona, possibly a bad install?

I have a clean csv file (checked it line by line), I used Apsona and copied/pasted it into Apsona, checked to update database and uploaded it.

When I check some products, the description showing on the site for several also include numerous other item numbers and their descriptions all in one. The extra item numbers if brought up on their own, do not have a description showing.

I went back to my clean csv that I copied from and those item numbers are showing a correct description. I'm thinking there is a problem or glitch in the way Apsona is uploading them. Has anyone else had this problem or does anyone think it could be a bad Apsona install maybe?

Any help is appreciated, I've written to Apsona but haven't heard back yet so thought I'd also check on here.

Thanks
Jim

UPDATE:
Think I found the problem or at least it seems to have fixed it for now. I have in the past always saved my spreadsheet to a csv(ms-dos) format to upload to Apsona and it's been good to go. This time for some reason it messed up random description columns so I was reading up on Easy Populate and found a post about having to save it to another format recognized by EP so I thought, what the heck, it's not working the way it is so I saved it first to a text(ms-dos) and that didn't work so I tried text(tab delimited) and it took it. I haven't checked very many items yet but did check the few I had written down as being messed up and they were all in order after this one.

Can anyone familiar with Apsona confirm this was most probably my problem or not so I'll rest tonight? LOL

Thanks
Jim

Since I work with a spanish site and accented characters, I long gave up on the vagaries of excel and only use Libreoffice, as you can tell it what encoding to use when both opening and saving your csv.
I have no problems with Apsona but am only importing about 3k products at most.
Maybe you should try Libreoffice to see if there is something in your text/Excel it doesn't like.

Thanks, I'll take a look at it, I guess in the past I just never noticed the descriptions were cut short, either that or what I was loading for the customer didn't have long descriptions.

Thanks
Jim

I am still struggling with Apsona not updating all of my prices. have contacted GoDaddy, and they showed me how to extend the upload time to well beyond what I need. I have also expanded the file size max upload to well beyond what I need, and there is still no change.

Now I am getting an additional error: Something about the script stopping "Script: http://shopadmin-svc.apsona.com/ec/zencart/apsona-ec.1103152126.min.js:12"

What does this mean?

RiverCity:

Think I've got the cutoff descriptions figured out, I hope.

Now I've got a problem with Apsona. When I go in and export a file with only the name, model number, quatity in stock, and the description, I save it to the desktop. Then I open it with excel (have tried several ways of opening it) and when it opens, all that is in the description column are # signs and each line appears to have the same number of # signs in it. I click on any of the description cells and they look up in the formula bar where the contents would normally show up, nothing but # signs in there either.

Anyone have any ideas on this?

Thanks for any help,

Jim

I hate to throw out the obvious, but are your columns wide enough to display the titles? When word wray is off and there is too much text to display, excel will replace it with ##s

SPembleton:

I hate to throw out the obvious, but are your columns wide enough to display the titles? When word wray is off and there is too much text to display, excel will replace it with ##s

Yep, already checked that, it turned out to be the format I was saving it in an reopening it, think I've got it figured out...at least for this supplier. Fixing to start on my other supplier's datafile and see how it goes.

Jim

SPembleton:

I am still struggling with Apsona not updating all of my prices. have contacted GoDaddy, and they showed me how to extend the upload time to well beyond what I need. I have also expanded the file size max upload to well beyond what I need, and there is still no change.

Now I am getting an additional error: Something about the script stopping "Script: http://shopadmin-svc.apsona.com/ec/zencart/apsona-ec.1103152126.min.js:12"

What does this mean?

Not sure on this, I'm guessing you've already set the permissions on each of the Apsona files. I don't know if a wrong permission would cause it or not. I usually carry around 3000 items and haven't run into a problem updating prices or stock levels. Sorry couldn't be of any help.

Jim

RiverCity:

Not sure on this, I'm guessing you've already set the permissions on each of the Apsona files. I don't know if a wrong permission would cause it or not. I usually carry around 3000 items and haven't run into a problem updating prices or stock levels. Sorry couldn't be of any help.

Jim

Is anyone other than me using this with 10k+ SKUs? Maybe I just hit Apsona's max number.

Is anyone from Apsona still monitoring this thread?

I've sent an email but haven't gotten any response from it either. Is anyone else having this kind of issue. I upload a clean csv file (checked, double checked, and triple checked) but the description for a few items is combined with several others to make one very long description. I have several items that now show up with these faulty descriptions. Also, when I download a copy of the store's database (product.csv), there are several items that are no longer lined up under the correct column heading, it's like each cell entry was moved over one column and not all items have a product id assigned to them.

I'm pretty sure this is a problem within Apsona and it's what is causing my problems with trying to get a good Google Merchant Feed file download.

If there is anyone from Apsona still on here, can you please let me know something? I've used Apsona for several years without any problems but this is really causing problems.

Thanks, if anyone else has any ideas I'm open......

Jim

Anyone know how to delete products in bulk using Apsona? I have over 3400 that I need to delete.

Thanks
Jim

RiverCity:

Anyone know how to delete products in bulk using Apsona? I have over 3400 that I need to delete.

Thanks
Jim

If you can write a filter to select those products, go to Products, top center select the drop down for Filters and select "new filter". A new dialogue box will appear that allows you to define the filter. For any characteristic you use, you can create the filter. Once you select that filter, select the "Search" button at the bottom of the dialogue box, the items that would be selected appear on the left. BE CERTAIN THAT THESE ARE THE ITEMS THAT YOU WANT TO DELETE. Then, under tools, select "Delete all". This cannot be undone, so you may want to back up your database first, or test it out on only 1 of the products or something similar!

SPembleton:

If you can write a filter to select those products, go to Products, top center select the drop down for Filters and select "new filter". A new dialogue box will appear that allows you to define the filter. For any characteristic you use, you can create the filter. Once you select that filter, select the "Search" button at the bottom of the dialogue box, the items that would be selected appear on the left. BE CERTAIN THAT THESE ARE THE ITEMS THAT YOU WANT TO DELETE. Then, under tools, select "Delete all". This cannot be undone, so you may want to back up your database first, or test it out on only 1 of the products or something similar!

That did it, thanks.

Is Apsona support still in this thread?

I tried to contact them because I want to use the software in my testing site, and as it's been too long I forgot my user and password with them, I went to their website and placed a support ticket to no avail. They never replied.