Starting Over

I have been working with this particilar Shopping Cart for 30 days. Trying to get the Shipping to work.

I am thinking maybe some of the PowerStore 3 Files were corrupted during installation and I need to delete all of them and start over.

I have downloaded a fresh copy of PowerStore 3 and unzipped it into a folder.

Then I downloaded all of the "Known Issures" fixes and unzipped them to the folder. This includes the one that was posted a day ago for shipping. (It did not fix my problem with shipping)

Here is my question, if I delete the current PowerStore 3 files from the Server and start over. What will this delete? How much of the work I have already done will be lost?

I know the products will remain in the MySQL Database, but what I am not sure of is how to link the fresh copy of PowerStore 3 to the current MYSQL Database since this Wizard will automatically create new tables.

I cannot find any information on how to link PowerStore 3 to an already existing Database.

However, I did find the instructions on moving from PowerStore 2 to PowerStore 3. Will these instructions work for what I am about to do above?

I really need answers soon.

Hi

Ok we've all had to start again ;-)

step one is to start up your own msql admin tool ie phpmyadmin, I use navicat.

Step 2 log into your database and select all the tables.

Step three using the menu select sql

at this point you should see an sql file created and be asked where to save it. REmember where you do!!!

Step 4 highlight all the tables and delete them.

step 5 start up you new fresh copy of PS3 and let it create the database.

