Jump to content

knipper

Members
  • Content count

    130
  • Joined

  • Last visited

Posts posted by knipper


  1. Found the answer! Not sure if I missed it when I installed this, or if it wasn't in the directions, but In the lines:

     tep_db_query("insert into " . TABLE_PRODUCTS . (SNIP)

    although the products_msrp line was in the values portion, it was missing this entry:

    '" . tep_db_input($product['products_msrp']) . "',

    therefore it was a column short when trying to insert the data.


  2. Hey JackMCS,

     

    If you're still around... it wasn't this contribution causing my error after all. I was out of town for a week, and when I came back started to work on a site that didn't have this contribution installed. Sure enough the problem was on this site! Bummer.

     

    Anyway, I started a new thread here:

    http://forums.oscommerce.com/index.php?showtopic=329891

    and was hoping you could take another look to see if you could help.

     

    Thanks!


  3. Hi All,

     

    I have seen many posts about this contribution http://addons.oscommerce.com/info/3574 but never with this issue. I originally thought it was a different newly installed contribution but then found out it was actually this one!

     

    OK... the contibution seems to work great. No problem with display on page. Calculations OK, etc. BUT... when you try to copy a product as a duplicate to a new category, you get the following error:

     

    1136 - Column count doesn't match value count at row 1
    
    insert into products (products_quantity, products_model,products_image, products_mediumimage, products_largeimage,
    products_msrp, products_price, products_date_added, products_date_available, products_weight, products_status,
    products_tax_class_id, manufacturers_id) values ('0', '116xx', 'loveseat-sm.jpg', 'loveseat-md.jpg', 'loveseat-lg.jpg',
    '208.5500', now(), null, '25.00', '0', '1', '1')
    

     

    As you can see, the msrp field products_msrp, isn't in the data to be inserted. Which is causing the error message. There is one more field in the table definition, than data trying to be pasted.

     

    Where do I need to make the change to correct the data being pulled from the query? It is the admin/categories.php page getting the error.

     

    Any assistance would be great! Thanks in advance!


  4. Thanks again Jack... I'm buzzing around the forum to see if I can find anything. I am posting the entire admin/categories.php file below in case yo anyone can cruise through and see if you see anything sticking out that may be the change I need.

     

    Ooopppssss..... The whole page is too long to post. I'll copy most of her code for the copy functions....

     

     

    // BOF: Attributes copy
    // WebMakers.com Added: Attributes Copy
           $contents[] = array('text' => '<br>' . tep_image(DIR_WS_IMAGES . 'pixel_black.gif','','100%','3'));
           $contents[] = array('text' => '<br>' . TEXT_COPY_ATTRIBUTES_ONLY);
           $contents[] = array('text' => '<br>' . TEXT_COPY_ATTRIBUTES . '<br>' . tep_draw_radio_field('copy_attributes', 'copy_attributes_yes', true) . ' ' . TEXT_COPY_ATTRIBUTES_YES . '<br>' . tep_draw_radio_field('copy_attributes', 'copy_attributes_no') . ' ' . TEXT_COPY_ATTRIBUTES_NO);
           $contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_copy.gif', IMAGE_COPY) . ' <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
          $contents[] = array('align' => 'center', 'text' => '<br>' . ATTRIBUTES_NAMES_HELPER . '<br>' . tep_draw_separator('pixel_trans.gif', '1', '10'));
    // EOF: Attributes copy
           break;
    // BOF: Attributes copy to existing product:
    // WebMakers.com Added: Copy Attributes Existing Product to another Existing Product
         case 'copy_product_attributes':
           $copy_attributes_delete_first='1';
           $copy_attributes_duplicates_skipped='1';
           $copy_attributes_duplicates_overwrite='0';
    
           if (DOWNLOAD_ENABLED == 'true') {
             $copy_attributes_include_downloads='1';
             $copy_attributes_include_filename='1';
           } else {
             $copy_attributes_include_downloads='0';
             $copy_attributes_include_filename='0';
           }
    
           $heading[] = array('text' => '<b>' . 'Copy Attributes to another product' . '</b>');
           $contents = array('form' => tep_draw_form('products', FILENAME_CATEGORIES, 'action=create_copy_product_attributes&cPath=' . $cPath . '&pID=' . $pInfo->products_id) . tep_draw_hidden_field('products_id', $pInfo->products_id) . tep_draw_hidden_field('products_name', $pInfo->products_name));
           $contents[] = array('text' => '<br>Copying Attributes from #' . $pInfo->products_id . '<br><b>' . $pInfo->products_name . '</b>');
           $contents[] = array('text' => 'Copying Attributes to # ' . tep_draw_input_field('copy_to_products_id', $copy_to_products_id, 'size="3"'));
           $contents[] = array('text' => '<br>Delete ALL Attributes and Downloads before copying ' . tep_draw_checkbox_field('copy_attributes_delete_first',$copy_attributes_delete_first, 'size="2"'));
           $contents[] = array('text' => '<br>' . tep_image(DIR_WS_IMAGES . 'pixel_black.gif','','100%','3'));
           $contents[] = array('text' => '<br>' . 'Otherwise ...');
           $contents[] = array('text' => 'Duplicate Attributes should be skipped ' . tep_draw_checkbox_field('copy_attributes_duplicates_skipped',$copy_attributes_duplicates_skipped, 'size="2"'));
           $contents[] = array('text' => '   Duplicate Attributes should be overwritten ' . tep_draw_checkbox_field('copy_attributes_duplicates_overwrite',$copy_attributes_duplicates_overwrite, 'size="2"'));
           if (DOWNLOAD_ENABLED == 'true') {
             $contents[] = array('text' => '<br>Copy Attributes with Downloads ' . tep_draw_checkbox_field('copy_attributes_include_downloads',$copy_attributes_include_downloads, 'size="2"'));
             // Not used at this time - download name copies if download attribute is copied
             // $contents[] = array('text' => '   Include Download Filenames ' . tep_draw_checkbox_field('copy_attributes_include_filename',$copy_attributes_include_filename, 'size="2"'));
           }
           $contents[] = array('text' => '<br>' . tep_image(DIR_WS_IMAGES . 'pixel_black.gif','','100%','3'));
           $contents[] = array('align' => 'center', 'text' => '<br>' . PRODUCT_NAMES_HELPER);
           if ($pID) {
             $contents[] = array('align' => 'center', 'text' => '<br>' . ATTRIBUTES_NAMES_HELPER);
           } else {
            $contents[] = array('align' => 'center', 'text' => '<br>Select a product for display');
           }
           $contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_copy.gif', 'Copy Attribtues') . ' <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
           break;
    // WebMakers.com Added: Copy Attributes Existing Product to All Products in Category
         case 'copy_product_attributes_categories':
           $copy_attributes_delete_first='1';
           $copy_attributes_duplicates_skipped='1';
           $copy_attributes_duplicates_overwrite='0';
    
           if (DOWNLOAD_ENABLED == 'true') {
             $copy_attributes_include_downloads='1';
             $copy_attributes_include_filename='1';
           } else {
             $copy_attributes_include_downloads='0';
             $copy_attributes_include_filename='0';
           }
         $heading[] = array('text' => '<b>' . 'Copy Product Attributes to Category ...' . '</b>');
           $contents = array('form' => tep_draw_form('products', FILENAME_CATEGORIES, 'action=create_copy_product_attributes_categories&cPath=' . $cPath . '&cID=' . $cID . '&make_copy_from_products_id=' . $copy_from_products_id));
           $contents[] = array('text' => 'Copy Product Attributes from Product ID# ' . tep_draw_input_field('make_copy_from_products_id', $make_copy_from_products_id, 'size="3"'));
           $contents[] = array('text' => '<br>Copying to all products in Category ID# ' . $cID . '<br>Category Name: <b>' . tep_get_category_name($cID, $languages_id) . '</b>');
           $contents[] = array('text' => '<br>Delete ALL Attributes and Downloads before copying ' . tep_draw_checkbox_field('copy_attributes_delete_first',$copy_attributes_delete_first, 'size="2"'));
           $contents[] = array('text' => '<br>' . tep_image(DIR_WS_IMAGES . 'pixel_black.gif','','100%','3'));
           $contents[] = array('text' => '<br>' . 'Otherwise ...');
           $contents[] = array('text' => 'Duplicate Attributes should be skipped ' . tep_draw_checkbox_field('copy_attributes_duplicates_skipped',$copy_attributes_duplicates_skipped, 'size="2"'));
           $contents[] = array('text' => '   Duplicate Attributes should be overwritten ' . tep_draw_checkbox_field('copy_attributes_duplicates_overwrite',$copy_attributes_duplicates_overwrite, 'size="2"'));
           if (DOWNLOAD_ENABLED == 'true') {
             $contents[] = array('text' => '<br>Copy Attributes with Downloads ' . tep_draw_checkbox_field('copy_attributes_include_downloads',$copy_attributes_include_downloads, 'size="2"'));
            // Not used at this time - download name copies if download attribute is copied
             // $contents[] = array('text' => '   Include Download Filenames ' . tep_draw_checkbox_field('copy_attributes_include_filename',$copy_attributes_include_filename, 'size="2"'));
           }
           $contents[] = array('text' => '<br>' . tep_image(DIR_WS_IMAGES . 'pixel_black.gif','','100%','3'));
           $contents[] = array('align' => 'center', 'text' => '<br>' . PRODUCT_NAMES_HELPER);
           $contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_copy.gif', 'Copy Attribtues') . ' <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $cID) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
           break;
    // EOF: Attributes copy
         default:
           if ($rows > 0) {
             if (isset($cInfo) && is_object($cInfo)) { // category info box contents
               $heading[] = array('text' => '<b>' . $cInfo->categories_name . '</b>');
    
               $contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $cInfo->categories_id . '&action=edit_category') . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $cInfo->categories_id . '&action=delete_category') . '">' . tep_image_button('button_delete.gif', IMAGE_DELETE) . '</a> <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $cInfo->categories_id . '&action=move_category') . '">' . tep_image_button('button_move.gif', IMAGE_MOVE) . '</a>');
               $contents[] = array('text' => '<br>' . TEXT_DATE_ADDED . ' ' . tep_date_short($cInfo->date_added));
               if (tep_not_null($cInfo->last_modified)) $contents[] = array('text' => TEXT_LAST_MODIFIED . ' ' . tep_date_short($cInfo->last_modified));
               $contents[] = array('text' => '<br>' . tep_info_image($cInfo->categories_image, $cInfo->categories_name, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT) . '<br>' . $cInfo->categories_image);
               $contents[] = array('text' => '<br>' . TEXT_SUBCATEGORIES . ' ' . $cInfo->childs_count . '<br>' . TEXT_PRODUCTS . ' ' . $cInfo->products_count);
    //BOF: Attributes copy to all existing products
               if ($cInfo->childs_count==0 and $cInfo->products_count >= 1) {
    // WebMakers.com Added: Copy Attributes Existing Product to All Existing Products in Category
                 $contents[] = array('text' => '<br>' . tep_image(DIR_WS_IMAGES . 'pixel_black.gif','','100%','3'));
                 if ($cID) {
                   $contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $cID . '&action=copy_product_attributes_categories') . '">' . 'Copy Product Attributes to <br>ALL products in Category: ' . tep_get_category_name($cID, $languages_id) . '<br>' . tep_image_button('button_copy_to.gif', 'Copy Attributes') . '</a>');
                 } else {
                   $contents[] = array('align' => 'center', 'text' => '<br>Select a Category to copy attributes to');
                 }
               }
    //EOF: Attributes copy to all existing products
             } elseif (isset($pInfo) && is_object($pInfo)) { // product info box contents
               $heading[] = array('text' => '<b>' . tep_get_products_name($pInfo->products_id, $languages_id) . '</b>');
    
               $contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . '&action=new_product') . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . '&action=delete_product') . '">' . tep_image_button('button_delete.gif', IMAGE_DELETE) . '</a> <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . '&action=move_product') . '">' . tep_image_button('button_move.gif', IMAGE_MOVE) . '</a> <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . '&action=copy_to') . '">' . tep_image_button('button_copy_to.gif', IMAGE_COPY_TO) . '</a>');
               $contents[] = array('text' => '<br>' . TEXT_DATE_ADDED . ' ' . tep_date_short($pInfo->products_date_added));
               if (tep_not_null($pInfo->products_last_modified)) $contents[] = array('text' => TEXT_LAST_MODIFIED . ' ' . tep_date_short($pInfo->products_last_modified));
               if (date('Y-m-d') < $pInfo->products_date_available) $contents[] = array('text' => TEXT_DATE_AVAILABLE . ' ' . tep_date_short($pInfo->products_date_available));
               $contents[] = array('text' => '<br>' . tep_info_image($pInfo->products_image, $pInfo->products_name, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '<br>' . $pInfo->products_image);
               $contents[] = array('text' => '<br>' . TEXT_PRODUCTS_PRICE_INFO . ' ' . $currencies->format($pInfo->products_price) . '<br>' . TEXT_PRODUCTS_QUANTITY_INFO . ' ' . $pInfo->products_quantity);
               $contents[] = array('text' => '<br>' . TEXT_PRODUCTS_AVERAGE_RATING . ' ' . number_format($pInfo->average_rating, 2) . '%');
    // BOF: Attributes copy existing to existing
    // WebMakers.com Added: Copy Attributes Existing Product to another Existing Product
               $contents[] = array('text' => '<br>' . tep_image(DIR_WS_IMAGES . 'pixel_black.gif','','100%','3'));
               $contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . '&action=copy_product_attributes') . '">' . 'Products Attributes Copier:<br>' . tep_image_button('button_copy_to.gif', 'Copy Attributes') . '</a>');
               if ($pID) {
                 $contents[] = array('align' => 'center', 'text' => '<br>' . ATTRIBUTES_NAMES_HELPER . '<br>' . tep_draw_separator('pixel_trans.gif', '1', '10'));
               } else {
                 $contents[] = array('align' => 'center', 'text' => '<br>Select a product to display attributes');
               }
    //EOF: Attributes copy existing to existing


  5. Hi again... I still can't see where I need to add the products_msrp field into her code. I can see an earlier query, that includes it, but here queries for copying don't call all the fields that are being copied individually. I'll show you a couple examples:

     
    $sql_data_array = array
    ('products_quantity' => tep_db_prepare_input($HTTP_POST_VARS['products_quantity']),
    'products_model' => tep_db_prepare_input($HTTP_POST_VARS['products_model']),
    'products_price' => tep_db_prepare_input($HTTP_POST_VARS['products_price']),
    'products_msrp' => tep_db_prepare_input($HTTP_POST_VARS['products_msrp']),
    'products_date_available' => $products_date_available,
    'products_weight' => tep_db_prepare_input($HTTP_POST_VARS['products_weight']),
    'products_status' => tep_db_prepare_input($HTTP_POST_VARS['products_status']),
    'products_tax_class_id' => tep_db_prepare_input($HTTP_POST_VARS['products_tax_class_id']),
    'manufacturers_id' => tep_db_prepare_input($HTTP_POST_VARS['manufacturers_id']), 
    'disable_addtobasket' => tep_db_prepare_input($HTTP_POST_VARS  'disable_addtobasket']));
    

     

    The products_msrp is referenced several times in the file.

     

    However... the code used for the contribution looks like this:

    ///////////////////////////////////////////////////////////////////////////////////////
    // BOF: WebMakers.com Added: Copy Attributes Existing Product to another Existing Product
         case 'create_copy_product_attributes':
     // $products_id_to= $copy_to_products_id;
     // $products_id_from = $pID;
           tep_copy_products_attributes($pID,$copy_to_products_id);
           break;
    // EOF: WebMakers.com Added: Copy Attributes Existing Product to another Existing Product
    ///////////////////////////////////////////////////////////////////////////////////////
    ///////////////////////////////////////////////////////////////////////////////////////
    // WebMakers.com Added: Copy Attributes Existing Product to All Existing Products in a Category
         case 'create_copy_product_attributes_categories':
     // $products_id_to= $categories_products_copying['products_id'];
     // $products_id_from = $make_copy_from_products_id;
     //  echo 'Copy from products_id# ' . $make_copy_from_products_id . ' Copy to all products in category: ' . $cID . '<br>';
           $categories_products_copying_query= tep_db_query("select products_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id='" . $cID . "'");
           while ( $categories_products_copying=tep_db_fetch_array($categories_products_copying_query) ) {
             // process all products in category
             tep_copy_products_attributes($make_copy_from_products_id,$categories_products_copying['products_id']);
           }
           break;
    // EOF: WebMakers.com Added: Copy Attributes Existing Product to All Existing Products in a Category
    ///////////////////////////////////////////////////////////////////////////////////////
    

     

    There is a lot of new code for her contibution, for different copy functions that are added... but as I said... I just can't find an array, or spot in the new code to add that products_msrp field.

     

    I really didn't think it wouldn't be that tough to find. :blink:

     

     

     

    The of the first part is products_largeimage, products_msrp so it would go after 'retangular_lg.jpg',. The value would comefrom an earler line where the database was read in. Or, if that section of doesn't need to update that value, products_msrp can be deleted from the first part.

     

    Jack


  6. Thanks JackMCS,

     

    You have helped me numerous time in the past as far back as a couple years ago. I always appreciate it! :)

     

    I already new what field was causing the problem... I just can't figure out where in the contibution I need to add the missing code for that field. I assume it is somewhere on the catagories.php page (Where the error occurs) but I've gone up & down the code, and can't find it. (Then again it was almost 2am... and I'd been working all day!)

     

    Would you take a look at code on the page and see what you think... or could it be in her function file or javascript? I can paste my categories.php if you'd like. I looked for an area where the fields are listed, but just don't see it!

     

    Thanks again!

     

    The error is saying that the number of these (13)
    (products_quantity, products_model,products_image, products_mediumimage,products_largeimage, products_msrp, products_price, products_date_added,products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id)

    don't match these (12)

    values('0', '', 'retangular_sm.jpg', 'retangular_md.jpg', 'retangular_lg.jpg', '92.5200',now(), null, '0.00', '0', '1', '0')

    It looks like it is the products_msrp but you will need to figure that out and add it.

     

    Jack


  7. Hey All,

     

    I'm building a new store based on my old MS2, and just installed the contribution. (version 5.1b - As it seemed the best fit date wise)

     

    I have an error, I know what it's from, but can't find the code to repair. I have a field in the database, that this contribution doesn't look for, so I need to add it to a query, or function. Here's the error:

     

    1136 - Column count doesn't match value count at row 1
    
    insert into products (products_quantity, products_model,products_image, products_mediumimage,
    products_largeimage, products_msrp, products_price, products_date_added,
    products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id)
    values('0', '', 'retangular_sm.jpg', 'retangular_md.jpg', 'retangular_lg.jpg', '92.5200',
    now(), null, '0.00', '0', '1', '0')
    
    [TEP STOP]

     

    It is on the admin/catagories.php file, when you try to copy a product. The field causing the problem is 'products_msrp' which I can see is missing from the values it tried to paste.

     

    Anyone take a look at this? I can post the entire catagories.php if needed. I've gone over it, and can't find where I need to add the 'products_msrp' field in.

     

    Thanks! :)

     

    PS... not a lot of action in this thread anymore! There must be a newer contribution huh?


  8. OK... Quick question. I also have "Purchase without account" on the site. It appears when someone has created an account the transaction goes through correctly. However, if someone tries to use paypal as payment method without creating an account, when they submit the order... it shows an error where they need the address to match their paypal address.

     

    From a cutomers standpoint, if they used their actual paypal account address, but tried to checkout without creating an account on my site... this would be confusing.

     

    Is there a workaround for this, or should I just make a note that for paypal payments, they need to create an account on my site?

     

    Thanks again in advance.


  9. Thanks.. I logged into the sandbox first... and it appears OK.

     

    Let the testing begin! :)

     

     

    From what I understand you must be logged into to developer central for the sandbox testing to work. You were taken to the login page only because you were not logged in.

  10. OK All,

     

    I have just installed the Paypal v2.3.3 on my modded MS2 site. I have signed up for the paypal sandbox, and have all the admin config settings correct.

     

    As a customer logged into an account, I added products and chose Paypal as the payment method... took me through the checkout screens to order verification.

     

    When I clicked submit, it bounced me to a login page for the paypal sandbox. I never saw any other paypal pages I assume a customer should see. What should happen here? Does the customer log into paypal to complete/submit the order? (From what I've read they have the option to come back to the site or not, and the IPN tracks even if they do not return)

     

    Can someone actually explain what should happen from both a customer standpoint as well as store owner?

     

    Thanks in advance! :)


  11. Hey all,

     

    After unsuccesful attempts to use newer versions of this contribution on my heavily modified MS2 version... I went back to an "OLD" version 0.910 which install seemed to work but with a minor glitch.

     

    I can checkout without creating an account with no problem. The shopping_cart.php file directs to the new "order_info.php" but it seems existing customers my bypass the log-in area.

     

    So I tried to change it to go to account.php - which directs to the login.php page which shows three options, checkout without account, create account or log-in.

     

    The problem is it puts you into an endless loop, after you log-in, where you never actually get to checkout_shipping.php in that config.

     

    Can anyone make a suggestion. I've gone over the threads from that timeframe/version several times... I'm not sure if it is doing something incorrectly, or if there is a mod I missed.

     

    ANy assistance would be great! :)


  12. Hey All...

     

    I am looking for a contribution, and although there are some that are similar I am unable to find anything like this. (After 2+ hours searching contributions!) :blink:

     

    I am sending an e-mail newsletter out, and want to be able to specify say 6 products with special pricing, only valid to those people who get the e-mail. There may be multiple ways to show a special price such as...

     

    A special category where a customer must have a password to a specific directory (That the rest of the world can't see when browsing) which these 6 products show the special price for them. Of course, the same items in my "normal" category need to show the regular price. Without having to be logged in to an account as all customers who get my e-mail may not have created an account in osC.

     

    OR...

     

    The customer can put in a special code supplied in the e-mail on the product page when adding the item to the cart. The cart then shows the special price, and when the order is submitted the special price and code are shown.

     

    I'm sure there may be other ways to do this, but these methods have worked for me in the past with other cart solutions.

     

    Unfortunately I am good at installing the contibutions, I just couldn't make one if my life depended on it!

     

    Any suggestions or contributions come to mind? Anyone willing to take on this challenge? :D


  13. Hey All...

     

    I had installed this mod some time ago, and am now going through my site making sure everything works and there are no bugs. While testing this, I now see two problems I had not noticed before after the initial install and testing.

     

    Hopefully you can point me the right dirrection. I had searched the threadm but come up with 40+ possibilities every time, and even thought I've read many... don't see yet what I need.

     

    SOOOooooo....

     

    Issue #1)

    If a person tries to redeen a discount coupon that has already been redeemed, there is no error or any type of message. It just keeps popping back to the payment screen. Should there be an error message? And if it's not already built in... how can we add one so the customer knows what is happening?

     

    Issue #2)

    When redeeming a gift voucher... Ooopppssss.... Nevermind #2! :0 Looks like the above is the only problem I see.

     

    Any suggestions? Thanks in advance!


  14. OK Folks...

     

    I got it going. After spending several hours going through every post in this thread, and then changing the pages multiple times, and even doing a complete restore and starting over... the tracking page would never show up.

     

    I am having to assume it was due to html in the /catalog/tracking.php page not being happy with STS. What I ended up doing was taking another osCommerce page, deleting the main body content, and then placing the code from the original tracking.php contibution into my new page. WAAALLLAAAAA!! It worked. I renamed my page tracking.php and everything is good.

     

    So just a recap in case anyone else has this issue, I had no problems with installation, the admin part, or the popup part... and tracking actually worked. But, if I clicked the link in the info box to "track package" the page would come up blank. I tried several variations of the "ob_start()" methods described in the thread previously, but none of these worked. I could make the logo, and page load if I "broke" the php code on the page... but it did not show the header or left/right columns.

     

    I knew it wasn't a Curl issue, because I wasn't even getting that far... the page just would not load. ( it looked like as previosly described a blank in the "middle" of the page where the content should have been)

     

    To fix, I placed the catalog/tracking.php code included in the contibution into another page which was working with my STS enabled store, and the page now displays properly. Tracking works, and all is good!

     

    See Ya! :thumbsup:

     

    OK... I try adding ob_start(); and ob_end_flush(); to the file in /classes/tracking.php but when I do, it places the UPS tracking box at the very top of the page, above everything else. The actual tracking does nothing when I try to track a package from there.  If I move the ob_start(); to a different area on the page (such as just before the table starts) it does not show up anywhere.

     

    OK... thats it for now... looking forward to any input!


  15. OK... I try adding ob_start(); and ob_end_flush(); to the file in /classes/tracking.php but when I do, it places the UPS tracking box at the very top of the page, above everything else. The actual tracking does nothing when I try to track a package from there. If I move the ob_start(); to a different area on the page (such as just before the table starts) it does not show up anywhere.

     

    OK... thats it for now... looking forward to any input!

     

    OK Folks,

     

    I was able to get this installed, and partially working.  One thing I found, is I am not sure what should have been edited in xmldocuments.php so it was not changed.

     

    I am able to add tracking numbers in admin, and when logged in as a customer click on "track" to get the popup with the tracking info, which works,  but if I click track order from the info box I get the blank area for tracking.php

     

    When originally installed I had not yet placed my UPS info into the correct fields, and partially saw the page.  But after correcting the info... just a blank on tracking.php

     

    Any suggestions where to start?  AND/OR what changes should have been made to xmldocuments.php ?

     

    Thanks in Advance!


  16. OK Folks,

     

    I was able to get this installed, and partially working. One thing I found, is I am not sure what should have been edited in xmldocuments.php so it was not changed.

     

    I am able to add tracking numbers in admin, and when logged in as a customer click on "track" to get the popup with the tracking info, which works, but if I click track order from the info box I get the blank area for tracking.php

     

    When originally installed I had not yet placed my UPS info into the correct fields, and partially saw the page. But after correcting the info... just a blank on tracking.php

     

    Any suggestions where to start? AND/OR what changes should have been made to xmldocuments.php ?

     

    Thanks in Advance!


  17. Looks like we're missing some data from the instructions... I get errors because I am missing a reference to osc_suite_more

     

    I installed the contribution from Amphitryon as well thinking the whole contibution may coorect it... but it doesn't. It just creates the same error on other pages. Anyone know what I need to do to add a osc_suite_more function?

     

    Thanks in advance.

     

    Let me edit and say that I did have the original 2.4v working fine. I just wanted to add the "read more" link.


  18. Thanks JanZ... I was just coming back to post I found it in the admin configuration when I saw your post.

     

    It is under Tare weight under shipping/packaging in the configure area. Also the Percentage increase for larger packages also effects the weight.

     

     

    I'll see what I can figure out for the weight display.... I'd Also like to get rid of the time in transit.

     

    Thanks. :thumbsup:

     

    PS, yoo to pickup man! You posted the same time I was typing!


  19. Hey All,

     

    I have a couple quick (Hopefully) Items to ask. I browsed through most of the thread, and didn't see an answer for either.

     

    I was able to sucessfully install this with no errors, and it appears to work with one glitch.

     

    UPSXML is automatically adding 3lbs. to every order. I.E. if the item is .1 lbs, it shows 3.1lbs. If it is 10lbs. it shows 13lbs. I checked the admin config and didn't see what I could change that would correct this....

     

    Also can someone suggest what to edit to remove the shown weight on the checkout_shipping page (after I get this corrected)?

     

    Thanks in advance! :D


  20. HHhmmmm....

     

    Here is a curious issue. If it was mentioned earlier I missed it. I was not having the problems mentioned with the sessions, or attributes. Everything seemed to be working fine. But here is the problem I now encounter....

     

    When you send the wishlist to a friend and include a personal note... everything is fine when the recipient gets the e-mail. BUT... if you DO NOT include a personal note, the wishlist contents ARE NOT shown in the recipients e-mail.

     

    Anyone have any suggestions or seen this before? Suggestions on how to fix this issue?

     

    Thanks in advance!


  21. Ahhhh...

     

    Thanks for the explaination. That clears things up for me. ( at least for now! :thumbsup: ) Great job, I know you've made many people happy with this contribution!

     

    Yes. Inventory is tracked normally in Quickbooks for sales of Inventory items. It doesn't matter if the invoice is paid or not.

     

    If you have inventory turned on in osC, you'll need to set the stock level to match what's in Quickbooks. So, if stock is 50 units in osC and QB, when you make a sale of two pieces and import it with QBI, then both will show 48 pieces. But if the count starts with 40 in osC and 50 in Quickbooks, then you'll end up with 38 and 48. So, the number of units sold stays on track, but you need to make sure that the starting inventory count is the same in both osC and QBI, because QBI does not do any transfer of the total inventory information.

     

    Just to clarify the payments options (I will explain all the options in a future revision of the manual, but a lot of people were clamouring for me to get version 1.00 released, so I didn't get this part explained fully yet).

     

    Import payments with Invoice: If you do credit card sales with an online gateway, like Authorize.net, turn this on. If you do credit card sales, but process the credit card manually later, then turn it off and record your payments in Quickbooks later when you process the card or use the QB Merchant account.

     

    Import CC payments as Sales Receipt: If you use a gateway, check this and any paid CC sales will import as sales receipts instead of invoices and payments. This is better, because you don't have to manually check off which invoice is paid. Note, if you choose this feature, then "Import Payments with Invoice" is over-ridden.

    No questions are dumb.

     

    Thanks,

    Adam


  22. Thanks for the reply Adam...

     

    So let me clarify. When QBI "Imports payments with invoices or as sales receipts" or "Imports new invoices and new customers in one iif file" does not Quickbooks alter the inventory from these invoices or receipts?

     

    Sorry if these seem dumb, but since I don't have actual hands-on Quickbooks time, I'm trying to determine the "flow".

     

    Thanks again.

     

    QBI allows you to export all your osC products into Quickbooks.

     

    It does not let you add Quickooks products directly to osC, but does let you match your QB products to those that are already in osC.

     

    QBI does not deal with the inventory count, and does not export the current osC inventory count into Quickbooks. Inventory may be added in a future version of QBI.

     

    If all your sales are through your online store, you can set the inventories in QB and osC to match, and then they should both stay in sync as each system will deduct inventory for each sale.

     

    - Adam

×