Jump to content

Peper

Members
  • Content count

    540
  • Joined

  • Last visited

Everything posted by Peper

  1. 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 '&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 '&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 &
  2. Hello @auzStar All working perfectly with Edge version, with new phoenix version not at all so far - search bar only gives "No matches" Tried even to hook js to sitewide\jquery Any recommendations? Thx
  3. Peper

    Wholesale (SPPC lite)

    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?
  4. Same issue here but not so intensive as other users are describing it. Using Recaptcha in create_account In admin/customers.php i have modified the search Mostly the spammers uses companies like google - easier to track down and deleted many - hth <?php $search = ''; if (isset($_GET['search']) && tep_not_null($_GET['search'])) { $keywords = tep_db_input(tep_db_prepare_input($_GET['search'])); $search = "where c.customers_lastname like '%" . $keywords . "%' or c.customers_firstname like '%" . $keywords . "%' or c.customers_email_address like '%" . $keywords . "%' or a.entry_company like '%" . $keywords . "%' or c.customers_telephone like '%" . $keywords . "%'"; }
  5. Peper

    Automatically send data feed to Froogle

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

    Automatically send data feed to Froogle

    @DAVID3733 Strange, that must have been added later on, i see nothing my side to option 3 Looks like good fix rather using the db tax than i hardcoded
  7. Peper

    Automatically send data feed to Froogle

    Tip: Setting up cronjob was problematic Changed in beginning of file chdir('../'); to full server root chdir('/usr/www/users/yourservernamehere/');
  8. Peper

    Automatically send data feed to Froogle

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

    Automatically send data feed to Froogle

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

    [Addon} Theme Switcher

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

    [Addon} Theme Switcher

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

    [Addon} Theme Switcher

    Will this still work with the new Phoenix version?
  13. Peper

    QRCode in admin invoices

    Getting late and confusing Barcodes to be scanned Serials to be read with human eye and entered manually In a few hours i will have serial for breakfast
  14. There is a app that adds qrcode to invoice and packingslip https://apps.oscommerce.com Anyone knows what data this qrcode is suppose to show on scan? For me only gives: BEGIN:VCARD FN: END:VCARD Was hoping it gives the order url at least Anyone using this?
  15. Peper

    QRCode in admin invoices

    No, not that way Just product serials to be added before packaging I added below so that url ends with orders.php?page=1&oID=12339&action=qr_device_insert the updating and insert into database not happening - page refresh though to bring me back to orders.php?page=1&oID=12339&action=edit_order (showing all previous orders list) case 'qr_device_insert': $oID = tep_db_prepare_input($_GET['oID']); $comments = tep_db_prepare_input($_POST['comments']); $order_updated = false; $check_status_query = tep_db_query("select customers_name, customers_email_address, orders_status, date_purchased from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'"); $check_status = tep_db_fetch_array($check_status_query); tep_db_query("insert into " . TABLE_ORDERS_STATUS_HISTORY . " (orders_id, date_added, comments) values ('" . (int)$oID . "', now(), '" . tep_db_input($comments) . "')"); $order_updated = true; if ($order_updated == true) { $messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success'); } else { $messageStack->add_session(WARNING_ORDER_NOT_UPDATED, 'warning'); } tep_redirect(tep_href_link('c.php', tep_get_all_get_params(array('action')) . 'action=edit_order')); break;
  16. Peper

    QRCode in admin invoices

    So on the packingslip there is a different qr code that will take me to edit order and add serials - works then finished scan the screen which is easier, there will be the save button also.(makes life simpler) This qrcode on screen needs to be scanned to save order once serials were entered
  17. Peper

    QRCode in admin invoices

    @fridgebox Ja maar wag nou What to do with? if (tep_not_null($action)) { switch ($action) { case 'qr_device_insert':
  18. Peper

    QRCode in admin invoices

    adding comments is this link http://127.0.0.1/edge/admin/order.php.php?page=1&oID=12346&action=edit or <?php echo tep_href_link(orders.php?page=1&'. 'oID=' . $_GET['oID'] . 'action=edit'); ?> what is the to save link: ??? @fridgebox
  19. Peper

    QRCode in admin invoices

    @fridgebox Most serials can be scanned, but some is just like 5 digits code This problem is the update button: <?php echo tep_draw_button(IMAGE_UPDATE, 'disk', null, 'primary'); ?> In order.php - im stuck with the update button to convert to qrcode
  20. 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;
  21. Peper

    QRCode in admin invoices

    Hello @fridgebox Thanks for replying. "You cannot say it not work, just like that." - indeed not working for me. I switched to another app though and is working generating urls as expected. However what i want to accomplish is not so easy after careful examination of the entire operation. What i need to do is print packaging slip, on there is added qr code At packaging station we need to take down serial numbers(multiple) for items whether scanned or manually typed in This is currently been done by writing them down on the packaging slip manually To speed up the process i was thinking to add a 2d scanner to scan the bar codes for the items. However when human intervention comes into play with digital errors can be made ie like selecting and scanning serials into wrong order, accidentally delete an order and so The packaging staff does not need to have full access to an order - just edit comments, add serials and save. This is now where the hard part comes in. without further human intervention apart from holding scanner in hand and scanning qr code codes: scan qrcode on packing slip to open order for adding comments(action=edit) once open scan serials when done scan second code on packing slip to save comments(&action=update_order) rinse and repeat This sequence stomped me - scanning qrcode browser opens order address, focus curser to comments, save part, then back to address bar I'm not sure if there are any users here that uses a much simpler approach - if so pls advice.
  22. Peper

    Wholesale (SPPC lite)

    Thanks @raiwa Tested, working perfect You should actually add this as an option in the admin sppc module
×