Help - Search - Members - Calendar
Full Version: Stone Edge Issue
MonsterSmallBusiness Forums > MonsterCommerce > MC Plug-ins & Add-ons > Other Integrations
Ptch3456
While we are waiting to get help with the Express Setup (unfortunately, a three week wait), we are attempting to set it up and familiarize ourselves beforehand. However, we are running into some significant and aggravating issues. I'm fairly confident that I'm running into some errors. It appears to be a communication problem.

For starters, the inventory import just REFUSES to import the product options, AKA variants. The title of the variant heading imports, but not the actual options. I have reimported 4 times, choosing different options, with the same result. When playing with the manual order input - the option title doesn't show up at all.

Secondly, we have about 5000 previous orders that need to import. While it says it has connected, it simply freezes. Also, the new orders won't import either. So, we are at a stand-still.

The customer import worked just fine.

I sure hope these are easily explained. It is very frustrating. I HATE computer issues - I just need it to work! blinking.gif I have searched the knowledge base in depth, and cannot find answers for any of this.

Any direction would be appreciated,

rungreen
PTCH,

Have you contacted support? Usually they're pretty helpful. I'm surprised that there is such a long wait, but there is a learning curve there.

What version of MS Access do you have? Is it possible that the database is set up incorrectly, or that your settings are blocking it(network?). The import works simply via a Csv sheet, so i'm surprised there is trouble. For the options, are you using advanced variants? They should be creating a new option in SE automatically.
Jared
Certainly, a call to technical support would probably help you... however, you might check:

System Parameters -> MonsterCommerce -> MonsterCommerceMaxOrderDownload - the default is 200; however, you may try lowering this number (so it downloads smaller quantities of orders at a time).

When running the download, check your NewOrders folder (generally c:\StoneEdge\NewOrders) - are new files being created here? If so, then the program is still downloading orders... (generally, ALL orders are downloaded (in batches determined by the parameter above); once all downloads have been completed, orders are processed)... therefore, it may look like StoneEdge isn't doing anything, but it's just working on downloading all of your orders.

If neither of those suggestions help, call StoneEdge...
superdetail
Have you tried using advanced variants?

I don't think normal variants import correctly.
Ptch3456
Thanks for the replies.

We are using Access 2003.

The current order download is set to only 50 - I'll try lowering it again just for grins. I have also checked the database for orders, and it is completely empty.

As for the variants - we don't use Advanced Variants - only the regular variants - these are what aren't showing up. The title of the option is there, but the actual options that show up in the monstersmile.gif pull-down menus are missing. For example, if we used color options... the "color" heading is visible, but "red,green,blue, etc" are not.

We don't use advanced variants, as these aren't inventory items.

As for a learning curve - absolutely. I like to think that I can handle this sort of thing on my own - I don't like asking for help, unless it is absolutely necessary - I don't like coming across as a bother. But... it is really overwhelming. There are SO many options/parameters, and the documentation doesn't really give clear and concise answers for everything.

Regardless, I do see the potential. I just need to be patient - which is NOT one of my talents.



Barney Stone
You don't have to wait for your Express Setup to get help with setting up or using the Order Manager. Give me a call at 215-641-1837 x 111 and I will get the programmer who handles MC integration on the phone with you.

As Jared pointed out, the program probably is importing orders, but with that many orders there will be a long delay, and it can appear that the program is not working. Checking your NewOrders folder for activity is a good test. I'm not sure about the product import problem. If it's a problem with the MC script (which we wrote initially, but they now control), we can pass the issue on to MC. If the problem is with the Order Manager or with your data, we can probably help you right away.
Ptch3456
QUOTE(Barney Stone @ Jan 26 2007, 06:59 AM) [snapback]120484[/snapback]
You don't have to wait for your Express Setup to get help with setting up or using the Order Manager. Give me a call at 215-641-1837 x 111 and I will get the programmer who handles MC integration on the phone with you.

As Jared pointed out, the program probably is importing orders, but with that many orders there will be a long delay, and it can appear that the program is not working. Checking your NewOrders folder for activity is a good test. I'm not sure about the product import problem. If it's a problem with the MC script (which we wrote initially, but they now control), we can pass the issue on to MC. If the problem is with the Order Manager or with your data, we can probably help you right away.


Barney:

Thank you for your reply.

