Jump to content


  • Content count

  • Joined

  • Last visited

Everything posted by tkeats

  1. I've managed to muddle my way through most of this, however one part is giving me a hassle. 1. The read me states that I should add this 'products_upc varchar(12) Yes Null' to the database under products. I did this under phpMyAdmin. It seems to be present. 2. I have attempted a number of times to apply the next step to the database with no luck. INSERT INTO configuration VALUES ( '129', 'Display Product UPC', 'PRODUCT_LIST_UPC', '1', 'Do you want to display the product UPC?', '8', '11', '', '', '', ''); All I end up with is this returning.... mysql> INSERT INTO configuration VALUES ( '129', 'Display Product UPC', 'PRODUCT_LIST_UPC', '1', 'Do you want to display the product UPC?', '8', '11', '', '', '', ''); ERROR 1062: Duplicate entry '129' for key 1 mysql> (Yes, I do this via the shell access at the command line) I think I am missing something but unsure what. 3. Everything else seems to be added, I backed up the older files, and replaced them with the included 'php' files in this package. I dont see a UPC feild in the admin section for product additions.. Help? Thomas Keats --+-----------------------------------------------------------------------------+-- Guerrilla Marketing Bombshells. 28 Minutes a month to increasing your sales. http://www.gmktgb.com/pages/tkeats
  2. tkeats

    Customer status version2

    uhm, disregard, posted in wrong thread. :/
  3. tkeats

    Customer status version2

    No shipping available for my country. :/ Thomas Keats
  4. Ok, so I appearently am not even close to being done. I found one other issue.... I am double checking my work here. in catalog/includes/languages/english/default.php <?php /* $Id: default.php,v 1.18 2002/01/14 10:34:17 jan0815 Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2002 osCommerce Released under the GNU General Public License */ define('TEXT_MAIN', 'This is a demonstration online-shop, <b>any products purchased will not be delivered nor billed</b>. An$ define('TABLE_HEADING_NEW_PRODUCTS', 'New Products For %s'); define('TABLE_HEADING_UPCOMING_PRODUCTS', 'Upcoming Products'); define('TABLE_HEADING_DATE_EXPECTED', 'Date Expected'); if ($category_depth == 'products' || $HTTP_GET_VARS['manufacturers_id']) { define('HEADING_TITLE', 'Let's See What We Have Here'); define('TABLE_HEADING_IMAGE', ''); define('TABLE_HEADING_MODEL', 'Model'); define('TABLE_HEADING_PRODUCTS', 'Product Name'); // Added for UPC SKU on 11.26.2002 // define('PRODUCT_LIST_UPC' => PRODUCT_LIST_UPC, /*added 3/17/02 for upc*/ // End Mods // define('TABLE_HEADING_MANUFACTURER', 'Manufacturer'); define('TABLE_HEADING_QUANTITY', 'Quantity'); define('TABLE_HEADING_PRICE', 'Price'); define('TABLE_HEADING_WEIGHT', 'Weight'); define('TABLE_HEADING_BUY_NOW', 'Buy Now'); define('TEXT_NO_PRODUCTS', 'There are no products to list in this category.'); define('TEXT_NO_PRODUCTS2', 'There is no product available from this manufacturer.'); define('TEXT_NUMBER_OF_PRODUCTS', 'Number of Products: '); define('TEXT_SHOW', '<b>Show:</b>'); define('TEXT_BUY', 'Buy 1 ''); define('TEXT_NOW', '' now'); define('TEXT_ALL', 'All'); } elseif ($category_depth == 'top') { define('HEADING_TITLE', 'What's New Here?'); } elseif ($category_depth == 'nested') { define('HEADING_TITLE', 'Categories'); } ?> After applying this, I get an error on the main page. Parse error: parse error in /home/www/test.rainbowcomputers.ca/htdocs/catalog/includes/languages/english/default.php on line 24 Please note, that the information for modifying this file states this I simply want to know if I did this part right. (I have experience in some php, but never really delved into databases) Further, this is the last part of the modification instructions and I have NO CLUE where to put it. I assume as it claims no file, that it is the same as the above default.php, but there are no 'case' instructions in it. I would like very much to have this modification completed today so I can keep on schedule (or damn close). Any help would be very much appreciated. Thomas Keats
  5. I am preparing to use the UPC/SKU contribution with my OSC 2.2 which I downloaded and installed (around) Monday 16 September, 2002. I have already added the 'IP Address' contribution, and I noticed that part of the basic OCS was re-writen. Has anyone had problems running these two contributions side by side? I want to record the IP address to track customers for security. I want to manage my own UPC/SKU's so I can keep track of which supplier I used for which product (presently managing approx 10 distributors in one database) and thought it would make life so much easier if I could tell on each product update and/or customer purchase who I determined was the lessor price, best quality.... any help would be appreciated. :lol: Thomas Keats --> http://test.rainbowcomputersystems.com/catalog/ is the site (I've slowly been rebuilding from scratch after a couple problems I had). Guerrilla Marketing Bombshells. 28 Minutes a month to increasing your sales. http://www.gmktgb.com/pages/tkeats
  6. I was at qhex.com today, and got signed up for ther merchant account, but then it directed me towards suncash to accept credit cards. Does anyone have, or is workign on a module for this before I setup an account with them? I would prefer for all this to be automated. (Perhaps even email/IM me on my mobile device so I know there was an order..)