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

[Paul69]

I dont see how a virtual instance would make any difference. The max memory setting could be an issue try using phpmyadmin and export the products table. In my case the products table was the largest with the product descriptions taking the most space. Apsona will only pull from one table at a time from what I can remember so I guess I dont understand why a complete export would not work through phpmyadmin. Now importing is completely different but at least it would be a start. The only issues I could remember having had to do with uploads not downloads.

[Limitless]

Are you on a shared host? I am talking about a VPS it should be a way to do it ... Without splitting the files ...

With my VPS (2GB), I have to split all exports into 5k product 'chunks' via a loop.

Not only does execution time come into play, but memory exhaustion as well.



I stopped using Apsona as it doesn't seem to handle 75k products very well.

[icecold]

With my VPS (2GB), I have to split all exports into 5k product 'chunks' via a loop.

Not only does execution time come into play, but memory exhaustion as well.



I stopped using Apsona as it doesn't seem to handle 75k products very well.

And what you use instead?
For me it has been really useful for simple daily product stock updates ...

[Limitless]

And what you use instead?
For me it has been really useful for simple daily product stock updates ...

I wrote scripts (wget and sql code) that does my imports via cron jobs.

[torvista]

Hi,
using Apsona on a local Xampp install I have found that
it works on xamp 1.80 using php 5.4.4
it does not load completely on xampp 1.81 using php 5.4.7.

No error log messages of use.

Is anyone else using Apsona on a php 5.4.7 (windows?) server?

[SeaJay]

I am using Apsona with Zecart 1.5.0 and am running in to a couple problems. First, how do you use Apsona to update inventory lists across a category? A mass change is easy enough, but I if I have 50 different products in a category, and want to update them all to reflect their individual quanitity in stock, how do I do this? I thought I could just update the number on my spreadsheet, import the csv file and create/update, but that seems to remove the file from the storefront, but it's still in my database, I just can't see it. This is evident because Apsona gives me a warning that the data is already in the database when I try to reload it. I then go back to Zencart, delete the category and everything in it, and all of my associated images disappear from my images folder.

Second, is it possible to make a "Discount" or Special Pricing" column on a csv file to upload via Apsona? If not, is there a way to update the info so the special pricing I make in Zencart doesn't disappear?

I know I'm doing something wrong here. Any help would be most appreciated.

[torvista]

I thought I could just update the number on my spreadsheet, import the csv file and create/update, but that seems to remove the file from the storefront,

Yes. It should update only the fields you are importing. If it is removing them, it must be either changing the enabled field to 0 or changing the category and/or master category.

A mass change is easy enough, but I if I have 50 different products in a category, and want to update them all to reflect their individual quanitity in stock,

I don't understand the distinction between these two cases.
An update of any product field is based on the id or unique model number, doesn't matter "where" they are.
Are you saying the group of products you want to update is just those in one particular category?

Second, is it possible to make a "Discount" or Special Pricing" column on a csv file to upload via Apsona

You have have any column you like in the spreadsheet. Apsona will not choke on it: it will just map the columns to field names it recognises, the others you can choose to map from the drop-down selector above the field, or not and they are ignored on the import.
I have an enormous spreadsheet for product control, most of which Apsona import can ignore with no problem.

If you can't map to where you want, contact Apsona, I think they can customise the code you download for you only.

[SeaJay]

Yes. It should update only the fields you are importing. If it is removing them, it must be either changing the enabled field to 0 or changing the category and/or master category.


I don't understand the distinction between these two cases.
An update of any product field is based on the id or unique model number, doesn't matter "where" they are.
Are you saying the group of products you want to update is just those in one particular category?


You have have any column you like in the spreadsheet. Apsona will not choke on it: it will just map the columns to field names it recognises, the others you can choose to map from the drop-down selector above the field, or not and they are ignored on the import.
I have an enormous spreadsheet for product control, most of which Apsona import can ignore with no problem.

If you can't map to where you want, contact Apsona, I think they can customise the code you download for you only.

Thank you for the guidance. I exported the data after my last three attempts at updating the data and the Category column returns blank. In other words, I import the data with a Category Column properly assigned and filled out. The data show up in my store. Next I update my CSV file to reflect new Quantity in Stock number, copy the CSV file (including the Category) to the the Apsona Shop Admin Import/Update field, get all the verify all the columns are there and select update. Everything seems to work ok, but all the items in the category I am updating disappears from my store. I export the file using the filter feature and find that everything...including the Enable column is there, and the Category column is there too...but all category name is missing from every line. What am I doing wrong?

[niccol]

How large a store have people managed to use this with.

I am a fan normally but have had bad experiences recently with two large stores. One for example is like this:

products : 50000
orders : 300000

What happens is that apsona starts but in starting sets running some crazy large queries that ultimately crash the db server. Now this is not a weak little shared hosting server.

anyone run with this kind of load successfully?

[torvista]

@Seajay
For a product to show up in the shop it needs to have a master category assigned to it and also belong to least one category...which should be the master category too.
So an import of a new product needs both those fields to exist.

If your export shows the category column to be blank, then thats the problem.

If you add a new product from the admin, check it shows up in the shop, export it, change one field (stock for example) and import it..does it disappear?