I did speak with someone at SE. The orders were indeed importing - it's just that the first download takes a long time, and it may appear not be doing anything. In any event, it did run into an error with a couple of orders that I was able to pin down to one of the XML files - I think it didn't like a character in a product name. I deleted that particular XML file, and then reimported using the text file import - at that point, they all came in fine. The "bad" file was from early 2006 - so, it wasn't important. We are starting fresh with 2007, as far as detailed records by order.

In retrospect, it is probably a better idea (for everyone) to do the Express Set-up later - as I will have a basis for any questions . I am feeling more confident in navigating the program. I will add though, that I have already discovered a feature that would be nice (unless I'm blind, and it already exists). Rather than hitting the "search" button to do this - it would be nice to be able to navigate to a particular order from the "view orders" screen, simply by typing in the web order number there.

I'm loving the payment terminal functionality - it is SO FAST! This alone is going to save a substantial amount of time. We get a ton of manual re-orders... so that has always been a pain.
Barney Stone
QUOTE(Ptch3456 @ Jan 26 2007, 08:26 AM) [snapback]120485[/snapback]
I will add though, that I have already discovered a feature that would be nice (unless I'm blind, and it already exists). Rather than hitting the "search" button to do this - it would be nice to be able to navigate to a particular order from the "view orders" screen, simply by typing in the web order number there.

We've got you covered on that one! There is a list of shortcuts like that in our Knowledge Base at: http://www.stoneedge.com/help/OM_DOC/tips_.../shortcuts.html
rungreen
PTCH

If you don't mind, can you tell me which payment gateway you use?

I can't use the terminal functionality, because MC dosen't return the info SE needs to process the payment. It might be in a "later release". I had thought that maybe using USAEpay(which NS/MC push), but nobody is sure if that will work either. This functionality would be much, much better......
Jared
Rungreen:

In the past, the download from monstersmile.gif to StoneEdge would not have transmitted the CVV and AVS response. However, I noticed some code (in more recent builds) that someone added to pickup the CVV and AVS response codes from monstersmile.gif... I haven't went back and figured out yet which gateways it works with (as we have the other issue of cards being declined because of high dollar tickets)... but, it looks like StoneEdge did work on collecting the AVS and CVV results (so using a real-time gateway with monstersmile.gif was actually useful.) Just FYI.
Ptch3456
QUOTE(rungreen @ Jan 26 2007, 05:49 PM) [snapback]120502[/snapback]
PTCH

If you don't mind, can you tell me which payment gateway you use?

I can't use the terminal functionality, because MC dosen't return the info SE needs to process the payment. It might be in a "later release". I had thought that maybe using USAEpay(which NS/MC push), but nobody is sure if that will work either. This functionality would be much, much better......


I didn't even realize that was (or was in the past) an issue. We've processed about 40 transactions through it since yesterday - both new orders, and re-orders using previous payment information. We use Authorize.net.

I will add however, that we are authorizing in MC first, and then capturing at shipment - so the CVV and AVS is processed beforehand. However, in the couple of transactions I processed manually (outside of MC), the AVS functioned just fine too.

Jared
Ptch-

The problen was that when authorizing through monstersmile.gif, then downloading to StoneEdge, there was no way to see the AVS and CVV result in StoneEdge. Since monstersmile.gif wasn't retaining the information, you had to login to Authorize.net to know what the AVS and CVV result (not the actual codes, but the yes/no/match/zip/address/etc)... are you seeing this information on credit cards that were authorized online using the Authorize.net payment methods?
Ptch3456
QUOTE(Jared @ Jan 26 2007, 07:28 PM) [snapback]120511[/snapback]
Ptch-

The problen was that when authorizing through monstersmile.gif, then downloading to StoneEdge, there was no way to see the AVS and CVV result in StoneEdge. Since monstersmile.gif wasn't retaining the information, you had to login to Authorize.net to know what the AVS and CVV result (not the actual codes, but the yes/no/match/zip/address/etc)... are you seeing this information on credit cards that were authorized online using the Authorize.net payment methods?


Ahhh... I see what you are asking.

No... we cannot see this information. However, we do see the results for the address in the automatic email from Authorize that matches each transaction. But I will add... that we don't use it for any purpose. Our products are personalized, and not subject to fraud - so this not a real concern for us. But, we do have it set up to decline charges that don't match the CVV or address in any event.

The email does indeed contain the AVS info. The CVV match is assumed since our gateway is set to decline a non-match.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.