Howdy,

So when I get an order in FoxEE, and I look at it under the “orders” tab, pretty much 100% of the time it says “Invalid Sku Provided”. When I look in the Activity Log, it says “Invalid Product code”. (ie, “FoxyCart Datafeed Error (orderid: 1138295) Invalid product code sent: TEST). So either the SKU or the product code is wrong. Or maybe both?

This is a problem because it appears to be preventing FoxEE’s inventory tracking from working correctly. My add to cart code is below. Any ideas of what could be amiss?

Thanks,

Mark

results in a form that looks like:

Hi Mark,

couple questions, what build of Foxee are you using? Make sure you upgrade to the latest (035)

Do you get the same errors if you use the foxee_test_template? Please install and test with the test template.

The inventory will not reduce if there are errors so that is functioning properly.

One other thing I saw that might cause a problem are the data and time parameters you have. I imagine you are trying to set hard sub dates.

I will upgrade to 035 today, I had been using 034. I do have the test template installed, and I get the same error if I hit “checkout” from there rather than from the FoxyBox. Although I am not sure how to add products from the test template, so if the error is happening when I add stuff to the cart I don’t think that would catch it.

PS - The date and time parameters are just there so they show up on the user’s receipt, I don’t actually do anything with them programmatically.

It sounds like you didn’t set the weblog variable in the test template?? It should show all of the products in your weblog. Do you have a link?

Passing the date and time values in the cart is fine the way you have it.

hitting checkout will not change anything, you need to add the products to the cart properly to not receive errors.

OK I am upgraded to 035. The test template was not showing my products because they’re not physical, downloadable, subscription, or donation (I am selling class registrations). I removed the foxee_product_type=“download” in the test template and the products all show up now, so I can add them to the cart from there. Even after doing that, however, I still get the same error(s) in my activity feed and order history. I’ll PM URL and login details now, thanks for your help!

Hey Aaric, I know for a fact that this is not a bug in Foxee so you shouldn’t have to hack the files.

As to what is causing the sku errors I’m not sure, there maybe a database error from a upgrade. What build of Foxee did you guys upgrade from?

I upgraded most recently from 034. I believe the first version I installed was either 028 or 029, and then I’ve upgraded a couple times since then.

I do agree with Aaric it seems the SKU is not being passed back from FoxyCart. When I look at the POSTs going from my server to FC I see x:sku showing up in the requests like I suspect it’s supposed to. But then it’s not in the fc_json object at the top of my checkout page, and “sku” does not appear anywhere in the XML response FoxyCart sends. I assume it needs to be passed back from FC in order for FoxEE to interpret it?

Mark

should I ask the FoxyCart guys about this? Any other ideas? Should I be seeing a “sku” field in the XML response from FoxyCart?

I’m on the most recent build, and I’m also having this problem.

Just as an experiment, I did an entirely fresh install of FoxEE on a different server for a different domain for a site that has never had ecommerce.

After everything was setup and running, I submitted a test order, checked the datafeed and sure enough, the same error “Invalid Sku Provided”

This is what I used to add my product to the cart

Which when I view source, outputs this:

There is obviously some kind of bug somewhere unless we’re all just missing something.

It is crucial that this issue be solved by Sunday night at the latest, please help!!

Jason, could you please provide a list of all of your settings:

Foxee general settings for FoxyCart
Your FoxyCart store settings

I have several installations of Foxee in our test environments and do not receive these errors.

Thanks

Hey guys, just an update. Jason’s issue was with the addtocart form that he constructed. We determined this by using the foxee test template to run test transactions, which returned without errors.

Please do the same for your installations (use the test template) to eliminate any third party conflicts or form template issues.

Hey Mike,

Thanks again for all your help.  It turns out the issue was foxycart’s fc_PreProcess() function, that validates the form before submission to the cart.

After I removed the function, everything worked perfectly.

Do you have any alternatives for me to use for making sure all required fields have been filled out?

Admin - 26 March 2010 05:56 PM

Hey guys, just an update. Jason’s issue was with the addtocart form that he constructed. We determined this by using the foxee test template to run test transactions, which returned without errors.

Please do the same for your installations (use the test template) to eliminate any third party conflicts or form template issues.

I did this, see post #4 in this thread, and I still have the SKU error. Jason, if you don’t mind, what was the error that fc_preprocess was causing? How did you determine that was the cause?

Hey Mark, I determined fc_preprocess was the issue because everything worked as soon as I removed it.

With fc_preprocess: It validates the form and sends the information to foxycart no problem.  The problem: my datafeed displays invalid sku OR displays no product details at all.

Without fc_preprocess: Everything works great (except no form validation of course).

I have also been running into this problem, although in my situation I’m doing subscriptions. The first charge goes through correctly with no errors, but each subsequent subscription charge (I’m doing a daily as a test) comes back with

FoxyCart Datafeed Error (orderid: 1249573) Invalid product code sent: 00006 (the correct Foxee product code)

Thoughts?

EE 1.6.8
FoxEE 1.10.60.035