gaspower

Hello, Need some help with 2.76g-MS2. When I activate SPPC and download the file to edit a, add into SPPC fields and upload, I get the following error, 1136 - Column count doesn't match value count at row 1 INSERT INTO products_groups VALUES ( 1, 7, 34 ) But, if I upload the file with SPPC fields blank it uploads fine? Thanks JR EP vers: 2.76g-MS2 osCommerce Online Merchant v2.2 RC1 OS: Linux 2.6.20.1 HTTP: Apache/2.2.4 (Fedora) DB: MySQL 5.0.27 PHP: 5.1.6 (Zend: 2.1.0) Temp Directory: /home/virtual/site1.com/var/www/html/temp/ Temp Dir is Writable Magic Quotes is: off register_globals is: off Split files on: 300 records Model Num Size: 12 Price with tax: false Calc Precision: 2 Replace quotes: false Field seperator: tab Excel safe output: false Preserve tab/cr/lf: false Category depth: 3 Enable attributes: false SEF Froogle URLS: false More Pics: false Unknown Pics: false HTC: false SPPC: true Extra Fields: false

Hello, I am using SPPC 4.2 contribution and was wondering if there is a way so that when a customer is chosen that does not get charged sales tax, that Manual Order Maker reflects no tax? I currently have to modify that field. Thanks JR

Hello, Contribution works great. Was wondering if there was a add on so it can show product inventory count when adding at product screen? Nice to know I am not adding more to customers order than in stock. Thanks JR

Hello, If you get a error for either manufacturers or specials, try adding a second manufacturer (even if not used) and or second special it should solve the error. Some reason the contributions has to have more than one in the database. JR

Hello, I have installed this contribution on a few sites, but on a couple I am getting this error, ERROR: Google Specials Sitemap Generation FAILED! Array ( [QUERY] => Array ( [PRODUCTS] => Array ( [STATUS] => success [NUM_ROWS] => 4926 ) [CATEOGRY] => Array ( [STATUS] => success [NUM_ROWS] => 185 ) [MANUFACTURERS] => Array ( [STATUS] => success [NUM_ROWS] => 44 ) [SPECIALS] => Array ( [STATUS] => success [NUM_ROWS] => 1 ) ) [SAVE_FILE_XML] => Array ( [0] => Array ( [file] => /home/virtual/domain.com/var/www/html/sitemapproducts.xml [status] => success [file_exists] => true ) [1] => Array ( [file] => /home/virtual/domain.com/var/www/html/sitemapcategories.xml [status] => success [file_exists] => true ) [2] => Array ( [file] => /home/virtual/domain.com/var/www/html/sitemapmanufacturers.xml [status] => success [file_exists] => true ) [3] => Array ( [file] => /home/virtual/domain.com/var/www/html/sitemapindex.xml [status] => success [file_exists] => true ) ) ) Thank you JR

Hello, I was wondering if there has been a fix to allow discounts to properly pass to Paypal IPN? Do we still need to run in aggregate selection to get them to pass? Thanks JR

