Jump to content

grbicking

Members
  • Content count

    42
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    George
  1. grbicking

    RMA Returns error for 2.2 MS2

    Has anyone found a way to return items from the same order more than once. For example. Customer orders 3 of one item. Customer requests to return 2 items. Then the customer wants to return the final 1 item. But RMA returns doesn't allow this. Has anyone figured out a solution. Thank you
  2. grbicking

    Admin Account Level 2.3

    Here are the two lines, I am thinking that the function dir no longer exists? $dir = dir(DIR_FS_ADMIN); while ($file = $dir->read()) {
  3. I could not find an answer to this anywhere on the forums. When clicking on File Access and then selecting one of the items in the table I get the following error below. All help is appreciated. I am running on windows just in case. It is a clean brand new install.... PHP Warning: dir(c:\Inetpub/wwwroot/store/admin/)[function.dir] failed to open dir:Invalide argument in c:\Inetpub\wwwroot\storecode\admin\admin_files.php on line 235 PHP Fatal Error: Call to a member function on a non-object in c:\Inetpub\wwwroot\storecode\admin\admin_files.php on line 237.
  4. I am using the latest version from the mod section. I am still using 2002, I have no need to go to 2003. If you can't find the version of quickbooks mod let me know. George
  5. <?php /* $Id: qb_iif_sale.php,v 2.0BETA 2003/02/09 11:32:53 VyReN Exp $ Created by Steve K. of Cantexgroup http://www.cantexgroup.ca/ email: support@cantexgroup.ca Modified for Quickbooks 2001 and OSC 2.2 by Tom St.Croix of Better Than Nature http://www.betterthannature.com/catalog/ email: management@betterthannature.com Modified again for OSC 2.2MS1 by Glen Piwowarczyk Modifeied by George R Bicking Please change all signs of NJ sales tax to your state or what you have for tax in quickbooks. Copyright (C) 2002 Steve K. Released under GPL and may be modified. */ $myfile = "/qb/qb_customer_" . date(m) .date(d) . date(y) . ".iif"; // Where will our transaction import file be located? // **** You shouldn't have to touch anything past this point **** $custfile = $DOCUMENT_ROOT . $myfile; // Check if the customer import file exists; $oldfile = file_exists ($custfile); // Open customer import file for appending, create it if necessary; $fp = fopen($custfile,"a"); // Create header line & write it to file if the customer import file did NOT exist previously // This means that everytime you 'import' the file into QB, you must delete it immediately. // This will prevent re-importation AND it will keep the IIF file small. // The header line values can be changed to whatever you need - read the QB IIF docs // for more info. if (!$oldfile) { $line ="!CUSTtNAMEtBADDR1tBADDR2tBADDR3tBADDR4tBADDR5t"; $line.="SADDR1tSADDR2tSADDR3tSADDR4tSADDR5tPHONE1tFAXNUMt"; $line.="CTYPEtTERMStLIMITtFIRSTNAMEtLASTNAMEtEMAILtTAXABLEtTAXITEMtREPtn"; fputs($fp,$line); } // Setup our variables for creating customer record $creditlimit = ""; // the default credit limit for new customers $salesman = "WebSite"; // The "default clerk" in QB. Can also be blank "" $firstname = $HTTP_POST_VARS['firstname']; $lastname = $HTTP_POST_VARS['lastname']; $accnum = $lastname . ", " . $firstname; $street = $HTTP_POST_VARS['street_address']; $city = $HTTP_POST_VARS['city']; $province = tep_get_zone_name($HTTP_POST_VARS['country'], $zone_id, $state); $countryname = tep_get_country_name($HTTP_POST_VARS['country']); $pcode = $HTTP_POST_VARS['postcode']; $phone = $HTTP_POST_VARS['telephone']; $fax = $HTTP_POST_VARS['fax']; $DOB = $HTTP_POST_VARS['dob']; $emailto = $HTTP_POST_VARS['email_address']; $rep = "WEB"; if ($state == 'New Jersey') : $tax = 'Y'; $taxstate = 'NJ Sales Tax'; else: $tax = 'N'; $taxstate = 'Out of State'; endif; // Create the IIF line & write it to the file. If you changed the header line, you // will also need to change these lines to match - read the QB IIF docs for more info $line ="CUSTt$accnumt$firstname $lastnamet$streett$city, $provincet"; $line.="$countrynamet$pcodet$firstname $lastnamet$streett$city, $provincet"; $line.="$countrynamet$pcodet$phonet$faxt$salesmantDue on receiptt$creditlimitt$firstnamet"; $line.="$lastnamet$emailtot$taxt$taxstatet$reptn"; fputs($fp,$line); // Close the customer import file fclose($fp); ?>
  6. I took the quick books mod and made it work with 2002, this includes the customer and sales mod. Each file will be created with a date. Also, the sales works with SALES TAX!!!!! Be sure to replace all areas of NJ SALES TAX... this is the sales mod <?php /* $Id: qb_iif_sale.php,v 2.0BETA 2003/02/09 11:32:53 VyReN Exp $ Created by Steve K. of Cantexgroup http://www.cantexgroup.ca/ email: support@cantexgroup.ca Modified for Quickbooks 2001 and OSC 2.2 by Tom St.Croix of Better Than Nature http://www.betterthannature.com/catalog/ email: management@betterthannature.com Modified again for OSC 2.2MS1 by Glen Piwowarczyk Modified by George R Bicking to work with 2002 pro editions make sure you change all signs of NJ sales tax to your state or what you have as your tax in your quickbooks Copyright (C) 2002 Steve K. Released under GPL and may be modified. */ $myfile = "/qb/qb_sale_" . date(m) .date(d) . date(y) . ".iif"; // Where will our transaction import file be located? $araccount = "Accounts Receivable"; // Our "Accounts Receivable" account $FOB = "NJ"; // Our FOB point for the invoice $terms = "Paid in Full"; // Invoice terms $storename = ".com"; // Your Store Name $memo = "Website Sale"; // Invoice memo $toprint = "Y"; // Y to mark invoice as 'to be printed', N otherwise $cleared = "N"; // Y to mark transaction as cleared, N otherwise $defaultclass = "BTN"; // the default class for the transaction // The individual lines will use the product class // but the entire transaction will use this $paid = "N"; // mark the invoice as paid Y or unpaid N $salesrep = "WEB"; // clerk for the transaction $invtitle = "WEBSITE SALE"; // the 'title' for the invoice. Could be whatever you want // for example LAYAWAY, INVOICE, etc. $Shipping_Account = "Postage and Delivery"; // The account used to post your shipping charges $shipdescription = "Shipping and Handling"; // the shipping description on the invoice $shipitem = "Shipping"; // the QB itemcode for shipping $shiptaxcode = "N"; // Your QB tax code for shipping $productaccount ="Airsoft Sale"; // **** You shouldn't have to touch anything past this point **** // Convert all order data $salefile = $DOCUMENT_ROOT . $myfile; $customers_id = $customer_id; $customers_name = $order->customer['firstname'] . ' ' . $order->customer['lastname']; $customers_street_address = $order->customer['street_address']; $customers_suburb = $order->customer['suburb']; $customers_city = $order->customer['city']; $customers_postcode = $order->customer['postcode']; $customers_state = $order->customer['state']; $customers_country = $order->customer['country']['title']; $customers_telephone = $order->customer['telephone']; $customers_email_address = $order->customer['email_address']; $customers_address_format_id = $order->customer['format_id']; $delivery_name = $order->delivery['firstname'] . ' ' . $order->delivery['lastname']; $delivery_street_address = $order->delivery['street_address']; $delivery_suburb = $order->delivery['suburb']; $delivery_city = $order->delivery['city']; $delivery_postcode = $order->delivery['postcode']; $delivery_state = $order->delivery['state']; $delivery_country = $order->delivery['country']['title']; $delivery_address_format_id = $order->delivery['format_id']; $payment_method = $order->info['payment_method']; $cc_type = $order->info['cc_type']; $cc_owner = $order->info['cc_owner']; $cc_number = $order->info['cc_number']; $cc_expires = $order->info['cc_expires']; $date_purchased = 'now()'; $orders_status = DEFAULT_ORDERS_STATUS_ID; $comments = $order->info['comments']; $currency = $order->info['currency']; $currency_value = $order->info['currency_value']; $total_tax = 0; // First we setup the format of our transaction header, our SPL header, // and our "we're done" lines. These can be changed to suit your requirements, but // read the QB IIF docs for more info. $transaction_header ="!TRNStTRNSIDtTRNSTYPEtDATEtACCNTtNAMEtCLASStAMOUNTt"; $transaction_header.="DOCNUMtMEMOtCLEARtTOPRINTtADDR1tADDR2t"; $transaction_header.="ADDR3tADDR4tADDR5tPAIDtTERMStSHIPVIAtREPt"; $transaction_header.="FOBtINVTITLEtSADDR1tSADDR2tSADDR3tSADDR4tSADDR5tn"; $distribution_line_header ="!SPLtSPLIDtTRNSTYPEtDATEtACCNTtNAMEtCLASStAMOUNTt"; $distribution_line_header.="DOCNUMtMEMOtCLEARtQNTYtPRICEtINVITEMtTAXABLEtEXTRAtn"; $end_header ="!ENDTRNStn"; $end_transaction = "ENDTRNStn"; // Now we setup the info that we need to send to the file $order_date = date('m/d/y'); $ordernum = $insert_id; $sale_name = $order->customer['lastname'] . ', ' . $order->customer['firstname']; $shipping = $order->info['shipping_cost']; $shipping_cost = $shipping - ($shipping * 2); // MUST BE NEGATIVE NUMBER, SO 'FLIP' IT // Convert transaction amounts from TEP to QB currency, if needed. if (CONVERT_QB_CURRENCY==1) { $shipping = ($shipping * EXCHANGE_RATE); $shipping_cost = ($shipping_cost * EXCHANGE_RATE); $total_tax = ($total_tax * EXCHANGE_RATE); $total_cost = ($total_cost * EXCHANGE_RATE); } // finish setting up our info for the IIF file. $shipping = number_format($shipping, 2, '.', ''); $shipping_cost = number_format($shipping_cost, 2, '.', ''); $total_cost = number_format($total_cost, 2, '.', ''); $transtotal = $cart->show_total() + $shipping; // setup our "ship via" for QB. Change these to match your own needs if (left($order->info['shipping_method'],13) == "United Parcel") { $shipvia="UPS"; } elseif ($HTTP_POST_VARS['shipping_method'] == "I will Pickup my order") { $shipvia="Pickup"; } else { $shipvia = "USPS"; } //$shipvia = $order->info['shipping_method']; // Check if the transaction import file exists; $oldfile = file_exists ($salefile); // Open transaction import file for appending, create it if necessary; $fp = fopen($salefile,"a"); // Create header line & write it to file if the transaction import file did NOT exist previously // This means that everytime you 'import' the file into QB, you must delete it immediately. // This will prevent re-importation AND it will keep the IIF file small. if (!$oldfile) { fputs($fp,$transaction_header); fputs($fp,$distribution_line_header); fputs($fp,$end_header); } //here we need to get the total tax for ($i=0; $i<sizeof($order->products); $i++) { $products_tax = (($order->products[$i]['tax']*.01) * $order->products[$i]['price']); $total_tax = $total_tax + $products_tax; } $transtotal = $transtotal + $total_tax; $total_tax = 0; // Create the IIF transaction data line & write it to the file. $transaction ="TRNSt$ordernumtINVOICEt$order_datet$araccountt$sale_namet"; $transaction.="t$transtotalt$ordernumt"; $transaction.="$memot$clearedt$toprintt$customers_namet"; $transaction.="$customers_street_addresst"; $transaction.="$customers_city,$customers_statet"; $transaction.="$customers_country,$customers_postcodet"; $transaction.="$customers_telephonet"; $transaction.="$paidt$termst$shipviat$salesrept$FOBt$invtitlet$delivery_namet"; $transaction.="$delivery_street_addresst"; $transaction.="$delivery_city,$delivery_statet"; $transaction.="$delivery_country,$delivery_postcodet$customers_telephonetn"; fputs($fp,$transaction); // Now lets add each product to an SPL line $lines=$ordernum; $lines++; for ($i=0; $i<sizeof($order->products); $i++) { $product_name = $order->products[$i]['name']; $product_price = $order->products[$i]['price']; $product_number = $order->products[$i]['model']; $class = $order->products[$i]['class']; $memo = $order->products[$i]['name']; $vendor = $order->products[$i]['vendor']; $qty = $order->products[$i]['qty']; $qty = $qty - ($qty * 2); // MUST BE NEGATIVE NUMBER, SO 'FLIP' IT $total_product_price = ($product_price + $cart->attributes_price($order->products[$i]['id'])); //reinvokeed tax // $product_tax = tep_get_tax_rate($order->products[$i]['tax_class_id'],1,$delivery_values['zone_id']); $products_tax = (($order->products[$i]['tax']*.01) * $order->products[$i]['price']); $total_tax = $total_tax + $products_tax; $attributes_exist = '0'; if ($order->products[$i]['attributes']) { $attributes_exist = '1'; reset($order->products[$i]['attributes']); while (list($option, $value) = each($order->products[$i]['attributes'])) { $attributes = tep_db_query("select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix from products_options popt, products_options_values poval, products_attributes pa where pa.products_id = '" . $order->products[$i]['id'] . "' and pa.options_id = '" . $option . "' and pa.options_id = popt.products_options_id and pa.options_values_id = '" . $value . "' and pa.options_values_id = poval.products_options_values_id"); $attributes_values = tep_db_fetch_array($attributes); // If there are attributes, we'll simply append the values to the item description // on the invoice line $memo.= ' '; $memo.= $attributes_values['products_options_values_name']; $product_price += $attributes_values['options_values_price']; } } if (CONVERT_QB_CURRENCY==1) { $product_price = ($product_price * EXCHANGE_RATE); $total_product_price = ($total_product_price * EXCHANGE_RATE); } $product_price = number_format($product_price, 2, '.', ''); $total_product_price = number_format($total_product_price, 2, '.', ''); //$account = $order->products[$i]['products_qb_sales_account']; $account = $productaccount; $total_product_price = $order->products[$i]['final_price']; // MUST BE NEGATIVE NUMBER, SO 'FLIP' IT // $ItemCost = $total_product_price - ($total_product_price * 2); $ItemCost = $total_product_price * $qty; //$ItemCost = $ItemCost - ($ItemCost * 2); // CHANGE THESE TO SUIT YOUR QB TAX CODES // if ($product_tax == "0.0000") { if ($total_tax == 0) : $taxcode= "N"; $taxcode2 = "Out of State"; $taxpercent = "0%"; $taxdescr = "Out of State"; else: // } elseif ($product_tax == "6.0000") { $taxcode= "Y"; $taxcode2 = "NJ Sales Tax"; $taxpercent = "6%"; $taxdescr = "NJ Sales Tax"; endif; // } else { // $taxcode = "Sales Tax"; // } // Finally, we build the SPL line and write it to the file. // $ItemNo = $vendor . ":" . $product_number; // the Item Number in QB // We use sub-items, grouped by vendor code, // hence this structure. If you just use // item numbers then your line would be // $ItemNo = $product_number; $ItemNo = $product_number; $line ="SPLt$linestINVOICEt$order_datet$accounttt$classt$ItemCostt"; $line.="t$memot$clearedt$qtyt$product_pricet"; $line.="$ItemNot$taxcodetn"; fputs($fp,$line); $lines++; } // Add a "shipping charge" SPL line if there is any shipping charge if ($shipping_cost <> "0.00") { $shipping_line ="SPLt$linestINVOICEt$order_datet$Shipping_Accountt"; $shipping_line.="tt"; $shipping_line.="$shipping_costtt$shipdescriptiont$clearedt-1t$shippingt"; $shipping_line.="$shipitemt$shiptaxcodetn"; fputs($fp,$shipping_line); } // Now lets add the total tax $taxaccount = "Sales Tax Payable"; // the QB 'sales tax' account $taxdescription = "NJ Only"; // for the invoice $lines++; // MUST BE NEGATIVE NUMBER, SO 'FLIP' IT $total_tax = $total_tax - ($total_tax * 2); $tax_line ="SPLt$linestINVOICEt$order_datet$taxaccountt$taxcode2tt$total_taxt"; $tax_line.="$ordernumt$taxdescriptiont$clearedtt$taxpercentt$taxdescrtNtAUTOSTAXn"; fputs($fp,$tax_line); // Add the END OF SPL and END OF TRANSACTION lines and close the file fputs($fp,$end_transaction); fclose($fp); ?>
  7. grbicking

    I've got a trouble

    Teejay let me know if you find out something Mine worked fine until I added more to the cart now it has stopped working with unsupported images, all are jpeg. FPDF error: Unsupported image file type: /images/ don't know why
  8. grbicking

    EasyPopulate 2.3 Released

    Figured it out, removed the catalog from the easypopulate.php file in them temp directory setup.
  9. grbicking

    EasyPopulate 2.3 Released

    Have the problem with the upload mod. Here is the information. It is a WINNT server, iuser has all permissions, also find my admin configure.php Warning: move_uploaded_file(/inetpub/airsoftupgrades/catalog/temp/EP1044936485.txt) [function.move-uploaded-file]: failed to create stream: No such file or directory in C:Inetpubairsoftupgradesadminincludesfunctionsgeneral.php on line 808 Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to move 'C:WINNTTEMPphp18.tmp' to '/inetpub/airsoftupgrades/catalog/temp/EP1044936485.txt' in C:Inetpubairsoftupgradesadminincludesfunctionsgeneral.php on line 808 File uploaded. Temporary filename: C:WINNTTEMPphp18.tmp User filename: EP1044936485.txt Size: 1449 Warning: file(/inetpub/airsoftupgrades/catalog/temp/EP1044936485.txt) [function.file]: failed to create stream: No such file or directory in C:Inetpubairsoftupgradesadmineasypopulate.php on line 621 Warning: Invalid argument supplied for foreach() in C:Inetpubairsoftupgradesadmineasypopulate.php on line 625 Upload complete web files at c:inetpubairsoftupgrades located at http://localhost CONFIGURE.PHP define('HTTP_SERVER', 'http://localhost'); // eg, http://localhost - should not be NULL for productive servers define('HTTPS_SERVER', 'https://'); // eg, https://localhost - should not be NULL for productive servers define('HTTP_CATALOG_SERVER', 'http://localhost/airsoftupgrades'); define('HTTPS_CATALOG_SERVER', 'https://'); define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module define('DIR_FS_DOCUMENT_ROOT', '/inetpub/airsoftupgrades'); // where the pages are located on the server define('DIR_WS_ADMIN', '/admin/'); // absolute path required define('DIR_FS_ADMIN', '/inetpub/airsoftupgrades/admin/'); // absolute pate required define('DIR_WS_CATALOG', '/airsoftupgrades/'); // absolute path required define('DIR_FS_CATALOG', '/inetpub/airsoftupgrades/'); // absolute path required define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/'); define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/'); define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');
  10. My bad, there was a piece of code somebody modified and the page wasn't pointing to your listing.php file. I pointed it to that and it is fine now. Thank you everyone for your help as I learned how to fully use this mod. Great work elari.
  11. for product listing. I added to the product_info page and that works fine. George WHat should I look for in procut listing. should I post a copy of it
  12. Exactly like that. For some reason when I click on a category I don't get the listing looking like that, and I don't have the drop down, I think the drop down is an admin item that has to be turned on though. What I get is all the products 2 to a row with the buy now below the picture and product name. i only have 2 product right now. Am I missing something in the admin. Thank you for your help, it is a great mod and I greatly appreciate everyone's help. George
  13. It is a great mod and works awesome, I have modified the sayings and everything. Everything works excpet on the default page. I wasn't too clear on it I believe. Basically new products, what's new, and even my product details works great. I modded some of those where there was no code. I am having trouble on the product listings. The products are listed when you click a category but the status isn't. I have learned a lot now from the code since starting this project but am having trouble with this las item. My product listing has the picture of the item, not like a list like yours. Could that be why? What should I look at in product)listing to have the status show as the code was there for it but just not showing up. Thanks you have been a great help.!
  14. grbicking

    Support Tickets

    Fixed that by changing to customers_email_address. Now this error. 1146 - Table 'localstore.table_ticket_history' doesn't exist select max(support_history_id) as support_history_id from TABLE_TICKET_HISTORY where ticket_id = '1' [TEP STOP] checking the sql table on this to make sure it is in there.
  15. grbicking

    Support Tickets

    I installed the new support_track.php in catlalog and get the follwoing: 1054 - Unknown column 'support_user_name' in 'field list' select ticket_id, support_user_name, support_user_email from support_tickets where support_user_email = 'AEG' [TEP STOP] Thanks for the help
×