Peper

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

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;

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

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

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

@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

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;

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.

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?

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

Hi @raiwa Please explain for the wholesaler groups not to be able to use discount coupons. The margin on wholesale is obvious to be at minimal level. I had disable coupon codes on my side Thanks

I see Google tag changed Global tag in header: <!-- Global site tag (gtag.js) - Google Ads: your tag number --> <script async src="https://www.googletagmanager.com/gtag/js?id=AW-your tag number"></script> <script> window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} gtag('js', new Date()); gtag('config', 'AW-your tag number'); </script> and also to add recommended event snippet: <script> gtag('event', 'page_view', { 'send_to': 'AW-your tag number', 'value': 'replace with value', 'items': [{ 'id': 'replace with value', 'google_business_vertical': 'retail' }] }); </script> Anyone done an update on this?

Hello Dominic How to add to frozen version? I tried but was not showing up? Also this seems practical, however is to keep showing all the sub categories instead of leading a customer to one sub category point. If anyone done this on edge please let me know, thanks

Demo sites always looks better - minimal functionality, clean and fast - the perfect cart or not? Lets add like a thousand products, couple categories, bit of customization, couple of enhancements. I doubt it will perform as the demo. As a novice in coding, oScommerce was the best option, the easiest, most free available and usable add ons. With the newest ce version for me is running really fast, if it is slow - change to a better service provider(my own experience). I always say its what's happening in the background that makes sense, users browsing your site does not see the master piece behind the curtains, the science to have a proper working site. You will always need custom coding and changes. There are a couple of very good talented developers here, keep up the excellent work! You are using oscommerce, a 24hr salesman for you, does not rest or gets tired, you have a business to take care of, dealing with customers is the most difficult part. The customer part is where most fail! So support oScommerce developers, they can build you a dream.

Thanks Phil This dir file checking is now working perfect without spewing out errors, i will change all files with this code to yours. When saving, the selected file options was not being saved However, i found ckeditor interfered here. Once ckeditor was disabled i was able to select files and save correctly.