Hello, I am having trouble with the Fedex labels to print multiple packages? Below is the debug output. All it prints is the first label, no click able to to print any other labels. Also when label is printed, it is setting shipping status to wrong status. Where do I change this option? Thanks JR Shipment request data, package number 1: Array ( [0] => 21 [2399] => 0 [16] => OR [13] => Address [1273] => 01 [1274] => 90 [18] => 5555551212 [15] => Bend [23] => 1 [117] => US [17] => 97002 [50] => US [11] => [12] =>Name [1333] => 1 [1415] => .00 [1368] => 2 [1369] => 1 [1370] => 5 [3002] => 313 [25] => 313 [3001] => [38] => [24] => 20090205 [1119] => N [2975] => Y [1266] => N [1200] => N [44] => [46] => [47] => [48] => [49] => [57] => [58] => [59] => [3008] => N [440] => Y [10] => 126622074 [498] => 5720896 [75] => LBS [4] => Shop Name [5] => Shop Address [6] => NONE [7] => Middlesex [8] => NJ [9] => 08846 [183] => Shop Number [68] => USD [116] => 3 [1117] => 1 [1400] => 21.0 [1401] => 7.0 ) Manifest data, package number 1: Array ( [delivery_id] => [orders_id] => 313 [delivery_name] => Customer Name [delivery_company] => [delivery_address_1] => Customer Address [delivery_address_2] => [delivery_city] => Bend [delivery_state] => OR [delivery_postcode] => 97002 [delivery_phone] => Customer Number [package_weight] => [package_value] => [oversized] => [pickup_date] => 20090205 [saturday_delivery] => [hold_at_location] => [hal_address] => [hal_city] => [hal_state] => [hal_postcode] => [hal_phone] => [dim_height] => [dim_width] => [dim_length] => [shipping_type] => 90 [residential] => Y [autopod] => [cod] => [multiple] => 1 [tracking_num] => master_trackNum ) Shipment request data, package number 2: Array ( [0] => 21 [2399] => 0 [16] => OR [13] => Customer Address [1273] => 01 [1274] => 90 [18] => Customer Number [15] => Bend [23] => 1 [117] => US [17] => 97002 [50] => US [11] => [12] => Customer Name [1333] => 1 [1415] => .00 [1368] => 2 [1369] => 1 [1370] => 5 [3002] => 313 [25] => 313 [3001] => [38] => [24] => 20090205 [1119] => N [2975] => Y [1266] => N [1200] => N [44] => [46] => [47] => [48] => [49] => [57] => [58] => [59] => [3008] => N [440] => Y [10] => 126622074 [498] => 5720896 [75] => LBS [4] =>Shop Name [5] => Shop Address [6] => NONE [7] => Middlesex [8] => NJ [9] => 08846 [183] => Shop Number [68] => USD [116] => 3 [1117] => 2 [1400] => 21.0 [1401] => 7.0 [1123] => master_trackNum ) Manifest data, package number 2: Array ( [delivery_id] => [orders_id] => 313 [delivery_name] => Customer Name [delivery_company] => [delivery_address_1] => Customer Address [delivery_address_2] => [delivery_city] => Bend [delivery_state] => OR [delivery_postcode] => 97002 [delivery_phone] => Customer Number [package_weight] => [package_value] => [oversized] => [pickup_date] => 20090205 [saturday_delivery] => [hold_at_location] => [hal_address] => [hal_city] => [hal_state] => [hal_postcode] => [hal_phone] => [dim_height] => [dim_width] => [dim_length] => [shipping_type] => 90 [residential] => Y [autopod] => [cod] => [multiple] => 2 [tracking_num] => trackNum ) Shipment request data, package number 3: Array ( [0] => 21 [2399] => 0 [16] => OR [13] => Customer Address [1273] => 01 [1274] => 90 [18] => Customer Number [15] => Bend [23] => 1 [117] => US [17] => 97002 [50] => US [11] => [12] => Customer Name [1333] => 1 [1415] => .00 [1368] => 2 [1369] => 1 [1370] => 5 [3002] => 313 [25] => 313 [3001] => [38] => [24] => 20090205 [1119] => N [2975] => Y [1266] => N [1200] => N [44] => [46] => [47] => [48] => [49] => [57] => [58] => [59] => [3008] => N [440] => Y [10] => 126622074 [498] => 5720896 [75] => LBS [4] => Shop Name [5] => Shop Address [6] => NONE [7] => Middlesex [8] => NJ [9] => 08846 [183] => Shop Number [68] => USD [116] => 3 [1117] => 3 [1400] => 21.0 [1401] => 7.0 [1123] => master_trackNum ) Manifest data, package number 3: Array ( [delivery_id] => [orders_id] => 313 [delivery_name] => Customer Name [delivery_company] => [delivery_address_1] => Customer Address [delivery_address_2] => [delivery_city] => Bend [delivery_state] => OR [delivery_postcode] => 97002 [delivery_phone] =>Customer Number [package_weight] => [package_value] => [oversized] => [pickup_date] => 20090205 [saturday_delivery] => [hold_at_location] => [hal_address] => [hal_city] => [hal_state] => [hal_postcode] => [hal_phone] => [dim_height] => [dim_width] => [dim_length] => [shipping_type] => 90 [residential] => Y [autopod] => [cod] => [multiple] => 3 [tracking_num] => trackNum ) Running in debug mode, no ship request made

