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

The more I work with Apsona the more I am loving it! Took me a while to wrap my head around it - but it is making sense now!

I do have a question on the export feature.....I have a client that needs a very specific file that includes ALL of the information for an order - basically it needs to look like this...where it is showing each specific option chosen, name, email etc...

Can this be done? I see you can export for various areas - but is there an option to export ALL details of an order? Thanks!

62,16142,"SKU1112345514840","SunCover 4000 10-0 Projection","Width Feet: 11, Fabric: Silverstone Spruce 71757, Frame Color: White, Hood: No, Operation: Manual Crank, Drive Side: Left, Mounting Method: Wall, Valance Style: Wave, Valance Braid: Best Match, Crank: 5-11 for over 8 feet high","1538.000",1,"theodorouconstruction","1538.000","0.000",,"0.000",0,,,"0.00 0","0.000","10-08-2009 09:39:15","C","Credit Card (AuthorizeNet: AIM)","N",,"Larry from DIY setting this up for Mike","--- Advanced info --- Reason: Approved: Approval Code: 094133; Transaction ID: 2555574988 AVS info: Address (Street) and 5 digit ZIP match CVV info: Match",,"Mr.","Mike","Construction","Theodorou Construction",,"Mike","Construction","19 Locust Ave",,"Westmont","NJ","US",08108,"Mr.","Mike","Construction","19 Locust Ave",,"Westmont","NJ","US",08108,"609.458.0235",,,"theodorouconstruction######## ##############"

jill8026 - glad you like it. We appreciate the feedback.

If you wish to export data records whose fields are all drawn from the Orders table, you can simply export from the Orders tab, via Tools - Export.

But it sounds like you want to create an export that contains some fields from the Orders table, some from the Customers table and some from the Ordered products table. If that's your goal, you can create a report in the Orders tab that contains the fields you want, run it, and export the results. Our website's support area contains examples of how to do this.

Please get in touch with us via email if you want more details.

Regards.
Apsona

I just installed Apsona and I had to write and say THANK YOU! I'm using it with ZC 1.3.9f without issue(so far). I'm hosted with GoDaddy, which I mention because someone posted that they had problems that they thought were GoDaddy issues. I was stupid and tried IE first, but switching to Firefox worked like a charm. You saved me an hour just tonight as I wanted to reprice a bunch of commonly priced products which was sheer torture in the ZenCart admin, but a piece of cake in Apsona.

Thanks again for a great app.

Bill

Thank YOU for making this amazing product!
We have an inventory of 45k + items, and have for weeks now been trying to build an import script or use another pre built method to do the work.
Within 6 hours of signing up, and using the product, I was able to get the job done AND prepped for repeat processes.
This was NO small feat for us.
The UI is intuitive, easy to follow. As well are you instructions on how to use it. The directions for each applicable use of the application are veritably flawless.
You guys have done an amazing job! Thank you sooooo much!!

Billy R Baldwin
ZC version 1.3.9e
Senior Developer
Johnsen's Wholesale Florist
http://johnsenflorist.com
:clap::bigups:

Lately (last 3 or 4 days) 4 separate sites when in the Apsona admin frequently (about every minute) display a popup message advising "The server is not responding. Please check your network connection. Status:timeout".

jetx - thanks for this note. This is because we had put in a per-request server timeout of 30 seconds, because we had observed some odd anomalies with imports. But I guess some hosts take even longer than that to respond. We've changed the limit to 2 minutes now. Hopefully that will mitigate the problem.

Thanks again. Please do keep us posted if you run into any glitches.

Regards.
Apsona

Great! Thanks for the adjustment, appears to work fine now.

We were in the same boat as numpy, a huge inventory 50k + parts and were really dreading adding them in through other channels.

Lucky for me, I found this wonderful piece of software. Not only does it handle products, but categories as well, and when you have as many of those as we do, it's a real time saver.

Best of all, it's really intuitive and easy to use.

Would definitely recommend anybody that hasn't given this software a try, to do so, I can't imagine how you would be displeased with it.

I have exported products and product attributers from one aspona zencart site and i'm trying to import them into another zencart site which also has aspona installed.

My problem is that i can't work out how to create new entries in the database table.

On all the attributes i am trying to import i get the following error as an example:

"select size does not match any existing values in the products_options_values table."

How do i allow it to import and create the new attribute value?

Quote:

---

Originally Posted by DVDTitan

I have exported products and product attributers from one aspona zencart site and i'm trying to import them into another zencart site which also has aspona installed.

My problem is that i can't work out how to create new entries in the database table.

On all the attributes i am trying to import i get the following error as an example:

"select size does not match any existing values in the products_options_values table."

How do i allow it to import and create the new attribute value?

---

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