Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

gaspower

Pioneers
  • Posts

    453
  • Joined

  • Last visited

Posts posted by gaspower

  1. 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

  2. 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

  3. 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

  4. 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

  5. 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

  6. 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

  7. 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

  8. 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

  9. 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

  10. 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

  11. 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

  12. 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

  13. 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

×
×
  • Create New...