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

[raybar81]

OK

this is what I have:

Option Name: EP
Option Values:
1year, 2year, 3year, 4year, 5year

Option Prices:
Vary based on product

above is set in ZC - I have added attributes to product, can see here.

I export that in apsona fine

when I try to upload using same cvs layout as the export it wont accept the new products.

Please bear in mind that the matching is exact

If I am using PRODUCT ID, why wouldn't it match that?

[apsona]

I guess I just do not get it, I created a product, gave it option, option value & option price.

Then I tried to import several products using PRODUCT ID

products have a unique ID, I must be doing something wrong. Do I have to assign attributes to products in ZC first. I looked for tutorials and cam up with this but that did not explain much as I did this.

I have allot of products, the only attributes are extra protection, I guess I will look to other solutions.

Two questions:

• Did you watch the video on that page? Was it of any use?
• Any particular reason you can't use the product name instead of the product id for matching? I would think it would be easier to match names, provided of course that your products all have distinct names.

Regards.

[raybar81]

Did you watch the video on that page? Was it of any use?

I did watch video, i checked for mis-spelled words, ect. but as I stated I copied right from export. Only difference is Option Value Price

Any particular reason you can't use the product name instead of the product id for matching? I would think it would be easier to match names, provided of course that your products all have distinct names.

Have you seen my product names, (example: Sony Cyber-Shot DSCTX1/L Digital Camera - 10.2 Megapixel, 4x Optical Zoom, 3.0" LCD, 11MB Internal Memory, USB Slot, HD Movie, Blue ) Why I choose PRODUCT ID

[apsona]

raybar81 - you are correct, there is an issue with updates by product id. Now looking back at the logs, I see that we used to support lookups by ID as well as by name, but that was leading to some rather hard-to-find errors because people were using them interchangeably. Obviously we did not fully resolve this issue.

We'll put this on our list of upcoming bug fixes, but in the meantime, I'm afraid it can only do lookups by product name. We'll definitely post a note here when this bug is fixed.

Apologies for the miscommunication and the inconvenience.

Regards.

[kelvyn]

Hi there Apsona. I've got a suggestion for a future update:

Edit orders! I hate over-writing core code like the current add-ons make you do, and it would be really good if you could apply your product editing easiness to editing customer orders (like by price, quantity, tax rate etc), but also notifying the customer like it currently does.

That would be good!

[Javier]

Hi again,

Any chance of getting an extra field added to the "Orders" table in ShopAdmin, to show "Purchase Order ". I have an additional field in the orders table of the database "po_number" (string data type). I do not need auto detect of fields. This would enable me to run a lot of reports. The PO is a customer supplied reference. Many thanks.

Javier

[harlyman]

Hello again

Apsona is working great, but now we found a litle problem we hope you have a solution to, and its this: when we export new pending orders, we are not able to import them into our accounts system because we do not know what the customer has in its order, is it possible to get the products lines as well as the other info? the model name and net price is all we need as well as what you allready have in there.

Is this possible?

Regards

[apsona]

now we found a litle problem we hope you have a solution to, and its this: when we export new pending orders, we are not able to import them into our accounts system because we do not know what the customer has in its order, is it possible to get the products lines as well as the other info? the model name and net price is all we need as well as what you allready have in there.

Is this possible?

Perhaps I don't fully understand your question, but it seems to me that you can create an ordered-products report with all the fields and filters you need, run it and export it. You can filter the report by the "Pending" flag on orders, and you can add fields into it from the order record, the ordered products record and the products record.

Does that help?

Regards.

[rufusclc]

I have been trying, through this program, to access the products_discount_quantity file so I can export, to make changes and import back, without any luck.
With my limited knowledge, can't seem to find the file in Apsona.
Help please?
Rufusclc

[rufusclc]

Another quickie question:
I would like to export from the products file the products_discount_type filed together with the product ID.
I get the product ID but I don't see the other field noted in the export options box.
help
Rufusclc