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

Quote:

---

Originally Posted by KeystoneAirsoft

Hi all,
Ok I have this installed on a Zen 1.3.9h and everything seems to be working well except when I try to export the products and really starting to get aggravated. I am setting up a store to where I am selling products at Retail priced and setting up a store for wholesale (same products, categories, description, etc. when I try to export the products from the Retail store and it asks if I want to open or Save I have tried both and this is what is showing in the products.csv file -
{"error": "/get/data/product.csv: No query given."}

Now I have tried to select various different Filters when I am looking at the Export Selected Records box and keep getting the same thing.

Help would be greatly appreciated as I NEED this feature as the Retail store will have over 1,000+ Products that I will need to import into the wholesale site.

Thanks much in advance.

---

Are you still having this problem? I know that some hosting services have unusual rules about parameter transmission, and I'm wondering if that might be the issue. Please do drop us a note via our website if we can help.

Hello,

I have a customer who wants the available quantity on his 11,600 products updated regularly from a data feed supplied by the supplier. At first glance I thought this would do that. In looking at the documentation and watching the videos I am not sure this is a part of what Apsona does. The feed is constructed as a url that returns an xml file that looks something like this depending on the query.

<products>
<product cwr_sku="10001" mfg_part_number="1930.3">
<price your_price="900.00"/><description short="ACR RCL-100D REMOTE CONTROL SEARCHLIGHT 12V"/>
</product>

And goes on for (in this case about 1000 records)

The contents of this file are url dependent as to what gets returned.

He wants to pull the update several times a day automatically.

Is this something Apsona does? or should I be looking at some other thing?

Lenpilot - we don't (yet) support automatic data feeds or XML. At the moment, ShopAdmin is a purely interactive browser-based system.

Regards.

No problem,

I actually spent the last two days writing a script to do this and I finally have it done. I am grabbing the csv version of their feed parsing it to the Zencart table format and running a "while loop" to throw the results to a preview page. (not needed but it makes the customer feel good) then when he has that warm fuzzy feeling that everything is going to be fine, he clicks the update link. and then: where product model =XXX update Quantity happens. Ultimately spitting out Success for each line updated! Or a whole bunch of nasty fail dialog, (which hasn't happened yet).

I would have liked to put this in cron but it won't let me grab the external feed... Maybe I will put it in as "include quantityupdate.php" (not the real name btw) in the front of the cart. I haven't decided yet.

But thanks for your response.

Len Farneth

I have a fresh copy of Zencart 1.5 installed and tried to install this app
1) nothing shows up under tools that says apsona
2) when i run http://localhost/surplus/apsona_index.php i get a blank screen with a blue header at the top with this in it " ShopAdmin for wils tv " where ever that comes from i have no idea.
3) trying to run any other php file is fruitless.
4) I have e-mailed Apsona and haven't as of yet had a response, guess they are to busy to support their product.

I am figuring this utility doesn't work in V 1.5 or has somebody been able to get this to work ?
Thank you

If it hasn't been upgraded to use the new v1.5 admin menu system then it won't show in the menu.
There are several support threads discussing the change, which developers can use for updating their mods.

Thanks DrByte
There is such a massive amount of topics, pages to go through it's almost impossible to find, would actually be nice if the forum was broken up into smaller chunks with more specific topics. I'm not complaining because there is a lot of information here, just a thought
:)
P.S
Would be nice if Apsona were that fast to respond LOL

LOL - the forum was separated into about 80 different sections at one point, and everyone complained that they had no idea where to look for something let alone where to post, so it was consolidated into fewer broader categories. :)

If you're not into developing mods, then the programming instructions for that probably won't be all that useful to you.

Hello all,

I have read all the Topics and I can't find information about:

- I would like to import and export products in two languages but I can't find how to do it.

Can anyone help me?

Congratulations to Apsona for this beautifull program ;)

Regards
João Raposo

I assume you have already added the second language to your shop.

In Apsona, choose english, export the products with the fields you want.
In Apsona, change to the second language, export the products with the fields you want to a second csv.

Open the first csv with Openoffice to ensure you use the correct character set.
Save it in the Openoffice format. Save the file, now that's your working copy.
Open the second csv and copy the columns into this OO file..

Now you can arrange everything as you like using the common ID, model number as reference but with the language-dependent columns for name, description, meta tags etc.
You can rename the columns as you like as you can map them to the correct database fields during the import.

When you are ready to import, save the file as csv again.
In Apsona, choose english, import the csv. It will probably map the columns correctly but you can check them.
In Apsona, choose the second language, import the csv. You will probably have to map the fields manually for the id and the second language columns.

No doubt you will get errors flagged on the way but they are self-explanatory and anyway you wont be doing this on a live database will you!!!
regards
Steve

P.S. They are looking at 1.5 compatibility at the moment.