Step six go back into your mysql admin tool and find the option to run your sql file ( see you need to know where it's saved ;-)

that will replace all the created tables with the old ones.

That should solve your problem.

Note that is your existing problem is being caused by your basic settings which are stored in the table wa_settings then by running the sql you will just re create your problem.

If thats the case then when you do your initial SQL dump highlight all the tables except wa_settings. when you restore your new settings table will not be over written.

HTH

IAn

Ok, I spent the day recreating my Powerstore thinking I may have had some corrupted files since I downloaded and applied the ecart Fix that
was posted on Monday. Which did not work for me.

Thank you i.edwards for the step by step instructions they worked great and saved me
a lot of time.

It looks like all the files are working the way they should with the exception of "Shipping".

I found a file in the Forum that suggested posting some coding to create error coding on the
checkout_failure.php and pp_checkout_failure.php pages.

I added this information to my pages and the following below is the result.

I should add I went to USPS Customer Service to make sure I had the correct information added to my
page in Admin and to ensure my account had in fact been activiated. It has been and the information is correct.

I set up a Sandbox account and everything is working as it should as long as I "uncheck" the enable box on the
Shipping Tab in Admin. But when I check the enable box I get an "Transaction not complete" on the Checkout Failure Page. (See attached.)

I also checked with PayPal and was told that my account was work and was talking with their server.

I hope someone can help me with this.

PS: Please understand I need step by step instructions on how to fix this problem,
if there is a fix that is.


==============================================================

Express Authorize:
Full Request: <?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Header><RequesterCredentials xmlns="urn:ebay:api:PayPalAPI"><Credentials xmlns="urn:ebay:apis:eBLBaseComponents"><Username>sheila_1273104721_biz_api1.sheilawilliams.com</Username><Password>1273104731</Password><Signature>An5ns1Kso7MWUdW4ErQKJJJ4qi4-ALdiU1EL.p8NM71XH74HB6EqrN4o </Signature><Subject/></Credentials></RequesterCredentials></soap:Header><soap:Body><SetExpressCheckoutReq xmlns="urn:ebay:api:PayPalAPI"><SetExpressCheckoutRequest><Version xmlns="urn:ebay:apis:eBLBaseComponents">2.20</Version><SetExpressCheckoutRequestDetails xmlns="urn:ebay:apis:eBLBaseComponents"><OrderTotal currencyID="USD">142.00</OrderTotal><ReturnURL>http://www.sheilawilliams.com/ps3/pp_confirm.php</ReturnURL><CancelURL>http://www.sheilawilliams.com/ps3/pp_cancel.php</CancelURL><PaymentAction>Authorization</PaymentAction></SetExpressCheckoutRequestDetails></SetExpressCheckoutRequest></SetExpressCheckoutReq></soap:Body></soap:Envelope>
Full Response: <?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:cc="urn:ebay:apis:CoreComponentTypes" xmlns:ed="urn:ebay:apis:EnhancedDataTypes" xmlns:wsu="http://schemas.xmlsoap.org/ws/2002/07/utility" xmlns:saml="urn:oasis:names:tc:SAML:1.0:assertion" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:wsse="http://schemas.xmlsoap.org/ws/2002/12/secext" xmlns:ebl="urn:ebay:apis:eBLBaseComponents" xmlns:ns="urn:ebay:api:PayPalAPI"><SOAP-ENV:Header><Security xmlns="http://schemas.xmlsoap.org/ws/2002/12/secext" xsi:type="wsse:SecurityType"></Security><RequesterCredentials xmlns="urn:ebay:api:PayPalAPI" xsi:type="ebl:CustomSecurityHeaderType"><Credentials xmlns="urn:ebay:apis:eBLBaseComponents" xsi:type="ebl:UserIdPasswordType"><Username xsi:type="xs:string"></Username><Password xsi:type="xs:string"></Password><Signature xsi:type="xs:string">An5ns1Kso7MWUdW4ErQKJJJ4qi4-ALdiU1EL.p8NM71XH74HB6EqrN4o </Signature><Subject xsi:type="xs:string"></Subject></Credentials></RequesterCredentials></SOAP-ENV:Header><SOAP-ENV:Body id="_0"><SetExpressCheckoutResponse xmlns="urn:ebay:api:PayPalAPI"><Timestamp xmlns="urn:ebay:apis:eBLBaseComponents">2010-05-13T00:08:00Z</Timestamp><Ack xmlns="urn:ebay:apis:eBLBaseComponents">Success</Ack><CorrelationID xmlns="urn:ebay:apis:eBLBaseComponents">65c36657ac713</CorrelationID><Version xmlns="urn:ebay:apis:eBLBaseComponents">2.20</Version><Build xmlns="urn:ebay:apis:eBLBaseComponents">1298200</Build><Token xsi:type="ebl:ExpressCheckoutTokenType">EC-8AU83160RJ4123216</Token></SetExpressCheckoutResponse></SOAP-ENV:Body></SOAP-ENV:Envelope>


Express Process:
Full Request: n/a
Full Response: n/a


USPS:
Full Request: API=RateV3&XML=<RateV3Request USERID="xxxxxxxxxxxxx"><Package ID="0"><Service>EXPRESS</Service><ZipOrigination>92592-1063</ZipOrigination><ZipDestination>95131</ZipDestination><Pounds>3</Pounds><Ounces>0</Ounces><Container>Flat Rate Box</Container><Size>REGULAR</Size></Package></RateV3Request>
Full Response: <Error> <Number>80040b1a</Number> <Description>API Authorization failure. RateV3 is not a valid API name for this protocol.</Description> <Source>UspsCom::DoAuth</Source> </Error>

Hi

I make no claim to be a PHP genius, quite the contrary. My knowledge has all been learnt the hard way.

As to shipping all my shops use "free shipping" because thats what the customers like.

Your error I think is going to need the tender attention of either Jason or Jimmy

Cheers

Ian

looks like the USPS Shipping API URL You are using is the testing URL< they have not updated the testing server to use the Version 3 API, you will need to use the USPS production server:
shippingapi.dll


make sure your account is activated with USPS to use the production server as well, I believe you only need to email then you account information and request activation on the production server to have this happen.

Hi James,

Thank you for taking the time to reply to my message.

My mistake I was not very clear in my message yesterday.

I called USPS after I reinstall PS3 yesterday to ensure my account was in fact activated.

I requested that Nath (USPS TechSupport 1 800 344-7779 as for Tech Support) double check my account to ensure that it was in fact activated. I was on the phone with him for 45 minutes, 15 of those minutes I was on hold while he made sure my account was in fact activated. I also verified that I was using the correct URLs. It is and I am.

My question is this, during BETA Testing was it not pointed out that there was a problem talking to the USPS and UPS Servers?

Per my request after testing on 6 May 2010 they sent me a message on 7 May 2010 with taking about my test and in the message I was told my API Account was activated. They included two URLs for the Production Servers. (See Postal Activation 1Attachment). I am not using the testing URL.

I have attached a part of the message I received on 27 April 2010 that gave me the URLs for the USPS Test Servers. (See TestServInfo Attachment) As you can see the test server URLs are different.

As you can see from the information I have provided below. The URLs from USPS and the one you provided in your message are all having problems talking to the USPS Server.

As I stated in my message yesterday if I disable the Shipping Tab Paypal works. But when I check the box to enable shipping I get an error message.

Per your message this morning I used the URL you sent me and received the same error message I get yesterday. (See Checkout Failure Message Attachment)

I have included pictures where I have used both URLs in PS3 (See Attachments 2 and 3) that were sent to me from USPS. I did remove my User ID from both images.

I used "http://production.shippingapis.com/ShippingAPI.dll " and here is the error message I received on the Checkout failure Page:

Express Authorize:
Full Request: <?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Header><RequesterCredentials xmlns="urn:ebay:api:PayPalAPI"><Credentials xmlns="urn:ebay:apis:eBLBaseComponents"><Username>sheila_1273104721_biz_api1.sheilawilliams.com</Username><Password>1273104731</Password><Signature>An5ns1Kso7MWUdW4ErQKJJJ4qi4-ALdiU1EL.p8NM71XH74HB6EqrN4o </Signature><Subject/></Credentials></RequesterCredentials></soap:Header><soap:Body><SetExpressCheckoutReq xmlns="urn:ebay:api:PayPalAPI"><SetExpressCheckoutRequest><Version xmlns="urn:ebay:apis:eBLBaseComponents">2.20</Version><SetExpressCheckoutRequestDetails xmlns="urn:ebay:apis:eBLBaseComponents"><OrderTotal currencyID="USD">58.00</OrderTotal><ReturnURL>http://www.sheilawilliams.com/ps3/pp_confirm.php</ReturnURL><CancelURL>http://www.sheilawilliams.com/ps3/pp_cancel.php</CancelURL><PaymentAction>Authorization</PaymentAction></SetExpressCheckoutRequestDetails></SetExpressCheckoutRequest></SetExpressCheckoutReq></soap:Body></soap:Envelope>
Full Response: <?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:cc="urn:ebay:apis:CoreComponentTypes" xmlns:ed="urn:ebay:apis:EnhancedDataTypes" xmlns:wsu="http://schemas.xmlsoap.org/ws/2002/07/utility" xmlns:saml="urn:oasis:names:tc:SAML:1.0:assertion" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:wsse="http://schemas.xmlsoap.org/ws/2002/12/secext" xmlns:ebl="urn:ebay:apis:eBLBaseComponents" xmlns:ns="urn:ebay:api:PayPalAPI"><SOAP-ENV:Header><Security xmlns="http://schemas.xmlsoap.org/ws/2002/12/secext" xsi:type="wsse:SecurityType"></Security><RequesterCredentials xmlns="urn:ebay:api:PayPalAPI" xsi:type="ebl:CustomSecurityHeaderType"><Credentials xmlns="urn:ebay:apis:eBLBaseComponents" xsi:type="ebl:UserIdPasswordType"><Username xsi:type="xs:string"></Username><Password xsi:type="xs:string"></Password><Signature xsi:type="xs:string">An5ns1Kso7MWUdW4ErQKJJJ4qi4-ALdiU1EL.p8NM71XH74HB6EqrN4o </Signature><Subject xsi:type="xs:string"></Subject></Credentials></RequesterCredentials></SOAP-ENV:Header><SOAP-ENV:Body id="_0"><SetExpressCheckoutResponse xmlns="urn:ebay:api:PayPalAPI"><Timestamp xmlns="urn:ebay:apis:eBLBaseComponents">2010-05-13T18:24:45Z</Timestamp><Ack xmlns="urn:ebay:apis:eBLBaseComponents">Success</Ack><CorrelationID xmlns="urn:ebay:apis:eBLBaseComponents">8e1e04e9e27</CorrelationID><Version xmlns="urn:ebay:apis:eBLBaseComponents">2.20</Version><Build xmlns="urn:ebay:apis:eBLBaseComponents">1298200</Build><Token xsi:type="ebl:ExpressCheckoutTokenType">EC-9UV90509CK064392V</Token></SetExpressCheckoutResponse></SOAP-ENV:Body></SOAP-ENV:Envelope>

Express Process:
Full Request: n/a
Full Response: n/a

USPS:
Full Request: API=RateV3&XML=<RateV3Request USERID="xxxxxxxxxxxx"><Package ID="0"><Service>EXPRESS</Service><ZipOrigination>92592-1063</ZipOrigination><ZipDestination>95131</ZipDestination><Pounds>3</Pounds><Ounces>0</Ounces><Container>Flat Rate Box</Container><Size>REGULAR</Size></Package></RateV3Request>
Full Response: <?xml version="1.0"?> <RateV3Response><Package ID="0"><Error><Number>-2147219430</Number><Source>DomesticRatesV3;clsRateV3.ValidateContainer;RateEngineV3.ProcessRequest</Source><Description>Invalid container type. A valid container type for Express Mail is Flat Rate Envelope.</Description><HelpFile></HelpFile><HelpContext>1000440</HelpContext></Error></Package></RateV3Response>

---------------------------------------
Next I used " ShippingAPI.dll " the second URL I received from the USPS. BTW this is the URL I was told to use by Nath at USPS Customercare Tech Support (1-800-344-7779). Here is the error message I received using this URL (it was the one message I sent yesterday but just in case I am sending it again):


Express Authorize:
Full Request: <?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Header><RequesterCredentials xmlns="urn:ebay:api:PayPalAPI"><Credentials xmlns="urn:ebay:apis:eBLBaseComponents"><Username>sheila_1273104721_biz_api1.sheilawilliams.com</Username><Password>1273104731</Password><Signature>An5ns1Kso7MWUdW4ErQKJJJ4qi4-ALdiU1EL.p8NM71XH74HB6EqrN4o </Signature><Subject/></Credentials></RequesterCredentials></soap:Header><soap:Body><SetExpressCheckoutReq xmlns="urn:ebay:api:PayPalAPI"><SetExpressCheckoutRequest><Version xmlns="urn:ebay:apis:eBLBaseComponents">2.20</Version><SetExpressCheckoutRequestDetails xmlns="urn:ebay:apis:eBLBaseComponents"><OrderTotal currencyID="USD">58.00</OrderTotal><ReturnURL>http://www.sheilawilliams.com/ps3/pp_confirm.php</ReturnURL><CancelURL>http://www.sheilawilliams.com/ps3/pp_cancel.php</CancelURL><PaymentAction>Authorization</PaymentAction></SetExpressCheckoutRequestDetails></SetExpressCheckoutRequest></SetExpressCheckoutReq></soap:Body></soap:Envelope>
Full Response: <?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:cc="urn:ebay:apis:CoreComponentTypes" xmlns:ed="urn:ebay:apis:EnhancedDataTypes" xmlns:wsu="http://schemas.xmlsoap.org/ws/2002/07/utility" xmlns:saml="urn:oasis:names:tc:SAML:1.0:assertion" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:wsse="http://schemas.xmlsoap.org/ws/2002/12/secext" xmlns:ebl="urn:ebay:apis:eBLBaseComponents" xmlns:ns="urn:ebay:api:PayPalAPI"><SOAP-ENV:Header><Security xmlns="http://schemas.xmlsoap.org/ws/2002/12/secext" xsi:type="wsse:SecurityType"></Security><RequesterCredentials xmlns="urn:ebay:api:PayPalAPI" xsi:type="ebl:CustomSecurityHeaderType"><Credentials xmlns="urn:ebay:apis:eBLBaseComponents" xsi:type="ebl:UserIdPasswordType"><Username xsi:type="xs:string"></Username><Password xsi:type="xs:string"></Password><Signature xsi:type="xs:string">An5ns1Kso7MWUdW4ErQKJJJ4qi4-ALdiU1EL.p8NM71XH74HB6EqrN4o </Signature><Subject xsi:type="xs:string"></Subject></Credentials></RequesterCredentials></SOAP-ENV:Header><SOAP-ENV:Body id="_0"><SetExpressCheckoutResponse xmlns="urn:ebay:api:PayPalAPI"><Timestamp xmlns="urn:ebay:apis:eBLBaseComponents">2010-05-13T18:40:06Z</Timestamp><Ack xmlns="urn:ebay:apis:eBLBaseComponents">Success</Ack><CorrelationID xmlns="urn:ebay:apis:eBLBaseComponents">2b797827d90d6</CorrelationID><Version xmlns="urn:ebay:apis:eBLBaseComponents">2.20</Version><Build xmlns="urn:ebay:apis:eBLBaseComponents">1298200</Build><Token xsi:type="ebl:ExpressCheckoutTokenType">EC-1UV14244WF220693C</Token></SetExpressCheckoutResponse></SOAP-ENV:Body></SOAP-ENV:Envelope>

Express Process:
Full Request: n/a
Full Response: n/a

USPS:
Full Request: API=RateV3&XML=<RateV3Request USERID="xxxxxxxxxxxx"><Package ID="0"><Service>EXPRESS</Service><ZipOrigination>92592-1063</ZipOrigination><ZipDestination>95131</ZipDestination><Pounds>3</Pounds><Ounces>0</Ounces><Container>Flat Rate Box</Container><Size>REGULAR</Size></Package></RateV3Request>
Full Response: <Error> <Number>80040b1a</Number> <Description>API Authorization failure. RateV3 is not a valid API name for this protocol.</Description> <Source>UspsCom::DoAuth</Source> </Error>



SPECIAL NOTE: I "X" out my User ID in both codes.

----------------------------

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
login.php