Jump to content

scythe000

Member
 View Profile  See their activity

  • Posts

    155

  • Joined

  • Last visited

 Content Type 

Posts posted by scythe000

    Google Missing Product Type Values

    in Technical Help

    Posted

    I found the least headache causing way to do this was to export the catalog in google base format than paste it all into a spread sheet and make my changes then paste it back into the txt format and upload it manually to google. It was a bit of work at first but now takes me about 5 minutes to do once a month after I add new products. I also need a manufacture part number vs ISBN, EAN, JAN or UPC. Using the spread sheet also allows for quick changes, quick new additions, and format changes so that I can use it for feeds other than Google as well.

    Oh, wow, awesome!

    so, something like this? I just added the field, and for the moment, made them all the same category.

    gbasetest1a.txt

    USPS shipping stopped working? Cart can't progress?

    in Technical Help

    Posted

    Holy Sh1t, i fixed it! I saw from here: http://forums.oscommerce.com/topic/146950-contribution-usps-methods/page__st__1120 that the ship date info isn't even necessary to send at all. I went to /modules/shipping/USPS/shipping.class.php and commented out this line: 

    
//   $xml->writeElement('ShipDate',date("d-M-Y"));

    and voila!it worked again!

    USPS shipping stopped working? Cart can't progress?

    in Technical Help

    Posted

    This error shows in the request log:

    


Request Sent - http://production.shippingapis.com/ShippingAPI.dll API=RateV4&XML=<RateV4Request USERID="392ONSAN7399"> <Package ID="0"> <Service>ALL</Service> <ZipOrigination>93001</ZipOrigination> <ZipDestination>93001</ZipDestination> <Pounds>6</Pounds> <Ounces>8</Ounces> <Container>VARIABLE</Container> <Size>REGULAR</Size> <Machinable>False</Machinable> <ReturnLocations>TRUE</ReturnLocations> <ShipDate>13-Apr-2012</ShipDate> </Package></RateV4Request>

Response received <?xml version="1.0"?> <RateV4Response><Package ID="0"><Error><Number>-2147219421</Number><Source>DomesticRatesV4;clsRateV4.ValidateShipDate;RateEngineV4.ProcessRequest</Source><Description>Ship Date must be within the next three days.</Description><HelpFile></HelpFile><HelpContext>1000440</HelpContext></Error></Package></RateV4Response>

    Big problems with 3.0.20 site that I upgraded to 5.0.7

    in Technical Help

    Posted

    Ok. Solved! Big thanks to the team at CubeCart. Very helpful. So, It seems my really old DB was actually in a SQL 4 format, even though the server was running v5. He created a new db and imported, and it worked ok.

    Here's Al's notes: "Well I think your old store has an old version of MySQL. Creating a new DB in Godaddy forced it onto a new version of MySQL which worked. "

    Thanks!!!

    Big problems with 3.0.20 site that I upgraded to 5.0.7

    in Technical Help

    Posted

    ok, managed to upgrade my 3.0.20 site via a 4.4.6 upgrade first. Now, all my orders are missing, although i see entries in the SQL field for them. My products are all missing as well, although they show in admin when i click on products, but not on the main page. Searching says no items. I tried to add a product to a category and it would freeze after saving the changes, and not apply them.

    Please help!

    Rebuild category product count

    in Technical Help

    Posted

    I'm getting this as well:

    
Error Message:

1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT DISTINCT `productId` FROM CubeCart_inventory WHERE `disa

SQL:

DELETE FROM CubeCart_cats_idx WHERE productId NOT IN (SELECT DISTINCT `productId` FROM CubeCart_inventory WHERE `disabled` = '0')

×
×
  • Create New...