Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Peper

Members
  • Posts

    611
  • Joined

  • Last visited

Posts posted by Peper

  1. @Jack_mcs

    Thanks Jack, that was close enough for me

    <?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . '&nbsp;' . tep_draw_textarea_field($field['field_name'] . '[' . (int)$field['language_id'] . ']', 'soft', 30, 5, $field['field_value']) . '&nbsp; ' . $languages[$field['language_id']-1]['name']; ?>

  2. @Jack_mcs

    Old but gold, please help.

    in categories.php, the input box to text box - how to?

    tep_draw_input_field($field['field_name'], $field['field_value']);
    to 
    tep_draw_textarea_field with box size specified

    Also not to remove html and retain new lines when saving - using table products_description and updated the new field to varchar 512

  3. Google warnings not going away

    Error is Mismatched [price] (page crawl)

    This comes in pricing showing excl Tax on site, the googlefeeder.txt is calculated including Tax
    Google bot is crawling site excluding Tax
    Google reports Mismatched [price]

    Web is setup to show pricing excluding tax in admin with tax rates 0% and 15%

    What needs to be done?

  4. Anyone got this working on Phoenix?
    I have updated the deprecated code
    Fedex installed

    Using my old admin/order.php file into ce it works perfect no errors

    These 2 edits seems to be problem

              <!-- tracking_module form -->
              <?php $tracking->display_form(); ?>
              <!-- end tracking_module form -->

    and 

          <!-- tracking_module noscript -->
          <?php $tracking->display_no_js(); ?>
          <!-- end tracking_module noscript -->

    Any ideas?

  5. Absolutely strange

    I setup a new phoenix install with the autocomplete search and is working(local pc)
    Compared page sources and almost a match except well for https and few little things

    Diffrence found :
    The working one have '&amp;search_in_description=1'
    the non working one '&search_in_description=1'

    In file ht-twitter-typeahead.js.php 
    I changed '&search_in_description=1\'  to read '&amp;search_in_description=1\'
    Now search is working correctly

    but even so, my working live site = &search_in_description=1 and works perfectly - same server

    I'm not so sure the problem was corrected this way changing & to &amp;
     

  6. Thanks for update

    I have a question.

    in includes/modules/product_listing_ws.php you specified schema example itemscope itemtype="https://schema.org/Offer

    With Phoenix there is a header tags module breadrumb and product JSON-LD that already does this.

    Is the schema still needed in product_listing_ws?

  7. 18 minutes ago, Jack_mcs said:

    You can turn the expiration date off. It is only useful if you are submitting products that will expire in less than 30 days. That probably won't fix the problem but may help you find it. You have to determine what data is missing. You can usually do that by looking at the contents of each column. For example, if the column is for price and it shows a date, then the price data is missing.

    This is not correct. The option 2 is handled in a different part of the code.

    The missing part was tax for each product
    The tax is calculating correctly

          if (OPTIONS_ENABLED_INCLUDE_TAX == 2) {
              $db_query = tep_db_query("select tax_rate from " . TABLE_TAX_RATES . " where tax_rates_id = " . (int)$row->tax_id);

    ............

    So now you have:

       if(OPTIONS_ENABLED_INCLUDE_TAX == 1 || OPTIONS_ENABLED_INCLUDE_TAX == 2) $output .= "\ttax";
       if(OPTIONS_ENABLED_UPC == 1)                 $output .= "\tupc";
       if(OPTIONS_ENABLED_WEIGHT == 1)              $output .= "\tshipping_weight";

    1st line will show tax heading - TAX == 1 and 2

    but then here:

             if(OPTIONS_ENABLED_INCLUDE_TAX == 1)
                $output .= "\t" . OPTIONS_TAX_STRING;
             if(OPTIONS_ENABLED_UPC == 1)
                $output .= "\t" . (isset($row->upc) ? $row->upc : (strlen(OPTIONS_UPC) ? OPTIONS_UPC : "Not Supported"));
             if(OPTIONS_ENABLED_WEIGHT == 1)
                $output .= "\t" . $row->prodWeight . ' ' .OPTIONS_WEIGHT_ACCEPTED_METHODS;

    only TAX==1
    the tax heading is shown but no output for each product TAX==2

    added TAX==2
             if(OPTIONS_ENABLED_INCLUDE_TAX == 2)
                $output .= "\t" . OPTIONS_TAX_STRING;

  8. Correct me if i'm wrong:

       if(OPTIONS_ENABLED_INCLUDE_TAX == 1 || OPTIONS_ENABLED_INCLUDE_TAX == 2) $output .= "\ttax";

    if option is a 1 or 2 - tax is shown.

    below only option 1 is output but not 2
             if(OPTIONS_ENABLED_INCLUDE_TAX == 1)
                $output .= "\t" . OPTIONS_TAX_STRING;


    added 2nd part for custom tax to show

             if(OPTIONS_ENABLED_INCLUDE_TAX == 2)
                $output .= "\t" . OPTIONS_TAX_STRING;

  9. Trying out this module

    After many hrs, still no stuck

    The txt file created there is a missing tab between expiration_date and model  - gmc is refusing the feed - Too many column delimiters

    link	title	description	price	image_link	id	availability	brand	condition	currency	expiration_date	model	shipping	tax	shipping_weight

      the tab is specified in below

             if(OPTIONS_ENABLED_EXPIRATION == 1)
                $output .= "\t" . $feed_exp_date;
             if(OPTIONS_ENABLED_PRODUCT_MODEL == 1)
                $output .= "\t" . (! empty($row->prodModel) ? $row->prodModel : $row->catName);

    How to fix?

    Anyone who has current working example, please share 

    Also @Jack_mcs

    Is these values correct for 15% VAT:

    define('OPTIONS_SHIPPING_STRING', 'ZA:Ground:95.00:yes'); //says charge shipping to US for residents of Florida at 5% and don't apply tax to shipping

    define('OPTIONS_TAX_RATE' , '15'); //default = 0 (e.g. for 20.0% tax use "$taxRate = 20.0;")  //only used in the next line
    define('OPTIONS_TAX_CALC', (OPTIONS_ENABLED_INCLUDE_TAX == 2 ? (OPTIONS_TAX_RATE/100) + 1 : '1')); //UK. US tax rate - US is ignorded since it is 1

    Please have a look

  10. 15 hours ago, JcMagpie said:

    Have not used the switcher for some time but it should still work.

     

    Yes but Phoenix pulls Boostrap from CDN now but if you download and install localy and change link to your install path will work fine.

    see file

    public_html/includes/hooks/shop/siteWide/bootStrap.php

    @JcMagpie

    Thanks, gave it a try already. For now will have to use an alternative.

  11. 9 hours ago, JcMagpie said:

    Try this lest you make color changes in admin.

    I tried the color tweak, works great.
    Takes me a while to figure out what color goes where

    Was using the theme switcher for promotional days even for black Fridays to switch the theme easily. <_<

     This part seems is issue for phoenix

    <?php if ( !defined ( MODULE_HEADER_TAGS_THEME_SWITCHER_STATUS ) ||
    MODULE_HEADER_TAGS_THEME_SWITCHER_STATUS != 'True' ); { ?>
    <link href="ext/bootstrap/css/bootstrap.min.css" rel="stylesheet">
    <?php } ?>

     

  12. Old post though

    See following
    You will need to find and match similar code to insert tax id
    Backup first

    ---------------------
    account_edit.php


       if ($error == false) {
        $check_entry_company_tax_id_query = tep_db_query("select entry_company_tax_id from customers where customers_id = '" . (int)$customer_id . "'");
        $check_entry_company_tax_id = tep_db_fetch_array($check_entry_company_tax_id_query);
            
          $sql_data_array = array('customers_firstname' => $firstname,
                                  'customers_lastname' => $lastname,
                                  'customers_email_address' => $email_address,
                                  'customers_telephone' => $telephone,
                                  'customers_fax' => $fax,
               'entry_company_tax_id' => $tax);

          if (ACCOUNT_GENDER == 'true') $sql_data_array['customers_gender'] = $gender;
          if (ACCOUNT_DOB == 'true') $sql_data_array['customers_dob'] = tep_date_raw($dob);

        if (ACCOUNT_COMPANY == 'true') {
          if (isset($_POST['company_tax_id']) && tep_not_null($_POST['company_tax_id']) && !tep_not_null($check_entry_company_tax_id['entry_company_tax_id'])) {
            $sql_data_array['entry_company_tax_id'] = tep_db_prepare_input($_POST['company_tax_id']);
          }
        }


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

      $account_query = tep_db_query("select customers_gender, customers_firstname, customers_lastname, customers_dob, customers_email_address, customers_telephone, customers_fax, entry_company_tax_id from customers where customers_id = '" . (int)$customer_id . "'");
      $account = tep_db_fetch_array($account_query);

      $breadcrumb->add(NAVBAR_TITLE_1, tep_href_link('account.php', '', 'SSL'));


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

          <?php echo tep_draw_input_field('fax', $account['customers_fax'], 'id="inputFax" placeholder="' . ENTRY_FAX_NUMBER . '"'); ?>
        </div>
      </div>
      
      <?php

       if (ACCOUNT_COMPANY == 'true') { 
    ?>
      <div class="form-group">
        <label for="inputTax" class="control-label col-sm-3"><?php echo ENTRY_COMPANY_TAX_ID; ?></label>
        <div class="col-sm-9">
          <?php echo  tep_draw_input_field('tax', $account['entry_company_tax_id'], 'id="inputTax" placeholder="' . ENTRY_COMPANY_TAX_ID_TEXT . '"'); 
                              } else {
                        echo $account['entry_company_tax_id'];
                        }  ?>
        </div>
      </div>
      <?php
        if ($account['entry_company_tax_id'] > 0) {
    ?>

        <div class="col-xs-12"><?php echo TEXT_UPDATE_COMPANY_NAME_ENTRIES . tep_draw_button(IMAGE_BUTTON_ACCOUNT_ADDRESS_BOOK, 'far fa-address-book', tep_href_link('address_book.php', '', 'SSL')); ?></div>
        
      <?php   }  ?>


    -------------------------------------------
    create_account.php


          if (ACCOUNT_DOB == 'true') $sql_data_array['customers_dob'] = tep_date_raw($dob);


          if ( ACCOUNT_COMPANY == 'true' && tep_not_null($company_tax_id)  ) {
          $sql_data_array['entry_company_tax_id'] = $company_tax_id; 
        }
          
          tep_db_perform(TABLE_CUSTOMERS, $sql_data_array);


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


            <?php
            echo tep_draw_input_field('company', NULL, 'id="organization" placeholder="' . ENTRY_COMPANY_OR . '"');
            if (tep_not_null(ENTRY_COMPANY_TEXT)) echo '<span class="help-block">' . ENTRY_COMPANY_TEXT . '</span>';
            ?>
    <!-- BOF field for tax id number -->
            <?php
            echo tep_draw_input_field('company_tax_id', NULL, 'id="organization-title" placeholder="' . ENTRY_COMPANY_TAX_ID_OR . '"');
            if (tep_not_null(ENTRY_COMPANY_TAX_ID_TEXT)) echo '<span class="help-block">' . ENTRY_COMPANY_TAX_ID_TEXT . '</span>';
            ?>
    <!-- EOF field for tax id number -->


    -----------------------------
    includes\languages\english.php  (and other languages)
    add


    define('ENTRY_COMPANY_TAX_ID', 'Company\'s TAX number:');
    define('ENTRY_COMPANY_TAX_ID_ERROR', '');
    define('ENTRY_COMPANY_TAX_ID_TEXT', '');


    -------------------------------
    includes\languages\create_account.php
    add

    define('ENTRY_COMPANY_TAX_ID_OR', 'Company\'s VAT number or leave empty');

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

    admin\customers.php

    $entry_country_id = tep_db_prepare_input($_POST['entry_country_id']);
    $entry_company_tax_id = tep_db_prepare_input($_POST['entry_company_tax_id']);
    $entry_company = tep_db_prepare_input($_POST['entry_company']);


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

            $sql_data_array = array('customers_firstname' => $customers_firstname,
                                    'customers_lastname' => $customers_lastname,
                                    'customers_email_address' => $customers_email_address,
                                    'customers_telephone' => $customers_telephone,
                                    'customers_fax' => $customers_fax,
                                    'customers_notes' => $customers_notes,
                                    'customers_newsletter' => $customers_newsletter,
                                    'customers_wholesale' => $customers_wholesale,

            'entry_company_tax_id' => $entry_company_tax_id);
     

            if (ACCOUNT_GENDER == 'true') $sql_data_array['customers_gender'] = $customers_gender;

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

              $customers_query = tep_db_query("select c.customers_id, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_street_address_2, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.entry_company_tax_id, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_wholesale, c.customers_default_address_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '" . (int)$_GET['cID'] . "'"); 

            $customers = tep_db_fetch_array($customers_query);
            $cInfo = new objectInfo($customers);


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

            <td colspan="2" class="formAreaTitle"><?php echo CATEGORY_COMPANY; ?></td>
          </tr>
          <tr>
            <td colspan="2" class="formArea"><table border="0" cellspacing="2" cellpadding="2">
              <tr>
                <td class="main"><?php echo ENTRY_COMPANY; ?></td>
                <td class="main">
    <?php
        if ($error == true) {
          echo $cInfo->entry_company . tep_draw_hidden_field('entry_company');
        } else {
          echo tep_draw_input_field('entry_company', $cInfo->entry_company, 'maxlength="64"');
        }
    ?></td>
              </tr>
              <tr>
                <td class="main"><?php echo ENTRY_COMPANY_TAX_ID; ?></td>
                <td class="main">
    <?php
        if ($error == true) {
          if ($entry_company_tax_id_error == true) {
            echo tep_draw_input_field('entry_company_tax_id', $cInfo->entry_company_tax_id, 'maxlength="32"') . '&nbsp;' . ENTRY_COMPANY_TAX_ID_ERROR;
          } else {
            echo $cInfo->entry_company . tep_draw_hidden_field('entry_company_tax_id');
          }
        } else {
          echo tep_draw_input_field('entry_company_tax_id', $cInfo->entry_company_tax_id, 'maxlength="32"');
          }
    ?></td>
              </tr>


    ------------------------
    admin\invoice.php


      include('includes/classes/order.php');
      $order = new order($oID);
      
    $tax_id_query = tep_db_query("select entry_company_tax_id from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$customer_id . "'");
    $company_tax_id=tep_db_fetch_array($tax_id_query);
    $tax_id=$company_tax_id['entry_company_tax_id'];


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

        <td><table border="0" cellspacing="0" cellpadding="2">
          <tr>
            <td class="main"><strong><?php echo ENTRY_PAYMENT_METHOD; ?></strong></td>
            <td class="main" width="200px"><?php echo $order->info['payment_method']; ?></td> 
            <td class="main" width="400px"><strong><?php echo ENTRY_COMPANY_TAX_ID; ?></strong> <?php echo $tax_id; ?></td>


    ---------------------
    admin\orders.php

                    <td class="main"><?php echo tep_address_format($order->customer['format_id'], $order->customer, 1, '', '<br />'); ?>

                  <?php
    $orders_query = tep_db_query("select orders_id, customers_id from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'");
    $customer_id = tep_db_fetch_array($orders_query);
    $orders=$customer_id['customers_id'];
    $customer_id = $orders;

    $tax_id_query = tep_db_query("select entry_company_tax_id from customers where customers_id = '" . (int)$customer_id . "'");
    $company_tax_id = tep_db_fetch_array($tax_id_query);
    $tax_id = $company_tax_id['entry_company_tax_id'];


    ---------------------
    admin\packingslip.php
    add

    $tax_id_query = tep_db_query("select entry_company_tax_id from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$customer_id . "'");
    $company_tax_id=tep_db_fetch_array($tax_id_query);
    $tax_id=$company_tax_id['entry_company_tax_id']; 


    then somewhere add the tax id like:

                <td class="main"><b><?php echo ENTRY_SHIP_TO; ?></b></td>
              </tr>
              <tr>
                <td class="main"><?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br>'); ?></td>
              </tr>
            </table></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
      </tr>
      <tr>
        <td><table border="0" cellspacing="0" cellpadding="2">
          <tr>
            <td class="main" width="300px"><strong><?php if ($tax_id >"1") echo ENTRY_COMPANY_TAX_ID;?></strong> <?php echo $tax_id; ?></td>
            <td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td>
            <td class="main"><?php echo $order->info['payment_method']; ?></td>
          </tr>

    ---------------
    admin\includes\languages\english.php
    add

    define('ENTRY_COMPANY_TAX_ID', 'Company TAX Number:');
    define('ENTRY_COMPANY_TAX_ID_ERROR', '');

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

    with phpmyadmin
    sql
    ALTER TABLE customers ADD entry_company_tax_id varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL;

×
×
  • Create New...