Hello, This contribution works great, thank you. Was wondering, once a package is shipped, the contribution updates the customer order info with tracking information. Is there a way, or maybe I missed it, that it updates the order from processing to shipped? Thanks JR

Hello, I reverted back to original IPN in RC1 package and I get the radial button to show in payment. If I upgrade to any other version, like 2.3.3 and the radial button disappears? Is it okay to use the version that came with MS2.2 RC1? I would like to upgrade and figure the problem. Any guidance what would cause the issue. I did check as mentioned above, Zones=none. Thanks JR

Hello, I just post error above but forgot to include these details. Register Globals = Off in php.ini ( did set a php.ini with register on in the ext/modules/payment/paypal_ipn/ipn.php Php version: 5.1.6 Curl Version: 7.15.5 OSC Version: v2.2 RC1 Paypal IPN Version 2.3.3

Hello, I just downloaded IPN version 2.3.3 for replacement of the standard Paypal payment with OSC. I removed the standard Paypal payment method and installed the new IPN version. I set all the parameters as indicated in the instructions. For some reason I am not getting the radial button in checkout? Only one that show is the current credit card button? Thanks JR

Hello, Discount Coupons works great. Is there a way to make it so it will work as a shipping discount if customer orders a certain amount. Example, if I have it set so when a customer orders $150.00 or more, they get a 20% discount on shipping? Thanks JR

Hello, Edit order and manual order (added on contribution) are working fine now. Was just wondering, what method people are using for processing the payment when order is created from admin or modified from admin. I understand when customer does complete checkout, it processes normally through payment modules, but how is payment taken if store owner processes order from admin? Is there another contribution? Thanks JR

Hello, Blank page error was doe to this line, Fatal error: Call to undefined function tep_get_products_special_price() in /home/virtual/var/www/html/includes/modules/shipping/freeamount.php on line 74 Which was doe to having the free shipping contribution installed. Fix for this is add this to the bottom of admin/includes/functions before the end ?> Add: function tep_get_products_special_price($product_id) { $product_query = tep_db_query("select specials_new_products_price from " . TABLE_SPECIALS . " where products_id = '" . (int)$product_id . "' and status"); $product = tep_db_fetch_array($product_query); return $product['specials_new_products_price']; } JR

Hello, I am using 5.0.6, and when I edit an order, and add a product, when it goes to update_order in edit_orders.php I get a blank screen? Sorry, tried to search, but may have missed the answer. Thanks JR

Hello, Does anyone have EP working with SPPC Attributes contribution for groups? Thank JR

Hello, I added the attributes SPPC addon and it works fine, shows attribute discounts for groups. But is there away in products_attributes to see the the values on the main screen for the group values other than clicking on the group prices button? I have quite a few items and would be easier to see if set correctly on the main screen verse having to click on the button for each? Thanks JR

Oh okay thank you.

Hello, Thanks again for the reply. I am using OSC RC1. Which patch are you using? Thanks JR

Hello, Same issue, all emails go to default email set in OSC. Thanks JR

Hello, We'll as soon as I get back from my Star Bucks run, I will try 1.3, see what happens. What version of OSC are you using? Thanks JR

Hello, Thank you for that suggestion. Sorry, I did forget to mention, I did try that, still same issue. All emails go to main email address set up in configuration. Thanks JR

Hello, I just installed v1.42 and it installed fine and seems to work great except for one issue. I am sometimes getting double emails, but emails are not going to the designated addresses? I have Web <[email protected]>, Tech <[email protected]>, Sales <[email protected]>, Billing <[email protected]>. Main email in configuration is [email protected]. No matter which radial button you choose in contact us, all mail goes to defaul [email protected]? Thanks JR

Hello, Thanks for a great contribution and it all works fine. I was wondering if anyone has come across a fix for the admin side, so when not uploading all eight images that it does not show broken image links? I have searched on this forum and may have missed the post. Thanks for the help, JR

Hey Jan, Thanks again for a great contribution. Have a small issue I can not trace down. I am using SPPC4.16 and in admin/customers.php when viewing, the customer group is not showing on the screen. But, once you enter the customer, such as edit and come back out, the customer group is in the listing?? What would cause it not to show until entering into the customers edit portion and back out? Thanks JR