Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

andes1

Pioneers
  • Posts

    175
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by andes1

  1. Thanks, i'm going to check that this weekend.
  2. hello For example: if you have a flower shop... you want to sell your product for occasion (anniversary, love, congratulations etc) also you want to sell your product by price in addition to categories (roses, gerberas, sunflowers etc). Another example; on a hypothetic perfumes and aromas store. Categories: Bath Night perfume Day perfume Teens Kids Lotions Body lotions Accessories etc MANUFACTURERS: Carolina Herrera DOLCE GAVANA VERSACHE NAUTICA FOR HIM OR HER: ...... ( MANUFACTURERS2; you can change the literature on languages files) For Him For Her ALSO IF YOUR PRODUCT IS MAKEN FOR 2 manufacturers; eje; pc Dell 3000 with Intel processor.so the costumer can select products Dell or products Intel. Well.... I had described only a few examples. You can use it to fit your particular needs. :thumbsup:
  3. I just uploaded. Really this contribution had been really buggy… and incomplete… I’ll try to make this contribution works, after that, I going to upload it to test on vanilla installation (this is the current step)… and to check for bugs… next I will make the long, long… install instructions manual. Any help will be welcome due to my lack of time. :blush: :rolleyes: The concept is simple; you should to consider that Manufacturers is a module or contribution, from here, the idea is to make a twin contribution; that’s it. You can use this twin for multiple purposes: Prices and range of prices, gifs for him or her, buy for occasion (anniversary, new child born), buy by authors, buy clothes for summer winter etc. For now only run the sql command on your database, and upload to your site the files and folders provided… if you have a modified store use wincompare. For your particular needs, you can change the literature on languages files. And remember backup, backup, backup. besos dont forget: run the sql command or file attached, on your phpmyadmin (nice feature on your host)
  4. I believe that this contribution and the support has been a very good option to the other ccgv contribution which is really an “apache” (patch, patch, patch). Thanks for you time and effort. In my humble opinion you should not withdrew from the contribution due to the fact that few people did not understand the spirit and method to maintain a bug free and clean contribution… as analogy the same situation could be pictured when you go to Bahamas and the taxi driver was rude with you… and you said I wont come back to Bahamas because the people here are rude… think about it. Anyway thanks… I’ll check your new support site
  5. Ok there is a problem but easy (humm more less) to solve it; first this issue is due to your domain is sending, a duplicated id numbers: i.e. you have your real site and you are on an order number 100, also you begin a test store under your domain and your test store reach the order number 105. the problem beings when you make an order in your live site, for example order number 102, paypal shows that this order is already paid (your test site processed this order already). The solution is modifying the order number on your database on orders table, (exist a manual about how to modify it). For example set up an order number 500; In addition make some transactions beginning from the new order id, in that way your orders will continue 501, 502, and 503 and so on. Avoiding duplicate order numbers against another store. Note: you can make transaction using cash on delivery mean while you reach the order number necessary. Or you can make transaction using: REPLACE CODE if (isset($_POST['invoice']) && is_numeric($_POST['invoice']) && ($_POST['invoice'] > 0)) { WITH CODE if (isset($_POST['invoice']) && is_numeric($_POST['invoice'])) { $invoice_id =substr($_POST['invoice'], strpos($_POST['invoice'], '-')+1);
  6. "When the buyer clicks on the 'Confirm Order' button on my site and goes over to Paypal it lists the store name underneath the 'Payment For' title in the table." I belive that this a paypal issue very weird... try to set up your ipn paypal module in the falowing way Transaction Type Per Item not agregate.... and let me know but I not sure if this fix the mail confirmation too
  7. ok problem solved missing argument is because it is waiting for 3 parameters, but only it is geeting 2... so to fix that, you have to add after a generic expression (wherever you find it, trouth in this case product_info.php) display_price( wherever you find that the falowing: $product_info['products_id'], imediatly fallowed by the anothesr tow parmeters. for example: $products_price_slave = $currencies->display_price($product_info['products_id'], $new_price, tep_get_tax_rate($attributes_values['products_tax_class_id'])); :)
  8. I Have the same problem Warning: Missing argument 3 for display_price() in /home/andinos/public_html/store/includes/classes/currencies.php on line 72 I red this tread but I could not fin any solution. Can somebody who already fixed this issue, give us some solution Thanks.
  9. Virtual Unique Products (PIN & Phonecard selling) Version 0.6 alpha ? 2005 <email address removed - bluenotemkvi> Work in progress, not for production use!!! ########### 0.6 * Bugfixes in checkout_process.php and admin area. + Now correctly works if customer buys 2 or more PINs. 0.5. Initial release. #############UPDATING################# Overwrite pin_loader.php with new one. Make to changes marked (UPD) below. ############# INSTALLATION ############## Set following options in admin area: Configuration - Download - Enable Download "true" Configuration - Stock - Check stock level "true" Configuration - Stock - Substract Stock "true" Configuration - Stock - Allow checkout "false" #FILE /admin/includes/database_tables.php #AND #FILE /includes/database_tables.php #ADD BEFORE closing ?> //PIN add define('TABLE_PRODUCTS_PINS', 'products_pins'); #FILE /admin/includes/filenames.php #ADD BEFORE closing ?> //PIN add define('FILENAME_PIN_LOADER', 'pin_loader.php'); #FILE /admin/includes/boxes/catalog.php (or where you want to) #FIND '<a href="' . tep_href_link(FILENAME_SPECIALS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CATALOG_SPECIALS . '</a><br>' . #ADD AFTER //PIN add '<a href="' . tep_href_link(FILENAME_PIN_LOADER, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CATALOG_PIN_LOADER . '</a><br>'. !!! If you have clean MS2 installation - you can copy files from "overwrite" folder !!! and jump to DATABASE OPERATIONS section. !!! Else copy files from /admin folder to your /admin folder and process everything below. #FILE /admin/products_attributes.php #FIND (~68) $products_attributes_filename = tep_db_prepare_input($HTTP_POST_VARS['products_attributes_filename']); $products_attributes_maxdays = tep_db_prepare_input($HTTP_POST_VARS['products_attributes_maxdays']); $products_attributes_maxcount = tep_db_prepare_input($HTTP_POST_VARS['products_attributes_maxcount']); #ADD AFTER //PIN add $products_attributes_is_pin = isset($HTTP_POST_VARS['products_attributes_is_pin'])?1:0; //PIN end #FIND (next lines usually) if (tep_not_null($products_attributes_filename)) { tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " values (" . (int)$products_attributes_id . ", '" . tep_db_input($products_attributes_filename) . "', '" . tep_db_input($products_attributes_maxdays) . "', '" . tep_db_input($products_attributes_maxcount) . "')"); #CHANGE TO //PIN change if (tep_not_null($products_attributes_filename) || $products_attributes_is_pin) { tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " values (" . (int)$products_attributes_id . ", '" . tep_db_input($products_attributes_filename) . "', '" . tep_db_input($products_attributes_maxdays) . "', '" . tep_db_input($products_attributes_maxcount) . "', '$products_attributes_is_pin')"); #FIND (~120) $products_attributes_maxcount = tep_db_prepare_input($HTTP_POST_VARS['products_attributes_maxcount']); #ADD AFTER //PIN add $products_attributes_is_pin = isset($HTTP_POST_VARS['products_attributes_is_pin'])?1:0; //PIN end #FIND (next lines again) if (tep_not_null($products_attributes_filename)) { tep_db_query("replace into " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " set products_attributes_id = '" . (int)$attribute_id . "', products_attributes_filename = '" . tep_db_input($products_attributes_filename) . "', products_attributes_maxdays = '" . tep_db_input($products_attributes_maxdays) . "', products_attributes_maxcount = '" . tep_db_input($products_attributes_maxcount) . "'"); #CHANGE TO //PIN change if (tep_not_null($products_attributes_filename) || $products_attributes_is_pin) { tep_db_query("replace into " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " set products_attributes_id = '" . (int)$attribute_id . "', products_attributes_filename = '" . tep_db_input($products_attributes_filename) . "', products_attributes_maxdays = '" . tep_db_input($products_attributes_maxdays) . "', products_attributes_maxcount = '" . tep_db_input($products_attributes_maxcount) . "', products_attributes_is_pin='$products_attributes_is_pin'"); #FIND (~758) if (tep_db_num_rows($download_query) > 0) { $download = tep_db_fetch_array($download_query); $products_attributes_filename = $download['products_attributes_filename']; $products_attributes_maxdays = $download['products_attributes_maxdays']; $products_attributes_maxcount = $download['products_attributes_maxcount']; #ADD AFTER //PIN add $products_attributes_is_pin = $download['products_attributes_is_pin']; //PIN end #FIND (~780) <td class="smallText"><?php echo tep_draw_input_field('products_attributes_maxcount', $products_attributes_maxcount, 'size="5"'); ?> </td> #ADD AFTER <!-- //PIN add --> <td class="smallText"><?php echo TABLE_TEXT_IS_PIN; ?></td> <td class="smallText"><?php echo tep_draw_checkbox_field('products_attributes_is_pin', '', $products_attributes_is_pin,1); ?> </td> <!-- //PIN end --> #FIND (~871) <td class="smallText"><?php echo tep_draw_input_field('products_attributes_maxcount', $products_attributes_maxcount, 'size="5"'); ?> </td> #ADD AFTER <!-- //PIN add --> <td class="smallText"><?php echo TABLE_TEXT_IS_PIN; ?></td> <td class="smallText"><?php echo tep_draw_checkbox_field('products_attributes_is_pin', '', $products_attributes_is_pin,1); ?> </td> <!-- //PIN end --> #FILE /checkout_process.php #FIND (~125) $stock_query_raw = "SELECT products_quantity, pad.products_attributes_filename #CHANGE TO //PIN change $stock_query_raw = "SELECT products_quantity, pad.products_attributes_filename, pad.products_attributes_is_pin #FIND (~146) if ((DOWNLOAD_ENABLED != 'true') || (!$stock_values['products_attributes_filename'])) { #CHANGE TO //PIN change if ((DOWNLOAD_ENABLED != 'true') || (!$stock_values['products_attributes_filename']) || ($stock_values['products_attributes_is_pin']==1) ) { #FIND (~180) $attributes_query = "select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix, pad.products_attributes_maxdays, pad.products_attributes_maxcount , pad.products_attributes_filename #CHANGE TO //PIN change $attributes_query = "select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix, pad.products_attributes_maxdays, pad.products_attributes_maxcount , pad.products_attributes_filename, pad.products_attributes_is_pin #FIND (~206) if ((DOWNLOAD_ENABLED == 'true') && isset($attributes_values['products_attributes_filename']) && tep_not_null($attributes_values['products_attributes_filename'])) { #CHANGE TO //PIN change if ((DOWNLOAD_ENABLED == 'true') && ((isset($attributes_values['products_attributes_filename']) && tep_not_null($attributes_values['products_attributes_filename'])) or $attributes_values['products_attributes_is_pin'])) { #(UPD) ADD AFTER //PIN add for($pincycle=0;$pincycle<$order->products[$i]['qty'];$pincycle++) { if($attributes_values['products_attributes_is_pin']) { $pin_query=tep_db_query("SELECT products_pin_id, products_pin_code FROM ".TABLE_PRODUCTS_PINS." WHERE products_id = '".$order->products[$i]['id']."' AND products_pin_used='0' LIMIT 1"); if(tep_db_num_rows($pin_query)=='0') { // We have no PIN for this product // insert some error notifying here $pin=PIN_NOT_AVAILABLE; } else { $pin_res=tep_db_fetch_array($pin_query); $pin=$pin_res['products_pin_code']; tep_db_query("UPDATE ".TABLE_PRODUCTS_PINS." SET products_pin_used='".$insert_id."' WHERE products_pin_id = '".$pin_res['products_pin_id']."'"); } } //PIN #FIND (~226) 'download_count' => $attributes_values['products_attributes_maxcount']); #CHANGE TO 'download_count' => $attributes_values['products_attributes_maxcount'], 'download_is_pin' => $attributes_values['products_attributes_is_pin'], 'download_pin_code' => $pin ); #FIND (next line) tep_db_perform(TABLE_ORDERS_PRODUCTS_DOWNLOAD, $sql_data_array); #(UPD) ADD AFTER } #FILE /includes/modules/downloads.php #FIND (~25) $downloads_query = tep_db_query("select date_format(o.date_purchased, '%Y-%m-%d') as date_purchased_day, opd.download_maxdays, op.products_name, opd.orders_products_download_id, opd.orders_products_filename, opd.download_count, opd.download_maxdays from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " opd where o.customers_id = '" . (int)$customer_id . "' and o.orders_id = '" . (int)$last_order . "' and o.orders_id = op.orders_id and op.orders_products_id = opd.orders_products_id and opd.orders_products_filename != ''"); #CHANGE TO $downloads_query = tep_db_query("select date_format(o.date_purchased, '%Y-%m-%d') as date_purchased_day, opd.download_maxdays, op.products_name, opd.orders_products_download_id, opd.orders_products_filename, opd.download_count, opd.download_maxdays, opd.download_pin_code,opd.download_is_pin from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " opd where o.customers_id = '" . (int)$customer_id . "' and o.orders_id = '" . (int)$last_order . "' and o.orders_id = op.orders_id and op.orders_products_id = opd.orders_products_id and (opd.orders_products_filename != '' or opd.download_is_pin='1') and o.orders_status>='".DOWNLOADS_AVAILABLE_STATUS."'"); #FIND (~51) // The link will appear only if: // - Download remaining count is > 0, AND #ADD BEFORE //PIN add if ($downloads['download_is_pin']==1) { //PIN processing $pinstring=$downloads['download_pin_code']; echo '<td class="main">'.$downloads['products_name'].'</td><td class="main">'.$pinstring.'</td><td class="main"> </td>'; } else { //usual stuff #FIND (~74) $downloads['download_count'] . TABLE_HEADING_DOWNLOAD_COUNT . '</td>' . "\n" . ' </tr>' . "\n"; } #ADD AFTER } #DATABASE OPERATIONS INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (NULL, 'PIN Show status', 'DOWNLOADS_AVAILABLE_STATUS', '2', 'Order must have this or better status', 13, 4, NULL, NOW(), NULL, ''); ALTER TABLE `products_attributes_download` ADD `products_attributes_is_pin` TINYINT( 1 ) NULL DEFAULT '0'; ALTER TABLE `orders_products_download` ADD `download_is_pin` TINYINT( 1 ) NULL DEFAULT '0', ADD `download_pin_code` VARCHAR( 250 ) NULL ; CREATE TABLE products_pins ( products_pin_id int(11) NOT NULL auto_increment, products_id int(11) NOT NULL, products_pin_code char(250) NOT NULL, products_pin_used tinyint(4) NOT NULL default '0', PRIMARY KEY (products_pin_id) ) #LANGUAGE CONSTANTS #ADMIN AREA define('TABLE_TEXT_IS_PIN','Is PIN code'); define('BOX_CATALOG_PIN_LOADER','PIN loader'); #CUSTOMER AREA define('PIN_NOT_AVAILABLE', 'Products out of stock during checkout. Personnel notified.'); that were the instruccions... i know the text on word path is a little weird to read edit - removed email address by request - bluenotemkvi
  10. sorry i mean I use to sell gifts to people who live in other ... instead "I use to buy gifts to people who live in other..."
  11. Hello :'( I have a problem whit my paypal service: I use to buy gifts to people who live in other countries different than his own country. Also these gifts are delivered to their parents in his maternal country. For example Bolivian people who lives in the UK, and want to send a gift to his mother in Bolivia. I have the oscommerce team?s ipn for paypal. But there in the payment page of paypal appear the following: ?Your purchase will be shipped to this address.? (The same address that have to match whit the credit card holder address) A lot of costumers just run away because of that. I don?t know how to do to fix that situation: I have thought: 1. Avoid Products Weight just like as a download. 2. Set up a pop up explaining the situation and asking to ignore the ?Your purchase will be shipped to this address.? because you already filled your shipping information. 3. Avoid the use of the ipn and use again the traditional system that give you the option of choose. Shipping is not required. Shipping Required? Shipping is not required. (e.g. online download, gift certificate, payment for a service, etc.) Shipping is required. (Please enter address below.) Can you give me some advises for this concern. Thanks :rolleyes:
  12. Hello Maybe I don't understand how to install the contribution. I have fallowed all the instruccions, but I have been geting some troubles: In my first attempt I got the fallowing error: 1054 - Unknown column 'attribute_sort' in 'field list' select attribute_sort from products_attributes where products_attributes_id = '36' [TEP STOP] Ok Maybe I should try firs in a clean store I did so At this try everything works well in administration module But in the real store I have gotten the fallowing; Warning: main(includes/html_title.php): failed to open stream: No such file or directory in /home2/conocera/public_html/stores/product_info.php on line 24 Fatal error: main(): Failed opening required 'includes/html_title.php' (include_path='.:/home2/conocera/public_html:/usr/local/lib/php') in /home2/conocera/public_html/stores/product_info.php on line 24 Looking for the file html_title.php that was mentioned in product_info.php line 24 <?php require(DIR_WS_INCLUDES . 'html_title.php'); ?> I could not find it. SIMPLY SUCH FILE , html_title.php, does exist in a clean store. well Can somebody help me or light me.
  13. I have been falowing all the steps described in the instructions, but when I try to check the funtionality of the contribution I have gotten the falowing error: Warning: main(includes/functions/scrambled_order_num.php): failed to open stream: No such file or directory in /home/andesflo/public_html/tienda2/checkout_process.php on line 36 Fatal error: main(): Failed opening required 'includes/functions/scrambled_order_num.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/andesflo/public_html/tienda2/checkout_process.php on line 36 i don't know where is the mistake. the instruccions are: ".../catalog/checkout_process.php -------------- * Near the top of the file, just above... include(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CHECKOUT_PROCESS); ...add the following... // >>> BEGIN SCRAMBLED_ORDER_NUMBER require('includes/functions/scrambled_order_num.php'); // <<< END SCRAMBLED_ORDER_NUMBER -------------- * Approx line 222 (hint - search for 'STORE_NAME'). Change this... // lets start with the email confirmation $email_order = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $insert_id . "\n" . EMAIL_TEXT_INVOICE_URL . ' ' . tep_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'order_id=' . $insert_id, 'SSL', false) . "\n" . ...to this... // lets start with the email confirmation // >>> BEGIN SCRAMBLED_ORDER_NUMBER $scrambled_order_num = randomise_order_num($insert_id); // <<< END SCRAMBLED_ORDER_NUMBER $email_order = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . // >>> BEGIN SCRAMBLED_ORDER_NUMBER EMAIL_TEXT_ORDER_NUMBER . ' ' . $scrambled_order_num . "\n" . EMAIL_TEXT_INVOICE_URL . ' ' . tep_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'order_id=' . $scrambled_order_num, 'SSL', false) . "\n" . // <<< END SCRAMBLED_ORDER_NUMBER welll..... thank you
×
×
  • Create New...